Bank Reconciliation Statement

Bank Reconciliation Statement

Reconciliation of Bank accounts

Reconciling the Company's Bank Accounts with the Banker's Statement is a fundamental and regular task of Accounting. First, there should be the ability to 'check back' the correctness of the reconciliation. This has been done, by marking the 'Bank Date' against the voucher. For instance, if you have issued a cheque on 8th April, which was ultimately cleared by your Bank on 19th April, - you would set the 'Bank Date' for the voucher to be 19th April. This means, that when you next need to 'check back' whether the entry made by you is correct, you will only need to verify the Bank Statement of the 19th. Second, that you should be able to 'recover' the reconciliation as of any date. This is of crucial importance to Auditing. The Bank Reconciliation is one of the pre-requisites of Auditing and verification of the correctness of accounts at the year end. However, it is not a 'real-time' task – in the sense, that it is not done by the auditor's on the first day of the next year. This means, that the reconciliation made on 31st Mar, should be 'viewable' even in August, - by when almost all the cheques would have subsequently been marked as reconciled. This has again been achieved using the concept above.

Bank Accounts may have a different 'Starting Date' for reconciliation purposes. When you create a Bank Account, you are requested to give an 'Effective Date for Reconciliation' just before the Opening Balance. Normally, this would be the 'Books Beginning from' date itself. However, you could have imported data from a previous version of Tally or from any other system (where the reconciliation process was not available or was different. In that case, you may not wish to reconcile the bank account with your bank statements from the very beginning. Give the date from which you want the reconciliation facility to be activated. Then, previous entries will not appear for reconciliation, but will be taken as a reconciled Opening Balance. A quick experiment with Reconciliation will show you what is meant.

Here is how you go about it:

Bring up the monthly summary of any Bank Book. (You could do this from the Balance Sheet, Trial Balance, or Display/Account Books/Bank Books, and selecting a Bank). Bring you cursor to the first month (typically April), and press Enter. This brings up the Vouchers for the month of April. Since this is a Bank Account, an 'additional' button F5: Reconcile will be visible on the right. Press F5.

The display now becomes an 'Edit' screen in 'Reconciliation' mode. The primary components are:A column for the 'Bankers Date'

The 'Reconciliation' at the bottom of the screen, showing: Balance as per Company Books Amounts not reflected in Bank

Balance as per Bank The Balance as per Company Books reflects your Balance as on the last date (in our example case, 30- Apr). The Amounts not reflected in Bank is the debit and credit sums of all those vouchers whose Bank Date is either BLANK, or GREATER than 30-Apr (i.e. these vouchers have not yet been reflected in the Bank Statement).

The Balance as per Bank is the Nett effect of your Book Balance offset by the amounts not reflected in the Bank – which should equal the balance in the Bank Statement. (Of course, some variation may persist due to entries made in the Bank Statement which you have not yet entered in your Books – but since you WILL definitely enter them, and only then print your reconciliation, it will ultimately reflect the correct balance). You will find, as you mark off the individual vouchers by setting the 'Bank Date', that the Reconciliation at the bottom of screen keeps reflecting those changes instantly. When you are finished, press Ctrl+A (or press Enter as many times as necessary to skip over the unmarked vouchers), and accept the screen. (If your screen has a largish number of vouchers it may take some time to complete the acceptance – be patient).

The next time you come for reconciliation, you will be presented only with those vouchers which remain un-reconciled. Thus, the task keeps becoming simpler.

Making of Bank reconciliation statement by yourself Bank reconciliation statement tells the reason why your cash books bank column is not matching with your bank pass book .

Free accounting knowledge

It may be noted that the American institute of certified public accounts , in 1941 defined accounting as the
specialised art of recording , classifying and summarizing in a significant manner transaction terms of money which are of a financial character and interpreting the result . In the course of the time the definition has become broader to include imparting economic information to permit informed judgements and decisions .
Economic events have been defined as happenings of consequence to a business entity

Basic terms in accounting

•Financial Statements
Two basic financial statements are prepared by an enterprise one is profit and loss statement and other is balance sheet
•Accounting Equation
Three components of a balance sheet can be stated in the form of following basic accounting equation
Assets = liabilities + capital
This equation tells at the glance that the resources of this enterprise total and these assets are financed by two source
also known as outsiders claims and owner equity.
•Business Transactions
It can be a purchase of goods , collection of money , payment to creditors for goods and expenses . An event to be a
transaction must possess the quality of economic substance , relate to business and affect the economic results .
•Assets
These are economic resources of an enterprise
fixed assets are assets held on a long term basis , such as land , building , machinery and plant etc.
Current assets are assets held on a short term basis such as debtors bills receivables , stock , cash and bank etc.
•Liabilities
These are the obligations or debts that the enterprise must pay in money or services at sometime in the future . They
represent creditors , claims against assets of the firms.