Thank you for your response
Import invoice details from e-way bill portal to prepare GSTR-1 every month or quarter, as the case may be. The article is a go-to guide to learn in detail about the option available on the GST portal login to import sales invoice details from e-way bill site to prepare GSTR-1.
The feature on GST portal is much-needed relief for the taxpayers dealing with goods and generating e-way bills for its transportation. These taxpayers can now make use of the option to integrate the e-way bill management portal on ewaybill.gst.gov.in and the GST return filing portal on gst.gov.in.
Extension in the Validity of e-way bills
29th August 2021
From 1st May 2021 to 18th August 2021, the taxpayers will not face blocking of e-way bills for non-filing of GSTR-1 or GSTR-3B (two months or more for monthly filer and one quarter or more for QRMP taxpayers) for March 2021 to May 2021.
4th August 2021
Blocking of e-way bills due to non-filing of GSTR-3B resumes from 15th August 2021.
1st June 2021
1. The e-way bill portal, in its release notes, has clarified that a suspended GSTIN cannot generate an e-way bill. However, a suspended GSTIN as a recipient or as a transporter can get a generated e-way bill.
2. the mode of transport ‘Ship’ has now been updated to ‘Ship/Road cum Ship’ so that the user can enter a vehicle number where goods are initially moved by road and a bill of lading number and date for movement by ship. This will help in availing the ODC benefits for movement using ships and facilitate the updating of vehicle details as and when moved on road.
18th May 2021
The CBIC in Notification 15/2021-Central Tax has notified that the blocking of GSTINs for e-Way Bill generation is now considered only for the defaulting supplier’s GSTIN and not for the defaulting recipient or the transporter’s GSTIN.
So far, the taxpayers had to first upload invoices on the e-way bill site and then again onto GST portal at the time of filing GSTR-1. Taxpayers had to go through the unnecessary hassle of importing the same data twice onto different portals. To avoid this, an option is added on the GSTR-1 filing dashboard-“Import EWB data” for three tiles. This will reduce errors involved in the input of data for taxpayers and help the tax authorities monitor tax evasion.
Following tiles or tables in GSTR-1 can be imported from the e-way bill site:
One can get data from the e-way bill website in 2 ways:
Step 1: Login and navigate to GSTR 1 dashboard Login to GST Portal and go to “Returns Dashboard”.
After selecting the month and financial year of the return period, Go to GSTR-1 tile by clicking on ‘PREPARE ONLINE’. Proceed to make entries
Step 2: Click on the respective tile A, B or C as referred to above, for which you want to Import Invoices from e-way bill site
Note: An invoice can be imported multiple times from the e-way bill system to GSTR-1, but if an invoice already exists in GSTR-1, a warning message will pop up asking whether you want to replace the existing document. Click on ‘Yes’ if you want to continue importing by replacing any existing invoice.
Step 3: Import e-way bill data into the respective tiles A, B or C and proceed to continue filing GSTR-1
To proceed, click on IMPORT EWB DATA button on the tile A i.e“4A, 4B, 4C, 6B, 6C – B2B Invoices”, for instance. On the basis of the number of invoices raised in EWB system, a page will be displayed subsequently. If the number of invoices is less than 50: Direct online import is possible as the number of invoices is less than 50. Follow the steps mentioned below:
If the number of invoices is more than 50 but less than 500:
If the invoices are more than 500 in number: The following page is displayed:
Click the IMPORT EWB DATA button in tile B “5A, 5B – B2C (Large) Invoices” tile. If the number of invoices is less than 50 Follow the same steps as performed for importing B2B invoices.
If the number of invoices is more than 50 but less than 500 The following page will be displayed:
Click Download to get the B2Cl file. Cross check the file for any discrepancies and edit the same in the downloaded excel file. Follow the steps for uploading the invoices from excel sheet to the GSTR-1 as detailed here.
If the number of Invoices is more than 500 Follow the same steps as performed for B2B file download.
Click the IMPORT EWB DATA button in tile C “12 – HSN-wise-summary of outward supplies” tile.
If the number of invoices is less than 50 The following page will be displayed:
Click download to get the hsn.csv file. Cross check the file for any discrepancies and edit the same in the downloaded excel file. Follow the steps for uploading the invoices from excel sheet to the GSTR-1 as detailed here. If the number of invoices is more than 50 but less than 500
Click download to get the hsn.csv file. Cross check the file for any discrepancies and edit the same in the downloaded excel file. Follow the steps for uploading the invoices from excel sheet to the GSTR-1 as detailed here.
If the number of invoices is more than 500 Follow the same steps as performed for B2B file download.
Cases where the number of invoices is more than 50, the taxpayer must first download the invoices in excel. Direct import to GSTR-1 option is not available in such cases. There are 2 options to upload invoices from excel file to GSTR-1.
Import excel workbook through Offline Utility Tool
Step 1: Import Excel File and make it in the format mentioned below:
Step 2: Click the Import Files on the returns offline tool.
Step 3: Click the Import excel button and browse and select the worksheet.
Step 4: Click Yes to proceed
A message will be received confirming successful import.
Step 5: Click the Back button to view the excel invoices populated on the screen
Data uploaded can also be deleted or edited by using the respective buttons on the screen.
Copy and paste from excel workbook
Step 1: Edit the downloaded excel worksheet in the prescribed return format and then copy the header part along with the data from the excel sheet.
Step 2: Click Import Files on the returns offline tool & then click on copy excel
A confirmation will be received. Click yes to save data and you can notice the invoices in the excel uploaded to the screen.
There are 2 options to upload missing invoices: