The 13 week cash flow forecast every owner needs
The 13 week cash flow forecast projects your real receipts and payments week by week over one quarter, dated to when money actually moves through the account. It fits on one sheet: opening balance, inflows, fixed and variable outflows, tax deadlines, closing balance, then the gap to a safety floor such as one month of fixed costs. Kept up and refreshed every Monday, it lets you see a cash squeeze two to three weeks ahead instead of discovering it that morning on your bank statement.
Most owners run their cash on instinct. They look at the bank balance in the morning and hope the big receipts land before the big payments. That works while things go well, and it blows up the day a customer pays late while VAT and payroll fall in the same week. The 13 week cash flow forecast exists precisely to remove that blind spot. Thirteen weeks is one quarter: short enough to stay reliable, long enough to see a squeeze coming and act before it turns into a crisis.
Why 13 weeks, and not an annual budget
An annual budget thinks in months and accounting profit. It tells you whether the year will be profitable, not whether you can pay salaries on the 28th. The 13 week forecast thinks in weeks and real flows, money in and money out on the date the cash actually moves through the account. It is a survival and decision tool, not a reporting tool. Its accuracy tapers off by design: the first two or three weeks are near certain, the middle is solid, the last weeks are an estimate you refine each week. That is normal and intended.
Profit tells you whether the business makes money. The 13 week forecast tells you whether it will still be around in three months to enjoy it.
The structure, line by line
The forecast fits on a single sheet: 13 columns, one per week, and a small number of rows. Resist the urge to detail everything. The logic is simple: start from the opening balance, add receipts, subtract payments, get the closing balance, which becomes the opening balance of the following week.
- Bank balance at the start of the week (the real balance, across all banks).
- Customer receipts, dated to the likely date of receipt and not to the invoice date. A 30 day invoice issued on the 10th lands around the 10th of the following month, sometimes later.
- Other inflows: grants, VAT refund, capital injection, loan drawdown.
- Fixed payments: salaries and social charges, rent, leasing, subscriptions, loan installments (principal and interest).
- Variable payments: suppliers, subcontractors, purchases, at their real payment date.
- Tax payments: VAT, corporate tax installments. These are what turn an ordinary week into a red week.
- Closing balance for the week, and the cumulative balance across the 13 weeks.
Add one final row, the most important one: the gap to your safety floor. Set a cash floor you never want to go below, for example one month of fixed costs, and show each week how far above or below it you sit. That is the row you will read first.
A worked example
Take a services business. Opening balance: €80,000. Average weekly fixed costs: €25,000. Safety floor set at one month of costs, so €100,000. On paper the business is profitable, but let us look week by week.
- Week 1: receipts €60,000, payments €30,000, closing balance €110,000. Comfortable.
- Week 2: a large customer slips a €50,000 payment to week 4. Receipts €15,000, payments €28,000, balance €97,000. Already below the floor.
- Week 3: a VAT payment of €40,000 and payroll of €25,000. Receipts €20,000, payments €65,000, balance €52,000. A clear squeeze, but visible three weeks ahead.
- Week 4: the €50,000 customer pays, and the balance climbs back into the green.
Without the forecast, the owner would have discovered the hole in week 3, on a Tuesday, staring at the account. With the forecast, they saw it in week 1. That gives two weeks to act: chase the week 2 customer, ask for a payment deferral, draw on a credit line, or simply push back a non urgent purchase. The problem does not change. What changes is the time available to solve it. That is the whole value of the tool.
The mistakes that make a forecast useless
A badly kept 13 week forecast is worse than none, because it gives false security. Four mistakes come up again and again, and I find them in almost every spreadsheet I am handed to fix.
- Dating receipts to the invoice date rather than the real payment date. This is mistake number one: it inflates the early weeks and reveals the holes too late.
- Forgetting non accounting flows: loan principal repayment, tax installments, dividend distribution, equipment bought outright. They are not in the profit line but they empty the account.
- Being too optimistic on customer receipts. Apply the payment times you actually observe, not the theoretical contractual terms.
- Not updating it. A frozen forecast becomes wrong within a week. The discipline of updating matters more than the sophistication of the model.
The rhythm: 20 minutes on Monday
The 13 week forecast is a rolling tool. Every Monday you do three things: replace the opening balance with the real bank balance of the day, compare last week’s actual receipts and payments to what you had forecast, and roll the window forward by adding a new thirteenth week at the end. The gap between forecast and actual is your best teacher: after a month or two you calibrate your collection times with a precision nobody in the business had before.
Twenty minutes a week is enough once the model is in place. The hard part is not the spreadsheet, it is the first build and the discipline of the dates. If you want to go deeper on the link between cash and profit, our guide on why profitable SMEs and startups still run out of cash explains why profit and cash diverge, and the 13 week forecast is the operational answer to it.
When to bring in an outside view
Many owners build their first forecast themselves, and that is exactly right. A fractional CFO adds three things that are hard to give yourself: the weekly discipline that survives busy weeks, the realistic calibration of customer delays from your own data, and the read on which lever to pull when a week turns red. It is also the tool any buyer will expect to see on the day of a sale, because it proves you steer your cash and not just your revenue.
If you do not yet keep a 13 week forecast, or yours still surprises you, a one hour diagnostic conversation is usually enough to set it up and to spot the first risky week in your quarter.
Turn the cash plan into this week’s decision
Start with reconciled bank balances and the date of the lowest projected balance. Separate confirmed, likely and unverified collections. An expected amount without a credible date should not be treated like an announced transfer. For each pressure point, record an action, owner and deadline, then compare actual collections the following week.
Weekly cash updates and monthly profit reviews serve complementary needs. Match the frequency to the variability of your business.
Key points
- Thirteen weeks is one quarter: short enough to stay reliable, long enough to see a squeeze coming and act before the crisis.
- Date receipts to the real payment date, never the invoice date: that single error is what hides the holes.
- The line to read first is not the balance, it is the gap to your safety floor.
- The tool does not remove the problem, it buys you time to solve it: two to three weeks of warning change everything.
- Twenty minutes every Monday: real balance, forecast versus actual, roll the window forward one week.
Frequently asked questions
What is the difference between a 13 week forecast and an annual budget?
The annual budget thinks in months and accounting profit; it tells you whether the year will be profitable. The 13 week forecast thinks in weeks and real flows through the account, and it tells you whether you clear the 28th of the month. The two work together: the budget sets the course, the 13 week forecast keeps you off the wall. A profitable year has never stopped a business from running short of cash on a Tuesday.
Spreadsheet or dedicated software: where should I start?
A plain spreadsheet is more than enough to start, and it is actually better: you understand every line instead of trusting a black box. Thirteen columns, about fifteen rows, and the formulas that carry the balance from one week to the next. Cash software earns its place later, when you want to connect the bank accounts and automate collection, not before you have run the spreadsheet by hand for three months.
How often should the forecast be updated?
Every Monday, without exception. A frozen forecast is wrong within a week, because payment dates move and new invoices land. The Monday ritual (real balance, forecast versus actual, add a thirteenth week at the end) takes twenty minutes once the model is built. It is the regularity, not the sophistication of the model, that makes the tool worth keeping.
What do I do when a week turns red?
First, you saw it coming, so you have time: that is already half the work. Then you pull the levers from cheapest to heaviest: chase a large customer, push back a non urgent purchase, ask for a payment deferral, and draw on a credit line only if you must. The one real mistake would be to do nothing and hope a receipt lands just in time.
Growing sales, but cash is still tight?
See how Mercova analyses cash timing and helps you choose actions suited to your business.
Understand my cash constraints