How to apply the programs:
Tally.ERP9:
1). Open your Microsoft Office application by the following navigation Start-
>all programs-> Tally.ERP9.
2). you can visual the gate way of Tally.ERP9
3). For creating company following the navigation Gate
way of Tally ->Create.
4). For creating Ledger following the navigation
Gate way of Tally -> Accounts Info -> Ledger -> Single Ledger Create.
5). For creating voucher following the navigation
Gate way of Tally -> Transactions -> Accounting Vouchers ->
6). View reports by following the navigation
Gate way of Tally -> Reports -> Balance Sheet (or) Profit and Loss (or) Stock Summary
(or) Ratio Analysis ->
7). Create Inventory Master by following the navigation
a) Gate way of Tally -> Inventory Info -> Stock Group -> Single Stock Group
Creation/ Multiple Stock Group Creation - > create and accept by pressing Yes.
b) Gate way of Tally -> Inventory Info -> Units of Measure -> Creation - > create
and accept by pressing Yes.
C) Gate way of Tally -> Inventory Info -> Stock Categories -> Single Stock
Category Creation/ Multiple Stock Category Creation - > create and accept by pressing
Yes.
D) Gate way of Tally -> Inventory Info -> Godown -> Single Godown Creation/
Multiple Godown Creation - > create and accept by pressing Yes.
E) Gate way of Tally -> Inventory Info -> Stock Items -> Single Stock Item
Creation/ Multiple Stock Item Creation - > create and accept by pressing Yes.
This is how we can apply the programs.
List of Lab Exercises
S.
Name of the program
No.
Create company in the name of “Rathinam & Co” in tally ERP 9 with VAT options. ❖
1. Accounts with Inventory option.
❖ Financial accounting year 01.04.2016 on wards.
To create below mentioned single ledger accounts in the books of “Rathinam & Co”.
Mr. Kumar Advertisement (Free Sample Send)
Commission Received in Advance Bad Debit
2. Insurance Premium Pre-Paid Depreciation
Advertisement ( Free Samples Received) Interest Paid
Commission Received Provision for Doubtful Debit
Create multiple ledgers under appropriate predefined groups with the opening balance as
on 01.04.2016 in “Rathinam & Co.
Ramesh (Sundry Debtors) Rs. 52,000 Rent, Rates and Taxes Rs. 3,600
Insurance premium paid
Mohan (Sundry Creditors) Rs. 22,000 Rs. 2,400 on 1st January,
20016
Cash in Hand Rs. 10,392 Cash at SBI Bank Rs .6,200
Furniture Rs. 3,500 Machinery Rs. 24,000
3.
Motor Car Rs. 22,000 Wages Rs. 23,600
Purchases Rs.145,000 General Expenses Rs. 2,680
Sales Rs.2,92,000 Carriage Inward Rs. 2,040
Sales Returns Rs. 2,600 Carriage outward Rs. 1,630
Salaries Rs. 8,420 Fuel and Power Rs. 6,430
Opening Stock Rs. 11,400 Rathinam & Co's Capital Rs. 20,000
Motor Car Expenses Rs. 6,108 Drawings Rs. 8,000
The following information is relevant to “Rathinam & Co” Books of Accounts.
You are requested to
a. Make the necessary closing entries,
1 Closing Stock Rs.35,000.00
2 Goods worth Rs.2,000 were distributed as free samples
3 Rs.1, 000 paid for machinery fitting expense was debited to wages account.
4 Write off bad debts Rs.2, 000 and provision for Doubtful Debts at 5% of
Sundry Debtors.
5 Provide Depreciate on furniture 10%, Machinery 10% and Motor car 20%.
4.
6 Commission of Rs. 3,600 has been earned but not received till the close of the
accounting year.
7 An amount of Rs. 10,000 was borrowed from Mr. Kumar on October 1st 2016
and it was returned on 31st March 2017. However, Interest at 10% p.a. still
remains unpaid.
b) Prepare Trading and profit & Loss a/c and
c) Balance sheet as on 31.03.2017.
d) Also prepare * Ratio Analysis. (*Shot term & Long term Solvency
ratio, *Current Ratio, *Quick ratio.
M/s. Bharath Electronics is a manufacturing &trading firm of electronic goods owned
by Mr. Bharath and Mr. Kannan works as an Accounting Manager. The firm uses Tally
ERP 9 to record their business transactions.
Kindly guide Mr. Bharath in creating the above mentioned company in Tally ERP 9
with the name of his firm creating a user account for Mrs. Kannan giving owner right.
Mr. Bharath is very much concerned about the data security and that is why he decides
to adopt the following password policy:
1. Minimum length of password should be 8 with at least 2 alphabets, 1
number and one specialist character in it. (for Example :Saravanam1^)
2. Users need to change password on first login.
3. User should be provided the rights to change their passwords.
After setting password policy in Tally ERP 9, create up the above a suitable
5. password for Mr. Kannan.
Create the following Multiple Groups under Fixed Assets in the books of M/s. Bharath
6. Electronics: Computer Furniture Buildings
Create the below mentioned Ledgers under appropriate groups in the books of M/s.
Bharath Electronics:
Mr. Awaaz’s Capital A/c Output CST@ 2%
7. Mr. Awaaz’s Drawing A/c Sales Return @ VAT 5%
Sales VAT @ 14.5% Purchase Return @ VAT 5%
Output VAT @ 14.5% CST Sales Return @ 2%
Purchase VAT @ 14.5% CST Purchase @ 2%
Input VAT @ 14.5% Input CST @ 2%
CST Sales @ 2% SBI Bank
Create the following Multiple Ledgers under appropriate groups in the books of M/s.
Bharath Electronics:
Malar & Co., (Sundry Debtors) Furniture
Annam P. ltd., (Sundry Debtors) Buildings
Shanmugam P. Ltd., (Sundry Creditors) Depreciation
8. Lalith& Co., (Sunday Creditors) Electricity Charges
Carriage inward Telephone Charges
Carriage outward Salary paid
Wages Salary Payable
Computer Bank Charges
Bank interest
Create the following data in the books of M/s. Bharath Electronics:
a) Unit of Measurement: Nos. (Numbers), Doz. (dozen)
b) Godown: Tech Zone Godown, 16/25, Rathinam Corner, Eachinary,
Coimbatore. Under Primary. By allow storage of material option as yes.
c) Stock Categories:15” & 17” (LG Monitor Inch wise)
9. d)Stock Groups :
LG Monitor Printer Keyboard
e) Stock Item:
LG Monitor 15” HP Laser 1010
LG Monitor 17” Dell Key Board
Samsung Printer Lenova Keyboard
TVS Epson Printer Asus Keyboard
Create voucher by using cost center, cost categories and tracking numbers for the
following transaction in the books of M/s. Bharath Electronics.
a) On 01.04.2016 Bharath introduced Capital of Rs. 10, 00,000/- by cash.
b) On 08.06.2016 Purchased 20 Nos. of LG Monitor 15” each for Rs.6,000/- with
Carriage inward @ 6% on purchase cost. Input tax @ 14.5% from the Shanmugam
P. Ltd., & Storage in Tech Zone Godown.
c) On 07.09.2016 Sold 8 Nos. of LG Monitor 15” form Tech Zone Godown to
M/s.Malar& Co., for Rs. 10000/- Each excluding Sales tax @ 14.5% is Rs. 11600/-
with 30 days Credit Period
d) Carriage outward @ 5% on Sales dated on 07.09.2016 Paid.
10.
e) On 12.8.2016 Returned 2 nos. of LG Monitor 15” to the Shanmugam P. Ltd.,
but
not returned Carriage input.
f) On 16.09.2016 M/s. Malar & Co., returned 3Nos. of LG Monitor 15”
g) On 3.10.2016 Cash deposited in SBI Bank Rs. 1, 00,000/-
h) On 10.10.2016 Electricity charges paid Rs.850/- By SBI bank cheque No.
146814
i) On 18.10.2016 Salary Paid to Sales Department Staff Mr. Ram Rs. 8,000/-
j) On 31.6.2016 Bank charges paid 250/-
k) On 31.12.2016 Bank interest received Rs. 1250/-
Export the Balance sheet and Profit and loss Account of M/s. Bharath Electronics in
11. excel format or Xml format and E – Mail the same to Mr. Bharath.
12. Take a print out of Cheque no. 146814 Issued 10.10.2016 to Electricity charges.
Split company of M/s. Bharath Electronics from the date of 01.04.2016 to 31.03.2016
13. & 01.04.2017 to 31.03.2017
Take a backup of “Bharath Electronics” & “Rathinam & Co” Books of Accounts in E
14. Drive.
Background Theory
Tally ERP 9:
Tally.ERP 9 leading accounting package. The first version of Tally was released
in 1988 and, through continuous development, is now recognized as one of the leading
accounting packages across the world.
It requires no accounting codes. And it provides a comprehensive solution to the
accounting and inventory needs of a business. The package comprises financial account-
ing, book-keeping and inventory accounting. It also has various tools to extract, interpret
and present data.
Tally Integrates/ Non-integrates accounting and inventory. It is Flexible, Speedy
and easy to use. Tally.ERP 9 provides the capability to generate instant and accurate
reports in time for different periods. Tally.ERP 9 allows the user to maintain multiple
companies and with unlimited levels of classification & grouping capabilities.
Tally.ERP 9 offers a special Auditors' Edition of Tally.ERP 9, which pro-vides auditing
and compliance capabilities exclusively for Chartered Accountants.
EXECUTION OF PROGRAMS
TALLY
1. PROGRAMME
Create company in the name of “Rathinam & Co” in tally ERP 9 with VAT options. ❖
Accounts with Inventory option.
❖ Financial accounting year 01.04.2016 on wards.
AIM: To Create a Company with all relevant data including VAT options.
Algorithm:
Step 1: Click Start button.
Step 2: Select all programs
Step 3: Select Tally.ERP9 & Enter.
Step 4: Select Create company in gate way of tally. or Press C
Step 5: Fill the details as required in the page. And accept the screen.
OUTPUT:
Created a company.
2. PROGRAMME:
To create below mentioned single ledger accounts in the books of “Rathinam & Co”.
Mr. Kumar Advertisement (Free Sample Send)
Commission Received in Advance Bad Debit
Insurance Premium Pre-Paid Depreciation
Advertisement ( Free Samples Received) Interest Paid
Commission Received Provision for Doubtful Debit
AIM: To Create the single Ledger under appropriate predefined groups.
Algorithm:
Step 1: Click Start button.
Step 2: Select all programs
Step 3: Select Tally.ERP9 & Enter.
Step 4: Select company in gate way of tally.
Step 5: Go to gate way of tally, Account info or press A.
Step 6: Go to Leger or press L
Step 7: Select single ledger create or press C. And Enter the ledger head and other
details Also accept the screen by press yes. Like wise creat for the others too.
OUTPUT:
Created ledgers under appropriate groups.
3. PROGRAMME:
Create multiple ledgers under appropriate predefined groups with the opening balance as
on 01.04.2016 in “Rathinam & Co.
Ramesh (Sundry Debtors) Rs. 52,000 Rent, Rates and Taxes Rs. 3,600
Insurance premium paid
Mohan (Sundry Creditors) Rs. 22,000 on 1st January, 20016 Rs. 2,400
Cash in Hand Rs. 10,392 Cash at SBI Bank Rs .6,200
Furniture Rs. 3,500 Machinery Rs. 24,000
Motor Car Rs. 22,000 Wages Rs. 23,600
Purchases Rs.145,000 General Expenses Rs. 2,680
Sales Rs.2,92,000 Carriage Inward Rs. 2,040
Sales Returns Rs. 2,600 Carriage outward Rs. 1,630
Salaries Rs. 8,420 Fuel and Power Rs. 6,430
Opening Stock Rs. 11,400 Rathinam & Co's Capital Rs. 20,000
Motor Car Expenses Rs. 6,108 Drawings Rs. 8,000
AIM: To Create the Multiple Ledger under appropriate predefined groups.
Algorithm:
Step 1: Click Start button.
Step 2: Select all programs
Step 3: Select Tally.ERP9 & Enter.
Step 4: Select company in gate way of tally.
Step 5: Go to gate way of tally, Account info or
press A
Step 6: Go to Leger or press L
Step 7: Select Multiple ledger creation R. And Enter the ledger head and
other details Also accept the screen by press yes. Like wise create for the
others too.
OUTPUT:
Created ledgers under appropriate groups.
4. PROGREMME:
The following information is relevant to “Rathinam & Co” Books of Accounts.
You are requested to
a. Make the necessary closing entries,
1 Closing Stock Rs.35,000.00
2 Goods worth Rs.2,000 were distributed as free samples
3 Rs.1, 000 paid for machinery fitting expense was debited to wages account.
4 Write off bad debts Rs.2, 000 and provision for Doubtful Debts at 5% of
Sundry Debtors.
5 Provide Depreciate on furniture 10%, Machinery 10% and Motor car 20%.
6 Commission of Rs. 3,600 has been earned but not received till the close of the
accounting year.
7 An amount of Rs. 10,000 was borrowed from Mr. Kumar on October 1st 2016
and it was returned on 31st March 2017. However, Interest at 10% p.a. still
remains unpaid.
b) Prepare Trading and profit & Loss a/c and
c) Balance sheet as on 31.03.2017.
d) Also prepare * Ratio Analysis. (*Shot term & Long term Solvency ratio,
*Current Ratio, *Quick ratio.
AIM: To Create Vouchers and view Profit and loss a/c and balance Sheet & Also present
Ratio Analysis. (*Shot term & Long term Solvency ratio, *Current Ratio, *Quick
ratio.
Algorithm:
Step 1: Click Start button.
Step 2: Select all programs
Step 3: Select Tally.ERP9 & Enter.
Step 4: Select Create company in gate way of tally. or
Press C.
Step 5: Fill the details as required in the page. And
accept the screen.
Step 6: Go to gate way of tally, Account info or press
A.
Step 7: Go to Leger or press L
Step 8: Select single ledger create or press C or Multiple ledger creation R. And
Enter the ledger head and other details Also accept the screen by press yes.
Step 9: Go to Gate way of tally, Transactions, Accounting Vouchers or Press V
and make necessary voucher entry. Likewise create for the others too.
Step 10: Go to Gate Way of Tally, click Profit and Loss A/c. or press P.
Step 11: Go to Gate Way of Tally, click Balance Sheet or press B.
Step 12: Go to Gate Way of Tally, click Ratio Analysis or press R
OUTPUT:
Created Vouchers and view Profit and loss a/c and balance Sheet.
