Account Transactions report (New)

The Account Transactions report displays transactions coded to one or multiple accounts in your chart of accounts.

We have improved the Account Transactions report. It replaces the previous Account Transactions report that you may be familiar with. You will still need to run the previous Account Transactions report if you want to be able to see multi-currency account transactions in their original currency.

Image of the Account Transactions report.

Access and run the improved Account Transactions report

  1. Go to Reports, then click All Reports.
  2. Under Accounting, click Account Transactions (New).
  3. Select one or multiple accounts from your chart of accounts.
  4. Select a date range, then click Update to view your report.

    Image of the date range options.

Subtotals and totals on the report

The report will have subtotals for each account you have selected. You can group and subtotal by something other than account when you refine your report's settings.

Amounts in the Total row are a mathematical sum of the subtotals within each column, regardless of debit and credit values.

Refine your report's settings

Click Report Settings to refine your report.

Image of the Report Settings link.

Accounting basis

  • Accrual accounting basis
  • Choose Accrual to display revenue earned and expenses that occurred during the date range you selected.

  • Cash accounting basis
  • Choose Cash to display revenue received and expenses paid during the date range you selected. For example, bill or invoice payments, spend or receive money transactions.

Show or hide decimals

Numbers will show to 2 decimal places by default.

To show only round numbers, click to clear the Show decimals checkbox.

Group data and select columns to display on the report

Select an option from Group By to group and subtotal information on the report. Select None for no groups.

Select checkboxes for columns you wish to show on the report. Clear a checkbox to hide a column.

Apply filters

Click Add a filter and select a column to filter by, then enter or select details.

As you add more filters, the report displays results based on all your filters combined.

When you update the report, the filters show at the top in a text block you can edit or delete.

Edit, move or delete text blocks

Click Update to run and view

After you've made your choices, click Update to close Report Settings and view your report.

View your results

ColumnDescription
Date - accrual basis

Bills, invoices and credit notes display if the date they were created in Xero falls within your selected period.

Expense claims display if the date they were approved falls within your selected period.

Date - cash basis

If you select Cash Basis in your report settings, transactions will appear based on the date they appear in your bank account (eg the date an invoice was paid).

Description

Contact name displays for account transactions. Payroll Employee displays in place of the employee's name for wage payments.

For accounts other than your bank accounts, you'll also see the description from the line on the original transaction.

Reference

From the journal number (on manual journals) or the Reference field on the source transaction or payment. If the Reference field was left blank, you may see information from another field, eg you'll see the invoice number for an invoice with a blank Reference field.

Sort and reorder columns

Once you've run your report and refined your results, you can:

  • Sort the report in ascending or descending order of the data in any column by clicking on the column heading.
  • Reorder the columns by dragging and dropping them into a different order.