Free template · Excel · Worked example

Bill Format: Free Excel Template with a Worked Example

A GST-ready bill (tax invoice) layout for manufacturers: a blank Excel sheet and a filled example. Every required field is tied to Rule 46 of the CGST Rules. No sign-up.

Download the Excel template

What is a bill format?

A bill format is the layout of a tax invoice. It has your business details, the buyer's details, and a bill number and date. Then comes a table of items with HSN code, quantity, rate and taxable value, then GST and the total. For a GST-registered seller, Rule 46 of the CGST Rules lists what the bill must show. That includes both GSTINs, place of supply and the tax (CGST + SGST within a state, IGST between states). Download our free Excel bill format above: a blank sheet and a filled example.

A bill is the everyday name. A tax invoice is a bill that charges GST. A bill of supply charges no GST, for exempt goods or composition dealers (see our bill of supply format). A bill of materials is different: it lists what goes into a product (see our bill of materials format).

Issue a goods bill on or before the day the goods leave (CGST Act section 31). For the legal detail, see our GST invoice format.

What each part of the bill format means

Each field, what to write, and its Rule 46 clause. A dash means good practice, not a legal must.

Table A: header fields

FieldWhat to writeRule 46
Your detailsLegal name, full address and 15-character GSTIN(a)
Title"Tax Invoice"—
Bill numberUp to 16 characters, unique for the financial year(b)
Bill dateOn or before the day the goods leave(c)
Bill toBuyer's name, address and GSTIN if registered(d)
Unregistered buyerName, delivery address, state and code, if taxable value is ₹50,000 or more(e)
Place of supplyState name and code(n)
Ship toDelivery address, if different(o)
Reverse chargeYes or No(p)

Table B: item columns

ColumnWhat to writeRule 46
DescriptionThe goods, with size or grade(h)
HSN code4 digits up to ₹5 Cr turnover; 6 digits above ₹5 Cr(g)
Quantity and unitFor example 20 Nos or 150 Kg(i)
RatePrice per unit before GST—
Discount and taxable valueQuantity × rate, minus any discount shown(k)
GST rate and amountCGST + SGST, or IGST: the rate and the rupees(l), (m)

Table C: totals and footer

FieldWhat to writeRule
Total valueTaxable value plus GST46 (j)
Amount in wordsThe total, in words—
SignatureYou or an authorised person; digital is fine46 (q)
IRN and QR codeOnly if e-invoicing applies48 (4)
CopiesOriginal for Recipient, Duplicate for Transporter, Triplicate for Supplier48

How to fill the bill format, step by step

  1. Header: your details, GSTIN and "Tax Invoice".
  2. Bill number and date, on or before dispatch.
  3. Bill to, ship to and place of supply, with state codes.
  4. Items: one line each, with HSN, quantity, unit and rate.
  5. Discount, then taxable value: quantity × rate, minus discount.
  6. GST type: CGST + SGST in the same state; IGST between states.
  7. Total in figures and words, signature, then three copies.

Where TranZact fills the bill for you

Excel works for a few bills a month. It gets harder when each bill must match an order, dispatch, e-way bill and Tally entry.

In TranZact, the bill sits in the sales flow: enquiry, quotation, order timeline, dispatch, e-invoicing and payment. TranZact generates the e-way bill from the GST invoice, with the e-invoice (IRN) in the same flow.

[[IMAGE {"type":"compare","title":"Excel bill format vs TranZact","columns":["Excel bill format","TranZact"],"rows":[["Making the bill","Items typed from the order","Same flow as quotation and dispatch"],["E-invoice (IRN)","Separate portal entry","Same flow as GST invoice"],["E-way bill","Typed again on the portal","Generated from the GST invoice"],["Tally entry","Accountant enters it again","One-way sync, no double entry"],["Payment follow-up","Calendar and WhatsApp","Delivery and payment reminders"]]}]]

Book a demo →

TranZact billing facts (as of publish date)

  • Manufacturing AI software used by 10,000+ manufacturers.
  • E-way bill and e-invoice (IRN) on all plans. Custom document formats on the Dominate plan (pricing).
  • Accounting stays in Tally or Zoho Books, with one-way sync. Busy integrates too.
  • Live in 2–3 weeks. Data stored in India on AWS servers in Mumbai.

