Cash Management Bank Reconciliation Report
I want to get a report which can use for Bank Reconciliation.
I have reviewed following 4 reports and those are not satisfying my requirement.
1. 1 .Bank Reconciliation Detail report
2. 2. GL Reconciliation Report
3. 3. Transaction Available for Reconciliation
4. 4. Cash In Transit Report.
Example – After completing the automatic reconciliation and ensures all the lines of bank statement have been reconciled my GL Accounts position are as follows.
HSBC Cash Account - 10,000
HSBC Remittance Account - 4,000
HSBC Clearing Account - 6,000
Gross GL Position - 8,000 (10000+4000-6000)
Period End Bank Reconciliation Report should be shown as follows,
Cash Book Balance as per GL 8,000
+ Issues but not presented Cheques