Bank Reconciliation

Bank Statement Closing Balance

  • General Ledger ==> Bank Reconciliation ==> Bank Statement Closing Balance ( Balance Icon )
  • In the Bank Statement Balance window :
    • Select year and bank.
    • Key in balance according to your Bank Statement Balance.
    • Click save button to save.
  • Software needed this balance to work out the Bank Reconciliation Report.

Import Bank Statement

  • General Ledger ==> Bank Reconciliation ==> Imported Bank Statement Listing ( Bullet Icon) ==> Imported Bank Statement ( Import Icon )
  • In the Bank Statement Import window :
    • Choose the file to import.( the bank statement download from your bank)
    • Select the Bank.
    • Click the import button to import.
  • Software will reject any file with bank statement date earlier than the bank date which had been imported before.
  • Currently Only Hong Leong Bank's Bank Statement can be import.
  • Please contact us if you wish to import other Bank's statement and we will add in the format for you.

Auto Bank Reconciliation

  • Software will automatically do bank reconciliation for the imported bank statement.
  • Software will find the cheque number and amount in the bank's transaction which is same as the imported bank statement and match them. ( Auto Reconciliation ).
  • For those transaction which can not find a match, you will need to do the reconciliation manually.
  • Please key in the cheque number only ( don't add anything ), when you key in any bank transaction as our software's auto bank reconciliation need a perfect match ( number match to number ).

Manual Bank Reconciliation

  • General Ledger ==> Bank Reconciliation
  • Select Bank Account
  • Set the Reconciliation Date. ( same as Bank statement date )
  • In the Imported Bank Statement Listing :
    • Left click to select the bank statement.
    • Then right click to copy the bank statement.
  • Then in the Bank Reconciliation Table, click the check box to match.
  • The copied bank statement will be paste to the right side of the Bank Reconciliation Table.
  • And the software will delete the statement from the Imported Bank Statement Listing.
  • After finish matching, click the save icon on the Tool Bar to save the Bank Reconciliation.