TALLY WORK SHEETS

Stock item creation

Stock item Stock Stock category unit qty rate value
group
I phone 15 Ios Mobile device Nos 10 80000 800000
devices
Samsung s23 Android Mobile device Nos 15 60000 600000
One plus Android Mobile device Nos 20 50000 110000
Basmati rice Joker Grocery Kg 100 90 90000
Wheat flour Atta Grocery kg 150 35 5250
Sugar Grocery Kg 200 40 8000
t- shirt Guess Means wear Nos 45 150 6750

Jeans Guess Means wear Nos 30 450 13500

Shirt Adidas Mans wear Nos 25 600 15000
Dell Inspiron Laptops i5 Processor Nos 10 45000 450000
15
HP Pavilion 14 Laptops i5 Processor Nos 5 50000 250000
Parle-G FMCG Biscuits box 25 300 7500
Philips LED Electricals Lighting Box 40 600 24000
bulb
Cello ball pen Cello Stationery Box 30 250 7500
Nirma Nirma Detergent Box 50 700 35000
washing
powder
Asian pints Paints Emulsion Box 12 2000 24000
Coca cola Beverages Soft drinks Box 15 480 7200

Stock item creation with alternative units

Stock item Stock Stock Unit/ alt. qty rate value
group category unit
Dell Inspiron Laptops i5 Processor NOS 15 NOS 45000 675000
Laptop
 I phone 14 Ios Mobile Box / Pcs 5 boxes 1000000 5000000
devices device (1 Box =
10 Pcs)
HP Ink Cartridge Ink Computer Pcs / Dozen 2 dozen 1,200 per 2400
680 Cartridges Consumables (1 dozen = Dozen
12 Pcs)
Amul Butter Amul Dairy Kg / Grams 10 Kg 420/kg 4200
Products (1 Kg =
1000 g)
A4 Printing Paper Stationery Ream / 8 Reams 150 per 1200
paper Sheets (1 Ream
Ream =
500
Sheets)
Bourbon Britannia Biscuit Box / Pcs (1 10 Boxes 800 8,000
Box = 20
Pcs)
Logitech Mouse Logitech Computer Box / Pcs (1 4 boxes 1000 4000
M235 Accessories Box = 25
Pcs)
Stock item creation with purchase price and selling
price
Stock item Stock Stock Unit Opening Purchase Selling
group category qty price price
Dell Laptops i5 Processor Nos 15 45000 55000
Inspiron
Laptop
I phone 14 Ios devices Mobile device Nos 20 75000 85000
Samsung 32 Samsung Television Nos 15 25000 30000
led tv
Hp laser Hp Computer Nos 30 10000 12500
printer accessories
Amul butter Amul Dairy KG 50 350 400
products
A4 Printing Paper Stationery Ream 100 250 300
paper
Bourbon Britannia Biscuit BOX 40 20 25
LG. 1.5 TON LG AIR NOS 10 35000 40000
AC CONDITIONER
NOKIA FEATURE MOBILE NOS 100 2000 2500
PHONE DEVICE
MAGGI NESTLE INSTANT PCS 150 20 30
NOODLES NOODLES
Logitech Logitech Computer PCS 200 500 650
Mouse Accessories
M235
 PURCHASE AND SALES
ITEM GROUP P. PRICE S. PRICE
LUX SOAP 25 30
SANDOOR SOAP 20 22

1/4/2024 RAVI COMMENCED A BUSINESS WITH RS. 300000

2/4/2024 CASH DEPOSITED INTO CANARA BANK RS. 50000
3/4/2025 PURCHASE 500 NOS LUX FROM DEVI TRADERS BILL NO. 707
4/4/2024 PAID RS. 2300 TO DEVI TRADERS BILL NO.707
5/4/2024 PURCHASE 1000 NOS LUX BY CASH FROM ROYAL DELARS BILL
NO. 007
6/4/2024 PURCHASE 20 NOSE LUX, 15 NOS SANDOOR BY CANARA CHEQUE
FROM DEVI TRADERS
7/4/2024 SOLD 350 NOS LUX, 8 NOS SANOOD TO JENATHA SUPER MARKET
ON BILL NO 54655
11/4/2024 SOLD 10 NOS LUX FOR CASH TO ANAND BILL NO 21142
12/4/2024 SOLD 25 NOS LUX TO JAMJOM SUPER MARKET BILL NO. 23654
20/4/2024 CASH RACEIVED RS-4000 FROM JENATHA SUPER MARKET ON BILL
NO. 54655
22/4/2024 SOLD 5 SANDOOR TO JAMJOM SUPER MAREKET BILL NO M65565
 PURCHASE RETURN & SALES RETURN

ITEM GROUP CATEGORY UNIT P. PRICE S. PRICE

PIGEON DIITAL PIGEON AIR FRYER NOS 4000 4500
AIR FRYER

1/4/2025 BUSSINESS STRTED WITH ₹ 8,00,000

2/4/2025 PURCHASE 10 NOS AIR FRYER FOR CASH FROM MR. DEEPAK
BILL NO. 001
3/4/2025 RETURNED 4 NOS AIR FRYER FOR CASH DUE TO DAMAGE TOWARDS BILL
NO.001
3/4/2025 SOLD 6 NOS AIR FRYER FOR CASH BILL NO.111
4/4/2025 SALES RETURN 2 NOS AIR FRYER FOR CASH BILL NO..111
5/4/2025 CASH DEPOSITED INTO CANARA BANK ₹ 1,00,000
6/4/2025 PURCHASE 12 NOS AIR FRYER BY CHEQUE FROM OREX LTD BILL NO. 002
6/4/2025 PURCHASE 10 NOS AIR FRYER FROM ROYAL TRADER BILL NO. 003
7/4/2025 PURCHASE RETURN AIR FRYER 7 NOS BY CHEQUE BILL NO.002
7/4/2025 SOLD 5 NOS AIR FRYER BY CHEQUE BILL NO. 112
7/4/2025 SOLD 5 NOS AIR FRYER TO TB COLLECTIONS BILL NO. 113
10/4/2025 RETURNED 3 NOS AIR FRYER BY CHEQUE AGAINST BILL NO .112
10/4/2025 RETURNED 4 NOS AIR FRYER BY ROYAL TRADER AGAINST BILL NO. 003
13/4/2025 SALES RETURNED FROM TB COLLECTIONS 2 NNOS AIR FRYER
NET PROFIT – 4500

