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


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 balance.

The weekly discipline

Update it every week, same day. Roll it forward one week so it always covers the next thirteen. Compare last week's forecast with what actually happened and note the variances; the forecast gets dramatically better after four to six weeks of this.

The five things that break forecasts

Optimistic receipts: use your actual debtor days, not your payment terms. Forgotten tax: put every HMRC deadline in the forecast the day you learn it. Lumpy payroll months: months with extra pay runs need their true cost, including employer NICs. Unrecorded commitments: purchase orders raised but not yet invoiced still become cash out. No scenario: run a downside version with receipts 20 percent late.

From forecast to control

A 13-week forecast turns cash management from reactive to deliberate. Businesses that want the discipline without the weekly effort often outsource it. Finex Outsourcing builds cash flow forecasting into its management accounts routines for UK small businesses, so the forecast is updated, reviewed, and acted on every single week.


 

Comments

Post a Comment

Popular posts from this blog

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

Image
  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 i...
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