We are trying to Reconcile one of our Bank accounts to GL cash account but we find differences. I have ran the Gl reconciliation detail report for the period of Mar-09 find a difference in General ledger cash account balance and the adjsuted bank statement balance.
Can somone help on how to do the reconciliation and find the reason for the diffrences.
Regards,
Ben[?]
Cash Management Reconciliation to GL
Dear Octavio,
Thanks for replying to my query. We have ran the Bank statement detail report and the final figures match with the bank statement but the General ledger cash account balance(from the general ledger reconciliation detail report) doesn't match.
Is there a way to verify the balances in general ledger reconciliation detail report. Please advise on this.
Regards,
Ben[?]
Thanks for replying to my query. We have ran the Bank statement detail report and the final figures match with the bank statement but the General ledger cash account balance(from the general ledger reconciliation detail report) doesn't match.
Is there a way to verify the balances in general ledger reconciliation detail report. Please advise on this.
Regards,
Ben[?]
Hello.
Please verify the following:
GL Reconciliation Report
Use this report to reconcile the General Ledger cash account balance to the bank statement closing balance and to identify any discrepancies in your cash position. The General Ledger cash account should pertain to only one bank account. This report is available in Summary and in Detail format.
The Summary report lists the General Ledger cash account balance and an adjusted balance for the bank statement. It also lists a separate adjustment amount for unreconciled receipts, payments, and journal entries which have been recorded in the General Ledger cash account, as well as bank errors. The Detail report provides details for the unreconciled items as well as the information contained in the Summary report.
Additional Information: This report does not include information on Payroll payments, Treasury settlements, or external transactions in the Reconciliation Open Interface because they may have been posted to a different General Ledger account than the one assigned to the bank account.
Warning: To ensure that this report is accurate, you must first perform these tasks:
Reconcile all statements in Cash Management.
Transfer journal entry transactions from Oracle Payables and Oracle Receivables to your General Ledger.
Post journals in General Ledger.
Run the report for the current GL period.
Octavio
Please verify the following:
GL Reconciliation Report
Use this report to reconcile the General Ledger cash account balance to the bank statement closing balance and to identify any discrepancies in your cash position. The General Ledger cash account should pertain to only one bank account. This report is available in Summary and in Detail format.
The Summary report lists the General Ledger cash account balance and an adjusted balance for the bank statement. It also lists a separate adjustment amount for unreconciled receipts, payments, and journal entries which have been recorded in the General Ledger cash account, as well as bank errors. The Detail report provides details for the unreconciled items as well as the information contained in the Summary report.
Additional Information: This report does not include information on Payroll payments, Treasury settlements, or external transactions in the Reconciliation Open Interface because they may have been posted to a different General Ledger account than the one assigned to the bank account.
Warning: To ensure that this report is accurate, you must first perform these tasks:
Reconcile all statements in Cash Management.
Transfer journal entry transactions from Oracle Payables and Oracle Receivables to your General Ledger.
Post journals in General Ledger.
Run the report for the current GL period.
Octavio
Who is online
Users browsing this forum: No registered users and 7 guests