Free template · Excel

Proforma Invoice Format (Free Excel Download)

A proforma invoice format is the layout a seller uses to send the buyer an advance bill before the goods are supplied. It lists seller and buyer details with GSTIN, items with HSN, quantity, rate, estimated GST and total, plus payment terms and a validity date. It is not a tax invoice. It is not reported in GST returns, and the buyer cannot claim input tax credit on it.

Download the Excel template

What is a proforma invoice?

A proforma invoice is an advance bill the seller sends before supply. It tells the buyer what they will pay, and on what terms. Manufacturers send one:

  • To collect an advance before production starts.
  • For the buyer's PO or budget approval.
  • For bank, LC or import paperwork.
  • For export orders, before the commercial invoice at shipment.

The seller issues it, often pricing from the bill of materials. "Proforma" is correct; "performa invoice" is a common misspelling.

Is a proforma invoice valid under GST?

It is a valid business document, but not a tax invoice. Issuing it creates no GST liability, and no format is prescribed.

  • It is not reported in GST returns.
  • It gets no IRN, so it is not an e-invoice.
  • The buyer cannot claim input tax credit on it.
  • GST law sets no validity period.

Section 31 of the CGST Act and the invoice rules list tax invoices and other documents. These include the bill of supply and the receipt voucher. A proforma invoice is not one of them, so no format is prescribed. Copying a tax invoice's fields still saves rework. See tax invoice vs bill of supply.

Proforma invoice format: every column explained

Header, seller and buyer

FieldWhat to writeWhy it matters
PI numberOwn series, e.g. PI/26-27/0042Keeps the tax-invoice series unbroken
Valid untilAn end date for the priceProtects you if material costs move
Seller, bill-to, ship-toName, address, GSTIN, state codeMust match the tax invoice
Place of supplyUsually the delivery stateDecides IGST or CGST + SGST

Item table

ColumnWhat to write
Sr. No.1, 2, 3…
Item descriptionName, size, grade, drawing number
HSN code4–8 digit code; it sets the GST rate
Qty and unitQuantity in Nos, Kg, Sets or Mtr
Rate (₹) and discount %Unit price before GST; agreed discount
Taxable value (₹)Qty × rate, less discount
GST % and GST amount (₹)HSN rate; the tax in rupees
Amount (₹)Taxable value + GST

Totals and terms

Add the total taxable value, then IGST (inter-state) or CGST + SGST (same state). Bill freight as a line so it carries GST. Round off, and write the grand total in words too.

Then add the advance in rupees, payment and delivery terms, bank details, a signature and "This is not a tax invoice."

How to fill a proforma invoice in 7 steps

  1. Take the next number from a separate PI series.
  2. Copy the buyer's GSTIN from their PO.
  3. Set the place of supply.
  4. Add items with HSN, quantity, unit, rate and discount.
  5. Check each line's GST against its taxable value.
  6. Write the validity date and the advance in rupees.
  7. Sign and send it as a PDF.

Proforma invoice example (filled)

A Pune engineering manufacturer (state code 27) bills a buyer in Gujarat (state code 24). It is inter-state, so IGST at 18% applies. Names, GSTINs, HSN codes and rates are illustrative.

PI/26-27/0042 · Date 17-11-2026 · Valid until 02-12-2026 · Against buyer PO 7781

LineWorkingTaxable value (₹)Amount with IGST 18% (₹)
MS weld-neck flange, 150 mm (HSN 7307)200 Nos × ₹450, less 5%85,500.001,00,890.00
Gasket set, 150 mm (HSN 8484)200 Sets × ₹6012,000.0014,160.00
Bolt and nut kit, M16 (HSN 7318)150 Kits × ₹84.7012,705.0014,991.90
Packing and forwarding1 Lot × ₹1,5001,500.001,770.00
TotalIGST ₹20,106.901,11,705.001,31,811.90
Grand totalAfter ₹0.10 round-off1,31,812.00
Advance asked (50%)Balance before dispatch65,906.00

At dispatch, the e-invoice format and e-way bill format templates take over.

[[IMAGE {"type":"compare","title":"Same order: inter-state vs intra-state GST","columns":["Buyer in Gujarat","Buyer in Maharashtra"],"rows":[["Tax type","IGST 18%","CGST 9% + SGST 9%"],["Tax amount","₹20,106.90","₹10,053.45 + ₹10,053.45"],["Taxable value","₹1,11,705","₹1,11,705"],["Grand total","₹1,31,812","₹1,31,812"]]}]]

Where TranZact takes over from the spreadsheet

Excel strains when the same customer, item, HSN and rate get retyped into the quotation, order, invoice and e-way bill. Every retype is a chance for numbers to drift.

TranZact's manufacturing AI software runs the sales flow on one system: 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, on all plans.

  • Tally stays. Accounting stays in Tally, and operations run in TranZact. It is a one-way sync with no double entry. Busy and Zoho Books sync too.
  • Advances and balances. Delivery and payment reminders, plus multi-currency, are on the Grow plan.
  • Your own layout. Custom document formats are on the Dominate plan. See the pricing page.

10,000+ manufacturers use TranZact, and it goes live in 2–3 weeks. See the full flow on the sales management page.

Book a demo →

Proforma invoice vs quotation vs tax invoice

DocumentWhen it's sentWhat it doesGST effect
QuotationBefore the orderOffers a price to acceptNone
Proforma invoiceBefore supplyAsks for an advance or approvalNone; no credit for the buyer
Tax invoiceAt supplyRecords the saleGST payable; buyer claims credit

What comes first, PO or proforma? Usually the quotation, the buyer's PO, a proforma for the advance, then the tax invoice at dispatch. Some buyers want the proforma before their PO. More in purchase order vs proforma invoice. Then a sales order format keeps production on the same numbers.

Should the buyer pay on a proforma invoice?

Yes, if its terms ask for an advance. The seller books it as an advance received, not a sale. The tax invoice follows at supply, and the advance is adjusted against it. For goods, GST is paid with the tax invoice. For services, check with your CA.

Common mistakes in proforma invoices

  1. Reusing the tax-invoice series. It breaks the series your returns rely on.
  2. Leaving out "This is not a tax invoice". The buyer may claim credit wrongly.
  3. Wrong place of supply. You must reissue the document.
  4. Wrong HSN. The GST rate won't match the final invoice.
  5. No validity date. A late payer expects the old price.
  6. Changing terms without a revised PI. The PO, PI and invoice stop matching.
  7. Booking the proforma as a sale. Sales look higher than they are.
  8. Retyping bank details. One wrong digit misroutes the advance.

Run every sales document from one set of details

Want your quotation, order, GST invoice and e-way bill from the same customer and item details? See it on your own items in a short demo.

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

Book a demo →

Frequently asked questions

Is GST charged on a proforma invoice?

The proforma shows the estimated GST so the buyer knows the full amount, but issuing it creates no GST liability. GST is charged on the tax invoice issued at supply.

How long is a proforma invoice valid?

GST law sets no validity period. Write your own 'valid until' date. Many manufacturers use 15–30 days so prices keep pace with raw material costs.

Can I change a proforma invoice after sending it?

Yes. Send a revised proforma with the same number plus a revision mark, e.g. PI/0042-Rev1, so the buyer's PO and your final invoice match.

Do I need a proforma for export orders?

Exporters commonly send one so the buyer can arrange import permits, bank payment or a letter of credit. The commercial invoice follows at shipment; see our export invoice format template.

Is GSTIN mandatory on a proforma invoice?

No format is prescribed. But adding both GSTINs, the HSN codes and the place of supply lets the final tax invoice match without rework.

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

Book a demo

Born in India. Building for the world.