SOFTECH COMPUTER EDUCATION

TALLY 1

Accounts:-
When we maintain a record related to money in summarizing terms, it is known as Accounts.

There are Two Types of Accounts.

1. PERSONAL ACCOUNTS
Personal Accounts are the accounts of persons with whom the business is required to deal
with Example include, Suppliers, Customers, and Lenders(owners)
Debit the receiver and Credit the Giver
Arun receive Rs.1000 by Karan.
Arun a/c Dr……..1000
To Karan a/c Cr……1000.

1. Real Accounts- Real Accounts means which is Assets of owners which cannot sell out.
Debits are come in and Credits are Goes out.
For Example- Furniture A/c, Machine A/c, Cash A/c, Computer A/c etc.

Purchase Machine Rs.10000 by cash.

Machine A/c Dr………10000
To Cash A/c Cr………10000

Cash withdraw from Bank Rs. 6000

Cash A/c Dr…………6000
To Bank A/c Cr…….6000.

2. Nominal Accounts-
Nominal Accounts are accounts where income and expenses are recorded, Example
Include Sales, cost of goods sold, salary expenses, wages etc.

Debits are all the Expenses & Losses and

Credits are all the Income & Gain.
For Example-Salary A/c, Rent A/c, Commission A/c, Interest A/c etc.

Paid Salary Rs.5000 by cash. Interest receive Rs.2000 by cash.

Salary A/c Dr……..5000
Cash A/c Dr……..2000
To Cash A/c Cr……5000.
To Interest A/c Cr….2000.
Rent Paid Rs.5500 By Cheque.
Rent A/c Dr……..…5500
To Bank A/c Cr……..5500 Commission receive In Bank Rs.1000
Bank A/c Dr………..1000
To Commission A/c Cr……….1000.

Transaction :

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 2
A transaction is an event that changes the organization’s financial position and / or its
earning. For Example , when you deposit cash in the bank, you cash balance reduces and
bank balance increases, when you sell goods for cash, your cash balance increases and your
stock reduces.

Accounts can be broadly classified under the following five groups:

 Assets
 Liabilities
 Capital
 Revenue ( profit)
 Expenses.
Double entry System
Double entry System is system of recording transactions in a manner that maintains the
equalities of accounting equation. This accounting technique records each transaction as a
debit and a credit, where every debit has a corresponding credit and vice versa.

Tally ERP / 9.0

What is tally
Tally is very User friendly computerize financial Accounting Package.

Tally is financial Accounting package. It was developed by Peutronics Pvt. Ltd. In Year 1987. its
first version was 3.0 in DOS.

The first financial Accounting is released by Erestaiel Peutronics in 1987-1988 was called PFA
(Peutronics Financial Accounting)

Group
You can classified all ledger based on their function.
This classification determine whether the ledger goes into the Profit and Loss A/c or Balance
Sheet.
Pre-defined Group
As soon as you create a company in tally it automatically create 28 Accounting group. These are
pre-defined which cannot be deleted. 15 groups are primary groups and 13 group are Sub Group.
The List of pre-defined group are follows.]

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 3

1. Capital Accounts:
2. Current Assets:

(i) Bank Accounts

(ii) Cash-in-hand
(iii) Deposit Assets
(iv) Loan & Advance (Assets)
(v) Stock-in-hand
(vi) Sundry Debitor

3. Current Liabilities:
(i) Duties & Taxes
(ii) Provision
(iii) Sundry Creditor
4. Fixed Assets:
5. Investment:
6. Loan (Liability)
(i) Bank OD Accounts
(ii) Secured Loan
(iii) Un Secured Loan
7. Suspense Accounts:
8. Misc-Exp-(Assets):
9. Sales Accounts:
10. Purchase Accounts:
11. Direct Income:
12. Indirect Income:
13. Direct Expenses:
14. Indirect Expenses:
15. Branch & Division

Ledgers and Groups

All financial entries are made using ledger accounts heads. Every transaction/ voucher can
be related to a ledgers account head to which they belong. Ledger that have transactions of
the same nature are classified under one group.

A group is a collection of ledgers which have similar transaction . For Example all ledger
account heads relating to fixed assets of the company are grouped under the fixed assets
primary group in Tally like Fixed AssetsFurniture a/c, Land and Building a/c, Computer
a/c, Electrical Fittings a/c etc.

Some ledger and their Groups are given below :-

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 4

LEDGER GROUP
Ram Capital Capital A/c
Amit Capital Capital A/c
State Bank of India Bank A/c
ICICI Bank Bank A/c
Wages Direct Exp.
Salary Indirect Exp.
Rent ”
Electricity Charge ”
Advertisement ”
Discount Allow ”
Stationary ”
Tiffin & Refr. ”
Commission Indirect Income
Discount Receive ”
Computer Fixed Assets
Machine ”
Land & Building ”
Furniture ”
Purchase Purchase A/c
Purchase Return ”
Sale Sales A/c
Sales Return ”
Amrita & co. (Lendar) Sundry Creditor
Sudha pvt. Ltd. (Dendar) Sundry Deditor

Voucher Types- Vouchers are used for recording day to day transaction

PAYMENT VOUCHER(F5): When we create entries which is related to all types of

