Hello All. In this post, we will see the import of E-Invoicing details to Saral GST from Excel file.
CBIC notified that GST e-invoicing for B2B transactions is mandatory for any business whose turnover exceeds Rs 100 crore from January 1, 2021. The limit set earlier was only for turnover above Rs 500 crore.
In a recent interview with PTI, Finance Secretary Mr.Ajay Bhushan Pandey said that e-invoice would be mandatory from April 1st, 2021 for all the B2B transactions by businesses with a turnover of over Rs. 5 crores.
E-Invoicing details entry in Saral GST can be made directly to the software or can be imported from an Excel file.
To know on the direct entry of details in Saral GST read below :
Now, we will see the step-by-by the procedure for excel import.
Excel Import of E-Invoicing can be done in two ways:
- Using Saral GST Template
- Using a user-defined template
Firstly, let us see importing details using Saral GST template. Go to Excel Import under E-Invoice menu and enable Select Default (Saral GST) Template in Excel import window.
Click on Template and the excel template will be opened for entry. Do the entries of invoices in E-Invoice sheet of the template and save the template.
After saving, in Excel Import window of Saral GST, trace the excel file with details and click on Import. The details in the excel file will be imported to Saral GST.
The second process of Excel import is using a self-defined template. To create a self-defined template, go Excel Import under E-Invoice menu and click on Template. The E-Invoice Template Mapping window will be displayed.
Now name the template and enter the starting row the excel file from where the data has to be imported. Next, select the details that will be imported from the list available in the left-hand side and move them to the right-hand side block with naming the column for each data as in Excel.
Note: Default format is available which can be used to load the mandatory data columns. The Excel column name for such list has to be modified according to the data excel file.
After adding all the data columns, save the template. Go to the Excel Import window and select the user-created template and trace the excel file in which data is available. Import this detail to Saral GST.
To upload the imported invoices to IRP, click on View/Upload under E-Invoice menu.
This is the screen, select the date range for invoice to be displayed and click on Go. All the invoices for the selected date range (Uploaded and not-uploaded) will be displayed.
Note: If the invoice is already uploaded, then the IRN details will be displayed against the particular invoice. Also, if the invoice is cancelled, then the cancelled information will also be displayed.
Select the invoices to be uploaded and click on Create JSON. On the successful generation of JSON file, click on Upload which will upload the details to IRP Portal.
On successful upload, the IRN will be generated the details will be updated against the invoice. After the IRN generation, the E-Invoice can be generated by click on Print. The PDF copy of the invoice will be generated for all.
Now click on Open PDF Folder where all the E-Invoice can be viewed. Open the required PDF to view the Invoice. The invoice will contain QR code as given by the IRP portal.
On click on Send eMail, the invoice will be mailed to the consider dealer.
This completes the process of importing invoice details from excel for E-Invoicing in Saral GST.