Cash Summary report
The Cash Summary reports the movement of cash into and out of your organisation for a chosen period. This report also includes credit notes applied to invoices and bills.
This report is also available as part of the management reports which you can access if you have the Adviser user role.
Management style reporting packages for month or year end
Other things you can do with this report:
Reports are available from Reports > All Reports. Your user role will determine whether you can see this report, and whether you can save and publish or just view it.
Reports and budget role comparison
If you are viewing a report produced by someone with the Adviser user role, you may see notes or a summary on the report. You may be able to
export, archive or edit the report, depending on your user role.
Reports and budget role comparison
By default, the Cash Summary is generated for the current month showing data for just that month.
Choose options by which to re-run the report:
Choose the month that you want to see cash transactions for.
Choose the number of months of data up until the report date you want to see (1, 2, 3, 6 or 12 months).
Choose how many periods you want to compare the chosen time block against. You can choose up to 11 periods back from the date of the report if you don't want to use the default 'Average' option.
Shows cash transaction totals including GST (they are displayed as GST exclusive by default).
Shows the total cash transactions in the chosen account for the financial year to date.
Show Income %
Shows the month or year total as a percentage of the total income (whether the total is for an income or expense account).
More optionsClick the 'More options' link to display fields to move Working Capital and filter the report.
Click the 'Fewer Options' link if you want to close these options and just use the date, period, comparison and display options.
Show Working Capital With
By default, transactions that have the 'current asset' or 'current liability' account type, display in the income or expense section of the report. You can change this to have these accounts display in the Non Operating Movements section of the report.
Filter by tracking
If you have set up tracking categories for this organisation, 'Filter by' fields will display so that you can filter the report based on your tracking options.
By default, the report will not be filtered, you need to choose an option from the tracking category.
Only transactions in the period of the report that match the tracking option(s) chosen will used to determine the totals and accounts displayed.
When the details of the report you want to run are entered or updated, click Update to re-generate the report.
If you're using multi-currency in Xero use the Compare Periods or Show Date Range tabs to display the report in a foreign currency.
Find out how multi-currency reports in Xero work
The number of columns displayed will depend on the report options chosen.
Only accounts where transactions occurred in any of the periods chosen will display, so you may not see every account from your chart of accounts in the report.
The 'Average' column shows the average total for the period chosen based on the financial year to date. For example, if the reporting period is a month the average will be for a month, if it's 3 months the average will be for that. If the first transaction in an account occurred after the start of the financial year then the average is based on that date.
The 'Variance' column only shows if you are comparing the month chosen with the Average and shows the percentage difference between what has been received or spent in that period and the period average.
Your financial year is specified by you in your financial settings. It's June by default unless you changed it when you set up Xero.
The GST Movements section of the report only shows if you are not already including GST in the totals reported.
The Non Operating Movements and Movements in Equity sections display only if transactions occurred in these types of accounts during the period of the report. Current asset and current liability transactions are included if you choose this option when you run the report.
Amounts that have passed through your bank accounts in Xero will be retrieved for this report. This includes spend and receive money transactions, transfers and payments for invoices, expense claims, and manual journals with the Cash basis option. This report also includes credit notes applied to invoices and bills.
Click on the account name to view the Account Summary report showing all transactions in that account regardless of the report date.
Click on the amount in the month or YTD column to view the Account Transactions report showing the transactions in that account for the period or financial year chosen that make up that amount.
To export the report:
Click Export, then select your preferred export option:
- PDF (printable format)
- Google Sheets
- Open, save or print the file as you need.