Tally ERP 9

Tally ERP 9 ........................................................................................................................................... 2

Golden Rules of Accounts ................................................................................................................ 4
Short Cut Keys .................................................................................................................................. 4
Types of Voucher in Details ............................................................................................................. 5
Ledgers Accounts .............................................................................................................................. 5
Journal Entry ........................................................................................................................................ 7
Assignment 1...................................................................................................................................... 7
Assignment 2...................................................................................................................................... 8
Assignment 3...................................................................................................................................... 9
Assignment 4.................................................................................................................................... 10
Bill by Bill ............................................................................................................................................ 11
Assignment -1 .................................................................................................................................. 11
Assignment-2 ................................................................................................................................... 12
Inventory.............................................................................................................................................. 13
Assignments 1 .................................................................................................................................. 13
Assignments 2 .................................................................................................................................. 14
Assignments 3 .................................................................................................................................. 15
Assignment-4 ................................................................................................................................... 17
Cost center ........................................................................................................................................... 18
Assignment1 ............................................................................................................................... 18
Assignment-2 ................................................................................................................................... 19
Assignment-3 ................................................................................................................................... 20

1
 Tally ERP 9
Accounts: - Accounting Is An Art Of Recording, Classifying,
Summarizing, Analysis, Interpretation Of Financial
Transaction & Events.

Accounts: - Is A Finance Support System That

1. Record Transaction.
2. Classified Transaction.
3. Express Transaction In Monitory Terms.
4. Help to Establish Control For The Business

Types Of Account

Personal Account Impersonal Account

Real Account Nominal Account

Intangible
Tangible Assets
Assets

2
 Types Of Accounts.

Personal Account: - Personal Account means, the person (Individual or

Artificial) receives the benefits from business Those
benefits person account is said to be debited. If the
person gives any benefit to the business then that
person’s a/c is credited.

Personal account are classified in two parts: -

1) Individual or Natural Person.

e.g. Vishal , Sam, Dinesh
2) Artificial Person
e.g. Name of College, Name of Company pvt ltd, Name of Bank,
Name of Institute, Any Name of Firm or Shop

Impersonal Account:- Accounts which is not related to person is called

impersonal account.

Impersonal account are classified in two parts: -

1) Real Account: - The thing is your own possession is called real account.
The elements or accounts which represent tangible and
intangible assets.

A) Tangible Assets: - Tangible Assets that can be seen, touched, purchase

and sold such account are called Tangible assets.
e.g. Cash, Building, Mobile, Furniture.

B) Intangible Assets: - An intangible asset is an asset that lacks physical

substance and usually is very hard to evaluate.
e.g. patents, copyrights, franchises, goodwill,
trademarks, trade names.

2) Nominal Account: - It includes all income & expenses of the Firm,

Company & Business.
e.g. Salary, Rent, Bills, Carriage, Wages, Interest,
Commission, Discount Received or Paid

3
 Golden Rules of Accounts
Personal Account :- Debit The Receiver

Credit The Giver.

Real Account :- Debit What Comes In.

Credit What Goes Out.

Nominal Account :- Debit All Expenses & Losses.

Credit All Income & Gains.

Short Cut Keys

ALT +C = To Create A New Ledger In Between Transaction

ALT +D = To Delete.

ALT + E = Export.

ALT + P = To Print.

CTRL +A = To Select / Accept.

CTRL + N = Calculator.

CTRL + M = For Going Back To Same Position.

CTRL + V = It Is Used In F8 & F9 When We Don’t Have Any

Stock Items.

4
 Types of Voucher in Details

ALT+F1 = To Select A Company /To Shut A Company

ALT+F2 = To Change the Period & F2 to Change the Date

ALT+F3 = Company Information

F4 = Contra Entry (Cash/Bank, Deposits /Withdrawal)

F5 = Payment (Paid of any kind of Expenses)

F6 = Receipt (Receive of Any Kind of Income)

F7 = Journal Entry (Purchase Return, Sales Return)

F8 = Sales

F9 = Purchase

CTRL+F10 = Memorandum Voucher.

F11 = Accounting Features.

F12 = Configure

Ledgers Accounts

NAME UNDER
Bills payable : - Current Liabilities.

Bills receivable : - Current assets.

Building : - Fixed assets.

Carriage Inward : - Direct expenses.

Carriage Outward :- Indirect expenses.

5
Cash : - Cash in hand.

Commission received : - Indirect income.

Commission Paid : - Indirect expenses

Interest received :- Indirect income.

Bank A/C :- Bank A/C.

