Purchase Order Format: Templates for Excel And Word in 2026

Key Takeaways

A standard purchase order format should include PO number, date, buyer and supplier details, item description, quantity, unit price, GST rate and amount, total, delivery date, payment terms, and an authorisation signature, with the PO number linking GRN and invoice records.
Use Excel for live, calculation-heavy POs with GST and totals, and Word for static, formal copies, especially when sending vendor-facing PDFs or archival records.
For FY 2025–26, include buyer and supplier GSTINs, HSN/SAC codes, and applicable GST rate on every PO to avoid ITC issues, and reconcile using Input Tax Credit.
Keep Tally and template PO numbering perfectly aligned, otherwise three-way matching will fail and unmatched receipts will inflate accounts payable.
Build approval into the PO template with raised-by and approved-by fields, and sign-offs, and mandate escalated approvals for high-value POs, for example, above ₹5 lakh.

Why a strong purchase order format matters in 2026

A missing or wrong purchase order format costs Indian SMBs more than time, it creates disputed liabilities, delayed vendor payments, and broken audit trails. A well-structured PO is your first line of defence against inflated bills and unreconciled payables.

A purchase order (PO) is a legally binding commercial document issued by a buyer to a supplier, authorising the purchase of specified goods or services at agreed prices. It precedes the supplier's invoice and governs AP (accounts payable) matching. Indian SMBs use POs to enforce three-way matching, PO, goods receipt note (GRN), and invoice, before releasing payment.

Pro tip: Treat the PO as the source of truth. If it is right, matching and ITC claims fall in place. If it is wrong, every downstream step takes longer and costs more.

Purchase Order Format: The Short Answer

A purchase order format is a structured template that formalises a buyer’s intent to purchase goods or services at defined terms. It serves as the controlling document for three-way matching in the AP process.

PO Number — Unique sequential identifier; Required for GST? Yes — for e-way bill linkage
PO Date — Date of issue; Required for GST? Yes
Buyer GSTIN — Buyer’s 15-digit GST registration; Required for GST? Yes
Supplier GSTIN — Supplier’s 15-digit GST registration; Required for GST? Yes
HSN / SAC Code — Item classification under GST; Required for GST? Yes, mandatory above ₹5 crore turnover
Item Description — Goods or service details; Required for GST? Yes
Quantity and Unit — How much, in which unit; Required for GST? Yes
Unit Price (excl. GST) — Agreed rate before tax; Required for GST? Yes
GST Rate and Amount — 5%, 12%, 18%, or 28%; Required for GST? Yes
Total Amount (incl. GST) — Final PO value; Required for GST? Yes
Delivery Date — Expected receipt date; Required for GST? No, but operationally critical
Payment Terms — Net 30, advance, milestone; Required for GST? No, but governs DPO
Authorised Signatory — Name, designation, signature; Required for GST? Internal control

The most common mistake is treating GST fields as an afterthought. The GSTIN and HSN on the PO must match the supplier’s tax invoice, otherwise GSTR-2B will show a discrepancy and your ITC may be reversed.

What Should A Standard Purchase Order Format Include?

Every PO template, whether in Excel, Word, or a procurement system, maps directly to Tally’s purchase order voucher fields. Missing even one field creates downstream reconciliation work.

Header Section: Buyer and Supplier Identity

The header carries both parties’ legal names, addresses, GSTINs, and contact details. For the buyer, use the registered legal name matching your GSTIN certificate. For the supplier, pull the name and GSTIN from their last tax invoice, not a visiting card or email signature.

Example: Your company is “Priya Industries Pvt Ltd” with GSTIN 27AABCP1234Q1ZX. Your supplier is “Ram Steel Works” with GSTIN 29AAACR5678M1Z2. If Ram Steel Works operates from Karnataka and you are in Maharashtra, IGST applies at the applicable rate, not CGST + SGST.

Tally supports purchase order vouchers natively, and correct GSTINs at the PO stage help auto-populate ledgers correctly when you convert the PO to a purchase voucher.

Line-Item Section: The Heart of the Purchase Order Format in Excel

Each line item carries: item code, item description, HSN or SAC, quantity, UOM, unit price (excluding GST), discount if applicable, taxable value, GST rate, GST amount (CGST + SGST or IGST), and line total.

In Excel, use formulas to eliminate manual errors: Taxable value: =quantity * unit_price - discount
GST amount: =taxable_value * gst_rate
Total PO value: =SUM(taxable_value) + SUM(gst_amount)