payment, through cash or Bank, we select Payment Voucher Types.
Note: Cash or Bank A/c always use in Cr. Side.

RECEIPT VOUCHER(F6): When we create entries which is related to Receive, through

cash or Bank, we select Receipt Voucher Types.
Note: Cash or Bank A/c always use in Dr. Side.

JOURNAL VOUCHER(F7): All other Voucher which is not related to Payment Voucher
and Receipt Voucher, So we are select Journal Voucher Types.
Note: Not Use Cash or Bank both side.

CONTRA VOUCHER(F4): When use only Cash or Bank a/c, we select Contra Voucher
Types. Note: Only Cash or Bank A/c used both side.
STS COMPUTER CENTRE
 SOFTECH COMPUTER EDUCATION
TALLY 5

Following These Journal Entries:

Payment Voucher(F5)
1. Rent paid Rs. 2000.
2. Paid Electricity Charge Rs. 5000.
3. Paid to Shyam Rs 10000.
4. Wages paid Rs. 1500.
5. Purchase furniture Rs.10000 by cheque.
6. Purchase Computer Rs. 13000 and amount paid by Cheque of Sbi bank.
7. House Rent paid Rs. 4500 by cheque.
8. Advertisement done Rs.2000.
9. Bought Machine Rs. 15000 from Cash.
10. paid to ram Rs. 9000.
11. salary paid Rs. 6000.
12. paid telephone charge Rs. 5000.
13. paid to dev Rs. 2000 by cheque of Sbi Bank.

Receipt Voucher(F6)
1. Commission receive Rs. 1000.
2. Commission receive Rs. 5000.
3. Interest receive Rs. 2000.
4. Cash Sale Rs. 25000
5. Goods Sold to Anupam & Co and receive by cheque.
6. Interest receive in Sbi bank Rs. 8000.
7. Rs. 9000 receive from amit by cheque.
8. Rs. 1000 Interest receive.
9. Rs. 5000 receive from Arun.
10. Cash receive Rs. 1000 from Raj.
11. Commission receive Rs. 2000 By cheque of ICICI Bank.
12. Rs. 10000 receive from Vikash by SBI Bank.
13. Rs 8000 receive from satyajeet by cash.

Journal Voucher(F7)
1. Purchase furniture Rs.10000 from Rajesh.
2. Bought Machine Rs. 15000 from Aditya.
3. Purchase Computer Rs. 13000 from Deepak.
4. Purchase Printer Rs. 3000 on cerdit from Kamla Ele...
5. Purchase goods Rs. 5000 from Dipty & Co.
6. Purchase Goods Rs 15000 on credit from D.k.Dutta.
7. Sold goods Rs. 6000 to Arya & Co.
8. Credit sold Rs. 2500 to Jaydeep & Co.
9. Advertisement done Rs. 2000 from Anuradha Communication.
10. Photocopy (Xerox) worth Rs. 800 from Aditya Xerox.

Contra Voucher (F4)

STS COMPUTER CENTRE
 SOFTECH COMPUTER EDUCATION
TALLY 6
1. Cash Deposit into Sbi Bank Rs. 100000.
2. Cash Deposit into Bank of India Rs. 12000.
3. Cash withdraw Rs. 9000 from Sbi Bank.
4. Cash Transferred Sbi Bank to HSBC Bank Rs.50000.
5. Cash with draw Rs. 6000 from Hsbc bank.
Tally
1. Started business from cash Rs.100000.
2. Purchase machine worth Rs.10000 on credit from Amit store.
3. Cash deposited into SBI Bank Rs.40000.
4. Rs. 1000 paid as electricity charge.
5. Purchase good for sale worth Rs10000 and amount paid by cheque.
6. Goods sold to Raj Ltd on credit Rs. 18000.
7. Commission receive Rs. 1000.
8. Rs. 10000 receive from Raj Ltd.
9. Salary paid Rs. 1000.
Ans.-117000
Tally
F4, F5, F6, F7
1. Money receive for shyam as capital Rs. 100000 in cash & Rs. 100000 in cheque.
2. Purchase Machinery worth Rs.25000 from Rajdeep & Co. on credit.
3. Interest receive from SBI Bank worth Rs. 2000.
4. Rs. 10000 paid to Rajdeep & Co.
5. Purchase goods for resale worth Rs. 30000 & amount paid by cheque.
6. Advertisement done from global communication worth Rs. 2000 & amount paid by cash.
7. Goods sold to Aditya worth Rs.30000 & amount receive Rs. 15000.
8. Charge depreciation on machinery @ 10% of machine cost.
Ans. 215000
Tally
1. Started business from SBI Bank Rs. 100000.
2. Purchase furniture from Raj deep & Co. worth Rs. 10000 on credit.
3. Interest receive from bank Rs. 2000.
4. Withdraw cash from Bank Rs. 60000.
5. Rent paid Rs. 2000.

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 7
6. Purchase goods for sale worth Rs. 15000 from Asutosh & amount paid by cash.
7. Charge depreciation on furniture Rs. 1000.
8. Cash Sale Rs. 10000.
9. Credit sold to Dinesh & com worth Rs. 10000.
10. Rs. 5000 paid to Rajdeep & Co.
11. Rs. 5000 receive from Dinesh & Co.
12. Advertisement done from Arti Studio worth Rs. 1000 on credit.
Ans.-109000
Tally
1. Started business with Bank Rs. 100000.
2. Wages paid Rs. 2000 by cheque.
3. Rs. 1000paid by cheque as Tiffin & Refreshment Expenses.
4. Rs. 50000 withdraw from bank.
5. Bought furniture worth Rs. 10000.
6. Rs. 1000 paid as office rent.
7. Purchase goods worth Rs. 10000 from Vender-X on credit.
8. Cash sale Rs. 2000.
9. Rs. 5000 paid to Vender-X.
10. Rs. 1000 receive as commission.

