Profit and cash are different things. A business can show a profit on paper and still struggle to cover payroll on Friday, because the money from a sale arrives weeks after the cost of delivering it. A short, simple cash forecast turns that surprise into something you see coming. This article shows how to build a 13-week cash flow forecast in a spreadsheet, in about two hours, with no special software.
The example uses hypothetical numbers, labelled as such. The aim is the method, not a benchmark.
Key takeaways
- A 13-week forecast tracks actual cash in and out, week by week, not profit.
- Start from your bank balance today, then add expected receipts and subtract known payments for each week.
- Use the date money will move, not the invoice date. Late-paying customers shift receipts later.
- Update it weekly: replace last week's guesses with actuals and add a new week at the end.
- Set a minimum cash level and decide in advance what you will do if the forecast dips below it.
Why a 13-week forecast?
Thirteen weeks is one quarter. It is far enough ahead to see a tax payment, a slow season or a large supplier bill coming, and near enough that you can estimate each week with some confidence. A 12-month forecast built from guesses feels precise but is rarely useful for day-to-day decisions. A rolling 13-week view gets corrected every week, so it stays honest.
What do you need before you start?
- Your current bank balance across all operating accounts.
- A list of unpaid customer invoices with their due dates and, if you know it, how late each customer typically pays.
- A list of bills you owe and their due dates.
- Your recurring costs: payroll, rent, loan payments, subscriptions, insurance, and any estimated tax payments.
- Any known one-off items: equipment, annual fees, seasonal inventory, owner draws.
How do you build it, step by step?
- Set up the grid. Put the 13 week-ending dates across the top. Down the side, add rows: opening cash, cash in, cash out, net change and closing cash.
- Enter opening cash for week 1. Use today's actual bank balance. Each later week opens with the previous week's closing cash.
- List cash in by source. Use separate rows for customer collections, other income and any financing you have already arranged. Place each unpaid invoice in the week you realistically expect payment, not the week it is due.
- Estimate new sales cautiously. For weeks beyond your current invoices, base collections on recent history and your payment terms. If you are unsure, use the lower number.
- List cash out by category. Use rows for payroll and payroll taxes, rent, supplier bills, loan payments, tax payments, insurance, software and owner draws. Put each in the week it is paid.
- Calculate net change and closing cash. Net change is cash in minus cash out. Closing cash is opening cash plus net change.
- Add a minimum cash line. Pick a floor, for example enough to cover one payroll or a few weeks of fixed costs, and highlight any week where closing cash falls below it.
What does a worked example look like?
The numbers below are hypothetical, for an imagined small services business, and are not data from any survey. Only the first four weeks are shown.
| Line | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Opening cash | $18,000 | $15,000 | $32,000 | $20,000 |
| Customer collections | $6,000 | $22,000 | $4,000 | $20,000 |
| Payroll and taxes | -$9,000 | $0 | -$9,000 | $0 |
| Rent, software, insurance | $0 | -$5,000 | $0 | -$6,000 |
| Estimated tax payment | $0 | $0 | -$7,000 | $0 |
| Closing cash | $15,000 | $32,000 | $20,000 | $34,000 |
In this example week 3 is the squeeze: two obligations land together and collections are light, so cash drops by $12,000 in a single week, even though the balance stays positive. A profit report would not show that. The forecast shows it weeks ahead, which is time to follow up on an overdue invoice, ask a supplier for a later due date or move a discretionary purchase, rather than scramble on the day.
What is the weekly routine?
- Once a week, at the same time, update opening cash to the real bank balance.
- Replace last week's estimates with what actually happened.
- Move any invoice that was not paid into a later week.
- Add a new week 13 at the end.
- Look at the lowest closing-cash week. If it is below your minimum, write down one action and an owner.
The comparison of forecast to actual is where the learning happens. If customers consistently pay a week later than you assumed, change the assumption.
Who should see the forecast?
Share it with whoever approves spending and whoever chases payments. The person who sends invoices should know which week a late payment hurts most, and the person who pays suppliers should know which weeks are tight. If you work with an accountant or bookkeeper, send them the file each month and ask what they would add. A forecast that only one person understands becomes a single point of failure, just like any other process in the business.
Cash forecast checklist
- Opening balance matches the bank, not the accounting software.
- Receipts use expected payment dates, not invoice dates.
- Payroll, payroll taxes and estimated tax payments are in the right weeks.
- Loan payments, annual fees and insurance are included.
- A minimum cash level is set and flagged.
- Someone owns the weekly update.
What mistakes make a forecast misleading?
- Using invoice due dates instead of the dates customers actually pay.
- Forgetting irregular costs such as annual insurance, license renewals and quarterly tax payments.
- Mixing profit and cash, for example leaving out loan principal or owner draws.
- Building it once and never updating it.
- Being optimistic on new sales. A forecast you can trust leans conservative.
Frequently asked questions
Do I need accounting software to do this?
No. A spreadsheet is enough to start. Accounting software can help you list unpaid invoices and bills, but the forecast itself is a simple grid you control.
How accurate does it need to be?
Accurate enough to show which weeks are tight. Near-term weeks should be close because they rest on known invoices and bills. Later weeks are estimates and will be revised as they come closer.
What should my minimum cash level be?
It depends on your business. Many owners start with enough to cover one payroll plus a few weeks of fixed costs, then adjust based on how unpredictable their receipts are. Your accountant can help you choose a level that fits your situation.
What if the forecast shows a shortfall?
Act while you still have time: follow up on overdue invoices, ask about earlier payment from customers, negotiate supplier due dates, or defer discretionary spending. Talk with your bank early if you may need financing.
Where to start
Block two hours this week, set up the grid and fill in the first four weeks from real bank and invoice data. If late invoices are a recurring cause of tight weeks, our guides on a small-business operations checklist and how to identify workflow bottlenecks can help you find where the delay starts, and the priority matrix can help you decide what to fix first. For a structured look at one workflow, the Workflow Clarity Assessment is one advisory option, and Find your starting point can help you choose a next step.