Reviewed & updated by WordNExcel Team — Updated November 6, 2026
A purchase order template helps your business order goods and services in writing, with a clear price, quantity, delivery date and approval before any money is committed. On this page you can use the free purchase order calculator above to total an order with tax and shipping and check it against your approved budget, then download five free purchase order templates in Excel: a standard purchase order, a service purchase order for labour and work, and a blanket purchase order with a spending limit, plus a purchase order register and a goods receipt note (GRN).
Each file is a real, editable .xlsx spreadsheet created for this page. Line amounts, subtotal, tax, shipping and the order total are calculated automatically, and the blanket order also shows how much of the agreed limit remains. The templates open in Excel, Google Sheets and LibreOffice Calc, and each one prints on a single page or saves as a PDF to email to the supplier.
Purchase Order Calculator
| Item | Qty | Unit price | Amount |
|---|
Runs in your browser; nothing is sent or saved. Tax is applied to the subtotal before shipping.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is a Purchase Order?
A purchase order, usually shortened to PO, is a document a buyer sends to a supplier to order specific goods or services at an agreed price. It lists the PO number, date, supplier, delivery address, the items with quantities and prices, the total, the payment terms and the expected delivery date. When the supplier accepts the purchase order, it becomes a binding agreement for that order.
Purchase orders give the buying business control over spending. Every order has a number, an approval and a written record of what was agreed, which makes it much easier to check deliveries, match supplier invoices and stop unauthorised purchases.
Purchase Order vs. Invoice vs. Quote
These documents follow each other in a typical purchase. The supplier may first send a quote stating the price. The buyer then sends a purchase order to place the order. After delivery, the supplier sends an invoice asking for payment. The buyer's accounts team checks that the invoice matches the purchase order and the goods actually received before paying. This check is often called a three-way match.
How to Use the Purchase Order Calculator
Type each item, its quantity and its unit price into the table, then enter the tax rate and the shipping charge. The calculator shows the subtotal, tax, shipping and the PO total as you type. If you enter an approved budget, it also tells you whether the order is within budget or by how much it is over.
With the example figures, ten boxes of copy paper, four toner cartridges and six desk organisers make a subtotal of 587.00. Tax at 8% adds 46.96 and shipping adds 25.00, for a total of 658.96. The calculator runs entirely in your browser and nothing is saved or sent.
Download the Free Purchase Order Templates
The five Excel files below cover ordinary goods, services and repeat orders under an agreed limit.
Purchase Order Template
The standard purchase order has a header for your company details, boxes for the PO number, PO date, vendor, ship-to address, delivery date and payment terms, and a 15-line item table with item number, description, quantity, unit price and amount. Subtotal, tax, shipping and the total are worked out automatically, with an authorisation line at the bottom.

Service Purchase Order
When you are buying work rather than products, such as repairs, maintenance, cleaning or consulting, this version replaces quantity and unit price with hours and rate. It is useful for keeping contractors and service providers to an agreed cost.

Blanket Purchase Order
A blanket purchase order covers repeated purchases from one supplier over a period, up to an agreed spending limit. Enter the blanket limit and the sheet shows the remaining amount after the items on the order. It suits regular supplies such as stationery, cleaning products or packaging.

Purchase Order Register

A control sheet for every PO you raise. Enter the PO number, vendor, description, date, amount, value already received, status (draft, open, partial, closed or cancelled) and due date. Open and partial rows are highlighted, and the header counts how many POs are still open and their remaining value. Purchasing and finance both use this to stop duplicate orders and to chase late deliveries. Export or filter by vendor before a supplier meeting. The sample shows three POs in different statuses.
Goods Receipt Note