B/S- 8,28,500

CASH-6,94,000

BANK-89000
 GODOWN AND TRANSFER VOUCHER
STOCK ITEM GROUP UNIT ALT. UNIT P. PRICE S. PRICE

Bourbon Britannia BOX 50 PKT/BOX 10 15

CREATE THE FOLLOWING GODOWNS

• PURCHASE DEPT
• SALES DEPT
1/4/2025 BUSINESS STARTED WITH₹ 6,00,000
2/4/2025 PURCHASE 30 BOX BOURBON FOR CASH BILL N. 111 TO PRCHASE DEPT
2/4/2025 TRANSFER 100 PKT BOURBON FROM PURCHASE DEPT TO SALES DEPT

3/4/2025 PURCHASE 20 BOX BOURBON FROM BRITANNIA LTD BILL NO.112 PURCHASE DEPT

4/4/2025 TRANSFFERD ALL PRODUCT TO SALES DEPT FROM EXISTING GODOWN

5/4/2025 SOLD 25 BOX BOURBON FOR CASH BILL NO. 0001 FROM SALES DEPT

6/4/2025 PURCHASE 10 BOX BOURBON FROM ROYAL TRADERS BILL NO. 113 TO PURCHASE DEPT

7/4/2025 RETURNERND 10 BOX BOURBONFROM SALES DEPT TO PURCHASE DEPT

8/4/2025 SOLD BOURBON10 BOX TO MAHESH TRADER BILL NO. 0002 FROM SALES DEPT

10/4/2025 SENT 2 PKT AS SAMPL FROM STOCK ROOM

11/4/2025 CASH DEPOSITED IN TO FEDERAL BANK ₹1,00,000

12/4/2025 RENT PAID ₹1,000

13/4/2025 COMMISSION RECEIVED₹1,000

EVALUATE THE GODOWN REPORTS

 PURCHASE ORDER AND SALES ORDER
ITEM GROUP UNIT P. PRICE S. PRICE
DIARY TRIVENY NOS 50 55

1/4/2025 CAPITAL INVESTED BY BUSINESS ₹ 1,50,000

2/4/2025 GIVE PUCHASE ORDER TO BOOK MART 5000 NOS DIARY BOOK ORDER NO. AB12

1/5/2025 PURCHASE ALL PRODUCT AS PER THE ORDR NO. AB12 AND BILL NO. 001

2/5/2025 GIVE PURCHASE ORDER TO EDUMART PVT LTD DAIRY BOOK 5000 NOS ON ORDER NO.
AB13

1/6/2025 RACEIVED 3000 NO DAIRY AGAAINST THE ORDER NO. AB13 BILL NO. 002

15/6/2025 GIVE PURCHASE ORDER TO BOOK MART FOR DAIRY 5000 ON ORDER AB14

15/6/2025 PURCHASE BALANCE DAIRY FROM EDUMART ON ORDER NO. AB13

20/4/2025 PURCHASE FROM BOOK MART AS PER ORDER NO AB14 DAIRY

1/7/2025 RECEIVE SALES ORDER FROM AKSHARA PRINTERS 2500 NOS DAIRY ON ORDER NO. SO/11
DUE ON 12/7/2025

10/7/2025 SOLD ALL PRODUCTS AS PER ORDER NO SO/11 TO AKSHARA PRINTERS BILL NO. 111

11/7/2025 RECEIVED SALES ORDER FROM ORBIT BOOK STALL FOR 8000 NOS DAIRY ORDER NO SO/12

30/7/2025 SOLD TO ORBIT BOOKS STALL 5000 NOS DAIRY AS PER ORDER NN. SO/12 BILL NO .56896

2/8/2025 RECEIVED SALES ORDER FROM NOVAL BOOK STALL FOR 500 NOS ON DAIRY ORDER NO
SO/13

5/8/2025 SOLD 1500 NOS DAIRY TO GLAXY COILLECTION AS PER ORDER NO SO/13 BILL NO 45623
 RECEIPT NOTE & DELIVERY NOTE
ITEM GROUP UNIT P. PRICE S. PRICE
BIKE PULSER NOS 60000 65000

1/4/2025 CAPITAL INTRODUCED BY MR. ARUN ₹ 5,00,000

2/4/2025 GIVE ORDER TO MAHINDRA LTD FOR 50 NOS BIKE ORDER NO PO/145
5/4/2025 PURCHASE THE ORDERED BIKE FROM MAHINDRA LTD BILL NO. 20001
(TRACKING NO. 250)
8/4/2025 RECEIVED BIKE FROM MAHINDRA LTD AS PER (TRACKING NO. 250)
8/4/2025 PURCHASE RETURNED 10 NOS BIKE TO MAHINDRA LTD
12/4/2025 GET ORDER FROM SPEED WORLD MOTORS FOR 30NOS BIKE ORDER NO
SO/45
14/4/2025 SOLD BIKE TO SPEED WORLD MOTORS AS PER THE ORDE NO SO/45 BILL NO-
9001(TRACKING NO- 889)
16/4/2025 DELIVERD TO SPEED WORLD MOTORS AS PER (TRACKING NO- 889)
16/4/2025 SALES RETURNED FROM SPEED WORLD MOTORS 2 NOS BIKE DUE TO
DAMAGE
20/4/2025 CASH PAID TO MAHINDRA LTD
24/4/2025 RECEIVED CASH FROM SPEED WORLD MOTORS
 REJECTION IN & REJECTION OUT
