A 13-week cash flow forecast is a week-by-week projection of cash inflows and outflows that produces a closing cash balance for each of the next 13 weeks — roughly one quarter. It is built from known cash events (invoices due, payroll dates, tax payments, contracted expenses) rather than P&L accruals, and it is rolled forward every week with actuals replacing forecasts. Its purpose is to show exactly when cash will be tight so you can act before a shortfall becomes a crisis.
The 13-week cash flow forecast is the most widely used tool in distressed finance and corporate turnaround situations — for good reason. When cash is tight, a 13-week view is the right planning horizon: long enough to see problems coming, short enough to forecast with genuine accuracy.
But the 13-week forecast isn't just for crisis situations. It's the right cash management tool for any business where cash flow is a meaningful management variable — which, practically speaking, is most businesses below €20M revenue and many larger ones too.
This guide covers what a 13-week cash flow forecast is, how to build one properly, how to use it, and how to maintain it as a rolling management tool.
What Is a 13-Week Cash Flow Forecast?
A 13-week (approximately quarterly) cash flow forecast is a week-by-week projection of cash inflows and outflows, producing a weekly closing cash balance for the next 13 weeks.
It is distinct from:
P&L forecasting: The P&L forecasts revenues and costs when they're earned and incurred (accrual basis). The cash flow forecast shows when money actually arrives in or leaves the bank account. These can differ significantly — a business can be profitable on a P&L basis and running out of cash simultaneously.
Annual budget: The annual budget is a 12-month P&L and cash flow projection, typically prepared once a year with monthly granularity. It provides strategic direction but not the week-by-week precision needed for near-term cash management.
Balance sheet forecasting: The cash flow forecast focuses exclusively on the bank account movement; the balance sheet captures the full financial position.
The reason 13 weeks is the standard horizon: it provides one full quarter of visibility, which is enough to anticipate and act on problems, while remaining within the range that can be forecast from real information (known invoices, confirmed payroll dates, contracted expenses) rather than extrapolation.
Why Every Growing Business Needs One
Most founders and business leaders have a vague sense of their cash position — they know roughly what's in the bank and have a general feeling about whether things are comfortable or tight. That's not sufficient for managing a growing business. The forecast is one tool inside a wider discipline, which our cash flow management playbook covers end to end.
Specific situations where a 13-week forecast is essential:
Cash is tight. If you have less than 8–12 weeks of runway at current burn, you need to know with precision when specific cash events will hit. A 13-week forecast shows you exactly when a large payroll payment, a tax payment, or a customer collection will land — and whether the sequence works.
The business is growing fast. Revenue growth consumes working capital. As you scale, you're often paying for more inventory, more people, and more overhead before the additional revenue arrives. Growth companies frequently experience the paradox of being profitable but cash-poor — a 13-week forecast makes this visible before it's a crisis.
You're in fundraising. Investors ask to see a cash flow forecast. More importantly, you need to know whether you'll reach your next milestone before running out of cash. The 13-week gives you a clear picture.
Tax payments are lumpy. VAT, corporation tax, payroll taxes — these create large, predictable cash outflows at specific dates. A 13-week forecast ensures you don't discover a €80k VAT payment is due in three weeks when the account only has €120k.
You have seasonal patterns. Businesses with seasonal revenue need to manage the cash trough — the period when revenue is low but fixed costs are still running. A rolling 13-week forecast provides early visibility of the trough.
How to Build a 13-Week Cash Flow Forecast
Structure
The forecast is structured as a table with weeks as columns and cash flow categories as rows:
| Wk 1 | Wk 2 | Wk 3 | ... | Wk 13 | |
|---|---|---|---|---|---|
| INFLOWS | |||||
| Customer receipts | |||||
| Other inflows | |||||
| TOTAL INFLOWS | |||||
| OUTFLOWS | |||||
| Payroll | |||||
| Rent & premises | |||||
| Tax payments | |||||
| Supplier payments | |||||
| Other outflows | |||||
| TOTAL OUTFLOWS | |||||
| NET CASH MOVEMENT | |||||
| Opening balance | |||||
| CLOSING BALANCE |
The closing balance of each week becomes the opening balance of the following week.
Inputs: Inflows
Customer receipts are the hardest part to forecast accurately. The approach depends on your business model:
Contract/subscription businesses: If revenue is largely contracted, you know the expected payment from each customer each period. Map it by the week you expect to receive the cash (not the week you issue the invoice or recognise the revenue).
Project businesses: Base it on your billing schedule and knowledge of each client's payment behaviour. If Client A is always 45 days, apply that lag to your invoices. If Client B pays consistently on the 15th, reflect that.
Transactional businesses: Use a recent average or rolling trend. For high-volume, low-value transactions (e-commerce, retail), a weekly average with seasonal adjustment is usually sufficient.
The most common error is using revenue recognition timing instead of cash collection timing. Revenue recognised in week 1 may not be collected until week 6. Always forecast cash on a cash basis.
Inputs: Outflows
Outflows are generally more predictable than inflows. Most are either fixed and regular (payroll runs on specific dates, rent is quarterly or monthly, standing orders are defined) or known in advance (confirmed supplier purchase orders, known tax payment dates).
Build your outflows from a calendar of known obligations:
- Payroll: Exact date, exact amount (usually fixed each month)
- PAYE/social contributions: Typically fixed to specific calendar dates
- VAT: Quarterly or monthly, based on your returns
- Corporation tax: Instalments or annual payment — map these specifically
- Rent/service charges: Per lease terms
- Supplier payments: Based on open purchase orders and terms
- Loan repayments: Fixed schedule
- Other: Any known large items (insurance renewals, annual software contracts, equipment purchases)
The discipline of mapping outflows to specific weeks — rather than spreading them evenly — reveals cash pinch points that smooth monthly figures conceal.
Free template: the 13-Week Cash Flow Forecast (Excel) is built exactly this way: an assumptions sheet (opening balance, minimum cash buffer, DSO and DPO, payroll date, VAT frequency), a weekly forecast with inflow and outflow lines you can rename, base, upside, downside and stress scenarios, a weekly actuals-versus-forecast variance and a runway dashboard. Enter your work email to download it.
Maintaining the Forecast as a Rolling Tool
The 13-week forecast is only useful if it's maintained. A static forecast prepared in January and reviewed in March is a historical document, not a management tool.
Roll it forward weekly: Each week, you drop the oldest week (which is now history) and add a new week 13 at the far end. This keeps the forecast window consistently 13 weeks forward.
Enter actuals weekly: Replace the forecast numbers for the most recently completed week with actuals. This creates a variance between forecast and actual — the most important analysis the forecast produces. Consistent over-forecasting or under-forecasting on specific lines tells you about your forecasting accuracy and the underlying business behaviour.
Update forward assumptions based on new information: If a large customer tells you they'll delay payment, update the forecast immediately. If a new contract is signed, add the expected receipts. The forecast should reflect your current best view, not a frozen point-in-time estimate.
Review the alert indicators weekly: Set a minimum cash buffer (typically 4–6 weeks of operating costs) and flag any week in which the closing balance falls below it. This isn't a cause for panic — it's a prompt to examine the situation and decide whether action is needed.
Common Mistakes
Confusing P&L with cash flow. Revenue recognised ≠ cash received. Costs accrued ≠ cash paid. Forecasting a P&L and calling it a cash flow forecast produces a number that can be wrong by the entire working capital movement.
Smoothing payments that are lumpy in reality. A payroll that runs on the 25th of each month creates a real spike in that week's outflows. Spreading it evenly across four weeks produces a forecast that looks smooth and bears no resemblance to reality.
Not accounting for timing differences in VAT. For VAT-registered businesses, the VAT collected in cash (from customers) and VAT paid in cash (to HMRC/revenue authority) are not the same as the VAT recognised in the P&L. These need to be in the cash flow separately.
Not updating regularly. A forecast that isn't maintained is worse than no forecast — it creates false confidence.
Frequently Asked Questions
How granular should the categories be? Enough to identify material items separately, but not so granular that the forecast becomes difficult to maintain. Separate payroll, tax, rent, and any item that represents more than 5% of weekly cash flow. Lump small items together.
Should the 13-week forecast replace the annual cash flow forecast? No — they serve different purposes. The annual cash flow (monthly granularity) provides strategic and funding context. The 13-week forecast provides operational precision. Both are needed.
How do I handle transactions in currencies other than my functional currency? If you have material FX exposure, run a sensitivity column showing the impact of a 5–10% adverse currency move on your cash position. If currency volatility is significant, consider FX hedging and reflect the hedging instruments in the forecast.
BB Financial Services Kft provides a 13-week cash flow forecast template as a free download, and works with businesses to build and maintain their cash forecasting process as part of our accounting and monthly close service. Get in touch if you'd like support setting this up in your business.
<!-- ============================================================== -->