Cash flow forecasting: building the 13-week forecast that stops surprises


 

By John Thomas, Senior Accountant

Every accountant has watched a profitable business run out of cash. Profit is an opinion, but cash is a fact, and the gap between the two catches out more small companies than any other single issue. The 13-week rolling cash forecast is the tool that closes that gap. Here is how to build one that actually works.

Why 13 weeks

Thirteen weeks is roughly a quarter: far enough ahead to see trouble coming, short enough that the numbers stay real. Annual cash forecasts are mostly fiction by month four. Thirteen weeks lines up with VAT quarters, typical supplier payment runs, and payroll cycles, so the forecast maps onto the rhythms your business already has.

What goes in

The forecast has three sections, and the golden rule is that it is about cash, not profit. Record every line on the date the money moves, not the date of the invoice.

Opening cash is your actual bank balance on day one, across all accounts. This is the only line you cannot estimate.

Cash in should be built bottom-up, not from the sales forecast. Start with confirmed receipts: debtors with payment dates agreed, recurring customer direct debits, grant money due. Then layer in realistic expectations for the rest, with collection timing based on what customers actually do, not what your terms say. Big one-off projects deserve their own lines with their own risk notes.

Cash out is where most forecasts die. Walk through everything: payroll (including PAYE and pension payments with their real due dates), supplier payments week by week, rent, VAT and corporation tax falling due, loan repayments, directors' drawings, and the irregular items everyone forgets, like insurance renewals and software annual renewals. A good test is to ask your bookkeeper what moved last quarter and compare line by line.

The bottom row is your closing cash each week: opening cash plus cash in minus cash out, rolled forward. That single line is the whole point of the exercise.

The weekly rhythm

The forecast is not a document, it is a rhythm. Every Monday morning, do the same four things: roll it forward one week, replace estimates with actuals for the week just gone, update receipts and payments for the new week 13, and review the minimum-cash weeks.

The roll-forward is where the learning happens. Compare last week's forecast against actual cash movements. Where were you wrong, and why? That feedback loop is what turns the forecast from guesswork into a reliable instrument within two or three cycles.

Spotting the crunch before it hits

A 13-week forecast earns its keep by flagging problems early. Watch for three signals:

  • The single dip: one week drops below your minimum buffer, often where a VAT bill, a payroll run, and a big supplier payment land together. The fix is timing: can a payment shift a week, or can an invoice be collected early?
  • The slow bleed: the closing-cash line drifts down week after week. Nothing dramatic, just the business spending slightly more than it collects. This is the hardest to notice and the easiest to fix early, usually by cutting discretionary spend or tightening credit terms.
  • The cliff edge: cash runs out in week 11 with no recovery. That is a financing conversation, and you want it 11 weeks out, not 11 days out.

Set a cash floor for the business, the minimum you need to operate comfortably, and treat any week below it as a problem to solve now.

Common ways forecasts go wrong

The usual killers are optimism on receipts, missing irregular payments, and building it once and never updating it. Another subtle one: forecasting receipts from the sales pipeline rather than from invoice-and-collection reality. Pipeline deals close late; the forecast should assume they do.

Keep it in one simple spreadsheet, one row per week, with every figure traceable to a source. Complexity kills adoption. The director should be able to read the closing-cash line without an accountant translating it.

When to get help

Building the first forecast takes a solid half-day with your bookkeeper. Keeping it alive takes an hour a week. Many directors know they need this discipline but cannot sustain the weekly rhythm alongside everything else. That is a common reason small firms hand their finance rhythm to an outsourced team.

Finex Outsourcing, a Global Business Services firm, builds and maintains rolling cash forecasts for clients as part of a wider monthly finance routine. Their FP&A outsourcing services include 13-week cash forecasting, monthly management accounts, and the weekly rhythm that keeps both honest, so the crunch gets spotted in week one instead of week twelve.


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