Detailed Account Transactions Report
The Detailed Account Transactions report shows approved transactions which have a VAT component, including those with a VAT 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.
- To display only cash transactions, select the Cash Basis option.
- 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 (e.g. 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 will be 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.
To drill into the source transaction, click on any of the links in each row.