ITEM GROUP UNIT P. PRICE S. PRICE
BIKE PULSER NOS 65000 70000

1/4/2023 MR. ANIL KUMAR INTRODUCED CAPITAL INTO BUSINESS 7,50,000

2/4/2023 PURCHASE 50 NOS BIKE FROM DELHI IMPORTERS BILL NO. 40001
(TRACKING NO.777)
6/4/2023 RECEIVED BIKE FROM DELHI IMPORTERS AS PER (TRACKING NO 777)
8/4/2023 PURCHASE RETURNED 10 NOS BIKE TO DELHI IMPORTERS BILL NO. 40001
(TRACKING NO778)
12/4/2023 REACHED THE RETURNED BIKE TO DELHI IMPORTERS AS PER (TRACKING
NO. 778)
12/4/2023 SOLD 40 NOS BIKE TO SPEED WORLD MOTORS BILL NO-3005 (TRACKING
NO.889)
14/4/2023 DELIVERED TO SPEED WORLD MOTORS (TRACKING NO.889)
15/4/2023 RETURNED 2 NOS BIKE BY SPEED WORLD MOTORS DUE TO DAMAGE BILL
NO.456(TRACKING NO 900)
18/4/2023 REACHED SALES RETUNED BIKE INTO BUSINESS AS PER (TRACKING
NO.900)
19/4/2023 CASH PAID TO DELHI IMPORTERS BY ₹ 1,00,000
20/4/2023 RECEIVED RS. 5,00,000 FROM SPEED WORLD MOTORS AS CASH
 TP STORES

1/4/2014
Mr. Vinod commenced business with cash ₹ 5,00,000
Brought building Rs. 1,50,000. Purchase furniture Rs. 25000
Brought computer from computer center Rs. 23000
4/4/2014
Opened bank account in SBT Calicut Rs. 50,000
Advertisement exp- rs.5000

Name of item Std. Rate S. Price

Rice 10.50 13.50
Sugar 14 15.50
Wheat 9 11

5/4/2014
Following goods are ordered from novelty (P.O -p12)
Name of item Qty
Rice 500kg
Sugar 400kg
Wheat 350kg

6/4/2014
Received goods from novelty
Transportation charge paid ₹ 400, freight& cooly ₹ 100, stationery item ₹ 150, salary
advance paid ₹ 2000, wage to the workers ₹ 250
7/4/2014
Following goods are sold to Arun Kumar

Name of item Qty

Rice 50kg
 Sugar 125kg
Wheat 75kg

Cash paid to novelty Rs 7500, sold rice to Dileep 30 kg for cash rs-405, travelling expenses
paid Rs. 75, tea expenses paid rs.30, postage charges paid Rs. 20, wheat sold for cash Rs.
1100, cheque received from Arun Kumar Rs. 2000, advertisement exp- 500
10/4/2014
Balance amount paid to novelty, sugar sold to Anand 50kg cash received only 10 kg,
travelling advance paid 500, take a loan from KSFE Rs. 30000, 100kg sold to nova agencies
50% amount received by cheque
15/4/20214
Sold good to Kripa store but not reached there (tacking no 125)

Name of item Qty

Sugar 75kg
Wheat 150kg

Travelling exp paid Rs. 750 and advance adjusted, tea exp paid rs.30, cleaning charge paid
Rs. 50
18/4/2014
Good delivered to Kripa store as per (tacking no 125)

20/5/2014

Name of item Std. Rate S. Price

Rice 10. 11.50
Sugar 15 16
Wheat 9.50 12
Lux 12/NOS 13/NOS

Following goods purchased from Sameera store (tracking no 987)

Name of item Qty

 Lux 100 NOS
Wheat 50kg

Cleaning charge Rs. 50, tea expenses paid Rs. 30

24/4/2014
Receive goods from Sameera store as per (tracking no 987) bill no.4885, transportation
charge Rs. 500, fright & cooly - 50
25/4/2014
Salary paid Rs. 2500, wage paid 3600, cleaning charge Rs- 50, tea exp-30, lux sold 15 NOS
for cash and discount allowed to them
Proprietor withdraw cash for personal use rs-10000, payment made by cheque rs.1075 to
Sameera store, telephone bill paid Rs. 1500
30/4/2024
Electricity charge paid Rs. 2000, salary paid 4000 advances adjusted to it
Wage paid Rs. 1000, adv. exp Rs. 750
 PRICE LIST
Rohini electronic, Trivandrum is a manufacturing company. produce CFL and
Chokes. They have two types of customers Wholesalers and Retailers. They
have 2000 NOS CFL ₹140 & 2000 NOS Chokes ₹ 120.

Wholesaler
Price of CFL Price of Chokes discount
Up to 100 180 160 2%
100-250 160 140 2%
250-ABOVE 140 120 2%

Retailers
Price of CFL Price of Chokes discount
Up to 100 200 170 2%
100-250 180 150 2%
250-ABOVE 160 135 2%
TRANSACTIONS
1/4/2024 SOLD 200 NOS CFL AND 160 CHOKES TO BISMI GROUP(WHOLESALER)
2/4/2024 SOLD 45 CFL AND 150 CHOKES TO ANIL (Retailer)
4/4/2024 SOLD 350 CFL TOAKASH (Retailer)
5/4/2024 SOLD 160 CHOKES AND 99 CFL TO KAMAL GROUP(WHOLESALER)
6/4/2024 SOLD 180 CFL TO BISMI GROUP
8/4/2024 SOLD 250 CHOKES AND 157 CFL TO KAMAL GROUP

10/4/2024 SOLD 120 CFL AND 55 CHOKES TO ARATHI (Retailer)

 MULTI CURRENCY
Currency Symbol Std. rate Buying rate Selling rate
Dollar $ 85.50 83.28 87.05
Pound £ 113.75 111.51 116.9
Euro € 97.35 95.96 100.94
Yen ¥ 0.60 0.39 7.4189