Cost Centre Cost Categories

Q. What is cost centre & cost categories.
Ans.- Cost centre & cost categories is the important feature of tally. By which we can maintain cost
wise and branch wise allocation. All logical information created under cost categories and all
physical information are created under cost centre.

As given in the following examples:-

Advertisement (cost categories) Salary (cost categories) -24000
 Handwill (cost centre)  Ram 7000
 In TV (cost centre)  Shyam 7000
 In Wall painting (cost centre)  Sita 5000
 Posters (cost centre)  Gita 5000

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 8
The company has Two Branches:-

“Dargiling ” and “Asam” Each branches has the Two Garden:-“Tea Garden” and “Rose
Garden”.

Management prefers to maintain party outstanding in bill by bill method.

a. How to activate cost centre and cost category?

b. How to create cost category?
1. Branch 2. Garden
c. How to create cost centre?
1. Assam
2. Dargilling
3. Tea Garden
4. Rose Garden

April’07
9th Paid for Telephone Charge of Rs. 1500 for Dargiling, Rs.2700 for Asam branch by cash

10th Purchase computer Desk(furniture) for Rs. 20000 from Krishna Furniture& Co.for Asam
branch Rose Garden. (NTRPR/07-08/2)

11th Purchase a customized software worth Rs. 25000 from Radha Com Ltd for each branch to
make counter sale easier.(NTRPR/07-08/3)

12th Purchase computer & accessories for billing section of Dargiling Rs.25000 from Mr
Bhavtosh Co.(NTRPR/07-08/4)

14th Purchase computer stationary worth Rs.24000 from Mr Naran Supplier for Asam branch in
Tea Garden. (NTRPR/07-08/5)

15th Return Two Printer cartridge worth Rs.3000 to Naran Supplier because of bad
qualities.against bill no-.(NTRPR/07-08/5)

18th Photocopy (Xerox) worth Rs. 800 has been done from Kangana Xerox on credit by Asam
branch (Rose Garden) the bill ref no.(NTREXP/07-08/1)

19th Received an advanced of Rs. 3500 in cash Kush & Company . against mobile
Purchase.ref(dv/sal/7-08/1) which was deposit into SBI Bank on the next working day.

20th Paid Rs. 10000 to Krishna Furniture& Co. Agst bill(Ntrpr/07-08/2)

Ans.-

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 9

Pre-Defined Cost Centre, Cost Categories

Q. What is Pre-defined cost centre & cost categories?
Ans.- Used predefined cost centers during entry its method by which we can automatically allocate.
The amount of
It has decided by the company that from May’07 onwards the following Expenses has been
distributed automatically between Tea Garden and Rose Garden of each branch in 70:30 ratio.
(i.e. Tea Garden : Rose Garden:=70:30, for each branch)

Create Predefined Cost Centre Class for each branch.

Expenses:
1) Office Rent
2) Photocopy Charges
3) Telephone & Fax Charges
4) Electricity Charge
5) Office Rent.

A. How to activate and Create Pre-defined Cost centre & Cost categories?

May’07

2nd Paid Light Charge bill worth Rs.1700 for Dargilling Branch, Rs. 1200 for Asam Branch
(allocation of Garden will be in Predefined ratio)

2nd Paid Electricity bill worth Rs.1700 for Dargiling Branch, Rs. 1200 for Asam Branch
(allocation of Garden will be in Predefined ratio)

7th Paid salary for Watchman Rs.2500 each for every Branch by Cash.(Predefined Allocation).

9th Paid Charges for repairing of washroom Basin Rs. 860 for Asam Branch (Predefined
Allocation).

10th Photo (Framing)worth Rs. 475 has been done from J.K.Traders on credit byDargiling
Branch (Rose Garden).the bill ref no is NTREXP/07/08/2.

Ans.-
The Management wants the following reports:
view all the reports.
1. Cash/Bank Book.
2. Day Book
3. Trial Balance
4. Balance Sheet
5. Profit & Loss Amount
6. Cost Centre Report
7. Branch and garden-wise Analysis
STS COMPUTER CENTRE
 SOFTECH COMPUTER EDUCATION
TALLY 10

Godown
Godown-Godown is a place to store stock/goods. You may stock in more then one place.

Stock Group-You can Group your stock item based on some similarity in them.
For example-Printer (Dot matrix Printer, DeskJet Printer, Laser Printer)

Stock Categories-It allows parallel allocation of stock item. They are also color wise, quality wise,
etc.

Stock item-it is a stock ledger as stock item.