Interest Paid : - Indirect expenses.

Drawings : - Capital A/C.

Furniture : - Fixed assets.

Goods : - Current assets.

Mr. Sam : - Sundry creditors.

Mr. Vishal : - Sundry debtors.

Mr. Deepak : - Capital A/C.

Profit & Loss A / C : - Primary.

Purchase : - Purchase A / C

Purchase return : - Purchase A / C.

Sales : - Sales A / C.

Sales return : - Sales A / C.

Rent : - Indirect expenses.

Salary : - Indirect expenses.

Telephone bills : - Indirect expenses.

Wages : - Direct expenses.

Capital A / C : - Capital A / C.

Office expenses : - Indirect expenses.

6
 Journal Entry
Assignment 1
1/1/14 started business with cash Rs.25000/-

3/1/14 Deposit into the bank Rs.5000/-

4/1/14 Purchases goods for cash Rs.10000/-

5/1/14 Sold goods for cash Rs.15000/-

6/1/14 Purchase goods from Sharma Rs.5000/-

7/1/14 Sold goods to Varma Rs.8000/-

8/1/14 Return defective goods to Sharma Rs.500/-

9/1/14 Varma returned defective goods Rs.1000/-

10/1/14 Paid cash to Sharma Rs.4000/-

12/1/14 Received cash from Varma Rs.6000/-

15/1/14 Received interest Rs.1500/-

17/1/14 Received commission Rs.2000/-

18/1/14 Paid Interest Rs.1000/-

19/1/14 Paid commission Rs.1500/-

20/1/14 Purchase goods from Suraj Rs.8000/-

24/1/14 Paid Rs.3000/- to Suraj by Cheque

25/1/14 Sold goods for cash Rs.1000/-

28/1/14 Deposited into the bank Rs.5000/-

29/1/14 Paid Salary 5000/- by Cheque

30/1/14 Withdrawal from Bank Rs.3000/-

31/1/14 Paid Rent Rs.2000/-

Balance Sheet: - 30500/- Trial Balance: - Profit & Loss:-

7
Assignment 2
1/4/98 Started a Business with Cash Rs.25000/- & Goods Rs.15000/-

2/4/98 Purchase goods for cash Rs.5000/-

3/4/98 sold goods for cash Rs.8000/-

4/9/98 Purchase Goods from Mona Rs 4000/-

5/8/98 Sold Goods to Sona Rs.6000/-

6/8/98 Sona Returned Goods Worth Rs.200/-

7/8/98 Returned Defective Goods To Mona Rs 500/-

8/8/98 Paid Cash to Mona 2000/-

9/8/98 Deposited Into Bank Rs. 5000/-

10/8/98 Received Cash from Sona Rs. 4000/-

11/8/98 Paid Rent by Cheque Rs.1000/-

12/8/98 Issued Cheque to Mona Rs.500/-

13/8/98 Cash Withdraw From Bank Rs.1000/-

14/8/98 Received Cash from Sona Rs.1000/-

15/8/98 Paid Salary Rs.2000/- Electricity Charges Rs.500/- & Phone

Charges Rs.500/-

Balance Sheet: - 42,300/-

Trial Balance: -

Profit & Loss: -

8
Assignment 3
1. Janhavi Started Business With Rs.5000/-

2. Purchased Furniture For Rs.1000/-

3. Purchased Goods For Rs.3500/-

4. Sold Goods For Rs. 400/-

5. Sold Goods For Rs. 800/- To Rahim

6. Paid Rent Rs. 20/-

7. Sold Goods Of Rs. 1200/- To Karim

8. Opened A Bank Current A/C By Depositing Rs. 1000/-

9. Karim Returned Goods Of Rs. 120/-

[Link] Paid Rs. 50/- by cheque.

[Link] Goods Of Rs. 1000/- From Gafoor

[Link] Goods Of Rs. 50/- To Gafoor

[Link] Commission Rs .15/-.

[Link] Cheque For Rs. 500/- To Gafoor.

[Link] Rs. 200/- From The Bank For Office Use.

[Link] Rs. 50/- From The Office Cash For janhavi’s Personal use

[Link] a cheque for Rs. 300/- from Rahim.

[Link] a cheque for Rs.500/- to the Janhavi’s son for his college fees.

Balance Sheet: - 4,900/-

Trial Balance: -

Profit & Loss: -

9
Assignment 4
1. Sawant started business with cash Rs.12000/-

2. Purchased goods from Mehta Rs.3000/-

3. Deposited cash into bank Rs.3000/-

