How To Use IMPORT EWB DATA Function In GSTR-1 - Full Explain

How To Use IMPORT EWB DATA Function In GSTR-1 - Full Explain

How can I import invoice-details, declared in e-Way Bill System, into Form GSTR-1?

To import invoice-details, declared in e-Way Bill System, into Form GSTR-1; perform following steps:

1. Login at GST Portal, navigate to GSTR-1 page of the selected tax period and generate GSTR-1 Summary

2. Import invoices, declared in e-Way Bill System, into the following three tiles of the generated GSTR-1 Summary page:

I. 4A, 4B, 4C, 6B, 6C - B2B Invoices (To import invoice-details for taxable outward supply transactions between registered taxable entities/persons from e-Way Bill System)

II. 5A, 5B - B2C (Large) Invoices (To import invoice-details for taxable outward inter-State supply transactions between a Registered Supplier and an Unregistered Buyer, where the invoice value is more than Rs 2.5 lakh, from e-Way Bill System)

III. 12 - HSN-wise-summary of Outward Supplies (To download the summarized HSN-wise invoice-details of all outward supplies)

I. 4A, 4B, 4C, 6B, 6C - B2B Invoices

To import B2B EWB invoices in the Form GSTR-1, perform following steps:

1. Click the IMPORT EWB DATA button in the "4A, 4B, 4C, 6B, 6C - B2B Invoices" tile.

Note: EWB details will be available in GST portal based on the e-Way bills pertaining to outward supply raised during the relevant tax period.

2. Based on the number of invoices of current tax period present in the EWB System, a page will be displayed.

2a. If the number of invoices are less than or equal to 50

2b. If the number of invoices are more than 50 but less than or equal to 500

2c. If the number of invoices are more than 500

2a.If the number of B2B EWB invoices are less than or equal to 50

If the number of invoices are less than or equal to 50, following page gets displayed. Perform the steps as mentioned below or click the BACK button to go to the previous page.

2a(i). If required, click the DOWNLOAD button to download the invoices in CSV format or go to step 2a(ii) to import the data.

2a(ii). Select all the invoices by selecting the All selection box or select the selection boxes against the invoices to be imported. As you make your selection, the "IMPORT" button gets enabled. Click the IMPORT button.

2a(iii). An Information popup is displayed. Click the OK button.

2a(iv). A Success popup is displayed. Click the CLOSE button.

2a(v). After a few minutes, click the refresh button on the top and processing Status gets displayed in the "Import History" table.

Note: In case the invoices are processed with error, error report gets generated in JSON format, which can be viewed in the Offline tool to correct the same. Please click here. to view the step-by-step instructions on how to do this in the "Open Downloaded Error File – GSTR1" section of the Offline Tool Manual.

2a(vi). Click BACK and the imported B2B EWB invoice details would be reflected in the tile.

2a(vii). Click the tile to cross-check all the processed invoices. The imported B2B EWB invoice would be listed on the top of the "Processed Invoices" list.

2a(viii). To edit the imported B2B EWB processed invoice, click its hyperlink in the "Receiver Details" column.

2a(ix). The B2B Invoices-Summary page is displayed. Click the Edit button in the "Actions" column or the hyperlink in the "Invoice No." column to make changes to the invoice.

Note: Make sure you duly enter any supply detail. which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

2b. If the number of B2B EWB invoices are more than 50 but less than or equal to 500

If the number of invoices are more than 50 but less than or equal to 500, following page gets displayed. Perform the steps as mentioned below or click the BACK button to go to the previous page.

2b(i). Click the DOWNLOAD button. A "b2b.csv" file gets downloaded as shown below.

2b(ii). To view the downloaded B2B EWB invoices, click on the downloaded b2b.csv sheet to open it. To upload these B2B EWB invoices using the offline utility,

Note: Make sure you duly enter any supply detail. which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

2c. If the number of B2B EWB invoices are more than 500

If the number of invoices are more than 500, following page gets displayed. Perform the steps as mentioned below or click the BACK button to go to the previous page.

2c(i). Click the GENERATE FILE TO DOWNLOAD button.

2c(ii). A message asking you to wait for 20 minutes gets displayed.

2c(iii). After 20 minutes, another message is displayed and a download link is also provided below the GENERATE FILE TO DOWNLOAD button. Click the link to download a zipped folder containing the B2B EWB invoices in excel format.

2c(iv). Right-click on the zipped folder and click Extract All.