The Management of Priyank Electronics & Computech Pvt. Ltd. Decided to maintain the stock of
their products. They have their Godowns at ‘Chitrakut’ and ‘Lakshya’ and ‘Saptarshi ’. They
maintain their products into two different Groups “Mobile Handset” and “Computer Item”. They
also want to classify their products under three different categories. These are “GSM Handset”,
“CDMA Handset” and “Computer Parts”. Make necessary arrangements in company features
section.(Set Integrate Accounts and Inventory as yes).

Opening Balance of Products: NOKIA-1600 (GSM)15pcs. @ Rs.2200.

NOKIA-2112 (CDMA)10pcs. @ Rs.2600.
LG-RD 3330 (CDMA)15pcs. @ Rs.2000.

All the GSM and CDMA Handsets are to be stored in “Chitrakut” and “Saptarshi ” Godown
respectively.

a. How to activate Godown?

b. How to create Godown?
a. Chitrakut
b. Saptarshi
c. Lakshya

c. How to create stock Group?

a. Mobile Handset
b. Computer Item
d. How to activate stock categories?
e. How to create stock categories?
a. Gsm Handset
b. Cdma Handset
c. Computer Parts
f. How to create stock item?
a. Nokia 1600
b. Nokia 2112
c. Lg-Rd 3330
g. How to activate Purchase order and Sales order?
h. How to activate Purchase challan and Sales challan?

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 11
i. How to activate purchase return and sales return?
j. Remember the Shortcut keys and use following entries.
a. Purchase Order Alt+F4
b. Purchase Challan(Receipt Note) Alt+F9
c. Purchase Bill F9
d. Purchase Return(Debit Note) Ctrl+F9
e. Sales Order Alt+F5
f. Sales Challan(Delivery Note) Alt+F8
g. Sales Bill F8
h. Sales Return(Credit Note) Ctrl+F8

May’07

16th Purchase order 30 pcs of Nokia-1600 Handset (GSM) from Durga electronics @ Rs. 2274
each and those product to Chitrakut godown. Bill (Or No-or/pur/001)

16th Purchase Challan 30 pcs of Nokia-1600 Handset (GSM) from Durga electronics @ Rs. 2274
each and those product to Chitrakut godown. Bill No-Ch/pur/001.

16th Purchase bill 30 pcs of Nokia-1600 Handset (GSM) from Durga electronics @ Rs. 2274 each
and those product to Chitrakut godown. Bill No-pb/07-08

17th Purchase order 20pcs of Nokia-2112 handset @ Rs.2600 each, 12pcs of LG-RD-2690
handset @ Rs.1480 each and 7pcs of LG-RD-3330 @ Rs.2050 each (all with Reliance
Mobile Connection CDMA) from Mehta Distributors. These Purchase were sent to Saptarshi
Godown in Delhi, Or. No.-or/pur/002

7th Purchase Challan 20pcs of Nokia-2112 handset @ Rs.2600 each, 12pcs of LG-RD-2690
handset @ Rs.1480 each and 7pcs of LG-RD-3330 @ Rs.2050 each (all with Reliance
Mobile Connection CDMA) from Mehta Distributors. These Purchase were sent to Saptarshi
Godown in Delhi, bill no.-ch/pur/002

17th Purchase bill 20pcs of Nokia-2112 handset @ Rs.2600 each, 12pcs of LG-RD-2690 handset
@ Rs.1480 each and 7pcs of LG-RD-3330 @ Rs.2050 each (all with Reliance Mobile
Connection CDMA) from Mehta Distributors. These Purchase were sent to Saptarshi
Godown in Delhi, bill no- pb/07-08/2

18th Return 2pcs of Nokia-1600 handset from Chitrakut Godown to Durga electronics due to
manufacturing defect, against bill No.-pb/07-08/1.(ret bill no-PRet/001)

18th Paid Rs. 22000 to Durga electronics Vide Cheque No.-929323 of SBI.Against bill no.-pb/07-
08/1.

19th Sold Order 5pcs Nokia-2112 handset @ Rs. 2825 each to Sapna electrods products were
sent from Saptarshi Godown. Or no-or/sal/001
STS COMPUTER CENTRE
 SOFTECH COMPUTER EDUCATION
TALLY 12

19th Sold Challan 5pcs Nokia-2112 handset @ Rs. 2825 each to Sapna electrods products were
sent from Saptarshi Godown. Ch No.-ch/sal/001.

19th Sold 5pcs Nokia-2112 handset @ Rs. 2825 each to Sapna electrods products were sent from
Saptarshi Godown. Bill No.-sal/07-08/1

22nd Received an A/c payee cheque of Rs.14125 from Sapna electrods against bill no. sal/07-08/1.
which was deposited into SBI.(Ch. No.-634554 of ICICI Bank).

View the following Reports:

1. Purchase and sale Register
2. Stock Summary
3. Godown-wise and Group/Category wise Report.
4. Stock ageing Report

Ans.-

Actual/Billed And Allowed Discount

a. How to activate actual and billed quantity?
b. How to activate Discount Column?
May’07

24th Purchase 10pcs of Seagate hard disk (80 GB) from Shilpa Computer @ 1650 each and get
2pcs free of cost, Sent these products to Lakshya Godown. bill no.-pb/07-08/3).

