Are you selling on Amazon? If yes then you might find this blog very informative. In this, you (being an online seller) will get to know how to file GSTR-3B for Amazon sellers in the easiest manner by using Excel.
We will be using a PIVOT table in excel for generating data that we are going to use in filing GSTR3B.
Follow the below-mentioned steps to file GSTR-3B in case of the online seller (Amazon)
Step 1:
Understand the requirement of GSTR-3B. What exactly GSTR-3B demands from us. After understanding the requirements we should proceed with the Data.
To know more about TCS Credit. Click Here.
Step 2:
Collection of Data
The most important step in filing monthly GSTR-3B in the case of an online seller is getting actual and full data for filing such a return.
Online sellers need below mentioned reports: –
- MTR Reports (Merchant Tax Report) which includes B2C Reports and B2B Reports
- Sales Return Report
Step 3:
Sorting of Data
We have to sort data as per the required format. Click here to download your excel file as explained in this video.
Step 4:
Consolidate your Data
Now you will have to consolidate all the three files which you have created (Sales Invoices, Cancelled Invoices, Returns Invoices)
Step 5:
Use of PIVOT Table
Apply the pivot table as explained in this video. We have attached the Excel file with “No” Data.
Step 6:
Gather your Eligible ITC
Online sellers can get their eligible ITC from various sources as explained in this video. The most important point to be considered while claiming the accurate ITC is to consider the Credit Note issued by the Amazon and the additional Shipping invoices issued by the Amazon.
Claim only eligible and accurate ITC
Step 7:
How to file GSTR-3B with the excel data.
Happy GSTR-3B filing.
Read More about:
Self-Judge your B2B performance on Amazon India through Amazon B2B Central
How to download monthly commission invoices from Amazon.
CA Devesh Thakur
Hi I am not able to find pivot excel download option
Dear Jitendra,
Please refer to Step 3 for Excel.
In your video you have not done any treatment for cancelled invoices. Those order ids must be removed from shipment if they are cancelled why to include it in sales invoice. Please clarify.
Dear Divyani,
Yes, it is a good practice to remove such cancel invoice ids.
sir how to file gstr 1 through pivot
Dear Jatin,
GSTR-1 in the case of Amazon is a comprehensive return. There is no predefined formula to file GSTR-1 in the case of Amazon. However, on various occasions we can use a Pivot Table. I will soon share the blog and video on how to file GSTR-1 in case of Amazon.
sir is there any way that i can take you professional services.
Dear Jatin,
Kindly check your inbox for more details.
SIR SALES COLUMN KASE BHARI GAI HAI AMAZON REPORT SE?
Dear Yogesh,
You have to put the Sales amount exclusive of taxes in Column “X” in the excel format. You can get the sales amount exclusive of taxes from B2C ad B2B reports.