Skip to content

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.

Purchase order template in Excel with three-way match sheet

What Belongs on a Purchase Order

FieldExampleWhy purchasing and accounting need it
PO numberPO-2026-0412The reference the supplier repeats on the packing slip and invoice
Item, quantity, unitA-100, 500 pcsExactly what was ordered, in the unit you receive and count in
Unit price$6.40The agreed price the invoice is checked against
Required by12/05/2026The delivery date the supplier commits to
Freight termsFOB DestinationWho pays the freight and who carries the risk in transit
Payment termsNet 30When payment is due after the invoice
Authorized byName and dateShows 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.

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