Home / Guides / Cash flow forecasting in Xero

Cash flow forecasting in Xero

Xero's short-term cash flow projection shows your bank balance for the next 7 or 30 days, worked out from the balances of your bank accounts in Xero and the invoices and bills awaiting payment. Payments that are not entered as invoices or bills, such as VAT, PAYE and Corporation Tax, loan repayments and sales not yet invoiced, sit outside it, so a 13-week or 12-month forecast kept alongside Xero is needed to show them.

Short-term cash flow in Xero

Xero's help centre says every Xero organisation has the short-term cash flow projection. In the Reporting menu, select Short-term cash flow, choose the bank accounts to include, and set the projection time frame to Next 7 days or Next 30 days. The graph shows each day's invoices owed to you, bills to pay and projected balance. Under Projection breakdown, the summary view lists totals by contact and the table view lists each invoice and bill. You need the administrator or standard + reports user role to see the dashboard.

The help centre sets out what the projection uses.

  • Included: bank balances in Xero, amounts owing on invoices and bills awaiting payment, one-off and repeating invoices and bills, and reimbursable expense claims.
  • Left out: credit notes, transfers, batch payments and batch receipts.
  • Overdue items: adding an expected payment date to each overdue invoice, and a planned payment date to each overdue bill, improves the projection. The Suggested actions panels on the dashboard do this in bulk, and Xero copies the dates onto the original invoices and bills.

Xero Analytics Plus

Where the subscription includes Xero Analytics Plus, Xero's help centre says the projection can run for the next 7, 30, 60 or 90 days. It adds upcoming money in or out that you enter by hand, and predictions. Predictions come from the last three months of reconciled transactions that repeat weekly, fortnightly or monthly, for consistent amounts, from the same bank account, on a regular date, with the same contact and account. At least three months of history is needed before predictions appear. Payroll can be predicted if it is reconciled as spend money transactions or bills and is regular in amount and timing; otherwise it can be added as an upcoming money out amount.

Xero's UK pricing page lists the cash flow forecast at 30 days on the Ignite plan, 60 days on Grow, 90 days on Comprehensive and 180 days on Ultimate.

What the Xero projection leaves out

The projection works from what is in the ledger. A payment that is never entered as a bill, and that does not repeat on a weekly, fortnightly or monthly pattern, does not appear in it.

  • VAT. GOV.UK sets the deadline for the return and the payment at one calendar month and 7 days after the end of the VAT period. A quarterly payment does not fit the repeat patterns Xero predicts from.
  • PAYE and National Insurance. GOV.UK says monthly payers pay by the 22nd of the next tax month, or make sure a cheque sent by post reaches HMRC by the 19th.
  • Corporation Tax. For taxable profits up to £1.5 million, GOV.UK puts the payment at 9 months and 1 day after the end of the accounting period. It appears in a 30-day view only in the month it is paid, and only if someone enters it.
  • Payroll timing where wages are not reconciled as regular spend money transactions or bills, along with bonuses and overtime that change the amount.
  • Loan and hire purchase repayments that are not entered as bills or picked up as a monthly prediction.
  • Sales not yet invoiced, such as work in progress, confirmed orders and retentions due on completion.
  • Seasonality. A 30-day view taken in a quiet month shows nothing of the busy month after it, or of the stock and wages paid out before the busy month starts.

Worked example with VAT and PAYE

On 1 May, a company's 30-day projection in Xero shows the balance staying above £30,000 all month. Its VAT quarter ended on 31 March, so VAT is due by 7 May, and PAYE for the tax month to 5 May is due by 22 May. Neither has been entered in Xero as a bill.

Bank balance to 24 May

Bank balance in Xero on 1 May£41,600
Customer invoices due 1 to 24 May+£88,300
Supplier bills due 1 to 24 May−£95,700
Xero projected balance on 24 May£34,200
VAT for the quarter to 31 March, due by 7 May−£21,400
PAYE and National Insurance for the tax month to 5 May, due by 22 May−£15,900
Balance on 24 May with both payments−£3,100

The figures are invented for this example. The due dates follow the GOV.UK rules for VAT and PAYE.

Xero shows £34,200 at the end of the week of 18 to 24 May. With the VAT and PAYE paid, the account is £3,100 overdrawn that week. A 13-week forecast prepared on 1 May shows the shortfall three weeks ahead, in time to chase two invoices, move a supplier payment back a week or agree an overdraft limit with the bank.

Building a 13-week forecast alongside Xero

A 13-week forecast runs week by week for a quarter, starting from the bank balance in Xero. Take the figures Xero holds and add the payments it leaves out.

  • Opening balance: the reconciled balance of each bank account in Xero.
  • Receipts: the Aged Receivables Summary, with each invoice placed in the week the customer pays in practice, plus sales you expect to invoice and collect within the 13 weeks.
  • Payments: the Aged Payables Summary by due date, plus payroll on its pay dates, VAT, PAYE, Corporation Tax, loan repayments, rent and any dividends.
  • Closing balance for each week, set against the overdraft limit and the lowest balance you want to hold.