Worked example:
• 50 units of MS rods at ₹200 per unit
• Discount: 5% on unit price = ₹10 per unit, net unit price = ₹190
• Taxable value = 50 × ₹190 = ₹9,500
• GST @ 18% = ₹9,500 × 18% = ₹1,710
• Total line value = ₹11,210

Footer Section: Terms, Approval, and Payment

The footer should include delivery address, delivery date, payment terms, freight and insurance responsibility (FOB or CIF), penalty clause for late delivery, and the authorisation block.

For purchases attracting TDS under Section 194Q of the Income Tax Act (aggregate purchases from a supplier exceeding ₹50 lakh in FY 2025–26), note the TDS obligation on the PO face. This prevents disputes when you deduct 0.1% TDS before payment.

How To Create A Purchase Order Format In Excel

An Excel-based PO is popular among Indian SMBs because it handles GST automatically and aligns with Tally’s workflow. Build it once, reuse forever.

Setting Up the Workbook Structure

Use one worksheet per PO, or a master template that you duplicate. Name each sheet by PO number, for example, “PO-2526-001”. Maintain a summary sheet listing PO numbers, suppliers, dates, values, and status (open, partially received, closed). This becomes your AP outstanding tracker.

A — Item Code — Manual
B — HSN / SAC — Manual
C — Description — Manual
D — Quantity — Manual
E — UOM — Manual
F — Unit Price (excl. GST) — Manual
G — Discount % — Manual
H — Taxable Value — =D*F*(1-G/100)
I — GST Rate % — Manual (0/5/12/18/28)
J — GST Amount — =H*I/100
K — Line Total — =H+J

Below the table, sum H for total taxable value, J for total GST, and K for total PO value.

Handling Multiple GST Rates in One PO

If the PO covers items with different GST rates, capture each rate at line level. Split totals into CGST + SGST or IGST based on place of supply.

Worked example:
• Stationery: ₹10,000 taxable at 12% = ₹1,200 (CGST ₹600 + SGST ₹600)
• Printer: ₹50,000 taxable at 18% = ₹9,000 (CGST ₹4,500 + SGST ₹4,500)
• Total PO: ₹70,200

Protecting Formulas and Enabling Drop-Downs

Lock formula cells, leave manual-entry cells unlocked. Add data validation for GST rate values (0, 5, 12, 18, 28). Validate supplier GSTIN length at 15 characters to reduce GSTR-2B mismatches.

How To Create A Purchase Order Format In Word

A Word-based PO is ideal when you need a formal, branded document, especially for services or when a signed PDF is required.

Building the Word PO Template

Use a clean header for buyer and supplier details, followed by a line-item table structure similar to Excel, but compute GST in Excel and paste values if your PO has multiple GST rates.

When To Use Word Over Excel

Use Word — Consultant or service POs, government or PSU submissions, or when director sign-off on a PDF is required
Use Excel — Many line items, multiple GST rates, partial deliveries, or downstream Tally entry

Adding Approval Blocks and Terms in Word

Include “Prepared By” and “Approved By” blocks with names, designations, and dates. For e-sign, add your standard signature tags. State payment terms explicitly, for example: “Payment within 30 days from tax invoice date, subject to satisfactory delivery and three-way matching against PO and GRN.”

What Is The Purchase Order Workflow For Indian SMBs?

The workflow connects the PO format to your AP cycle, from requisition to payment. Gaps at any stage create delays, inflated liabilities, or blocked ITC.

Step 1: Purchase Requisition to PO Issuance

Start with a formal requisition, review inventory and open POs, then issue the PO with a sequential number, for example, PO-2526-001 for FY 2025–26.

Key control: No verbal POs above ₹10,000. Put it in writing before receipt of goods or services.

Step 2: Three-Way Matching Before Payment

Match PO, GRN, and supplier’s tax invoice. All three must agree on item, quantity, and price within your tolerance.

Worked example:
• PO: 50 units at ₹190, taxable ₹9,500, GST 18% = ₹1,710, total ₹11,210
• GRN: 48 units received
• Invoice: Billed for 50 units
Action: Pay 48 units only, raise a debit note for the shortfall, and claim ITC only on paid quantity when supported by a revised document.

Step 3: PO Closure and AP Reconciliation

Close POs once fully received and invoiced, both in your Excel tracker and in Tally. Review open POs monthly to prevent surprises in committed spend.

