0% found this document useful (1 vote)
590 views30 pages

GST Test Project

Here are the steps to complete this project: 1. Restore the Tally backup file from the previous project. This will open the company "Little Leather Private Limited" 2. Pass the following journal entries: Date Particulars Debit Credit 01/09/2017 Purchased 500 pairs of shoes @ Rs. 1000 each plus 18% GST from ABC Traders (Regular supplier) 02/09/2017 Purchased 300 pairs of shoes @ Rs. 1200 each plus 18% GST from XYZ & Co (Regular supplier) 02/09/2017 Sold 450 pairs of shoes @ Rs. 1500 each plus 18% GST to PQR Trad

Uploaded by

babaloo sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (1 vote)
590 views30 pages

GST Test Project

Here are the steps to complete this project: 1. Restore the Tally backup file from the previous project. This will open the company "Little Leather Private Limited" 2. Pass the following journal entries: Date Particulars Debit Credit 01/09/2017 Purchased 500 pairs of shoes @ Rs. 1000 each plus 18% GST from ABC Traders (Regular supplier) 02/09/2017 Purchased 300 pairs of shoes @ Rs. 1200 each plus 18% GST from XYZ & Co (Regular supplier) 02/09/2017 Sold 450 pairs of shoes @ Rs. 1500 each plus 18% GST to PQR Trad

Uploaded by

babaloo sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 30

Q.1. On 01-07-2017 company Purchased 10 Pcs Printer @3,800 plus 18% GST From Jain & Co.

a Regular
dealer of UP. [GSTIN: 09AAACI1681G1Z1].
Q.2. On 01-07-2017 Company sold 10 Pcs Printer @4,600 each plus 18% GST to Paper House a Regular
dealer of UP. [GSTIN: 09BESPJ5513C1ZH]
Q.3. On 02-07-2017 company purchased 10 Pcs Printer @3,400 plus 18% GST from Mumbai traders
[GSTIN:27AAACI1681G1ZP] dealer of Maharashtra State.
Q.4. On 02-07-2017 company sold 10 Pcs Printer @4,600 plus 18% GST to Mr. K. Sharma Consumer of
Jharkhand State [GSTIN: 20AAACI1681G3Z1].
Q.5. On 02-07-2017 Purchased 20 Pcs Mouse @270 and 20 Pcs Printer @3,400 from Jain & Co. GST Rate
on Mouse 12% and Printer 18%.
Q.6. On 02-07-2017 Company sold 20 Pcs Mouse @320 each plus 12% GST and 20 Pcs of Printer @4,600
each plus 18% GST a Paper House a register Dealer of UP.
Q.7. On 01-08-2017 make the ajustment of GST and Paid it to Govt. through Axis Bank.
T From Jain & Co. a Regular

to Paper House a Regular

T from Mumbai traders

. K. Sharma Consumer of

00 from Jain & Co. GST Rate

nd 20 Pcs of Printer @4,600

Axis Bank.
Lakshya Academy of Computer Science
Project -1
Full Mark:-50

You work as an accountent of M/s Mobi Juction which run business of purchasing and selling mobile. Create a company in Ta
below mentioned details. Pass necessary journal entries of the following transactions, take backup of your company, save the
in desktop and change the name of the backup file with your student code e.g. A0001234.

Address : Your home town


PAN : Any PAN of Your Choice
GSTIN : XXPPPPP0000P1Z5 (First two digit will be your state code and next 10 digit will be youe PAN.)

Following transactions were extracted from the books of accounts:


Date Particulars
01/09/2017 Purchased 10 Pcs Samsung Galaxy J7 Pro SM-J730GM (Gold) Mobile @ Rs. 18,000 plus 12% GST from Jain & Co
XXAABPJ1230P1Z5].
02/09/2017 Purchased 20 Pcs Nokia 3 Dous-2017 (Black) Mobile @ Rs. 8,500 plus 12% from M/s Connection House [GSTIN
11AABBC1267L1Z5].
02/09/2017 Sold 9 Pcs Samsung Galaxy J7 Pro SM-J730GM (Gold) Mobile @ Rs. 19,500 plus 12% GST to M/s Bharat Machin
[GSTIN-XXAACCB0230Q1Z7].
02/09/2017 Sold all Nokia Dous-2017 (Black) Mobile @Rs.10,000 plus 12% GST to M/s Bijjaldeva Pvt. Ltd. [GSTIN- 12AABCB

01/10/2017 Adjust Input Credit against output Tax Liability for the month.

02/10/2017 Paid the Net output Tax Liability for the month of Sept'17 through net-banking.

Export the "GSTR - 1"from in excel format and save in desktop with your student code, e.g. A0001000_GSTR-1.
e

Time:- 60 Mins

le. Create a company in Tally with the


of your company, save the backup folder

(8)

will be youe PAN.)

