This guide outlines how to create an Account Transactions report in Xero, useful for viewing transaction details in accounts like Undeposited Funds or Cash on Hand.

This guide and many more can be found in Xero Central.

Overview of the Account Transactions Report

The Account Transactions report displays all recorded transactions within selected accounts over a chosen period. It provides flexibility to:

• Select specific accounts or multiple accounts
• Choose a report period
• Group, filter, and customise report results

You can run the report on an accrual or cash basis, and filter the data to include or exclude details like part payments or archived accounts.

Steps to Run the Account Transactions Report

1. Go to the Accounting menu and select Reports.

2. Find and select the Account Transactions in the report list or use the search field in the top right.

3. Under Accounts, select one or more accounts to include in the report. 

4. Uncheck Show archived to exclude archived accounts, or use Select all to include every account.

5. Select a Date range, or click the dropdown arrow for quick options like This Month or This Quarter.

6. Select other options you want the report to show – see how to customise the report below.

7. Click Update to generate the report.

Customising the report

You can adjust the report layout by grouping, filtering, and choosing columns. Here's how:

• Columns: choose columns like Account Code, Contact, or Contact Group to display on the report. 
• Grouping/Summarising: The report defaults to grouping by account name. Change the layout by selecting another grouping option, such as Account Code.
• Accounts to include: Refine the accounts based on activity or balance:
  • Only with transactions – shows accounts with transactions in the period.
  • With transactions or non-zero balance – shows accounts with transactions or non-zero opening balance.
  • All, including zero balance – shows all selected accounts regardless of balance or activity. 
• Filter: add filters to narrow down report results and click Apply. 
• Additional Options (Under More): change the accounting basis or include more details:
  • Accounting Basis – choose Accrual or Cash.
  • Opening and closing balances – show or hide  balances for asset, liability, equity, revenue, and expense accounts.
  • Decimals – show amounts to two decimal places, or hide decimals for a simplified view.
• Sort and Reorder Columns
  • Click on a column heading to sort in ascending or descending order.
  • Use Reorder columns to drag and drop columns into a preferred order, then click Apply.

Saving Custom Reports for Future Use

To save this customised report for future access click here.