Reconcile Outstanding Customer Balances (Oracle Receivables Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

Reconcile Outstanding Customer Balances

Reconcile the outstanding customer balance at the beginning of a specified period with the ending balance for the same period. The following table represents the various components that affect a customer's balance and the reports you can use to reconcile these components.

Reconcile Outstanding Customer Balances

Beginning Balance Aging Report

Transactions Transaction Register

Adjustments Adjustment Register

Invoice Exceptions Invoice Exceptions Report

Applied Receipts Applied Receipts Register

Unapplied Receipts Unapplied Receipts Register

Ending Balance Aging Report

Use the following formula to ensure your revenue accounts match your receivables aging:

Reconcile Outstanding Customer Balances

Beginning Balance	Aging Report
Transactions	Transaction Register
Adjustments	Adjustment Register
Invoice Exceptions	Invoice Exceptions Report
Applied Receipts	Applied Receipts Register
Unapplied Receipts	Unapplied Receipts Register
Ending Balance	Aging Report

Beginning Balance

+ Transactions

+ - Adjustments

- Invoice Exceptions

- Applied Receipts

- Unapplied Receipts

= Ending Balance

Use the Invoice Exception report to adjust the Transaction Register for any transactions that are not open to Receivables and therefore do not show up on your agings. See: Invoice Exception report.

Suggestion: Define a report set containing the above reports and specify default parameter values and printing options.

Report Options

Submit the above reports from either the Print Accounting Reports or the Submit Requests window. The two Aging reports must be submitted from the Submit Requests window.

Select the same GL Dates for all the reports. Receivables requires that you print the Aging Reports as of a particular GL Date. All transactions that have a nonzero balance as of this date will be included in your agings. Therefore, to get the opening balance, submit the Aging Report as of the day before the first date of the period. This will ensure that all transactions for the first day are not included in the opening balance calculation. To get the closing balance, submit the Aging Report as of the last date of the period. See: Aging Reports.

Choose to order all the reports by customer. This will let you research transactions based on customer name or number.

Suggestion: When sorted by customer, the Aging Report does not give the details of the transactions that are included in the calculation of the outstanding balances. If you need to find out details of such transactions, you might choose to print the Aging reports ordered by type. Use either the Aging - 4 Buckets or the Aging - 7 Buckets report for reconciliation. See: Aging - 4 and 7 Bucket Reports.

Reconcile Outstanding Customer Balances

Report Options

See Also