Ex.
No : 1
Date :
CREATION OF COMPANY LEDGERS AND SHOW
THE TRAIL BALANCE
AIM :
To create a Company with the following ledger under appropriate groups
and Show the Trail Balance
PROCEDURE :
Step 1 :
Double click on the Tally icon in the desktop and enter into the Gateway of
Tally screen.
Step 2:
Select the create Company option from the Company Info Menu (ALT + F3)
Step 3 :
Enter all the details of the Company Like Name of the Company, Mailing
Address and Type of the Company.
Step 4 :
Go By Gateway of Tally >> Accounts Info >> Multiple Ledgers >> Create
Step 5 :
First specify ALL items in the under Group and then given the name of the
ledger and specify ledger which group an then name of the ledger which
group it comes also specify the opening balances and then accept by
pressing “ YES “ key to save it.
Step 6:
Go by Gateway of Tally >> Display >> Trail Balance.
1
Program 1 : Prepare the Trail Balance of Anitha Company.
S.No. Particulars Amount
1. Capital 50,000
2. Cash 15,760
3. Bank 12,800
4. Purchase 27,100`
5. Sales 27,000
6. Furniture 15,000
7. Stock in Hand 1,800
8. Brokerage 40
9. Typewriter 2,100
10. Rent Paid 1,000
11. Salary 1,500
12. Return Inward 100
13. Return Outward 1100
14. Debtors 4400
15. Travelling Expenses 100
16. Sundry creditors 4200
17. Discount Allowed 100
18. Telephone Charges 500
2
LEDGER ENTRY :
3
OUTPUT
TRAIL BALANCE
4
Ex. No : 2
Date :
CREATION OF COMPANY GROUPS, LEDGERS AND
SHOW THE TRAIL BALANCE
AIM :
To create a Company with the following Groups, Ledger under appropriate
groups and Show the Trail Balance
PROCEDURE :
Step 1 :
Double click on the Tally icon in the desktop and enter into the Gateway of
Tally screen.
Step 2:
Select the create Company option from the Company Info Menu (ALT + F3)
Step 3 :
Enter all the details of the Company Like Name of the Company, Mailing
Address and Type of the Company.
Step 4 : Go by Gateway of Tally >> Accounts Info >> Multi Group >> Create.
Step 5 : If needed subgroup can be created ( Ex. Salary , Drawings….)
Step 6 :
Give the name of the Sub – Groups and specify under which primary groups
Its comes. Accept by pressing “ YES “ to save it.
Step 7 :
Go By Gateway of Tally >> Accounts Info >> Multiple Ledgers >> Create
Step 8 :
First specify ALL items in the under Group and then given the name of the
ledger and specify ledger which group an then name of the ledger which
group it comes also specify the opening balances and then accept by
pressing “ YES “ key to save it.
Step 9:
Go by Gateway of Tally >> Display >> Trail Balance.
5
Program 2 : Prepare the Trail Balance of Thanshika Spares.
S.No. Particulars Amount
1. Accountant Salary 12,000
2. Proprietor Salary 36,000
3. Staff Salary 24,000
4. Advertisement 6,150
5. Drawings 50,000
6. Electricity 5,572
7. Printing and Stationery 2,955
8. Purchases 6,11,625
9. Rent 25,200
10. Salary 72,000
11. Telephone Charges 4,565
12. Travelling Expenses 1,846
13. Wages 30,600
14. Cash at Bank 1,599
15. Cash in Hand 3,342
16. Compressors 34,000
17. Computers 34,000
18. Furniture and Fixtures 21,350
19. Motors 7,000
20. Stock in Hand 21,000
21. Sales 4,23,155
22. Service Charges 1,43,550
23. Additional Capital 35,000
24. Capital 2,00,000
25. Sundry Creditors 53,099
26. Unsecured Loans 1,50,000
6
LEDGER ENTRY :
7
OUTPUT
TRAIL BALANCE
8
Ex.no : 3
Date :
ENTERING ACCOUNTING VOUCHERS IN TALLY
AIM :
To pass entries in accounting vouchers in Tally and display the day book.
PROCEDURE :
Step 1:
Double click the tally icon in the desktop and enter into the Gateway of
Tally.
Step 2:
Create a company by using “ Company Info “ Menu and enter all the details
of the company.
Step 3:
Go by Gateway Tally >> Accounts Info >> Ledger >> Create single or Multiple
Ledger for each entry
Step 4:
Go by Gateway of Tally >> Accounting Vouchers
Step 5 :
While passing before entries press F12 key and press “ NO “ for use single
entry mode for “ Payment / Receipt / Contra “ option.
Step 6:
Pass the necessary entries in Double Entry Format ( Ex. To / By )
Step 7:
To change the Purchase, Sales, Invoice Format to Voucher Format. Press
CTRL + V
Step 8 :
Go by Gateway of Tally >> Display >> Daybook.
9
Program 3:
1. Mohan Started a business with cash Rs.20,000.
2. Bought goods for cash Rs.10,000.
3. Sold to Lal Rs.12,000.
4. Bought goods from Arun Rs.5,000.
5. Sold goods for cash Rs. 8,000.
6. Paid into Bank Rs.8,000.
7. Received from Lal Rs. 7,000.
8. Paid to Arun Rs. 3,000
9. Paid for Stationery Rs. 2,00
10. Bought Furniture for Office Use Rs.1,750
11. Paid for Postage Rs. 20.
12. Paid for General Expenses Rs. 50
13. Paid for Salary Rs.2,500
14. Paid for Rent Rs.750.
10
LEDGER ENTRY :
11
JOURNAL ENTRY :
S.NO. ENTRY VOUCHER AMOUNT
1. By Cash A/C Dr Receipt 20,000
To Mohan’s Capital
2. By Purchase A/C Dr Purchase 10,000
To Cash
3. By Lal A/C Dr Sales 2,000
To Sales
4. By Purchase A/C Dr Purchase 5,000
To Arun
5. By Cash A/C Dr Sales 8,000
To Sales
6. By Bank A/C Dr Contra 8,000
To Cash
7. By Cash A/C Dr Receipt 7,000
To Lal
8. By Arun A/C Dr Payment 3,000
To Cash
9. By Furniture A/C Dr Payment 1,750
To Cash
10. By Stationery A/C Dr Payment 200
To Cash
11. By Postage A/C Dr Payment 20
To Cash
12. By General Expenses A/C Dr Payment 50
To Cash
13. By Salary A/C Dr Payment 2500
To Cash
12
14. By Rent A/C Dr Payment 750
To Cash
OUTPUT
DAY BOOK REPORT
13
Ex.no : 4
Date :
ENTERING ACCOUNTING VOUCHERS AND SHOW
THE TRAIL BALANCE
AIM :
To pass entries in accounting vouchers in Tally and display the day book.
PROCEDURE :
Step 1:
Double click the tally icon in the desktop and enter into the Gateway of
Tally.
Step 2:
Create a company by using “ Company Info “ Menu and enter all the details
of the company.
Step 3:
Go by Gateway Tally >> Accounts Info >> Ledger >> Create single or Multiple
Ledger for each entry
Step 4: Go by Gateway of Tally >> Accounting Vouchers
Step 5 :
While passing before entries press F12 key and press “ NO “ for use single
entry mode for “ Payment / Receipt / Contra “ option.
Step 6:
Pass the necessary entries in Double Entry Format ( Ex. To / By )
Step 7:
By pressing F11 Key and Select “ YES “ option for Debit and Credit Notes.
Step 8 :
To change the Purchase, Sales, Invoice Format to Voucher Format. Press
CTRL + V
Step 9 : Go by Gateway of Tally >> Display >> Daybook
14
Program 4 :
1. Mr. Murugan commenced a business with capital of Rs.1,00,000.
2. Sold Goods to Anand Rs.10,000
3. Sold Goods to Balan Rs.7,000
4. Sold Goods to Muthu Rs. 43,000
5. Commision Received Rs.500
6. Anand Returned Goods worth Rs.750
7. Balan Returned Goods worth Rs.500
8. Muthu Returned Goods Worth Rs.1,000
9. Bought Goods from Murali Rs.20,000
10. Bought Goods from Mohan Rs.24,000
11. Bought Stationery Rs. 750
12. Returned Goods to Murali Rs.3,000
13. Bought Goods for cash Rs.6000
14. Collected from Balan Cash Rs. 6,500
15. Collected from Anand Cash Rs.9,250
16. Paid Salary Rs.2,000
17. Wages Paid Rs.2,000
18. Electricity Charges Rs.1,000
15
LEDGER ENTRY :
16
JOURNAL ENTRY :
S.NO. ENTRY VOUCHER AMOUNT
1. By Cash A/C Dr Receipt 1,00,000
To Murugan’s Capital
2. By Anand A/C Dr Sales 10,000
To Sales
3. By Balan A/C Dr Sales 7,000
To Sales
4. By Muthu A/C Dr Sales 43,000
To Sales
5. By Cash A/C Dr Receipt 500
To Commission Received
6. By Sales Return A/c Dr Credit Note 750
To Anand
7. By Sales Return A/c Dr Credit Note 500
To Balan
8. By Sales Return A/c Dr Credit Note 1000
To Muthu
9. By Purchase A/C Dr Purchase 20,000
To Murali
10. By Purchase A/C Dr Purchase 24,000
To Mohan
11. By Purchase A/C Dr Purchase 750
To Cash
12. By Murali A/C Dr Debti Note 3,000
To Purchase Return
13. By Purchase A/C Dr Purchase 6,000
To Cash
14. By Cash A/C Dr Receipt 6,500
To Balan
17
15. By Cash A/C Dr Receipt 9,250
To Anand
16. By Salary A/C Dr Payment 2,000
To Cash
17. By Wages A/C Dr Payment 2,000
To Cash
18. By Electricity Charges A/C Dr Payment 1,000
To Cash
OUTPUT
18
Ex.no : 5
Date :
ENTERING ACCOUNTING VOUCHERS AND DISPLAY A TRADING AND
P&L A/C AND BALANCE SHEET
AIM :
To pass entries in accounting vouchers in Tally and display the day book.
PROCEDURE :
Step 1:
Double click the tally icon in the desktop and enter into the Gateway of
Tally.
Step 2:
Create a company by using “ Company Info “ Menu and enter all the details
of the company.
Step 3:
Go by Gateway Tally >> Accounts Info >> Ledger >> Create single or Multiple
Ledger for each entry
Step 4:
Go by Gateway of Tally >> Accounting Vouchers
Step 5 :
While passing before entries press F12 key and press “ NO “ for use single
entry mode for “ Payment / Receipt / Contra “ option.
Step 6: Pass the necessary entries in Double Entry Format ( Ex. To / By )
Step 7: By pressing F11 Key and Select “ YES “ option for Debit and Credit Notes.
Step 8 :
To change the Purchase, Sales, Invoice Format to Voucher Format. Press
CTRL + V
19
Step 9 : Go by Gateway of Tally >> Display >> Trail Balance
Step 10 : Go by Gateway of Tally >> Display >> Profit and Loss A/C
Step 11 : Go by Gateway of Tally >> Display >> Balance Sheet
Step 12 :
Press Alt + F1 to view the result of Profit and Loss A/C and Balance Sheet
in detailed Format
Program 5 :
1. Mr.Ajay invested in business Rs.1,00,000
2. Bought Furniture for Rs.25,000
3. Paid Salary Rs.5,000
4. Paid Rent Rs.3,000
5. Wages Rs. 5,000
6. Carriage Inward Rs.1,500
7. Bought Goods from Mr.Suresh Rs.50,000
8. Sold Goods to Mr.Mukesh Rs. 75,000
9. Deposited into State Bank if India Rs.5,000
10. Purchased Goods for Cash Rs.7,000
11. Sold goods for cash Rs.15,000
12. Withdrawn cash for Personal Use Rs.1000
13. Depreciate furniture Rs.2,500
14. Paid Rs.48,000 to Mr. Suresh and received Discount of Rs.2,000
15. Cash received from Mr.Mukesh Rs.75,000 and Allowed Discount of Rs.5,000
16. Advertisement expenses Rs.2,000
17. Withdrawn cash from State Bank of India for office Use Rs.2,000
20
LEDGER ENTRY :
21
JOURNAL ENTRY :
S.NO. ENTRY VOUCHER AMOUNT
1. By Cash A/C Dr Receipt 1,00,000
To Ajay’s Capital
2. By Furniture A/C Dr Payment 25,000
To Cash
3. By Salary A/C Dr Payment 5,000
To Cash
4. By Rent A/C Dr Payment 3,000
To Cash
5. By Wages A/C Dr Payment 5,000
To Cash
6. By Carraige Inward A/C Dr Payment 1,500
To Cash
7. By Purchase A/C Dr Purchase 50,000
To Suresh
8. By Mukesh A/C Dr Sales 75,000
To Sales
9. By Bank A/C Dr Contra 5,000
To Cash
10. By Purchase A/C Dr Purchase 7,000
To Cash
11. By Cash A/C Dr Sales 15,000
To Sales
12. By Cash A/C Dr Contra 1,000
To Bank
13. By Depreciation A/C Dr Journal 2,500
To Furniture
14. By Suresh A/C Dr Payment 50,000
To Cash 48,000
2,000
To Discount Received
22
15. By Advertisement A/C Dr Payment 2,000
To Cash
16. By Cash A/C Dr Receipt 70,000
By Discount Allowed Dr 5,000
75,000
To Mukesh
17. By Drawings A/C Dr Payment 1,000
To Cash
23
OUTPUT
BALANCE SHEET
24
OUTPUT
PROFIT & LOSS ACCOUNT
25
Ex. No : 6
Date :
CREATION OF STOCK ENTRY
AIM :
To create a stock entry and Show the Stock Summary Report
PROCEDURE :
Step 1 :
Double click on the Tally icon in the desktop and enter into the Gateway of
Tally screen.
Step 2:
Create a Company by using “ Company Info “ menu and enter all the details
[ Particularly maintain : Accounts with inventory ]
Step 3 :
Creation of Stock Group of Shirt, Saree and Kidswear by using the
Gateway of Tally >> Inventory Info >> Stock Group >>
Multiple Group >>Create
Step 4 :
Creation of unit measure number in the symbol of “ Nos.” by using
Gateway of Tally >> Inventory Info >> Unit of Measure >> Create
Step 5 :
Creation of necessary stock item Ex. Cotton shirt and Formal Shirts under
Shirt group by using [ Gateway of Tally >> Inventory Info >> Stock Item >>
Multiple Stock Item >> Create
Step 6 : Go By Gateway of Tally >> Accounts Info >> Multiple Ledgers >> Create
Step 7 : Go by Gateway of Tally >> Accounting Vouchers
Step 8 :
By pressing Ctrl + V to change the voucher format to invoice format and
Invoice format to voucher
26
Step 9:
By pressing F11 key and type Yes to allow Invoicing option and type Yes to
enter Purchase / Sales invoice Format and accept it.
Step 10 :
Enter all the purchase, Sales Transactions are entered in invoice format.
Step 11 :
Goby Gateway of Tally >> Stock Summary
Step 12 :
To View the stock summary report in details by pressing Alt + F1 key.
Program 6 :
1. Purchase Shirt from Madura Coats Company.
Cotton Shirt – 15 Nos. – Rs. 130
Formal Shirt – 23 Nos. – Rs. 190
2. Purchase Sarees from Lakshmi Mills.
Punam Sarees – 18 Nos. – Rs. 350
Silk Sarees – 18 Nos. – Rs. 2500
3. Purchase Kidswear from Mangal Deep Company.
Frock – 15 Nos. – Rs. 370
Chudidhar – 12 Nos. – Rs. 420
4. Sold Shirts to Jeyachandran Textiles.
Cotton Shirt – 12 Nos. – Rs. 170
Formal Shirt – 15 Nos. – Rs. 220
27
5. Sold Sarees to RMKV Silks.
Punam Sarees – 14 Nos. – Rs. 430
Silk Sarees – 12 Nos. – Rs. 3800
6. Sold kidswear to Life Style.
Frock – 12 Nos. – Rs. 450
Chudidhar – 10 Nos. – Rs. 540
Stock Group : Shirt , Sarees , Kidswear
Unit of Measure : Nos.
Stock items : Cotton Shirt, Formal Shirt , Punam Sarees, Silk Sarees.
Frock, Chudidhar.
28
Accounts Info >> Ledger Entry
29
ACCOUNTING VOUCHERS :
30
31
32
OUTPUT
STOCK SUMMARY REPORT
33
Ex. No : 7
Date :
CREATION OF STOCK ENTRY
AIM :
To create a stock entry and Show the Stock Summary Report
PROCEDURE :
Step 1 :
Double click on the Tally icon in the desktop and enter into the Gateway of
Tally screen.
Step 2:
Create a Company by using “ Company Info “ menu and enter all the details
[ Particularly maintain : Accounts with inventory ]
Step 3 :
Creation of Stock Group of Shirt, Saree and Kidswear by using the Gateway
of Tally >> Inventory Info >> Stock Group >> Multiple Group >>Create
Step 4 :
Creation of unit measure number in the symbol of “ Nos.” by using
Gateway of Tally >> Inventory Info >> Unit of Measure >> Create
Step 5 :
Creation of necessary stock item Ex. SAMSUNG TV under SAMSUNG
COMPANY group and VIDEOCON TV AND WAHSING MACHINE under
VIDEOCON COMPANY by using [ Gateway of Tally >> Inventory Info >> Stock
Item >> Multiple Stock Item >> Create
Step 6 :
Go By Gateway of Tally >> Accounts Info >> Multiple Ledgers >> Create
Step 7 : Go by Gateway of Tally >> Accounting Vouchers
Step 8 :
By pressing Ctrl + V to change the voucher format to invoice format and
Invoice format to voucher
34
Step 9:
By pressing F11 key and type Yes to allow Invoicing option and type Yes to
enter Purchase / Sales invoice Format and accept it.
Step 10 :
Enter all the purchase, Sales Transactions are entered in invoice format.
Step 11 :
Goby Gateway of Tally >> Stock Summary
Step 12 :
To View the stock summary report in details by pressing Alt + F1 key.
Program 7 :
1. Purchase goods from Samsung Company
Samsung TV – 11 Nos. – Rs. 8,000
2. Purchased Goods from Videocon Company.
Videocon TV – 14 Nos. – Rs. 7,000
Videocon Washing Machine – 4 Nos. – Rs.6,000
3. Sold Goods to Mr. Ram
Samsung TV - 5 Nos. – Rs. 10,000
Videocon TV - 4 Nos. – Rs. 9,000
Videocon Washing Machine – 1 Nos. – Rs. 7,500
4. Sold goods to Mr. Arun
Samsung TV – 3 Nos. – Rs.10,000
Videocon TV – 4 Nos. – Rs.9,000
35
5. Purchase Return to Videocon Company
Videocon TV – 2 Nos. – Rs.7,500
Videocon Washing Machine – 1 Nos. – Rs.6000
6. Sales Return From Mr. Ram
Samsung TV – 1 Nos. – Rs. 10,000
Stock Group : SAMSUNG , VODEOCON
Unit of Measure : Nos.
Stock items : SAMSUNG TV , VIDEOCON TV, VIDEOCON WASHING MACHINE.
36
ACCOUNTS INFO >> LEDGER ENTRY
ACCOUNTING VOUCHERS
37
38
39
40
OUTPUT
STOCK SUMMARY REPORT
41
Ex. No : 8
Date :
PURCHASE BILL PENDING
AIM :
To create a Purchase Order and Display a Purchase Bill Pending
PROCEDURE :
Step 1 :
Double click on the Tally icon in the desktop and enter into the Gateway of
Tally screen.
Step 2:
Create a Company by using “ Company Info “ menu and enter all the details
[ Particularly maintain : Accounts with inventory ] of the company
Step 3:
Goby gateway of tally >> Accounts Info>>Ledger>>Create simple
Ledger for each entry
Step 4:
Create unit of measure Numbers, in the symbol of Nos by using[Gateway of
Tally>>Inventory info>>Unit of measure>>Create]
Step 5:
Creation of stock item Eg.T.Shirts Jeans by using[Gateway of tally>>
Inventory info>>Stock item>>Single or multiple stock item>>Create]
Step 6: Goby gate way of tally>>Inventory vouchers
Step 7:
By pressing F11:Features button and type yes for the option of ‘allow
purchase order processing
Step 8:
By type ‘yes’ for the option of use receipt notes/Delivery notes Vouchers
and use rejection in/out voucher.
42
Step 9:
Enter all the details of purchase order,receipt note,rejection out voucher.
Step 10:
Goby gateway of tally>>Display>>Statement of Inventory>>Purchase Bills
bending.To View the results in details by pressing Alt+F1 keys.
Program 8:-
1.Purchase order made to Sana Textiles (P.O.No.101)
T-shirt 100 nos @ Rs.100
Jeans 100 nos @ Rs.1000
Terms of payment : cash
Dispatch Through : Lorry
Terms of delivery : container
Destination : Madurai
2.Received materials for the purchase order form sana Textiles(P.O.No.101)
3.Returned goods to Sana Textiles
T-shirts 10 nos
Jeans 5 nos
43
ACCOUNTS INFO >> LEDGER ENTRY
STOCK ITEMS :
44
INVENTORY VOUCHERS :
45
46
OUTPUT
PURCHASE BILL PENDING
47
Ex. No : 9
Date :
SALES BILL PENDING
AIM :
To create a Sales Order and Display a Sales Bill Pending
PROCEDURE :
Step 1 :
Double click on the Tally icon in the desktop and enter into the Gateway of
Tally screen.
Step 2:
Create a Company by using “ Company Info “ menu and enter all the details
[ Particularly maintain - Accounts with inventory ] of the company
Step 3:
Goby gateway of tally >> Accounts Info>>Ledger>>Create simple
Ledger for each entry
Step 4:
Create unit of measure Numbers, in the symbol of Nos by using[Gateway of
Tally>>Inventory info>>Unit of measure>>Create]
Step 5:
Creation of stock item Eg. Cotton saree and Chudidhar by using[Gateway of
tally>>Inventory info>>Stock item>>Single or multiple stock item>>Create]
Step 6: Goby gate way of tally>>Inventory vouchers
Step 7:
By pressing F11:Features button and type yes for the option of ‘allow
sales order processing
Step 8:
By type ‘yes’ for the option of use receipt notes/Delivery notes Vouchers
and use rejection in/out voucher.
48
Step 9:
Enter all the details of sales order, delivery note, rejection in voucher.
Step 10:
Goby gateway of tally>>Display >> Statement of Inventory >> Sales
Bills bending. To View the results in details by pressing Alt+F1 keys.
Program 9:-
1.Sales order received from Arjun stores (S.O.No.111)
Cotton saree 60 nos @ Rs.500
Chudidhar 40 nos @Rs.750
Terms of payment : credit
Dispatch Through : Lorry
Terms of delivery : container
Destination : Chennai
2.Delivery note given to Arjun Stores for(S.O.No.111)
3.Returned goods From Arjun Stores
Cotton Saree 10 nos
Chudidhar 5 nos
49
ACCOUNTS INFO >> LEDGER ENTRY
STOCK ITEMS :
50
INVENTORY VOUCHERS :
51
52
OUTPUT
SALES BILL PENDING
53