(6*6=36)

us 12% GST from Jain & Co. [GSTIN-

Connection House [GSTIN-

GST to M/s Bharat Machineries Limited

Pvt. Ltd. [GSTIN- 12AABCB1260N1Z9]

000_GSTR-1. (6)
Lakshya Academy of Computer Science
Project -2
GST Practice on Supply of Service
Q.1. On 01-08-2017 company provided Interior Decoration Service (SAC: Find from internet) amounting to Rs. 6,40,000 plus 18
Galaxy Ltd. With the bill No. AD/1251/17-18. A regular dealer of U.P.
Q.2. On 02-08-2017 company received a bill amounting to Rs. 2,64,000 plus 18% GST for Advertising services (SAC: Find from in
from Third Eye Ltd. A regular Dealer of UP with the Bill No. TE/2001/17-18.
Q.3. On 02-08-2017 company provided Interior Deoration Services Amounting to Rs. 1,84,000 plus 18% GST to Orbit Salutions
dealer of Aruranchal Pradesh with the Bill No. AD/1252/17-18.
Q.4. On 02-08-2017 Company Purchased a Machinery of 60,00,000 plus 12% GST from Bharat Machineries Limited. One of the
dealer of UP.
ce

mounting to Rs. 6,40,000 plus 18% GST to

rtising services (SAC: Find from internet)

plus 18% GST to Orbit Salutions. A Regular

Machineries Limited. One of the regular


Lakshya Academy of Computer Science
Project -3
Full Mark:-40

Create a company Named "Mahindra communications Ltd"


Address : Your home town
GSTIN : 09BESPJ5514C1ZH

Following transactions were extracted from the books of accounts:


Date Particulars
01/09/2017 Purchased 20 Pcs Samsung Galaxy J7 Pro SM-J730GM (Gold) Mobile @ Rs. 20,000 plus 12% GST from Jain & Co
09AAACI1681G1ZN].
02/09/2017 On 01-08-2017 company provided Interior Decoration Service (SAC: Find from internet) amounting to Rs. 6,40,
GST to Galaxy Ltd. With the bill No. AD/1251/17-18. A regular dealer of U.P.
02/09/2017 Sold 18 Pcs Samsung Galaxy J7 Pro SM-J730GM (Gold) Mobile @ Rs. 21,500 plus 12% GST to M/s Bharat Mach
[GSTIN-09AABFC5619A1ZW].
02/09/2017 On 02-08-2017 company received a bill amounting to Rs. 2,64,000 plus 18% GST for Advertising services (SAC:
internet) from Third Eye Ltd. A regular Dealer of UP with the Bill No. TE/2001/17-18. [GSTIN: 09AAACI1681G1Z

01/10/2017 Adjust Input Credit against output Tax Liability for the month.

02/10/2017 Paid the Net output Tax Liability for the month of Sept'17 through net-banking.

Export the "GSTR - 1"from in excel format and save in desktop with your student code, e.g. A0001000_GSTR-1.
e

Time:- 60 Mins

(4)

(6*6=36)

us 12% GST from Jain & Co. [GSTIN-

net) amounting to Rs. 6,40,000 plus 18%

% GST to M/s Bharat Machineries Limited

Advertising services (SAC: Find from


. [GSTIN: 09AAACI1681G1ZY]

000_GSTR-1.
Lakshya Academy of Computer Science
Project -4
GST with all Cases
Q.1 Create a company Hari Traders 2017-2018 and enable GST.
GSTIN : 09AAAAG5588Q1ZU
State : Uttar Pradesh
Q.2 Business start on 01-07-2017 with cash 25,00,000.
Q.3 Open a Bank account in Axis Bank by 20,00,000.
Q.4 Purchase goods from Pritam Traders (Regular) of Kolkala with GST @18% on 01-07-2017.
Invoice No. Inv/001/2017-18
Item Qty Rate
Monitor 50 4000
HDD 100 2000
RAM 100 2000
Q.5 Purchase goods from SS Computers (Regular) of GKP with GST @18%.
Invoice No. Inv/028/2017-18
Item Qty Rate
Keyboard 100 500
Mouse 150 200
Sound 80 300
Q.6 Purchase goods from Suraj (Unregistered) of Gkp.
Invoice No. 101
Item Qty Rate
VGA Cable 10 200
HDMI Cable 10 250
Q.7 Purchase goods from Softech Computer (Composit dealer) of Gkp.
Invoice No. 111
Item Qty Rate
Pen Drive 25 450
Memory Card 50 300
Q.8 2 Pcs Monitor and 1 Pcs HDD return to Pritam traders on 02-07-2017 with debit note No. DN/001.
Q.9 10 Mouse return to SS Computers due to inferior quality on 02-07-2017 with debit nate No. DN/002.
Q.10 Purchase 1 Pcs 3D Printer from HP Computer (Newyork) on 02-07-2017 with the bill No. 121 on 1,50,000.
Q.11 Sold following Item to Rehan Traders ( Regular) with the bill No. sale/001/2017-18 on 02-07-2017.
Item Qty Rate
Monitor 40 5000
HDD 50 2500
RAM 50 2500
Q.12 Sold goods in cash to Rohit (Consumer) with the bill No. 002 on 02-07-2017.
Item Qty Rate
Monitor 2 5100
HDD 2 2600
RAM 2 2600
Q.13 Sold goods to Raja Traders (Composit) of (Patna) with the will No.003 on 02-07-2017.
Item Qty Rate
Keyboard 50 100
Mouse 100 250
Sound 40 400
Q.14 Sold goods to Mustfijur Traders of Dhaka (Bangladesh) with the bill No. 004 on 02-07-2017.
Item Qty Rate
Monitor 5 4000
HDD 40 2000
RAM 40 2000
Q.15 Sold goods to a cosumer name Tirupati (Chennai) with the bill No. 005 on 02-07-2017.
Item Qty Rate
3D Printer 1 300000
Q.16 1 Pcs Mouse return by Raja Traders with the credit note No. cr/001 on 31-07-2017.
Q.17 Advance cash receive from a customer Aman Traders (Regular) Rs. 1,18,000 for goods on 31-07-2017.
Q.18 Sales 3D Printer to Aman for Rs 3,10,000 and adjust advance.
No. DN/002.
121 on 1,50,000.
n 31-07-2017.
Lakshya Academy of Computer Science
Project -5
Full Marks: 50 Time : 60 Mins
You work as an accountent of M/s Little Leather Private Limited which run business of purchasing and
selling leather shoes. Restore the Tally Backup and pass necessary journal entries of the following
transactions, take backup of the company, save the backup folder in desktop and change the name of the
backup file with your student code e.g. IDT_A0001234.

Address : Your home town


PAN : Any PAN of Your Choice
GSTIN : 37AAACL0582H2ZK (Andhra Pradesh).

Following transactions were extrated from the books of account: [9*5=45]


Date Particulars

Required 20 pairs of shoes and issued bill of Rs. 2,000 plus 18% GST to M/s Vedant
01-04-2018 Shoes of Andhra Pradesh, an unregistered dealer.

Purchased 1 Shoe sole stitching machine from M/s Wigan Machine makers Ltd
01-04-2018
[GSTIN:37AAACW0387R1ZM] for Rs. 3,00,000 + 18% GST.

Purchased 50 Pairs of Wildhorn black shoes @ Rs. 1,000 plus 18% GST from Reddy
01-04-2018 shoes Private Limited [GSTIN: 37AAACR4849R2ZJ].

Sold 47 Pair of Wildhorn black shoes @ Rs. 1,200 plus 18% GST to M/s Shoes Mahal of
01-04-2018 Rajasthan [GSTIN: 08AACBS1429B1ZU].

02-04-2018 M/s shoes Mahal returned 2 pairs of Wildhorn black shoes because the colour was
different.

Purchased 10 Pairs of Wildhorn Men Casuals @Rs 2,700 plus 18 % GST from Modern
02-04-2018 leather World of Chennai [GSTIN: 33AAAGM0289C1ZQ].

Sold 8 Pairs of Woodland Men Casuals @ Rs. 3,500 plus 18% GST to M/s Metro Shoes ,
02-04-2018
an unregistered dealer.

Purchased 20 Pairs of Corporate Casual Shoes @ Rs.600 (Applicabe GST Rate -12%)
02-04-2018 from Mr. K. Subba Rao , an unregistered dealer of Andhra Pradesh.

Purchased 5 Pairs of Oora Men's Black Faux shoes @ Rs.450 (Applicabe GST Rate -5%)
02-04-2018 from M/s Andhra Shoes , another unregistered dealer of Andhra Pradesh.
Generate "GSTR 1.json file" and save the same in desktop with your student code , e.g. A0001000_GSTR1.json.
60 Mins
purchasing and
e following
ge the name of the

[9*5=45]

T to M/s Vedant

makers Ltd

GST from Reddy

M/s Shoes Mahal of

the colour was

GST from Modern

M/s Metro Shoes ,

GST Rate -12%)

abe GST Rate -5%)


adesh.
1000_GSTR1.json.
Lakshya Academy of Computer Science
Project -6
Full Marks: 50 Time : 60 Mins
You work as an accountant of M/s Little Leathers Private Limited which runs business of purchasing and
selling leather shoes. Restore the Tally Backup and pass necessary journal entries of the following
transactions, take backup of the company, save the backup folder in desktop and change the name of the
backup file with your student code e.g. IDT_A0001234 (Keep in mind the provisions of GST, wherever
applicable):

Address : Your home town


PAN : Any PAN of Your Choice
GSTIN : 37AAACL0582H2ZK (Andhra Pradesh).

Following transactions were extrated from the books of account: [9*5=45]


Date Particulars

Purchased 50 pairs of WildHorn Black Shoes @ Rs. 1,000 plus 18% GST from Reddy
01-05-2018 Shoes Private Limited [GSTIN – 37AAACR4849R2ZJ]

Purchased 10 pairs of Woodland Men Casuals @ Rs. 2,700 plus 18% GST from Modern
01-05-2018 Leather World of Chennai [GSTIN – 33AAAGM0289C1ZQ]

Purchased 20 pairs of Corporate Casual Shoes @ Rs. 600 (applicable GST Rate – 12%)
01-05-2018 from Mr. K Subba Rao, an unregistered dealer of Andhra Pradesh.

Purchased 5 pairs of Oora Men’s Black Faux shoes @ Rs. 450 (applicable GST Rate –
01-05-2018 5%) from M/s Andhra Shoes, another unregistered dealer of Andhra Pradesh.

Sold 47 pairs of WildHorn Black Shoes @ Rs. 1,200 plus 18% GST to M/s Shoe Mahal of
02-05-2018 Rajasthan [GSTIN – 08AABCS1429B1ZU].

Sold 8 pairs of Woodland Men Casuals @ Rs. 3,500 plus 18% GST to M/s Metro Shoes,
02-05-2018 an unregistered dealer

M/s Shoe Mahal returned 2 pairs of WildHorn Black Shoes because the colour was
02-05-2018 different.

Purchased 1 shoe sole stitching machine from M/s Wigan Machine Makers Limited
31-05-2018 [GSTIN – 37AAACW0387R1ZM] for Rs. 3,00,000 + 18% GST.

Repaired 20 pairs of shoes and issued bill of Rs. 2,000 plus 18% GST to M/s Vedant
31-05-2018 Shoes of Andhra Pradesh, an unregistered dealer.
Generate "GSTR 1.json file" and save the same in desktop with your student code , e.g. A0001000_GSTR1.json.
60 Mins
f purchasing and
e following
ge the name of the
GST, wherever

[9*5=45]

GST from Reddy

% GST from Modern

e GST Rate – 12%)

cable GST Rate –


a Pradesh.

M/s Shoe Mahal of

M/s Metro Shoes,

the colour was

Makers Limited

T to M/s Vedant
1000_GSTR1.json.
Lakshya Academy of Computer Science
Project -7
Full Marks: 50 Time : 60 Mins
You work as an accountant of M/s Little Leathers Private Limited which runs business of purchasing and
selling Monitor (Keep in mind the provisions of GST, wherever applicable):

Address : Your home town


PAN : Any PAN of Your Choice
GSTIN : 37AAACL0582H2ZK (Andhra Pradesh).

Following transactions were extrated from the books of account: [9*5=45]


Date Particulars

Purchased 20 Pcs Monitor @ Rs.3,800 plus 18% GST from Amrit & Company a regular
01-05-2018 dealer of West Bengal [GSTIN: 19AAACJ2054J1ZL].

Sold 20 Pcs Monitor @ Rs. 4,600 each plus 18% GST to Raj Traders a regular dealer of
01-05-2018 West Bengal [GSTIN: 19AABCP5762E1ZC].

Purchased 20 Pcs Monitor @ Rs.3,400 plus 18% GST from RKDK Groups a regular
01-05-2018
dealer of Andhra Pradesh [GSTIN: 37AAAAG5588Q1ZT].

Sold 20 Pcs Monitor @ Rs. 4,600 each plus 18% GST to Mr.K. Sharma , consumer of
01-05-2018 Jharkhand.

Provided Interior Decoration Service (SAC: 00440076) amounting to Rs. 3,20,000 plus
02-05-2018 18% GST to Galaxy Ltd. (19AAAAG5588Q1ZT) a regular dealer of West Bengal.

Purchased a Machinery of Rs. 50,00,000 plus 12% GST from Bharat Machineries Ltd.
02-05-2018 One of the regular dealers of West Bengal [19AAACB4146P1ZC].

Purchased 20 Pcs Monitor @ Rs. 3,200 from Radhey & company who is an unregister
02-05-2018 dealer of West Bengal.

31-05-2018 1 Monitor Purchased from Radhey & Company returned as it was not working.

02-06-2018 1 Monitor sold to Raj Trader returned by them due to display issue.

Generate "GSTR 1.json file" and save the same in desktop with your student code , e.g. A0001000_GSTR1.json.
60 Mins
f purchasing and

[9*5=45]

Company a regular

a regular dealer of

oups a regular

a , consumer of

o Rs. 3,20,000 plus


est Bengal.

Machineries Ltd.

ho is an unregister

ot working.

1000_GSTR1.json.
Lakshya Academy of Computer Science
Project -8
Full Marks: 50 Time : 60 Mins
You work as an accountant of M/s ABC Private Limited which runs business of purchasing and selling
Leather goods (Keep in mind the provisions of GST, wherever applicable):

Address : Your home town


PAN : Any PAN of Your Choice
GSTIN : 27AAACI1681G3ZN (Maharashtra).

Following transactions were extrated from the books of account: [9*5=45]


Date Particulars

Purchased 250 pairs of leather laptop bag @ Rs. 2,000 plus 5% GST from Amit Private
01-08-2018 Limited [GSTIN: 27AAAAG5588Q1ZW].

Purchased 6 pairs of Men Formal Shoes @ Rs. 5,000 plus 18% GST from Janta World of
01-08-2018 Kanpur [GSTIN: 09AAAAG5588Q1ZU].

Purchased 4 pairs of of Men Casual shoes @ Rs. 1,200 (applicalbe GST rate- 12%) from
01-08-2018
Mr. Hanuman, as unregistered dealer of Maharastra.

Purchased 3 pairs of Men's black shoes @ Rs. 1,000 (applicale GST rate- 5%) from Bata
01-08-2018 [GSTIN: AAAAG5588Q1ZW] ,a composite dealer of Maharashtra.

Exported 235 pairs of leather laptop bag @ Rs. 3,000 to Woodland company of
02-08-2018 Bangladesh. Applicable GST rate is 5%.

Sold 5 pairsof Men formal shoes @ Rs. 7,000 plus 18% GST to Janardan shoes, an
02-08-2018 unregistered dealer of Maharashtra.

02-08-2018 Janardan shoes returned 2 pairs of Men formal because the size was different.

Purchased 1 shoes stitching machine from Yakuhama company, Japan for Rs. 8,00,000.
02-08-2018
Applicale GST rate is 18%.

Got a bill of Rs. 50,000 from Mushafir & Co. a CA firm, for advising in financial matters.
02-08-2018 Applicable GST rate is 18% RCM applicable.

Generate "GSTR 1.json file" and save the same in desktop with your student code , e.g. A0001000_GSTR1.json.
60 Mins
ng and selling

[9*5=45]

from Amit Private

rom Janta World of

GST rate- 12%) from

rate- 5%) from Bata

company of

dan shoes, an

as different.

an for Rs. 8,00,000.

n financial matters.

1000_GSTR1.json.

You might also like