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
01.7.1996 Paid by cheque to Abdul Rs.5,000 01.7.1996 Paid to Ramu by cheque
Rs.1,880
01.7.1996 Cheque received from Gopal Rs.7,000 01.7.1996 Cheque received for sales from Raghu
Rs.9,000
01.7.1996 Payment made to Kishore Rs.3,790 01.7.1996 Cheque paid (Karthik) for the purchase made
Rs.3,525
01.7.1996 Salaries paid to Jagadeesh Rs.1,530 02.7.1996 Paid to Sathish
Rs.2,890
02.7.1996 Received from Shekar Rs.7,435 02.7.1996 Commission received (Basu)
Rs.915
02.7.1996 Payment made to Abdul Rs.1,025 02.7.1996 Mani paid his dues
Rs.3,400
PASS BOOK
DATE
PARTICULARS
Rs.
DATE
PARTICULARS
Rs.
01.7.96
To Abdul A/c
5,000
1.7.96
By Balance b/d
26,120
01.7.96
To Ramu A/c
1,880
01.7.96
By Gopal A/c
7,000
01.7.96
To Kishore A/c
3,790
01.7.96
By Raghu A/c
9,000
01.7.96
To Karthik A/c
3,525
02.7.96
By Basu A/c
915
01.7.96
To Jagadesh A/c
1,530
02.7.96
By Murugan A/c
1,900
02.7.96
To Insurance A/c
100
02.7.96
By Interest A/c
232
02.7.96
To Bill Payable A/c
1,550
02.7.96
By Int. on Investment A/c
735
31.7.96
To Balance c/d
31,097
02.7.96
By Bills Receivable A/c
2,570
TOTAL
48,472
TOTAL
48,472
HOW TO VIEW OPTIONAL VOUCHERS?
Gateway of Tally Display Exception Reports Optional
Vouchers Give period