24th Purchase 25 pcs of Samsung 15” colour monitor from Mr Kundan @ Rs. 3800 each. and
12pcs of HP Laser Printer-1020 @ Rs.5700 each. and get 3pcs free of cost, Sent these
products to Lakshya Godown. bill no.-pb/07-08/4).

25th 1pcs of Samsung 15” monitor was rejected and return to Mr Kundan are due to scratch on
the screen. It is to be adjusted against bill no. pb/07-08/3, return record no.-PRet/07-08/1.

26th Sold 4 packs of Nokia-1600 handset @ Rs. 2550 each to Kush & Company and allowed
trade discount @ 5% goods were sent from Chitrakut godown,bill no.-sal/07-08/2)

27th Sold 10pcs of Samsung 15” colour monitor @ Rs. 3800 each to Mr A.S.R Group Industrial
and allowed trade discount @ 8%. goods were sent from Chitrakut godown, , bill no.-sal/07-
08/3)
Ans.-

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 13

Price Level & Price List

Company has appointed Mr Aranya Singh Rai and Kush & Company as dealers. As per
the company policy every dealer will get a special discount of 10%, if they purchase 5 packs/
pcs or above any individual mobile handset. IN case of computer parts they will get an
additional 2% (i.e. 12%) discount for the same. Make necessary price level and price list.

Default Price List

Product Name Price

HP Laser Printer 6550
Samsung Monitor 15” 4400
HDD(Seagate Hardisk) 1900
LG-RD-2690 1680
LG-RD-3330 2240
Nokia-1600 2550
Nokia-2112 2825

a. How to activate price level/price list?

b. How to create price list?

June’07

02nd Sold 8 packs of Seagate Hardisk to Mr Aranya Singh Rai @ Rs. 1900 each. bill no.- sal/07-
08/3). Price list should be considered.

04th Sold 12pcs of Nokia-1600 handset to Kush & Co. @ Rs. 2550 each. bill no.-sal/07-08/4).
Price list should be considered.

05th Sold 6 pcs of Nokia-1600 handset to Mr Aranya Singh Rai @ Rs. 2550 each and Sold 11pcs
of Samsung 15” colour monitor @ Rs. 4000.bill no.-sal/07-08/5). Price list should be
considered.

06th Sold 4 pcs of Nokia-1600 handset to Mr Aranya Singh Rai @ Rs. 2550 each and Sold 11pcs
of Samsung 15” colour monitor @ Rs. 4000.bill no.-sal/07-08/6). Price list should be
considered.

VIEW THE FOLLOWINGS REPORTS:-

1. Stock Summary Repots
2. Sales/Purchase Register
3. Location wise Report
4. Stock Category wise Report

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 14

Manufacturing

The company is decided to assemble PC(Finished good) and sale those with a brand name S.S
Computer PC Set
To assemble one S.S Computer PC Set the following Raw Materials are required.

Hard Disk (Seagate 80GB) : 1pcs

DVD/CD RW Combo Drive : 1pcs
Keyboard : 1pcs
Mouse Scroll : 1pcs
15” Monitor (Hitachi) : 1pcs
Ram : 2pcs
Create the above items and record the necessary formulation for production. All these products are
stored in Chitrakut Godown.

Q. How to activate Stock Categories?

Q. Create Stock Categories?
(a) Raw Material
(b) Finish goods.
Q. Create Stock Item For Raw materials
(a) Hard Disk (Seagate 80GB)
(b) DVD/CD RW Combo Drive
(c) Keyboard
Mouse Scroll
(e) 15” Monitor (Hitachi)
(f) Ram

Q. Create Stock Item for Finish goods

(a) S.S. Computer Pc.

June’07
07th Purchase Hard Disk (Seagate 80GB) @ Rs.1650, DVD/CD RW Combo Drive @ Rs.1450,
Keyboard @ Rs.300, Mouse Scroll @ Rs.150, 15” Monitor (Hitachi) @ Rs.3800 and Ram @
Rs.1000 from Supreme Technologies. The quantity purchased for each item is 56 pcs. (Bill
No.-PB/07-08/5).direct bill preferred.

Create a voucher type named “Manufacturing Entry” under Stock Journal.

Prefix: Mgf\, Suffix:\07-08. Method of numbering-“automatic”. activate the option prefill
with “zero”.

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 15
th
09 the company has decided to produce 8pcs of “S.S Computer PC Set” which should be
stored in Chitrakut godown. Charge 10% of raw material cost as factory overhead. No use to
need ‘tracking number.

12th Sold 6pcs of “S.S Computer PC Set” to Kush & Co. @ Rs. 34000.Bill ref.(sal/07-08/5).
They cleared the payment in cash on same day. Default Discount allowed.

14th The Company again has decided to produce 4pcs of “S.S Computer PC Set” which should
be stored in Chitrakut godown. Charge 12% of raw material cost as factory overhead.

15th The Company again has decided to produce 4pcs of “S.S Computer PC Set” which should
be stored in Chitrakut godown. Charge of raw material cost as factory overhead Rs.6000.

Q. Purchase all Raw material Stock Item.(F9)

Q. Create Voucher Types:-

Manufacturing Entry

VIEW THE FOLLOWING REPORTS:

