HOME TALLY HOME



tally erp9 training

TALLY ERP9

BANK RECONCILIATION STATEMENT IN TALLY ERP 9?

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