You had a strong month. Then a VAT bill landed and the worry came back. Sound familiar? A 13 week cashflow forecast UK business owners can actually run will break that cycle. It shows the cash coming in and going out over the next quarter, week by week. You spot shortfalls early and stop guessing. This guide explains what the forecast is, why 13 weeks works, and how to build one this week. You also get a free template and the habit that keeps your cash under control.
What is a 13-week cashflow forecast?
A 13-week cashflow forecast is a weekly view of the money entering and leaving your business over the next quarter. It tracks real cash movements, not invoices. Each week shows your expected closing bank balance. That lets you see shortfalls coming weeks before they hit.
The forecast uses the direct method. You record cash when it actually lands or leaves your account, not when you raise an invoice.
Profit and cash are not the same thing. Your profit and loss account counts a sale the day you invoice it. Your bank account only changes when the client pays. That gap is where most cash stress lives.
Why 13 weeks and not 12 months?
Thirteen weeks equals one quarter. It is the longest period you can forecast with real confidence.
Quarters are long enough to see big payments coming, like VAT, payroll and tax. They are short enough that your weekly estimates stay accurate.
Longer forecasts have their place for strategy. For day-to-day control, the 13 week window wins.
13-week vs 12-month cashflow forecast: which do you need?
Most growing businesses need both. Start with the 13 week forecast for control, then add a 12 month view for strategy.
| Feature | 13-week forecast | 12-month forecast |
| Purpose | Day-to-day cash control | Long-term strategy |
| View | Weekly | Monthly |
| Accuracy | High | Directional |
| Best for | Can I cover next month’s bills? | Can I afford to grow? |
Short-term forecasting answers the urgent question first. Will the cash last? The annual view comes next.
Planning to scale changes the picture. Pair this forecast with a wider business growth strategy for the bigger view.
How to build a 13-week cashflow forecast (step by step)
Building a 13 week cashflow forecast takes about an hour the first time. Follow these seven steps.
- Start with your opening bank balance. Use the actual cash in your account today.
- List your cash inflows week by week. Base them on when clients really pay, not invoice dates.
- Record your cash outflows. Include payroll, suppliers, rent, software and loan repayments.
- Add your UK tax payments. Build in PAYE and NIC, VAT and Corporation Tax on the right dates.
- Include the owner and investment row. Add your own pay, dividends and money set aside for growth.
- Calculate net cash flow and a running closing balance for each week.
- Flag the danger weeks. Highlight any week the closing balance turns red.
UK tax dates catch many owners out. PAYE and NIC are usually due by the 22nd of the following month if you pay electronically.
VAT is normally paid each quarter. Corporation Tax is due nine months and one day after your year end. Always check current dates and rates on GOV.UK before you finalise.
In over 20 years advising UK businesses, I have seen one mistake repeat. Owners forget the VAT quarter, and a healthy month becomes a scramble. The forecast removes that surprise.
Your free 13-week cashflow forecast template
Our free template gives you the structure, ready to use. It works in Excel or Google Sheets and needs no special skills.
Rows hold your line items, grouped into three buckets: income, outgoings and investments. Columns cover the 13 weeks. A summary row shows net cash flow and your closing balance.
Investments are the bucket most templates miss. This row tracks the money you take out and put to work. That is how a forecast becomes a wealth tool, not just a survival sheet.
This three-bucket method sits at the heart of our cashflow system.
How the rolling part works
Rolling means the window always shows a constant 13 weeks. Each week you drop the week just gone and add a fresh one at the far end.
Replacing estimates with real figures sharpens your accuracy over time. The spreadsheet becomes a live early-warning system, not a one-off task.
How accurate does it need to be?
Aim for near-exact figures in weeks one to four. You already know most of these bills and receipts.
Weeks five to 13 are educated estimates. They tighten as they get closer. The aim is early warning, not perfect prediction.
Common mistakes UK founders make
Some errors show up again and again. Avoid these five.
- Recording income when you invoice, not when you actually get paid.
- Forgetting VAT and Corporation Tax until they are due.
- Assuming every client pays on time. Many do not.
- Letting the forecast go stale instead of updating it weekly.
- Leaving out your own pay and dividends.
Late payment is the biggest hidden threat. The Federation of Small Businesses estimates that late payments cause around 50,000 UK business closures each year. Build a buffer for slow payers into every forecast.
Turn your forecast into a weekly habit
Forecasts only work when you use them. Set aside 15 minutes every Monday to update yours.
Review what landed, update the weeks ahead, and act on red weeks early. This habit is what ends feast and famine for good.
Doing it alongside other owners makes it stick. That is why we created the Cashflow Circle.
13-week cashflow forecast FAQs
Is a cashflow forecast the same as a budget?
No. A budget sets your spending targets for the year. A cashflow forecast tracks the timing of real money in and out. You need both, but the forecast keeps you solvent week to week.
How often should I update my forecast?
Weekly. Replace your estimates with actual figures, then roll the window forward by one week. A quick Monday review keeps it accurate and useful.
What should a 13-week cashflow forecast include?
Everything that moves cash. Include your opening balance, all inflows and outflows, UK tax payments, your own pay, and a weekly closing balance.
Can I build a 13-week cashflow forecast in Excel?
Yes. Excel or Google Sheets is all you need. Our free template gives you the layout and formulas ready to fill in.
The takeaway
Cash stops being a monthly worry once you can see it coming. Build the forecast once, update it weekly, and you will catch problems with time to act. The tool is simple, and the habit changes everything.
Ready to build the habit with founders who get it? Join the Cashflow Circle, our free community for UK business owners. For the full system, explore the Cashflow Mastermind.
Which week in your next quarter worries you most?
