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
- Go to Reports, then click 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.
Refine your report's settings
Click Report Settings to refine your report.
- Accrual accounting basis
- Cash accounting basis
Choose Accrual to display revenue earned and expenses that occurred during the date range you selected.
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.
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.
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
|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.
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.