tally-second year practical

from the following prepare final accounts ,bankbook/cashbook and bank reconciliation statements

Transactions are taken from the book of TC stores Thiruvambady: -

2012

JAN 1   started business  Rs. 3,00,000

jan 2     cash deposited into bank Rs.2,00,000

jan 31   purchased goods and issued cheque No.2228 for Rs. 50,000

Feb1     sold goods to Sivaprasad and received cheque for Rs. 50,000 and deposited into bank

feb2      Purchased goods and issued cheque no. 2229 for rupees Rs. 75000

feb2      purchased goods and issued cheque no.2230 for rupees Rs. 25000

feb28    sold goods to Mr,Chandran and received a cheque for rs.Rs. 70,000 and deposited in to bank

april1    cash deposited in to bank for Rs.50000

april 2    Rent paid by cheque no.2231 for Rs. 10000

              on comparing the cash book with bank statement the following facts  are revealed

1. cheque no.2228 was cleared-on april 1,2012

2 .Sivaprasad's cheque was collected only on feb 28

3. cheque number 2229 and 22231 not cleared

4. cheque received from Mr .chandran was not collected.

PROCEDURE:-

Create company-

G W T ------> Com Info.------->Create company (Alt+F3)

Create Ledger accounts:-

G W T------->Accounts Info--------->Ledger ------>Create ------> single/Multiple

name of ledger	Voucher Type	account group	Dr./Cr.	amount
CASH CAPITAL	F6 -Receipts	-currentasset            CAPITAL	Dr.                            Cr.	3,00,000                 3,00,000
BANK CASH	F4-Contra	BANK Current asset	Dr. Cr.	2,00,000 2,00,000

Purchases To Bank	F9-purchases	PURCHASES BANK	Dr. Cr.	50,000 50,000
Sivaprasad To Sales	F8-sales	sundry debtors Sales account	Dr. Cr.	50,000 50,000
Purchases   To Bank	F9-purchases	Purchases Bank	Dr. Cr.	75,000 75,000
Purchases  To Bank	F 9-Purchases	Purchases Bank	Dr. Cr.	25,000 25,000
Mr.Chandran  To Sales	F 8 -Sales	Sundry Debtors Sales	Dr. Cr.	70,000 70,000
Bank  To cash	F 4 Contra	Bank	Dr. Cr.	50,000 50,000
Rent  To Bank	F5- Payments	Indirect Expenses	Dr. Cr.	10,000 10,000

Step 3. G W T ------->VOUCHER ENTRY

STEP 4. G W T -------> BANKING----->BANK RECONCILIATION----->BANK ACCOUNT

DISPLAY THE STATEMENT AND SET THE BANK DATE

TRANSACTION	BANK BATE
2	jan 2
3	jan 31
5	feb2
6	feb2

 Enter the bank date and accept it

The bank reconciliation Screen is displayed .........