CONTENTS
S.No DATE PARTICULARS PAGE NO SIGN
1 Creation of Company, Groups and Ledger
2 Preparation of Receipts & Payments Vouchers
3 Preparation of Purchase Order, Purchase
voucher and Debit Note
4 Preparation of Sales Order, Sales voucher and
Credit Note
5 Preparation of Contra and Journal Vouchers
6 Payroll Voucher and Payroll Report
7 Preparation of Final accounts
8 Preparation of Inventory Statement
9 Accounts with inventory and go-down wise
Summary
10 Calculation of GST
11 GST invoices at Stock Group & Stock Item
12 Sales to Consumers
13 Interstate Sales to Unregistered Dealers
14 Filing of GST Returns
Ex.no:1
CREATION OF NEW COMPANY GROUPS AND LEDGER
Create a new company, groups and Ledger
Aim:
To create company, groups and Ledger
Algorithm:
Step 1: Click on start - all programs- TALLY ERP 9. In company Info Select create company
option.
Step2: Enter the name, address, phone number and select "Account Only" Option and press
ENTER to get "Accept YES or NO"
Step 3: For Group Creation, Select the GATEWAY of TALLY. Select ACCOUNTS INFO -
GROUP - SINGLE - CREATE.
Step 4: Type the name of the group to be created.
STEP 5: For ledger creation in ACCOUNTS info, select LEDGER - MULTIPLE - CREATE
STEP 6: Enter all accounts to be created.
STEP 7: Thus, the company groups and ledger is created.
OUTPUT
RESULT
Thus the new company is created with groups and ledger
Ex.no:2
VOUCHER ENTRY FOR RECEIPT, PAYMENT
Enter various voucher entries in their respective voucher of the company.
Receipt Voucher
Rs.5000-Received from Mr. Kumar
Rs.2600-Received through cheque from Stanes &co
Rs.1500-Commision received by cash
Rs.1000-Cash on sales of last machinery
Rs.2500-Received by cheque towards interest.
Payment voucher
Rs.4500-Paid for Bonus
Rs.200-Salary by issue of cheque
Rs.450-Electronic Charges
Rs.150-Telephone bill through KVB bank cheque
Purchased machinery for Rs.3000 and Rs.2000 paid by Canara Bank cheque and balance Rs.100
by cash to Chitra & co
AIM
To enter various voucher entries in their respective vouchers of the company.
ALGORITHM
STEP 1: Click on Start ->All programs-> Tally ERP9
STEP 2: In the company info select create company and create company with necessary
information.
STEP 3: Create ledger under multiple ledger creation window select ledger account under
respective group.
STEP 4: For entering journal entries in gateway of tally select accounting voucher and click F6
for entering receipt voucher & press enter to get accept yes or no
STEP 5: For entering payment entries in gateway of tally select accounting vouchers and click F5
STEP 6: To view voucher entries in gateway of tally select display -> day book.
OUTPUT
RESULT:
Thus the voucher entry for receipt, payment, has been created for the company.
EX NO 3
PREPARATION OF PURCHASE ORDER, PURCHASE VOUCHER AND DEBIT NOTE
Purchase Order
Kannan & Co Ltd, Chennai
S.No Particulars Quantity Rate per unit
1 Bricks 10000 nos 23000
2 Sand 5000 kgs 5000
3 Cement 7000 tons 1200
4 Steel Rod 8000 tons 5000
Purchase Voucher
1. Purchased bricks from Mr.Kumar Rs.10000
2. Purchased cement from Ram & Co Rs.10000
3. Purchased sand for company Rs.10000
4. Purchased steel rod from Mr.Kumar and paid through bank Rs.10000
Debit Note
Goods returned to Mr.Kumar Rs.2000
Goods returned to Ram&Co Rs.2000
AIM :
To prepare purchase order, purchase voucher and debit note for the company.
ALGORITHM
STEP 1: Click on Start ->All programs-> Tally ERP9. In the company info select create
company and create company with necessary information.
STEP 2: Create ledger under multiple ledger creation window select ledger account under
respective group.
STEP 3 : Goto gateway of tally -> Accounting Info -> Inventory features -> Enable purchase
order processing / set as ‘Yes’ and save it.
STEP 4 : Goto gateway of tally -> order vouchers -> purchase order voucher. Enter the
necessary details for preparing purchase order.
STEP 5 : Now to create accounting voucher, goto gateway of tally -> Accounting voucher.
STEP 6 : Press F9 to activate purchase voucher
STEP 7 : In order to enable the option for debit note press F11, the accounting feature note. Set
‘Yes’ to the option, click invoice note and debit note.
STEP 8 : Now all purchase transactions can be recorded using voucher and invoice mode.
STEP 9 : For recording debit note choose Alt+F8. So debit window get opened.
STEP 10 : Journal entry for debit note can be made accordingly.
OUTPUT
RESULT :
Hence the program is created and displayed then the output is printed.
EX NO 4
PREPARATION OF SALES ORDER, SALES VOUCHER AND CREDIT NOTE
Sales Order
Stances & Co Ltd, Chennai
S.No Particulars Quantity Rate per unit
1 Bricks 8000 nos 23000
2 Sand 4000 kgs 5000
3 Cement 3000 tons 1200
4 Steel Rod 2000 tons 5000
Sales Voucher
1. Sold bricks from Mr.Kumar Rs.8000
2. Sold cement from Ram & Co Rs.20000
3. Sold sand for company Rs.70000
4. Sold steel rod from Mr.Kumar and paid through bank Rs.7000
Credit Note
Goods returned from Mr.Kumar Rs.4000
Goods returned from Ram&Co Rs.200
AIM :
To prepare sales order, sales voucher and credit note for the company.
ALGORITHM
STEP 1: Click on Start ->All programs-> Tally ERP9. In the company info select create
company and create company with necessary information.
STEP 2: Create ledger under multiple ledger creation window select ledger account under
respective group.
STEP 3 : Goto gateway of tally -> Accounting Info -> Inventory features -> Enable sales order
processing / set as ‘Yes’ and save it.
STEP 4 : Goto gateway of tally -> order vouchers -> sales order voucher. Enter the necessary
details for preparing sales order.
STEP 5 : Now to create accounting voucher, goto gateway of tally -> Accounting voucher.
STEP 6 : Press F6 to activate sales voucher
STEP 7 : In order to enable the option for credit note press F11, the accounting feature note. Set
‘Yes’ to the option, click invoice note and credit note.
STEP 8 : Now all purchase transactions can be recorded using voucher and invoice mode.
STEP 9 : For recording credit note choose Alt+F9. So credit note window get opened.
STEP 10 : Journal entry for credit note can be made accordingly.
OUTPUT
RESULT
Hence the program is created and displayed then the output is printed.
EX NO : 5
VOUCHER ENTRY FOR CONTRA AND JOURNAL
Enter various voucher entries in their respective voucher of the company.
Contra Voucher
Cash deposited into Canara Bank-Rs.2000
Cash withdrawn from Canara Bank-Rs.500
Deposit draft of State bank deposited into Canara bank-Rs.5000
Canara bank cheque deposited into Karnataka bank-Rs.1500
Canara bank cheque given to Karnataka bank for fund transfer -Rs.1000
Cash withdrawn from Karnataka bank for local expenses-Rs.250
Journal
Depreciation at Machinery Rs.200
Bad debts Rs.100
AIM
To enter various voucher entries in their respective vouchers of the company.
ALGORITHM
STEP 1: Click on Start ->All programs-> Tally ERP9
STEP 2: In the company info select create company and create company with necessary
information.
STEP 3: Create ledger under multiple ledger creation window select ledger account under
respective group.
STEP 4: For entering journal entries in gateway of tally select accounting voucher and click F4
for entering contra voucher & press enter to get accept yes or no
STEP 5: For entering journal entries in gateway of tally select accounting vouchers and click F7
for journal
STEP 6: To view voucher entries in gateway of tally select display -> day book.
OUTPUT
RESULT:
Thus the voucher entries for contra and journal has been created for the company.
EX NO 6
PAYROLL VOUCHER AND PAYROLL STATEMENT
Purchase Department
Kavi:
Basic Pay Rs.50000, DA – 10000, HRA – 5000, PF – 2000, ESI – 3000
Madhu:
Basic Pay Rs.40000, DA – 8500, HRA – 5000, PF – 1000, ESI – 300
Sales Department
Raj:
Basic Pay Rs.33540, DA – 9500, HRA – 6200, PF – 1800, ESI – 1400
Siddharth:
Basic Pay Rs.78200, DA – 4680, HRA – 3650, PF – 2000, ESI – 3000
AIM:
To create payroll with pay head, employee master employee group and attendance and production type.
ALGORITHM:
STEP 1: In a company setup go to the gateway of tally- company info – create company. In the company
creation screen, select in D14 in the field. Statement compliance for from the list of countries provided. I
type 01.04.2019,the financial year from data and press enter the accept for the company.
STEP 2: Payroll configuration. The configuration can be activated through gateway of tally-display
select F12 configure-payroll configuration.
STEP 3: In the enable payroll go to the gateway of tally press F11 company figure press F11 accounting
figure.
STEP 4: In the F11 accounting figures screen set maintain payroll to yes set more than 1 payroll/ cost
category to get the completed F11.Accounting features screen press enter to accept the F11 accounting
screen.
STEP 5: Payroll the statutory to enable statutory features go to the gateway of tally-press F 11 company
features-press F3 statutory and transaction.
STEP 6: In F11 statutory and taxation features screen set enable payroll to yes /alter payroll statutory
details to yes press payroll statutory with enter.
STEP7: In F11 statutory and transaction feature screen enter the provident fund and it’s transaction
features screen the provident fund and employees state insurance details of the company press ctrl+A to
accept the screen.
STEP 8: To create a payhead,go to the gateway of tally payroll info payhead create the following screen
will be displayed the details of the screen like name.An appropriate name distributing the nature of the
ledger a payhead may be used in payroll either as learning deduction or one of the payhead would appear
in payroll.
STEP 9: Create an employee master to order an employee master go to the gateway of tally-payroll info-
employee enter the request employee details and employees group up by grouping employee under the
function they perform in their department of deligation.
STEP 10: Employee group creation, to create manager as an employee create after the entries made.
STEP 11: To create attendance/production, go to type-create, enter the name under primary group and
select the unit from the list create students a tendency/production. Type for paid leave and unpaid leave as
group and casual leave, sick leave+overtime.
OUTPUT
RESULT
RESULT:
Hence the program is created and displayed and output.
EX NO 7
PREPARATION OF FINAL ACCOUNTS
PARTICULARS PARTICULARS
Capital 5000 Rent and stores 1800
Cash at bank 8000 Printing 1200
Cash at bank 500 Opening stock 3000
Building 30000 Dividend received 400
Wages 15000 Return outwards 2000
Salary 10000 Sales return 1500
Interest 100 Bills receivable 4000
Loan 3000 Purchase 70000
Travelling expenses 1800 Insurance 800
Gas and water 2200 Drawing 6000
Debtors 15000 Machinery 12000
Creditors 10000 Furniture 7500
Discount allowed 400
Rent received 200
AIM
To prepare the voucher entries ,profit and loss account ,balace sheet of sri ram & co
ALGORITHM
STEP 1: click start--- programs--- tally ERP9
STEP 2: in the company info --- select “create company” enter the name ,address,phone number
and select “account only” option and then enter to get accept “yes or no”
STEP 3: for ledger creation in account info select ledger --- multiple --- create
STEP 4: in multiple ledger creation window select all item and create the ledger accounts under
the respective group
STEP 5: in ledger for altering the closing stock select --- single--- alter opening stock
STEP 6: for entering journal entries , in gateway of tally select accounting voucher and then
click for journal voucher and enter all journal entries
STEP 7: to view trial balance of tally select display trial balance and press ALT F1 for detailed
view
STEP 8: to view voucher entries in gateway of tally select display--- day book
Step 9: to view profit and loss account in gateway of tally select profit and loss account
STEP 10: to view percentage in gateway of tally select balance sheet and press ALT F1 detailed
view
OUTPUT
RESULT
Thus, the final accounts prepared successfully
Ex no:8
PREPARE AN INVENTORY STATEMENT
Prepare an inventory statement from the following items:
PARTICULARS QUANTITY RATE
PER
UNIT
Montex pen 100 nos 10
Renolds 100 nos 5
Natraj sharpeners 100 nos 3
Camlin colour pen 150 nos 35
Carrot 20 kgs 10
Potato 100 kgs 25
AIM:
Brinjal 150 kgs 35
To prepare Tomato 200 kgs 16 an
inventory Beans 25kgs 24 statement
Natraj hero pen 150 nos 45
using all methods
Tip 5 nos 7
Pepsi 5lts 30
Coca – cola 10lts 35
Maaza 15 lts 40
Slice 20 lts 42
Table fan 15 pcs 500
Ceiling fan 20 pcs 400
Tube light 10 pcs 75
Drone box 5 pcs 1250
Exhaust fan 20 pcs 450
Lux 20 pcs 40
Titan watch 10 pcs 200
HMT watch 100 pcs 10
Parle G 700 pcs 5
Britannia marie gold 800 pcs 10
Rexona soap 120 pcs 35
Mysore sandal 132 pcs 35
ALGORITHM:
STEP 1:Click Start---All programs---Tally ERP9
STEP 2: In that company info select “create company” option and
enter the name, address, pincode, phone number and select “Accounts with inventory” and
then enter to accept “Yes or No”
STEP 3:Select Yes and then the company will be created.
STEP 4: To create stock group, go to Gateway of tally Inventory
info ---Stock group --- Multiple ---Create. Then click stock group with primary and accept
“Yes”. Stock group is created.
STEP 5:To create unit of measure, go to Gateway of tally --- Inventory info ---Unit of measure
---Create
STEP 6: Create various units as those for numbers with 2 decimal Point. “Kgs” for kilograms,
“lts” for litres, “pcs” for pieces, “doz” for dozens with 0 decimal point and accept “Yes”
STEP 7:In stock item creation select all items and enter all the stock Items with their respective
stock group unit of measure.
STEP 8: To view summary, go to Gateway of tally --- Stock summary (Alt + F1) for dividend
view.
OUTPUT
RESULT:
Thus, the inventory statement of all methods is created.
EX.NO : 9
ACCOUNTS WITH INVENTORY AND GODOWN DETAILS.
Stock groups Stock items Godown Quantity Rate per unit
Raw material Core 1 RM 800kg 2
Raw material Core 2 RM 3000 kg 30
Raw material KV2 RM 5000 kg 42
Raw material Fire wood RM 4500 kg 25
Finished goods Chemicals FG 2500 kg 26
Finished goods Bearing FG 1000 kg 35
Finished goods MV300 FG 758 kg 41
Create godown stock summary of a company
AIM
To prepare accounts with inventory and godown details.
ALGORITHM
STEP1: Start-->All programs-->Tally ERP.
STEP2: Create a company by selecting accounts with inventory.
STEP3: To create stock group go to gateway of tally-> inventory info->stock group->multiple
group stock group with primary.
STEP4: To create unit of measure go to gateway of tally->inventory info->unit of measure->
create.
STEP5: Create various units "nos" for numbers. "kg" for kilograms, "ltrs" for liters, "pes" for
pieces "doz" dozens and give yes.
STEP6: In stock items creation select inventory info and enter the stock items with their
respective stock group, unit of measure, quantity, rate per unit and give yes.
STEP7: In the features of the company select yes in maintaining multiple godown.
STEP8: To create a godown go to inventory info-> godown->range/multiple godown->create.
STEP9: Godown creation window opens give the details of the godown and click accept.
OUTPUT
RESULT
Thus accounts with inventory and godown details are created.
EX NO: 10
CALCULATION OF GST
Enter Purchase and sales bill with GST in tally ERP9.
Purchase Voucher;
Purchased bricks from Mr. Kumar-Rs.10,000
Purchased cement from Ram & co-Rs.15000
Purchased sand for company-Rs.10000
Purchased steel rod from Mr. Kumar and paid through Canara bank-Rs.20000
GST Rate @12%
Sales Voucher;
Sold frocks to Mr. Ramesh for Rs.25000
Sold kurthis for cash for Rs.10000 Sold to Mr. Ramesh sand for Rs.4000
GST Rate @15%
AIM
To enter purchase and sales bill with GST in tally ERP9.
ALGORITHM
STEP 1: Click on start->all programs-> tally ERP 9
STEP 2: Create a company with regular details and click F11 button and Change the first
configuration from ‘’no” to ‘’yes”
STEP 3: Give GST related items as yes
STEP 4: Create ledger with the details and give ‘’yes” in all GST details
STEP 5: In gateway of tally select inventory info -> stock group-> create Example: Rice-> rice
and GST option as yes
STEP 6: And in stock items enter as yes Example => rice and GST option as yes
STEP 7: In accounting voucher enter purchase details and party names as A a/c & enter GST
@5% central tax as 2%
STEP 8: At last press Alt +E and give yes
STEP 9: And create sales bill in same method [only ledger varies]
STEP10: Both purchase and sales bill will be entered
OUTPUT
RESULT
The purchase and sales bill with GST is entered.
EX NO : 11
GST INVOICES AT STOCK GROUP & STOCK ITEM
PARTICULARS QUANTITY RATE
PER
UNIT
Monitor 100 nos 10
100 nos 5
100 nos 3
150 nos 35
20 kgs 10
100 kgs 25
UPS 150 kgs 35
200 kgs 16
25kgs 24
150 nos 45
5 nos 7
5lts 30
Printer 10lts 35
15 lts 40
20 lts 42
AIM
15 pcs 500
To create Softwares 20 pcs 400 Gst
10 pcs 75
invoices at stock
5 pcs 1250
group & stock
20 pcs 450
item 20 pcs 40
10 pcs 200
100 pcs 10
Laptop 700 pcs 5
800 pcs 10
120 pcs 35
132 pcs 35
ALGORITHM
STEP 1: Click on start->all programs-> tally ERP 9
STEP 2: Create a company with regular details and click F11 button and Change the first
configuration from ‘’no” to ‘’yes”
STEP 3: Give GST related items as yes
STEP 4: Create ledger with the details and give ‘’yes” in all GST details
STEP 5: In gateway of tally select inventory info -> stock group-> create and GST option as
yes
STEP 6: Create units of measure such as no=numbers and create necessary stock items enter as
yes for GST option
STEP 7: In accounting voucher enter sales details and party names as ABC a/c & enter GST
@5%
STEP 8: At last press Alt +E and give yes
OUTPUT
RESULT
Gst invoices at stock group & stock item created.
EX No 12
SALES TO CONSUMERS
Sold frocks to Mr. Ramesh for Rs.2500000 (2500nos @ Rs.100)
Sold kurthis for cash for Rs.10000
Sold to Mr. Ramesh gowns for Rs.4000 (400nos @ Rs.5000)
AIM
To create a sales bill for consumers
ALGORITHM
STEP 1: Click on start->all programs-> tally ERP 9
STEP 2: Create a company with regular details and click F11 button and Change the first
configuration from ‘’no” to ‘’yes”
STEP 3: Give GST related items as yes
STEP 4: Create ledger with the details and give ‘’yes” in all GST details. In that party name
ledger choose consumer as registration type.
STEP 5: In gateway of tally select inventory info -> stock group-> create and GST option as
yes
STEP 6: Create units of measure such as no=numbers and create necessary stock items enter as
yes for GST option
STEP 7: In accounting voucher enter sales details and party names as KR enterprises & enter
GST @ 5%
STEP 8: At last press Alt +E and give yes
OUTPUT
RESULT
Thus the sales bill to consumers created
EX No 13
Sold frocks to A&B Ltd for Rs.25000
Sold kurthis for cash for Rs.10000 Sold to Embassy & CO
INTERSTATE SALES TO UNREGISTERED DEALERS
AIM
To create Interstate Sales to Unregistered Dealers
ALGORITHM
STEP 1: Click on start->all programs-> tally ERP 9
STEP 2: Create a company with regular details and click F11 button and Change the first
configuration from ‘’no” to ‘’yes”
STEP 3: Give GST related items as yes
STEP 4: Create ledger with the details and give ‘’yes” in all GST details. In that party name
ledger choose unregistered as registration type then enter their state as Karnataka
STEP 5: In gateway of tally select inventory info -> stock group-> create and GST option as
yes
STEP 6: Create units of measure such as no=numbers and create necessary stock items enter as
yes for GST option
STEP 7: In accounting voucher enter sales details and party names as A&B a/c & enter GST
@5%
STEP 8: At last press Alt +E and give yes
OUTPUT
RESULT
Thus, the sales bill to unregistered interstate dealer is created.
EX NO 14
Sold frocks to A&B Ltd for Rs.250000
Sold kurthis for cash for Rs.100500 Sold to Embassy & CO
AIM
To create Interstate Sales to Unregistered Dealers
ALGORITHM
STEP 1: Click on start->all programs-> tally ERP 9
STEP 2: Create a company with regular details and click F11 button and Change the first
configuration from ‘’no” to ‘’yes”
STEP 3: Give GST related items as yes
STEP 4: Create ledger with the details and give ‘’yes” in all GST details. In that party name
ledger choose regular as registration type.
STEP 5: In gateway of tally select inventory info -> stock group-> create and GST option as
yes
STEP 6: Create units of measure such as no=numbers and create necessary stock items enter as
yes for GST option
STEP 7: In accounting voucher enter sales details and party names as A&B a/c & enter GST
@5%
STEP 8: At last press Alt +E and give yes
STEP 9 : Select Display menu in gateway of tally -> Display->Statutory report -> GST->
GSTR1. The report will be opened.
STEP 10 :In that select Export GSTR1. The report will be generated for filing of GST returns.
STEP 11 : Press O for Open GST Portal then the Tamilnadu GST Portal will be opened. To give
necessary details and file the GST returns.
OUTPUT
RESULT
Thus, the GST returns filed.
