Guide · 2026-11-03

How to build a 13-week cash flow forecast (step by step for small businesses)

Profit tells you whether your business works. Cash tells you whether it survives next month. A 13-week cash flow forecast is the tool finance teams, banks and turnaround advisors use to answer one question: in which week could we run short of cash, and by how much?

Why 13 weeks?

Thirteen weeks is one quarter. It's long enough to see payroll cycles, quarterly tax payments and slow-paying customers, and short enough that you can forecast it from facts you already know — invoices you've sent, bills you've received, salaries you'll pay. Weekly (not monthly) buckets matter because a month can look fine in total while one week in the middle goes negative.

What goes into it

Step 1 — Pick week 1 and record opening cash

Start on a Monday. Use the real bank balance, not the accounting balance — uncleared cheques and pending card payouts matter here.

Step 2 — List the recurring items

Write down everything that repeats, with its amount, frequency and next date: payroll every two weeks on Friday, rent on the 1st, loan payment on the 20th, estimated tax every quarter. This list is the backbone of the forecast and rarely changes.

Step 3 — Add the one-off items

Go through receivables and estimate when each invoice will actually be paid — not when it's due. If a customer usually pays 15 days late, forecast it 15 days late. Add known one-offs: annual renewals, equipment, bonuses, a tax bill.

Step 4 — Place everything in its week

This is where spreadsheets get painful: every recurring item has to be copied into the right weeks by hand, and month-end dates (the 31st in a 30-day month) and fortnightly cycles cause errors. Check each column adds up.

Step 5 — Compare closing cash with your buffer

Set a minimum balance you never want to go below — often two to four weeks of fixed costs. Highlight every week where closing cash falls under it. Those weeks are your action list: chase a specific invoice, move a purchase, or line up credit before you need it.

Step 6 — Run a downside case

Ask "what if receipts come in 15% lower and costs run 5% higher?" If the downside goes negative, you have a real risk to manage, not just a tight week.

Step 7 — Roll it every week

Each Monday, record what actually happened last week, compare it to the forecast, move the window on by one week and add a new week 13. The comparison (variance) is how the forecast gets more accurate over time.

A worked example

A 6-person design studio starts with $12,000 in the bank and a $20,000 minimum buffer. Payroll of $12,500 goes out every other Friday, rent of $4,200 on the 1st, and a $12,000 quarterly tax payment falls in mid-December. Three retainers and five client invoices bring in about $179,000 over the quarter against $175,000 of spending — profitable on paper. But the weekly view shows three weeks below the buffer: week 1, the week after Christmas, and the last week of January, when payroll lands just before the next retainer. Knowing that in early November, the owner can ask one client to pay early and time a laptop purchase around it.

Common mistakes

• Using invoice due dates instead of realistic payment dates.
• Forgetting annual and quarterly items (insurance, taxes, software renewals).
• Mixing accrual figures (revenue, expenses) with cash figures.
• Building it once and never rolling it forward.