Hello All. In this post, we will see the import of  E-Invoicing details to Saral GST from Excel file.

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 :

https://www.saralgst.com/tutorials/e-invoice-generation-through-saral-gst/

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.

1. E-Invoicing details-default

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.

2. E-Invoicing details-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.

3. E-Invoicing details-Import

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.

4. E-Invoicing details-Mapping

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.

5. E-Invoicing details-Left handed

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.

6. E-Invoicing details-note

To upload the imported invoices to IRP, click on View/Upload under E-Invoice menu.

7. E-Invoicing details-Upload

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.

8. E-Invoicing details-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.

9. E-Invoicing details-JSON

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.

10. E-Invoicing details-Print

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.

11. E-Invoicing details-PDF

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.

E-invoicing Simplified!

If you are a business with more than 100 crore in revenue, then wait no more! Start using Saral today and make your transition and e-invoicing process effortless.

Leave a Reply

Your email address will not be published. Required fields are marked *