Single invoice with two different GST rates

Rate / HSN codes 15278 views 16 replies
Single invoice with two different GST rates, how to enter in GSTR-1 return? Offline utility is showing error as duplicate invoice.
During so many seminars it was told that single invoice can show different GST rates for different items. Whether GSTN IT system has taken care of such transactions?
Replies (16)
if so u will have to wait for modification

BETTER TO MAKE 2 DIFFERENT INVOICES IF POSSIBLE...........

Yes. You can have single invoice for more than 1 items having different GST Rates.

I faced similar situation. While filing GSTR1 for one of my clients, who is a wholeseller of having many HSN codes. The spread sheet that was extracted from the application, where single invoice having multiple items & multiple tax rates; we considered the same invoice number and invoice value as it is for all three line items. For Ex: Invoice # 001 having total Invoice value of Rs.10,000 with three different rate of items, i.e. 12% for Rs.2,000,18% for Rs.4,000 and 28% for Rs.4,000. We mentioned invoice # 001 and Invoice value Rs.10,000 for all three items with their respective taxable value in B2B section. While uploading the GSTR1 in to the GST portal, the system only considered one line item and removed two others as duplicate invoice details. That means the application is developed in such a way that only takes into consideration the invoice number as reference and excludes other details of the row. In consequence, there is a mismatch of total taxable value and tax on it. Really needs to be fixed.

For small organizations or the organization dealing with less number of items and volume for them it is possible. Think about an organization where thousands of entries to be made on a daily basis and that is kazilion for a month...I believe for them that will be really a big problem.

You have to add manually such invoices, system allows.

I did check it previously and it works. But do u think practically possible for those type of clients, where thousands of records are there in a month. Just take an example of Big Bazar (Future group)...

Additionaly, if you see the spread sheet attached in the zip folder available for downloading the off line tool, the spread sheet contains few data for example. The invoice number A1003 (if not wrong) in BTB section, there are two different tax rate and the invoice numbers are same along with invoice value. Does Govt. really mean that we need to upload the excel spread sheet and manually we will edit for each invoice befor generating the .json file. If that is so then grt job done by Infy.

Out of 5 line items in an Invoice (having different GST rates), only the first one is being uploaded in the offline tool. Rest 4 have to be added manually by clicking on edit option in offline tool on the respective Invoice. But when we see video tutorial in GST it nicely shows even those Invoices are getting uploaded. This is really a serious problem.

Here is the solution, Invoice value has to be modified as given below

This method will not work                
GSTIN/UIN of Recipient Invoice Number Invoice date Invoice Value Place Of Supply Reverse Charge Invoice Type Rate Taxable Value Cess Amount
37XXXXXXXXXXX1Z1 0001 01-08-2017 118 37-Andhra Pradesh N Regular 18 100  
37XXXXXXXXXXX1Z1 0001 01-08-2017 256 37-Andhra Pradesh N Regular 28 200  
37XXXXXXXXXXX1Z2 0002 02-08-2017 354 37-Andhra Pradesh N Regular 18 300  
37XXXXXXXXXXX1Z2 0002 02-08-2017 512 37-Andhra Pradesh N Regular 28 400  
                   
This method will work                  
GSTIN/UIN of Recipient Invoice Number Invoice date Invoice Value Place Of Supply Reverse Charge Invoice Type Rate Taxable Value Cess Amount
37XXXXXXXXXXX1Z1 0001 01-08-2017 374 37-Andhra Pradesh N Regular 18 100  
37XXXXXXXXXXX1Z1 0001 01-08-2017 374 37-Andhra Pradesh N Regular 28 200  
37XXXXXXXXXXX1Z2 0002 02-08-2017 866 37-Andhra Pradesh N Regular 18 300  
37XXXXXXXXXXX1Z2 0002 02-08-2017 866 37-Andhra Pradesh N Regular 28 400  

 

sir does it works?

Originally posted by : maruthiramg
Here is the solution, Invoice value has to be modified as given below




This method will not work
 
 
 
 
 
 
 
 


GSTIN/UIN of Recipient
Invoice Number
Invoice date
Invoice Value
Place Of Supply
Reverse Charge
Invoice Type
Rate
Taxable Value
Cess Amount


37XXXXXXXXXXX1Z1
0001
01-08-2017
118
37-Andhra Pradesh
N
Regular
18
100
 


37XXXXXXXXXXX1Z1
0001
01-08-2017
256
37-Andhra Pradesh
N
Regular
28
200
 


37XXXXXXXXXXX1Z2
0002
02-08-2017
354
37-Andhra Pradesh
N
Regular
18
300
 


37XXXXXXXXXXX1Z2
0002
02-08-2017
512
37-Andhra Pradesh
N
Regular
28
400
 


 
 
 
 
 
 
 
 
 
 


This method will work
 
 
 
 
 
 
 
 
 


GSTIN/UIN of Recipient
Invoice Number
Invoice date
Invoice Value
Place Of Supply
Reverse Charge
Invoice Type
Rate
Taxable Value
Cess Amount


37XXXXXXXXXXX1Z1
0001
01-08-2017
374
37-Andhra Pradesh
N
Regular
18
100
 


37XXXXXXXXXXX1Z1
0001
01-08-2017
374
37-Andhra Pradesh
N
Regular
28
200
 


37XXXXXXXXXXX1Z2
0002
02-08-2017
866
37-Andhra Pradesh
N
Regular
18
300
 


37XXXXXXXXXXX1Z2
0002
02-08-2017
866
37-Andhra Pradesh
N
Regular
28
400
 




 

NICE! IT'S WORKING, VERY MUCH THANKS

IT'S WORKING VERU MUCH THANKS!

 

Hi,

What of the Invoice value consists Reimbursment part? On which no GST. How do we show in GSTR1?

Invoice Value - 10000

Reimbursments - 500

Tax - 1800

Total Invoice value is - 12300/-

How do you show this Reimbursment part?

Reimbursements if shown as part of invoice will also get taxable


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register