++

7TALLY NOTES

Introduction of Tally
Software Developer Tally Solution Pvt. LTD.
Work from 1988 to 2011

Version Tally 4.5

Tally 5.4
Tally 6.3
Tally 7.2
Tally 8.1
Tally 9.0
Tally 9.0 Release 2.13
Tally 9.0 Release 2.14
Tally 9.0 ERP Releases 1.1

Type of Software
• Educational Software :- Its Demo purpose and study purpose
(We can fill only 1st and 2nd date of month)
1) SILVER EDITION MODE( single User)
2) GOLD EDITION MODE( Unlimited Use.)
• Professional Software :- License Copy of Tally Software

Use of Tally

ERP Stands for: Enterprise Resource Planning

Tally accounting is used to summarize record of all the transactions relating to
every person, every things of property and every type of records.

Company’s Financial Year: 1st April to 31st March

Golden Accounting Rules

• Personal A/c :- Name of persons, banks, firms comes under Personal a/c

For Example: - Mr. Ram, HDFC Bank A/c

Bank of Maharashtra, Tata Motor.

• Real A/c :-
For Example: - Cash A/c
Material A/c
Goods A/c (Purchase, sales, return)
Any fixed or current assets

• Nominal A/c :-

Commission Received A/c

Traveling Expenses
M.S.E. B. Bill
•
For Example: - Salary paid A/c

Personal Real account Nominal

account account
DEBIT The Receiver What Comes All Losses &
(sundry IN Expenses
Debtor)
CREDIT The Giver/ What Goes All Incomes
Given OUT & Gains
(sundry
Creditor)
Examples:

Ledger Group
Capital Capital account
Bank Bank account
Purchase Purchase account
Anil Sundry Creditor
Chandan Sundry Creditor
Harish Sundry Creditor
Purchase return Purchase account
Naveen Sundry Creditor
Sales Sales account
Gupta Sundry debtor
Commission Indirect expenses
Wages Direct expenses
Drawings Capital account
Manju Sundry Creditor
Anand Sundry Creditor

Ledger creation:
Path:

Gateway of Tally ---->> Account info (I) ---->> Ledger (L) ----->>
Create (C) Name of Ledger: ______a/c

Under : select group

Accept?

Yes/No
Ledger and their related groups are given as under:
Ledger Group
Opening stock Stock in hand
Purchase Purchase account
Purchase return Purchase account
Fright charges Direct expenses
Carriage inwards or Purchases Direct expenses
Cartage and coolie Direct expenses
Factory charges Direct expenses
Manufacturing wages Direct expenses
Coal, gas, water Direct expenses
Oil and fuel Direct expenses
Factory rent, insurance, electricity, lighting Direct expenses
and heating
Sales Sales account
Salary Indirect expenses
Postage and telegrams Indirect expenses
Telephone charges Indirect expenses
Rent paid Indirect expenses
Rates and taxes Indirect expenses
Insurance Indirect expenses
Audit fees Indirect expenses
Interest on bank loan Indirect expenses
Interest on loans paid Indirect expenses
Bank charges Indirect expenses
Legal charges Indirect expenses
Printing and stationery Indirect expenses
General expenses Indirect expenses
Sundry expenses Indirect expenses
Discount allowed Indirect expenses
Carriage outwards or sales Indirect expenses
Traveling expenses Indirect expenses
Advertisement Indirect expenses
Bad debts Indirect expenses
Repair renewals Indirect expenses
Motor expenses Indirect expenses
Depreciation on assets Indirect expenses
Interest on investment received Indirect income
Interest on deposit received Indirect income
Interest on loans received Indirect income
Commission received Indirect income
Discount received Indirect income
Rent received Indirect income
Dividend received Indirect income
Bad debts recovered Indirect income
Profit by sale of assets Indirect income
Sundry income Indirect income
Loan from other. Loan Liabilities
Bank loan Loan Liabilities
Bank overdraft Bank OD
Bills payable Current Liabilities
Sundry creditor. Sundry creditor.
Mortgage loans Secured loans
Expense outstanding Current Liabilities
Income received in advance Current Liabilities
Other liabilities Current Liabilities
Capital Capital account
Drawings Capital account
Cash in hand Cash in hand
Cash at bank Bank account
Fixed deposit at bank Deposit
Investments Investments
Bills receivable Current asset
Sundry debtor. Sundry debtor.
Closing stock Stock in hand
Stock of stationery Current asset
Loose tools Fixed asset
 Fixtures and fittings Fixed asset
Furniture Fixed asset
Motor vehicles Fixed asset
Plant and machinery Fixed asset
Land and building Fixed asset
Leasehold property Fixed asset
Patents Fixed asset
Goodwill Fixed asset
Prepaid expenses Current asset
Income outstanding Current asset
Accounting voucher:

1. Purchase (F9) :-

Any transaction are related to purchases good on cash or on credit that transaction entry
will be pass in purchase voucher.

Example: - 1) Purchase goods . 4,000/- by cash.

Goods ___ real ____ Comes in………Dr

Cash ___ real ____ Goes Out………Cr

2) Purchase good . 4,000/- on credit from Mr. Umesh.

Goods ___ real______ Comes in…….Dr.
Umesh___personal____giver________Cr.

2. Sales (F8) :-

“Ctrl + V” Any transactions are related to sales goods on cash or on credit that
transaction entry will be pass in sales voucher.
 Example: - 1) Sales good . 1,000/- by on credit
Goods ______ Real a/c _______ Goes Out……….Cr.
Cash ________ Real a/c _______ Comes In………Dr.

2) Sold goods . 1,500/- Joshi on credit.

Goods _____ Real ________ Goes Out ………….Cr.
Joshi ______ Pe.onal _____ Receiver ………….Dr.

3. Contra (F4) :-

Any transaction is directly related to cash and Bank that transaction entry will be saving
in Contra Vouche. always debits side and Bank A/c.
Example: - 1) Cash deposit into Bank
Cash ____Real _____Goes out _____Cr.
Bank ____ Pe.onal ____Receiver ____ Dr.

2) Cash withdraw from Bank

Cash ____ Real _____ Comes in …………Dr.
Bank ____ Pe.onal ____ Giver ………….Cr.

4. Payment (F5) :-

Any transaction is related to cash and Bank PAYMENT that transaction entry will be
passing in payment will be credited.

Example:-1). Paid Salary . 25,000/- to Mr. Amit.

Salary _______ Nominal A/c ______ Indirect Exp. _____ Dr.
Cash _________ Real a/c __________ Goes out _________Cr.

2). Paid Cash . 5,000/- to Sachin.

Sachin _______ Pe.onal a/c ______ Receiver _______ Dr.
Cash __________Real a/c _________ Goes out _______ Cr.

5. Receipt (F6) :-

Any transaction is related to cash and Bank (Cheque) RECEIVES that transaction entry
will be passing in receipt voucher always cash or Bank A/c will be debited.
 Example :- 1)Received . 10,000/- from Mr. Vishal
