Fusion Receivables Reconciliation - Detailed Information and Troubleshooting
(Doc ID 2096932.1)
Last updated on SEPTEMBER 29, 2019
Applies to:Oracle Fusion Receivables Cloud Service - Version 220.127.116.11.0 and later
Oracle Fusion Receivables - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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.
A. 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:
- Debit memo
- Credit memo
- On-account credit memo
- 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.
When you drill down in the Receivables to General Ledger Reconciliation report, you see real-time details that make up balances from the summary report. In order to guarantee that the summary balance for each type of activity agrees with the drilldown detail, you must ensure that you limit access to an accounting period when you run the Extract Reconciliation Data from Receivables to General Ledger program. Otherwise additional activity might be added to that period after the extract has run.
That is the reason why it is suggested to set the accounting period status to Close Pending.
Reopen the period if adjusting entries need to be added. You must ensure that the subsequent accounting period is open, in order that business operations continue during the reconciliation process.
It is a 2 step process.
Step 1: Create Extract - This prepares the data and creates the data into the Interim Tables.
For this, Run the Prepare Receivables to General Ledger Reconciliation program to select data for the Summary section of the Receivables to General Ledger Reconciliation Report.
This must be run prior to viewing the report in Business Intelligence.
Schedule (ESS) Name: Prepare Receivables to General Ledger Reconciliation
Description: Prepares transaction and accounting information for reconciling Oracle Fusion Receivables to Oracle Fusion General Ledger
Below is a screen shot of the Prepare Receivables to General Ledger Reconciliation ESS
a. Request Name:
Enter a name that is descriptive of this extract. This request name has to be selected when the actual reconciliation report is run.
Consider using name that indicates the accounting period, date, and time, especially if one is planning to create multiple extracts.
The ledgers available for selection are based on your security assignment.
c. Business Unit:
Use this parameter if you need to reconcile by a specific organization.
Note - If your business unit is implicitly mapped to the primary balancing segment value in the chart of accounts, you can run the report to reconcile by either business unit or ledger. If there is no implicit mapping, then you must reconcile by ledger.
This mapping is not defined anywhere in Oracle Fusion Receivables or Oracle Fusion General Ledger.
d. Accounting Period:
Either Open or Closed accounting periods can be selected based on the requirement.
e. Include Intercompany Transactions:
You can include or exclude Intercompany transactions, or you can reconcile by Intercompany activity only.
f. Include On-Account Items:
You can include or exclude on-account activities, unapplied receipts, and unidentified receipts.
Note - You may want to exclude these activities if they typically post to non-receivable accounts. If you include activities that post to non-receivable accounts, this can cause an accounting difference.
g. Include Unapplied and Unidentified Receipts Indicator:
You can select values from any of the segments of the accounting flexfield.
The Natural Account segment values must have the Financial Category of Accounts Receivable assigned in your general ledger setup in order for the extract and report to work properly.
If you are reconciling by business unit, select the range of balancing segment values implicitly mapped to your business unit.
If you are reconciling Intercompany activity, select the range of Intercompany accounts. These accounts must have the Financial Category of Accounts Receivable assigned.
If you are reconciling everything, you do not need to select any values. The report automatically selects data for Receivables accounts that have the Financial Category of Accounts Receivable assigned.
Step 2: Receivable to General Ledger Reconciliation Report:
This is the actual report that shows the reconciliation details based on the data that was prepared in the step 1.
It presents the beginning and ending receivables balances and all activity for the period, matching the receivables aging.
It increases visibility to information by drilling down to supporting journal and transaction details, rather than navigating to multiple screens or generating multiple printed reports.
Use this report to facilitate the reconciliation of receivables data to the general ledger.
Navigation: Navigator > Receivables > Accounts Receivable > Tasks > Receivables to Ledger Reconciliation
Name - Receivables to Leger Reconciliation
# Drill down on any amount in the summary report's Difference column to display the details of the Differences report for that item.
# The Differences Detail reports display the real-time details that make up balances from the Summary report, and indicate potential causes for differences between actual and reconciling amounts.
Differences between Transactional and Accounted Amounts
Ideally the Summary report should display no differences between receivables transactional amounts and accounted amounts.
Common reasons for differences between transactional amounts and accounted amounts include:
- Transactions that are not accounted.
- Transactions with subledger accounts that fall outside the account range of the report.
- Transaction amounts do not agree with the subledger journal line amounts.
- Journals are posted to the subledger or general ledger that did not come from Receivables.
- Subledger journals were not transferred or posted to general ledger.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|A. How are accounts reconciled to general ledger?|
|B. Steps to be Completed before running the AR Reconciliation Report|
|Helpful SQL Statements:|
|Problems & Solutions:|
|1. Should Receivable to Ledger Reconciliation report show Miscellaneous Receipt?|
|2. The values in the "Receivables Amount" column remain the same irrespective of the balancing segment prompt value, while the "Accounting Amount" does respond (change).|
|3. Account is not being picked up for reconciliation.|