Records what actually arrived against a purchase order. Enter each item with quantity ordered, quantity received and unit price; the line total uses the received quantity. Link the GRN to the PO number and vendor in the header. Short deliveries stay visible so you can chase the balance or short-pay the invoice. Warehouse and accounts should both keep a copy. The sample GRN shows a partial toner delivery still on backorder.
What to Include in a Purchase Order
- PO number: a unique, sequential number the supplier must quote on the invoice.
- PO date and the expected delivery date.
- Buyer details: company name, address, phone and email, and the person to contact.
- Vendor details: the supplier's name and, ideally, their address and account number.
- Ship-to address, if different from the billing address.
- Items: item or part number, a clear description, quantity, unit price and line amount.
- Subtotal, tax, shipping and total.
- Payment terms, such as Net 30 or payment on delivery.
- Special instructions: delivery times, packing requirements or quality standards.
- Authorisation: the name and signature of the person approving the order.
How to Fill In a Purchase Order
- Enter your company details in the header.
- Type the next PO number in sequence and the date.
- Enter the vendor name and the ship-to address.
- Enter the required delivery date and the agreed payment terms.
- List each item with its item number, description, quantity and unit price. The amount is calculated for you.
- Check the tax rate and enter the shipping charge.
- Review the total, then have the order authorised.
- Save a copy, export it as a PDF and send it to the supplier.
- Ask the supplier to confirm the order and the delivery date in writing.
Approving Purchase Orders
Purchase orders work best with a simple approval rule. Decide who can approve orders and up to what amount. For example, a department manager may approve orders up to a set limit, while larger orders need the owner or finance manager. Write the rule down and apply it every time. Checking the total against an approved budget before the PO goes out, as the calculator does, stops overspending before it happens rather than after the invoice arrives.
Receiving Goods and Matching Invoices
When the goods arrive, check them against the purchase order. Count the items, check that they are the right products and inspect them for damage. Note any shortages or damaged items on the delivery note and tell the supplier straight away. When the invoice arrives, compare it with the purchase order and what you received. Pay only for what was ordered and delivered at the agreed price. If something does not match, contact the supplier before paying.
Numbering and Filing Purchase Orders
Use a clear numbering system, such as PO-2026-001, and never reuse a number. Keep a simple log of all purchase orders with the number, date, supplier, total and status: open, partly received, received or closed. File the purchase order with the delivery note and the matching invoice, so anyone can see the full history of the purchase. At the end of each month, review open orders and follow up any that are overdue.
Purchase Order Tips for Small Businesses
- Use a PO for every significant purchase. Even small businesses benefit from a written record of what was ordered and at what price.
- Describe items precisely. Include sizes, colours, part numbers or specifications so the supplier sends exactly what you need.
- Confirm prices first. Base the PO on a written quote so there are no surprises on the invoice.
- Agree delivery dates. A delivery date on the PO gives you a clear basis to follow up late orders.
- Keep suppliers informed. If you need to change or cancel an order, send a revised PO with the same number and a revision note.
- Review spending. Totals from your PO log show which suppliers and categories you spend the most on, which helps when negotiating better terms.
Sending Purchase Orders as PDF
To send a PO, use File > Save As or Export and choose PDF in Excel, or File > Download > PDF in Google Sheets. The print area is already set, so the order fits on one page. Name the file with the PO number and supplier, such as "PO-2026-001-Vendor-Name.pdf".
Related Templates
You can also check these important templates like the packing slip templates for checking what arrives with each delivery, and the service invoice templates for the invoices your suppliers send.
You may also like the price list templates for keeping your own product prices up to date.
Frequently Asked Questions
What is a purchase order used for?
A purchase order is used by a buyer to order goods or services from a supplier at an agreed price. It records what was ordered, when it is due and who approved it.
Is a purchase order legally binding?
Once the supplier accepts it, a purchase order usually forms a binding agreement for that order. Check the rules where you do business and include your terms on the PO.
What is a blanket purchase order?
A blanket purchase order covers repeated purchases from one supplier over a period, up to an agreed spending limit, so you do not need a new PO for every small order.
Can I use the purchase order template in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas keep working.
How do I number purchase orders?
Use a unique, sequential number for every PO, such as PO-2026-001, and never reuse a number, even if an order is cancelled.
What is a three-way match?
It is the check that the purchase order, the goods received and the supplier's invoice all agree before the invoice is paid.