1. Stock query report.
2. Product category summary
3. Sales and Purchase order book.

TRANSFER OF MATERIALS AND STOCK ITEM VERIFICATION

16th 5pcs of S.S Computer PC Set and 8 pack of Nokia-1600 handset were transferred from
Chitrakut to Saptarshi Godown.

16th 2pcs of S.S Computer PC Set and 5 pack of Nokia-1600 handset were transferred from
Chitrakut to Saptarshi Godown.

20th 8pcs of HP Laser Printer were transferred from Lakshya to Chitrakut Godown.

21st Physical counting of Saptarshi Godowns shows that 1pcs Nokia-2112 Handset and 1pcs
Nokia-1600 Handset is damaged due to water leakage. Make necessary adjustment.

25th An advertisement worth Rs. 45000 done through kanchan Advt.Agency on credit

28th Deposited cash Rs. 90000 to UTI Bank and Rs.60000 to HSBC.

Ans.-

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 16

Priyank Electronics & Computer Tech.

25/A Mahatma Gandhi Road Kolkata-14
Ph. No.-22546854 E-mail : Priyank.kol@gmail.in
CST No. 19340940855
VAT Registration no. 19340940855
The balance sheet as on 31st March 2007 is as follows:

Priyank Electronics & Computech Pvt. Ltd.

25/A Mahatma Gandhi Road Kolkata-14
Balance Sheet

Liabilities Assets
Capital Accounts 14,00,000 Fixed Assets 9,25,000
Arunangshu Capital 14,00,000 Furniture 1,15,000
Land & Building 5,00,000
Current Liabilities Computer & Accessories 3,10,000

Sundry Creditor 3,13,000 Investment 1,00,000

Durga electronics 1,48,000 Fixed Deposite with SBI 1,00,000

Bill. No-(PB/06-07/23B) 80,000
- (PB/06-07/38) 68,000 Current Assets

Shilpa Computer 65,000 Closing Stock 89,000

Bill no.- (PB/06-07/739) Stock in Trade 89,000

Mr Abhijeet Kundu 1,00,000

Bill no.-(PB/06-07/41c) Sundry Debtors 4,14,000

Outstanding Exp.(Current Liabilities) 1,12,000 Sapna electrods 1,85,000

Bill no-(SB/06-07/221)
Outstanding Salary 62,000
Outstanding Office Rent 35,000 Mr Aranya Singh Rai 85,000
Outstanding Electricity Charge 15,000 Bill No-(SB/06-07/101)

Loans(Liabilities) 1,00,000 Kush & Company 1,44,000

City Financials 1,00,000 Bill No-(SB/06-07/381)

Profit & Loss 7,0000 Bank Account 3,78,000

SBI 1,45,000
Opening (a/c 10403800469)
Current Period UTI Bank 1,35,000
(a/c 033010130408817)
HSBC (a/c 10332103432) 98,000
Cash in Hand 89,000

Total 19,95,000
Pass the following transactions. (create ledgers if necessary) 19,95,000
STS COMPUTER CENTRE
 SOFTECH COMPUTER EDUCATION
TALLY 17

April’07
2nd Bought a new computer for sale counter worth Rs. 28000 from Supreme Technologies.(bill
No.-NTRPR/07-08/1).

3rd The outstanding electricity bill has been paid through cheque of UTI Bank.

4th Paid Rs. 750 as Tiffin & Refreshment for office staff by cash.

7th Paid outstanding Salary through a cheque from UTI Bank.(Ch No.-303761)

8th Paid Rs. 25000 to Supreme Technologies.against Bill Ref No.(NTRPR/07-08/1)from HSBC
Bank.(ch no.331151)
9th Paid Rs. 5000 to Supreme Technologies from HSBC against Bill No.-NTRPR/07-08/1 rest
will be treated as advance. (Ch. No.-331152)

Tax
What is Tax?
For Maintain the Government expenses some amounts charged on person and other companies on
their incomes and other transaction called tax.
How many types of Tax?
There are two types of tax:-
1. Direct Tax-Direct Tax is such a Tax whose liabilities can not be shifted to other,the amount
of this tax is to be paid by the person or company on which it is charged by the government.
For
Examples:- TDS, TCS Etc.

2. Indirect Tax-Indirect Tax is such a Tax whose liabilities shifted to other. The amount of this
tax is to be paid by the person or company on which it is charged by the government and it
can be also charged to other person or company.
For Example:- VAT CST Service tax Etc.

TDS(Tax Deductor at source)

TDS is the one of the compulsory method of collecting income tax. It is charged on income
like Salary, Interest, Price, Commission, etc.by the government to the person or company by
which earned these income. the person or company on which charged tax called deductee,
and the company organization person which provides the income called deductor

Deductor charged some amount from income as tax and paid to government, and balance
amount paid to deductee.
The concept of TDS was introduced in the income tax act 1961.

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 18
Q.How To Activate Tds Features?

10th Paid Rs. 15000 as office rent to Mr Sandeep Thakur , They are the landlords of the above
premises.( TDS deducted 15%). Paid them through HSBC Bank.

10th Paid Rs. 8000 as office rent to Mr Goutam Sen, They are the landlords of the above
premises.( TDS deducted 15%). Paid them through HSBC Bank.

