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
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)
~ 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
~ 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
18.7.1996 Cheque received from Gopal Rs.7,000 19.7.1996 Cheque received for sales from Raghu
20.7.1996 Payment made to Kishore Rs.3,790 20.7.1996 Cheque paid (Karthik) for the purchase made
26.7.1996 Salaries paid to Jagadeesh Rs.1,530 26.7.1996 Paid to Sathish
26.7.1996 Received from Shekar Rs.7,435 28.7.1996 Commission received (Basu)
28.7.1996 Payment made to Abdul Rs.1,025 28.7.1996 Mani paid his dues
To Abdul A/c
By Balance b/d
To Ramu A/c
By Gopal A/c
To Kishore A/c
By Raghu A/c
To Karthik A/c
By Basu A/c
To Jagadesh A/c
By Murugan A/c
To Insurance A/c
By Interest A/c
To Bill Payable A/c
By Int. on Investment A/c
To Balance c/d
By Bills Receivable A/c
HOW TO VIEW OPTIONAL VOUCHERS?
Gateway of Tally Display Exception Reports Optional
Vouchers Give period