Reg: Reconciliation Formula for Various Modules

[oracleapps1983]

Hi To all

Can any one give the Reconciliation formula for the Receivables, Payables, Assets and Cash Management.

Thanks

[oteixeira]

Hello.
This is a useful report for Receivables:
AR Reconciliation Report
Use this report to help you reconcile your accounts receivable activities. This report summarizes all customer, receipt, transaction, and account balances for the period you specify to simplify the internal reconciliation process. The report uses the following formula to help you reconcile any outstanding receivable amounts:

Totals for Period - End of Period Balance = Difference

Octavio

[oracleapps1983]

Hi oteixeira

Thanks for Your Reply. Reconciliation will be done acconted in Subledger modules and Posted in GL .


Thanks

[abhyankarnarayan]

For Payables formula is:
Payables opening balance + sum of invoice register - sum of payments register = payables closing balance. You can make use of AP trial balance report.

For Assets, you can see the Journal Entry Reserve Ledger Report total and compare it with the amount transferred to GL.

For Cash Management, I am not sure of any reconciliation unless you want to account for payment when it clears. You can check the reconciliation report and identify whether all the payments have been reconciled or not!!

Narayan