Xero Cash Summary report: what each line means and how to read it

The Cash Summary report in Xero shows the money that actually went in and out of your bank accounts in a period, grouped by the account each payment was coded to. Income and expense accounts come first, so you can see what trading brought in. Below that are the other cash movements (drawings, loans, equipment) and the GST or VAT that passed through, and at the bottom how your opening bank balance became your closing one.

To run it, go to Reporting (Accounting > Reports in Xero’s older menu) and open Cash Summary (or type it into the report search). Pick the date range, add previous periods to compare if you want to see a trend, and click Update.

The one line to understand is Surplus (Deficit). It is income received minus expenses paid, before drawings, loan repayments, equipment and GST. If the surplus is healthy but the bank balance fell, the reason is in the sections underneath it, and the report tells you which one.

How the report is laid out

The headings below are the ones the report uses. Your rows are your own accounts, and the tax section says GST or VAT depending on where your organisation is set up.

Section	What is in it	The question it answers
Income	Money received, by revenue account (sales, other income)	How much did customers actually pay?
Less Expenses	Money paid, by expense and cost of sales account	How much did running the business cost in cash?
Surplus (Deficit)	Income less Expenses	Did trading bring in more cash than it used?
Plus Other Cash Movements	Money in or out on Balance Sheet accounts: drawings, owner funds, loans, equipment and other assets	Where did cash go that is not a running cost?
Plus GST (or VAT) Movements	GST or VAT collected and paid with each transaction, and payments to or refunds from the tax office	How much tax passed through the bank?
Net Cash Movement	The three above added together	Did the bank balance go up or down, and by how much?
Summary	Opening balance, plus net cash movement, equals closing balance	Does it tie back to the bank?

Two things make it different from the Profit and Loss:

• It is cash basis. An invoice shows up in Income only when the customer pays it, and a bill shows up in Expenses only when you pay it. When an invoice is paid, the payment is spread back to the accounts on the invoice, so you still see sales by account rather than one “payments received” line.
• Income and expenses are shown without GST or VAT. The tax part of each receipt and payment is pulled out into its own section. That keeps the trading lines comparable with the Profit and Loss, and it makes a big quarterly GST or VAT payment visible on its own line instead of hiding it in expenses.

A worked example: a good month and a falling bank balance

Made-up figures for October 2026 in an Australian commercial cleaning business that uses subcontractors. The owner’s Profit and Loss looked fine, but the bank balance went from $31,000 to $27,169. Here is the Cash Summary:

	October 2026
Income
Cleaning income	$46,000
Interest income	$40
Total Income	$46,040
Less Expenses
Subcontractors	$18,400
Cleaning supplies	$3,100
Motor vehicle expenses	$1,850
Rent	$2,200
Software subscriptions	$360
Bank fees	$90
Total Expenses	$26,000
Surplus (Deficit)	$20,040
Plus Other Cash Movements
Owner drawings	−$9,000
Vehicle loan	−$1,450
Plant and equipment (floor scrubber)	−$6,800
Total Other Cash Movements	−$17,250
Plus GST Movements
GST	−$6,621
Net Cash Movement	−$3,831
Opening balance	$31,000
Plus Net Cash Movement	−$3,831
Closing balance	$27,169

How to read it, top to bottom:

1. Trading was strong: a $20,040 surplus. Customers paid $46,040 and the running costs paid were $26,000. Nothing is wrong with the business itself this month.
2. Other cash movements took $17,250. Drawings of $9,000, a $1,450 vehicle loan repayment and a $6,800 floor scrubber. None of these is an expense on the Profit and Loss (the scrubber is an asset, and only its depreciation reaches the P&L over the next few years), which is why the owner’s profit did not warn them.
3. GST took $6,621 net. The line is three movements added together: $4,600 of GST collected from customers (10% of $46,000; bank interest has no GST), $3,271 of GST paid to suppliers ($2,591 on the expenses and $680 on the scrubber), and the $7,950 paid to the ATO for the July to September BAS. $4,600 − $3,271 − $7,950 = −$6,621.
4. So the bank fell $3,831. $20,040 − $17,250 − $6,621 = −$3,831. Trading covered the drawings, the loan and the scrubber with $2,790 to spare. The BAS payment is what tipped the month negative, and it comes round every quarter.

The useful conclusion for this owner is not “costs are too high”. It is that drawings plus a capital purchase plus a BAS quarter in one month are more than one month’s surplus. Next quarter, either the scrubber-sized purchases or the drawings move to a month without a BAS payment, or GST goes into a separate account as it comes in (how much to set aside for tax works out the amount).

Why the Surplus is not your net profit

Owners often expect Surplus (Deficit) to match the net profit on the Profit and Loss for the same month. It usually doesn’t, for four reasons:

