General Ledger Exceptions report
The General Ledger Exceptions report is generated from the General Ledger Summary. It shows transactions that are out of the ordinary based on other transactions in the same account. You can't run this report directly from Report Center.
Run the General Ledger Exceptions report
- In the Reports menu, select All Reports.
- Under Accounting, click ... to expand the section if the report is hidden.
- Click General Ledger.
- Click the General Ledger Exceptions tab.
- Choose a time frame, then click Update to view your report.
Customize your report
The General Ledger Exceptions report is generated directly from the General Ledger Summary based on the period that the report is for.
The report options will be set to those used to generate the General Ledger Summary. You can choose different options to re-run the report and these will be carried through to update the General Ledger Summary:
Select the date range you want the report to cover using the 'From' and 'To' boxes. It will initially show the same dates as the General Ledger Summary, which shows the current month by default.
If you change the date range and click 'Update', the date range will be updated on the General Ledger Summary tab as well.
Choose how the accounts listed on the report will be sorted:
- Account Name: sorts alphabetically in order of account name (default).
- Account Code: sorts numerically in order of account code.
If 'Cash Basis' is ticked the report shows only cash transactions within the specified date range.
What determines an 'exceptional' transaction
Any transactions in the accounts shown in the General Ledger Summary that meet the following criteria will be included in the General Ledger Exceptions report:
- Transactions that have had their sales tax treatment changed from the default sales tax treatment for the account in the chart of accounts.
- Journal lines (which could be an entire transaction or an individual line item in a transaction) that are higher or lower than the average transaction amount in that account for the date range selected for the General Ledger report (those being +/- 2.5 standard deviations from the average).
- Journal lines where the amount is a debit (when most entries for the account are credits) or the amount is a credit (when most entries for the account are debits).
How exceptional transactions are displayed in the report
Only accounts from the General Ledger Summary that have exceptions identified will be displayed.
Accounts are displayed alphabetically or in code number order depending on the report option chosen.
The transactions displayed will be a subset of the transactions in a particular account (unless all of the transactions for the period of the report have had their tax option changed). Within each account, the exceptional journal line is identified. This could be an entire transaction (such as an invoice) or a line item within that transaction.
The transaction date, type, exception reason, reference, and tax percentage (where applicable) are displayed for each transaction shown on the report.
Transaction types are identified as:
- 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
- ADJ: a system-generated minor adjustment where Xero represents one payment for several invoices as individual journals, rather than one journal with multiple payments.
Exception reasons are identified as:
- High: the transaction (or line item within the transaction) is higher than average
- Low: the transaction (or line item within the transaction) is lower than average
- Sales Tax: the sales tax treatment for the transaction (or line item within the transaction) is not the default for that account.
The Reference column will show a reference from the source transaction.
The total debit and credit exceptions and the difference (net movement) is shown for each account. Note the debit or credit amount displayed is the amount of the exception, not the amount of the transaction, unless the whole transaction is an exception.
Select individual transactions
Click on the transaction to drill down to the invoice, credit note or transaction that contains the exception.
In some cases, the exception may be one journal line of several for a transaction.