Bulk Invoice Generator (Excel or CSV to GST Invoices)

About the Bulk Invoice Generator (Excel or CSV to GST Invoices)

Make every invoice of a sales sheet at once. Load an Excel or CSV register (one row per item, or one per invoice and rate — from Tally, Busy, Vyapar, Zoho or your own sheet), a Shopify, WooCommerce or Amazon order export, or invoices saved by the Invoice Generator. Match the columns once — the choice is remembered — and every row is checked before anything is made: GSTIN check characters, State codes, place of supply and CGST + SGST or IGST, HSN/SAC digits, rates and totals, with the row number of each problem.

The invoices are made with the Invoice Generator’s template — your logo, signature, bank and UPI details — in the copies you need (original, duplicate, triplicate), on A4, A5 or an 80 or 58 mm thermal roll, as a ZIP of PDFs named by invoice number or one file to print, with a register CSV. Refunds in shop exports become credit notes, and each invoice can get its packing slip. Numbers can continue the Invoice Generator’s series. Documents only: nothing is e-mailed or uploaded.

Common uses

• Shops on Shopify, WooCommerce or Amazon issuing GST invoices for a day’s or a month’s orders.
• Traders whose billing software keeps the sales register but prints invoices one at a time.
• Accountants making clients’ invoices, credit notes and packing slips from one sheet.
• Counters printing receipt-style tax invoices on 80 mm or 58 mm thermal printers.

What is checked before anything is made

• GSTINs: the check character of yours and each customer’s, and that the State code matches the customer’s State.
• Place of supply and tax type: CGST + SGST within your State, IGST outside it, for SEZ supplies and exports.
• HSN/SAC codes: at least 4 digits, or 6 when your turnover is above ₹5 crore (Notification 78/2020–Central Tax), and whether a code is a service.
• Rates and amounts: GST rates that exist, quantity × price − discount = taxable value, tax = rate × taxable value, and the sheet’s invoice total.
• Numbers and dates: document numbers of up to 16 letters, digits, hyphens and slashes (rule 46(b)), rows of one invoice that disagree, and dates in the future.

Copies, paper and files

Rule 48(1) of the CGST Rules, 2017 asks for goods invoices in triplicate — the original for the recipient, the duplicate for the transporter and the triplicate for the supplier — and rule 48(2) for services invoices in duplicate, the original for the recipient and the duplicate for the supplier; each copy is printed with its label, and an invoice of services only gets those two labels whichever copies you tick. A5 pages are the A4 template at half size; thermal rolls get a receipt layout with the same particulars and, when you give a UPI ID, a UPI QR code for the amount due. The ZIP holds one PDF per document named by its number, in folders for invoices, credit and debit notes and packing slips, and register.csv lists every document with its taxes and file.

Numbering

Keep the numbers of your sheet, or give the invoices a new consecutive series in date order — rule 46(b) allows one or more series of up to 16 characters. The series counts up the last group of digits (INV/26-27/0042, INV/26-27/0043 …), credit notes are pointed at their invoices’ new numbers, and after the run the Invoice Generator can be set to continue where it ended.

Shop exports

Shopify orders exports, WooCommerce order exports and Amazon’s Merchant Tax Report are read with their own columns: prices with tax included are worked back to taxable values, shipping and discounts are spread to the right lines, cancelled orders are left out and refunds become credit notes dated as you choose. Exports have no HSN codes, so a product list (SKU or name, HSN/SAC, GST rate) fills them in; the same list settles the rate of each item in orders with more than one rate.

Limitations

• Amounts are in rupees; an invoice discount given after tax and cess on a line are not shown on the template (the run says when a sheet has them).
• On A4 and A5 the UPI ID is printed as text with the payment details; only thermal receipts carry a UPI QR code.
• E-invoices (IRN and QR code) are made by the IRP: prepare the upload with the E-Invoice JSON Generator.
• Very large runs take a while in the browser; split a year into months if the page becomes slow.

Privacy

Your sales data, logo, signature and the PDFs stay in your browser; nothing is uploaded or e-mailed. Your business details, design and column choices are kept in this browser for the next run.