E-Invoice › Help › Good to know

Many e-invoices at once from Excel

If your invoices are made in another program or a register, fill the Excel template (one row per item) and get one e-invoice file for all of them.

Step by step

1. Choose your business. Its GSTIN, address, city, PIN and state go into every invoice.
2. Download the Excel template. One row per item; rows with the same invoice number make one invoice.
3. Choose your Excel or CSV file. It shows Documents read, Ready and Need fixing, with the row and the problem (date, state code, GSTIN, supply type…).
4. Download the e-invoice file. Only ready invoices go in. Tick Also save these invoices in My data to print them with the IRN later.
5. Load the portal's reply. After the upload, choose the result; IRN, Ack No. and QR go onto each saved invoice.

Worked example

A sheet of 38 rows makes 12 invoices; 11 are ready, one has a wrong state code "3" (should be 03). Fix it and choose the file again: 12 ready.

Common mistakes and how to fix them

• An old .xls file. Save as .xlsx or CSV UTF-8 in Excel.

Related help

All help on E-Invoice · Help for the Nivesh Sahayak App