4. Sold goods to Shah Rs.2000/-

5. Purchased furniture at Rs.1500/- from Yashraj.

6. Paid to Mehta by cheque of Rs.800/-

7. Received a cheque of Rs.500/- from Shah

8. Paid commission Rs.200/-

9. Withdraw cash Rs.100/- for personal use

10. Returned goods of Rs.50/- to Mehta

11. Received goods of returned by Shah Rs.45/-

12. Paid salary to Clerk by cheque Rs.500/-

13. Received cheque for rent Rs.800/-

14. Withdraw cash Rs.500/-from bank for office use

15. Return furniture of Rs.200/-to Yashraj.

Balance Sheet: - 15,350/-

Trial Balance: -

Profit & Loss: -

10
 Bill by Bill
Assignment -1
1. Shriram started business with cash Rs.2000/-

2. Brought goods from john on 10thdays credit Rs1000/-(Bill no 14)

3. Sold goods for cash Rs200/-

4. Sold goods to Shree on 8 day credits 500/- (Bill no 11)

5. Returned goods to john worth Rs 100/-(Bill no 14)

6. Purchased goods for cash Rs 325/-

7. Purchased goods on credit form Sumit Rs1200/-(Bill no 20)

8. Bought office furniture from Robert credit Rs. 800/- (Bill no 22)

9. Shree returned goods of Rs 75/-(Bill no 11)

[Link] to Robert on account of worth Rs 480/-

[Link] goods to Sumit worth Rs 150/- (Bill no 20)

[Link] goods form john Rs 1500/- (Bill no 25)

[Link] form Shree Rs 425/-

[Link] cash to John on account Rs 500/-

[Link] goods to David on 8 day credit Rs 450/- (Bill no 20)

[Link] returned goods worth Rs 50/- (Bill no 20)

[Link] form David Rs200/-

[Link] salary Rs600/-

Balance Sheet: - 5,270/-

Trial Balance: -

Profit & Loss: -

11
Assignment-2
1) Vinayak started business with cash Rs. 5000

2) Purchase goods for Gopal on 15 day credit Rs. 560 (bill No 22)

3) Sold goods to Ramakant on 8 days credit Rs.560 (bill No 10)

4) Returned goods to Gopal Rs. 240 (bill No 22)

5) Sold good to Pandit on 7 days credit Rs.900 (bill No 40)

6) Purchase goods from Patel on 15 days credit Rs. 600 (bill no 33)

7) Ramakant return goods of Rs. 36 (bill no 10)

8) Sold goods Ashok on 8 days credit Rs.700 (bill no 29)

9) Pandit return goods of Rs. 50 (bill no 40)

10) Purchase goods from gopal on 10 days credit Rs. 200 (bill no 35)

11) Paid cash to Gopal Rs. 500 (bill no 22)

12) Sold goods to Ramakant on 5 days credit Rs.500 (bill no 40)

13) Received cash from Ramakant Rs.300 (bill no 10)

14) Ashok return goods of Rs.80 (bill no 29)

15) Received cash from Pandit Rs. 500(bill no 40)

16) Paid cash to Gopal Rs. 200 (bill no 35)

Balance Sheet: - 6,594/-

Trial Balance: -

Profit & Loss: -

12
 Inventory

Assignments 1
[Link] Started Business With Cash Rs.5, 00,000 Furniture Rs.20, 000.

Apr1 Purchased 100 Kg Rice From Mr. Aryan. (26/- per kg)

Apr4 Purchased 50 Kg Wheat From [Link]. (35/- per kg)

Apr6 Purchased 20 Kg Sugar From [Link]. (32/- per kg)

Apr8 Purchased 50 Kg Rice From [Link] On Credit.

Apr10 Purchased 20 Kg Wheat from [Link] on Credit

Apr12 Purchased 5 Kg Sugar from Mr. Aryan on Credit

Apr14 Returned To Mr. Aryan 5 [Link].

Apr 16 Returned To Mr. Aayush 2 [Link].

Apr 18 Returned To [Link] 5 [Link]

Balance Sheet: - /-

Trial Balance: -

Profit & Loss: -

13
Assignments 2
Mr. Sony Started Business with Cash Rs75000, Furniture Rs.15000

Apr 1 Sold 30 Mts Cotton Dress Materials to Mr. Sayon

Apr 8 Sold 50 Mts Silk Dress Materials To Mr. Krishna

Apr 10 Sold 200 Nos Punjabi Suits to Mr. Sujay

Apr 12 Sold 50 Mts Khadi Dress Materials to Mr. Sujay on Credit

