Free template · Excel · Worked example

Purchase Order Format: Free Excel Template + Example

Free purchase order format in Excel for Indian manufacturers. Get a blank PO plus a filled GST example for a factory buying raw material, with every column explained.

Download the Excel template

A purchase order format is the standard layout a buyer uses to order goods from a supplier. It carries the PO number and date, buyer and supplier details with GSTIN, and each item's description, HSN code, quantity, unit, rate and GST. It also shows the total and the delivery and payment terms. Once the supplier accepts it, the PO is the agreed record of what will be supplied, at what price and by when.

What is a purchase order, and when should a factory raise one?

A purchase order (PO) is the buyer's written order to a supplier. Raise one once the need and the price are approved.

It sits in a chain: indent, quotation, PO, GRN, purchase invoice, payment. Once the supplier accepts it, the PO works as a contract.

A PO is not a GST document. You claim input tax credit on the supplier's invoice, but showing both GSTINs helps you check it. See purchase order vs proforma invoice.

What each column in the purchase order format means

Header

FieldWhat to writeWhy it matters
PO number and dateNext in your seriesQuoted on the invoice
Buyer and supplier GSTINNames, addresses, GSTINsState codes set the tax type
Ship-toReceiving plant or storeGoods reach the right gate
Indent and quote referenceBoth numbers and datesTies the PO to the price

Item lines

FieldWhat to writeWhy it matters
Description and specGrade, size, drawing revisionStops wrong material
HSN codeThe item's HSN codeSets the GST rate
Quantity and unitOne unit: kg, nos or metreAvoids invoice disputes
Rate and taxable valueRate before GST; qty × rateBase for GST
GSTCGST + SGST, or IGSTMust match the invoice
Delivery dateDate needed per lineLets you chase late lines

Totals and terms

FieldWhat to writeWhy it matters
TotalsFigures and wordsThe amount you approved
Delivery and inspectionPart deliveries, freight, test certificateStores can reject off-spec material
Payment termsE.g. 30 days from receipt45-day limit for micro and small suppliers

The items usually come from your bill of materials format.

How to fill a purchase order, step by step

  1. Note the approved indent number.
  2. Add the supplier's quote number and date.
  3. Take the next PO number and today's date.
  4. Fill both parties' GSTINs and the ship-to plant or store.
  5. Add each line: spec, HSN, quantity, unit, rate, delivery date.
  6. Same GSTIN state code means CGST + SGST. Otherwise, IGST.
  7. Add totals in figures and words, then the terms.
  8. Sign within your approval limit and get written acceptance.

Where TranZact helps you raise the PO

An Excel PO works for a few orders a week. It gets hard when indents, POs, part deliveries and GRNs sit in separate files and WhatsApp chats.

In TranZact, the PO is one step in a single purchase management flow: MRP report, indent, RFQ, PO, GRN, payment. The MRP engine runs through your orders and BOMs, then tells you what to buy and when.

One honest limit: printing POs on your own layout needs custom document formats, which are on the Dominate plan only.

TranZact is used by 10,000+ manufacturers and goes live in 2–3 weeks.

TranZact purchase facts (as of 17 Nov 2026)

FactPlanSource page
Purchase flow: MRP report to paymentGrow and up/solutions/factory-ai-os/purchase-management
Approvals and alerts; delivery and payment remindersGrow and up/pricing
Tally / Busy / Zoho integrationGrow and up/pricing
Custom document formatsDominate/pricing
E-invoicingAll plans/pricing

Plans and prices are on the pricing page.

Book a demo →

Worked example: a fabrication unit orders steel and fasteners

The numbers are illustrative. A Pune fabrication unit orders from a Pune trader. Both GSTINs start with 27, so CGST 9% and SGST 9% apply.

PO header

FieldExample entry
PO number and datePO/26-27/0142, 17-Nov-2026
GSTINs (samples)27AAAAA0000A1Z5, 27BBBBB1111B1Z2
Indent and quoteIND/26-27/0388; Q-1176, 14-Nov-2026
TermsDelivery 05-Dec-2026; mill test certificate; 30 days from receipt

Item lines with CGST + SGST

ItemQty × rate (₹)Taxable value (₹)CGST 9% + SGST 9% (₹)
MS plate IS 2062, 10 mm (HSN 7208)2,000 kg × 621,24,00011,160 + 11,160
MS angle 50 × 50 × 6 mm (HSN 7216)1,500 kg × 6496,0008,640 + 8,640
Hex bolt M12 × 50, grade 8.8 (HSN 7318)1,000 nos × 9.509,500855 + 855
Total2,29,50020,655 + 20,655

Same order from an out-of-state supplier (IGST)

From a Gujarat supplier (GSTIN starting 24), the same order carries IGST 18% instead. The grand total stays the same.

[[IMAGE {"type":"compare","title":"Same order, two suppliers: CGST + SGST vs IGST","columns":["Pune supplier (27)","Gujarat supplier (24)"],"rows":[["Taxable value","₹2,29,500","₹2,29,500"],["Tax type","CGST 9% + SGST 9%","IGST 18%"],["GST amount","₹20,655 + ₹20,655","₹41,310"],["Grand total","₹2,70,810","₹2,70,810"]]}]]

PO vs quotation vs proforma vs GRN vs invoice

A quotation is the supplier's offer, and the PO accepts it. You claim GST credit on the supplier's tax invoice.

DocumentWho issues itWhenGST role
QuotationSupplierBefore the orderNone
Proforma invoiceSupplierBefore supply, often for an advanceNot a tax invoice
Purchase orderBuyerAfter the price is agreedNot a GST document
GRNBuyer's storesWhen goods arriveRecords receipt
Tax invoiceSupplierWhen goods are suppliedClaim input tax credit on it

Numbering, approvals and changes to a PO

Use one company-wide series: prefix, financial year, serial, e.g. PO/26-27/0142. Restart each April and never reuse a cancelled number.

Set approval limits in writing. For example, the owner signs any PO above a set value.

To change a sent PO, issue a dated revision such as PO/26-27/0142-R1. Get the supplier's written acceptance.

Common purchase order mistakes

  • Units that don't match. PO in kg, invoice in nos.
  • Rate with GST mixed in. Show GST in its own columns.
  • Changes agreed on the phone. Issue a revised PO.
  • Paying without a match. Check the PO against the goods received note format and purchase invoice format first.

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

Bring one real purchase order to the demo. We'll show it moving from indent to GRN to payment in TranZact.

Born in India. Building for the world.

Book a demo →

Frequently asked questions

What should a manufacturer add to a PO that a trader usually skips?

Add the item spec (grade, size, drawing revision), your indent number, the ship-to plant or store and any test certificate needed. This stops wrong material reaching the shop floor.

How do I handle part deliveries against one PO?

Make a GRN for each delivery and track ordered, received and pending quantity per line. Close the PO when every line is received or cancelled.

What payment terms can I give a micro or small supplier?

Under the MSMED Act, pay by the agreed date, within 45 days of accepting the goods. With no written agreement, the limit is 15 days. Late payment attracts compound interest.

Should the rate on the PO include GST?

Write the rate before GST and show GST in its own columns. The approved total is then the real cost and easy to match with the supplier's invoice.

How do I change a PO after sending it?

Issue a revised PO with the same number plus a revision, e.g. PO/26-27/0142-R1, and the date of change. Don't agree changes only on a call.

Can I keep using this Excel format if my accounts are in Tally?

Yes, while you raise a few POs a week. When indents, POs and GRNs get hard to track, TranZact runs purchase and stock while accounting stays in Tally through one-way sync.

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

Book a demo

Born in India. Building for the world.