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.

Run the Cash Summary report

  1. In the Reports menu, select All Reports.
  2. Under Financial, click ... to expand the section if the report is hidden.
  3. Click Cash Summary.
  4. Select a Date and Period, then click Update to view your report.
Your user role will determine whether you can see this report, and if so, whether you can save and publish it or just view it.

Customise your report

More options

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

Tracking

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

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.

If you are viewing a report produced by someone with the Adviser user role, you may see notes or a summary on the report.

View transactions

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

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.

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 GST Movements section of the report only shows if you are not already including GST in the totals reported.

GST 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

You might also be interested in