BANK RECONCILIATION STATEMENT: We check the balances shown by the Cash Book prepared by us, with the Bank’s Pass Book
every month. Sometimes they may not tally as some debits & credits are entered only in Cash Book
and some others only in Pass Book. So we prepare BRS to rectify the differences.
ACTIVATION: F11: Features Use Reversing and
Optional voucher = Yes
THREE STEPS
1. Removing common entries.
2. Converting extra entries into “Optional” voucher.
3. Entering missed entries in our Tally.
STEPS TO RECONCILE:
~ Select the Bank Book.
~ Open the date wise transactions.
~ Press ‘F5: Reconcile’ and go to edit mode.
~ Enter the bank transactions dates under ‘Bank Date’ column. (Edit Mode)
~ Accept.
~ Again press F5 (Reconcile). ~ You can notice the transactions that are not entered in the Bank’s Pass Book; i.e. the
amount not reflected in the Pass Book.
~ Find out the vouchers appearing in our Book and not appearing in Pass Book.
~ Convert those entries into ‘Optional Vouchers’ in our book.(i.e. in Tally)
~ Find out the transactions from the Bank’s Pass Book, which are not entered in our Cash
Book.
~ Post the missed vouchers in our book. ~ Now the balances of Cash Book and Pass Book will tally.
Exercise: Post the following transactions in “BRS Enterprises” and reconcile the balances.
01.7.1996 Opening Balance Rs.26,120
03.7.1996 Paid by cheque to Abdul Rs.5,000 15.7.1996 Paid to Ramu by cheque
Rs.1,880
18.7.1996 Cheque received from Gopal Rs.7,000 19.7.1996 Cheque received for sales from Raghu
Rs.9,000
20.7.1996 Payment made to Kishore Rs.3,790 20.7.1996 Cheque paid (Karthik) for the purchase made
Rs.3,525
26.7.1996 Salaries paid to Jagadeesh Rs.1,530 26.7.1996 Paid to Sathish
Rs.2,890
26.7.1996 Received from Shekar Rs.7,435 28.7.1996 Commission received (Basu)
Rs.915
28.7.1996 Payment made to Abdul Rs.1,025 28.7.1996 Mani paid his dues
Rs.3,400
PASS BOOK
DATE
PARTICULARS
Rs.
DATE
PARTICULARS
Rs.
4.7.96
To Abdul A/c
5,000
1.7.96
By Balance b/d
26,120
16.7.96
To Ramu A/c
1,880
20.7.96
By Gopal A/c
7,000
20.7.96
To Kishore A/c
3,790
20.7.96
By Raghu A/c
9,000
20.7.96
To Karthik A/c
3,525
30.7.96
By Basu A/c
915
28.7.96
To Jagadesh A/c
1,530
30.7.96
By Murugan A/c
1,900
26.7.96
To Insurance A/c
100
31.7.96
By Interest A/c
232
28.7.96
To Bill Payable A/c
1,550
31.7.96
By Int. on Investment A/c
735
31.7.96
To Balance c/d
31,097
31.7.96
By Bills Receivable A/c
2,570
48,472
48,472
HOW TO VIEW OPTIONAL VOUCHERS?
Gateway of Tally Display Exception Reports Optional
Vouchers Give period
