Page 1 of 1

Cash management Reconciliation report issue

Posted: Fri Jun 27, 2008 4:32 am
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

Posted: Fri Jun 27, 2008 6:20 am
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

Posted: Sat Jun 28, 2008 12:13 am
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.

Posted: Wed Jul 02, 2008 12:42 am
by imranhad
Yes GL Cash account showing balance in trial.