Free template · Purchase

Purchase Invoice Format (GST): Free Excel Download

A free GST purchase invoice format in Excel, blank and filled. Every field is checked against GST Rule 46. You also get a worked example with the tax maths, and a way to check each bill against your PO and GRN.

Download the Excel template

A purchase invoice is the GST tax invoice your supplier gives you when you buy goods. It is the bill you check, pay and claim input tax credit on. A valid format shows both GSTINs, a unique invoice number of up to 16 characters, the date, the HSN code, and quantity with unit. It also shows the taxable value, GST split into CGST and SGST or IGST, place of supply, whether reverse charge applies, and a signature. Before you pay, match it line by line with your purchase order (PO) and goods receipt note (GRN).

Download the free Excel: a blank format and a filled example, from the download box on this page.

What is a purchase invoice?

You keep it for three jobs. It is the basis for paying the supplier and for your stock and cost records. And you need it to claim input tax credit (ITC) on the GST you paid.

Who prepares the purchase invoice, the buyer or the seller?

The seller prepares it. To the supplier, it is a sales invoice. You, the buyer, record the same document as a purchase invoice and check it before paying.

One exception: when you buy from an unregistered supplier under reverse charge, you issue a self-invoice yourself.

Purchase order vs purchase invoice vs GRN

A PO says what you agreed to buy. A GRN says what actually arrived. The purchase invoice says what the supplier is charging you.

PointPurchase order (PO)GRNPurchase invoice
Who makes itYou, the buyerYou, at your storesThe supplier
WhenBefore the supplyWhen goods arriveAt the time of supply
What it provesItems, quantity and rate agreedWhat reached you, and in what conditionWhat you owe, with tax
Carries GST?NoNoYes
Used for ITC?NoShows goods were receivedYes, it is the main document

Is a purchase bill the same thing?

Yes. "Purchase bill" is the everyday name for a purchase invoice. For the supplier's side, see our GST invoice format. A bill of supply is different. Composition dealers and suppliers of exempt goods issue it, with no GST, so there is no ITC on it.

Purchase invoice format: every column explained

The table lists each field, what to write, and whether GST Rule 46 makes it mandatory. "Recommended" means not in Rule 46, but it makes checking much faster.

SectionFieldWhat to writeMandatory under Rule 46?
HeaderTitle"Tax Invoice"Recommended
HeaderInvoice numberConsecutive, unique in the financial year, up to 16 characters (letters, numbers, - and /)Yes
HeaderInvoice dateDate of issueYes
SupplierName, address, GSTINThe supplier's registered detailsYes
BuyerName, address, GSTINExactly as on your GST registrationYes, if you are registered
BuyerDelivery addressWhere goods went, if not the place of supplyYes, when different
BuyerPlace of supplyState name and state codeYes for inter-state; good practice always
Line itemsDescription and HSN codeWhat was supplied, and its HSN codeYes
Line itemsQuantity and unitFor example 500 kg or 2,000 nosYes
Line itemsRate, discount, taxable valueGST is charged on the value after discountYes (taxable value)
Line itemsGST rate and amountCGST + SGST, or IGST, plus cess if anyYes
TotalsInvoice total, amount in wordsTaxable value plus all taxTotal: yes. Words: recommended
FooterReverse charge"Yes" or "No"Yes
FooterSignatureSupplier's signature or digital signatureYes, unless issued electronically
ReferencePO, GRN and e-way bill numbers, payment termsYour references, e.g. 30 days from invoice dateRecommended

How to fill the purchase invoice format, step by step

This is also how you make a purchase invoice format from scratch.

  1. Number and date. Use the next number in this financial year's series, up to 16 characters.
  2. Supplier and buyer details. Write both names, addresses and GSTINs. Copy GSTINs from the registration, not from memory.
  3. Place of supply. This decides the tax. Same state as the supplier means CGST + SGST. A different state means IGST.
  4. Line items. One row per item, with description, HSN code, quantity and unit.
  5. Discount and taxable value. Taxable value = quantity × rate − discount.
  6. Tax split. CGST and SGST are half the GST rate each. IGST is the full rate.
  7. Totals and sign-off. Add taxable value and tax, write the amount in words, mark reverse charge, and sign.

Where TranZact fills it for you

Your supplier fills the invoice. Your job is to check it against your PO and GRN before you pay. In TranZact, your POs and GRNs are already there.

So checking a supplier's bill against what you ordered and received takes one look, not a hunt through files. Purchase runs as one flow: MRP report, indent, RFQ, PO, GRN and payment, with vendor coordination.

Accounting stays in Tally. Entries reach Tally by one-way sync, with no double entry. 10,000+ manufacturers use TranZact. See the full flow on the purchase management page.