Cash ______ Real _____ Comes in ______Dr.
Vishal ______ Pe.onal______ giver ____ Cr.
2)Received commission . 2,000/- by cash.
Commission ____ Nominal _____ indirect income _____ Cr.
Cash ___________ Real ______ Comes In _______ Dr.

6. Journal (F7) :-

Any transaction is not related to cash, Bank and related to adjustment entries that
transaction entry will be pass in journal.
Example :- 1) Purchase Return
1. 2) Sales Return
A) Bill Receivable
Bills receivable from Ram.
Bills receivable _______ Current asset ____ Dr.
Ram _____ personal ______ Giver _______ Cr.
B) Bill payable
Bills Payable _________ Current Liability _____ Cr.
Ram ______________ Pe.onal _________ Receiver _____ Dr.

7. Debit note: (ctrl + f9): transaction of purchase return

8. Credit note: (ctrl + f8) : transaction of sales return

CONTRA VOUCHER (F4)

All cash and bank transactions will be made in Contra Voucher.

1) Deposited into Bank/ Bank of India of Rs-5000/-

Ledger: GOT- accounts info------ ledgers------create

a) Cash a/c

Under: Cash-in-hand

b) Bank a/c/ Bank of India

Under: Bank accounts

Entry: Contra F4

Cr. Cash

Dr. Bank/ Bank of India

2) Cash withdrawn from Bank of Maharashtra of Rs--2000/-

Ledger: a) Cash

Under: Cash-in-hand

b) Bank of Maharashtra

Under: Bank accounts

Entry: Contra F4

Cr. Bank of Maharashtra

Dr. Cash

Solve the following problems:

1. Opened a current account into Bank of India by depositing .-2000/-

2. Deposited cash into Dena bank of Rs--10000/-
3. Withdrawn from Bank of Rs--5000 for personal use.
4. Withdrawn cash from Bank of Maharashtra of Rs--2000/-
5. Deposited cash into Bank of Rs--5000/-
6. Ramesh deposited cash into bank of Maharashtra of Rs--8000/-
7. Cash withdrawn by Suresh of Rs--7589 from Bank of Baroda.
8. Opening a saving a/c in the bank of Maharashtra by deposited of Rs- 600/-
9. Deposited in to bank of Rs- 3000.
10.Withdraw from bank of Rs- 1000.
11.Deposited in to bank of Rs- 8000.
12.Withdraw from bank of Rs- 2000.
13.Deposited in to bank of Rs- 7000.
14.Withdraw from bank of Rs- 5000.
15.Deposited in to bank of Rs- 15000.
16.Withdraw from bank of Rs- 5000.
17.Deposited in to bank of Rs- 15000.

PAYMENT VOUCHER (F5)

1) Paid cash to Ravi of Rs--5700/-

Ledger: a) Cash

Under: cash-in-hand

b) Ravi

Under: Sundry Creditor

Entry:

DR. Ravi

CR. Cash

2) Paid salary of Rs--5000/-

Ledger: a) Cash
 Under: cash-in-hand

b) Salary

Under: Indirect expenses

Entry:

DR. Salary

CR. Cash

Solve the following problems

A. Paid salary of Rs--5000/-

B. Paid electricity charges of Rs--750/-
C. Paid for postage and telegram of Rs--8900/-
D. Paid Audit fees of Rs--1500/-
E. Paid interest on bank loan of Rs--750/-
F. Paid Depreciation on furniture of Rs--875/-
G. Paid travelling expenses of Rs--1200/-
H. Paid for Printing and stationary of Rs--4500/-
I. Paid insurance premium of Rs--1250/-
J. Paid advertisement expenses of Rs--7890/-
K. Paid rates and taxes of Rs--7500/-
L. Paid telephone charges of Rs--9500/-
M. Interest on loan paid of Rs--7850/-
N. Cash paid to Ravi of Rs--7850/-
O. Paid depreciation on machinery of Rs--750/-
P. Cash paid to Ravi Shankar of Rs- 6000.
Q. Paid salary of Rs- 25000.
R. Paid office expenses of Rs- 2500.
S. Paid LIC premium of Rs- 5000.
 T. Paid telephone bill of Rs- 3500.
U. Paid travelling expenses of Rs- 2000.
V. Paid interest and commission to Pramod of Rs- 2500& 3000 respectively.
W. Paid municipal tax of Rs- 2500.
X. Paid electricity bill of Rs- 2500.
Y. Cash paid to Lalu of Rs- 25000.
Z. Cash paid to saraswati book depo of Rs- 1000.
Cash paid to mudra compute. Of Rs-6000

RECEIPT VOUCHER (F6)

Any transaction is related to cash and Bank (Cheque) RECEIVES that transaction
entry will be passing in receipt voucher always cash or Bank A/c will be debited.

Started business entry will pass in this voucher

1) Mr. Joshi started business with cash of -40000, furniture of =45000 and
building of -150000/-

Ledger: a) Joshi’s Capital a/c

Under: Capital a/c

b) Cash Under: cash-in-hand

c) Furniture
Under: Fixed Asset
d) Building
Under: Fixed Asset
Entry:
CR. Joshi’s Capital a/c
DR. Cash
 DR. Furniture
DR. Building

2) Cash received from Ramesh of Rs--2000/-

Ledger: a) Cash

Under: Cash-in-hand

b) Ramesh

Under: Sundry debtor

Entry: Receipt F6

Dr. Cash 2000

Cr. Ramesh 2000

3) Interest received of Rs--5000/-

Ledger: a) cash

Under: cash-in-hand

b) Interest received

Under: Indirect Income

Entry

Dr. Cash

Cr. Interest

Solve the following problems:

1. Mr. Jay started business with cash of -45000, furniture -75000/- and
building of -200000/-
2. Mr. Ganesh started his business with building and furniture of -275000/-,
cash of Rs-25000/-
3. Miss. Jaya Started business with cash, furniture, equipment of -30000,
76000 and 10000/-
4. Cash received from Dinesh of Rs--5000/-
5. Cheque received from Karthik of Rs--7500/-
6. Interest received of Rs--7850/-
7. Commission received of Rs--8560/-
8. Dividend received of Rs--4580/-
9. Cash received of Rs- 8000 from patil and sons.
10.Cheque received of Rs- 10000 from lalita surana.
11.Cash received of Rs- 7500 from sager.
12.Bills received of Rs- 8000 from Sonia.
13.Cash received of Rs- 25600 from sneha.
14.Cheqddue received of Rs- 105000 from subhash&company.
15.Cash received from Mohan joshi of Rs- 56900 on cash.
16.Cheque received from shree of Rs-1500.
17.Cheque received of Rs- 100000 from satpute trade.
18.Cheque received from Manish Mehta of Rs- 31280.
19.Bills received of Rs-105000 from mothoot finance.
20.Discount received of Rs--500/-
21.Interest on deposit received of Rs--4500/-
22.Interest on loans received of Rs--750/-
23.Interest on investment received of Rs--8750/-

JOURNAL VOUCHER (F7)

Purchased machinery or any fixed asset from anyone on credit then it entry will
be passed in Journal Voucher. Or any receivables and payables entry will pass in
this voucher.

1) Bills receivable of -7500/- from Suvarna.

