Account Transactions report (older version)
The older Account Transactions report shows all transactions assigned to an account. Depending on your user role, you can export, archive, or edit the report. You might want to run this older report version if you want to see multi-currency transactions in their original currency.
Generate the Account Transactions report
You can generate the report in three ways:
- Drill into amounts from another report. For example, the Profit and Loss report.
- By clicking the current month figures in the Account Watchlist on the Dashboard.
- From the main All Reports screen (under Accounting).
Once you've generated the report, you can filter the report's transactions.
Filter the Account Transactions report
Choose the account you want to report on.You can only choose accounts that have transactions in them.
- Select a date range.
- (Optional) Select the Cash Basis checkbox to show only cash transactions.
- (Optional) If you're using multi-currency and want to see transactions in their original currency, clear the Show in [base currency] checkbox.
- (Optional) If you want to filter on a tracking category you've set up:
- Click More options.
Select tracking category options to filter the report.
(Optional) Click a transaction to view the details.
If you've filtered the report by one or more tracking options, only transactions matching these options will be shown on the report. The report heading will include the name of the option chosen so you know which option you have filtered by.
The report shows amounts for the selected period for transactions coded to your accounts depending on the transaction date.
- Bills, invoices and credit notes show if the date they were created is between your selected dates.
- Bank account transactions show if they're dated between your selected dates.
- Expense claims show if the reporting date is between your selected dates.
- Payroll bills and employee payments show for any salary or wage accounts if the transaction date (e.g. payslip) is between your selected dates. They'll have the generic name 'Wage Payable Invoice - Employee Payment' unless your user role gives you access to payroll in Xero information. If you have Payroll Admin or Payroll Read Only access, you can see employee and payee names. You can also drill into each item to see the full payslip or bill details.
- If the Cash Basis box is selected, the report shows transactions that have passed through the bank account for your selected account. For example, bill and invoice payments, or spend and receive money transactions.
- Type shows the original source of the transaction:
- INV: Invoice or bill
- PAY: Payment or cash refund
- MJ: Manual journal
- PE: Payroll expense journal
- EC: Expense claim
- CN: Credit note (date of credit note)
- APP: Date credit note applied to invoice or bill
- BT: Bank transfer
- SB: Starting Balance
- ADJ: a system-generated minor adjustment where Xero represents one payment for several invoices or bills as individual journals, rather than one journal with multiple payments.
The Reference column
The Reference column shows the source transaction reference:
- Sales invoices show the invoice number.
- Bills, expense claim receipts, spend money and receive money transactions show the reference (if any).
- Expense claim payments show the payment reference first, and then the claim reference if it's a single claim. Otherwise, it'll be blank.
- Customer credit notes show the credit note number. Refunds show the payment reference first and if there isn't one, the credit note number.
- Supplier credit notes show the reference. Refunds show the payment reference first and if there isn't one, the credit note reference.
- Invoices and bill payments show the payment reference first and then the number.
- Manual journals show the journal number that appears on a posted journal and the Journal Report.
- Payslips and wage payable bills show the reference.