Meta Pixel
LIMITED OFFERSave upto 65% today on SuperBiller Pro EditionExplore Now
Back to All Articles
GST & Compliance 6 November 2026• 7 min read

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.

S
SuperBiller Compliance Team
Verified GST & SaaS Guide
142 views
Data entry specialist converting Excel sales spreadsheets to JSON for bulk e-invoice portal upload
Data entry specialist converting Excel sales spreadsheets to JSON for bulk e-invoice portal upload
Quick Takeaway (BLUF)

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 NameBest For / Business TypeKey Characteristics
Format ASingle-item or low-variety dispatchesOne row represents one invoice with one product line. Simple and fast for bulk traders with standard single-line dispatches.
Format BMulti-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 CMulti-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 DComplex industrial & export billingAccommodates 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

  1. Visit https://einvoice1.gst.gov.in.
  2. In the top navigation, click Help ➔ Tools ➔ Bulk Generation Tools.
  3. Download your preferred template (e.g., eInvoice_Format_B.xlsm).
  4. 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 INV for Tax Invoice, CRN for Credit Note, or DBN for 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 URP for unregistered export recipients).
  • Place of Supply (POS): 2-digit state code (e.g., 27 for Maharashtra, 07 for 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

  1. Click the blue Validate button on the Excel ribbon.
  2. 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.
  3. Fix any flagged entries until the alert displays: "Validation Successful! No errors found."
  4. Click the green Prepare JSON button.
  5. 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

  1. Open your browser and log into https://einvoice1.gst.gov.in.
  2. In the left sidebar, click e-Invoice ➔ Bulk Upload.
  3. Click Choose File, select your saved .json file, and click Upload.
  4. The IRP processes the payload through its validation engine in seconds.
  5. The screen displays the summary:
    • Total Records Uploaded: 120
    • Successful IRNs Generated: 120
    • Failed Records: 0
  6. 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  │
└────────────┴─────────────────────────────┴─────────────────────────────┘
  1. 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.
  2. 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.
  3. 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 / StepGovernment Excel Bulk ToolSuperBiller Cloud POS
Data EntryManual typing or complex copy-pastingBarcode scan or 1-click select
Macro DependencyRequires desktop Microsoft ExcelCloud-native; runs on any device
Error DebuggingCryptic cell errors & manual fixesLive inline validation before save
IRN Turnaround15 to 30 minutes per batchInstant (Under 2 seconds)
QR Code PrintingManual copy of response back to printAuto-printed on A4 or 80mm thermal
E-Way Bill GenerationRequires separate Part-B batch toolSimultaneous with e-invoice
Mobile DeliveryNoneInstant 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:



Related In-Depth Guides & Recommended Reading

Expand your tax compliance and store management knowledge with these related guides from our topic cluster:

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:

Tags:#e-invoice bulk upload#excel to json tool#bulk irn generation#gepp tool#e-invoice offline
Editorial Integrity & Statutory ComplianceCBIC & GST Council Validated

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.

Related Free Indian MSME Tools100% Free
SuperBiller ERP Software

Ready to automate your GST Billing & 80mm POS?

Generate your first tax invoice in under 30 seconds. 100% offline-ready.

Get Started Free