1/4/2024 following items purchase from Samsung group from Germany (€)

100 no’s Iron box amount of 20

150 Nos tv amount of 170

150 Nos mixer granter 125

50 Micro-oven amounts of 130

8/4/2024 50 double door regenerator amounts of 490

50Nos top load washing machine amount of 290

100 Nos air conditioner amount of 300

11/4/2024 sold following goods AKG group, Calicut

50 Nos iron box ₹1300

75 Nos tv ₹18000

67 mixture grainter₹13500

14/4/2024 sold goods to say traders, oedipal

10 Nos Micro oven ₹ 14000

10Nos top load machining machine ₹30000

5 Nos AC ₹31000

CURRENCY SYMBOL SHORT KEYS DECIMAL PORTION

DOLLAR $ Shift + 4 Cent
Pound £ Alt + 156 Penny
Yen ¥ Alt + 157 Cent
Euro € Alt + 0128 cent
 Batch No, Manufacturing and Expiry Date
Problem 1
ITEM NAME TOTAL QTY BATCH MFG EXPIRY QTY RATE
NO DATE DATE
Crosin 1000 Cr 1 1st 2 YEARS 500 5
APRIL
Cr 2 1ST 1 YEAR 500 5.50
AUG

Brufen 1200 Br 1 2nd 2 years 400 5.20

April
Br 2 2nd 1 year 600 5.25
June
Br 3 1st 2 years 200 6
July

Anacin 800 An 1 1st 2 years 500 8

April
An 2 1st 1 year and 300 8.50
aug 6 months

D ‘ cold 800 1st dec 1st 2 years 300 10

may
2nd dec 31st 2 YEARS 450 11
Aug

PURCHASE ALL ITEMS 200 QTY

Problem 2
A. Stock item setting
Item Group p. price s. price Unit
Fair lovely Face cream 50 58 Botl
Gilalite Shaving cream 80 95 botl

B. Pass the following transaction

1. Purchase 50 bot fair lovely from fashion cosmetic center on bill no :321
Batch Mfg date Expiry date
A1 01/04/20 01/20/20

2. Purchase 30 bot fair lovely from fashion cosmetic center on bill no :879
Batch Mfg date Expiry date
A2 01/06/20 01/12/25

3. sold 40 bot fair lovely to benzy beauty parlor bill no: 4213 [ batch NO: A1]
4. Purchase 10 bot fair lovely and 38 bot gillete from Apple beauty World bill
no: 1242

Fair lovely Gilalite

Batch Mfg date Expiry date Batch Mfg date Expiry date
A3 01/06/20 01/04/22 B1 01/06/20 01/11/25
5. Sold 15 bot gillete to benzy beauty parlor on [batch no: b1] and fair lovely 45 bot [ on all
batch respectively]
6. Show closing stock report by considering expiry dates
 BILL OF MATERIAL
ITEM GROUP P. PRICE UNIT
MONITOR R.M 8000 NOS
CPU R.M 10000 NOS
KEYBOARD R.M 600 NOS
SPEAKER R.M 300 NOS
WEB CAM R.M 250 NOS
MOUSE R.M 200 NOS
COMPUTER F. P ……. NOS

NOTE: - FOR PRODUCING ONE COMPUTER THE FOLLOWING MATERIALS ARE WANTED (BILL OF
MATERIAL)

CPU- 1, MONITOR- 1, KEYBOARED- 1, SPEAKER- 2, WE CAM- 1, MOUSE- 1

1/4/2024 PURRCHASE 5 NOS CPU, 5 NOS MONITOR, 5 NOS KEYBOARED, 5

NOS MOUSE, 10 NOS SPEAKER, 5 NOS WEB CAM FROM RP GROUP
BILL NO: 00215
2/4/2024 PRODUCE 4 NOS COMPUTER (ADDITIONAL COST: WAGE 3000,
FACTORY RENT 10%)
3/4/2024 SOLD 4 NOS COMPUTER TO IT WORLD CO ( 20% PROFIT ADD ON
COST)
4/4/2024 CASH RECEIVED FROM IT WORLDRS. 20000
 Cost center & cost category
Cost category Cost center
Students April
Amusement adults 1.
Senior citizen
Restaurant
Refreshment
hotel
Chinese
Gift house
Indian
Booth no.1
Telephone booth
Booth no. 2
Commenced business with ₹30,00,000 as partnership Mr. Bijoy ₹ 20,00,000and Mr. Selin
₹10,00,000

April 2. Opened a current account at SBT by depositing 25,00,000

April 3. Purchase a computer & generator for ₹ 30000& ₹ 40000as per bill no. 83&125 by cash

April 4. Purchased land &building worth 20,00,000 by cheque.

Purchased delivery van from popular automobiles as per bill no. 1255 for 27500 credit period 15
days.

Purchase furniture as per bill no. 2858 from Travancore furniture mart ₹125000 credit period 15
days

April 12. Income from amusement collected ₹14400

Cost category Cost center Amount

Students 8200
Amusement Adults 4200
Senior citizen 2000
April 13. Imported machinery from Francis, USA $ 2000 (Rate of Exchange 1$/82.30)

April 15. Income collected from refreshment for the week ₹10000

Cost category Cost center Amount

Restaurant 6300
Refreshment
Hotel 3700
April 16. Paid to Travancore furniture mart ₹125000 as against their bill no. 2858by cheque no. 877896

April 17. Income collected from gift house for the period ₹ 7500

Cost category Cost center Amount

Indian 2300
Gift house
Chinese 3700
April 20. Paid to popular automobiles ₹27500 as against their bill no. 1255 by cheque

April 22. Settled the a/c of Francis of USA $ 2000 (rate of exchange -1$/42.20)
April 25. Income collected from telephone booth for the period Rs. 6000

Cost category Cost center Amount

