Tally Prime
Case Study 4 Exercise
Manufacturing
Organization
With GST
Mr. Dheeraj Kumar, Mr. Vikash Verma and Mr. Madan Lal Sharma started
a business in partnership under name & style “UPCISS COMPUTERS” The
board of director’s has to decide to maintain their accounts on Tally Prime
Software from 1st July, 2024. Trial Balance of the company on June 30,
2024 is as per given below.
Trial Balance (Closing Balance)
Particulars Group Amount
Assembling Table Fixed Assets 15000 Dr
Cash Cash-in-hand 553000 Dr
Computer Fixed Assets 25000 Dr
Electrical Equipment Fixed Assets 12000 Dr
Electrical Fittings Fixed Assets 15000 Dr
Furniture & Fixture Fixed Assets 25000 Dr
ICICI Bank Bank Account 1300000 Dr
Mr. Dheeraj Kumar Capital Account 700000 Cr
Mr. Vikash Verma Capital Account 500000 Cr
Mr. Madan Lal Sharma Capital Account 800000 Cr
Security Deposits Deposits Assets 45000 Dr
Voltage Meter Fixed Assets 10000 Dr
Create New Company in Tally Prime. Financial Year 1-Apr-2024
Books Beginning From 1-Jul-2024. Company GST No.
07ARCPS7755L1ZR (New Delhi).
1
July 2024
1 1-7-2024 Company deposited cash of Rs.80000 into ICICI Bank.
2 2-7-2024 Company purchased following items from Neha Computer,
New Delhi on credit. 07CKSPK5050M1ZU.
Items HSN Qty Rate Amount GST Total
Cabinet 84732900 100 650 65000 18% 76700
Mouse 84733010 100 175 17500 18% 20650
Keyboard 84733010 100 200 20000 18% 23600
RAM 84733030 100 750 75000 18% 88500
HDD 84733030 100 3500 350000 18% 413000
DVD-ROM 84733030 100 800 80000 18% 94400
Monitors 85283020 50 4000 200000 18% 236000
Total 807500 952850
Note: Company maintain all Stock items in different Location
(godown). Raw Materials Godown, Job Work Godown,
Finished Goods Godown.
3 7-7-2024 Company deposited cash of Rs.120000 into ICICI Bank.
4 10-7-2024 Company hired the following employee.
Name Designation Monthly Salary
Ganesh Rathore Hardware Engineer 4000
Bhawani Singh Salesman 3000
Imran Khan Accountant 3000
Kamlesh Raj Peon 2500
Salary will be Started from 1st July 2024.
5 18-7-2024 Company hired two building for office and godown. The Rent
of office and godown is Rs.3000 and 2000 per month.
Company issued a cheque of Rs.25000 towards security of
buildings.
Note: Create Voucher Class – Bank Payment and Cash Payment.
6 21-7-2024 Company purchased following items from Vintron System
Bangalore on credit (29BAOPK0366L1ZU).
Items HSN Qty Rate Amount GST Total
Motherboard 84733020 50 3200 160000 18% 188800
(Intel)
Motherboard 84733020 50 2500 125000 18% 147500
(AMD)
Motherboard 84733020 50 2200 110000 18% 129800
(VIA)
2
Processor 84714110 50 3500 175000 18% 206500
(Intel)
Processor 84714110 50 3000 150000 18% 177000
(AMD)
Processor 84714110 50 2500 125000 18% 147500
(VIA)
Total 845000 997100
Godown – Raw Materials Godown.
7 25-7-2024 Company issue a cheque of Rs.500000 to Neha Computers.
8 28-7-2024 Company purchase following items from Surya Hardware,
New Delhi on credit. (07AKQPR0650M1ZR).
Items HSN Qty Rate Amount GST Total
Screw 73181500 5 KG 600 3000 18% 3540
Packing 42029100 100 KG 50 5000 28% 6400
Materials
Godown – Job Work Godown.
9 31-7-2024 Company paid cash of Rs.9940 to Surya Hardware.
3
4
August 2024
10 1-8-2024 Company issued a cheque of Rs.5000 towards rent, office
Rs.3000, godown 2000.
Use Cost center and define % rate.
11 5-8-2024 Company paid cash of Rs.12500 towards salary.
Name Salary
Ganesh Rathore 4000
Bhawani Singh 3000
Imran Khan 3000
Kamlesh Raj 2500
Use Cost center and define % rate.
12 7-8-2024 Company has to set the details of components for
assembling a computer as brand Computer-Intel (HSN-
85283030, GST-18%). Details for assembling a computer is
given below.
Cabinet - 1Nos, Motherboard (Intel) - 1Nos, Processor
(Intel) - 1Nos, RAM - 1Nos, HDD - 1Nos, DVD-ROM - 1Nos,
Keyboard - 1Nos, Mouse - 1Nos, Monitor – 1Nos.
13 8-8-2024 Company issue a cheque of Rs.452850 to Neha Computer.
14 10-8-2024 Company issue a cheque of Rs.500000 to Vintron System.
15 12-8-2024 Company transfer following materials from Raw Materials
Godown to Job Work Materials.
Cabinet – 20 Nos, Motherboard (Intel) – 20 Nos,
RAM – 20 Nos, Processor (Intel) – 20 Nos,
HDD – 20 Nos, DVD-ROM – 20 Nos,
Keyboard – 20 Nos, Mouse – 20 Nos, Monitor – 20 Nos.
16 14-8-2024 Company assembled 20 Computer (Computer-Intel) and
incurred the wages of Rs.20000 and overheads Rs.1000.
17 17-8-2024 Company paid Rs.10000 reimbursement to partners in cash.
Name of Person Reimbursement
Madan Lal Sharma 4000
Dheeraj Kumar 3500
Vikash Verma 2500
Use Cost center and define % rate.
18 18-8-2024 Company has to set the details of components for
assembling a computer as brad Computer-AMD. (HSN Code:
85283030 GST-18%).
5
Cabinet - 1Nos, Motherboard (AMD) - 1Nos, Processor
(AMD) - 1Nos, RAM - 1Nos, HDD - 1Nos, DVD-ROM - 1Nos,
Keyboard - 1Nos, Mouse - 1Nos, Monitor – 1Nos.
19 18-8-2024 Company has to set the details of components for
assembling a computer as brad Computer-VIA. (HSN Code:
85283030 GST-18%).
Cabinet - 1Nos, Motherboard (VIA) - 1Nos, Processor (VIA)
- 1Nos, RAM - 1Nos, HDD - 1Nos, DVD-ROM - 1Nos,
Keyboard - 1Nos, Mouse - 1Nos, Monitor – 1Nos.
20 19-8-2024 Company transfer following materials from Raw Materials
Godown to Job Work Materials.
Cabinet – 30 Nos, Motherboard (AMD) – 15 Nos,
Motherboard (VIA) – 15 Nos, Processor (AMD) – 15 Nos
RAM – 30 Nos, Processor (VIA) – 15 Nos,
HDD – 30 Nos, DVD-ROM – 30 Nos,
Keyboard – 30 Nos, Mouse – 30 Nos, Monitor – 30 Nos.
21 20-8-2024 Company assembled 15 computers Computer-AMD and
incurred the wages of Rs.15000 and overheads of Rs.1000.
22 22-8-2024 Company assembled 15 computers Computer-VIA and
incurred the wages of Rs.15000 and overheads of Rs.1000.
23 25-8-2024 Company sold following computers to Shree Shyam
Computers, New Delhi on credit. (07ACCPL5252M1ZU)
Items Qty Rate Amount GST Total
Computer-Intel 10 22500 225000 18% 265500
Computer-AMD 10 19500 195000 18% 230100
Computer-VIA 10 19000 190000 18% 224200
Total 610000 719800
24 27-8-2024 Company sold following computers to Joy Computers, New
Delhi on cash. (Consumer)
Items Qty Rate Amount GST Total
Computer-Intel 5 23000 115000 18% 135700
Computer-AMD 5 20000 100000 18% 118000
Computer-VIA 5 19000 95000 18% 112100
Total 310000 365800
25 29-8-2024 Company received a cheque of Rs.719800 from Shree Shyam
Computers in full settlement.
26 31-8-2024 Company deposited cash of Rs.500000 in to ICICI Bank.
6
7
September 2024
27 1-9-2024 Company Paid Tax (GST) of Rs.18310.
28 3-9-2024 Company issued a cheque of Rs.5000 towards rent.
29 5-9-2024 Company paid cash of Rs.12500 towards salary.
30 6-9-2024 Company paid Rs.10000 reimbursement to partners in cash.
31 12-9-2024 Company received a job work statement of Rs.52500 form
Sharma Job Worker, New Delhi (07CVPPV7755M1ZR).
Job Work (Wages) = Rs.50000
GST@5% = Rs.2500
32 14-9-2024 Company issue a cheque of Rs.52500 to Sharma job worker.
33 20-9-2024 Company adjusts the physical stock verification for following
stock item. Screw 4.5Kg, Packing Materials 90Kg.
34 25-9-2024 Company issue a cheque of Rs.497100 to Vintron System.
8
9
10
11