To build a 13-week cash flow forecast, start with your actual cash balance, then list expected receipts and expected payments for each of the next 13 weeks, adding and subtracting from a running balance as you go. The result shows exactly which week, if any, your cash position is projected to dip — often weeks before it would actually happen. It's the single most useful early-warning tool a small business can build without specialized software.
Key takeaways
- A 13-week cash flow forecast lists expected receipts and payments by week, starting from your actual current cash balance.
- Thirteen weeks (roughly one quarter) is long enough to catch a shortfall coming, and short enough that your estimates stay realistic.
- A forecast answers a different question than a budget: not "will this be profitable" but "will there be enough cash on hand, when."
- The running weekly balance — not any single week's number — is what tells you whether a shortfall is coming.
- It's a rolling exercise: update it weekly, dropping the week that just passed and adding a new week 13 out.
A forecast is not a budget
A budget plans expected income and expenses over a period, usually a year, without much regard to exact timing. A cash flow forecast is specifically about timing — when cash is expected to actually move in and out, week by week, which is what determines whether bills can be paid on time. A business can have an accurate annual budget and still get blindsided by a cash-poor week that the budget never broke out on its own.
The two work together: the budget says what the year should look like in total; the forecast says whether the cash to get there arrives in the right order.
What you need before you start
Three things, all of which should already exist if daily records are current:
- Your actual cash balance today. Not a rounded estimate — the real number, ideally freshly reconciled against the bank using your latest e-statement.
- A list of expected receipts, with realistic dates: open customer invoices and when they're actually likely to be paid (not just when they're due), plus any other expected income.
- A list of expected payments, with dates: rent, payroll, loan instalments, supplier bills, and anything else leaving the account in the period.
All three depend on the same underlying discipline: transactions that are recorded the same day they happen rather than batched, so the lists you're forecasting from are actually current.
The step-by-step framework
- Start with today's actual cash balance. This is week zero — everything else builds forward from this one real number.
- List expected receipts for each of the next 13 weeks. Pull from open invoices and their realistic payment dates, plus any other income you're confident about. Be conservative with anything uncertain — a customer who usually pays late should be forecast late, not on time.
- List expected payments for each week. Rent, payroll, loan payments, and supplier bills are usually the most predictable — they have fixed or contractual dates. Add anything variable (a planned purchase, a tax payment) in the week it's actually expected to leave the account.
- Calculate the net for each week — receipts minus payments — and carry it into a running balance, starting from today's actual cash.
- Scan the running balance for any week that dips low or goes negative. That's the forecast doing its job: telling you which specific week needs attention, and how much notice you have to act on it.
- Roll the forecast forward every week. Drop the week that just passed, add a new week 13 weeks out, and update the receipts and payments you now know more about. A forecast built once and left alone goes stale fast.
A worked example
Palmetto Wholesale Supply starts its forecast with an actual cash balance of $12,000.
| Week | Cash in | Cash out | Ending balance |
|---|---|---|---|
| 1 | $8,000 | $9,500 | $10,500 |
| 2 | $6,000 | $9,500 | $7,000 |
| 3 | $15,000 | $9,500 | $12,500 |
| 4 | $6,000 | $9,500 | $9,000 |
| 5 | $4,000 | $13,500 | −$500 |
Weeks 1, 2, and 4 show routine dips as regular payroll and supplier payments go out against ordinary sales collections. Week 3 recovers on a large customer payment that was already expected. Week 5 is the one that matters: a quarterly tax payment pushes cash out to $13,500 against only $4,000 expected in, taking the running balance negative.
Nothing about week 5 was unpredictable — the tax payment date and amount were both already known. The forecast's only job was putting it on the same timeline as everything else, four weeks before it happened, instead of five days before.
A forecasted shortfall a month out is a solvable problem: delay a discretionary purchase, follow up on a receivable early, or arrange short-term financing ahead of time. The same shortfall discovered the week it happens is a crisis. The entire value of forecasting is moving the discovery earlier.
Keeping the forecast honest
A forecast is only useful if its numbers are realistic, not hopeful. A few habits keep it that way:
- Forecast receivables by when a customer is likely to actually pay, based on their history, not the invoice due date.
- Round payments up and receipts down when genuinely uncertain — a forecast that's slightly too cautious is far less costly than one that's slightly too optimistic.
- Revisit it weekly rather than monthly. A month is long enough for several assumptions to go stale at once.
How aggressively to keep it updated is partly a volume question — a business already reconciling its bank account weekly has most of the raw numbers on hand to refresh the forecast at the same time.
A 13-week forecast is only as good as the receipts and payments you can actually predict, and that's where Reyuko's existing records help. The Receivable list (Payment → Receivable) shows every open customer invoice with aging computed live from its due date, so pulling next week's realistic expected collections is a matter of reading the list rather than guessing.
On the payments side, Recurring purchase templates and payment terms with a fixed due date (delivery date plus grace period) mean regular supplier bills and instalments show up with a known date instead of a rough estimate. The Calendar also surfaces every upcoming receivable and payable, color-coded, which is a quick way to sanity-check a week's forecasted figures against what's actually on file.
There's no dedicated 13-week forecasting tool — you're still building the week-by-week forecast yourself — but the receivables, due dates, and recurring commitments it draws from are live figures, not something reconstructed by hand. These features are part of Reyuko's free plan.
Build your own 13-week starting point
Show the setup steps
- Write down today's actual, reconciled cash balance.
- List every open customer invoice with a realistic (not just contractual) expected payment date.
- List every known upcoming payment — rent, payroll, loans, recurring supplier bills — with its date.
- Spread both lists across 13 weekly columns.
- Calculate each week's net and running balance.
- Circle the first week the balance dips below your comfort level. That's the week to plan around now.
A forecast is the forward-looking half of cash flow discipline; the everyday habits that keep profit and cash from drifting apart are the daily half it depends on for accurate inputs.
Reyuko