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

Cash Summary report

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

Generate the Cash Summary report

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:

Report options

Date

Choose the month that you want to see cash transactions for.

Period

Choose the number of months of data up until the report date you want to see (1, 2, 3, 6 or 12 months).

Compare with

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.

Include VAT

Shows cash transaction totals including VAT (they are displayed as VAT exclusive by default).

Show YTD

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 options

Click the 'More options' link to display fields to move Working Capital and filter the report.

Tracking

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.

Update

When the details of the report you want to run are entered or updated, click Update to re-generate the report.

View transactions

rep - cash - transactions.png

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 March by default unless you changed it when you set up Xero.

The VAT Movements section of the report only shows if you are not already including VAT