Cash management Reconciliation report issue

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
imranhad
Posts: 56
Joined: Thu Apr 06, 2006 6:57 am
Location: Pakistan

Cash management Reconciliation report issue

Post by imranhad »

hi all
In cash management module, General Ledger Reconciliation report is not showing General ledger cash account balance, please see given blow out put of report
========================================
------------------------Report out put----------------------------------


Period Name: MAY-08
GL Cash Account:

Bank Name: Habib Metropolitan Bank Ltd. Bank Account Number: MBL A/C-20311-152417 Bank Account Currency: PKR
Bank Branch Name: Egerton Road Br. Bank Account Name: Metro. Egerton Rd. Br.20311


GENERAL LEDGER POSITION:

General Ledger Cash Account Balance 0.00

BANK POSITION:

Bank Statement Closing Balance (67,488,411.00)
+ Unreconciled Receipts 1,047,219,498.29
- Unreconciled Payments 1,094,557,366.01
+/- Unreconciled Journal Entries 0.00
+/- Lines Marked As Errors 0.00
------------------------------------------------------------------------ ---------------------------
Adjusted Bank Statement Balance (114,826,278.72)

DIFFERENCE (GL Cash Account Balance - Adjusted Bank Statement Balance): 114,826,278.72
kkmundhra
Posts: 83
Joined: Sat Jun 14, 2008 1:17 pm
Location: India

Post by kkmundhra »

Hi Imran

Please check the trial balance for May-08 for General Ledger Cash account balance. Is it the same in trial balance or different.

Thanks
Karan
ramsabi
Posts: 19
Joined: Fri Jul 27, 2007 11:56 pm
Location: India

Post by ramsabi »

Hi Imran,

Prima facie it looks like no reconciliation has been done for the period May-08 <b>at all</b>. I make this conclusion based on the huge amount showing as unreconciled receipts and payments.

Also is this a new bank account? Because whatever may be the reconciliation situation, the GL Cash account balance will not normally show zero balance.

Karan's advice is the starting point. Check the TB and see the GL balance for this bank's cash account.
imranhad
Posts: 56
Joined: Thu Apr 06, 2006 6:57 am
Location: Pakistan

Post by imranhad »

Yes GL Cash account showing balance in trial.
Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests