The 13-week cash flow template: the most useful spreadsheet you will own.

A 13 week cash flow template is a rolling weekly forecast of every pound entering and leaving a business over the next quarter. It starts from the actual bank balance, lists receipts and payments by the week they will clear, and shows closing cash for each of the thirteen weeks ahead.

Why 13 weeks, and why weekly?

Monthly management accounts answer the question "where are we now?". Annual budgets answer "where do we want to be?". Neither answers the question that matters most for an SME on most days: "will I have enough cash next week, and the week after, and the one after that?"

That question requires weekly granularity. And it requires forward visibility long enough to see issues early (so you can act) but short enough to be accurate (forecasts beyond 13 weeks degrade quickly because too many variables compound). 13 weeks, one quarter, is the established right answer. PE-backed companies have used 13-week models for decades; the discipline is now standard practice for any SME with a credit facility or material seasonality.

What goes in

A 13-week cash flow is not a P&L. It tracks actual cash movement, not accrual revenue and expenses. Build the model as three sections.

1. Opening cash

One row: the closing bank balance from the prior week. This is the only number you absolutely cannot get wrong; reconcile to bank weekly.

2. Cash receipts (inflows)

• Customer receipts. Schedule based on your AR aging, invoice X due on date Y, expect to receive Y+5 days based on historic customer behaviour. Don't schedule by invoice date.
• Subscription revenue: for SaaS, the recurring portion is predictable and goes in at expected processing date.
• One-off receipts: VAT refunds, R&D tax credits, grant disbursements, asset disposals, loan drawdowns.
• Capital injections: investor tranches, shareholder loans, founder top-ups.

3. Cash payments (outflows)

• Payroll: gross salary plus employer NI/equivalent, on actual pay date.
• Supplier payments: based on AP aging and your actual payment-run cadence (weekly, fortnightly, monthly).
• Tax payments: VAT, PAYE, Corporation Tax instalments, on actual due dates.
• Rent, utilities, software: recurring, mostly direct debit.
• Variable: marketing spend, inventory purchases, capital expenditure planned for the period.
• Debt service: loan interest and principal repayments.

Bottom line: closing cash, weekly

Opening + inflows − outflows = closing cash. The closing cash for week 1 becomes the opening cash for week 2. The chart you actually look at is the closing cash trajectory across 13 weeks.

A worked example

Imagine a UK SaaS business, £180k MRR, 12 employees, monthly retainers in our scope. Their 13-week cash flow at the start of Q3 might look like this (simplified to 4 weeks):

Several things are visible from this view that wouldn't be from monthly accounts:

• The VAT payment in week 1 takes £40k out, easy to forget without a weekly view.
• Payroll in week 3 takes the balance to £368k, still healthy, but the lowest point of the period.
• The R&D credit in week 4 is material; if it slipped to week 6 or 7, the cash position would be very different.
• The closing-cash trajectory across 13 weeks (extrapolating beyond what's shown) lets you stress-test scenarios: what if subscription receipts dropped 15%, what if the R&D credit slipped, what if you brought forward £50k of marketing spend.

How to maintain it

The model is only useful if it's accurate, and it's only accurate if it's maintained. The discipline:

• Weekly refresh. Every Monday morning, update the opening cash to actual, roll the period forward one week (week 14 becomes available, week 1 drops off), update forward-week forecasts based on what you learned last week.
• Variance review. What was forecast for the week just past vs what landed? Why was the variance? Use the answer to inform forward-week forecasts.
• Scenario layers. Build base case, downside (-15% inflows) and upside (+20% inflows). Look at all three weekly. Take decisions only after seeing all three.

Where does a 13 week cash flow template break?

Three things break 13-week cash flow models, and they're all avoidable.

1. Optimistic inflow timing

The most common failure mode. AR aging is built on invoice date rather than actual customer payment behaviour. Customers who pay 45+ days routinely show up as receipts at day 30. Cure: use trailing-90-day actual payment timing per customer, not invoice terms.

2. Missing inflexible outflows

Quarterly VAT, six-monthly Corporation Tax instalments, annual insurance renewals: easy to forget until the bank balance suddenly drops. Cure: maintain a "scheduled large outflows" calendar separate from the weekly model and reconcile every Monday.

3. No scenario discipline

Model built once, never stress-tested. The first time downside scenario is run, it's during an actual crisis, when the model is too crude to be useful. Cure: run base/downside/upside every week, even when nothing is broken.

The 13-week cash flow is the artifact every credit committee, investor and PE buyer expects. If you don't have one, you're running blind on the variable that matters most.

The bottom line

If your business doesn't maintain a 13-week cash flow, start one this week. The first version will be wrong; the second version less wrong; by month three you'll wonder how you ran the business without it. The model itself is unglamorous. The decisions it informs (when to hire, when to pause marketing, when to draw a credit facility, when to stretch payables) are some of the biggest decisions an operator makes.

What goes in each row of the 13 week cash flow template?

Fourteen rows and thirteen columns. Anything more is a model you will stop updating by week three, which is worse than not having one.

The tax rows are the ones people leave out, and they are the rows that cause the trouble. A UK business on quarterly VAT pays one calendar month and seven days after the period ends, per HMRC's VAT deadline rules, so a 31 March quarter end lands on 7 May. Corporation Tax is payable nine months and one day after the year end, and accounts are due at Companies House within nine months. Three fixed, unavoidable outflows that a monthly P&L never shows you in week form.

What does the model show that a profit and loss cannot?

Timing. A business can be profitable every month of a quarter and still run out of money in week seven, because profit recognises a sale when it is invoiced and cash recognises it when it arrives. The 13 week model is the only routine report that puts those two facts next to each other.

Worked example, illustrative rather than a real client. An agency invoices £180,000 in a quarter against £150,000 of costs, so £30,000 of profit. Payroll of £42,000 falls on the last working day of each month, the VAT payment of £21,000 falls in week six, and the largest client pays on 60 day terms. The P&L shows a healthy quarter. The weekly model shows the balance dipping to £4,000 in week six, which is the week to move the supplier payment run rather than the week to discover the problem.

That is also the number that decides whether to draw on a facility, and when. Deciding in week two costs a conversation. Deciding in week six costs a rate.

Who should own the model, and how we run it

Whoever chases the cash. In a business under about thirty people that is usually the founder or the finance lead, and the update should take twenty minutes on a Monday, not an afternoon. If it takes an afternoon, the model has too many rows.

We build and maintain it as part of our fractional CFO engagements, sitting alongside monthly management accounts so the weekly cash view and the monthly performance view are built off the same ledger. The underlying bookkeeping runs through cloud bookkeeping services in Xero or QuickBooks, and businesses whose ledger is too far behind to forecast from start with catch-up bookkeeping. Founders wondering whether they need the wider finance function should read when does a startup need a CFO, and businesses with foreign currency balances should pair this with multi-currency accounting for SMEs. Sector context sits on startup accountants for VC-backed founders and small business accountants.