e-Invoice Bulk Generation Tool: How to Upload 100+ Bills via JSON
Step-by-step tutorial on using the official NIC e-Invoice Bulk Generation Tool to convert Excel invoices into JSON and generate 100+ IRNs in one batch.
Generate 100+ e-invoices simultaneously using the NIC offline Excel-to-JSON utility. Step-by-step bulk IRN creation guide for high-volume distributors.
For FMCG distributors, pharmaceutical stockists, industrial wholesalers, and e-commerce fulfillment centers in India, typing invoices one by one on the government web portal is an impossible bottleneck. When your warehouse processes 100 to 500 dispatches every afternoon, manual data entry on einvoice1.gst.gov.in invites typing errors, session timeouts, and dispatch delays.
To solve this challenge for businesses operating without high-cost enterprise ERP systems, the National Informatics Centre (NIC) and GSTN released official e-Invoice Bulk Generation Utilities.
These Excel-based macro tools allow accounts teams to copy-paste hundreds of sales invoices, validate them against the statutory INV-01 JSON schema, and generate a single batch JSON file. Uploading this file to the portal generates dozens or hundreds of verified Invoice Reference Numbers (IRNs) and signed QR codes in one seamless batch.
In this comprehensive guide, we explain how to select the right bulk template format, prepare your Excel data without errors, execute macro validation, upload the batch to the portal, and download the signed responses—along with how SuperBiller eliminates Excel files entirely through 1-click cloud synchronization.
What is the e-Invoice Bulk Generation Tool? (Direct Answer)
Quick Answer (BLUF): The e-Invoice Bulk Generation Tool is an official offline macro-enabled Excel utility provided by the NIC (einvoice1.gst.gov.in). It allows businesses to enter up to hundreds of invoice line items, validates tax calculations and HSN codes, and converts the data into a single CBIC-compliant JSON file. Uploading this JSON file to the portal generates batch IRNs and digitally signed QR codes simultaneously.
┌────────────────────────────────────────────────────────────────────────┐
│ NIC e-INVOICE BULK JSON GENERATION PIPELINE │
├────────────────────────────────────────────────────────────────────────┤
│ STEP 1: Download Official Excel Utility (Format A, B, C, or D) │
│ │ │
│ ▼ │
│ STEP 2: Enter Invoice Headers, Buyer GSTIN, HSN & Tax Amounts │
│ │ │
│ ▼ │
│ STEP 3: Click "Validate" Macro ──► Resolves missing fields & errors │
│ │ │
│ ▼ │
│ STEP 4: Click "Prepare JSON" ──► Compiles compliant .JSON batch file │
│ │ │
│ ▼ │
│ STEP 5: Log into einvoice1.gst.gov.in ➔ Bulk Upload ➔ Submit File │
│ │ │
│ ▼ │
│ SUCCESS: Portal returns 100+ IRNs, Ack Nos & Signed QR Codes in 1 sec │
└────────────────────────────────────────────────────────────────────────┘
Choosing the Right Bulk Template Format (A, B, C, or D)
The NIC portal provides four distinct offline Excel formats under the Help ➔ Tools ➔ Bulk Generation Tools menu. Selecting the wrong format is the number one cause of upload failures:
| Template Name | Best For / Business Type | Key Characteristics |
|---|---|---|
| Format A | Single-item or low-variety dispatches | One row represents one invoice with one product line. Simple and fast for bulk traders with standard single-line dispatches. |
| Format B | Multi-item invoices (Consolidated) | Each line item has its own row, but header details (Buyer GSTIN, Inv No, Date) are repeated across rows for the same bill. |
| Format C | Multi-item invoices (Separate Sheets) | Invoice headers are entered in Sheet 1, while product line items are entered in Sheet 2, linked by Document Number. |
| Format D | Complex industrial & export billing | Accommodates multi-currency exports, SEZ supplies, dispatch-from/ship-to addresses, and advance payment references. |
[!TIP] For most Indian distributors and wholesalers selling multiple items per bill, Format B or Format C is the most reliable and easiest to populate from standard accounting exports.
Step-by-Step Tutorial: Preparing & Uploading Bulk e-Invoices
Follow this sequential workflow to generate batch IRNs without encountering validation rejections:
Step 1: Download & Enable Macros
- Visit https://einvoice1.gst.gov.in.
- In the top navigation, click Help ➔ Tools ➔ Bulk Generation Tools.
- Download your preferred template (e.g.,
eInvoice_Format_B.xlsm). - Open the file in Microsoft Excel. When the security warning appears at the top, click Enable Content (or Enable Macros). Without macros enabled, the tool cannot compile JSON payloads.
Step 2: Populate Master Business Details
Go to the Profile or Welcome tab and enter your:
- 15-Digit Supplier GSTIN
- Legal Name & Trade Name
- Registered Address, Pin Code, and State Code
- Document Series prefixes
Step 3: Enter Invoice Data Accurately
Switch to the e-Invoice Details sheet and enter your transaction particulars. Adhere strictly to the government formatting rules:
- Document Type: Enter
INVfor Tax Invoice,CRNfor Credit Note, orDBNfor Debit Note. - Document Number: Maximum 16 characters (letters, numbers, hyphens
-, and slashes/). - Document Date: Strict format:
DD/MM/YYYY(e.g.,06/11/2026). - Buyer GSTIN: 15-character valid registered GSTIN (or
URPfor unregistered export recipients). - Place of Supply (POS): 2-digit state code (e.g.,
27for Maharashtra,07for Delhi). - HSN Codes: Minimum 4 digits for turnover up to ₹5 Crore; minimum 6 digits for turnover exceeding ₹5 Crore.
Step 4: Run Validation & Prepare JSON
- Click the blue Validate button on the Excel ribbon.
- The macro executes client-side schema checks. If an error is detected (such as a missing state code or incorrect decimal round-off), the utility highlights the problematic cells in red and provides an error log.
- Fix any flagged entries until the alert displays: "Validation Successful! No errors found."
- Click the green Prepare JSON button.
- Choose a save location on your computer and save the generated file (e.g.,
Bulk_Invoices_06Nov.json).
Step 5: Upload JSON File to the e-Invoice Portal
- Open your browser and log into https://einvoice1.gst.gov.in.
- In the left sidebar, click e-Invoice ➔ Bulk Upload.
- Click Choose File, select your saved
.jsonfile, and click Upload. - The IRP processes the payload through its validation engine in seconds.
- The screen displays the summary:
- Total Records Uploaded: 120
- Successful IRNs Generated: 120
- Failed Records: 0
- Click Download Response File (or Download Excel) to export the generated 64-character IRNs, Ack Numbers, Ack Dates, and Signed QR Codes back into your records.
Top 5 Bulk Upload Errors & How to Fix Them
┌────────────────────────────────────────────────────────────────────────┐
│ COMMON BULK JSON REJECTION CODES │
├────────────┬─────────────────────────────┬─────────────────────────────┤
│ Error Code │ Government Description │ Immediate Correction │
├────────────┼─────────────────────────────┼─────────────────────────────┤
│ Error 2150 │ Duplicate IRN found │ Document number already used│
│ Error 2188 │ HSN Code not in Master │ Check 6-digit CBIC master │
│ Error 2175 │ Value Mismatch in Totals │ Round-off mismatch > ₹1 │
│ Error 2283 │ Invalid Recipient GSTIN │ Buyer GSTIN cancelled │
│ Error 2265 │ Invoice date older > 30 days│ Past 30-day reporting lock │
└────────────┴─────────────────────────────┴─────────────────────────────┘
- Error 2175: "Total invoice value mismatch": The sum of item taxable amounts, CGST, SGST, IGST, cess, and round-offs must match the header total down to the exact paise. Use our Free GST Calculator to recalculate item totals before generating JSON.
- Error 2150: "Duplicate IRN": Occurs when you accidentally re-upload an invoice number that was already registered earlier in the financial year. Change the document number or remove the duplicate row.
- Error 2265: "Document date cannot be older than 30 days": Mandated taxpayers with turnover ₹10 Crore+ cannot upload bills dated older than 30 days. Adjust the invoice issue date.
Bulk Excel Uploads vs SuperBiller 1-Click Automated Billing
While the official Excel macro utility is free, running manual spreadsheets every afternoon carries severe operational overhead:
| Feature / Step | Government Excel Bulk Tool | SuperBiller Cloud POS |
|---|---|---|
| Data Entry | Manual typing or complex copy-pasting | Barcode scan or 1-click select |
| Macro Dependency | Requires desktop Microsoft Excel | Cloud-native; runs on any device |
| Error Debugging | Cryptic cell errors & manual fixes | Live inline validation before save |
| IRN Turnaround | 15 to 30 minutes per batch | Instant (Under 2 seconds) |
| QR Code Printing | Manual copy of response back to print | Auto-printed on A4 or 80mm thermal |
| E-Way Bill Generation | Requires separate Part-B batch tool | Simultaneous with e-invoice |
| Mobile Delivery | None | Instant automated WhatsApp PDF |
With SuperBiller, you never have to wrestle with Excel macros or JSON upload queues. The platform sends each bill to the government IRP behind the scenes via encrypted APIs, printing beautiful tax receipts with active signed QR codes instantly.
Free SuperBiller Business Utilities
SuperBiller offers a complete ecosystem of free web tools designed to keep your shop, warehouse, and accounting desk productive:
- Online GST Invoice Generator — Create compliant tax invoices with automatic tax rate calculation.
- Free GST Calculator — Calculate base price and tax fractions across 5%, 12%, 18%, and 28% slabs.
- Delivery Challan Generator — Generate transport delivery challans compliant with Rule 55.
- Credit Note Generator — Issue Section 34 compliant GST credit notes for sales returns.
- Cash Counter Calculator — Count cash drawer currency notes instantly at daily closing.
Related In-Depth Guides & Recommended Reading
Expand your tax compliance and store management knowledge with these related guides from our topic cluster:
- How to Verify B2B e-Invoice Signed QR Code Using Official App – Essential compliance rules, practical calculations, and step-by-step guidance.
- Direct e-Invoice API Integration: Auto-Generate IRN from Billing App – Essential compliance rules, practical calculations, and step-by-step guidance.
- e-Invoice System Login: Common Password & OTP Issues Fixed – Essential compliance rules, practical calculations, and step-by-step guidance.
- GST e-Invoice Portal (einvoice1.gst.gov.in): Complete 2026 Login, Registration, IRN & Error Troubleshooting Guide – Essential compliance rules, practical calculations, and step-by-step guidance.
Frequently Asked Questions (FAQs)
What is the maximum number of invoices that can be uploaded in one bulk JSON file?
The official NIC bulk generation utility supports compiling up to 500 invoices (or 10,000 item line details) into a single JSON batch file for upload on einvoice1.gst.gov.in.
Can I use OpenOffice or Google Sheets to run the bulk generation tool?
No. The official bulk generation utilities rely on Microsoft Visual Basic for Applications (VBA) macros that are only fully supported in desktop versions of Microsoft Excel (Excel 2010 or higher). Google Sheets and OpenOffice cannot execute these macros.
How do I print invoices after generating IRNs through the bulk tool?
After uploading the JSON file, download the signed JSON response from the portal. You can then use the portal's Print e-Invoice utility by entering the Ack Number, or import the response file back into your billing software to print batch PDFs.
What should I do if half of the invoices in my bulk upload fail?
The portal generates IRNs for all valid invoices in the batch and outputs an error log for the rejected records. Download the error spreadsheet, rectify only the failed rows in your Excel utility, generate a fresh JSON file containing the corrected invoices, and re-upload.
Does the bulk tool generate e-Way Bills at the same time?
Yes. If you populate the optional transporter details (Transporter ID, Vehicle Number, Transport Mode) in the Excel utility, the IRP will generate both the IRN and e-Way Bill number simultaneously in the response file.
Regulatory References & Official Software Standards
For business accounting mandates, digital security standards, and statutory audit compliance, refer to the following official resources:
- Ministry of Corporate Affairs (MCA):
- MCA Company Law & Audit Trail Mandate — Statutory requirements for accounting software with un-editable audit logs
- Indian Computer Emergency Response Team (CERT-In):
- CERT-In Cybersecurity Guidelines — Best practices for enterprise data protection, ransomware prevention, and software integrity
- Ministry of Electronics and Information Technology (MeitY):
- Information Technology Act, 2000 Provisions — Legal implications of unlicensed/cracked software and data privacy compliance
- GST Common Portal (GSTN):
- GST Portal Technical Architecture — Official standards for GST invoicing, GSTR-1 JSON schema, and API integrations
- Ministry of MSME:
- Digital MSME Scheme — Cloud software adoption and digital business transformation guidelines
This guide is authored by the SuperBiller Tax & Retail Operations Desk and fact-checked against official Central Board of Indirect Taxes and Customs (CBIC) circulars, the CGST Act 2017 (Rule 46 & Section 31), and latest GST Council threshold updates. SuperBiller provides MSMEs with compliant billing technology, 80mm thermal printing, and automated tax workflows.
Ready to automate your GST Billing & 80mm POS?
Generate your first tax invoice in under 30 seconds. 100% offline-ready.