Worked example: a steel trolley order (illustrative numbers)

A Pune manufacturer sells steel trolleys to a Maharashtra machine builder. Names, numbers, HSN and the 18% rate are examples; confirm yours with your CA.

Table 1 (Example): the bill header

FieldValue
SellerExample Engineering Pvt Ltd, Pune. GSTIN 27XXXXX0000X1Z5
Bill numberTRL/26-27/0148 (14 characters)
Bill date17-11-2026, the day the trolleys leave
Bill toSample Machines LLP, Nashik. GSTIN 27XXXXX1111X1Z2
Ship toSample Machines LLP plant, Chakan
Place of supplyMaharashtra (27)
Buyer POPO-4471 dated 10-11-2026
Reverse chargeNo

Table 2 (Example): item lines with CGST + SGST (same state)

Item (HSN 871680)Quantity × rateTaxable valueCGST 9% + SGST 9%
Steel platform trolley10 Nos × ₹9,000, less 5% discount (₹4,500)₹85,500₹7,695 + ₹7,695
Steel drum trolley4 Nos × ₹6,500₹26,000₹2,340 + ₹2,340
Total₹1,11,500₹10,035 + ₹10,035

The bill total is ₹1,11,500 + ₹20,070 GST = ₹1,31,570. In words: Rupees One Lakh Thirty-One Thousand Five Hundred Seventy only.

Table 3 (Example): the same bill to another state (IGST)

Buyer and delivery in Ahmedabad: place of supply is Gujarat (24), so the full 18% is IGST.

Item (HSN 871680)Taxable valueIGST 18%
Steel platform trolley₹85,500₹15,390
Steel drum trolley₹26,000₹4,680
Total₹1,11,500₹20,070

The bill total stays ₹1,31,570.

What else this bill needs: e-way bill, e-invoice, 6-digit HSN

  • E-way bill: needed: ₹1,31,570 is over the ₹50,000 limit (and Maharashtra's ₹1 lakh intra-state limit).
  • E-invoice: IRN and QR code, if the seller's turnover is above ₹5 Cr.
  • HSN: 6 digits (871680) above ₹5 Cr; 4 digits (8716) up to ₹5 Cr.

Common bill format mistakes

  • Wrong GST type. CGST + SGST on a sale to another state.
  • Bill number problems. Reused, skipped, reset mid-year or over 16 characters.
  • Hidden discount. Agreed but not shown, so the totals do not add up.
  • Late bill. Dated after the truck left the gate.
  • Missing e-way bill, IRN or 6-digit HSN. Each is needed at the limits above (see our e-way bill format).

How to send a bill as a PDF and get paid

Excel: File → Save As → PDF. Google Sheets: File → Download → PDF. Email it the day the goods leave, with bank, UPI and payment terms, such as 30 days.

Ready to stop retyping bills?

Billing daily from orders and dispatches? See one system keep them matched.

Don't be the bottleneck. Become the AI-Run Factory.

Born in India. Building for the world.

Book a demo →

Frequently asked questions

Can I use an Excel bill format if my turnover is above ₹5 crore?

You can keep Excel as the layout, but B2B bills must also be reported on the e-invoice system to get an IRN and QR code. A bill issued without it is not treated as a valid invoice.

Do goods under ₹50,000 ever need an e-way bill?

Usually not. But goods sent to a job worker in another state need an e-way bill whatever the value.

What is the difference between a bill and a bill of supply?

A tax invoice charges GST. A bill of supply is used for exempt goods or by a composition dealer, and shows no tax.

How many copies of a bill should a manufacturer print?

Three for goods: Original for Recipient, Duplicate for Transporter and Triplicate for Supplier. An e-invoice does not need these copies.

Does TranZact replace Tally for billing?

No. Bills, e-invoices and e-way bills are made in TranZact along with orders and dispatch. Entries sync one way to Tally, so accounting stays in Tally with no double entry.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.