Each week, put the actual receipts and payments next to the forecast, find out why any line differs, then add a new week thirteen. The guide to the 13-week cash flow forecast covers the layout line by line.

A 12-month forecast for the year ahead

A 12-month forecast runs month by month from the budget. It shows seasonal dips, the Corporation Tax payment, loan repayments ending or starting, and the effect of hiring staff or buying equipment. Keep both: the 13-week forecast for the next quarter's payments, and the 12-month forecast for the year.

Buzz prepares a budget and a 12-month cash flow forecast together for £1,200 + VAT once. Business Pulse keeps a rolling 12-month forecast up to date each month, from £375 a month + VAT on top of the accounts fee. Buzz is a Xero Gold Partner, and the Xero page covers setting up a ledger so the projection in Xero holds every invoice and bill.

Action this week

Download the 13-week cash flow forecast template and fill in the first four weeks.

  • Enter today's reconciled bank balance from Xero.
  • Copy the invoices and bills due in the next four weeks from the table view of the short-term cash flow projection.
  • Add the next VAT payment, the next PAYE payment and each payroll date.
  • Add expected payment dates to overdue invoices in Xero, so the projection and the template agree.

If any week closes below zero, decide this week which invoices to chase, which payments to move and whether to speak to the bank.

Questions

Does Xero do cash flow forecasting?

Xero has a short-term cash flow projection that every organisation can use, found under Short-term cash flow in the Reporting menu. Xero's help centre says it projects the bank balance for the next 7 or 30 days from the balances of your bank accounts in Xero and the invoices and bills awaiting payment. With Xero Analytics Plus, the projection can run further ahead and adds predictions based on the last three months of regular reconciled transactions, plus amounts you enter by hand. It does not show payments that are never entered as bills and do not repeat on a regular pattern, such as quarterly VAT or Corporation Tax. A 13-week forecast kept alongside Xero covers those, and the 13-week template is a starting point.

How far ahead does Xero's cash flow projection go?

Xero's standard short-term cash flow projection runs for the next 7 or 30 days, according to Xero's help centre. With Xero Analytics Plus, the help centre says it can run for the next 7, 30, 60 or 90 days. Xero's UK pricing page lists the cash flow forecast by plan: 30 days on Ignite, 60 days on Grow, 90 days on Comprehensive and 180 days on Ultimate. Even the longest of these works from invoices, bills and regular transactions already in Xero, so payments not yet entered are missing from it. For a full quarter, keep a 13-week forecast set out week by week. For the year ahead, a 12-month forecast built from the budget shows seasonality, Corporation Tax and loan repayments.

Does Xero's cash flow projection include VAT and PAYE payments?

Xero's cash flow projection includes VAT and PAYE payments only if they are entered as bills awaiting payment, or added by hand as upcoming money out in Xero Analytics Plus. The projection works from bank balances, invoices and bills, and in Analytics Plus from predictions of transactions that repeat weekly, fortnightly or monthly. Quarterly VAT does not fit that pattern. GOV.UK sets the VAT deadline at one calendar month and 7 days after the end of the VAT period, and PAYE for monthly payers is due by the 22nd of the next tax month. Enter both in a 13-week forecast as soon as the amounts are known. In the worked example, the two payments turn a projected £34,200 into an overdraft of £3,100.

Should I use a 13-week or a 12-month cash flow forecast?

Use both: a 13-week forecast for the payments due in the next quarter, and a 12-month forecast for the shape of the year. The 13-week forecast is set out week by week from the bank balance in Xero, the aged receivables and payables, payroll dates and tax payments, and is updated every week against what happened. It shows a week where the balance falls below zero in time to act. The 12-month forecast is set out month by month from the budget and shows seasonal dips, the Corporation Tax payment and the effect of hiring or buying equipment. Buzz prepares a budget and 12-month cash flow forecast together for £1,200 + VAT once.

How can I make Xero's cash flow projection more accurate?

Reconcile the bank regularly and give every overdue invoice an expected payment date and every overdue bill a planned payment date. Xero's help centre lists these as the ways to improve the projection, and dates added on the dashboard are copied onto the original invoices and bills. Enter supplier bills when they arrive, so they appear in the projection on their due date. With Xero Analytics Plus, the help centre also advises reconciling with the correct account code and contact, and making recurring payments on the same day each week or month, so Xero can predict them. Even with all of that in place, payments that are never entered as bills stay out of the projection, so keep a 13-week forecast alongside it.

13-week cash flow forecast template

An Excel workbook with receipts and payments for 13 weeks, the closing balance and the low point worked out, and an example filled in with invented figures.

  1. 1How to use
  2. 2Forecast, blank
  3. 3Example, filled in

Get the template

Excel workbook, three sheets.

More guides

Cash flow forecasting

How to build a 12-month forecast and keep it up to date.

How to read a cash flow forecast

What each line means and where a tight month shows up.

Why a profitable business runs out of cash

Profit is counted when you invoice and cash moves when you are paid. Where the difference goes, how much cash you need, and ways to release it.

How to reduce debtor days

How to work out debtor days, the steps that bring them down, from payment terms to a weekly chasing routine, and the cash a lower figure releases.