Apr 15 Sold 20 Mts Bandhani Dress Materials Mr. Krishna on Credit

Apr 18 Sold 50 Mts Kosa Dress Materials Mr. Sayon on Credit

Apr 20 Returned From Mr. Sayon 5 Mts Kosa Dress Materials

Apr 23 Returned From Mr. Krishna 10 Mts Bandhani Dress Materials

Apr 29 Returned From Sujay 12 Mts Khadi Dress Materials

Balance Sheet: - /-

Trial Balance: -

Profit & Loss: -

14
Assignments 3
Mr. Kamat started business cash with 50000/-. Furniture-25000/-, building
100000/-.

Opening stock

Stock Quantity Rate per

Electrical bulbs 2000 nos 8
Wall clock 100 nos 250
Wires 2000 mts 10
Screws 50 Dz 5
Monitor 15 nos 900
Box strips 1000 mts 20
Switch 500 nos 10
Apples 200 kg 60
Mango 200 dz 250
Grapes 200 kg 40
Water melon 50 nos 25
Orange 100 nos 10
Strawberries 200kg 300
Potatoes 200 kg 20
Onion 200 kg 18
Sweet potatoes 200 kg 25
Lady fingers 200 kg 30
Cabbage 200 kg 18
Bringles 200 kg 22

15
April-1 Purchased 20dz Screws, 5nos Monitor, 10nos Wall Clock

April 3 Sold 500nos Electric Bulbs, 100mts Wires, 200mts Box Strips

April 5 Purchased 20nos Switch 10nos Electric Bulbs Mr. Satyam on

Credit

April 7 Sold 5nos Monitor, 10nos Screws to Mr. Bhavan on Credit

April 9 Retuned 2nos Monitor, From Mr. Bhavan

April 11 Retuned To Mr. Satyam 5nos Switch, 3nos Electric Bulbs

April 13 Purchased 20dz Mango 5kg Apple, 10kg Grapes

April 15 Purchased 10nos Water Melon 10 Nos Orange, 20kg

Strawberries

April 17 Purchased 20nos Water Melon, 10nos Orange from Mr. Satyam
on Credit

April 19 Sold 5dz Mango, 10kg Grapes to Mr. Bhavan on Credit.

April 21 Returned 2dz Mango from Mr. Bhavan

April 23 Returns to [Link] 5 Nos Water Melon & 3 Nos Orange.

April 25 Purchase 10 Kg Potatoes 10kg Onion, 5 Kg Sweet Potatoes.

April27 Sold 5 Kg Lady Fingers, 5 Kg Cabbage & Bringles

April28 Purchased 20kg Sweet Potato’s & 5 Kg Cabbages from

[Link] on Credit.

April29 Sold 25 Kg Cabbages & 25 Kg Potato’s To Mr. Bhavan on

Credit.

April30 Returned 5 Kg Cabbages From Mr. Bhavan.

April30 returned to Mr. Satyam 3 Kg Sweet Potato’s.

Balance Sheet: - /-

Trial Balance: -

Profit & Loss:

16
 Assignment-4

Particular Monitor keyboard mouse monitors Hard disk total

Qty Rate Qty rate Qty rate Qty rate Qty rate
[Link] purchase 5 5250 5 325 5 315 5 4100 5 4350 71700
[Link] purchase from
6 5350 3 350 9 325 4 4450 8 4100 86675
modern com.
3. sold goods for cash 3 5750 3 550 3 425 3 4850 3 4500 48225
[Link] to modern
1 5350 1 350 1 325 0 0 1 4100 10125
com.
5. Credit sales to
akshay info.
2 3850 3 525 4 450 2 4775 3 4450 33975
[Link] purchase from 11875
10 5500 12 350 15 250 5 4050 9 3950
D.J system 0
[Link] sales to Vijay
1 6000 1 450 1 375 1 4750 1 4600 16175
Sys

8. Return from akshay

1 3850 0 0 1 450 0 0 2 4450 13200
info.
[Link] sales to ashwin 1 5900 1 400 1 400 1 4450 1 4750 15900
[Link] sales to
satyam com.
3 5800 4 450 2 375 2 4400 2 4450 37650
[Link] sales to
rupesh
2 5650 2 375 2 425 2 4500 1 4700 26600
[Link] return by
1 5650 1 375 0 0 0 0 1 4700 10725
rupesh
[Link] purchase
3 5300 4 350 2 550 1 4250 2 4325 31300
from abhay sales ltd.

17
 Cost center