Book a demo →

Worked example: a filled purchase invoice

An engineering manufacturer in Pune buys steel and bolts from a trader in Pune. Both GSTINs start with 27, Maharashtra's code. All numbers here are illustrative.

Invoice no. SS/26-27/0148, dated 12-11-2026, against your PO-2026-311. Place of supply: Maharashtra (27). Reverse charge: No.

Item (HSN)Quantity × rateTaxable valueGST 18% (CGST + SGST)
MS round bar 20 mm (7214)500 kg × ₹62₹31,000₹2,790 + ₹2,790
Hex bolt M12 x 50 (7318)2,000 nos × ₹6.50, less ₹650 discount₹12,350₹1,111.50 + ₹1,111.50
MS round bar 25 mm (7214)300 kg × ₹61₹18,300₹1,647 + ₹1,647

Totals: taxable value ₹61,650. CGST ₹5,548.50 and SGST ₹5,548.50, so tax is ₹11,097. Invoice total: ₹72,747 (Seventy-two thousand seven hundred forty-seven rupees only).

The PO and GRN check: the rates and discount match PO-2026-311. But the GRN shows only 490 kg of 20 mm bar, not 500 kg. The short 10 kg is worth ₹620, plus ₹111.60 GST, so ₹731.60. Pay ₹72,015.40 and ask the supplier for a credit note of ₹731.60.

[[IMAGE {"type":"compare","title":"Same purchase: local vs inter-state supplier","columns":["Pune supplier (local)","Gujarat supplier (inter-state)"],"rows":[["GSTIN state codes","27 and 27","24 and 27"],["Tax head","CGST + SGST","IGST"],["GST rate","9% + 9%","18%"],["Tax on ₹61,650","₹5,548.50 + ₹5,548.50","₹11,097"],["Invoice total","₹72,747","₹72,747"]]}]]

How to check a supplier's purchase invoice before you pay

Use a 3-way match. Put the PO, the GRN and the invoice side by side, and check each line.

  • Items: the same items and HSN codes on all three.
  • Quantity: not more than the GRN quantity.
  • Rate and discount: the same as the PO.
  • Tax: the right head and the right rate.
  • Your details: your GSTIN and name are correct.

Then check the conditions for ITC under Section 16(2) of the CGST Act:

  • You hold the tax invoice.
  • You have received the goods. Your GRN shows it.
  • The supplier has filed the invoice, so it shows in your GSTR-2B.
  • The supplier has paid the tax to the government.
  • You have filed your own GSTR-3B.
  • You pay the supplier within 180 days of the invoice date. If not, reverse the ITC with interest, and claim it again once you pay.

Common mistakes on purchase invoices

  1. Wrong buyer GSTIN. The bill will not show in your GSTR-2B, so ITC waits for the supplier's fix.
  2. Wrong tax head. CGST + SGST on an inter-state supply, or IGST on a local one.
  3. Missing or wrong HSN code. A wrong code can mean a wrong rate.
  4. Repeated or long invoice number. It must be unique in the year and up to 16 characters.
  5. Rate or discount off the PO. Catch it before payment, not at month end.
  6. No signature on a paper invoice. Rule 46 needs one.

Download the free purchase invoice format (Excel)

The download has a blank format and the filled example from this page.

Want your own layout for documents? In TranZact, custom document formats are on the Dominate plan; see pricing. TranZact also integrates with Busy, Zoho Books, Gmail and Excel / Google Sheets.

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

See how your POs, GRNs and supplier bills sit in one place, with accounts flowing to Tally. Live in 2–3 weeks.

Book a demo →

Frequently asked questions

Can I make a purchase invoice format in Excel?

Yes. Excel works if the sheet has every Rule 46 field: GSTINs, a unique invoice number, HSN, quantity, taxable value, tax split and signature. Download our blank format and filled example above.

Does a purchase invoice need a signature?

Yes. Rule 46 needs the supplier's signature or digital signature. An invoice issued electronically under the IT Act does not need one.

How many copies of a purchase invoice are made for goods?

Three: Original for Recipient, Duplicate for Transporter and Triplicate for Supplier (Rule 48).

Is the PO or GRN number mandatory on a purchase invoice?

No, GST does not require them. Asking suppliers to quote your PO number makes every bill quick to match against what you ordered and received.

What if the invoice quantity is more than what we received?

Pay only for the quantity on your GRN and ask the supplier for a credit note for the difference. ITC applies only to goods you actually received.

How many HSN digits should a purchase invoice show?

The number of digits depends on the supplier's turnover, as notified by the government. Check the current rule with your CA.

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

Book a demo

Born in India. Building for the world.