EX.
NO:1
COMPANY CREATION
QUERY:
Create a company by using tally in the name of ABC&co.
COMPANY CREATION
AIM:
To create a company using tally in the name of ABC&co.
ALGORITHM:
STEP1:To start with tally,select start programs Tally.
STEP2: To create a company the application for the creation of the company will appear at
Entering the tally.
STEP3: In the form type the mailing name and address of the company.
STEP4: In the next step fill up the strategy compliance of the state, telephone number.
STEP5: Enter the type in which account is prepared whether accounts only or accounts with
Inventory.
STEP6: After finishing all those, date for financial year must be stated.
STEP7: To maintain secret account tally use for tally vault password.
STEP8: After checking basic currency info like currency symbol, formal name& other
Account details to be specified.
STEP9: After giving all the details give yes to accept it or no to do the correction.
STEP10: Now the company is created.
RESULT:
Thus the company ABC it has been created.
EX.NO:2
LEDGER CREATION
QUERY:
Prepare necessary ledger accounts from the following details.
1) Business commenced with cash Rs.100000.
2) Purchase goods for cash Rs.25000.
3) Sold goods for cash Rs.50000.
4) Cash deposited into bank Rs.8000.
5) Bought furniture for cash Rs.7000.
6) Bought goods for credit from Ravi Rs.19000.
7) Sold goods on credit to Robert Rs.8000.
8) Paid salary by cash Rs. 5000.
LEDGER CREATION
AIM:
To create the appropriate ledger account for the company created.
ALGORITHM:
SINGLE LEDGER
STEP1:Open tally.
STEP2: Select “account information” from gateway of tally and select the “ledger”.
STEP3: Select, create from “single ledger”.
STEP4: A Seperate page will be appear for the ledger creation, give the necessary details.
STEP5:Select “display” option from the single ledger to display the ledger creation.
STEP6:Go back to the gateway of tally to do the necessary alteration in the ledger created.
MULTIPLE LEDGERS
STEP7:Select, create ledger from the multiple to display “all the ledger account”.
TRIAL BALANCE
STEP8:Select the display option from the gateway of tally.
STEP9:Select “Trial balance” from the display menu, in order to display the trial balance
ofLedger created.
RESULT:
Thus the company ledger has been created.
EX.NO:3
FINAL ACCOUNTS
QUERY:
Preparation of final accounts.
Prepare final accounts of Mr Raju as on 31st March 2015.
Purchase 70000
Cash in hand1000
Sales return 5000
Plant and machinery50000
Opening stock 20000
Sundry debtors60000
Discount allowed 2000
Cash at bank7000
Bank charge500
Capital56000
Salary4500
Sales150000
Wages5000
Purchase return4000
Freight inwards4000
Discount received1000
Freight outward1000
Sundry creditors30000
Rent and taxes5000
Advertising 6000
Adjustments: 1) Outstanding salary 5000
2) Prepaid rent 5000
3) Outstanding wages 5000
4) Closing stock 25000
FINAL ACCOUNTS
AIM:
To create a final account for the company created.
ALGORITHM:
STEP1:Open tally by start program tally.
STEP2: Select “account info” from “gateway of tally” and select ledger.
STEP3: Select “create” from multiple ledgers.
STEP4:Multiple ledger page opens enter the necessary details.
STEP5:Go back to the “gateway of tally” and select” accounting vouchers and click
Journal.
STEP6:Click alt+c, enter the adjustments.
STEP7:Accounting voucher for journal will opens, enter the details.
STEP8: Select display option from the “gateway of tally”.
STEP9: Select “trial balance” to display the trial balance of final accounts created.
STEP10:To view the trial balance in a detailed manner, click F1-Detailed.
RESULT:
Thus the final accounts have been created.
EX.NO:4
CREATION OF STOCK MAINTENANCE
QUERY:
Creation of stock maintenance.
STOCK GROUPS
1) Furniture.
2) Home appliances.
3) Medicines.
1) Furniture.
S . N o Items U n i t s ( n o ) R a t e
1 C h a i r 5 0 3 0 0
2 T a b l e 1 0 5 0 0
3 S o f a 5 5 0 0 0
2) Home appliances.
S . N o Items U n i t s ( n o ) R a t e
1 T V 5 2 0 0 0 0
2 R e f r i g e r a t o r 3 1 5 0 0 0
3 A i r c o n d i t i o n e r 4 3 0 0 0 0
3) Medicines.
S . N o Items U n i t s ( n o ) R a t e
1 C r o c i n 2 0 5
2 D o l o 6 5 0 1 0 7
3 D a r t 6 1 0
STOCK MAINTENANCE
AIM:
To prepare entries for various groups and various location of companies.
ALGORITHM:
STEP1:To start with tally, select start programs tally.
STEP2:To create a company select”alt+F3” and enter all the details with “accounts with
Inventory”.
STEP3:Selectinventory info stock group create.
STEP4:Then enter the stock name under primary.
STEP5:To create unit of measure, select inventory info unit of measure create, to
Givevarious types of units in stock item.
STEP6:Click F11-Inventory feature in that give “yes” to maintain multiple godowns and
Enter “yes” to accept it.
STEP7:Again in inventory info, select godownscreate, type the various places of
Godowns.
STEP8:Then select stock item create, type the stock items and enter the details.
STEP9:In gateway of tally, select stock summary to view the details of stock.
RESULT:
Thus the stock summary of the various stock items is successfully created.
EX.NO:5
CASH LESS TRANSACTION
QUERY:
Prepare bank account statements with creditors and debtors by passing and receiving.
Particulars Rs
Paid salary by cheque 6000
Received commission by cheque 700
Paid stationery by cheque 2000
Paid into bank by cheque 10000
Received cash from Mr.B 3000
Paid Mr. A by cheque 5000
Paid rent and taxes by cheque 1000
Received interest by cheque 5000
Received rent by cheque 1200
Paid for advertisement by cheque 800
CASH LESS TRANSACTION
AIM:
To prepare bank account statement with debtors and creditors by passing and receiving
cheques using cash less transaction.
ALGORITHM:
STEP1:To start with tally and create a company.
STEP2:Enter all the details with ‘accounts with inventory”.
STEP3: Go to the gateway of tally and create single ledger.
STEP4: Enter the necessary details in the ledger creation page and go to the “gateway of
Tally” and open accounting vouchers.
STEP5: Go to the gateway of tally and click “display” trial balance and daybook. Click F1-
To View in detailed manner.
RESULT:
Thus the bank account statements have been prepared using cash less transaction.
EX.NO:6
EXPIRED GOODS
QUERY:
Prepare the statement of expired dates for goods from the following details.
FMCG PRODUCTS:
S . N o I t e m Unit Rate
1 c h o c o l a t e 1 5 0 1 5
2 b i s c u i t 2 0 0 2 0
3 m o b i l e 1 0 7 0 0 0
4 Stationery item 1 0 0 1 0
MEDICINES:
S . N o I t e m Unit Rate
1 c r o c i n 1 0 5
2 D o l o 6 5 0 5 0 1 2
3 d a r t 7 0 2 0
4 c a l p o l 8 0 8
EXPIRED GOODS
AIM:
To create expiry date for the FMCG products and medicines.
ALGORITHM:
STEP1: To start with tally, select start program tally.
STEP2: To create a company, select”alt+F3” Enter all the details with”accounts with
Inventory”.
STEP3: Select Inventory info stock group create.
STEP4:To create unit of measure, select Inventory info unit of measure create to
Give various types of unit in stock item.
STEP5: To create godown, go to the inventory info select godown create, type the
Various places of godowns.
STEP6: To create stock item, select stock item create, press F11 and activate the
Following in inventory feature. Maintain stock category-yes.
Maintain batch wise-yes.
Set expiry for batches-yes.
STEP7: While creating stock item, maintain in batch?-yes, give the opening balance.
STEP8:Next, itwill move to another screen in that, give manufacturing date, below the
Opening date of company, expiry dateand accept.
STEP9: To view the effect of transaction, select display inventory books ageing
Analysis and view the result.
RESULT:
Thus the statement of goods expired has been created successfully.
EX.NO:7
BILL WISE STATEMENT
QUERY:
Preparation of bill Wise statement for the following transactions in the books of X ltd for
the year ended 31.03.2016.
The following stock item as on 1st April 2016.
I t e m s U n i t s P e r u n i t
K i d ’ s w e a r 7 5 0 1 5 0 0
M e n ’ s w e a r 2 5 0 7 0 0
S a r e e 1 0 0 0 5 0 0
C h u d i 3 0 0 9 5 0
Credit purchase from Anjali collections.
I t e m s U n i t s P e r u n i t
C h u d i 2 5 0 1 0 0 0
K i d ’ s w e a r 5 0 9 0
Credit sales made to Venkatesh.
I t e m s U n i t s P e r u n i t
S a r e e 2 5 0 7 0 0
C h u d i 4 0 0 1 8 0 0
Credit purchase from Shree Devi textile.
I t e m s U n i t s P e r u n i t
S a r e e 3 0 0 5 5 0
M e n ’ s w e a r 1 0 0 1 0 0 0
Credit sale made to Anand.
I t e m s U n i t s P e r u n i t
K i d ’ s w e a r 3 0 0 9 5 0
M e n ’ s w e a r 2 5 0 1 2 0 0
1. Credit period allowed for suppliers for 30 days.
2. Credit period allowed to customers for 30 days.
3. Payment to Anjali collection Rs 17500.
4. Payment to Shree Devi textile Rs 75000.
5. Cash received from venkateshRs 50000.
6. Cash received from AnandRs 98000.
The following expenses were incurred,
P a r t i c u l a r s R s
R e n t 2 5 0 0
S a l a r i e s 8 0 0 0 0
W a g e s 5 0 0 0 0
BILL WISE STATEMENT
AIM:
To create a bill wise statement for the sundry debtors business dealings with sale set of
debtors.
ALGORITHM:
STEP1:To start with tally, select start program tally.
STEP2:To create a company select”alt+f3” and enter all thedetails with”accounts with
Inventory”.
STEP3:to create ledger, select accounts info ledger single ledger or multiple ledgers
Create.
STEP4:Post the ledger under the account without amount.
STEP5:By using display option create items and click “alter” option in single ledger and
Make necessary corrections.
STEP6:In the gateway of tally, click accounting vouchers. Post the same related accounts
With amount.
STEP7:Complete all the voucher entry with the help of amount.
STEP8:Go to gateway of tally, click table bill wise statement or displaying.
RESULT:
Thus the bill wise statement is completed.
EX.NO:8
PAY ROLL STATEMENT
QUERY:
To determine the basis pay, DA, PF, Overtime of an employee.
S . n o Employee name Employee group Basic pay H R A D A
1 A n i t a Accounts department 2 0 0 0 0 5 0 0 0 3 0 0 0
2 A n a n d Finance department 1 2 5 0 0 2 5 0 0 1 0 0 0
3 V a r u n Marketing department 2 5 0 0 0 6 0 0 0 1 5 0 0
ADDITIONAL INFORMATION:
1. All employees are eligible for PF Rs.1000& ESI Rs.500.
2. All employees are deducted with canteen expenses Rs.100.
3. All employees have done overtime and earned approximately Rs.2300.
PAY ROLL STATEMENT
AIM:
To determine the basic pay, DA, PF, OT of an employee.
ALGORITHM:
STEP1: To start with tally.
STEP2: Create a company with, “accounts with inventory”.
STEP3: start with gateway of Tally, click f11-features and fill details.
STEP4: In gateway of tally, click payroll info and enter details in units, employee
Group, employees, pay heads.
STEP5: Enter the additional info in pay heads.
STEP6: Enter the details of each employee in payroll voucher.
Step7: Go back to gateway of tally and click display payroll report statement
Of payroll pay sheet.
RESULT:
Thus the payroll statement of each employee is created successfully.
