Cash Flow Forecast: How to Build a Simple 13-Week Forecast in a Spreadsheet

A cash flow forecast answers one question: will you have enough cash, week by week, to pay what is due? A 13-week forecast covers roughly one quarter. That is long enough to spot a tight month ahead, and short enough that your estimates stay realistic. You do not need special software. A simple spreadsheet, updated weekly, is enough for most small businesses.

This cash flow forecast template builds on How to Improve Cash Flow Management and the warning signs in Cash Flow Problems: 7 Warning Signs. Here you will lay out the sheet, fill it in week by week, and learn how to use what it shows.

Why 13 weeks works well

A month is too short. Many problems, like a quarterly tax bill or a slow-paying customer, sit just beyond it. A full year is useful for planning, but weekly detail that far ahead becomes guesswork. Thirteen weeks sits in between: you can see the next big bill, the next quiet period, and the effect of chasing one large invoice, all on one screen.

Setting up the spreadsheet layout

Create columns for each week, labelled Week 1 to Week 13, with the Monday date for each week. Down the left side, create these rows:

• Opening bank balance
• Money in: customer payments expected
• Money in: cash sales and card settlements
• Money in: other income (list separately if it matters)
• Total money in
• Money out: wages and payroll costs
• Money out: rent and premises costs
• Money out: suppliers and stock
• Money out: tax payments due
• Money out: loan or finance repayments
• Money out: other regular costs
• Total money out
• Net movement for the week (total in minus total out)
• Closing bank balance

The closing balance for one week becomes the opening balance for the next. That single link is what makes the forecast useful: a bad week carries forward, so you can see its real effect instead of treating each week in isolation.

Filling it in, week by week

Start with what is certain

Enter the fixed, known items first: rent, wages on their normal dates, regular repayments, direct debits, and tax payments you already know are due in the period. These rarely move, and they form the skeleton of the forecast.

Add expected customer payments realistically

For each invoice, put the expected payment in the week you honestly expect it, based on when that customer usually pays, not just the invoice due date. If a customer normally pays two weeks late, forecast it two weeks late. A hopeful forecast hides problems. A realistic one reveals them while you can still act.

Add seasonal and one-off items

Note insurance renewals, equipment purchases, busy or quiet trading periods, and any planned spending. If you run a retail or hospitality business, mark school holidays, local events, or your known quiet weeks. Cash problems often come from a known event that nobody wrote down.

Reading what the forecast tells you

Look first for any week where the closing balance goes negative, or drops below the minimum you need to feel safe. That week is your action point, and the weeks before it are your preparation time. You can bring income forward by invoicing earlier or chasing a debt, move a payment by agreement, delay a non-essential purchase, or arrange support from your bank well before the tight week arrives. Look second for patterns: if the balance falls a little almost every week, the issue is not timing, it is that regular spending exceeds regular income, and that needs a different conversation about prices and costs.

A short example of how a tight week appears

Imagine Week 5 shows wages, a quarterly tax payment, and rent all falling together, while your largest customer is forecast to pay in Week 6. The forecast does not create that problem. It shows it four weeks early. You might chase the customer for a part payment in Week 5, move one supplier payment to Week 6 by agreement, and pause a planned purchase. Each small move is easier because you saw the clash in advance.

Keeping the forecast alive

• Update it on the same day each week. Ten to fifteen focused minutes is usually enough once it is set up.
• Replace last week’s forecast figures with what actually happened, and note why they differed.
• Roll the forecast forward: drop the finished week and add a new Week 13 at the end, so you always look 13 weeks ahead.
• Keep a copy of each version. Comparing forecast with reality teaches you how each customer really pays.

Common mistakes

The biggest mistake is forecasting income on due dates while forecasting spending on real dates. Be equally honest on both sides. Other mistakes include forgetting annual or quarterly bills, counting the same expected payment twice, and building the forecast once for a loan application and never opening it again. A forecast is a weekly working tool, not a one-off document.

 

Frequently Asked Questions

What if I have never used a spreadsheet before?

Start with the row list in this article on paper or in a simple table, then copy it into a spreadsheet when you are comfortable. The thinking matters more than the tool.

How accurate does a forecast need to be?

It will never be exact, and it does not need to be. It needs to be realistic enough to warn you about tight weeks in time to act.

Should I include money I hope to win from new sales?

Keep hopeful sales out of the main forecast, or list them in a separate row you can switch on and off. Base decisions on income you have good reason to expect.

What should I do if the forecast shows a negative week?

Act early: chase income, move payments by agreement, cut non-essential spending, and talk to your bank or adviser before the week arrives, not during it.

Conclusion

A simple 13-week spreadsheet turns cash flow from a surprise into a schedule. Set up the rows, fill them in honestly, and review them weekly. If you want general background while you build better habits, BCC Financial Management Services provides educational information to help small businesses plan with more confidence.

General information only: This article is educational information about a general forecasting method, with a fictional illustrative example. It is not personal financial advice. Consider a qualified accountant or adviser for guidance specific to your business.