Bank Reconciliation

Menu Path: Finance > Cash Book > Bank Reconciliation

Create Statement:

• Select a Company (Branch) , then click Set Company button.
• Select a Cashbook, then click 'Set Cashbook'.

The result image will appear with details of Dates, Balances and Action.

Create New Statement:

• Enter a name for the statement.
• If it is a monthly statement, key in the opening date (eg. 1.12.2008). Next, in the 'Balance Open' enter the amount (eg. RM 1000) as per the opening balance (1.12.2008) from your actual bank statement.
• Do the same for the closing date and closing balance.
• These steps are taken to enter the amounts from the bank statement to make comparisons with the amounts in the cashbook in EMP.
• Click ' Create New Statement'.

• The Bank Statement List will appear as below:
• Click 'Edit' to edit the cash statement as stated on Action Column.

Add Details

• Click 'Add Details' to file transactions for the reconciliation.
• Select the number of transactions to be displayed.
• Click on the Description in blue to view the receipts or payment voucher.
• When filing the transactions, the user is required to refer to the actual bank statement. Check if the transactions on the list have already been paid (PV) or received (Rct). If the transaction on the list matches the bank statement, tick the box on the right to select a particular transaction. Then click 'File It'.

• To view the bank reconciliation report, click 'BankRecon2' at the Action Column.
• The following will appear:

Explanation of the report above:

- The purpose is to reconcile the cashbook (31.12.2008) of RM 15,819 to bank statement's closing balance of RM 1,800.
- The difference is due to unpresented cheques, uncredited cheques and any discrepencies.
- From the report, total unpresented cheques is RM 500. An unpresented cheque is when the user company issued a cheque payment of RM 500 and the cashbook has already been 
deducted with RM 500 but the the bank has not. This is caused by the processing time of when the bank has to clear the cheque.
- This causes the bank to have have a balance of RM 500 more than the cashbook.
- Uncredited cheques (eg. RM 13,989) are cheques that have been issued to the bank by the customer and again, the bank has not cleared the cheque but the user's cashbook has 
already been debited. 
- This situation resulted in the bank balance being less than the cashbook balance.

Bank Statement as at 31 December 2008.

RM
Closing balance as per cashbook                      15,319
Add: Unpresented cheques                         500
Less: Uncredited cheques                     (13,989)
Closing balance as per bank statement    1,830
Actual closing balance as per bank statement       1,800   
Discrepancies                                          30

Please refer Discrepancies for ways of dealing with it.

To create a new statement for January 2009, repeat the steps above.