Module 03 · Everyday Digital Record-Keeping

How to Build a Simple Cash Flow Forecast

Thirteen weeks is long enough to see a shortfall coming and short enough that your guesses about it are still reasonable.

5 min readLesson 9 of 13 in this moduleUpdated 2026-08-25

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

  1. Start with today's actual cash balance. This is week zero — everything else builds forward from this one real number.
  2. 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.
  3. 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.
  4. Calculate the net for each week — receipts minus payments — and carry it into a running balance, starting from today's actual cash.
  5. 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.
  6. 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.

What to do with a projected dip

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.

Doing this in Reyuko

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
  1. Write down today's actual, reconciled cash balance.
  2. List every open customer invoice with a realistic (not just contractual) expected payment date.
  3. List every known upcoming payment — rent, payroll, loans, recurring supplier bills — with its date.
  4. Spread both lists across 13 weekly columns.
  5. Calculate each week's net and running balance.
  6. 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.

Frequently asked questions

What is a 13 week cash flow forecast?

A 13-week cash flow forecast is a rolling projection covering roughly one quarter, broken into weekly columns, that lists expected cash coming in and going out. It's short enough to stay accurate and long enough to spot a cash shortfall coming weeks before it actually happens.

How do you create a simple cash flow forecast?

Start with your current cash balance, list expected receipts, like customer payments and other income, and expected payments, like rent, payroll, and suppliers, for each upcoming week. Add receipts and subtract payments from the running balance to see your projected cash position week by week.

What's the difference between a cash flow forecast and 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, showing when cash is expected to actually move in and out week by week, which is what determines whether bills can be paid on time.

How far ahead should a small business forecast cash flow?

Thirteen weeks, roughly one quarter, is the most common horizon because it's far enough ahead to catch a shortfall before it happens, but close enough that the underlying assumptions, like which customers will actually pay, stay reasonably reliable. Forecasting further out becomes increasingly speculative.

What data do you need to build a cash flow forecast?

You need your current cash balance, a list of expected customer payments with realistic dates, and a list of upcoming fixed and variable costs like rent, payroll, loan payments, and suppliers. Pulling this from already-recorded, up-to-date transactions is what makes the forecast accurate rather than guesswork.

How often should a 13-week cash flow forecast be updated?

Weekly. Drop the week that just passed, add a new week 13 weeks out, and refresh any receipt or payment estimate you now know more about. A forecast updated only monthly loses much of its early-warning value, since several weeks of assumptions can go stale between updates.

Build your forecast from figures that are actually current

Reyuko's live Receivable aging, Calendar due dates, and recurring payment terms give you real numbers to forecast from instead of guesswork.

Download Reyuko freeSee what's included