In this clip, you will see a very important column, which
was not filled in GST R1 earlier, but now it is mandatory
to fill it.
If you file a written without it, then there is a complete
chance of getting a notice.
You will have to fill this column, which is table number
12, HSNY summary of outward supplies.
You can see how it is, some data has been asked for it, but
friends, it will not be fed up so easily.
This is a little different work than filing a bill.
It is a different work than filing a bill.
This is HSNY summary.
Sir, how will it be made?
For this, I will take you to an excel sheet.
And I will tell you how that excel sheet is made.
And how do you have to make it?
Look at this, friends, we have come to an excel sheet.
And I try to make it a little bigger.
Give me some time.
Look at this.
Sir, what have you made?
We have made this HSN sheet to file a written.
How is this HSN sheet made?
That's what I have to discuss with you.
Look, friends, what do you have to do in your bills?
You have to make a combination.
Combination of what?
HSN and Unit Quantity Code, UQC.
Like liter, meter, kilogram, all these things.
HSN code and UQC, you have to make a combination of unit
quantity code.
You have to take one HSN and one UQC.
If there is another UQC on the same HSN, then a different
heading will be made.
For example, I will take you to the writing pad.
Because this thing will be understood better on the writing
pad.
Let me take you all to the writing pad.
What I want to say will be understood more by writing.
So, as we have seen the bill numbers, friends.
All the bills we have to do, we have to write HSN from all
of them.
What is the HSN in it?
We had 20 bills.
And the HSN codes we had in those bills were like this.
3916, 3917.
After that, 3923.
After that, 40097307.
Sir, where are you writing from?
I am writing from the bill itself.
8 5 4 4 8 7 1 4 8 5 4 4 8 7 1 4
Sir, the first four digits have to be written.
Yes, now you understand this much.
And 8 7 0 8.
I have written all the HSN codes in all the bills.
In 20 bills, in some bills there was 3916, in some there
was 3917, in some there was 3923.
In some there was 40097307, in some there was 8 5 4 4, in
some there was 8 7 1 4, in some there was 8 7 0 8.
All the different HSNs were in my 20 bills.
I picked it up and wrote it here.
Now you have to see in those bills.
In those bills, what was the quantity?
It was in kg, it was in liter, it was in meter, it was in
what?
In the HSN of 3916, all the quantities were in kg.
How many were there?
In kg.
All the bills of 3916 were in kg.
The bills of 3917 were also in meter.
And were also in kg.
The bills of 3923 were in pieces.
PCS pieces.
40097307, 8 5 4 4.
All three bills were in pieces.
Pieces, pieces, pieces.
The bill of 8714 was in meter.
And the bill of 8708 was in kg.
What did I do?
I picked up all the bills.
I wrote all the different HSNs in them.
And on those HSNs, what was the quantity?
In those bills, I wrote it in front.
And I found out.
All the bills of 3916 are in kg.
All the bills of 3923 are in pieces.
Similarly, all the bills of 40097307 and 8 5 4 4 are in
pieces.
The bill of 8714 is in meter.
And the bill of 8708 is in kg.
We have one such bill.
HSN code.
The bill of 8714 is in kg and is in meter.
The bill of 8714 is in meter and is in kg.
Okay, okay, okay.
Write it down.
Correct it.
The bill of 8714 is in kg and is in meter.
So, we have two bills.
This one and this one.
How do we have these?
Their quantity is of two types.
The bills of 3917 are in meter and are in kg.
The bills of 8714 are in kg and are in meter.
You have to make a list like this.
And this is what I have written in Excel.
This is what I have written in Excel, friends.
See this.
This is what I have written in Excel.
We have all these HSN codes.
3916, 3917, 3923, 409, 7307, 8544, 8714, 8708
In this, we have two such bills.
One is 3917, which is in meter and is in kg.
And 8714, which is in meter and is in kg.
The rest are either in kg or in pieces.
In this way, we have prepared a list.
In this way, we have prepared a list, friends.
What do you have to do after that?
All the bills of 3916 are in kg.
You have to write the total quantity of all of them here.
Come, I will show you the bills of 3916.
How many did we have?
Let me show you how many bills of 3916 we had.
See this, sir.
From 3916 to kg, we have two bills.
From 3916 to kg, we have a bill of 482.
And from 3916 to kg, we have a bill of 489.
You have to calculate the total quantity of both the bills.
The quantity is 970, 970.
And 917.
970 plus 917.
This will be 1887.
1887.
You have to write 1887 in the Excel sheet here.
1887 in the total quantity.
Okay, okay, okay.
1887 here.
After that, calculate the total taxable amount.
Calculate the total taxable amount.
Calculate the total taxable amount in both the bills.
Let's calculate the total taxable amount.
Let's calculate the taxable amount.
Here it is.
The taxable amount will be below the taxable amount.
In the first bill, it was 107538.
And in the second bill, it was 113580.
The value above the GST.
The total amount below is 134024.
The value above the GST is 113580.
And 107538.
The total of these two.
You have to write the total of these two in the Excel sheet.
Here.
The taxable amount will be 221118.
And then whatever GST is being applied.
You have to write the total in both the bills.
Similarly, friends.
You have to apply on every combination of HSN and UQC.
And this Excel sheet will be prepared in this way.
First pick up the bills.
Write all the HSN codes in the Excel sheet.
Write all the types of unit quantity codes related to those
HSN codes separately.
Then write the total of all the matched bills.
Write the total quantity of all the bills on 3916.
Write the total taxable amount and total GST.
Similarly, write the total taxable amount of all the bills
on 3917.
Write the total taxable amount of all the bills on 3917.
Write all the bills in this way.
Your Excel sheet will be ready.
Your Excel sheet will be prepared.
And then you have to go to the GST portal.
And here you can add more details.
For example, if you are asking about HSN, the first one was
3916.
Okay, sir. Take 3916.
After 3916, what was the unit quantity code in the first
line?
It was kg.
Come down and select.
You will see a kilogram here.
Kilogram, kilogram, kilogram.
Here, kg, kilogram.
The total quantity was 1887.
What was the total taxable value? 221,118.
221,118. What was the rate of GST in both the bills? 18%.
And in both the bills, the IGST was 0.
The central tax was the total of both the bills, CGST.
19,900.
And the SGST of both the bills was 19,900.
Add it like this.
Request accepted successfully.
That is, one entry came.
give you one entry give one entry give next hsn next hsn is
3917meter i will show you excel sheet 3917meter
3917meter 4860 total quantity what you will do here write
3917 in hsn
You can search in UQC, meters, don't know where the meters
are, MTR meters, here it is.
In total quantity, you will write, total quantity which we
had, 4860, total taxable value 57348.
You have to make it by looking at the excel sheet.
Okay, what was the rate? 18% of CGST and SGST, IGST is 0.
And how much is CGST and SGST?
Search in the excel sheet, 51615161.
And if you click on add, another entry will be uploaded.
Request accepted successfully.
If you come down and see, whatever you upload, it will go
away while you see.
The department wants the total of your bills and your HSN
summary to be matched.
Upload the entry separately and send it to the HSN summary
department separately.
That's why you have to do this.
In this way, you have to add all the combinations of the
excel sheet here.
All the combinations have to be uploaded.
So what will happen then?
Then friends, this will be completed.
Your HSN table will also be completed.
Okay? Okay sir.
So this was table number 12, HSN wise summary of outward
supplies.