Oracle Fusion / Cloud AR to GL Reconciliation

Overview Reconciliation is the process by which the transactional data recorded in subledgers is compared with the accounting data generated by subledger accounting to create the journal entries that post to the general ledger. The reconciliation report allows a coherent view of the data from each of these modules: Receivables AR Subledger Accounting SLA and General Ledger GL to confirm their data agrees and is represented as intended, without corruption. Use the Receivables to General Ledger Reconciliation report to facilitate the reconciliation of receivables data to the general ledger. Receivables provides the tools to reconcile the subledger AR with General Ledger. Internal reconciliation involves reconciling the customer accounts, transactions, and receipts. Once the transactions are posted to the general ledger then one can reconcile subledger AR with the general ledger by verifying that all the correct journal entries were made How are accounts reconciled to general ledger The Receivables to General Ledger Reconciliation report only reconciles accounts receivable for accrual basis accounting, and only reconciles accounting in the primary ledgers. The Receivables to General Ledger Reconciliation report reconciles the transaction types that impact the accounts receivable in general ledger. These include: Invoice Debit memo Credit memo On-account credit memo Chargeback Adjustment Applied receipt On-account receipt Unapplied receipt Unidentified receipt Bills Receivable Bills Receivable Application On-account credit memo refund amounts and on-account credit memo gain or loss amounts are included in the Invoices section of the Reconciliation report, because they affect the open balance of the receivable amount of the credit memo. In all cases the intent is to close the credit memo, so both the original credit memo and the activity against it are displayed. • The report also reconciles manual journal entries created in the Receivables subledger. B. Steps to be Completed before running the AR Reconciliation Report Before running the AR Reconciliation report, the following steps have to be completed. 1. Complete month-end activities such as importing billing information, applying receipts and approving adjustments. 2. Run Create Receivables Accounting for the period to final account activity and post to the general ledger. 3. Set the Receivables period status to Close Pending. What are the month end closing processes in Oracle Fusion Receivables Solution Oracle Fusion Receivables Period Close Checklist 1Complete month end activities such as importing billing information applying receipts and approving adjustments. 2If there are unposted transactions with invoicing rules run Revenue Recognition and review the execution report to confirm all relevant records are picked up for processed. 3 Set Receivables period status to Close Pending. 4 Run Create Receivables Accounting for the period to final account activity and post to the general ledger. 5 Run Subledger Period Close Exceptions Report to review items that may prevent period close and make corrections. a Compare Invalid journals to Create Accounting Execution report activity. b Incomplete Invoices and Unapproved Adjustments do not prevent period close. 6 Run the Prepare Receivables to General Ledger Reconciliation scheduled process. 7 Review the Receivables to Ledger Reconciliation Report. a If Differences exist, review the associated Differences report for potential causes and make appropriate corrections. b If Variances exist, contact IT or Oracle Support for assistance. c If an amount exists for Other Accounting, review the activity. If activity other than Intercompany and manual journals sourced from AR exists, this may indicate incorrect setup. d If there are not differences, you may still want to review the detail reports to verify GL accounts. 8 Once all differences have been resolved, rerun the Prepare Receivables to General Ledger scheduled process and review the Reconciliation Report to confirm differences are cleared. 9 Compare the Accounting End Balance of the Reconciliation report with the Aging Report ending balance. a Subtract out the Other Accounting, which represents accounting activities not included on the Aging report. 10 If the aging and reconciliation balances do not agree a Confirm the report parameters were set consistently for both the Aging and Reconciliation reports. b Confirm the beginning balances agree. The ending balance of the prior period aging report should agree with the reconciliation beginning balance 11 If the aging and reconciliation balances do agree set the Receivables period status to Closed.