Ledger: a) Bills receivable

Under: Current Assets

b) Suvarna

Under: Sundry Debtor

Entry:

Dr. Bills receivable

Cr. Suvarna

2) Bills Payable to Mr. Sachin of - 2500/-

Ledger: a) Bills Payable

Under: Current Liabilities

b) Sachin

Under: Sundry creditor

Entry:

Dr. Sachin

Cr: Bills Payable

Purchased machinery from Mahesh of -75000/-

Ledger: a) Machinery a/c

Under: Fixed Asset

B) Mahesh

Under: Sundry Creditor

Entry:

Dr. Machinery

Cr. Mahesh

Solve the following problems:

1. Purchased machinery from David of -8000/-

2. Purchased Furniture and Fixtures of -5000 & 7000/-Vikas traders.
3. Bills receivable from Karthik of - 5700/-
4. Bills payable to Sandeep of -4560/-
5. Purchased building of -110000/- from David
6. Purchased machinery from kirloskar&company of Rs- 55 000.
7. Purchased building from bajaj&company of Rs- 45000.
8. Purchased land from birla& sons of Rs- 35000.
9. Purchased compute from mudra sales of Rs- 25000/-
10.Purchased plant from Lhp Company of Rs- 15000/-
11.Bills receivable of -50000 from Ajay.
12.Bills payable to Sachin of -78000/-
13.Bills receivable for printing and stationary of -750/-
14.Bills payable of -7800/-to Mahidra finance.

STOCK ITEM CREATION

We can create stock items by using Inventory. To create stock items follow the
points given below:

1) Stock Group:

Gateway of Tally ------ >>Inventory Info. ---- >> Stock Group ------ >> Create

Name : Electronics

Under : Primary

Accept

Eg.

Electronics, stationary,vehicles, liquid, grains, garments

2) Units of Measurement

Gateway of Tally ------- >> Inventory Info ------- >> Units of Measure ------ >> Create

Symbol: no.

Formal Name: Number

Decimal Points: 0

Accept

Eg. No., pcs, kg, ltr, tn

Formal name:number, pieces, kilogram, litre, tonne

3) Stock Item:

Gateway of Tally ----- >> Inventory Info ----- >> Stock Item ------>> Create

Name: Mobile
Under: Electronics ( select Group)

Unit: no.(select Unit)

Accept

Eg. Books, pen, pencils, laptop, fridge, computer, CPU, keyboard, bike, car,

Cotton cloths

SALES VOUCHER (F8)

Sold car to Megha of Rs--10, 00,000/-

Ledger: a) Sales A/c

Under: Sales account

b) Megha

Under: Sundry Debtor

Entry:

Party Name: Megha

Sales Ledger: Sales account

Name of Item quantity rate Amount

Car 100000

Solve following problems:

1. Sold goods to Krishna of Rs-- 10000/-

2. Sold camera to Mohan of Rs--8000/-
3. Sold following goods to Shruti:
 i. 2 Apple Mobile@30000 each
ii. 3 Laptop@45000 each
4. Sold goods to Patil & sons of Rs- 8000 on credit.
5. Sold Samsung TV to Lalita Khorana of Rs-10000 on credit.
6. Sold fridge to sager of Rs- 7500 on credit.
7. Sold mobile to Sonia of Rs- 8000 on credit.
8. Sold laptop to sneha of Rs- 25600 on credit.
9. Sold land and building to subhash & company of Rs- 105000 on credit.
10.Sold machinery to LHP Company of Rs- 222000 on credit.
11.Sold old innova motor to Harish Mehta of Rs- 850000 on credit.
12.Sold old furniture to moothut finance of Rs- 105000 on credit.
13.Sold wheat & sugar to satpute trade. of Rs- 100000 on credit.

PURCHASE VOUCHER (F9)

Purchases:

1) By Cash

2) By cheque

3) On Credit

By Cash

1) Purchased Goods of Rs--25000/-

Ledger:

Gateway of Tally >> Accounting info >> ledger >> Create

a) Purchase a/c
Under: Purchase account
b) Cash
Under: Cash-in-hand

For entry:
G.O.T >> Accounting Voucher >> F9

Press ctrl+v

Entry: Purchase Voucher: F9

Cr. Cash

Dr. Purchase a/c

If Stock item is given then press CTRL+V

Party name: Cash

Purchase ledger: Purchase a/c

Name of Item

Laptop 40000

Narration

Solve following Problems:

1. Purchased goods of Rs--2000/-

2. Purchased laptop of Rs--40000/-
3. Purchased bike of Rs--65000/-
 4. Purchased computer of Rs--12000/-
5. Purchased fridge of Rs--10000/-

ON CREDIT

1) Purchased mobile of Rs--10000 from Rahul on credit.

Ledger: a) Purchase a/c

Under: purchase a/c

b) Rahul

Under: Sundry Creditor

Entry: Purchase Voucher: F9

Party Name: Rahul

Purchase ledger: Purchase Account

Name of Item quantity rate Amount

Mobile 10000

If Stock item is given then press CTRL+V

Entry

Cr. Party name

Dr. Purchase a/c

Solve the following problems:

1) Purchased laptop of Rs--25000/- from Dinesh on credit.
2) Purchased following items from Ravi on Credit.
i) 20 Pens@ 10 each
ii) 15 Big Exercise Book@40 each
iii) 2 Laptop@40000 each
3) Purchase following computer Items from Sam on Credit
i) 5 LG Monitor@5000 each
ii) 2 CPU@6000 each
iii) 5 Key board@500 each
4) Purchased type writer from Roy of Rs--8000 on Credit.
5) Purchased goods from Ajay of Rs-- 75000 on credit.
6) Purchased Samsung TV on credit from Ramesh of Rs--25000/- .
7) Purchased FAN on credit of Rs- 1850 from SUBHASH.
8) Purchased goods on credit of Rs- 10000 from Mahesh.
9) Purchased Compaq laptop on credit of Rs- 45000 from ANIL.
10) Purchased Books on credit of Rs- 1000 from Saraswati book depo.
11) Purchased Apple mobile on credit of Rs- 30250 from Mudra mobile shops.
12) Purchased hero honda bike on credit of Rs-
80000 from Laxmi automobile.
13) Purchased fridge on credit of Rs- 12500 from AMOL ELECTRONICS.
14) Purchased C.P.U. on credit of Rs- 18900 from GURUMAHARAJ COMPUTE.
15) Purchased keyboard on credit of Rs- 6000 from MUDRA COMPUTE.

DEBIT NOTE CTRL+F9

If we purchased some goods and if we have lots of stock of this product then we
returns some of goods to seller then this entry will passed in Debit Note.
It Used for only PURCHASE RETURN.

To activate debit/ credit note follow the path:

Gateway of Tally-------- >> F11 >>Accounting Features ------- >> Use Debit /
credit Note-------- >> Yes

1) Goods returned to Mahesh of - 7500/-

Ledger: a) Purchase Return a/c

Under: Purchase a/c

b) Mahesh:

Under: Sundry Creditor

Entry: Debit Note

CR. Purchase Return

DR. Mahesh

