- Login to E-invoicing Desktop Utility
- User needs to login to E-invoicing Desktop Utility using IRIS IRP Web Portal credentials
IRIS IRP Portal and input IRIS IRP web portal credentials.
For the desired output with utility tool of E-invoicing, user needs to map excel fields from source file with the fields given in E-invoicing Desktop Utility.
In this tool, separate sheet named as “Map_Generate_IRN” is available for mapping.
If user has input file is Excel (.xlsx) then in “Map_Generate_IRN” sheet in F column, firstly user needs to provide “Excel sheet name” (Cell F1) secondly the “Header row number” (Cell F2) as per the input file that is going to be used for importing data in this utility.
After this a one-time mapping of column headers of input file needs to be done in “Map_Generate_IRN” sheet corresponding to Utility Headers in Column B. If input file is Excel (.xlsx) – then Column F needs to be updated and if input File is CSV (.csv), then Column D needs to be updated. For e.g. If your column header for Buyer GSTIN is Recipient GSTIN, then in Cell F21/Cell D21 change to Recipient GSTIN.
To help taxpayers have a smooth transition to IRIS IRP utility, a default mapping NIC excel utility format mapping is already added. In case, input file of user is from ERP and is in NIC format then user can directly import data. So, this completes the process of mapping. It is a one-time activity of mapping. After completion of mapping, the user needs to import the said file in this application. See the below image. One option of import data is available. For importing data two forms of files are allowed, one “Excel” and second “.csv” file.
Import excel sheet or csv file for generating e-invoices
i. If user clicks on Import excel: Below pop-up will come
ii. If user clicks on Import .csv: Below pop-up will come
- Browse the file and provide details as asked e.g., select one option from overwrite data or don’t overwrite data.
- Then click on Upload Excel File/ Import CSV button so that data will get imported as required.
- Once data get imported successfully below pop message will come. Click on “OK”