Skip to main content

Auto Bank Reconciliation

Setup​

1. In SQL General Ledger, go to Bank Reconciliation -> Create New​

  1. Select the Bank Statement Date

  2. Select the Account

  3. Tick “Show Current Recon Transactions”

  4. Click Apply

    1

  5. Click Load Statement

    2

  6. Select your Bank Statement (pdf / csv)

    3

  7. System loading

    4

  8. System will detect the Name of your Bank and prompt message below, Click Yes if it is correct.

    5

  9. Once you have loaded in your bank statement, bank closing amount will be automatically filled.

    6

    info

    Criteria to Match:

    1. Cheque number + Amount

    2. Description + Amount

  10. System will auto match the transactions with the bank statement and auto ticked. (yellow highlighted)

But some transactions may not be able to auto match [red box]

7

2. Step to match on unmatched transactions with bank statement​

  1. Click on the untick transaction.

    At the bottom, search for SAME DR/CR AMOUNT, you will find that is a “Match” button or few “Match” button…(if there are few same amount, eg. 50.00)

    8

  2. Click on “Match” when this is the correct bank transactions for [Salary for Ali]

    9

    After click “Match”, system will auto tick the transactions and show the date and bank description at Bank Statement (Match) Column