Solve the following problems:

1) Returned goods to Dinesh of -8650/-

2) Returned Samsung TV to Karthik of -7850/-
3) Returned goods to Ravi of -9850/-
4) Returned books to Mr. Vikas of -250/-
5) Goods returned to Ravi Shankar of Rs. 3000.
6) Samsung TV returned to Lalu of Rs. 25000.
7) Fan returned to subhash&company of Rs. 1850.
8) Goods returned to Mahesh of Rs. 3000.
9) Apple mobile returned to mudra mobile shopee of Rs. 30250.
10) CPU returned to gurumaharaj computer of -18900.
11) Compaq laptop returned to Anil Ambany of - 45000.
12) Returned following goods to Ramesh:
 i) 20small exercise book@50 each
ii) 15 Medium exercise book@60 each
iii) 10 Large exercise book@70 each
iv) 7 drawing book@40 each
13) Returned following items to Sanket:
i) 5keyboards@500 each
ii) 4 Mouse@400 each
iii) 3 monitor@5000 each
iv) 3 CPU@3000 each
14) Returned apple and Samsung mobile to Lalita of Rs-30000 and 15000/-

CREDIT NOTE CTRL (F8)

If we sold goods to someone and they returned some goods of them then this
entry will passed in Credit Note.

This Voucher entry is always used to Pass SALES RETURN entries.

1) Goods returned by Ramesh of Rs-2000/-

Ledger: a) Sales Return a/c

Under: Sales account

b) Ramesh

Under: Sundry Debtors

Entry:

DR. Sales Return

CR. Ramesh
Solve the following problems:

1) Goods returned by Ajay of Rs-4500/-

2) Samsung TV and LCD returned by Mahesh of Rs-10000& 25000/-
3) Following goods returned by Karthik:
i) 20shirt@500 each
ii) 40 T-shirt@600 each
iii) 15 Jackets@700 each
4) Goods returned by Patil & Sons of Rs.2500/-
5) Samsung TV returned by Lalita Surana of rs.10000.
6) Fridge returned by Sagar of rs.7500.
7) Mobile returned by Sonia of rs.8000.
8) Laptop returned by sneha of rs.25600.
9) Returned following goods by Ramesh:
i) 20small exercise book@50 each
ii) 15 Medium exercise book@60 each
iii) 10 Large exercise book@70 each
iv) 7 drawing book@40 each
10) Returned following items by Sanket:
i) 5keyboards@500 each
ii) 4 Mouse@400 each
iii) 3 monitor@5000 each
iv) 3 CPU@3000 each
11) Returned apple and Samsung mobile by Lalita of Rs-30000 and 15000/-
12) Goods returned to Ravi Shankar of Rs-5000.
13) Samsung TV returned to Lalu of Rs. 25000.
14) Fan returned to subhash&company of Rs. 1850.
15) Goods returned to Mahesh of Rs. 3000.
16) Apple mobile returned to mudra mobile shopee of Rs. 30250.
 Combine problems:

EXERCISE 1
1/4/2008 Started business with cash Mr. Joshi Rs. 25,000/- Furniture Rs.
20,000/- and building Rs. 1, 55,000/-
2/4/2008 Purchased goods from Mandar for Rs. 10,000/-
2/4/2008 Sold good to Tom for Rs. 12,000/-
4/4/2010 Purchased goods from Dixit on credit Rs. 5,000/-
4/4/2008 Sold goods to Sam on Credit Rs. 7,000/-
7/4/2008 Purchased Machinery for cash Rs. 10,000/-
7/4/2008 Opened Bank account in Bank of India with depositing Rs. 5,000/-
10/4/2008 Taken a loan Janta Bank Rs. 1, 50,000/-
12/4/2008 Purchased goods from X in Credit Rs. 10,000/-
13/4/2008 Sold goods to Y in credit Rs. 15,000/-
15/4/2008 Received Bill Receivable from Y Rs. 15,000/-
16/4/2008 Issued Bill Payable to X Rs. 10,000/-
20/4/2008 Returned goods to Mandar Rs. 1,000/-
21/4/2008 Received goods returned by Sam Rs. 2,000/-
23/4/2008 Withdraw from Bank Rs. 2,000/-
24/4/2008 Paid Salary Rs. 4,000/- and wages Rs. 2,000/- in cash.
27/4/2008 Received commission Rs. 3,333/-
28/4/2008 Paid electricity charges by cheque Rs. 1,000/-

EXERCISE 2

2/2/2002 paid Cash of Rs. 7,000/-to Sachin

4/2/2002 Paid info the bank Rs. 2,000/-
9/2/2002 Cash purchases Rs. 3,000/-
5/2/2002 Paid bills Rs. 50/-
6/2/2002 Received from Govindrao Rs. 5,000/-
8/2/2002 Cash sales Rs. 7,000/-
6/2/2002 Received commission Rs. 150/-
8/2/2002 Sold goods for cash Rs. 5,000/-
9/2/2002 Purchased goods on Cash Rs. 1, 00/-
4/2/2002 Withdraw Rs.1, 000/- from the bank for office use.
9/2/2002 Purchased old typewriter for Rs. 500/- for officer.
8/2/2002 Ajay sold his old car Rs. 5,000/- and invested some into the business.
7/2/2002 Withdraw for personal use Rs. 1,000/-
5/2/2002 Paid for salary Rs. 200/- and for printing and stationary Rs.25/-
6/2/2002 Received interest Rs. 125/- and dividend Rs. 100/-

EXERCISE 3

1) Purchased goods from Rupali worth Rs. 5000/- less 10% TD.

Ledger:

a) Purchase account
Under: Purchase account
b) Cash
c) Discount received= indirect income

Calculate discount

5000*10% or 5000*10/100 =500 >> 5000-500(discount)=4500

Entry:

Party Name: Rupali

Purchase Ledger: Purchase a/c

Name of Item:

Goods 5000

Discount Received: -500

4500

2) Sold goods worth Rs. 8000/- to Deepali of 10% CD.

Ledger:

a) Sales account
b) Cash
c) Discount allowed:indirect Expenses

Calculate discount

8000*10% or 8000*10/100 =800 >> 8000-800=7200

Discount=800

Entry:

Party Name: Deepali

Sales Ledger:Sales a/c

Name of Item

Goods:

2/5/2001 Started Business with cash Rs. 50,000/- Furniture Rs. 15000/-
3/5/2001 Deposited into Bank Rs. 10,000/-
5/5/2001 Purchases goods from Arun Rs. 12,000/- on credit
6/5/2001 Sold good to Varun Rs. 15,000/- on credit.
7/5/2001 Paid Rs. 3000/- by cash and Rs. 5000/- by cheque to Nilesh.
8/5/2001 Purchases goods from Mohan worth Rs. 10,000/- less 3% TD.
9/5/2001 Sold goods worth Rs. 15,000/- to Sham less 5% CD.
10/5/2001 Received Rs. 4,750/- from Sham and allowed him discount of RS-
250/-

