Running the A/R Aging Report

Normally, you print the Accounts Receivable Aging Report at the end of the period, before you print statements. This report is helpful in identifying customers with past-due invoices.

The report shows the age of a customer's balances and places them into the aging buckets defined in the report options.

You can print the report either in a detailed format, which includes all the open item information, or in summary format, which includes only the totals for each customer.

Note: If you have to clear any offsetting items, refer to the topic Clearing Offsetting Open Items in A/R for further information.

The Accounts Receivable Aging Report prints the customers you specify using the report options, and it prints the names and billing information for each. The Print Posted Transaction option determines how the posted transactions, if displayed, are sorted. There are other report options that determine how the overall report is sorted, for example Sort by Currency, and Consolidate Customers.

The main part of the report is the aging buckets. These show how much each customer owes and how long that amount has been due. This report also prints finance charge information, which includes charges and payments.

The report also displays the exchange rate for multi-currency purposes. When printed in domestic currency, the report also includes gains/losses already written to the A/R journal. The bucket amounts are the sum of all transactions, including any gain/loss values. The bucket amounts do not include any estimate gain/loss amounts. If the report is not being translated to domestic, then all summary amounts are displayed in the customer’s currency and all detailed amounts are in the transaction currency.

If an invoice has multiple due date payment terms, a line will print for each scheduled payment that has not been completely paid.

If an invoice has a debit memo or credit memo applied to it, the report shows the applied debit or credit memo number.

You can print all posted transaction information showing the date and amount of each transaction. The end of the report provides grand totals for all selected customers.

To print the Accounts Receivable Aging Report:

Select the field values and check boxes to define the parameters of the report you want.

The default selections print a report for all customers.
(Optional) To view the report before printing the final version, click Preview.
To print the final report, click Print.