How To Import Invoices From The E-way Bill Site To GSTR-1

GSTR-1 is a statement showing the details of all outward supplies of goods and services. All normal as well as casual registered taxpayers need to file GSTR-1. Depending on their turnover, some businesses can opt for the Quarterly Return and Monthly Payment (QRMP) Scheme, where they will have to file GSTR-1 every quarter. Businesses who don’t opt or are ineligible for the QRMP Scheme have to file GSTR-1 every month.

Suppliers who have transported goods would have generated e-way bills to facilitate those transports. The GST Portal provides a highly useful feature to import invoice details from those e-way bills directly to the GST Portal. This is a great help for taxpayers while preparing GSTR-1.

In this article, we will go over this feature in detail and show you how to import the invoice details from the e-way bill portal directly to the GST Portal.

What Details can be Imported From the E-way bill site?

The following tables can be imported from the E-Way Bill Portal when filing GSTR-1:

• Tables 4A, 4B, 4C, 6B, 6C – B2B Invoices – These are details of sales transactions that occurred between GST registered persons, arranged invoice-wise. We will refer to these collectively as ‘Table A’ moving forward.
• Tables 5A, 5B – B2C (Large) Invoices – We will refer to these collectively as ‘Table B’ moving forward. These are invoice-wise details of the following sales transactions:
• Sales by a registered person to an unregistered person
• Sales where invoice value greater than ₹2,50,000
• Table 12 – HSN-wise-summary of Outward Supplies – This is an HSN-wise summary table of invoice details of outward supplies. We will refer to this table as ‘Table C’ moving forward.

There are two ways to download data from the e-way bill website:

1. If there are 50 or fewer invoices, you can directly import them into GSTR-1; but
2. If there are more than 50 invoices, you must first download the data as a ‘.CSV file,’ arrange it in the required excel format for import and then upload it to GSTR-1 online.

How to Import B2B E-Way Bill Invoices in Form GSTR-1.

To continue, select ‘IMPORT EWB DATA’’ from Table A, such as ‘4A, 4B, 4C, 6B, 6C – B2B Invoices,’ for example. A page will then be shown based on the number of invoices raised in the EWB system.

As mentioned earlier, if there are fewer than 50 invoices, you can directly import them online. Follow the steps shown below to do so:

1. Select ‘Select All’ or check the boxes next to each invoice that must be imported. To get invoices in a CSV file instead and upload them later, click on ‘Download’.
2. Then select ‘IMPORT.’
3. There will be a pop-up warning that the chosen invoices will replace any existing GSTR-1 data. Click OK to continue.
4. You’ll get a confirmation message. Close the dialogue box.
5. The import history table will appear below this window shortly, and the status will change to ‘Processed.’
6. The following information about imported invoices will be shown on the B2B tile:

Check the invoice’s specifics. If any adjustments are necessary, click the hyperlink next to the pertinent receiver detail and make the required changes. Take the below steps to file GSTR-1.

If there are more than 50 invoices but fewer than 500, you will see the following screen:

You won’t be able to import directly in this scenario. Instead, you will have to download the invoices in ‘.CSV’ format. To do that, click on ‘Download’.

To double-check all of the invoice details, open the ‘b2b.csv’ file. Before submitting the excel file, any discrepancies can be rectified using the Offline Utility. Once all invoices have been downloaded, follow the instructions for uploading an excel file.

Whenever there are more than 500 invoices: The following webpage appears:

• Select ‘Generate file for download’ to start.
• It will ask you to wait for 20 minutes.
• You will receive a link to download the file from the zipped folder after 20 minutes.
• Extract the spreadsheet file from the zipped folder you downloaded.
• To check for any inconsistencies with B2B EWB invoices, open the excel file. If there are any errors, edit the excel file and follow the instructions for uploading the invoices from the excel sheet to the GSTR-1.

Populate HSN-wise Summary of Outward Supplies

The “12 – HSN-wise-summary of outward supplies” tile’s IMPORT EWB DATA button is located there.

If there are fewer than 50 invoices, You’ll see the following page:

To download the hsn.csv file:

1. Check the document twice for errors and correct them in the downloaded spreadsheet file.
2. Observe the instructions for uploading the invoices from the excel sheet to the GSTR-1.

If there are fewer than 500 invoices, You’ll see the following page:

If there are more than 500 invoices, the same procedures for downloading B2B files should be followed.

Reporting of additional bills that are not covered by the e-way bill portal

1. Prepare Online by manually entering data: The process used to upload new invoices to GSTR-1 is the same as the process used to upload missing invoices from an e-way bill.
2. Utilise the three options listed below to prepare offline.
   • Import Excel file: Following the same procedures above, prepare the file for missing invoices in the required format.
   • Copy from excel file: Following the same procedures above, prepare the file for missing invoices in the required format.
   • Import the .csv file: One can produce a JSON-formatted file by formatting invoice data imported from a CSV file.