GST Invoice Template Pack Free Excel with 6 Formats

Every invoice format an Indian business needs, in one Excel file. Tax Invoice, Bill of Supply, Export Invoice, Credit Note, Invoice Register, and a ready HSN/SAC code reference. All compliant with Rule 46 of CGST Rules, 2017. Updated for FY 2026-27.

  • Auto-detects intra-state vs inter-state from state codes, splits tax as CGST + SGST or IGST
  • 50+ common HSN/SAC codes with correct GST rates built in
  • Invoice Register sheet ready for GSTR-1 filing prep
No spam. Instant download link to your email.
Petpooja presents
GST Invoice Template Pack
For Indian Businesses
6
Formats in one Excel file
FY 2026-27
What's Inside

Six invoice formats covering every GST scenario.

01

Tax Invoice (B2B)

Standard GST tax invoice with all 16 mandatory fields per Rule 46, CGST Rules, 2017. Seller and buyer GSTIN, HSN codes, quantity, rate, taxable value, and auto-calculated CGST + SGST or IGST. Enter your business details once on the Instructions sheet, and they auto-populate across all invoice formats.

02

Bill of Supply

For Composition Scheme dealers (Section 10, CGST Act) and exempt supplies. No tax breakup columns since composition dealers can't charge GST on invoices. Includes the mandatory declaration text.

03

Export Invoice

For exports and SEZ supplies. Fields for port code, shipping bill number, IEC code, AD code, and LUT/Bond ARN. Dropdown to select "Export with IGST" or "Export under LUT/Bond" per your setup.

04

Credit Note / Debit Note

For returns, rate corrections, or post-sale discounts. Links back to the original invoice number and date. Dropdown for reason (goods returned, excess charged, deficiency in services). Compliant with Section 34, CGST Act.

05

Invoice Register

Monthly sales register to track every invoice you issue. Records invoice number, buyer GSTIN, supply type, taxable value, and tax amounts. Includes an HSN-wise summary section. Makes GSTR-1 filing 10x faster.

06

HSN / SAC Code Reference

50+ commonly used HSN codes (goods) and SAC codes (services) with descriptions and applicable GST rates. Covers food, retail, electronics, garments, pharmaceuticals, IT services, hospitality, transport, and more.

Why This Matters

The Invoice Formatting Problem Indian Businesses Face Every Day

You sell goods to a buyer in another state. You charge CGST + SGST instead of IGST. The buyer can't claim Input Tax Credit. Now you need to issue a credit note, revise the invoice, and re-file your GSTR-1. One wrong field on one invoice just cost you half a day.

This happens more often than you'd think. According to CBIC data, a significant portion of GST notices issued to small businesses relate to invoice discrepancies: wrong GSTIN, missing HSN codes, incorrect place of supply, or mismatched tax rates.

The rules aren't optional. Rule 46 of the CGST Rules, 2017 lists 16 mandatory fields for every tax invoice. Miss even one, and the buyer loses ITC eligibility. Your invoice becomes a compliance liability instead of a payment document.

Here's what makes it tricky for Indian SMEs. A grocery store in Ahmedabad selling to a buyer in Rajasthan needs IGST. The same store selling to a local restaurant needs CGST + SGST. A composition dealer can't charge tax at all. An exporter needs entirely different fields like port code, shipping bill number, and LUT reference.

Most businesses either use a single generic format (and get it wrong for edge cases) or pay for billing software they don't fully need yet. This template pack gives you all six formats in one file, with the right fields pre-built for each scenario. The formulas handle the tax calculations. You just fill in the item details.

Sample Preview

What the Tax Invoice sheet looks like for a sample B2B sale.

Here's a preview of the Tax Invoice format with sample grocery items:

Seller GSTIN: 27AABCT1234A1ZV (Maharashtra) with full business name, address, and state code pre-formatted
Buyer GSTIN + Place of Supply: Enter the buyer's state code. Supply Type auto-detects as "Intra-State" or "Inter-State." CGST+SGST columns fill for same-state, IGST column fills for different-state. Change the buyer state code and watch it switch instantly.
Item Line (Basmati Rice): HSN 1006 | Qty: 50 Kg | Rate: ₹120 | Taxable: ₹6,000 | CGST 2.5%: ₹150 | SGST 2.5%: ₹150 | Total: ₹6,300
Item Line (Packaging Material): HSN 4819 | Qty: 200 Pcs | Rate: ₹12 | Taxable: ₹2,400 | CGST 9%: ₹216 | SGST 9%: ₹216 | Total: ₹2,832
Grand Total: Auto-summed with taxable value, CGST total, SGST total, and invoice value. Bank details and terms section below.
... plus Bill of Supply, Export Invoice, Credit/Debit Note, Invoice Register, and HSN Reference across 6 sheets.
Key Stats

Why correct GST invoicing matters.

16 fields

Every tax invoice must carry 16 mandatory fields under Rule 46 of CGST Rules, 2017. Missing any field can result in the buyer losing Input Tax Credit on that purchase.

Source: Rule 46, CGST Rules, 2017
₹5 Cr

E-invoicing is mandatory for all businesses with aggregate turnover exceeding ₹5 crore, as per Notification No. 10/2023-Central Tax dated 10-May-2023. Below this threshold, this Excel template works perfectly.

Source: CBIC Notification 10/2023-CT
₹10,000+

Minimum penalty per offence for issuing incorrect invoices or failing to issue invoices. Under Section 122(1) of the CGST Act, the penalty is the higher of ₹10,000 or the tax amount involved. For high-value invoices, that exposure multiplies fast.

Source: Section 122(1), CGST Act, 2017
Common Mistakes

7 GST Invoice Mistakes Indian Businesses Make