11th Paid Rs. 12000 as office rent to Mr Krishnendu Roy. They are the landlords of the above
premises.( TDS deducted 15%). Paid them through HSBC Bank.

12th An advertisement worth Rs.50000 from Balajee Communication Agency and amount paid
Their dues in full after deducting TDS

20th Deposit cash Rs. 3500 to HSBC Bank.

20th Deposite the Deducted Tds in Hsbc Bank.

-: Bank Reconciliation Statement :-

20th All the cheque of SBI and HSBC Bank was been cleared as usual time (after 3 days) except
ch. No.331145

24th Cleared by the bank, reconcile it.

Gateway of Tally---Display---Accounts Book---Cash/Bank Book---Bank A/c---Entre---Entre---

Press F5---Put Bank Date---Accept.

Ans.
TCS(Tax Collected at Source)
TCS is tax collected by the salary on the sales of certain goods/transaction mansion under
section 206C of income Tax act 1961. these goods/ transaction are scrap, Tendu leave,
Alcoholic liquid, Timber, Mining, Quarrying, Lease of parking lot, etc.

The amount of collected tax by the salary have to pay to government in specify time.

Q. How to Activate Tcs Features?

Q. Create Sales Ledger-Sales On Scrap
Q. Create Tax Ledger-Tcs On Scrap

August’07
14th Company sold the Four 15” Samsung monitors as scrap products for Rs. 10000 to Bimal &
Co. from Lakshya Godown. Apply TCS while generating sale bill No. scrap-sal/07-08/1.for
this purpose use ‘Scrap Sale Account’ as the sales a/c.

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 19
th
20 Bimal & Co. cleared their dues by cheque (ch no 452424 on India Bank). Deposited in UTI
Bank.

31st deposited the deducted TCS in UTI Bank. Ch. No.303763, BSR Code BSWW553 Bank
Challan No.: 15 dated 31st Aug 2007.

View the following reports

1. View the print preview of e-TDS forms, form 27B and form 27D.
2. Reconcile the TCS Challan.
3. Check whether and TCS Outstanding is there or not.

CST (Central Sales Tax)

Central state tax is central level tax charged on purchase/sale by goods from other state. This tax is
charged by central government. Cst is payable in the state from which the goods are sold.

VAT (Value Added Tax)

Value Added Tax is state level tax charged on purchase/sale of goods in the same state. This tax is
charged by state government.

Q. How to Activate CST/VAT?

CST(Central Sales Tax)

Q. Create Ledger For Cst.

(a) Purchase with cst
(b) Sales with cst
Q. Create Tax Ledger For Cst.
(a) Input Cst @ 4%
(b) Output Cst @ 4%

VAT(Value Added Tax)

Q. Create Ledger For Vat.

(a) Purchase with vat
(b) Sales with vat
Q. Create Tax Ledger For Vat.
(a) Input Vat @ 4%
(b) Output Vat @ 4%

5th purchase 24 pcs Samsung DVD from Mr Boss of new delhi@ Rs.1800 per pcs. Cst charged
@4%. Bill no.-pur/001.(C form issue)

5th Purchase 35 pcs nokia 6070 from Dev Industrial @ Rs. 4950 per pcs. Cst Charge @ 4% .bill
no.-pur/002.(form C issue).

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 20
th
6 Purchase 27 pcs Nokia 3110 From Nokia Show Room @ Rs. 5100 per pcs.Cst Charged @
4%.(Form D issue)

6th Sold 5 pcs Nokia 3110 @ Rs. 5400 per pcs to Dikshit & Co. of bhubneshwer. Cst charged @
4%. Bill no.-sal/001

8th Sold 4 pcs Samsung DVD @ Rs 2000 each pcs to Rajendra of kolkata.Cst charged @
4%.bill no.-sal/002.

9th Sold 6 pcs Nokia 6070 @ Rs. 5050 each pcs of D.N. Vedy of orrissa.cst charged @ 4%.bill
no.-sal/003.

10th Purchase 15 pcs Seagate harddisk @ Rs. 1650 each pcs by cash.+cst charged.

10th Purchase 12 nokia N71 @ Rs. 4100 each set by cash.+Cst Charge.

13th Sold 2 pcs Nokia 3110 @ Rs. 5000 and 4 pcs Nokia N 71 @ Rs. 4500 in Cach+Cst Charged .

16th Purchase 15 pcs Nokia 3110 From gayatri & Co. @ Rs. 4500 per pcs.Vat Charged @ 4%.

16th Sold 2 pcs Samsung Dvd @ Rs.1620+ Vat by Cash.

17th purchase 45 pcs Samsung DVD from Dayal @ Rs.1800 per pcs. Vat charged @4%. Bill no.-
pur/001.

17th Purchase 35 pcs nokia 6070 from Lakhaya Industrial @ Rs. 4050 per pcs. Vat Charge @
4% .
18th Sold 3 pcs Samsung DVD @ Rs 2100 each pcs to Rajendra .Vat charged @ 4%.

19th Sold 4 pcs nokia 6070 @ Rs. 5000 to sristi electronic, vat charged @4%

19th Sold 2 pcs Samsung Dvd @ Rs.1620+ CST by Cash.

