Bank Reconciliation report may be produced as often as required.
- In the menu expand, Base Modules > General Ledger > Other > Bank Reconciliation > Manual Bank Reconciliation and then double-click GL Bank Reconciliation Report. GLR340 Bank Reconciliation Report selection panel appears.
- Enter the GL Bank account, Report period and Closing balance and click OK.
| Note |
Bank currency will be determined as below.
|
Bank reconciliation report will be generated for the selected period showing the following information.
-
- Bank opening balance
- Determines Match Group (1=Unpresented, 2=Unposted, 3=Unmatched). These are established in TMSGL/BNK-MTCH
- Entries on both but discrepancy in amounts
- Calculated closing balance
- General ledger balance
- Discrepancy between the Bank and General Ledger.
- Not Presented – in General Ledger Bank Account but not on Statement
- Cheques Not Posted – on Statement but not in General Ledger Bank Account. The cheque number is used as the validation.
- Cheques mismatched – differences between the cheques as they appear on the Bank Statement and as they were entered on the system. For example the Bank Statement shows $100.40 but in the General Ledger it shows as $100.80.
