Detailed Account Transactions Report
The Detailed Account Transactions report shows approved transactions which have a sales tax component, including those with a sales tax rate of zero. This report includes invoices, bills, credit notes, expense claims and bank transactions. You can also run this report on a Cash Basis.
The Detailed Account Transactions report can be used as part of your end of year or end of period requirements to identify transactions which have the incorrect tax rate applied. It may also be useful in support of a set of financial statements.
Your user role will determine whether you can see this report, and if you can save and publish it or just view it.
Run the Detailed Account Transactions report
- In the Reports menu, select All Reports.
- Under Accounting, select Detailed Account Transactions.
- Select your date range by entering a From and To date. You can also choose to Sort your results by Account Name, Account Code, Reference or Date.
- Select the Cash Basis option to display cash transactions only.
- Click Update to view your report.
This report only displays in your base currency.
Viewing wide reports - select the Wide view option to view the full report, or export the report to print or change its size.
Bank account transactions, invoices, bills and credit notes will show where the date of the transaction is within the selected date range.
Expense claims will display where the specified reporting date is within the selected date range.
Pay run bills and employee payments will display if there are any transactions associated with a pay run (eg payslips and taxes) where the transaction date falls between the date range. These can be drilled into, but details other than total amounts will only be visible if your user role includes Payroll Admin or Payroll Read Only.
The type shows the original source of the transaction:
- INV: Invoices
- PAY: Payment or cash refund
- MJ: Manual journal
- EC: Expense claim
- CN: Credit note (date of credit note)
- APP: Date credit note applied to invoice
- SB: Starting balance
- PR: Pay run
The Reference column is based on the type as follows:
- Invoice: the invoice number.
- Invoice payment: the payment reference field or the invoice number.
- Bill, expense claim, spend or receive money transaction: the reference field.
- Credit note: the credit note number or reference. On a refund, it will first show the payment reference field, then (if none) the credit note number or reference.
- Bill payment: it will first show the payment reference field or the reference (if a single claim - otherwise it will be blank).
- Manual journals: the journal number.
- Payslip or pay run bill: the reference.
Click any link in a row to drill into the source transaction.