Overview
The Aged Trial Balance report groups outstanding transactions or balances into a current period and four aging periods by document date or due date. Use the report to analyze your receivables.
You can generate a detailed version of the report (listing the outstanding documents for each customer) or a summary version (a single line for each customer, with the current balance in the customer's account and the balance in each aging period).
You can use selection criteria to limit the customers included in the report. You can also limit the types of transactions included.
When to Print
Print the Aged Trial Balance report when you need a listing of the status of your receivables on a given date, such as at the end of a fiscal year or period, or when you want to identify documents or balances you may need to write off.
Information Printed on This Report
The detailed version of the Aged Trial Balance report includes:
- The Due Date/Applied Number/Applied Type column lists the due date for documents at the left, and the number and type of applied details at the right.
- The Current column lists documents that are not yet due. If As Current is selected for Age Unapplied Credit Notes and Debit Notes (on the Statement tab of the A/R Options screen), this column may also contain credit notes and debit notes. If As Current is selected for Age Receipts, Unapplied Cash and Unapplied Prepayments, this column may also contain receipts, unapplied cash, and unapplied prepayments.
- Fully paid transactions (if you select the Fully Paid Transactions option for the report).
- Aged retainage amounts for each customer (if you select the Aged Retainage option for a report by due date).
- The contact person, telephone number, and credit limit of each customer (if you select the Contact/Phone/Credit option for the report).
- Extra space between each customer (if you select the Space for Comments option for the report).
- You can include Adjustment transaction types on the Aged Trial Balance report. Adjustments are then listed separately on the report, as well as with the transactions that they are applied to. (You can identify adjustments by their "WO" document type.)
- Subtotals if you sort by customer group, account set, billing cycle, national account, or an optional text field (not a Date or Amount field) when using a single currency ledger or a multicurrency ledger using the functional currency.
- Totals by currency code in a multicurrency ledger using the customer currency. Also, subtotals by account set if you sort first by account set.
The summary version of the Aged Trial Balance report includes a single line for each customer, with the current balance in the customer's account and the balance in each of four aging periods.