Rs. 250/-
12/5/2001 Paid Rs. 4,900/- to Sachin towards sentiment of Rs. 5,000/-
15/5/2001 Paid Salary Rs. 2,000/- Rent Rs. 1,500/- Electricity charges Rs. 500/-
and Telephone charges Rs. 2,500/- by cash.

EXERCISE 4

4/5/2000 Started business with cash Rs. 40,000/- Furniture Rs. 5000/- and
Building Rs. 10,000/-
5/5/2000 Deposited into Bank Rs. 10,000/-
7/5/2000 Purchased goods from Rupali worth Rs. 5000/- less 5% TD.
7/5/2000 Cash purchase Rs. 8000/-
8/5/2000 Sold goods worth Rs. 8000/- to Deepali of 3% CD.
10/5/2000 Cash sales Rs. 12,000/-
12/5/2000 Purchased Machinery worth Rs. 25,000/- from Godrej and co on
Credit.
13/5/2000 Purchased goods worth Rs. 7500/- from Prasad at.
15/5/2000 Purchased Furniture worth Rs. 5000/-
16/5/2000 Distributed goods worth Rs. 1000/- as free sample.
17/5/2000 Paid Rs. 2000/- by cash and Rs. 2000/- by cheque to Rupali.
18/5/2000 Uninsured goods worth Rs. 8000/- los by life.
 EXERCISE 5
1/4/2003 Asha invested into the Business cash Rs. 15,000/-
3/4/2003 Opened a Bank A/c by depositing Cash Rs. 1000/-
4/4/2003 Cash purchase Rs. 7000/-
5/4/2003 Purchases goods worth Rs. 8000/- from Usha at 5% TD.
7/4/2003 Sold goods worth Rs. 5000/- to Nisha at 2% CD
8/4/2003 Nisha Returned goods worth Rs. 100/-
9/4/2003 Goods worth Rs. 150/- returned to Usha as they were defective.
10/4/2003 Paid to Usha Rs. 5000/-
12/4/2003 Received Rs. 4000/- from Nisha.
14/4/2003 Withdraw Cash Rs. 5000/- from the Business for self-use.
15/4/2003 Deposited cash Rs. 5000/- in to the Bank.
16/4/2003 Cash sales Rs. 7000/-

EXERCISE 6

2/12/2004 Started Business with cash Rs. 50,000/- Furniture Rs. 40,000/- Bank
Balance Rs. 25,000/-/
3/12/2004 Deposit into Bank Rs. 20,000/-
4/12/2004 Brought goods of Rs. 25,000/- off 8% TD.
6/12/2004 Brought goods of Credit from Manish Rs. 10,000/- @ 10% TD.
7/12/2004 Sold goods to Rajesh Rs. 19,800/- of 3% CD.
8/12/2004 Sold goods to cash Rs. 3000/- off 5% CD.
10/12/2004 Paid house rent Rs. 1500/- office rent Rs. 1000/-
11/12/2004 Paid advertisement Rs. 2500/- printing Rs. 1500/-
12/12/2004 Paid Rs. 8500/- to Manish & discount of Rs. 500/- paid by cheque.
15/12/2004 Withdraw cash from office Rs. 2000/- and cash from Bank Rs. 1000/-
for self-use.
16/12/2004 Paid Insurance premium Rs. 1000/- on the life police of proprietor.
 GODOWNS

How to create Godowns?

Path:

Gateway of Tally>> F11 >> Inventory Features >> Maintain Multiple

Godowns >> Yes

Creation:

Gateway of Tally >> Inventory info >> Godown >> Create

Name: Satara Godown

Under: Primary

Accept

1. Purchased Laptop from David for Satara Godown of Rs-8000/-

2. Sold books from Sangali godown to Mr. Vikas of Rs-2500/-
3. Purchased Typewriter for Karad Godown of Rs -5000 from Mahesh.
4. Sold Monitor to Mr. Ajay of Rs-8000 from Karad godown
5. Purchased 10 mobiles for Chinchwad godown of -10000/- from ajay.
6. Purchased Fridge from kirloskar&company of Rs- 55000/-for Mohol
godown
7. Purchased laptop of Rs--25000/- from Dinesh on credit for Karad godown.
8. Purchased following items from Ravi on Credit for chinchwad godown.
i. 20 Pens@ 10 each
ii. 15 Big Exercise Book@40 each
iii. 2 Laptop@40000 each
9. Purchase following computer Items from Sam on Credit for Satara godown
i. 5 LG Monitor@5000 each
 ii. 2 CPU@6000 each
iii. 5 Key board@500 each
10.Sold goods to Krishna of Rs-- 10000/- from Satara godown
11.Sold camera to Mohan of Rs--8000/- from Karad godown
12.Sold following goods to Shruti from Sangali godown:
i. 2 Apple Mobile@30000 each
ii. 3 Laptop@45000 each
13.Sold goods to Patil & sons of Rs- 8000 on credit from Chinchwad godown.
14.Sold Samsung TV to Lalita Khorana of Rs-10000 on credit from
Mangalwedha godown.
15.Sold fridge to sagar of Rs- 7500 on credit from satara godown.
16.Sold mobile to Sonia of Rs- 8000 on credit from sangali godown.
17.Sold laptop to sneha of Rs- 25600 on credit from Karad godown.
18.Sold land and building to subhash & company of Rs- 105000 on credit from
Chinchwad godown.

VAT (Value added Tax)

To activate VAT:

Path:

Gateway of Tally >> F11 >> Statutory and Taxation >> Value added Tax
>> Yes >> Details >> Yes

Input vat= Purchase

Output Vat = Sales

Purchased following goods from Firoz @ 4% VAT:

10 pen at Rs-10 each

 20 pencils at Rs-5 each

Ledger:

d) Purchase 4%

Under: Purchase a/c

Used in VAT returns: Yes

Select Purchase 4%

Use for assessable Value Calculation: Yes

Method of Apportion: Based on Value

e) Input Vat 4%

Under: Duties and Taxes

Type of Duty/ Tax: VAT

VAT class: Input vat 4%

f) Firoz

Under: Sundry Creditor

Entry

After inserting all items then insert Input vat after total amount of the items.

Sold following goods to David @ 12.5% Vat

2 laptop of Rs-45000

5 monitor of Rs-4000

Ledger:

d) Sales 12.5%
 Under: sales a/c

Used in VAT returns: Yes

Select Sales 12.5%

Use for assessable Value Calculation: Yes

Method of Apportion: Based on Value

a) Output Vat 12.5%

Under: Duties and Taxes

Type of Duty/ Tax: VAT

VAT class: Output vat 12.5%

b) David Under: Sundry Debtors

Check VAT Reports:

Gateway of Tally >> Display >>Statutory Reports >> Vat

Reports >> Vat Computation

Note:

Assessable amount Vat amount

Output Vat 12000 2000

Input VAT 10000 800

Vat payable 1200

Setting in Journal Voucher:

Gateway of Tally >> Account Info >> Voucher Type >> Alter >> Journal >>
Name of Class – Vat adjustment

Create Ledger:

VAT PAYABLE >> UNDER: Duties and Taxes >> Vat >> Not applicable

Entries:

1) Journal Voucher: debit credit