• Timing. The P&L counts a sale when you invoice it; the Cash Summary counts it when the customer pays. In a month when customers paid slowly, the surplus is lower than profit; when old invoices are finally paid, it is higher. Who owes me money? shows how much is waiting.
• Bills not yet paid. A supplier bill dated this month is an expense on the P&L now, and in the Cash Summary only when it is paid.
• Depreciation. It reduces profit but no cash moves, so it is not in the Cash Summary at all. The cash for the asset shows in Other Cash Movements in the month you paid for it.
• Anything coded to a Balance Sheet account. Prepayments, stock bought and held, and loans all move cash without touching the P&L.

If the two are far apart month after month, the profit but no cash guide works through every cause, and the free profit but no cash explainer reconciles your own two numbers without needing Xero. A Profit and Loss switched to cash basis comes closer to the surplus, but still leaves out GST and the other cash movements (see cash vs accrual in Xero).

Cash Summary, Bank Summary or Statement of Cash Flows?

All three look back at cash that has already moved. They differ in how they group it.

Report	Groups cash by	Best for
Cash Summary	The account each payment was coded to (sales, each expense, drawings, loans, GST or VAT)	Seeing which income and cost lines drove the month, and how much went on things that are not running costs
Bank Summary	Bank account	Quick totals: opening balance, cash received, cash spent and closing balance for each account
Statement of Cash Flows	Operating, investing and financing activities	Whether the business funds itself or is funded by loans and owners (how to run and read it)

The Cash Summary is the most useful of the three for a monthly look, because it keeps the detail of the Profit and Loss and adds the cash that never reaches it. For a 12-month view, compare previous periods by month and read across the Surplus and Net Cash Movement rows: seasonal business cash flow shows what to do with a pattern of strong and weak months, and a cash flow chart makes it easy to see at a glance.

When the numbers look wrong

The Cash Summary only knows about bank accounts set up in Xero, and only about transactions that have been reconciled or entered. Check these before you trust it:

• Unreconciled bank lines. Anything still waiting in the reconcile screen is not in the report yet. Reconcile to the end of the period first.
• Transfers between your own accounts coded as income or expense. Moving $5,000 to savings should be a transfer, which leaves Net Cash Movement unchanged when both accounts are in Xero. Coded to an expense, it inflates Expenses and makes the surplus look $5,000 worse than it was.
• A card or payment account that is not in Xero. Spending on a credit card that is not set up in Xero is invisible, so expenses look lower than they were.
• Large amounts in Other Cash Movements you do not recognise. Usually a payment coded to a suspense, clearing or loan account by mistake. Click the amount to see the transactions behind it.
• Closing balance does not match the bank. Compare it with the bank balances on the Balance Sheet for the same date; if they differ, one of the points above is the cause (why Xero’s bank balance doesn’t match goes through them in order).

Common questions

What is the Cash Summary report in Xero? A report of the cash received and paid in a period, grouped by the account each transaction was coded to. It shows income received, expenses paid, the surplus or deficit between them, other cash movements such as drawings, loans and assets, GST or VAT movements, and how the opening bank balance became the closing balance.

Is the Cash Summary the same as the Statement of Cash Flows? No. Both use the same cash, but the Statement of Cash Flows groups it into operating, investing and financing activities, while the Cash Summary keeps your own account lines and puts GST or VAT in a section of its own. The net movement in cash for the period is the same on both.

Why is the Surplus (Deficit) different from my net profit? The Cash Summary counts income and expenses when money moves, not when you invoice or are billed, and it leaves out depreciation. Unpaid invoices, unpaid bills and depreciation are the usual gap. In the worked example the surplus was $20,040; the P&L would only match it if every invoice and bill in the month had been paid in the same month.

Why are my income and expenses lower than the amounts in the bank? The Cash Summary shows them without GST or VAT, and puts the tax in the GST or VAT Movements section. Add the two together and you get what went through the bank.

Where do owner drawings show? Under Other Cash Movements, with loans, owner funds introduced and asset purchases. They are not an expense, so they never reduce the surplus, but they do reduce the bank balance.

Can I see the Cash Summary month by month? Yes. Set the date range to one month and add previous periods to compare, and each month gets its own column. Reading the Surplus and Net Cash Movement rows across 12 months shows your strong and weak months.

Is the Cash Summary a forecast? No, it only covers cash that has already moved. For the next 30 days from invoices and bills already entered, use Xero’s short-term cash flow; for further ahead, a 13-week cash flow forecast.

Getting the answer every Monday instead

The Cash Summary answers “where did the cash go?” well, but only if you remember to run it and know which line to look at. ReportPilot reads your Xero figures and sends a short plain-English email every Monday: cash in the bank against the end of last month, roughly how many months it lasts if it has been falling, money owed to you that is past due and by whom, and bills due in the next two weeks against your cash. It does not reproduce the Cash Summary report itself. It asks Xero for read-only access, and there is a 14-day free trial with no card.