TALLY

Assignment - 1

Q - HOW TO CREATE COMPANY IN TALLY?

1. SELECT CREATE COMPANY.

2. NOW FILL THE DETAILS OF THE COMPANY.

3. Now press Enter.

Q - How to shut the company?

1. Select shut company

 2. Select company which you want to shut and press enter.

Q – How to alter the company?

1. Select alter

2. Now select company which you want to alter

3. Now alter the details and press enter.

HOW TO CREATE NEW GROUP ?

1. Select company info

2. Select groups

3. Select create

4. Fill the details.

5. Now press enter and check it in display.

How to delete or alter the group ?

1. Press A or click alter

2. Select the group

Press enter

3. Now press alt + d

 4. Press enter

Group deleted

How to create ledger ?

1. Select ledger.

2. Select create

3. Fill the details.

4. Press enter

5. And ledger is created

Check it in display

Assignment - 2

CREATE THE LEDGER

Q. Given below is the trail balance of previous period, create groups and ledgers and enter
opening trial balance.

Ans. Write the steps

TRAIL BALANCE AS
ON 31.03.2016
PARTICULARS DEBIT CREDIT
Bank Account 35,000.00
Deposit Account 40,000.00
Petty Cash 500.00
Sundry Debtors ( total) 57,300.00
Comp Care Systems 5,400.00
Data Link Technologies 26,000.00
Spectrum Computers 12,400.00
Supreme Computers 13,500.00
Buildings 75,000.00
Building Accumulated 8,000.00
depreciation
Office Equipment 4,500.00
Office Equipment 4,780.00
Accumulated depreciation
Sales Tax 13,600.00
Sundry creditor ( total) 156,000.00
Challenger system 65,650.00
Horizon Enterprises 44,750.00
Silver Plus computer 45,600.00
Mutual Trust Loan 50,000.00
Equity Capital 250,000.00
Profit & Loss Account 32,070.00
Difference in opening 286,150.00
balances
Total 518,950.00 518,950.00

--- Ledger
Trial balance

Balance sheet

Assignment - 3
Q . Create the following vouchers: -

DATE TRANSACTION DETAIL

2-4-2012 Paid Rs500 to Challenger System

2-4-2012 Bought office supplies for Rs150 with petty

cash

2-4-2012 Wages of Rs600 paid to employees by

cheque

5-4-2012 Banked a cheque for Rs5000 record from

Data Link Technologies

6-4-2012 Sold 1 IBM Pentium 4(computer sales) to

Spectrum Computers for Rs 24785

6-4-2012 Withdrew Rs 200 from Bank account for

petty cash

7-4-2012 Bought 1 LaserJet 1500(printer purchase)

from Silver Plus Computers on credit for Rs

8100
 Assignment – 4

Q : pass the following voucher entries.

Started business with cash 5000

Purchased furniture in cash 500

Opened a bank account 1000

Goods purchased in cash 2000

Goods sold in cash 1500

Goods purchased on credit from Roy 3000

Paid salary 800

Paid rent by cheque 500

Goods sold on credit to Bose 1800

Cash paid to Roy 2500

Cash collected from Bose 1500

Cash deposited in bank 1600

Cash withdrawn for household purposes 500

Cheque drawn for office purposes 1000

 Assignment - 5

Q. Pass the following voucher entries.

DATE TRANSACTIONS
APR. 12 Received a cheque of rs 50,000 from ram &sons
 manufacturers

APR. 13 Insurance paid by cheque rs 20,000

APR. 14 Sold goods to Nandini manufacturers rs 2,00,000

APR. 15 Nandini pays rs 2,00,000

APR. 16 Goods purchased for rs 3,00,000 from GG trader

sand paid through cheque

APR. 17 Purchased office furniture for rs 50,000 in cash

APR. 18 Goods costing rs 30,000 given as charity

APR. 19 Paid rs 50,000 towards rent cheque

APR. 20 Cash withdrawn for household purposes 20,000

APR. 21 Damaged goods returned to GG traders rs 50,000

APR. 30 Salaries paid rs 30,000 through cash

Jun. 6 Payment made to Sugriv for rs 1,00000 and

discount received forrs 10000
Jun. 7 Cash of rs 2,00,000 was received from star
tradersand discount allowed for rs 20,000
jun. 9 Running business was purchased by Rakesh
and the following assets and liabilities
details are shown below
Cash rs 50,000 furniture rs 25000 land
200000 creditors 70000 bank overdraft
20000 capital 66000

Ledger
 Trial balance

Day book
 Assignment - 6

Q: -create the following group.

STOCK GROUP UNDER CAN QUQNTITIES

OF ITEM ADDED
COMPUTERS PRIMARY YES
PRINTERS PRIMARY NO
PERIPHERIALS PRIMARY YES
ACCESSORIES PERIPHERIALS YES
COMPONENTS PERIPHERIALS YES

Alteration of stock group

Delete stock group

 Assignment - 7

Q. create the following stock categories.

NAME UNDER
National Primary
Hcl Primary
Ibm Primary
Hp Primary
Samsung Primary
Alter and delete the stock categories
 Q : Create the following unit of measure