Assignment 1
Mr. Roy started business with cash Rs.10, 000/-, Machinery Rs.30, 000/-, Loose
tools Rs20, 000/- Bank Rs. 75,000/-

They have 4 different department

Food department

Toys department

Cosmetic department

Medicine department

1. Purchase goods of.30,000/-in cash for food department Rs.10,000/-Medicine

department Rs.10,000/-Toys department Rs.5,000/-cosmetic department
Rs.5,000/-

2. Sold goods to cash Rs.50,000/- for food department Rs.10,000/-Toys

department Rs.15,000/-cosmetic department Rs.15,000/- Medicine department
Rs.10,000/-

3. Purchase Machinery for Food department Rs.10,000/-Toys

departmentRs.8,000/-

4. Paid electricity charges Rs.40,000/-for Food department Rs.10,000/-Medicine

department Rs.7,000/- Toys department Rs.13,000/- cosmetic department
Rs.10,000/-

5. Paid advertisement expenses worth Rs.20,000/-for Food department

Rs.6,000/-Medicine department Rs.4,000/-Toys department Rs.6,500/-cosmetic
department Rs.3,500/-

6. Received commission for Food department Rs.10,000/-Toys department Rs.

15,000/-

7. Cash withdrawn by bank worth Rs.50,000/-

18
 Assignment-2

Mr. Mahadev Started Business On Capital Rs 500000/-

Sr. NAMES OF DEPARTMENTS

Particular TV AC FREEDGE WASHING C.D OVEN TOTAL
no MACHINE PLAYER
1 Cash Purchase 60000 30000 90000 45000 3300 25000 253300
2 Carriage Inward 3000 1500 4500 2550 3330 1900 16780
3 Cash Sales 48000 24000 72000 36000 10300 15500 205800
4 Paid Carriage Outward 1000 500 1500 750 500 250 4500
5 Credit Purchase From M/S. 120000 60000 180000 90000 45000 12300 507300
Traders
6 Paid Carriage Inward 6000 1500 9000 2250 4550 750 24050
7 Cash Sales 180000 90000 270000 135000 8000 11000 694000
8 [Link] To Mahesh 96000 5000 144000 75000 15000 12000 347000
9 [Link] To Ramesh 48000 5000 72000 70000 58000 3000 256000
10 [Link] Fromvideocon 180000 7000 270000 65000 2000 5000 529000
11 Paid Carriage Inward 8000 3000 12000 4400 200 700 28300
12 Paid For Advertisement 10000 9000 7000 8000 6000 5000 45000
13 Cr Purchase From Bpl 20000 30000 40000 25000 35000 30000 180000
14 Paid For Printing And 100 100 100 100 100 0 500
Stationary
15 Godown Rent Paid By Rent 250 300 400 350 200 150 1650
16 Electricity Bill Paid By Cash 1000 1000 1000 1000 1000 1000 6000
17 Paid Octrai Net Purchase 4% 4% 4% 4% 4% 4% 58784
18 Wages Paid By Cash 300 400 900 1000 500 250 3350
19 Commission Paid On Sales 2% 3% 4% 5% 12.% 10% 65299
20 Salary Paid By Cash 2000 2000 2500 1500 1000 1000 10000

19
Assignment-3
Following information the cash RS.2500000 started business MS. Shivram Automobiles.

Particular Hero Suzuki TVS Honda Bajaj Total

1 Cr. purchase from Sham & Co. 1000500 750,000 801000 500,000 275000 3326500
2 Cr. purchase from Dhoot Auto. 1340000 925000 712000 200000 300000 3477000
3 Paid carriage in word by cash. 10000 7000 2000 3000 1500 23500
4 Cash sale to Kamal trades. 900000 500000 300000 400000 285000 2385000
5 Cash paid to Dhoot Auto. 170000 150000 90000 75000 50000 535000
6 Credit sale to Ram agency. 50,000 100000 100000 150000 180000 580000
7 carriage out word paid by cash 7000 6500 3000 2000 1500 20000
8 Cash purchase. 500000 300000 450000 150000 105000 1505000
9 Paid for Advertisement 3000 4000 2000 1700 2000 12700
10 Octrai paid by cash. 1000 300 450 700 650 3100
11 Paid for printing & stationary. 7000 5000 1000 1300 900 15200
12 Cr. Purchase from Vijay traders. 500000 300000 275000 325000 200000 1600000
13 Carriage in word paid by cash. 5000 3000 2750 3250 2000 16000
14 Cash sale to Gade & co. 350000 275000 285000 180000 195000 1285000
15 Insurance premium paid by cash 1500 2500 3500 4500 5500 17500
16 Commission paid by cash. 7500 3200 4350 3750 5250 24050
17 Carriage out word paid by cash. 1000 2000 3000 4000 5000 15000
18 Cr. Purchase form A.S. traders. 100000 100000 100000 100000 100000 500000
19 Wages paid by cash. 1000 1000 1000 1000 1000 5000
20 Returned goods to A.S. traders. 5000 4000 3000 2000 1000 15000