01

Charging CGST + SGST on inter-state sales

If your state code and the buyer's state code are different, it's inter-state supply. You must charge IGST, not CGST + SGST. Getting this wrong means the buyer can't claim ITC properly, and you'll need to issue a credit note.

02

Using wrong or missing HSN/SAC codes

HSN codes are mandatory on B2B invoices for all businesses (4-digit HSN if turnover is up to ₹5 crore, 6-digit HSN above ₹5 crore). Using the wrong code means wrong GST rate, which means wrong tax collected. The GST portal flags these mismatches during GSTR-1 filing.

03

Non-sequential invoice numbering

Invoice numbers must be sequential, unique within each financial year, and no longer than 16 characters (Rule 46). Gaps in numbering trigger scrutiny during audits. The GST portal flags these mismatches during return filing. Starting a new series mid-year without proper documentation is another red flag.

04

Composition dealers charging tax on invoices

If you're registered under the Composition Scheme (Section 10, CGST Act), you can't charge GST on your invoices. You must issue a "Bill of Supply" instead of a "Tax Invoice." Charging tax when you're not eligible makes the entire invoice invalid.

05

Missing "Place of Supply" on B2B invoices

Place of Supply determines whether a transaction is intra-state or inter-state. Omitting it from the invoice is a Rule 46 violation. The place of supply rules differ for goods (Section 10, IGST Act) and services (Section 12, IGST Act).

06

Not issuing Credit Notes within the deadline

Credit Notes must be issued before the due date of filing GSTR-9 (annual return) for that financial year, or before 30th November of the next year, whichever is earlier. Miss the deadline, and the adjustment is lost forever (Section 34, CGST Act).

07

Using a Tax Invoice format for exports without shipping details

Export invoices need additional fields: port code, shipping bill number and date, country of destination, and LUT/Bond reference (if exporting without IGST). A regular tax invoice format won't have these fields, leading to customs clearance delays. If you also manage vendor purchases, our Vendor Evaluation Template pairs well with this pack.

Comparison

GST Invoicing: Manual vs This Template Pack.

Aspect Manual / Generic Format With This Template Pack
Invoice formats available Usually one generic format 6 formats for every GST scenario
Tax calculation Manually calculated, error-prone Auto-calculated with formulas
CGST/SGST vs IGST Often applied incorrectly Auto-detects from state codes, fills correct columns
HSN/SAC codes Looked up separately each time 50+ codes with rates built in
Export invoices Missing port code, shipping fields All export-specific fields included
Credit Notes Created ad hoc, often non-compliant Section 34 compliant with reason dropdown
GSTR-1 prep Re-enter all data at filing time Invoice Register tracks everything monthly

Stop worrying about invoice compliance.

Download the free GST Invoice Template Pack and start issuing correct invoices in 2 minutes.

FAQ

Frequently asked questions.

What are the 16 mandatory fields on a GST tax invoice?
Rule 46 of the CGST Rules, 2017 lists 16 sub-clauses (a through p) covering every field a tax invoice needs. The key ones: supplier name, address, and GSTIN; a sequential serial number (max 16 characters, unique per FY); date of issue; recipient name, address, and GSTIN (if registered); HSN/SAC code; description of goods or services; quantity and unit; total value of supply; taxable value after discounts; rate of tax (CGST, SGST, IGST); amount of tax charged per head; place of supply with state name; delivery address (if different); whether reverse charge applies; and the supplier's signature. This template covers all 16 fields with clear labels. If you also need help with GST filing, grab our GST Return Filing Checklist.
When should I use a Bill of Supply instead of a Tax Invoice?
You issue a Bill of Supply (not a Tax Invoice) in two situations: (1) You're registered under the Composition Scheme under Section 10 of the CGST Act, or (2) you're supplying exempted goods or services. Composition dealers cannot collect tax from buyers, so the invoice must not show any tax breakup. The Bill of Supply must carry the declaration: "Composition taxable person, not eligible to collect tax on supplies." This template includes that declaration by default.
How do I decide between CGST + SGST and IGST?
It depends on the Place of Supply. If the supplier and the place of supply are in the same state, it's intra-state supply, so you charge CGST + SGST (each at half the GST rate). If they're in different states, it's inter-state supply, and you charge IGST (at the full GST rate). For example, 18% GST on an intra-state sale = 9% CGST + 9% SGST. The same 18% on an inter-state sale = 18% IGST. The total tax amount is the same; only the split differs. Use our free GST calculator to quickly verify amounts.
Is e-invoicing mandatory for my business?
E-invoicing is mandatory for businesses with aggregate turnover exceeding ₹5 crore in any financial year from 2017-18 onwards, per CBIC Notification No. 10/2023-Central Tax (dated 10-May-2023). If your turnover is below ₹5 crore, you can continue using Excel or manual invoice formats like this template pack. Once you cross the threshold, you'll need to generate an Invoice Reference Number (IRN) through the IRP portal for each B2B invoice. At that point, a tool like Petpooja Invoice handles e-invoicing automatically.
Can I customise these templates for my business?
Yes. Go to the "Your Business Details" section on the Instructions sheet and fill in your company name, GSTIN, address, state code, and bank details once. All four invoice sheets (Tax Invoice, Bill of Supply, Export Invoice, Credit Note) pull from there automatically. Item rows, buyer details, and GST rates are editable directly on each sheet. The formula cells (shaded grey) auto-calculate, so don't overwrite those.

About Petpooja

Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.

Automate GST invoicing for your entire business

Petpooja Invoice handles GST invoicing with e-invoices, e-way bills, barcode scanning, and Tally integration. No more manual invoice formatting or HSN code lookups.

Book a Free Demo Call: +91-92279 80766