SHORTCUT KEY OF TALLY

Company Info Alt+F1 or Alt+F3

Shut Company Alt+F1
Period Change Alt+F2
Date F2
Delete Alt+D
Alter Ctrl+Enter
Accept Ctrl+A
Online Creation Alt+C
Features F11
Accounting Features F1
Inventory Features F2
Contra Voucher F4
STS COMPUTER CENTRE
 SOFTECH COMPUTER EDUCATION
TALLY 21
Payment Voucher F5
Receipt Voucher F6
Journal Voucher F7
Attendance Voucher Ctrl+F5
Payroll Voucher Ctrl+F4
Purchase Order Alt+F4
Purchase Challan Alt+F9 (Receipt Note)
Purchase Bill F9
Purchase Return Ctrl+F9 (Debit Note)
Sales Order Alt+F5
Sales Challan Alt+F8 (Delivery Note)
Sales Bill F8
Sales Return Ctrl+F8 (Credit Note)
Stock Journal Alt+F7 (Transferred)
Manufacturing Entry Alt+F7
Physical Stock Alt+F10
Entry up Page up
Entry down Page down
Print Alt+P

-: SERVICE TAX :-

Service tax is a type of indirect tax. Which is leaved on the sales of services. it’s indirectly
collected from the buyer of such service. The sales is required to deposit the service tax
collected from the buyer to the government.

Service tax is leader almost all service like travel Agency banking end financial service,
cable, etc.

Q. How to Activate Service Tax?

Create Service tax ledger “Repairing Charge” and “Networking consultancy charges”, type
will be sales, and a service ledger “Engineering consultancy charge”, as purchase type
remembers to unable service tax applicable to yes for this ledger.

Q. Create sales ledger.

(a) Repairing Charge.
(b) Networking consultancy charges.

Q. Create purchase ledger.

(a) Engineering consultancy charge.

Q. Create Tax Ledger for Service Tax.

(a) Input Service Tax.
(a) Output Service Tax.

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 22
Q.1 Mr. Sharma Repairing Co. has placed an order to repair 18 pcs of Mobile phone .
service has been provided in 3 days. Bill charge Rs. 3000. with applicable service charge.
(bill no.-ser/12-13/001).

Receive an order for lan Ups consultancy (item) from “WB Kolkata” for Rs. 45000+service
tax. The job has been done in 20days with the help of “kolkata network associates” an
engineer consultancy form on network.

Q.2 Receive a bill for consultancy charges from “kolkata network associate”for this service
amounting Rs. 20000 service tax has been charged extra. (bill no.-pser/12-13/001).

Sent bill to “WB Kolkata” as lan Ups consultancy (item) according to agreement.(ser/12-
13/002)

Q.3 Receive the due amount from Mr. Sharma Repairing co. in cash.

Q.4 Paid to “kolkata Network associate” all their dues by cheque of HSBC bank. (ch no.-
564123)

Q.5 Received Rs. 40000 from “WB kolkata” agst bill no-ser/12-13/002.

Q.6 Compute service tax payable. View and print.

Q.7 Paid service tax at SBI (BSR Code-325284)

Payroll

It is features of tally related to accounting features. It is used to maintain Employee Salary.

We can also calculate employee salary for calculate employee salary. We have to
create
 Attendance/Production Type
 Pay Head
 Employee Group
 Employee
 Salary Details, etc.

1. Create a new Company (Any Name).

2. Activate Payroll Features.(F11F1)

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 23

3. Create Cost Categories.(Payroll Management)

4. Create Attendance/Production Types.(Absent-Leave without Pay)
5. Create the followings Pay Heads.

SI.NO Pay Type Under Calculation Formula

. Head
Type Period
1 Basic Earning Indirect On Attendance Monthly No
for Exp.
employee
2. DA Earning Indirect Computed Value Monthly 40% Of
for Exp. Basic
employee
4. Bonus Earning Indirect User Defined (Per No
for Exp. Months)
employee
6. PF Employee Current Computed Value Monthly 12% Of
statutory Liabilities Basic+DA
deduction
7. Salary Not Current ---
Payable Applicabl Liabilities
e

6. Create the Employee Groups:-

Group Name Under
Manager Primary
Clerks Primary
Acc. Clerks Clerks
Office Clerks Clerks
Sales Manager Manager

STS COMPUTER CENTRE

 SOFTECH COMPUTER EDUCATION
TALLY 24

7.Create Employee using followings Information’s. Their details are given below:

Si. No. Name Designation DOJ Location DOB Blood

Gr.
1. Aranya Manager 1-4-2014 Kolkata 1-9-1990 B+ve
2. Shubham Clerks 1-4-2014 Dargiling 1-1-1990 B+ve
3. Arun Acc Clerks 1-4-2014 Kolkata 5-4-1991 A+ve
4. Sandeep Sales 1-4-2014 Kolkata 3-1-1993 AB+
Manager
5. Devashish Off. Clerks 1-4-2014 Malda 5-2-1998 A+ve

8. Create the Salary Details for the employee group:

9. Create Salary details for Employee.
10.Create Attendance Voucher entry.
11.Create Payroll Voucher entry.
12.See the Pay slip.
13.Payment each Employee.

STS COMPUTER CENTRE