Report templates: change settings unique to the Statement of Cash Flows

Find out how to change settings unique to the Statement of Cash Flows report within a report template in My Xero (Partner Edition) or at the client level.

A standalone version of this report is also available from the Reports menu.

Statement of Cash Flows report

Before you start

Map your bank accounts to the one of the following report code so they appear in the cash and cash equivalents section of the report:

  • ASS.CUR.CAS
  • ASS.CUR.CAS.BAN
  • ASS.CUR.CAS.FLO

Merge debits and credits

  1. Click Edit Layout.
  2. Select the split (Dr Image showing Debit icon. or Cr Image showing Credit icon) report codes you want to merge. To select an entire group, select the check box next to the group name.
  3. Click Merge Debits / Credits.
If both parts of a split report code or account are in the same group, they are merged automatically.

Split debits and credits

  1. Click Edit Layout.
  2. Select the merged Image showing merged icon accounts you want to split. To select an entire group, select the check box next to the group name.
  3. Click Split Debits / Credits.

Display tax on operating activities as net or gross

Accounts mapped to a revenue or expense report code will display as tax inclusive by default. To change how tax will display for accounts mapped to a revenue or expense report code:

  1. Click Report Settings.

    Image of the Report Settings link.

  2. Select either Gross Tax on Operating Activities or Net Tax on Operating Activities.
  3. Click Update.

This is a cash basis report. If any figures are not appearing as you'd expect, it's worth checking journals. To edit an accrual-basis journal so it appears on this report, select the 'Show journals on cash basis reports' check box.

Manual Journals

Access the Account Movements report for an account

Click on a figure to access the Account Movements report for that account. The Account Movements report is only accessible through the Statement of Cash Flows report.

Customise the report using the layout editor

Click Edit Layout to open the layout editor and:

  • Add your own columns for tracking, notes or other custom options.
  • Rearrange accounts and groups.
  • Move accounts between groups.
  • Edit formulas.
  • Move columns around by clicking and dragging.