The 13-Week Cash Flow Forecast: Build Your First One in an Afternoon


 

Profit is an opinion; cash is a fact. Businesses rarely fail because the annual accounts looked bad. They fail because the bank balance hit zero on a Tuesday and payroll was due on Friday. The 13-week cash flow forecast is the tool that stops that happening. It is simpler than it sounds, and you can build your first one in an afternoon.

Why 13 Weeks

Thirteen weeks is roughly a quarter: long enough to see trouble coming, short enough that the numbers are mostly known rather than guessed. It covers the next payroll cycles, the next VAT quarter-end, the next corporation tax instalment. Anything further out belongs in a budget; the 13-week forecast is about survival and timing.

Step 1: Start With the Opening Balance

Take today's actual bank balance across all business accounts. Not the book balance, the bank balance. Reconcile first so you are starting from truth, not hope.

Step 2: List Every Known Outflow by Week

Go through the next 13 weeks and place every committed payment in its week: payroll dates, rent, loan repayments, supplier payment runs, VAT and tax deadlines, insurance renewals. Be pessimistic about timing: if a payment might go out in week 6 or 7, put it in week 6. Cash forecasts should err on the side of caution.

Step 3: List Expected Inflows, Then Haircut Them

List customer receipts by the week you realistically expect them, not the invoice due date. Then apply a haircut: push anything from a habitually late payer one week later, and exclude anything you would not bet on. A forecast built on optimistic receipts is a fantasy with columns.

Step 4: Find the Troughs

With inflows and outflows placed, calculate the running balance each week. You are looking for the low points: the weeks where the balance dips toward zero or below. Those troughs are the whole point of the exercise. A trough in week 9 that you see today is a problem you can solve; the same trough discovered in week 8 is a crisis.

Step 5: Act on What You See

For each trough, you have options, and they all work better with notice: chase the overdue debtors now, agree extended terms with a supplier, draw on an agreed facility before you need it, or shift a discretionary payment. The forecast does not fix cash; it buys you the time to fix cash.

Keeping It Alive

A forecast built once and filed away is decoration. Update it weekly: replace forecast weeks with actuals, roll forward one week, and re-check the troughs. Thirty minutes every Monday morning. The discipline matters more than the spreadsheet design.

The One Number to Watch

If you track nothing else, track the minimum forecast balance over the 13 weeks. When it trends down for three consecutive weeks, act, even if it is still positive. Trends are warnings; absolute numbers are just snapshots.

What to Do When the Forecast Says No

Sooner or later the forecast will show a week where the balance goes negative, and that is the moment it earns its keep. You have better options with nine weeks of notice than with nine days. Bring forward receipts: offer early-payment discounts to your best payers, or chase the overdue ledger hard now. Push back outflows: agree extended terms with suppliers before you need them, not after. Talk to your bank about an overdraft extension while the balance is still healthy; facilities arranged in a crisis cost more. And if tax is the trough, a Time to Pay arrangement lets you spread the bill with HMRC, but only if you call before the deadline, not after. The forecast does not prevent bad weeks; it converts them from emergencies into decisions.

Cash flow forecasting sits at the heart of good financial management, and it is one of the first things to slip when the finance function is stretched. Finex Outsourcing provides outsourced financial planning and analysis for UK businesses, including rolling cash flow forecasts, management reporting, and the monthly discipline that keeps the numbers honest.

Comments

Post a Comment

Popular posts from this blog

The 13-week cash flow forecast: a simple template for small businesses

Image
Profit is an opinion; cash is a fact. The businesses that survive tight periods are rarely the most profitable on paper; they are the ones that knew, week by week, what was coming in and going out. The 13-week cash flow forecast is the simplest tool that gives you that visibility. Why 13 weeks Thirteen weeks is one quarter: long enough to see the real pinch points (the VAT quarter, the payroll months, the big supplier payments) and short enough that the numbers are still based on known invoices and realistic expectations rather than guesses. The template: three sections Opening cash: the actual bank balance today, across all accounts, reconciled, not estimated. Cash in, week by week: every expected receipt, dated by when the money actually arrives, not when the invoice was raised. Cash out, week by week: payroll dates, supplier payment runs, VAT and tax deadlines, rent, loan repayments, and the regular overheads. The closing balance each week becomes the next week's opening bal...
Read more

The debtor days problem: cutting 60 days down to 30

Image
The debtor days problem: cutting 60 days down to 30   What debtor days really measure Debtor days tell you how long, on average, your customers take to pay you. The formula is simple: divide trade receivables by annual credit sales and multiply by 365. A business sitting at 60 debtor days is effectively giving every customer a two-month interest-free loan, funded from its own cash reserves. Bring that down to 30 days and you release a full month of sales back into the bank account. For a business turning over £1.2 million, that single improvement frees roughly £100,000 of working capital. No new borrowing, no new sales required. Measure it before you try to fix it Start with the headline number, then break it down. Segment debtor days by customer, by invoice size and by salesperson or account manager. The aged debtors report is your best friend here: a headline of 45 days can hide one large customer sitting at 90 while everyone else pays in 30. Track the number weekly, not month...
Read more