BANK ACCOUNTS
INTRODUCTION TO BANK RECONCILIATION
  
In addition to the petty cash account, bank account is the only source where money can physically flow into the bank account and physically flow out of the bank account. It is important that the bank account be strictly monitored to see that all the moneys that are received is deposited, and that all the cheques has been honoured. TurboCASH allows you to match or reconcile your Cash Book with the your bank statement you receive from the bank. The bank reconciliation is a process of checking and comparing the transactions in your cash book with the transactions on the bank statement.

All the transactions on the bank statement should be reflected in the cash book and those transactions appearing in the cash book, but not on the bank statement, should be reflected on the bank reconciliation statement. This process can be illustrated as follows:

Cash book transactions in the Receipts and Payments Journals is matched with the Bank Statement. Transactions not marked off is listed on the Reconciliation Statement. Reconciliation Statement - is a list of the transactions in the cash book which is yet listed on the Bank Statement. Bank Statement is matched with the cash book. Transactions not marked off is entered into the cash book.

When the bank statement is received, you will find that the bank cost (and interest if you have an overdrawn cheque account) is debited, and the interest that you have received on a positive bank balance is credited on your bank account. These transactions appearing on your bank statement does not appear in your cash book. The same applies for debit orders and electronic payments as well as moneys paid directly into your bank account by your customers or other parties. The bank reconciliation helps you to identify these transactions and enter them into your cash book.

Another reason is the time factor, if you send a cheque to another supplier by post. This take some time and the other party (beneficiary) to whom the cheque is issued, may bank the cheque too late for the bank to clear the cheque and reflect it on your bank statement. You may also have made a deposit up after banking hours and the deposit will only be reflected on the bank statement on next day.

The bank reconciliation is carried out for a number of reasons, such as:

Determining of outstanding cheques and deposits and reporting it in the Cash Book Reconciliation Report:

These outstanding deposits and cheques will be reported in the Bank Reconciliation Statement or Cash Book Reconciliation Report and should be reflected in the bank statement for the next reconciliation period. Should a cheque be outstanding for a second consecutive period, you need to follow it up with the supplier or beneficiary, since the cheque may be lost in the post, etc. Recording of transactions on the bank statement which do not appear in the cash book:

Tracing and correcting of errors: here are various reasons, which may cause differences between the bank balance as per bank statement and the reconciled balance according to TurboCASH. To read more on how to deal with these differences, click here. Fraudulent cheques The amounts on the bank statement should match the amount in the cash book. If it does not, the cashed cheque should be scrutinised as to determine if there was no tampering with the cheque.

You may receive a bank statement by fetching it from the bank or by post. TurboCASH also has an Online Banking feature, which are available on the Tools - Plug-ins - Bank Online menu option, which are available if you have installed the Plug-ins from the TurboCASH.Seven Installation CD. This Online Banking feature allows you to view bank statements in a electronic format, which you may obtain as follows:
  1. Download a bank statement from your bank, provided that your system is configured and setup for the Internet and you are registered for online banking at your bank or financial institution. It is important to select the correct dates to include transactions (the dates must correspond with those dates for which you need to do the bank reconciliation) when you save the bank statement transactions as a file.

  2. You need to import a bank statement from a valid existing file format on your system.


TurboCASH allows you to reconcile your Bank Accounts before you update or post your Payments and Receipts Journals to the ledger. This will allow you to easily correct any errors found (edit transactions, insert transactions which is omitted, delete transactions which is entered twice, reverse all the transactions if entered on the incorrect side, etc., when doing the bank reconciliation. You may also enter any transactions (such as bank charges and interest), which is listed in your bank statement but does not appear in your cash book. You may post or update your batches after your reconciliation is completed, unless you are working on a "Client Machine" in a network environment.