Free Excel download β’ Edit online β’ Save & share with Drive β’ Export to PDF
A Purchase Order (Excel) is a spreadsheet-based commercial document a buyer sends to a supplier to formally authorize the purchase of specified goods or services at agreed prices, quantities, and delivery terms. It captures every material detail of the transaction β PO number, vendor identification, itemized line items with auto-calculated totals, ship-to address, payment terms, and an authorized signature β in a single printable and emailable file. Once the supplier accepts the PO, it functions as the binding record of what was agreed before any goods ship or work begins.
Without a purchase order, you have no written record of what you authorized, at what price, or by when β and disputes with suppliers default to whoever can produce better documentation. Receiving staff have no basis to verify incoming shipments, accounts payable has nothing to match against the supplier's invoice, and overpayments or duplicate payments go undetected. A properly completed PO closes all three gaps: it gives your team a clear receiving checklist, gives your finance team the reference document for three-way matching, and gives your supplier a confirmed, unambiguous order they can fulfill without back-and-forth. This template lets you issue a professional, complete purchase order in under five minutes.
| If your situation is⦠| Use this template |
|---|---|
| Ordering physical goods or inventory from a domestic supplier | Purchase Order (Excel) |
| Requesting services rather than goods from a vendor | Service Purchase Order |
| Placing a cross-border order requiring customs documentation | International Purchase Order |
| Pre-authorizing repeat orders on a recurring schedule | Blanket Purchase Order |
| Requesting quotes from multiple suppliers before committing | Request for Quotation (RFQ) |
| Confirming a supplier's terms before the first purchase | Vendor Agreement |
| Recording what was actually received against what was ordered | Goods Receipt Note |
Why it matters: An unsigned PO is not a binding internal commitment. If the purchase is questioned later, there is no documented approval and the company may be unable to enforce agreed pricing.
Fix: Build the authorization step into your workflow before the PO leaves the building β require a signature from the budget owner for any order above a defined threshold.
Why it matters: Descriptions like 'office supplies' or 'parts' give receiving staff no basis to verify what arrived, and give suppliers room to substitute cheaper items.
Fix: Include the product name, model or SKU number, and any relevant specification β enough detail that a receiving clerk who was not involved in ordering can confirm the right item arrived.
Why it matters: If you leave the PO payment terms blank, the supplier's invoice terms control β and they may set Net 15 when your cash flow requires Net 30.
Fix: Always state your payment terms explicitly on the PO and confirm them with the supplier before the order is placed.
Why it matters: Deliveries routed to a billing address instead of a warehouse or job site cause delays, rerouting fees, and in some cases lost shipments.
Fix: Maintain a verified list of ship-to addresses in your master PO template and select the correct one before each order rather than copying from the previous PO.
Fill in your legal business name, address, and the name of the person placing the order. Then add the supplier's legal name, address, and accounts-receivable contact.
π‘ Save a version with your buyer information pre-filled as a master file β you only need to update vendor details for each new order.
Use a sequential numbering format such as PO-YYYY-NNNN and enter today's date. The PO number is the primary key for matching the order to the supplier's invoice.
π‘ A four-digit year prefix keeps POs sortable and prevents number collisions when the calendar rolls over.
Enter the specific date by which you need the goods or services delivered. Confirm this is achievable given the supplier's standard lead time before sending.
π‘ Add two business days of buffer to your true need date β this gives you room to follow up without disrupting your operations.
List each product or service on its own row with a clear description (including model number, SKU, or specification), the quantity, and the agreed unit price. The template calculates line totals automatically.
π‘ Copy the exact product description from the supplier's quote or catalog to eliminate substitution disputes at receiving.
Enter the applicable sales tax rate and any agreed shipping charge. Verify the grand total matches the supplier's quoted amount before sending.
π‘ If shipping terms are FOB destination, the supplier bears freight cost β set the shipping field to $0.00 and note 'FOB Destination' in the delivery instructions.
Confirm the correct delivery address β warehouse, job site, or office β and add any instructions the carrier needs, such as dock number, receiving hours, or a contact name.
π‘ A wrong ship-to address is the single most common cause of delayed deliveries; double-check it against your most recent confirmed shipment to the same location.
Have the appropriate approver sign the PO before transmitting it to the supplier. Send it as a PDF export or via email, and retain the editable Excel file for your records.
π‘ Ask the supplier to reply with a written order confirmation referencing your PO number β this confirms they received it and agree to the terms.
A purchase order is a commercial document issued by a buyer to a supplier that formally authorizes the purchase of specified goods or services at agreed prices and delivery terms. Once the supplier accepts it, the PO becomes a binding agreement between the two parties. It also serves as an internal spending-control and audit document.
At minimum: a unique PO number, the buyer's and supplier's legal names and addresses, the order date, a required-by date, itemized line items with descriptions, quantities, unit prices, and totals, the ship-to address, payment terms, and an authorized signature. Missing any of these commonly causes invoice-matching failures or delivery problems.
A purchase order is generally considered a binding contract once the supplier accepts it β either in writing or by beginning to fulfill the order. The PO sets out the offer (quantity, price, terms), and the supplier's acceptance creates the agreement. Consider consulting a lawyer if your orders involve high-value goods or complex terms.
A purchase order is issued by the buyer before delivery to authorize the purchase. An invoice is issued by the supplier after delivery to request payment. They should reference each other by PO number so both parties can match them during accounts-payable processing β this is the basis of a three-way match.
A three-way match is an accounts-payable control that compares three documents before approving payment: the purchase order, the supplier's invoice, and the goods receipt note. All three must agree on item, quantity, and price. It prevents overpayment, duplicate payments, and payment for goods that were never received.
Use a PO whenever you want a documented, pre-approved record of what was ordered before the supplier ships. This is especially important for purchases above an internal approval threshold, orders involving multiple line items or custom specifications, recurring supplier relationships, or any purchase that needs to be matched against a budget line.
Use a sequential format that includes the year β for example, PO-2026-0001 through PO-2026-9999. The year prefix keeps orders sortable and prevents number conflicts across fiscal years. Never reuse a PO number; if an order is cancelled, mark that number void in your log and move to the next one.
Yes. Replace product descriptions with service descriptions β for example, "IT Support Services β May 2026, 20 hours @ $95/hr" β and leave the ship-to field blank or enter the service delivery location. The line-item structure and approval block work the same way for services as for goods.
An invoice is issued by the supplier after delivery to request payment. A purchase order is issued by the buyer before delivery to authorize the purchase. They document the same transaction from opposite sides of the timeline and should reference each other by PO number for three-way matching.
An RFQ asks suppliers to submit pricing for goods or services before any commitment is made. A purchase order is issued after a supplier is selected and pricing is agreed β it is the commitment document. Use an RFQ to solicit and compare bids, then issue a PO to the chosen supplier.
A purchase requisition is an internal request from a department to the procurement team asking for approval to buy something. A purchase order is the external document sent to the supplier once that internal approval is granted. Large organizations use both; small businesses often skip the requisition and go straight to a PO.
A vendor agreement sets the long-term terms and conditions governing a supplier relationship β pricing frameworks, warranties, liability, and dispute resolution. A purchase order is a transaction-level document that authorizes a specific order under those terms. High-volume supplier relationships typically need both.
SKU-level ordering with agreed unit costs, minimum order quantities, and lead times tied to inventory replenishment cycles.
Material and equipment orders tied to specific job numbers, with delivery to job-site addresses and cost codes for project accounting.
Raw material and component ordering with precise specifications, approved vendor lists, and delivery windows tied to production schedules.
Software subscriptions, subcontractor engagements, and equipment purchases with clear approval chains and budget-code references.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small businesses, startups, and any buyer issuing standard domestic purchase orders | Free | 5 minutes per order |
| Template + professional review | Businesses adding custom approval workflows, cost-code fields, or multi-currency support | $0β$100 (bookkeeper or operations consultant review) | 1β2 hours |
| Custom drafted | Enterprise procurement with ERP integration, complex multi-site routing, or regulated purchasing requirements | $500β$3,000+ (developer or ERP configuration) | 1β4 weeks |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
