Reconcile Oracle Fusion Receivables aging to the GL

Run Receivables Aging by General Ledger Account using the accounting cutoff and balancing segment used for the Receivables to General Ledger Reconciliation report.
Upload a case

Key facts

Match the treatment of unapplied cash, unidentified payments and on-account credits before interpreting a variance.

Align report parameters

Set Transaction As-of Date and use the same balancing segment in both reports. For a GL-account comparison, choose Customer Summary on the aging report. Use the same inclusion policy for on-account credits, on-account cash, unidentified payments and unapplied cash.

Check the vendor’s current options in Oracle’s GL-account aging report reference.

Check credits before comparing totals

Set Show Open Credits to Age if the reconciliation includes open credits, or Do Not Show if they were excluded. Set Show Receipts at Risk to Do Not Show. Compare totals by accounting flexfield. Advanced Collections Aging reports lack the general ledger account detail needed for this comparison.

Make the variance explainable

If two runs differ by $400 and one excludes $400 of unapplied cash, rerun with aligned settings before researching the posting. Keep both outputs, parameter values and the remaining unexplained difference in the close file.

For the wider collection workflow, see the accounts receivable guide.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.