Booth1 4200
Telephone booth
Booth2 3700
April 26. Park exp as per vouchers Rs 7500 allocated to cost centers student, adults, senior citizen in their
ratio 2:2:1 under cost category amusement

April 27. Purchase refreshment items 15000 allocated to cost center restaurant & hotel in the ratio of 3:2
under cost category refreshment

April 30. Paid telephone charge to BSNL as per bill no. 167 Rs. 3000 allocated to cost center booth 1&
booth2 equally.
 Style fitters
Liabilities Amount Asset Amount
Capital 265186 Fixed asset
BANK O/D 200000 Machinery 225000
BILLS PAYABLE 40000 Building 150000
Furniture and fittings 20000
SUNDERY CREDITORS
DEEPAK SPINNER 16200 Current asset
ARUN 22860 39060 Closing stock 36846
Cash 2870
WAGE OUTSTANDING 1000 SBT bank 1,00,000
SALARY OUTSTANDING 1000
SUNDRY DEBTORS
REMA TETILES 8260
JANATHA TEXTILES 3270 11530

546246 546246

• CREDIT PURCHASE FROM DEEPAK SPINNER AS PER THEIR BILL NO 1067 DATED Rs. 42000 ALLOCATED
RHIS PURCHASE TO THE FOLLOWING COST CENTER
TAILORING -18200

LEADIES WEAR- 11300

OUT FILLING-12500
• ELECTRICITY CHARGE Rs. 10000 PAID BY CHEQUE SBT TO BE ALLOCATED IN THE RATIO OF 2:2:1
• PAID TI DEEPAK SPINNER Rs. 16200 BY CHEQUE
• PAID ADVERTESMENT Rs.12000 AND EQUALLY ALLOCATED TO ALL DEPARTMENT
• IMPORTED MACHINERY FROM FEDNIC OF ENGLAND FOR €100 AS PER INVOIVE NO 183(RATE OF
EXCHANGE 52.20)
• CASH SALEW FOR THE MONTH OF APRIL Rs. 56000
TAILORING -23400
LEADIES WEAR- 18200
OUT FILLING-14400
• CREDIOT SALE TO RFEMA TEX Rs. 16000
TAILORING -6000

LEADIES WEAR- 5000 OUT FILLING-5000PAID

• PAID RENT Rs. 1500 TO BE ALLOCATED EQUALLY TO EACH DEPARTMENT

The Following Would Be Recording in Journal Using Double Entry System. Do The
Posting Process from Journal Entries and Prepare the Trial Balance, Trading A/C, Profit
& Loss A/C and Balance Sheet and cost canter In the Books Of M/S. EVEREST LIT For
the Following Year 2009 To 2010.
Particular Dr Cr

Capital 500000

Cash 200000

Furniture 50000

Bank loan 200000

Indian Bank 150000

Bank O/d 150000

Machinery 150000

Motor car 75000

Computer 125000

Investment 200000

Salary due 50000

Sundry creditors:
M/s. Reliance (P) ltd was Rs.150000 Bill no:29

Sundry debtors:
M/s. Hindustan Ltd was Rs.60000 bill no:30

Particular Dr Cr

M/s. Unilever Ltd was Rs.40000 bill no: 31

 Cost category and cost center:

Mr. Flaming (cost category) Ms. Familia (cost category)

Basic pay Basic pay (F)

DA DA (F)

TA HRA (F)

Medical allowance Conveyance allowance (F)

Food allowance Medical allowance (F)

Mr. Prince (cost category) Income and expenditure (cost category)

Basic pay(p) Telephone charges

DA(p) Postage

HRA (p) Interest received

TA(p) Wages

Food allowance(p) Fright charges

Medical allowance (P) Commission received

 TRANSACTION DURING THE PERIOD:

1. Telephone charges paid Rs.1000

2. Amount paid to Mr. Reliance Ltd was Rs.50000-part settlement

3. Commission received Rs. 10000

4. Goods purchased from Mr. Dolphin ltd was Rs.120000 bill no:28
5. Salary paid to Ms. Familia for the following

Basic pay (F) Rs.6000

DA (F) Rs.2000

HRA (F) Rs.500

Conveyance allowance (F) Rs.700

Medical allowance (F) Rs.500

6. Paid postage Rs.1250

7. Goods sold to Rs. Ramani was Rs. 150000 bill no:75

8. Interest received Rs.8000

9. Salary paid to Mr. Flaming for the following:

Basic pay Rs.5000

DA Rs.2500

HRA Rs.1000

Medical allowance Rs.500

Food allowance Rs.300

10. Depreciation of machinery @ 10%

11. Interest on capital @ 6%

12. Withdraw from personal use Rs.5000

13. With draw from bank Rs.20000

14. Paid wages and fright charges Rs.700, Rs.350

15. Salary paid to Ms. Prince for the following:

Basic pay(p) Rs.7000

DA(p) Rs.3000

HRA (p) Rs.1500

TA(p) Rs.600

Food allowance(p) Rs.500

Medical allowance (P) Rs.400

16. Motorcar sold on cash Rs.70000 and balance amount was depreciated

17. Dividend received Rs.30000

 Sales rep
Item Group p. price s. price Unit
Vivo Mobile phone 12000 15000 Nos

Cost category Sales rep General sale

Aravind Direct sale
Cost center Amal
Revathi

1/4/2024 Kamal start business with cash Rs.5,00,000

2/4/2024 purchase 300 Nos VIVO from Super World Bill No.
A/999
3/4/2024 cash paid to Super World Rs. 3,50,000
4/4/2024 sold 30nos VIVO to Raju co: for cash bill
no.991(sales rep Aravind)
5/4/2024 sold 45 Nos VIVO by SBT cheque bill no 992(sales
rep: Amal)
6/4/2024 sold 10Nos VIVO to Mobile World bill no. 993(direct
sale)
7/4/2024 sold 50 Nos VIVO for cash bill no994 (sales rep:
Revathi)
8/4/2024 sold 15 Nos VIVO to mobile world bill no 995(sales
rep: Aravind)
9/4/2024 sold 5 Nos VIVO for cash bill no 996(sales rep Amal)
10/4/2024 sales returned 2 nos VIVO by mobile world due to
damage bill no 890
11/4/2024 commission paid each to each sales rep 12% of
their sales
 JOB
