Bank Reconciliation
Bank Reconciliation
Bank Reconciliation
Pushpa Kumari
STRUCTURE
12.1 12.2 12.3 12.4 Introduction Objectives Cash Book Types of Cash Book 12.4.1 Simple Cash Book 12.4.2 Two Column Cash Book 12.4.3 Three Column Cash Book 12.5 Petty Cash Book. 12.5.1. Imprest System of Petty Cash Book. 12.5.2 Advantages of Petty Cash Book 12.6 12.7. Pass Book Bank Reconciliation Statement 12.7.1 Meaning 12.7.2. Causes for difference between Cash Book Balance and Pass Book Balance. 12.7.3. Need and importance of Bank Reconciliation Statement 12.7.4 Procedure for preparation of Bank Reconciliation Statement. 12.8. 12.9. Summary Glossary
12.10. Self Assessment Questions 12.11. Answers to check your progress 12.12. Further Readings
12.1. INTRODUCTION
Every entrepreneur should have knowledge of cash book and pass book as from these books, he may check how much balance is available to him for meeting his expenses and liabilities and what are the details of receipts and payments of a particular period. With the details of payments it can be
175
checked that whether the payments are of reasonable amount or not. If the expenses are unreasonably high he may take steps to control them. An entrepreneur who regularly checks his cash and bank balances would never face problems like dishonor of cheques or cash crisis etc. The entrepreneur, who doesnt distinguish between his revenue and profits, may spend all his receipts for his personal purposes subsequently resulting in deficiency of cash for business purposes and that might lead to a cash crisis.
12.2. OBJECTIVES
After going through this lesson you should be able to Explain the meaning of Cash Book, Pass Book, and Petty Cash Book. Discuss the types of Cash Book. Enter the transactions in Cash Book. Explain the meaning, need and importance of Bank Reconciliation Statement. Discuss the causes for difference between the balances of Pass Book and Cash Book. Prepare Bank Reconciliation Statement.
176
Balancing the Cash Book The Cash book is balanced like any other account. The receipts column total will be more than the payments column total. The difference will be written on the Cr. Side as By Bal c/d. Example 1 Enter the following transactions in simple Cash Book. 2006 Jan 1 Jan 5 Jan 7 Jan 8 Jan 10 Cash in hand Received from Ramesh Paid Rent Sold goods Paid Sohan Rs. 12000 3000 3000 7000 2000 Simple Cash Book Dr. Date 2006 Jan 1 Jan 5 Jan 8 Receipts Particulars To Bal b/d To Ramesh To Sales Amt. Rs. 12000 3000 7000 Date 2006 Jan 7 Jan 10 Jan 31 Payments Particulars By Rent By Sohan By Bal C/d Cr. Amt Rs. 3000 2000 17000
177
22000 ======
22000 ======
Find out the monthly expenses and incomes of your family and prepare a cash book for a particular month. Q 1. Enter the following transactions in the simple cash book. 2005 Dec 1. Dec 2 Dec 3 Dec 4 Dec 5 Dec 6 Cash in Hand Received from Ramesh Purchased Furniture Machinery Sold Goods sold Salaries paid Rs. 10,000 13,000 15,000 10,000 20,000 1,000
178
the firm so it is to be credited and recorded in the Cr. side of the cash book the specimen Performa of a two column cash Book is given as under
Two columns Cash Book Dr Date Receipts Particulars Amount Amount Date Discount Cash Payments Cr Particular Amt. Amt. Discount Cash
Note: Discount columns are not balanced they are merely totaled. Example 2: Enter the following transactions in a two-column ash Book. 2005 Jan 1 Jan 5 Jan 5 Jan 6 Jan 10 Jan 10 Jan 11 Jan 12 Jan 13 Jan 14 Cash in hand Paid to Mohan Discount allowed by him Purchased goods Received from Vijay Discount allowed Sold goods Paid to Shyam Discount received Rs. 50 Paid wages Paid to Rajesh in full settlement of his Account, which shows a Cr. Balance of Rs. 4000 Two Column Cash Book Dr
Date Particulars
Rs. 15,000 3,000 100 4,000 9,800 200 4,000 2,950 50 500
3900
Receipts
Amt Dis. Amt Cash Date 2005
Payments
Particulars Amt Dis.
Cr
Amt Cash
179
Rs
Rs 15,000 9,800 4,000 Jan 5 Jan 6 Jan 12 Jan 13 Jan 14 Jan 31 By Mohan By Purchases By Shyam By Wages By Rajesh By Bal c/d 250 100 100 50 3,000 4,000 2,950 500 3,900 14,450 28,800
200 -
200
28,800
Check your progress Q 2. X started business on 1.4.2005 with Rs. 20,000 as Capital. He had following cash transactions in the month of April 2005.
2005
April 1 April 2 April 3 April 4 April 5 Purchased Furniture Purchased Goods Sold Goods for Cash Purchased Goods Paid Cash to Ram Discount allowed by him April 6 Received Cash Kaviraj and Co. Allowed Discount from
Rs. 2005
2,500 3,000 1,500 2,000 5,600 100 April 7 April 8 April 9 April 10 April 11 April 12 April 13 6,000 200 Paid for petty exp. Cash Purchases Cash Sales Recd from Ram & Sons Paid for Typewriter Paid for Telephone Paid Aggarwal brothers They allowed discount
Rs.
150 1,500 2,000 6,000 8,000 2,000 4,000 80
Make out two column cash Book ...... .............................................................................................................................. .............................................................................................................................. .............................................................................................................................. .............................................................................................................................. ..............................................................................................................................
180
A three column cash Book is a cashbook, which contains bank along with cash and discount columns.
column
A firm normally keeps the bulk of its funds at a Bank; money can be deposited and withdrawn at will if it is a current account. Probably payments into and out of the bank will be more numerous than strict cash transactions. There may be only a little difference between cash in hand and cash at bank. Therefore it is very convenient if in the cash book on each side another column is added to record moneys deposited at bank and payments out of the bank. The specimen Performa of a three-column cashbook is given as under: Three Column Cash Book Dr
Date Particular
Receipts
DisRs. Cash Rs. Bank Rs. Date
Payments
Particulars DisRs. Cash Rs.
Cr
Bank Rs.
Balancing: The discount columns are totaled but not balanced. The cash columns are balanced exactly in the same manner as indicated for the simple cash book. The process is similar for balancing the bank columns also. It is possible, however, that the bank may allow the firm to withdraw more than the amount deposited, i.e. to have an overdraft. In such a case the total of the bank column on the credit side will be bigger than the one on the debit side. The difference is written on the debit side as To Bal c/d. Then the totals are written on the two sides opposite one another; the balance is then entered on the credit side as By Bal b/d. However the usual case is that payments into the bank will exceed the withdrawals or payments out of the bank. Then the bank columns are balanced just like the cash columns. (Ref.: T.S. Grewal, Double Entry Book Keeping) Example 3: Enter the following transactions in a Three-column cash book. Cheques are first treated as cash receipts 2005 Jan 1 Jan 2 Jan 3 Cash in hand Paid into Bank Receives cheques from Kirti and Co. Rs. 20,000 19,000 600
181
Jan 4 Jan 5
Pays into bank Kirti and Cos Cheque He pays Ratan and Co. by Cheque and is allowed discount of Rs. 20
600 330
Receipts
DisRs. Cash Rs. 20,000 Bank Rs. Date 2005 19,000 Jan 4 600 Jan 5 By Bank A/C (c) By Ratan and Co (c) By Bal c/d Jan 2 By Bank A/C (c) Particulars
Payments
DisRs. Cash Rs. 19,000
Cr
Bank Rs. -
20 -
600 330
Jan 3
Jan 4
----
Jan 31
20
1000 20,600
19270 19,600
Note 1) When cash is paid into bank the entry passed is Bank A/C Dr. To Cash A/C (Bank balance increased) (Cash balance decreased)
This type of transaction affects both cash and bank and these are called contra transactions 2) When cheque is received two entries are passed Cash A/C Dr. To Debtors Bank A/C Dr. To Cash Check your progress Q 3. Enter the following transactions into a three-column cashbook. 2005 Feb 1 Feb 2 Cash in hand Receives cheques from Warsi and Rs. 10,000 (When cheque is deposited into Bank) (When cheque is received)
182
Allows him discount Rs. 300 Feb 3 Feb 4 Pays by cheque for cash purchases Sundry exp. paid in cash
Example 4 Prepare a petty cash book on the imprest system from the following:
183
2005 March 1 March 2 March 3 March 4 March 5 March 6 March 7 Solution Petty Cash Book
Recei pts Date V . N o. Particulars Total Rs. Con veya nce Cart age
Rs. Received Rs. 1000 for petty cash Paid bus fare Paid Cartage Paid for postage and telegram Paid for stationary Paid for postage and telegram Paid for sundry exp. 10 25 50 40 50 40
Station ary
Postage Telegra m
Sundries
2005 1000 March-1 March-2 March-3 March-4 March-5 March-6 March-7 1 2 3 4 5 6 7 To Cash A/C By conveyance By cartage By postage telegram By stationary By postage telegram By sundry exp. and and 10 25 50 40 50 40 10 25 40 50 50 -
40
1000
March 31
By Bal c/d
215 785
10 ===
25 ===
40 ====
100 ====
40 ====
====
====
785 215
April 1
(iii) Control It provides control over small payments. (iv) Convenience in preparing ledger amounts.
184
(Ref.: T.S. Grewal, Double Entry Book Keeping) Check your progress Q 4. Prepare a Petty cash book on the Imprest System. From the following: 2005 Jan 1 Jan 2 Jan 3 Jan 4 Jan 5 Received Rs500 for Petty Cash Paid bus fare Paid for stationary Paid for postage and telegrams Paid for Cartage 20 130 170 100
Check you progress Activity 2 Find out what are the similarities and dissimilarities between a Cash Book and Pass Book.
185
12.7.1. MEANING
The cash Book and Pass Book are prepared separately. The Businessman prepares the Cash Book and the Pass Book is prepared by the Bank (here by cash book we mean three column cash Book). But as both the books are related to one person and same transactions are recorded in both the books so the balance of both the books should match i.e. the balance as per Pass Book should match to balance at bank as per cash book. But many a times these two balances do not agree then, it becomes necessary to reconcile them by preparing a statement which is called Bank Reconciliation Statement. A BANK RECONCILIATION STATEMENT may be defined as a statement showing the items of differences between the cash book balance and the pass book balance, prepared on any day for reconciling the two balances.
2.
3.
4.
5.
Cheques issued but Entry is made not yet presented for payment Balance =Decreased Cheques paid into Entry is made the bank but not yet cleared. Balance = Increased Interest allowed by No entry is made till the Bank the Pass Book is checked Balance = Same Interest and No entry is made till Expenses Charged the Pass Book is by the Bank checked Balance = Same Interest and No entry is made till
6.
7.
8.
9.
10
dividends collected the Pass Book by Bank checked Balance = Same Direct payments by No entry is made the bank the Pass Book checked Balance = Same Direct payments No entry is made into the bank by a the Pass Book customer checked Balance = Same Dishonor of a bill No entry is made discounted with the the pass Book bank checked Balance = Same Bills collected by No entry is made the bank on behalf the Pass Book of the customer checked Balance = Same Errors committed either in Cash Book or Pass Book
is Balance = Increased till Entry is made is Balance = decreased till Entry is made is Balance = Increased till Entry is made is Balance = decreased till Entry is made is Balance = Increased
OF
BANK
The need and importance of the bank reconciliation statement may be given as follows: 1. The reconciliation process helps in bringing out the errors committed either in cash Book or Pass Book. 2. Bank reconciliation statement may also show any undue delay in the clearance of cheques. 3. Sometimes the cashier may have the tendency of cheating like he may made entries in the Cash Book only but never deposit the cash into bank. These types of frauds by the entrepreneurs staff or bank staff may be detected only through bank reconciliation statement. So this way bank reconciliation statement acts as a control technique too. (Ref.: T.S. Grewal, Double Entry Book Keeping)
will reach to the other balance. This way both the balances will agree. The way the adjustments should be made may be illustrated as follows:
Particulars Balance at Bank as per Cash Book Add (i) (2) (3) (4) (5) Less: (1) (2) (3) (4) Cheques paid into the bank but not Xx yet cleared Interest and expenses charged by Xx the bank Direct payment by the Bank Xx Dishonor of a bill discounted with Xx the bank Cheques issued but presented for payment not yet Xx Xx
Interest and dividend collected by Xx the bank Direct payments into the bank by a Xx customer Bills collected by the bank on Xx behalf of the customer (+) xx
(-) xx Xxx
Note: If you start the question with balance as per passbook all the adjustments will be reversed. Example 5. : From the following prepare a bank reconciliation statement on 31st March 2005. 1. 2. 3. Balance as per Cash Book Cheques paid into Bank on March 2005 but credited by the bank in April 2005 Cheques issued in March 2005 but cashed in April 2005 1,80,000 7,900 11,000
188
4. 5 6
Cheques entered in the Cash Book in March 2005 but paid into bank in April 2005 Interest allowed by the bank Interest charged by the bank
Solution Bank Reconciliation Statement As on March 31, 2005 Particulars Add. 1. 2. Less: 1. 2. 3. Balance as per Cash Book Cheques issued but not cashed Int. allowed by bank Cheques paid into bank but not yet cleared Cheques entered into Cash Book but not deposited into bank Interest charged by Bank Balance as per Pass Book 11,000 2500 7,900 1,000 500 Amount 1,80,000 + 13,500 1,93,500
Check your progress Q. 1. Prepare a bank reconciliation statement from the following information 1. 2. 3. 4. 5. 6. 7. Balance as per pass book Cheques deposited but not yet collected Cheques issued but not yet presented for payment Expenses paid by the bank directly Bill dishonored (discounted with the bank) Commission charged by the bank Interest allowed by the bank 3,357 790 650 1,000 500 13 10
.. .. .. ..
189
12.8. SUMMARY
After going through the basic accounting concepts, one should be able to understand as well as to prepare the subsidiary books like cash book, pass book etc. A Cashbook is a very important tool of having control over items of expanses. It facilitates the businessman to have knowledge that from what sources he is receiving money and on what items he is spending that money. Cashbook gives him detailed information regarding receipts and payments and that helps the businessman to exercise control over the expanses and the performance of the business. Cashbook is the record of cash and bank transactions prepared by the entrepreneur and the Passbook is the statement of accounts prepared by the bank. There are lot of reasons due to which the balances of Cashbook and Passbook do not match, and then Bank Reconciliation statement is prepared to reconcile both the balances which also facilitates checking of errors and frauds in these books.
12.9 GLOSSORY
Presentation of cheque Depositing the cheque into bank for receiving payment. Clearing of cheque Collection of the amount of cheque by the bank. Bills Receivable - An instrument in writing containing an unconditional order, signed by the maker directing a certain person to pay a certain sum of money to certain person or the bearer of the instrument. Dishonor of Bill A situation when the acceptor of the bill refuse to pay the amount or otherwise unable to do so.
190
191