Charging interest on late payments

Statutory interest at 8% above base rate, the fixed sums of £40, £70 and £100, when the late payment law applies, how to claim and how to word your terms.

Setting aside money for VAT, PAYE and Corporation Tax

When VAT, PAYE and Corporation Tax are due, how to work out what to move to a tax account each month, and a worked example for a limited company.

CIS deductions and a builder's cash flow

How CIS deductions of 20%, 30% or nothing reduce what a subcontractor banks on each invoice, HMRC deadlines, and gross payment status.

Outsourced credit control and how it works

What an outsourced credit controller does each week, how it runs in your Xero, what it costs against employing one, and the cash it releases.

The 13-week cash flow forecast

How to build a 13-week cash flow forecast, update it every Monday and act on it, with payroll, PAYE, VAT and Corporation Tax in the right weeks.

Month-end close for a small business

How to close the books by working day 10: the reconciliations, accruals and prepayments, the review, and what the management accounts should show.

Debtor control and getting paid faster

Payment terms, invoicing, a chase sequence by day, debtor days, and statutory late payment interest and compensation at the rates on GOV.UK today.

The monthly KPI pack and board pack

The 8 to 12 numbers an owner-managed business should see every month, how to read them, and what a monthly board pack contains, with a worked example.

13-week cash flow forecast template

A free Excel template for the next 13 weeks of receipts, payments and bank balance.

Sample board pack

A six-page monthly board pack to download.

Management accounts explained

The contents of a monthly management pack, and how to read it.

KPIs to check every month in a small business

The KPIs an owner-managed business checks each month, how to set targets, leading and lagging measures, and a worked monthly KPI sheet.

Sample board pack

A six-page monthly board pack to download.

Gross margin explained

What gross margin is, how it differs from mark-up, how to calculate it, what moves it and why to check it monthly, with a worked example of the confusion.

Working capital explained

What working capital is, how to calculate it from a balance sheet, the working capital cycle in days, why growth uses cash, and a worked example.

Budget against actual variances explained

How to compare each month's results with the budget, tell favourable from adverse variances, split price from volume and decide which ones to act on.

What management accounts cost and include

Management accounts from £375 a month quarterly or £499 monthly + VAT: what a monthly set contains, what the owner provides and when it should arrive.

Management accounts for a construction company

Management accounts for builders and contractors: work in progress, retentions, CIS deductions, the VAT reverse charge and margin by contract.

Setting up monthly management reports in Xero

How to set up monthly management reports in Xero: the ledger work first, then the Management Report pack, budget variance, tracking and commentary.

How to price for profit

What a price change does to profit, worked through.

Turnover up, profit down

Why sales can rise while profit falls, and where to look.

How to set an annual budget for your business

Six steps to next year's budget, a month-by-month worked example, seasonality, wage rises from April 2026, and reforecasting during the year.

Break-even point explained

How to work out break-even in sales and in units from fixed costs, variable costs and contribution margin, with a worked example and the margin of safety.

What a price rise does to profit

How a small price rise flows straight to profit, how many customers you could lose and still be better off, and how much more you must sell after a discount.

Job costing for small businesses

How to cost each job with materials, labour at a loaded hourly rate, subcontractors and overheads, compare quoted with actual, and value work in progress.

What does a part-time finance director do?

What a part-time or fractional finance director does, the first three months, how it differs from a financial controller, and what one costs.

Finance manager or financial controller?

What a finance manager does, what a financial controller adds, the month-end close, deadlines, how to choose, and what each costs to employ or outsource.

Month-end close checklist

The steps to close the books within five working days: bank, ledgers, accruals, prepayments, payroll, VAT, stock, fixed assets and a final review.

In-house or outsourced bookkeeper?

What employing a bookkeeper costs once National Insurance, pension and holiday cover are added, what an outsourced service covers, and how to switch.

How to run a monthly board meeting

Who attends a board meeting in an owner-managed company, what goes in the board pack, a standard agenda, the decisions and actions log, and the minutes.

Replacing a bookkeeper who has left

Keeping payroll, VAT and the books running when your bookkeeper goes.

The cost of employing a financial controller

What a finance manager, financial controller and finance director cost to employ in 2026 to 2027, with National Insurance and pension, against Buzz fees.

How much a part-time finance director costs

A part-time finance director from Buzz costs £2,000 + VAT a month with the finance team included, against £128,508.40 a year to employ one.

Fractional CFO, part-time FD or interim FD

What a fractional CFO, a part-time finance director, an outsourced CFO and an interim FD each are, and how to choose one for your business.

What a bank wants to see in a business plan

What a lender reads in a business plan: the amount and purpose, ability to repay, forecasts, assumptions, security, guarantees and the people running it.

Talk to us

Tell us about the business and what is taking up your week, or book 30 minutes with Peter. He will come back within 48 hours with the level that fits and a fixed monthly fee.

Book a call

Or call

07476 989568

Accreditations and partners

AAT Licensed Accountant
ICPA
FreeAgent Partner
Equity & General
All In Place
Xero Gold Partner
Swoop
The Gap
Institute of Advisors