PROJECT NAME: -BUILDING WORK

LOCATION: - CHENNAI

SET THE FOLLOWING MATERIALS: -

NAME GROUP P. PRICE UNIT ALT. UNIT

CEMENT AMBUJA 250 SACK LOAD/150 SACK
METAL 3500 LOAD
STONE 15 NOS LOAD/200 NOS
IRON TMT 56 KG LOAD/1000KG
STAND 4000 LOAD
PIPE PVC 50 MTR
PAINTS ASSIAN 90 LTR TIN/100LTR

PURCHASE THE FOLLOWING IEMS FROM MOHAN TRADER

CEMENT 40 LOAD, METAL 32 LOAD, STONE 20 LOAD, IRON 15 LOAD, SAND 18 LOAD, PIPE
10,000 MTR, PAINT 30 TIN

CONSUMED THE FOLLOWING ITEMS FOR JOB

CEMENT 32 LOAD, METAL32 LOAD, STONE 20 LOAD, IRON 14 LOAD, SAND 15 LOAD, PIPES
7600 MTR, PAINT 25 TIN

PAID THE BELOW EXPENSES FOR JOB

WAGE Rs.25000, CARRIAGE Rs.10,000, LOADING CHARGE Rs. 5000

SOLD THE JOB (BY ADDING Rs. 10,000 ON COST)

 BUDGET
1. Director board take a decision to set a budget, details are given below

Budget Name : sales budget

Duration : from: 01/04/25 to 01/05/25

Type of budget : on closing balance

Amount : 1,00,000

2. Purchase the below items: -

HP/2210 (group: printer, @ Rs. 8,000 per Nos) from

desire IT Shop 55 Nos Bill No: PR/12387

3. Sold 4 Nos HP Printer @ Rs. 10,000 per Bill No: S/01 (Include in Budget)

4. Sold 5 Nos HP Printer @ Rs. 10,000 per Nos to Color World pvt Ltd Bill
No: S/02 (Include in Budget)

5. Sold 1Nos HP Printer to Info Tech Bill No: 782 (exclude in budget)

6. Sold 2 Nos HP Printer for cash Bill No :S/03 (Include in budget)

7. Display the total sales, total budget and also display budget variance
Budget problem 2

The Following Would Be Recording in Journal Using Double Entry System. Do The
Posting Process from Journal Entries and Prepare the Trial Balance, Trading A/C,
Profit & Loss A/C And Balance Sheet in the Books Of M/S. INFOSYS LTD For the
Following Year 2009 To 2010

Particular Dr Cr

Capital 500000

Cash 250000

Bank Loan 100000

Profit & Loss A/C 50000

Accounts Receivable 50000

Axis Bank 150000

Machinery 75000

Plant & Machinery 150000

Good Will 125000

Bank O /D 100000

Debentures 50000

Total 800000 800000

Title of the Budget: Financial Budget

Period of Budget: 1.4.2009 to 31.3.2010

Ledger Name Estimated Amount (Rs)

Stationery 10000

Rent 50000

Salary 20000

Wages 15000

Fright charges 5000

Discount 5000

Commission 10000

Depreciation 10000

TRANSACTION DURING THE PERIOD:

1. Paid Telephone Charges Rs.2000

2. Goods Purchased on Credit From M/Sling Agencies Was Rs.100000

3. Bank Loan Received Rs.200000

4. Cash Withdraw from Bank Rs.100000

5. Paid Salary by Cheque Rs.10000

6. Provision For Depreciation Rs.15000 Allocate in to P&L A/C

7. Bank O/D Settled Rs.20000

8. Goods Sold To M/Sanaa Was Rs.180000 Bill No:25 25days

9. Paid For Rent: 20000, Stationery: 4000, Wages: 6000

10. Dividend Received Rs.20000

11.Paid Fright Charges Rs.3750 By Cheque 12.

Purchased Furniture Rs.60000

13. Paid To M/Sling Agencies and Discount Received @ 5%

14. Paid For Salary: 10000, Rent: 30000, Stationery: 1750

15. Paid Advertisement Charges Rs.2500 16.

Interest On Bank Balance Rs.10000

17. Depreciation Of Machinery @ 10% This Amount Adjusted to Provisions

18. Bank Loan Settled Rs.50000

19. Bad Debit Written Of M/Raina Was Rs.5000 20.

Discount Allowed Rs.3000

Answers:
opening balance 8,00,000

Gross profit 70,250

Net profit 17,000

Balance sheet 9,39,500

 Interest example sums
The following would be recorded in journal using double entry system to the posting
process from journal and prepare the Trial Balance, Trading a/c, Profit & loss a/c,
Balance Sheet and maintain the stock entry.

Features: Purchase order, Sales Order, Interest calculation, Re-order level,

Manufacturing date, Expiry Date as on 1.4.2010 to 31.3.2011.

Particular Dr Cr

Capital 1500000

Cash 200000

Building 200000

Furniture 100000

Debentures 500000

computers 100000

Motor car 200000

South Indian bank 600000

Loan from bank 400000

UPS 150000
 Particular Dr Cr

Investment 100000

Misc. Exp 250000

Provision for Depreciation 100000

Free hold property 100000

COMPUTER ACCESSORIES:

• Key board: 100nos @ Rs.1000each

• Mouse: 100nos @ Rs.600each

• Monitor: 8nos @

Rs.5000each FOOD ITEM:

• Horlicks: 500bottles @ Rs.120each

• Cereal: 600pack @ Rs.150each

• Bornite: 1000bottels @ Rs.150each

TRANSACTION DURING THE PERIOD:
PURCHASE ORDER & SALES ORDER:

