Cash Summary report

The Cash Summary reports the movement of cash into and out of your organization 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 Advisor 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 Advisor 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:

Fields

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 Sales Tax

Shows cash transaction totals including sales tax (they're displayed as tax 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 organization, '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 (fiscal) year is specified by you in your financial settings. It's December by default unless you changed it when you set up Xero.

The Sales Tax Movements section of the report only shows if you are not already including sales tax in the totals reported.

Sales tax section

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.

Optional

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.

Select individual transactions

Click on the account name to view the Account Summary report showing all transactions in that account regardless of the report date.

rep - cash - coa link.png

Account summary

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.

Select month or year to date amounts to view transactions report

Export your report

To export the report:

  1. Click Export, then select your preferred export option:

    • Excel
    • PDF (printable format)
    • Google Sheets
  2. Open, save or print the file as you need.