20
 VAT (VALUE ADDED TAX)

Definition :- vat is system of indirect taxation which has been introduced in lieu of sales
tax .it is tax paid by the producers, manufactures retailers or any other dealer who add value
to the goods &that is ultimately passed on to the consumer.

There are 550 categories of good`. Under the vat system there

Is classified into the following 3 groups depending on the vat?

Vat @ 4%

The largest number of goods (270)comprising of basic necessity items such as drugs &
medicine, agriculture & industrial input capital goods &declared goods are under Vat 4%
rate.

Vat @1%

This is for a specific category of goods like gold, silver etc. Articles of gold, silver &
precious metals including jewelry made from gold silver & precious metals.

Vat 12.5%

The remaining commodities are under the general vat rate i.e. 12.5 %

21
ASSIGNMENT.1

1. MR. MUKESH STARTED BUISNESS WITH CASH RS 25, 0000/-

2. PURCHASE FOLLOWING ITEMS FROM VIDIOCON

NAME OF
QTY RATE VAT
ITEMS
TV 10 5000 12.5%
CD 15 2000 12.5%
FREEZE 5 7000 12.5%
3. PIAD FOR CARRAGE RS 500/-

4. SOL TO M/S VIJAY ELECTRONICS THE FOLLOWNING ITEMS

NAME OF
QTY RATE VAT
ITEMS
TV 5 5200 12.5%
CD 7 2200 12.5%
FREEZE 2 7500 12.5%
5. PAID COMMISSION RS 1000/-

6. PAID RS 12500 TO VIDIOCON INFULL SETELMENT.

7. PAID FOR ADVERTISEMENT RS 250.

8. PURCHASE FOLLOWING MATERIAL FROM REJESH CASH

NAME OF
QTY RATE VAT
ITEMS
TV 8 4800 12.5%
CD 10 1900 12.5%
FREEZE 5 6800 12.5%
9. PAID FOR CARRAGE OUTWORDS RS 500.

10. RECEIVED RS 6000/- FROM MS VIJAY ELECTRONIC INFULL SETTELMENT.

11. SOLD FOLLOWING MATERIALS FOR CASH TO RAJESH.

NAME OF
QTY RATE VAT
ITEMS
TV 10 5100 12.5%
CD 15 2100 12.5%
FREEZE 5 7200 12.5%

22
ASSIGNMENT 2
1. MR NAVEEN TRADERS STARTED BUISNESS WITH CASH RS 1,50,000/-
2. OPEND BNAK A/C IN DENA BANK BY DEPOSITING RS 5000/-
3. PURCHASE FOLLOWING MATERIALS FROM M/S SAHYOG TRADERS
NAME OF
QTY RATE VAT
ITEMS
CHAIRS 15 175 12.5%
TABLE 5 750 12.5%
CUPBOARD 5 250 12.5%
4. PAID FOR CARRAGE RS 1500/-
5. SOLD FOLLOWING MATERIALS TO AJAY FURNITURE
NAME OF
QTY RATE VAT
ITEMS
CHAIRS 15 250 12.5%
TABLE 5 1100 12.5%
CUPBOARD 5 3000 12.5%
6. PAID COMMISSION RS 2000/-
7. PAID CASH TO M/S SAHYOG TRADERS RS 50,000/- AT PART PAYMENT OF THEIR DUES
8. PURCHASE FOLLOWING MATERIALS FOR CASH
NAME OF
QTY RATE VAT
ITEMS
CHAIRS 10 150 12.5%
TABLE 20 700 12.5%
CUPBOARD 10 2500 12.5%
9. SOLD THE FOLLOWING MATERIALS FOR CASH
NAME OF
QTY RATE VAT
ITEMS
CHAIRS 10 250 12.5%
TABLE 10 1000 12.5%
CUPBOARD 10 2800 12.5%
10. RECEIVED RS 20000/- FROM M/S AJAY FURNITURE AS PART PAYMENT
11. PAID SALARY RS 5000
12. PAID FOR RENT RS 3000
13. PASS NESSESARY VAT ADJUSTMENT ENTRY...

23
Assignment 3

MR. CJ Home Appliance Started Business with Cash of Rs. 60000/- , furniture of Rs. 50000/-,

Building Rs. 40000/-.

DEVICES QTY AMT

GODREJ AC 1.5 TON 4 18000
GODREJ WASHING 5 15000
MACHINE
GODREJ AIR COOLER 2 7000
21 ‘’ Color TV . 5 9000
DVD 4 4000
Refrigerator 3 9500

Purchase good from M/S GODREJ.

Godrej AC 1.5 10nos RS. 180000/-

Godrej washing machine 10nos RS. 150000/-
Godrej Air Cooler 10nos Rs. 70000/-
INPUT VAT @ 12.5%

1) Purchase good from M/S ONIDA

21’’ Color TV. 10nos Rs. 90000/-

DVD 10nos Rs. 40000/-
Refrigerator 10nos Rs. 95000/-
INPUT VAT @ 12.5%

2) Purchase good from M/S SAMSUNG

21’’ Color TV. 10nos Rs. 90000/-

DVD 07nos RS. 28000/-
Refrigerator 07nos RS. 66500/-
INPUT VAT @ 12.5%

3) Sold good to M/S Aditi Enterprises

21’’ Color TV 5nos Rs . 45000/-

DVD 5nos Rs. 20000/-
Refrigerator 5nos RS. 47500
OUTPUT VAT @ 12.5%

24
Assignment 4:

Purchased Goods from Mr. A for Following Goods

Small Exercise Book 100 pcs Rs. 25/-

Medium Exercise Book 150 pcs Rs. 20/-
Input Vat @ 12.5%

Sold Goods to Mr. B for flowing goods

Navnit Book 20 0pcs Rs. 50/-

Novels 12 0pcs Rs. 100/-
Output Vat @ 12.5%

Return goods to Mr. A for following goods

Small Exercise Book 50 pcs Rs. 25/-

Medium Exercise Book 20 pcs Rs. 20/-

Mr. B Return the following goods

Navnit Book 50 pcs Rs. 25/-

Novles 20 pcs Rs. 100/-

Purchase goods from General Stores

Sugar 300 bgs Rs. 185/-

Wheat 100 bgs Rs. 50/-
Salt 200 bgs Rs. 75/-
Input Vat @ 4%

Sold Goods to Tata Tea Company

A Grad Tea 150 bgs Rs. 185/-

Coffee 125 bgs Rs. 75/-
Golden Tea 175 bgs Rs. 150/-
Output Vat @4%

25
TAX DEDUCTED AT SOURCE

DEFINITION

Tax deducted at source is one of the modes of collecting income tax. The buyer (detector)
deduct the tax from the payment mode to the seller (deductee) & remits the tax to the income
tax department within stipulated time.

TDS nature of payment

1. Payment on account of re-purchase of units by……

2. Payment of contractors (other than advertisement)
3. Payment to non-resident sportsman sports association.
4. Payment to contractors (advertisement contractors).
5. Payment to sub-contractors.
6. Rent
7. Winning from horse race.
8. Winning from lotteries & cross word puzzles.
9. Commission on sale of lottery tickets.
10. Commission on brokerage.
11. Fees for professionals of technical services.
12. Income from foreign currency bonds or shares of
13. Income in respect of units of units of non-residents
14. Income of foreign institutional investors from…
15. Insurance commission
16. Interest on securities
17. Interest other than interest on securities.
18. Others sum payable to non-residents.
19. Payment of compensation on acquisition of immovable property.
20. Payment in respect of deposit under NSS.
21. Payment in respect of units to as off shore fund.

26
Features of TDS

The TDS functionality in tally supports the following features

1. Simple & user friendly.

2. Quick & easy to set up & use
3. Accounting for tax on partial & full payments of tds.
4. Flexibility for auto & manual calculations of tds.
5. Complete tracking of each transaction from deduction to payments.
6. Managements & printing for prompt & accurate filing of tax.
7. Allows multi party printing.
8. Form 16 A management
A. Can be printed for a transaction.
B. Can be printed for a period.
C. Can be printed for yearly.
9. The automatic allocation features prevents error-[prone date entry & helps to track
the transaction faster.
10. 10 It even generates from 16 A, Tds challan, Tds computation & TDS payable
reports.

27
TDS (Tax Deduction of Sources)
Sundry Creditors Roy Services

Indirect Expenses Technical Services

Duties & Taxes TDS on Technical Services

Total Expenses 600000

Sundry Creditors Vikas Agarwal

Indirect Expenses Rent

Duties & Taxes TDS on Rent

Total Expenses 200000

Sundry Creditors Bank Publishing LTD.

Indirect Expenses Advertisement Contracts

Duties & Taxes TDS on Advertisement Contracts

Total Expenses 50000

Sundry Creditors Sumit Advertising Agency

Indirect Expenses Advertisement Expenses

Duties & Taxes TDS on Advertisement Expenses

Total Expenses 300000

28
Import & export

There are two types of import & Export:

1. Tally to Excel.
2. Company to company.

Tally to excel

Select any company and go to profit & loss A/C. Press Alt+F1for more details. Press Alt+E
(For Export). Press Backspace button for entering details:

Language :-Default (All Language)

Format :-Excel (Spreadsheet)

Output file name :-any name&.xls enter & export.

THEN …..

Minimize Tally & Open Microsoft Excel. Go to file, click on open button. Select My
Computer Option, select D-Drive or C-Drive, select Tally ERP9 folder select file.

2. Company to Company:
Go to display, then List of Accounts. Press Ctrl+End, alt+E

Press Backspace Button for Entering Details.

Language :-Default (All Language)

Format :-Xml (data interchange)

Output file name :-company [Link]

Types of Masters :-All Masters

Esc & go to Balance Sheet. Press Alt+E, Press backspace Button, all Enter Export &
Overwrite. Go to Display, Trail Balance press Alt+E, press Backspace Button. Enter Export
& Overwrite. Go to Daybook. Press Alt+E, press Backspace button. Press Enter Export &
Overwrite.

Then,

Press Alt+F3 to create a new company or select a company

Go to import of Data

29
Masters:-

Import file name :-company [Link]

Treatment of entries already existing :-Modify with new data.

Vouchers

Import file name :-[Link].

3 TIMES ESCAPE

THEN YOU CAN SEE ALL DATA………

30
Service tax

Definition:

Service tax an indirect tax on certain category of services provided by a person, firm, agency
Etc. Service tax is applicable on 97 categories of service. A person /firm providing a service
that come Under the service tax category has to pay service tax.

Abatement: some category of service includes material value. A caterers has to procure
material to Prepare food products & sale services. Service tax is charged on the total amount
for the service & does not include the rate of the material procured. Hence a deduction is
provided. The deduction from the service charges to be considered for service tax is called
abatement. Abatement is either a percentage of the service charges or a lump sum value.

Adjusting 100% & 20%CR.

If you providing a consultancy service over the phone then you can use the input cr. From the

Telephone charges to adjust against 100%of the service tax payable on your consultancy
service. If the input service is solely used for the output service then 20% cr. Adjustment is
applicable.

31
Service tax assignment

 Purchase fashion designing services from Aditi rs.10000/-

 Sold disha franchise to [Link] for rs.100000
 Service tax 12.36%

Purchase

1. Blue dart courier service >purchase a/c

2. Mr. ram >sundry creditors
3. Service tax on courier service>duties and taxes
4. Amount 4000/- 12.36%

Sales

1. Kingfisher air ticket >sales a/c

2. [Link] >sundry debtor
3. Service tax on air ticket >duties and taxes
4. Amt-95000/service tax.12.36%

Purchase

1. Building construction serves—purchase a/c

2. [Link] – sundry creditor
3. Service tax on construction service—duties and taxes
4. Amt –70000/ service tax 12.36%

Sales

1. Sai cable service –sales a/c

2. Service tax on cabal services—duties and taxes
3. [Link] – S.D.
4. Amt. 80000/-S.T.12.36%

32
BANK RECONCILIATION STATEMENT

Problem for Reconciliation

Date Particulars

1\4\9 Started Business with Cash Rs. 10000/-

2\4\9 Open a Bank A/C in State Bank of India by Depositing Rs 5000

3\4\9 Fees Collected From Students Rs 40000/ In Cash

4/4/9 Rs 40000/ Cash Transfer To Bank

5/4/9 Paid Electricity Charges Rs 3000/ By Cheque … (Cheque No 543069)

7/4/9 Paid Telephone Charges Rs 2500/ By Cheque …..(Cheque No 543070)

10/4/9 Paid Salary To [Link] Rs 4000/By Cheque ….( Cheque No 543071)

12/ 4/9 Received Cheque for Fees from Mr Ganesh Kale Rs 3940... (Cheque No
7133065)

15/4/9 Paid Office Rent Rs 6000 to Mr Kulkarni Shekhar By Cheque

(Cheque No 543072)

33