Apr 01 Purchase order issued to M/s. COMPAQ SYSTEM LTD for the followings

• 70GB Ram 700nos @ Rs.2000each

• 50Gb Hard disk drive 500nos @ Rs.3000each

• CPU 100nos @ Rs.5000each Order No:CS82

Apr08 Sales order received from M/s. MORDEN COMPUTERS for the followings

• 70GB Ram 500nos @ Rs.2500each

• 50Gb Hard disk drive 450nos @ Rs.3500each

• CPU 80nos @ Rs.6000each Order No:MC55

Apr15 Stock received from M/s. COMPAQ SYSTEM LTD for the followings

• 70GB Ram 600nos @ Rs.2000each

• 50Gb Hard disk drive 450nos @ Rs.3000each

• CPU 100nos @ Rs.5000each

• Against Order No: CS82 bill no: 45 (45days)

Apr 20 Stock issued to M/s. MORDEN COMPUTERS for the followings

• 70GB Ram 450nos @ Rs.2500each

• 50Gb Hard disk drive 400nos @ Rs.3500each

• CPU 60nos @ Rs.6000each

• Against Order No: MC55 bill no: 564 (30days)

May05 Balance stock received from M/s. COMPAQ SYSTEM LTD against

• Order no: CS82 bill no:30 (20days)

May 12 Balance stock issued to M/s. MORDEN COMPUTERS against

• Order no: MC55 bill no:20 (30days)

INTEREST:

Jun 01 Goods sold to M/s. MORE INDUSTRIALS for the following

• Cereal: 200pack @ Rs.200each

• Bornite: 400bottels @ Rs.200each

• Vide bill no: 90 (30days)

• Rate of interest: 15%, Interest style: 365days

• Interest balance: All balance, Applicability: Past due date
• By: 30days, from: Due date of invoice redates: 1-Jul-2010
• Rounding: Normal rounding, Limit: 0.50

Jul02 Goods sold to M/s. WORLD VISION for the following

• Horlicks: 200bottles @ Rs.180each

• Cereal: 250pack @ Rs.200each

• Born vita: 200bottels @ Rs.200each

• Vide bill no: 080 (30days)

• Rate of interest: 10%, Interest style: 365days

• Interest balance: All balance, Applicability: Always
• From: Eff. Date of Transaction,
• Rounding: Normal rounding, Limit: 0.50
MFG DATE & EXPIRY DATE:

Sep05 Goods purchased from M/s. THULASI PHARMACY for the following.

• B-Complex 500strips (1strip=20tab) @ Rs. 30

• Zeranol 450strips (1strip=15tab) @ Rs. 45 bill no:25 (25days)

Batch No: UFC1115 (MFG Date: 01.09.2010) (Expiry Date: 01.02.2012)

Batch No: 23296 (MFG Date: 01.05.2009) (Expiry Date: 01.04.2011)

Other Transaction:

• Oct01 Cash deposit in to Bank Rs.50000

• Oct 21 Amount paid to M/s. COMPAQ SYSTEM LTD was Rs.50000-part amount.

• Nov 05 Amount received from M/s. MORDEN COMPUTERS was Rs.150000.

• Dec 03 Cash withdraw from bank Rs.30000

• Jan03 Amount received from M/s. WORLD VISION was fully received.

• Jan 31 Interest on Investment Rs.5000

• Feb07 Telephone charges paid Rs.2000 by cheque

• Mar31 Update the following stock quantities reorder level

o 70GB Ram: Reorder level: 1000nos Minimum Qty: 100nos

o 50 GB Hard disk drive: Reorder level: 500nos Minimum Qty: 30nos

o CPU: Reorder level: 500nos Minimum Qty: 450nos

Bank Interest

• Rate of interest: 15%, Interest style: 365days

• Interest balance: All balance, Applicable from:2-Sep-2010 To: 1-Nov-2010

• Rounding: Normal rounding, Limit: 0.50

• Rate of interest: 20%, Interest style: 365days

• Interest balance: All balance, Applicable from:1-Jan-2010 To:
• Rounding: Normal rounding, Limit: 0.50

Answers:
opening balance 25,00,000

Gross profit 6,25,500

Net profit 6,28,500

Balance sheet 65,13,750

Closing Stock 9,91,750

 BANK RECONCILATION STATEMENT
PARTICULAR DR CR
Capital 350000
Cash 100000
Indian bank 300000
Loan liability 150000
Bank O/d 48000
Furniture 30000
Good will 15000
Bills payable 200000

Land & building 50000

Bills receivable 130000
Bank deposit 100000

SUNDRY CREDITORS:
Mr. WIN INDIA Was Rs.5000 Bill. No. Ac75
Mr. COOL DREAM Was Rs.7000 Bill.No.AG085

SUNDRY DEBTORS:
Mr. FIVE STAR Ltd Rs.15000 Bill.NoAG076
Mr. LION MARK Ltd Rs.20000
Date Transactions

01-Apr Paid Telephone Charge Rs.2000 By Cheque [Vodafone] Ch.No.25131

02-Apr Amount Paid to Mr. Win India Was Rs.5000 Against Bill. No. AC075. Ch. No.
25132

03-Apr Commission Received by Cheque Rs.10000 Ch.No.75461

04-Apr 4 Month Salary Rs.10000 By Cheque Paid Ch.No.25133

05-Apr Amount Received M/five Star Rs.15000 By Cheque Discount allowed Rs. 750.Ch.
No.42678

06-Apr Dividend Received Rs.29000 By Cheque.Ch.No.13555

10-Apr Paid Rent by Cheque Rs. 4500.Ch. No.25134

11- Amount Paid to Mr. Cool Dream Rs.7000 by Cheque Discount Received Rs.700
Apr/td> Ch.No.25135

15-Apr Electric Charge Paid Cheque. Rs.1500 Ch.No.25136

16-Apr Interest Received by Cheque Rs.2000 Ch.No.41596

