How to import invoices from the e-way bill site to GSTR-1?

Whenever necessary, import invoice information from the e-way bill gateway to create GSTR-1. The article is a go-to resource for information on how to import sales invoice facts from an e-way bill website to generate GSTR-1.

For taxpayers who deal with commodities and generate e-way bills for their transportation, the option on the GST portal provides much-needed assistance. These taxpayers can now combine the portals for managing e-way bills on ewaybill.gst.gov.in and filing GST returns on gst.gov.in

 

Reasons to introduce the option to import e-way bill data to GSTR-1.

Until now, while filing GSTR-1, taxpayers had to upload invoices twice: once on the e-way bill website and once on the GST portal. The same data had to be imported twice onto various portals, causing unnecessary trouble for taxpayers. To prevent this, the option to "Import EWB data'' for three tiles has been introduced to the GSTR-1 filing dashboard. It will lessen data entry errors for taxpayers and aid tax officials in their efforts to detect tax evasion.

What details can be imported from the e-way bill site?

From the e-way bill website, the following tiles or tables can be imported into GSTR-1:

• B2B invoices 4A, 4B, 4C, 6B, and 6C provide invoice-by-invoice data of sales transactions between GST-registered individuals.

• 5A, 5B- B2C (Large) Invoices- Invoice-by-invoice information on sales transactions made by GST-registered people to unregistered people, whether they took place outside their home states or when the invoice value exceeded Rs 2.5 lakh.

• 12- HSN-wise-summary of Outward Supplies—A summary of all Outward Supplies' HSN-wise invoice information.

 

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

1. If there are 50 or fewer invoices, import them immediately into GSTR-1.

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.

Download and Import data from the E-way website

Step 1: Go to the "Returns Dashboard" after logging into the GST Portal. Choose the month and fiscal year for the return period, then click "PREPARE ONLINE" to go to the GSTR-1 tile. Proceed to enter the data.

 

 

Choose the month and fiscal year for the return period, then click "PREPARE ONLINE" to go to the GSTR-1 tile. Proceed to enter data.

 

 

Step 2: To import invoices from an e-way bill website, select the relevant tile A, B, or C from the list above. 

 

 

If an invoice already exists in GSTR-1, a warning notice will appear asking if you want to replace the existing document. However, an invoice can be imported numerous times from the e-way bill system to GSTR-1. If you want to continue importing by replacing any current invoices, select "Yes."

 

Step 3: Import e-way bill data into the appropriate tiles A, B, or C, then carry out the remainder of the GSTR-1 filing.

 

• B2B e-way bill invoices can be imported into GSTR-1- Tile A.

• B2CL e-way bill invoices should be imported into GSTR-1-Tile B.

• Fill in the HSN Summary on the e-way bill website in Tile C of GSTR-1.

To import B2B EWB invoices in Form GSTR-1.

 

To continue, select "IMPORT EWB DATA '' from tile 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. If there are fewer than 50 invoices: Direct online import is possible because there are fewer than 50 invoices. Take the actions outlined below:

• 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 later, click Download.

• Then select "IMPORT."

• There will be a pop-up warning that the chosen invoices will replace any existing GSTR-1 data. Click OK to continue.

• You'll get a confirmation message. Close the dialogue box.

• The import history table will appear below this window shortly, and the status will change to "Processed."

• 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:

 

 

• Direct online import is not feasible in this situation. To download all the files in.csv format, click 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 a 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.

To import B2CL EWB invoices in Form GSTR-1.

In tile B, "5A, 5B - B2C (Large) Invoices," click IMPORT EWB DATA. Follow the same procedures for importing B2B invoices if there are fewer than 50 invoices.

 

If there are more than 50 invoices but fewer than 500, You'll see the following page:

 

 

To get the B2Cl file:

1. Click Download.

2. Check the document twice for errors and correct them in the downloaded spreadsheet file.

3. Observe the instructions for uploading the invoices from the excel sheet to the GSTR-1.

 

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

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.

What to do after downloading the invoices in excel?

The taxpayer must first download the invoices in excel if there are more than 50 invoices. In such circumstances, the direct import to GSTR-1 option is not accessible. There are two alternatives to uploading invoices from an excel file to a GSTR-1.

 

Option one

Excel workbook import using an offline utility tool

 

Step 1: Create the following format by importing an Excel file:

 

 

Step 2: Click the Import Files button on the returns offline tool.

 

 

Step 3:  Select the worksheet by browsing and clicking the Import Excel button.

 

Step 4: Select Yes to continue.

 

 

You'll get a notification verifying the import's success.

 

Step 5:  To view the excel invoices displayed on the screen, click the Back button.

 

 

Uploaded data can be deleted or edited using the corresponding buttons on the screen.

 

Option 2 

Pasting from an Excel workbook

 

Step 1:  Copy the header portion and the data from the downloaded Excel worksheet after editing it according to the recommended return format.

 

Step 2:  On the returns offline tool, select Import Files and then click Copy Excel.

 

 

You'll get a confirmation in return. You will see the invoices from the excel file uploaded to the screen after selecting "Yes" to save the data.

 

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

 

There are two ways to upload unaccounted-for invoices:

 

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.