What does a simple purchase order template look like, and can I use one today?
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.
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:
| Section | Fields | Why it matters |
|---|---|---|
| Header | Company name and logo, PO number, PO date, quote reference | The PO number links the order, the delivery and the invoice |
| Buyer | Bill-to address, contact name, email, phone | The supplier knows who to ask and where to bill |
| Vendor | Name, address, contact, vendor ID | One clean record per supplier |
| Shipping | Ship-to address, required date, shipping method, terms | A missing ship-to sends goods to the wrong place |
| Line items | Item code (SKU), description, quantity, unit of measure, unit price, line total | Codes and units beat vague words |
| Totals | Subtotal, discount, tax, shipping, total due | Let the sheet calculate them |
| Terms | Payment terms, special instructions, cost center | Sets expectations before shipping |
| Approval | Approved by: name, title, date | Shows 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.
- Open a new workbook and name the first tab "PO".
- Put your logo and company name at the top.
- Make a header block for PO number, date, vendor, bill-to and ship-to, with labels in one column and values in the next.
- Build the line table: line number, item code, description, unit of measure, quantity, unit price, line total.
- 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.
- Add payment terms, instructions and an approval line under the table.
- Add dropdown lists (called data validation) for the unit of measure and the vendor name. This stops typing errors.
- Freeze the header rows and lock the formula cells so nobody types over the math.
- Add a second tab called "PO log" with one row per PO: number, date, vendor, total, approver, status and delivery date.
- 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
- Get a written price from the vendor and check it against your budget.
- Fill in the core fields: number, date, vendor, ship-to, items, quantities, prices.
- 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.
- 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)
| Line | Item code | Description | Unit | Qty | Unit price | Line total |
|---|---|---|---|---|---|---|
| 1 | CPLG-050-BR | Brass coupling, 1/2 in. | CASE of 50 | 10 | $42.00 | $420.00 |
| 2 | VLV-100-SS | Stainless valve, 1 in. | EA | 24 | $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 number | Vendor | PO total | Received | Invoice | Match |
|---|---|---|---|---|---|
| PO-2026-0007 | Northline Fittings | $924.00 | All lines | $924.00 | Yes, pay |
| PO-2026-0008 | Harbor Packaging | $1,500.00 | 3,000 of 5,000 units | $1,500.00 | No: invoice covers goods not yet received |
| PO-2026-0009 | Ridge Tools | $310.00 | All lines | $325.00 | No: 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) →