17-Apr Amount Received Mr. Lion Mark Was Rs.19000 Discount Allowed Rs.1000 By
Cheque Ch.No.89576
19-Apr Received Branch Income Rs. 25000 by Cheque.Ch. No. 89156

20-Apr Paid Trade Expenses by Cheque Rs.2500 Ch.No.25137

25-Apr Paid To General Expenses Rs.6000 Ch.No.25138

26-Apr Received House Rent Rs.3000 Ch.No.695472

27-Apr With Draw from Bank Rs.7000 Ch.No.25139

30-Apr Deposit To Bank Rs.9000

 PAYROLL

Name S.Nishanth P.Rathika

Department Administrative Sales

Designation Manager Sales Manager

Date of Join 1.8.1995 1.6.2000

Employee ID 258 1087

Bank name HDFC Bank Ltd HDFC Bank Ltd

Account number 1234567890 9876543210

Employee Salary Details

S.Nishanth P.Rathika

Basic pay Rs.35000 Basic pay Rs.20000

DA 40% for Basic pay DA 20% for Basic pay

TA 6% for Basic pay TA 5% for Basic pay

Medical allowance Rs.1000 per Month Medical allowance Rs.600 per Month

Advance Rs.1500 per Month Public provident fund 6.5% for Basic pay
Food allowance Rs.1300 per Month Food allowance Rs.500 per Month

House Rent 15% for Basic pay House Rent Allowance 8.5% for Basic pay
Allowance

Provident 10% for Basic pay + DA Provident Fund 7% for Basic pay + DA
Fund

Income tax 15% for DA Income tax 10% for DA

House loan Rs.700 per Month City compensatory allowance 15% for Basic pay

Over time 10hrs Over time 8hrs

 PAYROLL SHEET-2

• CAPITAL INTRODUCED IN THE BUSINES Rs. 1,00,000

NAME PAYHEAD UNDER CALCULATION ATTENDANCE CALCULATION PER DAY

TYPE LEAVE WITH PERIOD CALCULATION
PAY OR BASIS
PRODUCTION
TYPE
WAGE EARNING FOR DIRECT ON PRESENT DAYS
EMPLOYEE EXPENSE ATTENDANCE
SALARY EARNINGS FOR INDIRECT ON PRESENT MONTH USER
EMPLOYEE EXPENSE ATTENDANCE DEFINED (
MONTH OF
25 DAYS)
COMMISSION EARNINGS FOR INDIRECT ON QTY: NOS
EMPLOYEE EXPENSE PRODUCTION
BOUNS EMPLOYEES INDIRECT FLAT RATE MONTH
CONTRIBUTION EXPENSE
HRA EMPLOYEES INDIRECT FLAT RATE MONTH
CONTRIBUTION EXPENSE
TA EMPLOYEES INDIRECT FLAT RATE MONTH
CONTRIBUTION EXPENSE
DA EMPLOYEES INDIRECT FLAT RATE MONTH
CONTRIBUTION EXPENSE
MEDICARE EMPLOYEES INDIRECT FLAT RATE MONTH
CONTRIBUTION EXPENSE
PF EMPLOYEE’S CURRENT FLAT RATE MONTH
DEDUCTION LIABILITY
ESI EMPLOYEE’S CURRENT FLAT RATE MONTH
DEDUCTION LIABILITY
• EMPLOYEE REMUNERATION DETAILES

CREATE THE EMPLOYEE

EMPLOYEE GROUP EMPLOYEE NAME
SALES DEPARTMENT JHON
MATHEW
PRODUCTION DEPARTMENT AKIL
PARVATHI
ACCOUNTING DEPARTMENT BINDHU
NIKIL
SALARY DETAILS
NAME OF EMPLOYEE PARTICULERS AMOUNT
JHON WAGE 150
BOUNS 100
PF 50
DA 500
HRA 250
MATHEW WAGE 175
BOUNS 100
HRA 250
PF 50

BINDHU SALARY 5000

HRA 300
PF 500
BOUNS 200
NIKIL SALARY 6500
HRA 300
PF 200
BOUNS 150
TA 500

AKIL COMMISION 100

MEDICARE 1000
PF 100
ESI 25
PARVATHI COMMISION 150
PF 150
DA 300
TA 350

ATTENDANCE SETTING
BINDHU 24 DAYS • Show bonus report on the basis of department only
NIKIL 25 DAYS • Check the attendance details of this month
JHON 27 DAYS • Evaluate pf reports on the basis of employee name
MATHEW 26 DAYS • Show the pay sheet basis reports
AKIL 75 NOS • Identify pay slip reports
PARVATHI 68 NOS
 TDS (Tax Deduct at Source)

RECEIVE INVOICE FROM MOHAN BARGAVA, CHARTED ACCOUNTANT,

TOWARDS INTERNAL AUDIT FEE OF ACCOUNT Rs. 25000/- PAID TO MOHAN
BARGAV TOWARDS HIS INVOICES AFTER DEDUCTING TDS

TAX ASSESSMENT NO : 778/GA/01

INCOME TAX CIRCLE/ WARD(TCS): SEC(101)

COLLECTOR TYPE : GOVERNMENT

NAME OF RESPONSIBLE : TAX ATHORITY

 TCS (Tax Collected at Source)
ITEM UNIT S. PRICE P. PRICE OPENNING QTY
TMBER MTR 1000 900 5000

1. SBI BANK BALANCE Rs. 350000

2. SOLD 3000 MRT TIMBER TO MAHESH TRADER PVT LTD BILL NO001
3. CASH RECEIVED FROM MAHESH TRADER Rs. 3084150
4. PAID TCS TO GOVT
 POINT OF SALE
KERALI PVT LTD HAVE 10 NOS SPEAKER. THEY SOLD 2 NOS
SPEAKER TO ARAVINTH WITH Rs. 1500/NOS. CASH TENDRED AT
4000 BANCE AMNOUNTED TO ARAVITH Rs. 500