DR. OUTPUT VAT >> INSERT ASSESSABLE VALUE (eg. 12000) (vat amount)

CR. INPUT VAT >> INSERT ASSESSABLE VALUE OF INPUT VAT (vat)

CR. VAT PAYABLE payable amt

Or

Dr. vat refundable

2) Payment Voucher:

DR. Vat payable 1200

CR. Cash 1200

If refundable

Cr. Vat refundable

Dr. cash

Solve the following problems and Clear VAT reports every time:
1) Purchased laptop and monitor of Rs--25000/- and 8000/-from Dinesh on credit
@ 4% VAT.
2) Sold Samsung TV to Lalita Khorana of Rs-10000 on credit at 12.5% VAT.
3) Purchased following items from Ravi on Credit at@ 12.5% VAT.
i) 20 Pens@ 10 each
ii) 15 Big Exercise Book@40 each
iii) 2 Laptop@40000 each
4) Sold laptop to sneha of Rs- 25600 on credit at 12.5% VAT.
5) Sold machinery to LHP Company of Rs- 222000 on credit at 12.5% VAT.
6) Purchase following computer Items from Sam on Credit at 12.5 % VAT
i) 5 LG Monitor@5000 each
ii) 2 CPU@6000 each
iii) 5 Key board@500 each
7) Purchased type writer and printer from Roy of Rs--8000 and 9000/-on Credit at
4% VAT.
8) Sold mobile to Sonia of Rs- 8000 on credit at 12.5 % VAT.
9) Purchased wheat and jawar from Ajay of Rs-- 75000 on credit at 4% VAT.
10) Sold Monitors to Patil & sons of Rs- 8000 on credit at 4% VAT.
11) Purchased Samsung TV and LG monitor on credit from Ramesh of Rs--
25000/- and 8000/-at 12.5% VAT.
12) Purchased FAN and Fridge on credit of Rs- 1850 and 10000/-from SUBHASH
at 4% VAT.
13) Sold following goods to Shruti at 4% VAT:
a) 2 Apple Mobile@30000 each
b) 3 Laptop@45000 each
14) Sold land and building to subhash & company of Rs- 105000 on credit at 4%
VAT.
15) Sold fridge to sager of Rs- 7500 on credit at 4% VAT.
16) Purchased Laptop and CPU on credit of Rs- 10000 and 4000/- from Mahesh
at 12.5% VAT.
17) Purchased Compaq laptop on credit of Rs- 45000 from ANIL at 4% VAT.
18) Sold camera to Mohan of Rs—8000/- at 12.5% VAT
19) Purchased Books on credit of Rs- 1000 from Saraswati book depo at 4%
VAT.
20) Sold Laptop to Krishna of Rs-- 10000/- at 12.5% VAT

TDS
Tax Deduction at Source
Deductors Deductee

--- X Rent
--- Y Technical
--- Z Advertisement
--- D Contract
Payment (100-10% TDS)

How to apply TDS?

Press F11 (Company Futures)>> Select: - Statutory & Taxation

Unable– Tax Dedu2ction at Source? “yes”

Seat after TDS Details “yes”

Tax assessment No.

Income Tax Circle/word (TDS) : SD 563251

Detector Type : Others

Name of person responsible : Dinesh Sir

Designation : A/c Manager

Accept It? : “yes”

• Paid annual rent of office of Rs. 1,50,000 /- to Mr. Vikas Agarwal (Apply
TDS on office Rent )
Ledgers:

a) Office rent

Under: Indirect Expenses

TDS: Yes

Select Nature of Payment: Rent on Land, building and furniture

b) Mr. Vikas Agarwal

Under: Sundry creditors

TDS Applicable: Yes

Type of deductor: individual/ company resident

c) TDS on office rent

Under: Duties and taxes

 Type of Duty: TDS

Nature of payment: select category (rent on land, building and

furniture)

Entry: Journal Voucher F7

DR. Office rent

CR. Vikas Agarwal

CR. TDS on office rent

Payment f5

DR. Vikas Agarwal

CR. Cash

Payment F5

Dr. Tds on office rent

Cr. Cash

Solve the following problems of TDS:

1. Paid for Technical service to Mr. Roy of Rs-150000/-

2. Paid for advertisement contracts to Banik advertising LTD. Of Rs- 70000/-
3. Paid interest on security to Mr. shah of Rs-80000/-
4. Paid office rent to Mr. Shailesh of Rs-150000/-
5. Paid rent on plant and machinery to Mehta of Rs-200000/-
6. Paid fees for all types of Contractors of Rs-500000/-
7. Paid insurance commission to Mr. Shubham of Rs-10000/-
 SERVICE TAX

Services Tax : 12.36%

Tax Rate : 12%

Education Cess : 2% (On Duty Value)

High Education Cess : 1% (On Duty)

How to Apply Services Tax

Press F11(Company futures)>> Statutory and Taxation>>

Enable Service tax : “yes”

Set/Alter services Tax details : “Yes”

Services Tax Registration No : ET 546177

Date of Registration : 1st April 2010

Type of Organization : Partnership/ Registered Private

Ltd Com.

Is Large Tax Payer? : No

SERVICE TAX COLLECTION OR RECEIVABLES

Fees collect from Mr. Sandeep Kumar of Rs. 35000/- for computer course (Charge
Services Tax)

a) Fees collect/ collection:

 Under: Indirect income

Service Tax applicable: Yes

Select category: Commercial training and coaching

b) Mr. Sandeep Kumar

Under: Sundry Debtor

Service tax applicable: Yes

Exemption details: Not applicable

c) Service tax on Computer Course/ course fees

Under: Duties and taxes

Type duty/tax: Service Tax

Select category: Commercial training and coaching

ENTRY:

JOURNAL VOUCHER F7

DR. Sandeep Kumar 1

CR. Course Fees/fees collection amt.

CR. Service Tax on Computer Course

RECEIPT VOUCHER F6

CR. Fees Collect/sandeep kumar

DR. Cash

PAYMENT VOUCHER F5
 DR. Service tax on computer course

CR. Cash

PAID/ PAYMENTS:

Paid telephone bill to Reliance communication of Rs-150000/-

Ledgers:

a) Telephone bill

Under: indirect expenses

Service tax applicable: Yes

Select category: Telecommunication services

b) Reliance communication

Sundry creditor

Service tax applicable: Yes

Not applicable

c) Service tax on telephone bill

Under: Duties and taxes

Type of Duty/tax: Service tax

Select category: Telecommunication service

ENTRY

JOURNAL VOUCHER F7

DR. Telephone bill

DR. Service tax on telephone

CR. Reliance communication

PAYMENT F5

DR. Telephone Bill

CR. Cash

Solve the following problem:

1. Paid chartered Account fees Rs 50,000 to C.A.

