Bank Summary Report

The Bank Summary report shows money coming in and going out of your bank accounts in Xero for a specified time period.

Reports are available from Reports > All Reports. 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.
Reports and budget role comparison

rep - bank summary.png

What can you see and do with the Bank Summary report?

Generate report

The Bank Summary is generated for the current month by default.

Enter or edit

rep - button - update.png

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

Choose options by which to re-run the report:

rep - bank - fields.png

From

The date to show the report from.

To

The date to show the report to.

More options

If you have set up tracking categories for this organisation, a 'More options' link will display so that you can filter the report based on your tracking options.

Tracking

Click the 'Fewer Options' link if you want to close these options and just use the standard date and comparison options.

  • Either one or both of the tracking categories you have set up will display.
  • By default, the report will not be filtered, you need to choose an option from the tracking category.
  • For each tracking category displayed, you can choose to view the report with no filter (i.e. just the default report) or by an option for each category.
  • Only transactions in the period of the report that match the tracking option(s) chosen will be included in totals.
  • If there are no transactions for the period or date range for the tracking option(s) you have chosen, the report will be empty.
  • There is no 'More options' link if you don't have tracking categories.

Set up tracking categories to monitor different areas of your business

Update

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

View transactions

Image showing bank accounts.

Transactions

Totals

Cash in and out of the bank accounts you have in Xero will display for the chosen period.

Only amounts that have passed through the bank account set up in Xero will be included in these totals. Spend and receive money transactions and transfers will show up right away, but invoice payments will not until they are marked on the invoice as paid or are reconciled.

If you are using multi-currency the report footnotes show the figures that were converted into your base currency for the purpose of reporting in one currency and at what rate the conversion rate occurred. They also show where the rate was taken from (i.e. whether it was an XE rate or a rate entered by a user). If there has been a foreign currency gain or loss in a foreign currency bank account, an additional column showing this will display. Find out more on how multi-currency reports in Xero work.

Select

Individual totals

Bank account name click

Click on the bank account name to view all transactions for that account.

Account details

Click on amount in bank accounts summary

Click on an amount to view the transactions that make up this amount.

bank summary amount details

The transactions displayed will be those that occur in the chosen bank account during the date range specified. Transactions are displayed using the Account Transactions Report.

rep - button - print.png

Export options

If you have the Adviser user role you will also be able to Save as Draft, or Publish this report and change the default PDF preferences. If you’re using Partner Edition your practice logo will display if your Principal has set it up.

Print

Print the report directly from your browser.

Export

Choose where you want to export the report to. You can either view it or save it once it's exported into the chosen format.

Excel

Open the report directly into Excel or save it to your computer and open it from there.

rep - bank - excel.png

PDF

Open the report directly as a PDF or save it to your computer and open it from there. Zero figures will show on the PDF as '-' and do not show decimal places so numbers are rounded for display purposes only. In many cases PDF amounts may not add up correctly due to rounding, but in Xero and other exported formats the calculations are correct.

Bank summary PDF report

Google Sheets

If you use Gmail, you can set up your account to access Google Sheets (Google's document viewer). You can then export the report to Google Sheets and edit, save or share it. You’re prompted to log into Gmail (if you're not already) and you’re prompted to confirm that Xero is a 'trusted' site each time you start a Google Sheets session.

Google

When you authenticate your connection to Google Drive and export to Google Sheets, a connection is made to your Xero account. You can break the connection at any time.

Disconnect Xero from Google Sheets

Google Help (Google website)