How to Create a Purchase Order in Excel

The workbook uses three sheets: a Vendor master (name, GSTIN, address, credit terms), the PO template that pulls from it, and a PO Log that records every number issued.

Referencing the vendor master means a changed address or GSTIN updates every PO you build from it.

The arithmetic mirrors an invoice: line taxable value = qty × rate; subtotal sums the lines; GST splits to CGST and SGST (intra-state) or IGST (inter-state); the grand total closes.

Give the Log sheet a Next Number cell and let each PO read and then advance it, or compute the number from COUNTA(log range) with a prefix like PO-2026-. Sequential, unique and checked against the log every time.

Terms block with delivery date, payment terms (advance/days), inspection window and validity keep the PO contract-complete. Pull the default terms from the vendor master so every vendor gets their agreed terms automatically.

Save each PO as a PDF with the PO number in the filename and keep the log sheet as the index. Three-way matching (PO-GRN-invoice) then works from a dated folder.

A purchase order is the budget's first line of defence. It commits a number before the spend happens, so the finance team sees upcoming liability before the invoice arrives. A monthly open-purchase order report is a cash-flow forecast in itself.

Track open purchase orders — issued, not yet delivered or invoiced — as a standing line in the accounts review. The number is the truest picture of committed spend. A short weekly review of the open list catches stalled orders before they become overdue deliveries.

Set a dollar-free approval threshold for PO value so small orders flow and large ones pause for sign-off; the threshold makes the discipline practical rather than bureaucratic.

Vendors want four things on a purchase order: their name and GSTIN right, the item descriptions and quantities clear, the delivery date realistic, and the payment terms specific. Vendors who quote you faster and offer better prices cite clean POs as the reason.

A vendor-facing purchase order is a relationship document. Put the due date and advance terms where the vendor's accounts team can see them at a glance. Add the contact person and phone for delivery coordination so the warehouse does not call the wrong number.

Revisit the terms block at renewal season; payment terms that were fine for a one-off order can quietly damage a recurring engagement's cash flow.

Service purchase orders differ from goods: the line items are milestones or monthly retainers, delivery is a service window, and acceptance criteria replace the goods-inspection clause. Keep the price-per-milestone explicit to avoid scope disputes.

For retainers, state the notice period for changes and the invoice cadence on the purchase order. The terms block is where service disputes are either prevented or created. Write the deliverables into the order rather than into the email thread that follows it.

For projects, split the order into phases with a hold-at-phase sign-off only when the deliverable accepts; phased service POs settle cleaner than lump-sum ones.

A purchase order history audit asks three questions: were prices in line with the approved quotes, were all orders delivered, and were all invoices matched to their purchase orders. The answers reveal the leaks — duplicate payments, unapproved vendors, and discounts never claimed.

Run the audit quarterly with a simple spreadsheet: purchase order number, amount, status, matched invoice. The report takes an afternoon and pays for itself in recovered overpayments. Flag any invoice that arrives without a PO number as a control exception.

Date the audit trail and keep it for the statutory period — the same file answers both management reviews and the tax authorities.

Three-way matching is how a business avoids paying for goods it never held: the purchase order, the goods receipt note and the invoice must agree before the payment leaves. The purchase order sets the price; the GRN sets the quantity; the invoice must match both.

Run the three-way check as a standing rule rather than a monthly audit — a payment that skips the GRN has nothing to prove the purchase happened. Flag every invoice that does not reference a purchase order as a control exception before it reaches the payment list.

The matching discipline also catches the silent leak of quality materials returned without a credit note: a GRN sans the return entry inflates the books by the return value.

Scope creep reaches the purchase order when an extra is added without a re-issue: the approval trail breaks and the added cost arrives as a surprise on the invoice. Rule for any change: if it is worth more than the tolerance, park the order, issue a fresh purchase order for the delta.

Write the tolerance into the order itself — a spoken 5% band that becomes reality in the price block — so small variations do not travel through the email thread. Every re-issue carries a version marker in the purchase order number line.

Keep the approved version of each purchase order in the shared folder; the version control saves both the vendor and the finance team from the wrong-spec dispute at delivery.

An open purchase order is a liability until its invoice is paid and its goods are accepted. Close cleanly: mark accepted on delivery, match the invoice, pay to term, and record the closure date on the purchase order line.

Unclosed purchase orders accumulate into phantom commitments; the review file shows a budget spent that the books have not yet charged. Set a monthly close-out ritual — a fifteen-minute pass over the open list — so the committed-spend number stays honest.

Re-issue a purchase order when the supply breaches its dates instead of letting the old order carry the blame through the dispute.

A purchase order converts a verbal understanding into a written commitment covering price, quantity, delivery date and payment terms. Once the vendor accepts it, it becomes a binding contract under the Indian Contract Act.

For small businesses, the purchase order is also the audit trail that reconciles inventory, goods-received notes and vendor bills at month end.

While a purchase order is not a tax document like an invoice, it carries the GSTIN of both parties and the tax computation, so the vendor's invoice and your records match at reconciliation time.

Keeping sequential PO numbers mapped to invoice numbers lets you quickly answer audit queries and catch duplicate billing.

Digital purchase orders replace printed forms entirely — send by email, get an acceptance reply, and file the PDF with the matching invoice and payment record.

The Crafex generator keeps your company letterhead, tax lines and terms consistent on every PO you issue.

As purchase volumes climb, informal approval stops scaling. The standard control is a short chain: requisition from the department, quote comparison by purchasing, approval by the budget owner, and issue of the purchase order. Each step leaves a record the next step references.

Even a two-person finance team benefits from a written rule — 'no purchase order, no purchase above ₹10,000' — because it forces the discipline that catches over-buying before payment.

The three-way match — purchase order, goods-received note and vendor invoice — is the check that finds wrong prices, un-delivered lines and double bills. Compare each line: description, quantity received, unit price and tax rate, all against the purchase order terms.

When a line differs, hold only that line for correction rather than blocking the whole invoice. Approval of the clean remainder keeps vendor goodwill while the disputed line resolves.