What does a simple purchase order template look like, and can I use one today?

By Ranjit Bhinge, founder of Blur Studio · Updated · 6 min read

Short answer: A simple purchase order (PO) has a header, buyer and vendor details, a ship-to address, a line-item table, totals, payment terms and an approval line. You can build it in Excel or Google Sheets in about 20 minutes with the layout below. A spreadsheet works for a few POs a week. It stops working when several people issue POs, approvals take days, or you need to match each PO to receipts and invoices.

Ranjit Bhinge

You need a clean purchase order you can fill in and send today, and you want to know when a spreadsheet is no longer enough.

I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.

The fields every PO needs

A purchase order is a document a buyer sends a supplier to confirm what they want, how many, at what price and by when. Spendflo, a procurement software company, and Shopify, the online store platform, list similar fields in their free templates. Group them like this:

SectionFieldsWhy it matters
HeaderCompany name and logo, PO number, PO date, quote referenceThe PO number links the order, the delivery and the invoice
BuyerBill-to address, contact name, email, phoneThe supplier knows who to ask and where to bill
VendorName, address, contact, vendor IDOne clean record per supplier
ShippingShip-to address, required date, shipping method, termsA missing ship-to sends goods to the wrong place
Line itemsItem code (SKU), description, quantity, unit of measure, unit price, line totalCodes and units beat vague words
TotalsSubtotal, discount, tax, shipping, total dueLet the sheet calculate them
TermsPayment terms, special instructions, cost centerSets expectations before shipping
ApprovalApproved by: name, title, dateShows who allowed the spend

Take care with the unit of measure. A PO that says "100" is unclear. Write "100 CASE of 12" or "100 EA" on every line. Cleverence, a company that sells warehouse scanning software, names unit mismatches as a common PO error.

The smallest PO that still works

Spendflo says a full PO has about 25 fields, but the simplest usable one needs eight: PO number, date, vendor, ship-to address, item, quantity, unit price and total, plus an approver's signature. Start there if you are in a hurry and add fields as suppliers ask for them. Shopify's free online generator takes a middle path. It asks for your company details, the vendor, the PO number, PO date, delivery date, shipping method and shipping terms, then the items, with a tax rate you can edit. Shopify then emails you a link where you download the PDF.

How to build it in Excel or Google Sheets

The steps are the same in both tools.

  1. Open a new workbook and name the first tab "PO".
  2. Put your logo and company name at the top.
  3. Make a header block for PO number, date, vendor, bill-to and ship-to, with labels in one column and values in the next.
  4. Build the line table: line number, item code, description, unit of measure, quantity, unit price, line total.
  5. In the line total column, multiply quantity by unit price. The subtotal is the sum of the line totals. Add tax and shipping for the total due.
  6. Add payment terms, instructions and an approval line under the table.
  7. Add dropdown lists (called data validation) for the unit of measure and the vendor name. This stops typing errors.
  8. Freeze the header rows and lock the formula cells so nobody types over the math.
  9. Add a second tab called "PO log" with one row per PO: number, date, vendor, total, approver, status and delivery date.
  10. Test the formulas with real numbers. Add up one order by hand and compare.

Two details save trouble. In Excel, a dropdown comes from Data, then Data Validation, with Allow set to List and your choices in the Source box. Microsoft says the Stop error style makes people fix a bad entry, while the Warning style lets them carry on. To lock formulas, first unlock the cells people may type in (select them, open Format Cells, Protection, and clear Locked), then use Review, Protect Sheet. Microsoft warns that if you forget the password it cannot recover it, and that sheet protection is not meant as real security. In Google Sheets, Insert, then Dropdown, lets you list the choices or point to a range, and Google rejects anything not on the list unless you choose to show a warning instead.

Keep the master file unchanged and save a fresh copy for each PO with one file-name pattern, such as the PO number plus the vendor.

How to number purchase orders

Use one sequence that never repeats. A prefix and a year work well, for example PO-2026-0001. Spendflo says a PO number should be unique, sequential and never reused or skipped, and that you should void a number instead, so the sequence stays auditable. If an issued PO has to change, raise a numbered change order instead of editing the original. Spendflo says the same: never edit an issued PDF.

A simple process around the template

  1. Get a written price from the vendor and check it against your budget.
  2. Fill in the core fields: number, date, vendor, ship-to, items, quantities, prices.
  3. Get the budget owner's approval, and finance approval above your limit. Write the limits down. Set limits that fit your business, for example a manager up to one amount, purchasing up to a higher one, and a director above that.
  4. Save as a PDF, email it, ask the vendor to confirm, and record the number in your log.

