Profit tells you whether your business makes money over a year. Cash tells you whether you can pay everyone on Friday. Plenty of profitable businesses get into trouble because a big customer pays late, a tax bill lands and payroll falls in the same fortnight. A 13-week cash flow forecast is the simplest way to see that coming.
Thirteen weeks is a quarter: long enough to spot a problem while there's still time to act, and short enough that most of the numbers are things you already know about.
The short version
- List the cash you expect to come in and go out, week by week, for the next 13 weeks.
- Start from your actual bank balance today, not your profit and loss report.
- Update it every week: swap the oldest week for what actually happened, and add a new week at the end.
- Watch for any week where the closing balance dips below a safety buffer you've chosen, and act early.
Why weekly, and why cash
Monthly forecasts hide timing. Payroll on the 25th and a big customer payment on the 2nd look fine in a monthly total, but can leave you short for a week in between. And cash isn't the same as profit: an invoice you've sent counts as income in your accounts, but it doesn't help you until the money arrives. Our article on why profitable businesses still run out of cash goes into this in more detail.
The layout
One column per week, and these rows:
| Row | What goes in it |
|---|---|
| Opening cash | Last week's closing cash (for week 1, today's bank balance) |
| Customer receipts | Money you expect customers to actually pay that week |
| Other income | Loans, grants, asset sales, anything else coming in |
| Payroll | Wages, plus PAYE and pension contributions (or US payroll taxes) in the week they're paid |
| Rent and bills | Rent, utilities, insurance, subscriptions |
| Suppliers | Bills you'll pay that week |
| Tax | VAT, sales tax, corporation tax or income tax payments due |
| Loan repayments | Any finance repayments |
| Other payments | Anything else going out |
| Net cash flow | Total in minus total out |
| Closing cash | Opening cash plus net cash flow |
A spreadsheet is the right tool for this, because the totals need to add up automatically. Set it up once, and it takes 20 to 30 minutes a week to keep current.
Where the numbers come from
Money coming in
Start with the invoices you've already sent, and put each one in the week you realistically expect to be paid, not the week it's due. If a customer always pays ten days late, plan for ten days late. Then add sales you're confident about but haven't invoiced yet. Be cautious here. It's far better to be pleasantly surprised than caught short.
Money going out
Fixed costs are the easy part, because payroll, rent and subscriptions happen on known dates. Then add supplier bills you've received, and known tax dates. In the UK, VAT returns and payments are usually due one calendar month and seven days after the end of each VAT period, and our Self Assessment deadlines guide lists the personal tax dates for sole traders.
Updating it every week
- 1Replace last week's forecast with what actually happened.
- 2Look at the differences. Big gaps show you which assumptions need fixing.
- 3Add a new week at the end, so it always looks 13 weeks ahead.
- 4Move the expected payment date of any invoice that's now late.
- 5Check the lowest closing balance in the next 13 weeks.
What to do when you see a gap
Pick a safety buffer, such as enough cash to cover a month of fixed costs, and treat any week below it as a warning. The earlier you see it, the more options you have:
- Chase overdue invoices, and make it easy to pay.
- Agree new payment dates with suppliers before the bill is due, not after.
- Move non-essential spending to a later week.
- Talk to your bank about an overdraft or other facility while things are still fine. It's much harder to arrange in a hurry.
- For tax, contact HMRC (or the IRS in the US) early if you can't pay on time. Payment plans are often possible.
Copy the layout
Here's the layout, ready to paste into a spreadsheet. Put the weeks across the top, then add simple formulas for the totals, net cash flow and closing cash.
13-week cash flow forecast layout
13-WEEK CASH FLOW FORECAST Business: First week starts (date): Safety buffer (the least cash we want to hold): One column per week, Week 1 to Week 13. Rows: OPENING CASH CASH IN Customer receipts Other income Total cash in CASH OUT Payroll (including PAYE, pensions or payroll taxes) Rent and bills Suppliers Tax (VAT, sales tax, corporation or income tax) Loan repayments Other payments Total cash out NET CASH FLOW (total in minus total out) CLOSING CASH (opening cash plus net cash flow) BELOW SAFETY BUFFER? (yes / no)
A worked example
Here's what the first four weeks might look like for a small service business. These are illustrative figures, not a real company.
| Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
| Opening cash | £12,000 | £15,500 | £6,800 | £13,300 |
| Customer receipts | £6,000 | £4,500 | £8,000 | £3,000 |
| Payroll | £0 | £9,000 | £0 | £0 |
| Rent and bills | £1,500 | £0 | £500 | £300 |
| Suppliers | £1,000 | £1,200 | £1,000 | £800 |
| Tax (VAT) | £0 | £3,000 | £0 | £0 |
| Closing cash | £15,500 | £6,800 | £13,300 | £15,200 |
Week 2 is the one to watch. Payroll and a VAT payment land together, and cash drops to £6,800. If your safety buffer is £8,000, that's the warning, and you can see it weeks in advance. Moving a supplier payment, or chasing a customer who's due to pay in week 3, would fix it.
Common mistakes
- Putting invoices in the week they're due instead of the week you'll really be paid.
- Forgetting quarterly and annual costs, such as VAT, insurance renewals or software paid yearly.
- Starting from the profit and loss report instead of the bank balance.
- Building it once and never updating it.
- Being too optimistic about new sales.
Frequently asked questions
Why 13 weeks?
It's one quarter, so it covers most regular cycles, such as payroll, rent and quarterly VAT, while staying close enough that the numbers are reliable. Many businesses also keep a rougher 12-month forecast for longer-term planning.
How is this different from a budget?
A budget is a plan for income and spending, usually monthly and based on profit. A cash flow forecast shows when money actually moves in and out of the bank, week by week.
Do I need accounting software for this?
No, a spreadsheet is fine. Up-to-date bookkeeping makes it much quicker, though, because you can see unpaid invoices and bills at a glance.
Who should own the forecast?
One named person who updates it every week, often the owner, the finance lead or your bookkeeper. Others can feed in numbers, but one person should be responsible for keeping it current.
How accurate does it need to be?
Accurate enough to spot a problem in time. The near weeks should be close to reality; the later weeks will be rougher, and that's fine. What matters is that you update it and learn from the differences.
Want help with cash flow?
Our fractional CFO team builds and runs cash flow forecasts for growing businesses, and our bookkeeping team keeps the numbers behind them up to date. See how in our Finance Studio, or book a call.
See it in practice · FinTech
FinTech KYC review cut from 5 days to 4 hours
Curious how your own site scores?
Run our free website audit. Simple report, about 10 seconds, no sign-up.