2. Paid to Ramesh for banking and financial accounting of Rs-30000/-
3. Received Rs.40,000/- from vishal for Architects services
4. Paid Rs-5000 to cable operator for cable operating services.
5. Paid insurances installment Rs. 20,000/- to LIC
6. Paid for courier services to VRL Travels of Rs-7500/-
7. Collect Rs. 25000/- from sayali for interior decorators
8. Paid of Rs-8000 to Event manager for management services.
9. Paid Rs. 2,000/- to internet café to Mr.Dinesh
10. Collected fees from Sujata for being a member of Club of Rs-15000/-.
11.Paid Agent fees Rs.5,000/- to Real Easter Agents
12.Collected amount for packaging services from Rahul of Rs-5000/-
13.For securities services collect Rs. 1,000/-from mayor
14.Transport operator collect Rs.15,000/- from us for goods transport services
15.Fashion designer received Rs. 8,000/- for his services
16.Deposit Rs. 12,000/- in Bank
17.Amar paid Rs.10,000/- to us for Advt services
18.Bank cut Rs.500/- from Gauri account for use ATM services
 COST CENTRES AND COST CATEGORIES

How to apply cost centers and categories?

Path:

Gateway of Tally >> F11 >> accounting features >> maintain cost centers:
Yes >> use cost centres for job costing: Yes >> More than one Payroll/ cost
category: yes

Create Category:

Gateway of Tally >> Accounting Features >> Cost category >> Create

Name: Branch

Allocate revenue items? Yes

Allocate Non- revenue Items? Yes

E.g. Department, agents

Create Centre:

Path:

Gateway of Tally >> Accounting features >> Cost centres >> create
Category: Branch

Name: Satara

Under: Primary

Use for Job costing: No

Solve the following problem:

1) Opening Balances-

a) Cash Rs. 10,0000/-

b) Capital Rs. 150000/-

2) Purchase goods of Rs. 20000/- in cash. From gents department Rs. 8,000/-
and from Ladies Department Rs. 12,000/-

3) Sold goods in Cash Rs. 25,000/- .to Gents Department Rs. 10,000/- and for
ladies department Rs. 15,000/-

4) Purchase machinery by gents department for cash Rs. 5,000/-

5) Deposited Rs. 25,000/- with Janta Bank

6) Received commission by Gents Department Rs. 6,000/-

7) Paid Electricity charges Rs. 6,000/- for Gents Department Rs. 2000/- and for
Ladies Department Rs. 4000/-
8) Paid Salary worth Rs. 30,000/- for gents Department Rs. 22,000/- and for
ladies Department Rs. 8,000/-

Assignment -2

Create following centres

1) Food Department

2) Medicine Department

3) Toys Department

4) Cosmetic Department

1) Opening Balances

a) Cash Rs. 200000/-

b) Bank Rs. 12,5000/-

c) Capital Rs. 300000/-

2) Purchase good to cash Rs. 30,000/- in cash for food department Rs. 10000/-
Toys Department – 5000/- Cosmetic Department Rs.15000/-

3) Sold goods to cash Rs. 50,000/- for food Department Rs. 10,000/- medicine
Department Rs. 10,000/- Toy Department Rs. 15,000/- Cosmetic Department Rs.
15,000/-

4) Purchase machinery by for food Department Rs. 10,000/- Toy Department

Rs. 8,000/-

5) Paid Electricity charges Rs. 40,000/- for food Department Rs. 10,000/-
medicine Department Rs. 7,000/- Toy Department Rs. 13,000/- Cosmetic
Department Rs. 10,000/-
6) Paid advertisement expense worth Rs. 20,000/- for food department Rs.
6,000/- medicine Department Rs. 6,000/- Toys Department Rs. 4,000/- Cosmetic
Department Rs. 4000/-

7) Received commission by for food department Rs. 150,000/-

8) Cash withdrawn by Janta Bank worth 50,000/-

BRS (BANK RECONCILIATION STATEMENT)

F5 for bank date

GOT------> Display----------> Account books------->cash/bank book-------

>select bank-----> select Month------- >> press F5 for reconciliation----- >>
Enter the Bank date

Solve the following problem:

1. Cash Deposited in to Bank Transactions of Rs-5000/-

2. Cash withdraw from Bank Rs. 5000/-
3. Paid Rs. 3000/- by cheque for advt.
4. Received Rs. 1, 50,000/- by cheque from Mr. Rakesh.
5. Received Rs. 1,5000/- by cheque for commission
6. Paid Rs. 25,000/- by cheque to Mr. Sachin.
7. Paid Rs. 24,000/- by cheque to Mr. Dinesh.
8. Ramesh deposited cash into bank of Maharashtra of Rs--8000/-
9. Cash withdrawn by Suresh of Rs--7589 from Bank of Baroda.
10.Opening a saving a/c in the bank of Maharashtra by deposited of Rs- 600/-
11.Deposited in to bank of Rs- 3000.
12.Withdraw from bank of Rs- 1000.
13.Deposited in to bank of Rs- 8000.
14.Withdraw from bank of Rs- 2000.
15.Deposited in to bank of Rs- 7000.
16.Withdraw from bank of Rs- 5000.
 17.Deposited in to bank of Rs- 15000.
18.Withdraw from bank of Rs- 5000.
19.Deposited in to bank of Rs- 15000.
20. Cash withdrawn from bank of India of Rs-5000/-

FBT (Fringe Benefit Services)

How to apply FBT?

Press F11 Company Features

Select and Statutory and Taxation Features

Enable Fringe Benefit Tax

SET/Alter FBT Details?

a) Provided below services to Mr. Shah

Basic salary – Direct expenses Rs-7000/-

Conveyance- indirect expenses Rs-1500/-

Entertainment- indirect expenses Rs-900/-

Hotel and boarding – indirect expenses Rs-4000/-

ENTRY

JOURNAL VOUCHER F7

DR= basic salary

DR=conveyance

DR=entertainment
DR=hotel and boarding

CR=Cash

Payment F5

Payment F5

DR. Mr. Shah

CR. Cash

VIEW FBT REPORTS

Gateway of Tally >> Display >> Statutory Reports >> FBT reports >> FBT
Computation >> note the amount of FBT Payable

Create ledger FBT Under: duties and taxes >> FBT: yes

PAYMENT VOUCHER F5

DR. FBT

CR. Cash

Solve the following problem:

a) Company provided below benefits to Ajay :

Basic salary Rs-7500/-

Conveyance Rs-500/-

For festival celebration Rs- 2000/-

Scholarship of Rs- 8000/-

Foreign travelling Rs- 50000/-

b) Mr. Ashok received following benefits:

 Basic salary Rs-10000/-
Conveyance Rs-1500/-
For festival celebration Rs- 22000/-
Scholarship of Rs- 8000/-
Telephone service Rs-800/-
Foreign travelling Rs- 50000/-
c) Miss Chitra receives a following benefits

Basic salary Rs-7500/-

Conveyance Rs-500/-
For festival celebration Rs- 2000/-
Scholarship of Rs- 8000/-
Foreign travelling Rs- 50000/-
Hotel and boarding Rs- 9000/-

TCS (Tax Collected at Source)

Tax collected at Source

Press F-11

Statutory and Taxation

Enable Tax collected at source (TCS) - “Yes”

Set/Alt TCS Details - “Yes”

Example -

Ledger Creation

Mr. Dinesh

Sales A/c

TCS on Scrap
Accounting Vouchers