A PO email you can copy

Subject: Purchase order [PO number] from [your company]

Hello [vendor contact],

Please find purchase order [PO number] attached. It covers [short description] with a total of [amount]. We need delivery to [ship-to address] by [date]. Payment terms are [terms].

Please reply to confirm the price and delivery date. If anything is wrong, tell us before you ship so we can issue a change.

Thank you,
[Name, title, phone]

Asking the vendor to confirm matters. A written acknowledgment by email is your proof that they accepted your price and terms.

Turn it into a processing tracker

Add a few columns to the PO log so the same file tracks what happens after you send: date sent, date confirmed, date received, quantity received, invoice number and invoice amount. Then add a "match" column that says whether the invoice, PO and receipt agree. That is a three-way match. For the full process, read purchase order processing.

A filled-in example (made-up figures)

LineItem codeDescriptionUnitQtyUnit priceLine total
1CPLG-050-BRBrass coupling, 1/2 in.CASE of 5010$42.00$420.00
2VLV-100-SSStainless valve, 1 in.EA24$18.50$444.00

Subtotal $864.00. Shipping $60.00. Total due $924.00 (tax left out for simplicity). Number PO-2026-0007, terms Net 30 (due 30 days after the invoice date), approved by the purchasing manager.

A filled-in PO log (made-up figures)

Here are three rows of the "PO log" tab, with the match column from the tracker above:

PO numberVendorPO totalReceivedInvoiceMatch
PO-2026-0007Northline Fittings$924.00All lines$924.00Yes, pay
PO-2026-0008Harbor Packaging$1,500.003,000 of 5,000 units$1,500.00No: invoice covers goods not yet received
PO-2026-0009Ridge Tools$310.00All lines$325.00No: price differs by $15.00, ask for a corrected invoice

Row two shows why the match column earns its place. The supplier billed in full, but only 3,000 of 5,000 units arrived, so the invoice waits. Row three is a price gap. Decide your tolerance in advance, for example a small percentage that passes on its own, and write it on the log tab.

Mistakes that cost money

Spendflo lists the usual ones. Raising the PO after the vendor has already shipped or started work leaves price and quantity uncontrolled. Vague descriptions cause wrong deliveries, so use item codes. Editing an issued PO instead of raising a numbered change order breaks the paper trail. Splitting one order into several to stay under an approval limit defeats the limit.

When a spreadsheet stops being enough

  • Two people issue POs and one reuses a number.
  • Approvals sit in someone's inbox for days.
  • You cannot tell what has arrived and what is still on backorder.
  • Someone retypes each PO into the accounting system after sending it.
  • You want suppliers or customers to order through a page, not a file.

At that point the fix is a small web tool that holds the PO log, approvals and links to your ERP. I wrote about turning a sheet like this into an app in Excel to web app.

How I'd approach this

Start with the spreadsheet. It costs nothing and it teaches you which fields your suppliers actually need. Lock the formulas, use dropdowns, number every PO and always send a PDF. Review the log once a month. If you keep fixing the same mistakes, or two people are stepping on each other, that is the signal to move to a tool with approvals and receiving built in.

Questions people ask

What should a simple purchase order include?

A unique PO number, the date, buyer and vendor details, the ship-to address, and line items with quantity, unit and unit price. Add totals, payment terms and the approver's name.

Does Excel have a purchase order template?

Spendflo offers a free one for Word, Excel, Google Sheets and PDF. Check that whichever you pick has approval fields and a PO log.

Is there a free purchase order template for Google Sheets?

You can build one for free with the fields above, and Spendflo's free template covers Google Sheets. Shopify also offers a free online PO generator you fill in step by step.

How do I send a purchase order to a supplier?

Save it as a PDF and email it with a short message that asks them to confirm price and delivery date. Record the PO number in your log.

When should I stop using a spreadsheet for POs?

When several people issue POs, approvals are slow, or you need to match POs to receipts and invoices. See purchase order processing and Excel to web app.

More in this topic: B2B: order entry and purchase orders (9 guides) →

Sources

Ready for the next step?

A 30 minute call. If you do not need me, I will tell you.

Ranjit Bhinge You talk to me, Ranjit. I reply within a few hours.

Not sure what you need? Tell me what is going on. I will point you the right way, even if it is not me.

Blur Studio · 30 minute call

Book a 30 minute call

You talk to me, Ranjit. If you do not need me, I will tell you.

  • We talk about your business and what is going on.
  • You leave with a clear next step, even if it is not me.
  • I reply to every message within a few hours.
Loading the calendar…