Invoice, Purchase Order & Quote Templates for Excel and Google Sheets
A purchase order, a quote, and an invoice look similar at a glance — line items, quantities, a total — but they mark different stages of a transaction and mixing them up creates real problems: a vendor can't fulfill against a document that isn't actually an authorized order, and an invoice without a matching PO number is harder to approve for payment.
The purchase order template here is built specifically as an authorization document: a PO number, vendor details, line items, and a status field, formatted the way a vendor and your own accounts payable process both expect to see it.
Free templates
PO numbers and three-way matching
A purchase order's job is to authorize a purchase before it happens, with a unique PO number that ties together everything downstream: the vendor's shipment, the packing slip, and eventually the invoice. Accounts payable teams use that number for three-way matching — confirming the PO, the receiving record, and the invoice all agree on quantity and price before releasing payment. Without a consistent PO number on every order, that check has to be done manually against memory or email threads.
The template assigns and tracks that number for every order automatically, along with a status field (open, received, closed) so you can see at a glance which orders are still outstanding.
Quotes, purchase orders, and invoices: what each document does
A quote is a proposed price before a commitment is made — it's not binding and can change. A purchase order is the buyer's authorization to proceed at agreed terms, issued after the quote is accepted. An invoice is the seller's request for payment after the goods or services are delivered, referencing the PO number for approval. Treating these as interchangeable documents is a common source of billing disputes, since each one carries a different legal weight and a different point in the transaction.
Keeping the purchase order as its own tracked document, rather than folding it into an invoice or an email approval, is what makes it possible to catch a pricing or quantity discrepancy before payment goes out instead of after.
Tracking outstanding orders and vendor spend without software
Once you're issuing more than a handful of purchase orders a month, the question stops being about any single order and becomes about which ones are still open, which vendors you're spending the most with, and whether anything's overdue for delivery. A spreadsheet handles that as long as every order lands in one log with a consistent status field, rather than scattered across separate emails or paper copies that only get checked when something goes wrong.
That single log also makes it easy to filter by vendor at the end of a quarter, which is useful both for negotiating better terms with a supplier you're spending heavily with and for spotting a vendor whose orders keep running late. None of that requires procurement software; it just requires every PO to actually get logged in the same place instead of living in whichever inbox it was issued from.
Frequently asked questions
Is the purchase order template free?
Yes, the purchase order template is free to download in both Excel and Google Sheets.
Does the template assign PO numbers automatically?
It provides a structured PO number field per order so you can track and reference each order consistently; you set your own numbering sequence within that structure.
What's the difference between a purchase order and an invoice?
A purchase order is the buyer's authorization to proceed with a purchase at agreed terms. An invoice is the seller's request for payment after delivery, typically referencing the PO number. They serve opposite sides of the same transaction.
Can I track the status of multiple purchase orders at once?
Yes, the template includes a status field per order (such as open, received, or closed) so you can see all outstanding purchase orders in one view rather than checking each one individually.
Does this template require macros to function?
No. It uses standard formulas only, as a matching Excel and Google Sheets build, with no macros required.