About customer ledger ageing reports
These reports can also be used by management to determine the effectiveness of the credit and collections functions.
Aged past due
You use the Aged past due (AR631000) report and its multi-currency version, Aged past due (currency) (AR631100) report, to determine which documents are overdue for payment and for how long.
These reports show all open documents recorded in the system, regardless of the current business date or the date specified in the Ageing date field in the report window. That is, the reports show open customer ledger documents, even if they are posted to periods later than the ageing date period. The documents are grouped by statement cycle and by customer.
To age overdue customer balances at the end of the particular period, use the Aged period sensitive (AR630500) report.
For each customer, the report shows the outstanding customer balance in the system and lists open documents, which are broken down by ageing periods. That is, the balances of the documents are sorted into columns that represent ageing buckets. The system forms ageing buckets by using the ageing periods defined for the customer’s statement cycle.
In the report, debit documents are aged based on their due date and the ageing date specified for the report (in the Ageing date field). If the due date of a debit document is earlier than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.
Credit documents are aged based on their document date and the ageing date specified for the report if the Age credits check box is selected in the Customer ledger preferences (AR101000) window. By default, the check box is cleared and the credit amounts are shown in the Current column. With the check box selected, if the document date of a credit document is earlier than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.
Aged outstanding
The Aged outstanding (AR631500) report and its multi-currency version, Aged outstanding (currency) (AR631600) report, are designed to show when you should expect to get payments for the outstanding documents.
These reports show all open documents recorded in the system, regardless of the current business date or the date specified in the Ageing date field in the report window. That is, the reports show open customer ledger documents, even if they are posted to periods later than the ageing date period. The documents are grouped by statement cycle and by customer.
To age overdue customer balances at the end of the particular period, use the Aged period sensitive (AR630500) report.
For each customer, the report shows the outstanding customer balance in the system and lists open documents, which are broken down by ageing periods. That is, the balances of the documents are sorted into columns that represent ageing buckets. The system forms ageing buckets by using the ageing periods defined for the customer’s statement cycle.
In the report, debit documents are aged based on their due date and the ageing date specified for the report (in the Ageing date field). If the due date of a debit document is later than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.
Credit documents are aged based on their document date and the ageing date specified for the report if the Age credits check box is selected in the Customer ledger preferences (AR101000) window. By default, the check box is cleared and the credit amounts are shown in the Current column. With the check box selected, if the document date of a credit document is later than the ageing date, the document balance is reflected in the Current column of the report. Otherwise, the document balance is reflected in the corresponding ageing bucket.
Aged period sensitive
You use the Aged period sensitive (AR630500) report to determine the state of the open documents at the end of a particular period.
The report shows the customer ledger documents that are open at the end of the financial period you select in the Financial period field in the report window. The documents are grouped by statement cycle and by customer.
The report ages the balances of the debit and credit document in the same way as the Aged past due (AR631000) report does. For details, see the Aged past due section in this topic.
Related pages
Concepts
- Process customer ledger documents - overview
- About tracking customer ledger documents
- About types of customer ledger documents
- About the customer ledger document processing flow
- About changing the processing of customer ledger documents
- About schedules for recurring documents