TYPE SYMBOL FORMAL NO. OF
NAME DECIMAL
PLACES
Simple Nos Number of 0
Simple Box Boxes 0
Assignment - 8
Q: - create the following stock item under required groups.

STOCK PARTICULARS COST(RS) TOTAL TOTAL

QUANTITY VALUE
Computers
HCL PIV 17500 5 87500
IBM PIV 17100 4 68400
Peripherals
Accessories
CD ROM DISKA 100S 450 5 2250
DUST COVERS 35 10 350
Components
USB PEN DRIVE 16 GB 1250 10 12500
WIRELESS KEYBOARD 490 25 12250
WIRELESS MOUSE 250 20 5000
Printers
HP LASERJET 1010SRIES 8200 7 57400
SAMSUNG LASERJET 1500 8100 5 40500

Q . This is the transaction detail of the national traders

DATE TRANSACTIONS DETAILS

6-4-2012 Delivered HCL PIV from on site
to spectrum computers
7-4-2012 Received delivery of 2 HP
LaserJet 1010 Series from silver
plus computers and stored in on
site
9-4-2012 Transferred 2 HCL PIV from on
 site to warehouse
13-4-2012 Returned 1 HP LaserJet 1010
series to silver plus computers
16-4-2012 Spectrum computers returned 1
HCL PIV which was ordered
incorrectly
16-4-2012 Stock check reveals physical stock of 3
nos of Cd ROM disk 100s in on site
Godwon

Delevery note

Reciept note
Rejection out

Rejection in
Physical stock

Stock journal
Q14
Enter the following transactions of the Company in Tally and show various reports

1. All purchase and sales transactions of goods, Payment to creditors, and receipt from
debtors are done through Oriental Bank of Commerce

2. Any other payment and receipt is done through State Bank of India or cash

Balance Sheet as at 31-3-2014

Liabilities Amount Assets Amount
Capital 1900000 Land and Buildings 1600000
Reserves 700000 Plant and Machinery 500000
Profit and Loss 300000 Furniture 500000
Account
Secured loan 800000 Investment 100000
Debentures 1000000 Stock 1724800
Loan from 200000 Debtors 262000
Promoters
Provision for tax 250000 Bills Receivables 55000
Bills Payable 120000 State Bank of India 500000
Sundry Creditors 224600 Oriental Bank of 320000
Commerce
Salaries 35000 Cash in Hand 20000
outstanding
Rent outstanding 60000 Prepaid insurance 7800
5589600 5589600
 Ø
The company deals in the following stocks:

Name of the Group Quantity Rate (Rs) Opening Stock

Items Value
Cotton Shirts 100 pcs. 600 60000
Woollen Shirts 125 pcs. 1000 125000
Teri cot Shirts 108 pcs. 600 64800
Denim Trousers 400 pcs. 1500 600000
Woollen Trousers 100 pcs. 2500 250000
Cotton Trousers 500 pcs. 1250 625000
Total 1724800
Ø
The list of company debtors and creditors is as follows:

Debtors Bala Creditors Bala

nce nce
Due paya
ble
Pooja 4500 Shalu 2500
0 0
Prerna 8900 Sangeeta 3050
0 0
Pawan 5200 Sapna 6750
0 0
Pankaj 3000 Sandeep 4260
0 0
Prakash 4600 Siddharth 5900
0 0
Total 2620 Total 2246
00 00

Record the following transactions that took place during the April to March 2015.

S.No. Transactio Item Quantity Amount

n
1 Purchase Cotton 20 7000
from Shalu Shirts
2 Sale to Woollen 125 240000
Prerna Shirts
3 Sale to Denim 100 450000
Pankaj trousers
4 Paid to 5000
Shalu
5 Purchase Woollen 160 160000
from Shirts
Sangeeta
6 Purchase Cotton 200 200000
from Sapna Shirts
7 Purchased 25000
furniture

8 Paid 15600
insurance
Premium

9 Purchased
Land and
Building
from XY
Ltd for Rs.
10,00,000 .
To pay this
the company
borrowed
from bank a
loan of Rs.
6,00,000 and
issued fully
paid
debenture of
Rs. 4,00,000
to XY Ltd.
10 Sold all the 2,50,000
investment
11 Paid
1. Outstanding 20000
Salaries
2. Electricity 10000
3. Telephone 5000
4. Current 50000
Salaries
5. Rent 80000
(including
outstanding)
12 Outstanding
1. Total 50000
Salaries
2. Total rent 40000
outstanding
13 Charge
Depreciation
for the
period
1/4/2014 to
31/3/2015
on furniture
@15% p.a.
and
Machinery
@ 8% p.a.

You are
required
to:-
1. Create a company as per details given above
2. Create appropriate groups and Ledger Accounts.
3. Enter the transactions as given selecting appropriate voucher type.
4. Display the following statements
a. Trial Balance as on 31/3/2015
b. Profit and Loss Account as on 31/3/2015
c. Balance Sheet as on 31/3/2015
d. Cash Book
 e. Ratio Analysis

TRIAL BALANCE

Profit and loss account

Balance sheet

Ratio analysis