Reconcile Oracle Fusion Receivables aging to the GL
Key facts
Match the treatment of unapplied cash, unidentified payments and on-account credits before interpreting a variance.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
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.


.webp)