Cash flow forecasting for Xero: what Xero does, the add-ons, and how to keep a forecast current
Manoj Tutika · Published 16 November 2026 · Last checked 16 November 2026
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
Does Xero do cash flow forecasting?
Yes, within limits. Xero's cash flow dashboard projects your future cash position from the balances on your connected bank accounts, the invoices you are owed and the bills you have to pay, with their due dates, plus recurring transactions it predicts from your history. You can add an expected payment date to an overdue invoice and enter one-off amounts to model a scenario, such as a late customer or a large purchase.
How far it looks ahead depends on your plan. Xero UK lists a 60-day forecast on Grow, 90 days on Comprehensive and 180 days on Ultimate (checked 16 November 2026). At Xerocon London in July 2026 Xero also announced Cash Flow Actions, in beta, where its AI JAX builds plans to protect payroll, delay non-critical bills and bridge cash gaps.
For many small businesses that is enough. A finance team usually needs more: a rolling 13-week view that the FD signs off, payroll and tax payments on their real dates, and a forecast compared with what actually happened.
What goes into a forecast you can rely on?
A forecast is only as good as its inputs. Check each line against the books before you trust the total.
| Line | Where the number comes from | What to check |
|---|---|---|
| Opening cash | Bank balances in Xero | Every account reconciled to yesterday |
| Customer receipts | Aged receivables by expected date | Each customer's real payment habit, not the due date |
| Supplier payments | Bills to pay plus bills you expect | Rent, insurance and annual renewals not yet billed |
| Net pay | Payroll on payday | New starters, leavers and bonuses |
| PAYE and NIC | Payroll liability, paid by the 22nd of the next month | Student loan and other deductions |
| Pensions | Contributions due by the 22nd of the month after deduction | Employer and employee shares |
| VAT | Quarter's liability, usually due one calendar month and 7 days after the period ends | Direct debit timing |
| Loans and capex | Loan schedule and committed purchases | Covenants and facility headroom |
Which add-ons do UK Xero users choose?
Two add-ons that connect to Xero are built for this job. Facts below are from their own websites, checked on 16 November 2026.
- Float is short-term cash flow software. It connects to Xero or QuickBooks Online, syncs through the accounting platform every 24 hours, and offers a rolling 13-week forecast plus monthly forecasts up to three years, with scenarios you switch on and off. See Thred vs Float.
- Fathom is a reporting, analysis and forecasting platform. It builds management reports, tracks KPIs and produces three-way forecasts of profit and loss, balance sheet and cash flow, with consolidation and a portfolio view for accountants. See Thred vs Fathom.
Both are good at modelling. Neither fixes the books underneath, and a forecast built on a bank feed three weeks behind is a forecast of the past.
What does a 13-week forecast look like in pounds?
Take a UK company with about £3.4 million revenue, monthly payroll and quarterly VAT, starting the forecast with £182,000 in the bank. The FD wants at least £100,000 at all times.
| Line | Week 1 | Week 2 | Week 3 | Week 4 | Weeks 5 to 13 |
|---|---|---|---|---|---|
| Opening cash | £182,000 | £207,500 | £162,100 | £137,200 | £89,500 |
| Customer receipts | £64,000 | £58,000 | £49,000 | £71,000 | £612,000 |
| Supplier payments | -£38,500 | -£42,000 | -£36,500 | -£40,200 | -£351,000 |
| Net pay | £0 | £0 | £0 | -£78,500 | -£157,000 |
| PAYE and NIC | £0 | £0 | -£27,800 | £0 | -£55,600 |
| Pensions | £0 | £0 | -£9,600 | £0 | -£19,200 |
| VAT | £0 | -£61,400 | £0 | £0 | £0 |
| Closing cash | £207,500 | £162,100 | £137,200 | £89,500 | £118,700 |
Week 4 drops to £89,500 because the VAT quarter, PAYE and payroll land within three weeks of each other. The forecast shows it a month early, which leaves time to act: chase two large invoices due in week 3, move a £15,000 supplier payment to week 5 by agreement, or draw on the facility for a few days.
How do you keep the forecast current?
- Reconcile every bank account daily, so opening cash is right.
- Enter bills on arrival, and list the bills you expect but have not received.
- Set expected dates on overdue invoices from each customer's history, not the due date.
- Add payroll, PAYE, pensions and VAT as fixed lines on their due dates.
- Every Monday, drop the past week, add a new week 13 and compare last week's forecast with the actual bank movement.
- Explain every difference over £5,000, so the next forecast is better.
Days sales outstanding is the quickest lever on the receipts line. A two-day drop in DSO on £3.4 million of revenue brings forward about £18,600 of cash. For the method behind the weekly roll, read the 13-week cash flow forecast.
What do Thred's agents do with cash flow forecasting on Xero?
Thred is a team of AI agents that takes the recurring finance work off your desk, on the accounting software you already use. The Treasurer manages your cash. Ask for the 13-week view in chat and it builds it from the live numbers in your Xero organisation: reconciled balances, receivables by each customer's real payment habit, bills due and expected, payroll, PAYE, pensions and VAT on their dates. Every week it explains what moved and why.
The rest of the team keeps the inputs honest. The Bookkeeper keeps the record up to date, so opening cash is right. The Collector manages your receivables and moves the receipts line. The Payer manages your payables and times supplier payments. The Analyst monitors performance and variance against the forecast. On Xero, Thred's agent reads your organisation and creates and updates records, with each write shown for approval first. See Thred Layer.
Frequently asked questions
Does Xero do cash flow forecasting?
Yes. The cash flow dashboard in Xero projects your cash position from bank balances, invoices due, bills to pay and recurring transactions predicted from your history. You can add expected payment dates to overdue invoices and one-off amounts to test scenarios.
How far ahead does Xero forecast cash?
Xero UK lists a 60-day forecast on the Grow plan, 90 days on Comprehensive and 180 days on Ultimate, checked on 16 November 2026. For anything longer, or for a monthly view over several years, you need an add-on or a spreadsheet.
What is the best cash flow forecasting software for Xero?
It depends on the job. Float focuses on short-term cash, with a rolling 13-week forecast and monthly forecasts up to three years. Fathom combines management reporting with three-way forecasts of profit and loss, balance sheet and cash. If the forecast goes stale because the books are behind, fix the books first.
Can I build a 13-week cash flow forecast from Xero data?
Yes. Start from reconciled bank balances, take receipts from aged receivables by realistic payment date, supplier payments from bills to pay plus expected bills, and add payroll, PAYE, pensions and VAT on their due dates. Roll it forward every week.
Why is my Xero cash flow forecast wrong?
Usually because the inputs are stale. Unreconciled bank lines, bills not yet entered and invoices that customers always pay late all distort the projection. Reconcile daily, enter bills on arrival and set expected dates on overdue invoices.
Sources
- Xero UK, Cash flow forecasting and analytics (plans and horizons)
- Xero blog, Xerocon London 2026: Cash Flow Actions in beta (8 July 2026)
- Float, cash flow forecasting software (homepage)
- Fathom, reporting, analysis and forecasting (homepage)
- GOV.UK, Submit a VAT return: deadlines
- GOV.UK, Running payroll: reporting to HMRC
- The Pensions Regulator, Making contributions to your pension scheme
Read next
- AI cash flow forecasting: what AI adds to a 13-week forecast, with a worked £ example
- Thred vs Float: a Float alternative that keeps your cash view current from your Xero books
- Thred vs Fathom: a Fathom alternative where agents prepare the numbers, not only the report
- Month-end close for UK finance teams: a practical checklist
- Start your SME finance dashboard with free cash
- Cash flow statement: the direct and indirect method explained, with a worked example
Where Thred comes in
Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.