Sales A/c (F8)

Sales voucher
Party’s A/c Name : Mr. Dinesh

Sales Balance : Sales A/c

Name of Item Quantity Rate Amount

Scrap 15000/- 50 7,50,000/-

TCS on Scrap

TCS - Details :

TCS party Ledger : Mr. Dinesh

Gross Amount : @ 1% 7,50,000/-

Income Tax : @ 10% 7,500/-

Surcharge : @ 2% 750/-

Cess : @ 1% 165/-

Add/Edcess : @ 83/-

1. Sold 10kg Tendu leaves to Sachin at Rs-5000/-

2. Sold 50kg scrap to Ajay of Rs-75000/-
 3. Sold 20kg tendu leaves of Rs-7000 and 20kg Scrap Rs-70000/- to Dinesh

Purchase / sales order

To activate purchase/sales order:

Gateway of Tally >>F11 >> Inventory Features >> Purchase/ sales order >> Yes
>> Yes]

Buttons:
Accounting Voucher

Purchase order

Purchase Order :Alt +F4

Receipt Note : Alt+F9

Rejection out :Alt+F6

Purchase :F9

Debit Not :Ctrl+F9

Sales order

Accounting Voucher

Sales Order : Alt+F5

Delivery Note : Alt+F8

Rejection in : Ctrl+F6

Sales : F8
Credit Note : Ctrl+F8

a) Company placed a purchase order to Mandar and Sons for following goods:
(Order No: 2570)
20 pen of Rs-10 each
10 pencil of Rs- 5 each
20 rubbers of Rs- 5 each
b) Received order from Ramesh for following goods: (Order No. 2575)
2 fridge of Rs-8000 each
4laptop of Rs- 45000/-
3 Keyboard of Rs-500 each
c) Company placed a purchase order to Mahindra and sons for following
vehicles (Order no.2580)
2 Maruti cars of Rs-500000/-
2 Hyundai motors of Rs-700000/-
3 Nano cars of Rs-150000/-

Payroll System
How to apply?

Press - F11 (Company Feature) >> Select - Account Feature

Maintain payroll? “Yes”

More than payroll/categories “Yes”

Accept it? “Yes”

Master Creation

Gateway of Tally >> Payroll Info >> Units >> Create

Type -Simple

Symbol -Day

Formal Name - ---

No of decimal places -0

Create units: - Days

Month

Minutes

Hours

Type- Compound

Create units: - Month of 26 days

Hours of 60 Minutes

Attendance Type-

Gateway of Tally >> Payroll Info >> Attendance Type >> Create

Name - Present

Attendance Type - Attendance & Live without pay.

Name - Absent

Attendance Type - Live without pay

Name - Over time

Attendance Type - Production

Units - Hours of Go minuts

Employee Creation

Gateway of Tally >> Payroll Info >> Employee >> Cre

Employee Name - shubham

Date of Joining - 19-6-2007

D.O.B - 21-5-1987

Designation - (Post Name)

Location - (dks.kR;k Location oj dke djr vkgsr-)

Boold Group - B

Father Name - Kiran

Address - Satara

Bank Name - SBI

Branch - Satara

A/c No. - 456123

Pay Heads

Gateway of Tally >> Payroll Info >> Pay head >> Create
Basic Salary

Pay head Type - Earning for Employees

Under - (Indirect/Direct exp)

Indirect

Name to appear pay slip - Basic Salary

Use for Graduity - “Yes”

Calculation Type - On Attendance

Attendance of leave with pay - present

Calculation period - Months

As per use detailed - 26 days

Reading method - Not applicable

D.A. (Dearness Allows)

Pay head Type - Earning for Employees

Under - Indirect Exp.

Appear pay Slips - “Yes”

Use for gratuity - D.A.

Calculation Type - “Yes”

Calculation Type as a computed Value - On current earning total

Up to 10,000/- - 5%

From 10,000/- - 10%

H.R.A. (House Rent Allows)

Pay head Type - Earning for Employees

Under - Indirect Exp.

Appear pay Slips - “Yes”

Calculation Type as a computed Value - On current earning total

Up to 10,000/- - 6%

From 10,000/- - 8%

Over Time

Pay head Type - Earning for Employees

Under - Direct Exp.

Appear pay Slips - “Yes”

Name to appear pay slip - Over time

Calculation Type - On Production

Attendance type - Production for over time

Period - Hours of 60 minits

Professional Tax

Pay head Type - Deduction from Employees

Under - Current liabilities

Name to appear pay slip - Professional Exp.

Calculation Type - As computed Value

Calculation period - Month

Calculation Type as a computed Value - On current earning total

Up to 10,000/- - 2.66%

From 10,000/- - 4%

Traveling allows

Pay head Type - Earning for Employees

Under - Indirect Exp.

Name to appear pay slip - Traveling Exp.

Calculation Type - Flat Rate

Calculation period - Month

Salary Details

Gateway of Tally >> Payroll Info >> Pay head >> Create

Select - Mandar

Basic Salary - 5,300/-

H.R.A

D.A

Over time - 500 (1 hours)

T.A - 350/-

Professional tax
 Accept it? - “Yes”

Master Creation Entry

Voucher Entry

Attendance Voucher - Ctrl + F5

Mandar - Present 25 days

Mandar - Overtime 20 Hours

Pratik - Present 18 days

Pratik - Overtime 10 Hours

Dinesh - Present 26 days

Dinesh - Over time 52 hrs.

(Note :- Create Bank A/c - Bank of India (Ledger)

Payroll Voucher (Ctrl + F4)

Press - Alt + A/S

From 1st April - (Blank)

Items - All Items

Payroll Ledger - Bank of India

Enter
 Import Export
XYZ Company - Data (vlysyh)

Account list

Gateway of Tally

Display

Accounting list (Ledger P;k ’ksoVh Press - Alt + E)

Language - Default (All Language)

Formal - XML (Data Interchange)

Output File Name - ABC XML

Type of Master - All master

Export? - “Yes”

Overwrite? - “Yes”

Trial Balance

Gateway of Tally

Display

Trial Balance

Select - ‘’ksoVph Entry - Press Alt + E

Language - Default (All Language)

Format - XML (Date Interchange)

Out put File Name - XYZ . XML

Seale Factor for Values - Detailed

Method in for - Grouped

Export? = “Yes”

Overwrite ? = “Yes”

Day Book

Display

Day book

Select ‘’ksoVph Entry - Press - Alt + E

Language - Default (All Language)

Format - XML (Data Interchange)

Out put file Name - XYZ. XML

Format - Detailed

Select Vouchers to show - All Vouchers

 Export? = “Yes”

Overwrite? = “Yes”

Press - Alt + F3 vkf.k XYZ Company gh Shut djkoh Select New Company

How to apply Import?

Master - Gateway of Tally

Import of Data

Select Master

Import files Name - “ABC. XML”

Treatment of entries already existing - “Modify with new Date”

Vouchers

Gateway of Tally

Import of Data

Vouchers

Import files Name - “XYZ. XML”

Enter

Report :- Display

Trial Balance

Day book
List of Accounts