2c(v) Unzipped Excel File gets displayed. Click it to open it.

2c(vi). The downloaded B2B EWB invoices get displayed. To upload these invoices using the offline utility, follow the steps mentioned here.

Note: Make sure you duly enter any supply detail which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

Go back to the Main Menu

II. 5A, 5B - B2C (Large) Invoices

To import B2CL EWB invoices in Form GSTR-1, perform the following steps:

1. Click the IMPORT EWB DATA button in the "5A, 5B - B2C (Large) Invoices" tile.

Note: EWB details will be available in GST portal based on the e-Way bills pertaining to outward supply raised during the relevant tax period.

2. Based on the number of invoices of current tax period present in the EWB System, a page will be displayed. 

2a. If the number of invoices are less than or equal to 50

2b. If the number of invoices are more than 50 but less than or equal to 500

2c. If the number of invoices are more than 500

2a. If the number of invoices are less than or equal to 50

If the number of invoices are less than or equal to 50, following page gets displayed. Perform the same steps you would have performed to import B2B invoices, as mentioned here.

Note: Make sure you duly enter any supply detail. which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

Go back to the Main Menu

2b. If the number of B2CL EWB invoices are more than 50 but less than or equal to 500

If the number of invoices are more than 50 but less than or equal to 500, following page gets displayed. Perform the steps as mentioned below.

2b(i). Click the DOWNLOAD button. A "b2cl.csv" file gets downloaded as shown below.

2b(ii). To view the downloaded B2Cl EWB invoices, click on the downloaded b2cl.csv sheet to open it. To upload these B2CL EWB invoices using the offline utility,

Note: Make sure you duly enter any supply detail. which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

Go back to the Main Menu

2c. If the number of B2CL EWB invoices are more than 500

If the number of B2CL EWB invoices are more than 500, following page gets displayed. Perform the same steps you would have performed to import B2B invoices, as mentioned here.

Note: Make sure you duly enter any supply detail which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

III. 12 - HSN-wise-summary of Outward Supplies

To import HSN-wise EWB invoices in the Form GSTR-1, perform the following steps:

1. Click the IMPORT EWB DATA button in the "12 - HSN-wise-summary of outward supplies" tile.

Note: EWB details will be available in GST portal based on the e-Way bills pertaining to outward supply raised during the relevant tax period.

2. Based on the number of invoices of current tax period present in the EWB System, a page will be displayed. Click the following hyperlinks to know what happens in each case:

2a. If the number of invoices are less than or equal to 50

2b. If the number of invoices are more than 50 but less than or equal to 500

2c. If the number of invoices are more than 500

2a. If the number of HSN-wise EWB invoices are less than or equal to 50

If the number of HSN-wise EWB invoices are less than or equal to 50, following page gets displayed. Perform the steps as mentioned below or click the BACK button to go to the previous page.

2a(i). Click the DOWNLOAD button. An "hsn.csv" file gets downloaded as shown below.

2a(ii). To view the downloaded HSN-wise EWB invoices, click on the downloaded hsn.csv sheet to open it. To upload these invoices using the offline utility, please follow the steps mentioned here.

Note: Make sure you duly enter any supply detail. which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

Go back to the Main Menu

2b. If the number of HSN-wise EWB invoices are more than 50 but less than or equal to 500

If the number of HSN-wise EWB invoices are more than 50 but less than or equal to 500, following page gets displayed.

Perform the steps as mentioned below.

2b(i). Click the DOWNLOAD button. An "hsn.csv" file gets downloaded as shown below.

2b(ii). To view the downloaded HSN-wise EWB invoices, click on the downloaded hsn.csv sheet to open it. To upload these invoices using the offline utility, please follow the steps mentioned here.

Note: Make sure you duly enter any supply detail. which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

Go back to the Main Menu

2c. If the number of HSN-wise EWB invoices are more than 500

If the number of HSN-wise EWB invoices are more than 500, following page gets displayed. Perform the same steps you would have performed to import B2B invoices, as mentioned here.

Note: Make sure you duly enter any supply detail which was not covered in the e-Way Bill data, against the relevant tab separately in Form GSTR-1 before filing.

LIKE OUR FACEBOOK PAGE FOR GST NEWS:- https://www.facebook.com/latestgstnews/

READ ALSO:- कतर (Qatar) जीएसटी (GST) में प्राकृतिक गैस को शामिल करना चाहता है - GST NEWS