Cash flow forecast template: how to build a 13-week forecast (free Excel download)
Profit tells you whether the business works. Cash tells you whether it survives the next quarter. A step-by-step guide to the weekly forecast lenders and owners rely on, with a free template.
Ranahesha Fernando · updated
A business can be profitable on paper and still run out of cash. Customers pay late, a supplier wants a deposit, payroll and a tax payment land in the same week, and the bank balance that looked comfortable at the start of the month is gone by the third Friday.
A cash flow forecast is how you see that coming, and the 13-week version is the one finance teams, lenders and turnaround advisers rely on. It is simple to build, it needs no special software, and once it is running it takes less than an hour a week to keep up to date.
Profit tells you whether the business works. Cash tells you whether it survives the next quarter.
Download it, then follow the steps below.
What it is, and why 13 weeks
A 13-week cash flow forecast lists, week by week, the cash you expect to receive and the cash you expect to pay out, starting from the money in the bank today. Each week’s closing balance becomes the next week’s opening balance.
Thirteen weeks is one quarter. It is long enough to see a squeeze coming while there is still time to act, and short enough that each week can be forecast in real detail: actual invoices due, actual payroll dates, actual supplier terms. Beyond about three months, weekly detail turns into guesswork, so longer views are usually done monthly.
The forecast is rolling. Every week you drop the week that has just finished, add a new week 13, and update everything in between with what you now know.
When you need one
Any business benefits from one, but it becomes essential when:
- Cash is tight, or you have had a near miss with payroll or a supplier payment.
- You are growing quickly. Growth eats cash: you pay for stock and staff before customers pay you.
- Your sales are seasonal, so a good quarter can hide a thin one coming.
- A lender or investor asks for one. Banks often ask for a 13-week forecast when a facility is renewed, extended or under pressure.
- You are planning a big commitment, such as new premises, a system or a hire, and want to know whether the timing works.
Direct, not indirect
There are two ways to forecast cash. The indirect method starts from profit and adjusts for non-cash items and working capital. It is how the cash flow statement in annual accounts is usually built, and it is useful for longer-range planning.
The 13-week forecast uses the direct method: actual cash in and actual cash out, line by line. It is easier to understand, easier to check against the bank, and it shows exactly which payment causes a problem in which week.
The structure
| Section | What goes in it |
|---|---|
| Opening cash | The bank balance at the start of the week (week 1: today’s actual balance) |
| Receipts | Customer collections, other income, loans received, asset sales |
| Payments | Payroll and payroll taxes, suppliers, rent, other overheads, sales tax, income tax, loan repayments and interest, capital spending |
| Net cash flow | Receipts minus payments for the week |
| Closing cash | Opening cash plus net cash flow |
| Minimum cash | The balance you never want to go below |
| Headroom | Closing cash plus any undrawn facility, minus the minimum |
Building it, step by step
- Start from the bank, not the ledger. Week 1 opens with the actual cleared balance across your operating accounts today. If the forecast does not start from a real number, nothing after it can be trusted.
- Forecast customer receipts from your receivables. Take your aged receivables list and place each invoice in the week you realistically expect to be paid, based on how that customer actually pays, not on your stated terms. Then add expected new sales, delayed by your typical collection period.
- Lay out payroll on its real calendar. Pay dates, payroll taxes and pension or retirement contributions on the days they actually leave the account. Payroll is usually the largest and least flexible payment, so get it exactly right.
- Schedule supplier payments by due date. Use your payables list and supplier terms. Add the regular suppliers you will pay in the period even if they have not invoiced yet.
- Add fixed commitments. Rent, leases, insurance, software subscriptions, loan repayments and interest, on their actual dates.
- Add tax payments. Sales tax, income tax instalments and any payment plans, on their due dates. These are easy to forget and hard to move.
- Add the one-offs. Planned equipment, bonuses, deposits, annual renewals and anything else you know is coming.
- Set a minimum cash line. Decide the lowest balance you are comfortable with, often a few weeks of fixed costs, and flag any week that falls below it.
- Calculate headroom. If you have an overdraft or a revolving facility, add the undrawn amount and subtract the minimum. This is the number that tells you how much room you really have.
Keep it rolling, and check it every week
The forecast earns its keep when it is updated weekly and compared with what actually happened:
- Roll it forward. Drop the finished week, add a new week 13, and update the open weeks with new information.
- Compare forecast with actual. For the week just finished, put the actual receipts and payments next to what you forecast. The template has a column for this.
- Explain the big differences. A customer who paid two weeks late, a supplier paid early, an expense nobody expected. Each explained difference makes the next forecast more accurate.
- Track your accuracy. After a few weeks you will know which lines you forecast well and which you do not. That is where to spend your effort.
Common mistakes
- Using terms instead of behaviour. A customer on 30-day terms who always pays in 55 days should be forecast at 55.
- Forgetting the lumpy payments. Quarterly tax, annual insurance and software renewals cause most surprises.
- Treating it as a one-off. A forecast built once for the bank and never updated is out of date within a fortnight.
- Mixing profit and cash. Depreciation, accruals and invoices raised but not paid do not belong in a cash forecast.
- No owner. Someone needs to update it every week, at the same time, and share it.
Where systems help
The slowest part of a weekly forecast is collecting the data: exporting receivables and payables, checking the bank, and retyping it all into the spreadsheet. If your accounting system can produce aged receivables and payables in a consistent format, much of that can be refreshed automatically, which turns an hour’s work into minutes and removes retyping errors.
That is where finance and systems meet. We build cash forecasts with businesses, and connect them to the systems they already use so they stay current without the manual effort.
In short
- Build it on the direct method: real cash in, real cash out, week by week.
- Start from the actual bank balance, and forecast receipts from how customers really pay.
- Set a minimum cash line, and watch the headroom, not just the balance.
- Roll it every week, compare with actual, and learn from the differences.
Get the templateThe same forecast, ready to fill in with your own numbers.Download ↓
Frequently asked questions
What is a cash flow forecast?
A cash flow forecast estimates the cash coming into and going out of the business over a coming period, and the bank balance that leaves at the end of each week or month. Unlike a profit forecast, it follows when money actually moves, so it shows whether you can pay wages, suppliers and tax on the days they fall due.
Should a cash flow forecast be weekly or monthly?
Both have a place. A weekly forecast over 13 weeks is the one to manage cash with: it catches the week when payroll, a supplier run and a tax payment land together. A monthly forecast over 12 months suits budgeting and funding conversations. Many businesses run the 13-week forecast every week and a 12-month forecast alongside it.
Can’t I just use the cash flow forecast in Xero?
Xero includes a short-term cash flow forecast on its current Australian plans (90 days on Comprehensive, 180 days on Ultimate), built from the invoices and bills already in Xero. It is a good starting point. A 13-week forecast adds what the accounting system cannot know yet: payroll and super, tax instalments, loan repayments, planned purchases, and your judgement about which customers really pay late.
How often should I update it?
Every week, on the same day, starting from the actual bank balance. Compare last week’s forecast with what actually happened, and adjust your assumptions. A forecast built once for the bank and never updated is out of date within a fortnight.
Glossary
Direct method. Forecasting cash from actual receipts and payments, rather than starting from profit.
Aged receivables. A list of unpaid customer invoices grouped by how long they have been outstanding.
Minimum cash line. The lowest balance the business is willing to hold, used to flag weeks that need action.
Headroom. Closing cash plus any undrawn borrowing facility, minus the minimum cash line.
Rolling forecast. A forecast that always looks the same distance ahead, extended by one period each time a period ends.
Sources
Share this