What is cashflow forecasting?
A cashflow forecast predicts how much money will come into and go out of your business over a future period, typically 4 to 12 weeks. It tells you whether you will have enough cash to pay your bills, your staff, and yourself. It is the single most useful financial tool a small business owner can have.
Weekly Pulse · Monday 10 Apr 2026Hi Sarah — here's where things stand this week.
Cash Position
£31,800
Revenue
£17,400
Expenses
£14,200
Invoices · Owed to you
£8,400
Overdue · 3
£4,490
Outstanding · 2
£12,890
Total receivable
Bills · You owe
£1,200
Overdue · 1
£3,000
Due to pay · 4
£4,200
Total payable
Your CFO's take
Cash is healthy at £31,800 — that's around 8 weeks of cover at your current run rate. Riverside Events owes you £4,200 now 29 days overdue — chasing that today would meaningfully improve your position. Marketing spend jumped 47% this month; worth reviewing whether the ROI justifies continuing at this level.
CFO Pal · cfopal.co.uk · hello@cfopal.co.uk
Cashflow Forecast
12-week rolling forecast with budget tracking
Current Cash
£31,800
Apr 26
Cash In vs Out
-£3,400
spent more than received
Budget Pace
1 over pace
5 of 6 categories on track
Spend vs Budget
£27,220 / £27,500
£280 underCash Flow Overview
| Period | Jan | Feb | Mar | W/C 14 Apr | W/C 21 Apr | W/C 28 Apr |
|---|---|---|---|---|---|---|
| Opening Balance | £42,000 | £38,500 | £35,200 | £31,800 | £30,400 | £28,900 |
| Revenue | £18,200 | £16,800 | £17,400 | £4,100 | £4,100 | £4,100 |
| Staff Costs | £9k | £9k | £9k | £2k | £2k | £2k |
| Facilities & IT | £3k | £3k | £3k | £711 | £711 | £711 |
| Marketing & Sales | £1k | £2k | £3k | £415 | £415 | £415 |
| Total Cash Out | -£21,700 | -£20,300 | -£21,800 | -£5,500 | -£5,600 | -£5,300 |
| Net Cash Flow | -£3,500 | -£3,500 | -£4,400 | -£1,400 | -£1,500 | +£1,800 |
| Closing Balance | £38,500 | £35,200 | £31,800 | £30,400 | £28,900 | £27,100 |
Cash projected to drop below £20,000 threshold in week 10. 3 overdue invoices totalling £8,400 — recommend chasing today.
Why cashflow forecasting matters
Profit and cash are not the same thing. A business can be profitable on paper and still run out of cash. This happens when money is tied up in unpaid invoices, stock, or when large expenses land before revenue comes in. A cashflow forecast gives you advance warning so you can act before problems arrive.
Most UK small businesses that fail do not fail because they are unprofitable. They fail because they run out of cash. A forecast that looks 8 to 12 weeks ahead gives you enough time to chase overdue invoices, delay a non-essential purchase, or arrange short-term funding before the gap becomes a crisis.
What a cashflow forecast includes
A basic cashflow forecast has three columns for each week or month: money in, money out, and the running bank balance. Money in includes customer payments, refunds you are owed, and any other income. Money out includes supplier payments, wages, rent, tax, loan repayments, and everything else that leaves the account.
The running balance tells you the projected cash position at the end of each period. If that number goes negative at any point, you have a problem coming and you now know exactly when it will hit.
How to build a cashflow forecast
You can build a basic forecast in a spreadsheet. Start with your current bank balance. For each of the next 12 weeks, list every payment you expect to receive (based on invoices sent and their due dates) and every payment you expect to make (rent, wages, suppliers, subscriptions, tax). The difference between the two gives you your projected balance.
The problem with doing this manually is that it takes time, it goes stale quickly, and it relies on you remembering to update it. Most business owners build a forecast once, update it for a week or two, and then stop. By the time they need it, the numbers are wrong.
How CFO Pal automates cashflow forecasting
CFO Pal connects to your Xero, QuickBooks, or Sage account and builds your cashflow forecast automatically. It pulls your real invoices, real expenses, and real bank data, then projects your cash position 4, 8, and 12 weeks ahead. No spreadsheet. No manual updates. The forecast refreshes every time your accounting data syncs.
If the forecast shows your cash dropping below a threshold you set, CFO Pal sends you an alert by email, SMS, or WhatsApp before the problem arrives. That is the difference between reacting to a crisis and preventing one.
See your cashflow forecast now
Connect your Xero, QuickBooks, or Sage account and CFO Pal builds your forecast automatically. No spreadsheets.
Connects to Xero, QuickBooks & Sage · UK data residency · No card required