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)
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.
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
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.
Consolidate your Data
Now you will have to consolidate all the three files which you have created (Sales Invoices, Cancelled Invoices, Returns Invoices)
Use of PIVOT Table
Apply the pivot table as explained in this video. We have attached the Excel file with “No” Data.
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
How to file GSTR-3B with the excel data.
Happy GSTR-3B filing.
Read More about:
CA Devesh Thakur