Overview
Note: Depending on how your system is set up, this desktop screen may also be available as a web screen. For more information, see the Web Screens Getting Started Guide or the help for Sage 300 web screens.
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 print the report in detailed form, listing all outstanding documents for each customer, or summary form, printing one line for each customer number, including the current balance and the balance in each aging period.
If you use optional fields as selection criteria for this report, you can specify the ranges of values from which to select records for printing. The report then includes only customers that use the specified optional fields, whose values fall within the specified range.
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 Aged Trial Balance report includes the following information:
- A 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.
- A Current column contains documents that are not yet due. Credit notes, debit notes, unapplied cash, and prepayments appear in this column if you select As Current for the Age Credit Notes And Debit Notes and Age Receipts, Unapplied Cash And Prepayments options on the A/R Options screen.
- Each customer's contact person, telephone number, and credit limit (if you select the Contact/Phone/Credit option).
- An extra space appears between each customer record if you select the Space for Comments option.
- 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.)
- Aged retainage amounts for each customer, if you choose to include them, on reports you print by due date.
- Fully paid transactions, if you choose to include them. You can also specify the earliest date for which to show fully paid transactions.
- In a single currency ledger, or in a multicurrency ledger with Print Amounts In Functional Currency selected, subtotals appear if you sort by customer group, account set, billing cycle, national account, or an optional text field (not a Date or Amount field).
- In a multicurrency ledger, if you select Print Amounts In Customer Currency, totals by currency code are printed. Also, if you sort first by account set, the report includes subtotals by account set.
- The summary version of the report includes one line for each customer number, listing the current balance in the customer's account and the balance in each of four periods.