How Does The Purchase Order Format Connect To GSTR-2B Reconciliation?

GSTR-2B reflects what your suppliers filed in GSTR-1. Your purchase register should match GSTR-2B on GSTIN, invoice number, taxable value, and GST amount. While POs do not appear in GSTR-2B, they dictate invoice accuracy, which drives reconciliation.

How PO Fields Map to GSTR-2B

If your PO carries an incorrect HSN and the supplier mirrors it on the invoice, your ITC will show under the wrong HSN in annual reconciliations, inviting scrutiny.

Common PO-to-GSTR-2B Mismatch Scenarios

GSTIN mismatch — Supplier updated registration, you used the old GSTIN, resulting in missing entries in GSTR-2B
Rate mismatch — PO at 12%, invoice at 18%; ITC may still be available, but your three-way match fails until you amend the PO
Timing gap — March PO, April invoice, ITC appears in April GSTR-2B; track and close the reconciling item

Preventing GSTR-2B Mismatches at the PO Stage

Validate the supplier’s GSTIN on the GST portal before issuing a PO. Add a standard clause: “The tax invoice must match the GSTIN, HSN/SAC, and GST rate on this PO. Invoices with discrepancies will be returned unpaid.”

References

Frequently Asked Questions

What is the difference between a purchase order and a purchase invoice?

A purchase order is issued by the buyer before the transaction and authorises the supplier to deliver at agreed terms. A purchase invoice is issued by the supplier after delivery and demands payment. In three-way matching, PO, GRN, and invoice must agree before payment. Under GST, ITC arises from a valid tax invoice appearing in GSTR-2B, not from the PO.

What should I do if I issued a PO without a GSTIN and the supplier has already invoiced me?

Request a revised tax invoice with your correct GSTIN. If the original is uploaded in GSTR-1, ask for a credit note and a fresh invoice. Do not claim ITC on an invoice missing your GSTIN. Update your PO record and vendor master to prevent repeats.

How do I number purchase orders for the new financial year 2026–27?

Reset numbering from 1 April 2026. A robust format is PO-2627-001, with FY prefix and a sequential counter. Configure a new voucher series in Tally for Purchase Order vouchers for FY 2026–27 to maintain audit trails and clean AP reports.

Can the same PO format be used for both domestic and import purchases?

Use separate templates. Domestic POs carry INR values, GST fields, and both GSTINs. Import POs carry foreign currency, Incoterms, supplier country, expected port of entry, and currency conversion fields. IGST on imports is assessed at customs, not on your domestic PO.

What happens if a payment is made without a PO?

Three-way matching becomes impossible. While ITC may still be available if the supplier files GSTR-1 and the invoice appears in GSTR-2B, from an internal control standpoint, payments without POs are high risk. Many SMB CFOs enforce a “no PO, no payment” policy above ₹5,000.

Does a PO need to be signed by both buyer and supplier to be valid?

No. Under the Indian Contract Act, offer, acceptance, and consideration create a binding contract. The buyer issues the PO, and the supplier’s acknowledgement or performance is acceptance. Dual signatures are best practice for high-value or long-term supplies but are not mandatory for routine orders.

If a supplier files GSTR-1 late, is my ITC blocked even if I hold the PO and invoice?

Yes. ITC is available only to the extent it appears in your GSTR-2B. If the supplier files GSTR-1 late, your credit will reflect in the subsequent month’s GSTR-2B. Track and claim it in that period.

How do I prevent GSTR-2B mismatches originating from the PO stage?

Validate supplier GSTIN on the GST portal before issuing POs, standardise HSN/SAC and GST rate fields, and include a clause requiring invoice fields to match the PO exactly. For example, mandate “Invoice must match PO GSTIN, HSN/SAC, and GST rate, else it will be returned unpaid.”

Can I use one Excel PO template for both goods and services?

Yes. Replace HSN with SAC for services and use appropriate UOMs like hours or months. GST logic remains the same. Place-of-supply rules may change IGST vs CGST/SGST application; set a drop-down for supply type to drive the correct split.

Written By

Rohan Sinha

Rohan Sinha is a fintech and growth leader building aiaccountant.com, focused on simplifying accounting and compliance for Indian businesses through automation. An IIT BHU alumnus, he brings hands-on experience across 0 to 1 product building, growth, and strategy in B2B SaaS and fintech.