Thred

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.

Book a demo

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.

The lines of a 13-week cash flow forecast and where to check them
LineWhere the number comes fromWhat to check
Opening cashBank balances in XeroEvery account reconciled to yesterday
Customer receiptsAged receivables by expected dateEach customer's real payment habit, not the due date
Supplier paymentsBills to pay plus bills you expectRent, insurance and annual renewals not yet billed
Net payPayroll on paydayNew starters, leavers and bonuses
PAYE and NICPayroll liability, paid by the 22nd of the next monthStudent loan and other deductions
PensionsContributions due by the 22nd of the month after deductionEmployer and employee shares
VATQuarter's liability, usually due one calendar month and 7 days after the period endsDirect debit timing
Loans and capexLoan schedule and committed purchasesCovenants 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.

Worked 13-week cash flow forecast for a UK company on Xero
LineWeek 1Week 2Week 3Week 4Weeks 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?

  1. Reconcile every bank account daily, so opening cash is right.
  2. Enter bills on arrival, and list the bills you expect but have not received.
  3. Set expected dates on overdue invoices from each customer's history, not the due date.
  4. Add payroll, PAYE, pensions and VAT as fixed lines on their due dates.
  5. Every Monday, drop the past week, add a new week 13 and compare last week's forecast with the actual bank movement.
  6. 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

  1. Xero UK, Cash flow forecasting and analytics (plans and horizons)
  2. Xero blog, Xerocon London 2026: Cash Flow Actions in beta (8 July 2026)
  3. Float, cash flow forecasting software (homepage)
  4. Fathom, reporting, analysis and forecasting (homepage)
  5. GOV.UK, Submit a VAT return: deadlines
  6. GOV.UK, Running payroll: reporting to HMRC
  7. The Pensions Regulator, Making contributions to your pension scheme

Read next

Where Thred comes in

Thred Layer

Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo