A 13-week cash flow forecast gives a small business an early warning system for cash shortages, delayed customer payments, and unusually large expenses. This guide explains how to build a repeatable cash flow planning spreadsheet, choose realistic timing assumptions, apply rolling-balance formulas, test scenarios, and review the forecast each week before making hiring, purchasing, or payment decisions.
Overview
Profit and cash are not the same thing. A business can record sales and still lack enough money in its bank account to cover payroll, suppliers, tax obligations, software subscriptions, or other commitments when they fall due. The timing gap between issuing an invoice and receiving payment is often the reason.
A 13-week cash flow forecast focuses on that timing. It lists expected cash coming in and going out by week, then calculates the projected closing balance. The forecast is not intended to predict revenue perfectly. Its purpose is to answer practical questions:
- How much cash is likely to be available at the end of each week?
- Which weeks contain a potential shortfall?
- What happens if a major customer pays late?
- Can the business afford a planned purchase, hire, or owner draw?
- How much cash should be set aside for payroll, tax, or other reserved obligations?
Use the forecast as a decision tool, not as a substitute for accounting records. Your accounting system shows what has happened and how transactions should be classified. The forecast estimates what may happen next and makes assumptions visible.
For related planning, compare this forecast with a break-even analysis. Break-even helps assess sales requirements; a cash flow forecast helps assess payment timing and available funds.
How to estimate
Set up one column for each of the next 13 weeks. Use a consistent week-ending date, such as Friday or Sunday, and keep the same date convention every time you update the file.
Start with this basic cash flow forecast formula:
Closing cash balance = Opening cash balance + Total cash receipts − Total cash payments
For the next week, the closing balance becomes the opening balance:
Next week’s opening balance = Previous week’s closing balance
A practical spreadsheet layout might include these rows:
| Forecast row | What to enter |
|---|---|
| Opening cash balance | Cash available at the start of the week |
| Customer receipts | Payments expected to arrive during the week |
| Other receipts | Loans, grants, refunds, owner funding, or asset sales if applicable |
| Total receipts | All expected cash inflows added together |
| Payroll and contractor payments | Amounts expected to leave the account that week |
| Supplier and operating payments | Materials, rent, software, insurance, utilities, and other costs |
| Tax and reserved payments | Amounts scheduled or deliberately reserved for tax and similar obligations |
| One-off payments | Equipment, repairs, annual renewals, deposits, or professional fees |
| Total payments | All expected cash outflows added together |
| Net cash movement | Total receipts minus total payments |
| Closing cash balance | Opening balance plus net cash movement |
In spreadsheet terms, if receipts are in cell B8 and payments are in B15, the net movement can be written as =B8-B15. If the opening balance is in B3, the closing balance can be =B3+B16. In the following week, link the opening balance to the prior week’s closing balance, for example =B17. The exact row numbers do not matter; consistent structure does.
Separate confirmed receipts from estimates. A useful approach is to add a confidence or status column with labels such as “received,” “scheduled,” “expected,” and “uncertain.” You can then create a conservative view that excludes uncertain receipts or moves them to a later week.
Inputs and assumptions
Opening balance
Use the actual available bank balance at the forecast start date, then adjust for transactions that have already been initiated but have not cleared. Do not include money that is restricted, already committed, or held in a separate account unless it is genuinely available for the decision being considered.
Accounts-receivable timing
List each significant expected customer receipt separately rather than entering one optimistic sales total. For every invoice, record:
- Customer or invoice reference
- Invoice amount expected to reach the bank account
- Invoice date and contractual due date
- Expected payment week
- Confidence level based on payment history or current communication
Use expected bank receipt dates, not simply invoice dates. If a customer normally pays several days after the due date, reflect that pattern in the forecast. If payment timing is unknown, create a conservative version that delays the receipt rather than placing it in the earliest possible week.
Recurring expenses
Build a recurring-expense schedule for rent, payroll, contractor fees, software, insurance, loan repayments, utilities, and subscriptions. Record the actual payment week and amount where known. Annual or irregular costs should be added to the week in which payment is likely, even if the expense is not incurred evenly each month.
Keep a separate list of planned but nonessential spending. This makes it easier to test whether delaying a purchase would protect the cash balance without mixing discretionary decisions into unavoidable commitments. A software cost audit can help identify renewals that need to be included in the forecast.
Tax, payroll, and reserves
Track tax and payroll-related cash separately from general operating expenses. The correct amounts and payment dates depend on your location, business structure, payroll arrangements, and filing schedule, so confirm them against your own records and professional advice where needed. If an amount has been collected or set aside for a specific obligation, do not treat it as freely available working cash.
Scenario assumptions
At minimum, maintain three views:
- Expected case: Your best current estimate of receipts and payments.
- Conservative case: Selected receipts arrive later and selected costs are higher.
- Decision case: The expected case after a proposed hire, purchase, loan payment, or other change.
Make the changes explicit. For example, delay one customer receipt by two weeks, increase a planned repair by a chosen contingency amount, or add a new monthly payroll commitment. Avoid applying an arbitrary percentage to every line when only one or two assumptions are uncertain.
Worked examples
Imagine a business begins week one with an available cash balance of $18,000. It expects $9,500 in customer receipts and $11,200 in payments, including payroll, suppliers, software, and a scheduled tax payment.
The calculation is:
- Opening balance: $18,000
- Receipts: $9,500
- Payments: $11,200
- Net cash movement: $9,500 − $11,200 = −$1,700
- Closing balance: $18,000 − $1,700 = $16,300
In week two, the opening balance is $16,300. If receipts are expected to be $6,000 and payments are $14,500, the closing balance becomes $7,800. That result may be manageable, but it deserves review if the conservative case shows a lower balance or if another large payment is due in week three.
Now test a delayed-payment scenario. Suppose a $7,000 customer receipt currently scheduled for week two moves to week four. Week two’s closing balance falls from $7,800 to $800. The total expected cash over the 13-week period has not changed, but the timing has created a short-term risk. Possible responses could include following up on the invoice, rescheduling a discretionary purchase, negotiating supplier timing, or arranging funding before the shortage becomes urgent.
Test unexpected costs separately. If a $3,000 repair is added to week five, reduce that week’s projected closing balance by $3,000. If the balance becomes negative, the spreadsheet has identified a funding or scheduling decision. Do not hide the problem by moving the cost to a later week without a reasonable basis.
For invoice collection discipline, pair the forecast with an invoice workflow and payment follow-up checklist. The forecast shows which receipts matter; the workflow assigns the follow-up action and owner.
When to recalculate
Review the 13-week cash flow forecast at least once each week. Replace the oldest completed week with a new week so the model always looks 13 weeks ahead. During the review:
- Enter actual receipts and payments, using the bank account as the source of truth.
- Compare actual amounts and dates with the previous forecast.
- Move unpaid invoices to a realistic expected payment week.
- Update recurring costs, new commitments, and one-off expenses.
- Recalculate expected, conservative, and decision scenarios.
- Highlight the lowest projected closing balance and its week.
- Assign an action for every material risk, with an owner and due date.
Recalculate immediately when pricing inputs change, a major customer changes payment timing, payroll changes, a large contract is won or lost, a loan or lease is added, or an unexpected cost appears. Refresh the forecast before approving a large purchase, hiring, owner withdrawal, or new subscription.
Keep a dated copy of each review or use a change log. Comparing forecast versus reality over time will reveal whether receipts are routinely late, expenses are understated, or certain costs are consistently omitted. The model becomes more useful as those assumptions improve.
A cash flow forecast does not need to be elaborate to be effective. Start with the bank balance, realistic receipt dates, known payment dates, and a rolling formula. Review it on a fixed weekly schedule, test the assumptions that could change the result, and act while there is still time to choose among several options.