A cash flow forecast is a map of what your bank balance will look like in the weeks and months ahead. Start today with a 13 week direct model, or a simple monthly rolling template if your business runs on longer cycles. GOV.UK guidance treats cash forecasts as a core part of business planning, and building the habit now protects you from the timing gaps that catch outgrowing businesses.
TL;DR:
- Using a 13 week rolling direct forecast helps identify cash shortfalls weeks in advance, allowing timely tactical responses.
- Maintaining current bank feeds and AR data improves forecast accuracy and reduces errors caused by manual data entry.
- Setting a minimum cash buffer equal to at least one bad week of cash flow prevents sudden crises and gives space for early action.
- Combining weekly updates on short-term cash flow with monthly strategic forecasts ensures alignment between tactical moves and long-term planning.
- Engaging a dedicated accountant and using cloud accounting tools enhances forecast reliability by catching seasonal dips and payment delays.
Table of Contents
- Cash flow fundamentals: essential terms and why timing matters
- Forecasting methods: when to use 13 week, monthly and longer horizons
- Building a working forecast: data, assumptions and cadence
- Tools, templates and where to source reliable data
- Analyse the forecast and act: tactical and structural responses
- Improving accuracy: common errors and fixes
- How a dedicated accounting partner helps
- Why the weekly habit matters more than the model
- How eAccounts supports your forecasting
- Sources
- FAQ
Cash flow fundamentals: essential terms and why timing matters
A forecast tracks five things: the opening balance you start with, the inflows landing in your account, the outflows leaving it, the net cash for the period, and the ending balance you carry into the next one. That ending balance becomes next period’s opening balance, which is what makes forecasting a rolling exercise rather than a one off spreadsheet.
Profit and cash are not the same thing. You can invoice a client for £10,000 and record it as revenue this month, but if they pay in 60 days, your bank balance does not move until then. Payroll, tax and rent still leave on schedule regardless of when customers pay you, which is why a business can be profitable on paper and still run out of money.
That risk is exactly why a minimum cash floor matters: a buffer below which you never want your balance to fall.
- Opening balance: the cash you hold at the start of the period.
- Inflows and outflows: what comes in from sales and collections, and what goes out on payroll, rent, tax and suppliers.
- Net cash and ending balance: the difference between inflows and outflows, carried forward as next period’s starting point.
Weak forecasting compounds these risks. EY’s research on cash forecasting found that poor forecasting raises costs and reduces a business’s resilience when conditions tighten.
Forecasting methods: when to use 13 week, monthly and longer horizons
Different horizons answer different questions, and most small businesses eventually need more than one running at once.
- 13 week rolling direct method: tracks actual bank receipts and payments week by week, replacing forecast figures with real numbers as each week closes. This is the method restructuring advisors favour because it surfaces a shortfall weeks before it hits the account, giving you time to act rather than react.
- Monthly rolling forecast: useful once the immediate danger has passed, giving a wider view for planning stock orders, hiring or seasonal spending without the weekly admin overhead.
- 12 month forecast: the strategic layer, built on assumptions rather than confirmed receipts, used for lending applications, investor conversations and annual budgeting.
The direct method, which lists actual cash receipts and payments, suits short rolling windows because every line traces back to a real transaction. The indirect method, which starts from profit and adjusts for non-cash items, suits the 12 month view because it connects more naturally to your accounts and budget. A practical routine runs the 13 week model weekly and the 12 month model monthly, so the tactical and the strategic never drift apart.
Building a working forecast: data, assumptions and cadence
Building a forecast that you can actually trust starts with getting the basics right, then keeping them right every week.
- Confirm your opening balance by reconciling it against your actual bank feed, not a figure from memory or an old spreadsheet.
- List your inflow rows: expected accounts receivable collections, new sales, and card or platform receipts, each on its own line.
- List your outflow rows: payroll, tax payments, rent, and vendor payments, scheduled on the date they actually leave the account.
- Convert AR ageing into expected receipts by applying each customer’s real payment pattern rather than assuming every invoice pays on terms.
- Set a minimum cash floor and write down every assumption behind it, including payment delays and seasonal dips, so you can check them later.
- Update weekly: replace the week that just closed with actuals, re-forecast the remaining weeks, and roll the whole model forward by one week.
That last step is what makes the model reliable. A forecast built once and left untouched degrades within a month, because customer behaviour, supplier terms and your own spending all shift.
Pro Tip: Keep a running note of every assumption you change, week by week: it turns “why was I wrong last time” into a pattern you can actually fix.
Tools, templates and where to source reliable data
A spreadsheet is enough when you have one bank account, a handful of recurring payments and the discipline to update it weekly. Once you are juggling multiple accounts, ecommerce platform payouts, or a large AR ledger, integrated accounting software earns its keep by pulling bank feeds and ageing reports automatically instead of you retyping them.
Whichever route you choose, look for the same core features, including a comprehensive Finance Overview with real-time financials that integrates your P&L, balance sheet and cash flow projections.
- Live bank feeds so opening balances never rely on memory.
- AR and AP ageing built in, so collections and payments reflect real customer and supplier behaviour.
- A rolling horizon that shifts forward automatically rather than needing a new tab each week.
- Variance reporting that flags where last week’s forecast missed and by how much.
For a 13 week template, structure it as one column per week with inflow and outflow rows beneath, ending in a running balance. For a 12 month template, use monthly columns and build in seasonal assumptions from the start. Feed both from the same four sources every time: your bank feed, AR ageing, purchase ledger and payroll schedule.
Analyse the forecast and act: tactical and structural responses
A forecast is only useful once you act on what it shows. The timing of a projected breach tells you what kind of action to take.
- Inside four weeks: treat it as tactical. Chase overdue invoices, delay discretionary spending, or arrange short-term credit to bridge the gap.
- Between four and thirteen weeks: treat it as structural. Renegotiate supplier payment terms, reschedule non-urgent projects, or revisit pricing and hiring plans.
- Beyond a bad-week floor: IMF practitioner guidance recommends setting your minimum cash floor at roughly one bad week, or a multiple of fixed costs, so a breach reads as an early warning rather than a crisis.
Sharing the forecast itself strengthens negotiations. Lenders and suppliers respond better to a business that can show its numbers than one asking for goodwill on faith, and a clear weekly model with documented assumptions gives you a stronger position when asking for extended terms or additional facilities.
Pro Tip: Bring your 13 week model to a supplier renegotiation instead of a verbal request: showing the actual weeks under pressure makes the ask concrete and harder to refuse.
Improving accuracy: common errors and fixes
Forecasts usually go wrong in predictable ways: overly optimistic collection timing, tax payments left off the schedule entirely, capital spend ignored until it lands, or a floor set at zero with no buffer at all.
- Use historical payment behaviour, not invoice terms, to predict when customers actually pay.
- Reconcile weekly against the bank feed so drift never compounds across months.
- Keep AR and AP genuinely current, updated the same day an invoice is raised or paid.
- Document every assumption so you can trace exactly why a forecast missed.
Watch days sales outstanding, days payable outstanding and inventory turnover: each one directly shortens or extends your cash runway. When the gaps get too wide to track alone, or the numbers stop making sense, that is the point to bring in professional help rather than keep patching a model that has outgrown a spreadsheet.
How a dedicated accounting partner helps
Automated bookkeeping and a live Xero feed remove the manual reconciliation that most forecasts fail on, and a dedicated accountant catches the tax payments and seasonal dips a spreadsheet alone tends to miss. eAccounts pairs each client with a dedicated accountant for ongoing support, alongside cash-flows and forecasts services built on cloud accounting tools. Onboarding typically starts with a consultation to map your current bookkeeping before the forecast model goes live.
Why the weekly habit matters more than the model
The model matters less than the habit of updating it. Review your 13 week forecast every week, take one concrete action from what it shows, and pair that tactical view with a monthly look at the 12 month picture so short-term fixes never lose sight of the longer trend.
— Kris
How eAccounts supports your forecasting
Running a reliable forecast takes bookkeeping that stays current, not just a good template. eAccounts handles that groundwork through Xero online accounting and bookkeeping services, with cash-flows and forecasts built in and a dedicated accountant reviewing the numbers alongside you.
- Xero online accounting keeps your bank feed and ledgers current so forecasts start from real numbers.
- Dedicated accountant support means someone reviews your assumptions, not just your bookkeeping.
- Cash-flows and forecasts as a service removes the weekly admin without losing the weekly discipline.
If you would rather hand the forecasting groundwork to someone else, book a consultation and choose a package to see what fits your business.
Sources
- Guide to financial management for SMEs (UK government)
- Cash forecasting: Difficult and more urgent than ever | EY
- The 13-week rolling cash flow forecast: A direct-method guide for small businesses
- IMF practitioner guidance on cash buffers
- AI-driven cash flow forecasting in ERP systems (research paper)
FAQ
What is a cash flow forecast used for?
A cash flow forecast projects the cash coming in and out of your business over a set period, showing your expected bank balance at each point. Small businesses use it to spot shortfalls before they happen and to plan spending, hiring and supplier payments with confidence.
How far ahead should a small business forecast?
Most small businesses benefit from running two horizons at once: a 13 week rolling forecast for tactical decisions, and a 12 month forecast for strategic planning. Practitioner guidance treats the 13 week window as the most actionable because it tracks actual receipts and payments rather than accrual estimates.
What is the difference between the direct and indirect method?
The direct method lists actual cash receipts and payments as they occur, which suits short rolling forecasts because every figure ties to a real transaction. The indirect method starts from profit and adjusts for non-cash items, which suits longer strategic forecasts tied to your accounts.
How much cash buffer should a small business keep?
IMF practitioner guidance suggests setting a minimum cash floor around one bad week of cash flow, or a multiple of fixed monthly costs, rather than leaving the floor at zero. Treating a breach of that floor as an early warning, rather than a crisis, gives you time to act.
Can accounting software improve forecast accuracy?
Yes: software that pulls live bank feeds and AR ageing removes the manual errors that undermine spreadsheet forecasts. Research on AI-driven forecasting shows these gains depend on clean, consistent bookkeeping data being in place first.
