Account Transactions report (New)
The Account Transactions report displays transactions coded to one or multiple accounts in your chart of accounts.
Access and run the improved Account Transactions report
- In the Reports menu, select All Reports.
- Under Accounting, click Account Transactions (New).
- Select one or multiple accounts from your chart of accounts.
Select a date range, then click Update to view your report.
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.
Customise your report
Click Report Settings to customise your report.
View your results
The data displayed in the report is dependent on the accounting basis and transaction type.
|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).
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.
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.