Purchase Order Template vs PO Software: When the Spreadsheet Stops Working
What a purchase order template must include, a filled-in PO followed through to the invoice, how to keep a PO spreadsheet honest, and the seven signs it is time for purchase order software.
A purchase order template is enough when one person raises POs, approvals happen face to face, and you send fewer than about ten a month. Our free template pack (Excel with automatic PO numbering and a tracker tab, opens in Google Sheets, plus a Word PO form) covers that stage well. The spreadsheet stops working at roughly 20 people or 30 POs a month: two people take the same PO number, approvals happen in the hallway with no record, nobody checks the budget before ordering, and the invoice gets paid without anyone comparing it to what arrived. That's the point where PO software replaces the template: it numbers, routes, checks the budget and matches the invoice on its own.
Below: how Foxpedite replaces the PO spreadsheet, the free template if you're not there yet, a filled-in example from a small manufacturer, and the seven signs your spreadsheet has stopped working.
How Foxpedite does it: the PO spreadsheet, without the spreadsheet
Here's the same workflow your template runs by hand, the way Foxpedite runs it, for the company still running purchasing on spreadsheets, email and QuickBooks.
- The requester drafts the purchase. The production lead fills a short request: item, vendor, quantity, price, job. No asking the office manager to type it up.
- The PO number assigns itself. Foxpedite numbers every PO automatically, in your format. Two people can't take PO-0418 at the same time.
- Gate 1: budget at draft (Draft-Stage Budget Lock). The moment the request is drafted, Foxpedite reserves it against the job or department budget. Overspend shows at the request, not at month-end.
- Gate 2: approval routed by amount and department. The plant manager gets an email and approves from it. The office manager stops being the router, and the audit trail records who approved what, and when.
- The PO goes to the vendor as a PDF, by email, once it's approved.
- Receiving logs what arrived against the PO, including partial deliveries.
- Gate 3: the invoice pays only when PO, receipt and invoice match. If the vendor bills for 25 bars and 20 arrived, the invoice is held, not paid.
- QuickBooks Online sync. Approved POs, vendors and matched bills sync to QuickBooks Online, so nothing is typed twice.
Pricing, published: Regular $390/month (10 users included) covers automatic numbering, budgets and three-way match. Approval routing with approve-from-email and the QuickBooks Online sync are on Advanced, $740/month (20 users included). Extra users are $39/month. The 14-day trial includes every Advanced feature and needs no card. The template pack keeps one row per PO with standard columns, so moving your open POs later is a CSV import, not a rebuild.
Try Foxpedite free for 14 days
Put this week's POs through it instead of the spreadsheet: numbered, approved from email, matched before payment. Every Advanced feature, no credit card.
Start your free trial → · Prefer to start by hand? Get the free PO Template Pack
The free purchase order template (the manual version)
If you're not at 20 people yet, start with a template. Use it on purpose, and know where it stops.
| Format |
Best for |
Auto-numbering |
Tracker tab |
QBO column map |
| Excel (.xlsx) |
Office or ops manager raising most POs |
(formula, next number from the log) |
|
|
| Google Sheets (import the .xlsx) |
Several people sharing one file |
(formula) |
|
|
| Word (.docx) |
Occasional POs; save as PDF to send |
❌ (manual) |
❌ |
❌ |
| Foxpedite |
20+ people or 30+ POs a month |
automatic, can't collide |
live status |
syncs to QuickBooks Online |
The QBO column map shows which column in the tracker goes to which QuickBooks Online field. QuickBooks imports bills but not purchase orders, so the pack builds bill-import rows from invoiced POs. (QuickBooks Online creates POs only on Plus and Advanced; see our QuickBooks Online purchase orders guide.)
Fields every PO template needs: a unique PO number (never reused), PO date, buyer and vendor details, ship-to, line items (item, description, quantity, unit, unit price, line total), subtotal, tax, shipping, total, payment terms, requested delivery date, approver name and date, and one instruction to the vendor: "Quote this PO number on every invoice and packing slip." Nice to have: department or job code, GL account, requested by, freight terms. That last must-have is the one most templates skip, and it's what makes matching possible later. In Foxpedite, the PO number, approver and date are filled in for you.
Prefer to start by hand? Free: PO Template Pack (Excel + Google Sheets, auto-numbering, QBO column map)
An auto-numbered PO log with status and approvals, a printable PO form, a QuickBooks Online column map and a Word PO form. Blue notes in the file mark each step Foxpedite automates.
Get the template pack → · Or skip the manual version: try Foxpedite free for 14 days
A filled-in PO, followed through to the invoice
Example scenario: a light manufacturer orders bar stock (illustrative)
Example scenario. A 60-person machine shop needs 6061 aluminum bar stock for a customer job. The production lead asks the office manager for it. Here's the PO, field by field:
| Field |
Entry |
| PO number |
PO-2026-0418 |
| PO date |
Nov 16, 2026 |
| Vendor |
Example Metals Supply (fictional) |
| Ship-to |
Plant 1 receiving dock |
| Job code |
JOB-7731 |
| Requested by |
Production lead |
| Line 1 |
6061-T6 round bar, 2" dia., 12 ft — qty 40 × $118.00 = $4,720.00 |
| Line 2 |
6061-T6 flat bar, 1/2" × 4", 12 ft — qty 25 × $96.50 = $2,412.50 |
| Line 3 |
Cut-to-length charge — qty 1 × $145.00 = $145.00 |
| Subtotal |
$7,277.50 |
| Freight |
$210.00 |
| Sales tax |
$0.00 (resale certificate on file for job material — confirm with your accountant) |
| Total |
$7,487.50 |
| Terms |
Net 30 |
| Approved by |
Plant manager, Nov 16 |
Ten days later, the vendor ships 40 round bars and 20 flat bars (5 on backorder) and invoices the full $7,487.50.
- With the template: the receiving clerk has to remember to mark 20 of 25 flat bars received in the tracker. AP has to compare invoice to PO and receipt by eye: 25 billed, 20 received, a difference of 5 × $96.50 = $482.50. If both of those happen, AP short-pays to $7,005.00 or holds the invoice. If either is skipped, the $482.50 gets paid for metal still sitting in the vendor's warehouse.
- In Foxpedite: the clerk logs 20 flat bars against PO-2026-0418 on the receiving screen. When the invoice lands, the 25-bar line doesn't match the receipt, so the invoice is held with the $482.50 difference shown. Nobody has to remember to look.
The workaround: keeping a PO spreadsheet honest (and where it breaks)
If you run the template, these rules keep it working for as long as possible.
- One source of truth for the next number. In the pack, the next number comes from the PO log. Never type it by hand. Where it breaks: two people working from two copies of the file.
- Prefix with the year (PO-2026-0418) and add a location code if you have more than one (PO-P1-2026-0418). Where it breaks: nowhere, and Foxpedite supports the same formats. Our guide to purchase order number formats has examples.
- Never reuse a voided number. Mark it VOID in the log.
- A status column: Open → Partially received → Received → Invoiced → Closed, with received quantity, invoice number and a variance column (invoice − PO). Turn the row amber when the variance isn't zero. Where it breaks: the status is whatever someone last typed, there's no record of who changed it, and the amber row only helps if someone opens the file before paying.
The pattern is the same every time: the template is right, but it depends on a person doing each step on time. Software makes each step a side effect of doing the work.
Seven signs your PO spreadsheet has stopped working
Spreadsheet AP is still common. In a Yooz-commissioned survey of more than 1,000 finance decision-makers across eight countries, more than 20% of businesses still processed AP in Excel, and only 18% had fully automated invoice processing (Yooz survey via CPA Practice Advisor, Sep 2021). That survey is dated and not US-only, but the pattern holds in most small companies we talk to.
| Signal |
What it looks like |
What Foxpedite does instead |
| Duplicate or skipped PO numbers |
Two POs with one number |
Numbers assigned automatically, never repeated |
| Approvals happen by hallway |
"He said yes" with no record |
Routed by amount and department; approve from email, with an audit trail |
| You find overspend at month-end |
Job over budget, discovered in the P&L |
Budget reserved and checked at the draft |
| Receipts live in a folder |
Packing slips in a drawer |
Receipts logged against the PO |
| One person is the system |
Office manager on vacation = nothing moves |
Requests route themselves, with escalation |
| Re-keying into QuickBooks |
Every PO typed twice |
Sync to QuickBooks Online (Advanced plan) |
| 30+ POs a month |
Tracker has hundreds of rows |
Live status per PO, no filtering |
Example scenario: what the admin time costs (illustrative)
Example scenario. The machine shop raises 45 POs a month. The office manager spends about 25 minutes per PO on the template workflow: numbering, chasing approval, logging receipt, matching the invoice and re-entering it in QuickBooks. That's 45 × 25 = 1,125 minutes, about 18.75 hours a month. At an employer cost of $36.73/hour (BLS ECEC June 2026, office & administrative support; use your own), that's about $689 a month of admin time, before counting any variance that slips through. Foxpedite Regular is $390/month; Advanced, with approvals from email and the QuickBooks sync, is $740/month. Time the workflow on five of your own POs in the trial before you decide.
That's not an argument that software is always cheaper. If you raise 8 POs a month, the same math is about $122 a month of time, and the template is the right answer for now. The procurement work nobody should still be doing by hand goes through which tasks are worth automating first.
Your PO spreadsheet breaks at 20 people. Start your 14-day Foxpedite trial
Automatic PO numbers, budget checked at the draft, approvals from the email, and invoices paid only on a match, synced to QuickBooks Online. Every Advanced feature, no credit card.
Start free, no card →
Not ready yet? The free PO Template Pack is the manual version: download it. Or take the 1-minute fit check.
Common questions
What should a purchase order template include?
At minimum: a unique PO number, date, buyer and vendor details, ship-to, line items with quantity and unit price, subtotal, tax, shipping, total, payment terms, delivery date, and the approver's name. Add a line asking the vendor to quote the PO number on invoices.
Is there a free purchase order template in Excel?
Yes. The Foxpedite PO Template Pack includes an Excel workbook with automatic PO numbering, a tracker, a printable PO form and a QuickBooks Online column map. It opens in Google Sheets, and a Word PO form is included. It's free with an email signup.
When should I switch from a purchase order template to PO software?
When several people raise POs, approvals happen without a record, you find overspend at month-end, or you re-key every PO into accounting. In practice that's around 20 people or 30 POs a month. Foxpedite's 14-day trial (every Advanced feature, no card) lets you run real POs through it before you decide.
What does PO software do that a spreadsheet can't?
It assigns PO numbers that can't collide, checks the budget when the purchase is drafted, routes approvals and records who approved, logs receipts against the PO, and holds an invoice that doesn't match. Foxpedite does all of that and syncs approved POs and matched bills to QuickBooks Online (Advanced plan, $740/month for 20 users).
How do I auto-number purchase orders in Excel or Google Sheets?
Keep every PO in a log and calculate the next number as the highest existing number plus one. Prefix it with the year. Never type numbers by hand, and never reuse a voided number. It still breaks if two people work from separate copies of the file.
Related reading
Sources
- Yooz-commissioned survey of 1,000+ finance decision-makers in eight countries, reported by CPA Practice Advisor, Sep 24, 2021. https://www.cpapracticeadvisor.com/accounting-audit/article/21238639/the-state-of-automation-in-finance
- Intuit, "Create and send purchase orders in QuickBooks Online" (plan availability), checked Oct 18, 2026. https://quickbooks.intuit.com/learn-support/en-us/help-article/purchase-orders/create-send-purchase-orders-quickbooks-online/L2mVpjOoq_US_en_US
- Intuit, "Import your bills in QuickBooks Online" (bills are importable; POs are not in the native import list), checked Oct 18, 2026. https://quickbooks.intuit.com/learn-support/en-us/help-articles/importing-your-bills/00/261324