01Free Template · Excel and PDF
Purchase Order Template: Free Excel PO with 3-Way Match (+ PDF)
Free purchase order template in Excel and PDF, with a three-way match sheet that compares PO, receipt and supplier invoice and flags lines to hold.

What Belongs on a Purchase Order
| Field | Example | Why purchasing and accounting need it |
|---|---|---|
| PO number | PO-2026-0412 | The reference the supplier repeats on the packing slip and invoice |
| Item, quantity, unit | A-100, 500 pcs | Exactly what was ordered, in the unit you receive and count in |
| Unit price | $6.40 | The agreed price the invoice is checked against |
| Required by | 12/05/2026 | The delivery date the supplier commits to |
| Freight terms | FOB Destination | Who pays the freight and who carries the risk in transit |
| Payment terms | Net 30 | When payment is due after the invoice |
| Authorized by | Name and date | Shows the order was approved before money was committed |
Three-Way Match: Pay Only for What You Ordered and Received
A three-way match compares three documents before a supplier invoice is paid: the purchase order (what you ordered and at what price), the receiving record (what actually arrived) and the supplier invoice (what you are asked to pay). It is an internal control, and it catches short shipments, double billing and price changes.
- 1. Copy the PO lines to the match sheet: item, quantity and unit price.
- 2. Enter the received quantity from the packing slip after the dock has counted.
- 3. Enter the invoiced quantity and price from the supplier's invoice.
- 4. Read the status. A line is "OK to pay" when you were not billed for more than you received and the price is within your tolerance (2% by default). Anything else shows "Hold: review".
In the sample row, 500 pieces were ordered and invoiced but 480 arrived: the sheet holds the line with a variance of 20.
From a PO Spreadsheet to a Purchasing Process
The match sheet works for a handful of orders. With dozens of open POs, the comparison has to happen where the documents already are. In Draivix, Purchase Orders & RFQs create the order, the warehouse records the receipt, AI invoice capture reads the supplier invoice from the mailbox, and accounts payable approval compares the invoice with its purchase order and goods receipt before anyone can pay it. A person approves; the system does the comparing. The full sequence is in the ERP procurement process guide.
02Frequently Asked Questions
What is the difference between a purchase order and an invoice?
The buyer issues a purchase order to order goods or services at an agreed price. The supplier issues an invoice afterwards to request payment. The invoice should repeat the PO number so the two can be matched.
What is a three-way match in accounts payable?
It is a check that the purchase order, the receiving record and the supplier invoice agree on quantity and price before the invoice is paid. A two-way match compares only the PO and the invoice.
What does FOB Destination mean on a purchase order?
The seller is responsible for the goods and the freight until they reach the buyer's location. Under FOB Origin, responsibility passes to the buyer when the goods leave the seller's dock.
Is a purchase order legally binding?
A purchase order is an offer to buy; it generally becomes a binding contract once the supplier accepts it, for example by confirming the order or shipping the goods. For specific situations, ask your attorney.
03More Free Tools
Related Templates & Calculators
- Work Order Template: Service & Maintenance (Excel, PDF)Free work order template in Excel and PDF for service, maintenance and installation jobs: asset, work performed, parts, labor, tax and customer sign-off.Open
- RFID Time Clock System: Badge Readers, Cards & SetupHow an RFID employee time clock works, whether your existing access cards can be reused, what a badge reader needs on site, and what US law asks you to record.Open
- 2-2-3 Shift Schedule Template (Pitman, Excel & PDF)Free 2-2-3 shift schedule template for four crews on 12-hour shifts, with weekly hours per crew and the workweek start that cuts overtime from 20 hours to 8.Open
- DuPont Schedule Template: 12-Hour Rotation (Excel, PDF)Free DuPont shift schedule template: four crews, 12-hour day and night shifts over a 28-day cycle with a 7-day break. Weekly hours and overtime explained.Open
Let’s start together
Tell us how your business works.
We will show you what a system that takes over part of that work could look like.
Book a consultation