How to Prepare Invoice Data for Bulk Processing

Quick answer: Keep one row per invoice or challan in a master sheet, with items in a linked sheet, then validate GSTINs, PINs and HSN codes and remove duplicates. Enter the clean data into the official Bulk Generation Tools to create the JSON file, because the portal does not accept your own Excel sheet as it is.

Bulk processing — uploading many invoices at once instead of entering them one by one — saves real time for businesses with high dispatch volumes. But bulk processing has a catch: it multiplies whatever is in your data. One wrong PIN code typed by hand is one problem. The same wrong PIN pasted into forty rows is forty problems.

This guide is about the step before the upload: getting invoice data into a structured, checked, duplicate-free sheet. It applies whether you are preparing a file for bulk e-way bill generation on the official portal, sharing data with your accountant for GST returns, or importing into accounting software.

How bulk e-way bill generation works, in brief

The official e-way bill portal offers a bulk generation facility. In general terms:

1. You download the official Bulk Generation Tools (an Excel-based utility) from the portal.
2. You fill or paste your consignment data into the tool in its prescribed format.
3. The tool converts the data into a JSON file.
4. You upload the JSON file on the portal, which generates e-way bills for valid rows and reports errors for the rest.

Large taxpayers may instead use API access through a GSP or ERP integration. The exact columns, codes and limits are defined by the official tool and documentation, so always use the current version from the portal. Our guide on how to generate bulk e-way bills walks through the portal side.

Everything below is about making the data you feed into that tool correct.

Step 1: Use one row per document, one sheet per purpose

Keep a master sheet where each row is one invoice or delivery challan. If an invoice has several items, keep item details in a second sheet linked by the document number. Mixing header and item data in one row leads to copy errors.

Suggested header columns

Suggested item columns

Document number (link), product name, HSN code, quantity, unit, taxable value, tax rate.

Step 2: Run validation checks before upload

You can do most of these with simple spreadsheet formulas or filters.

Format checks

• GSTIN length is 15 characters. =LEN(A2)=15
• GSTIN state code matches the state column. The first two digits are the state code.
• PIN code is 6 digits and the first digit is plausible for the state.
• HSN code has the right number of digits for your turnover requirement, and contains only numbers.
• Dates are real dates, not text. Sort by date; text dates will sort oddly.
• Vehicle numbers follow one format (e.g. remove spaces and hyphens consistently).

Logic checks

• Tax heads: if dispatch and delivery states are the same, IGST should be 0; if they differ, CGST and SGST should be 0. See CGST, SGST and IGST explained.
• Totals add up: taxable value + tax = total value, within rounding.
• Item totals equal header totals for each document.
• Threshold: flag rows where total value is at or below the threshold, so you do not generate unnecessary e-way bills (unless your case needs one at any value, such as interstate job work).
• Document age: as reported by GSTN, from 1 January 2025 e-way bills cannot be generated for documents dated more than 180 days before generation. Flag old dates.
• Distance sanity: distance should not exceed the 4,000 km maximum, and should be roughly in line with the PIN-to-PIN route.

Note: Use the HSN code lookup and GST calculator to spot-check a sample of rows. For GSTINs, verify new buyers on the GST portal once and then reuse saved details.

Step 3: Remove duplicates

Duplicates are the most expensive bulk error, because a duplicated row can create a second e-way bill for the same goods, which then has to be cancelled within 24 hours.

How to find them:

1. Exact duplicates: use your spreadsheet's remove-duplicates feature on the document number + supplier GSTIN columns, but review before deleting.
2. Near duplicates: sort by recipient GSTIN, then by value and date. Two rows with the same buyer, same value and same date but different document numbers deserve a second look.
3. Already processed: keep a column for "E-way bill number". Before each upload, filter out rows that already have one.

Step 4: Freeze, convert, upload, reconcile

1. Freeze the data. Once checks pass, save a dated copy. Don't edit the source after this point.
2. Copy into the official tool and generate the JSON.
3. Upload on the portal.
4. Reconcile results: bring the generated e-way bill numbers back into your sheet against each document. Fix rejected rows at the source and re-run checks before uploading them again.

Example (illustrative)

A Morbi ceramic tiles trader prepares 62 invoices for a day's dispatches. Before upload, the checks find:

After fixing 7 rows, removing 2 duplicates and excluding 9 small invoices, 51 rows go into the bulk tool. All generate on the first upload, and the e-way bill numbers are pasted back against each invoice.

Common mistakes

• Mixing formats (dates as text in some rows, real dates in others).
• Leaving formulas live in the upload sheet, so values change after checks.
• Pasting from emails or PDFs without cleaning stray spaces and line breaks.
• Using the billing PIN instead of the delivery PIN.
• Not keeping the generated e-way bill numbers next to the source rows, making cancellations and audits harder.
• Using an old version of the bulk tool. Formats change; download the current one.

Where E-Way Easy fits

The E-Way Easy Android app is designed for creating invoices and e-way bill workflows one consignment at a time on a phone, with saved buyers and products, HSN from the product and PIN-based distance. It does not offer bulk generation. For high-volume bulk uploads, use the official portal's bulk facility or an authorised API integration. Clean masters, wherever you keep them, are what make either approach work.

Official sources

Download the current bulk tool and read the format notes on the E-Way Bill System and its user documentation. For GSTIN checks and return-related formats, see the GST portal.