Purchase Order Template: Control Costs and Document Supplier Commitments

A purchase order turns a verbal agreement with a supplier into a written commitment: a specific item, a specific quantity, a specific price and a specific delivery date. The template on this page is ready in Excel, Word, PDF, Google Sheets and Google Docs, so you can fill it in and print it or send it to the supplier as it is.

Most supplier disputes do not start at the invoice. They start weeks earlier: a quantity agreed on the phone, a price that moved between the call and the delivery, or an item that arrived with different specifications. A written purchase order closes that gap and gives the warehouse and the finance team one reference to measure the delivery against.

Why you need a purchase order template

Buying without a written document feels faster at first, and the cost lands later: a price gap, a quantity that does not match what was asked for, or an invoice carrying an amount nobody agreed to. One approved purchase order template closes that gap, because it forces both sides to fix the details before anything leaves the supplier’s warehouse.

A company that issues orderly purchase orders knows at any moment what it ordered, at what price, from which supplier, and when the delivery is due. Finance sees the commitment before it turns into a payable, the warehouse prepares space and staff for a shipment whose details it already has, and procurement builds a record worth reading at the annual supplier review. And even in a small team where everyone knows everyone, the document protects the employee: whoever acted on a written, approved order is not asked later to answer for a decision they never made.

• Price and quantity on record: A signed price ends the argument when the invoice arrives higher, and protects the margin you calculated on a known cost.
• Visibility of upcoming commitments: The total of your open orders tells you how much cash will leave in the coming weeks, which no financial report shows before the invoices are issued.
• Faster inspection and receiving: The warehouse clerk matches what arrived against what is written, and rejects the excess or the wrong item before it enters the store.
• Better inventory planning: Tying orders to delivery dates reduces both stockouts and the overstocking that freezes cash on the shelf.

What is a purchase order?

A purchase order is a formal document you issue to a supplier stating what you intend to buy: items, quantities, agreed prices and delivery date. It precedes the purchase invoice and becomes binding once the supplier accepts it.

The point most teams miss: a purchase order creates no journal entry on its own. It does not move inventory and it does not move the supplier balance. It stays an organizational document until it is converted into a purchase invoice, and only then does the effect reach the books. That is why it belongs to the family of source documents that justify an entry later, not to the entries themselves.

In practice, ten open purchase orders change nothing on your balance sheet, yet they change your cash plan for the coming weeks, because each will become a payable within a known window. That is why open orders belong in an operational report rather than the trial balance.

Purchase requisition vs purchase order vs purchase invoice

Three documents that small companies routinely confuse, even though each serves a different purpose and is issued by a different party. The purchase requisition is internal: the department that needs the goods asks procurement to cover a shortage. The purchase order is external: procurement sends it to the supplier after the requisition is approved and the best offer is chosen. The purchase invoice comes from the supplier after delivery, and it is the only one of the three that carries an accounting and tax effect.

The confusion shows up in two ways. A company emails the internal requisition straight to the supplier, losing both the approval step and the comparison of offers. Or it books the purchase order as if it were an invoice, so a liability that does not yet exist appears on the supplier account. Because all three carry nearly the same items and quantities, telling them apart depends on who issues them, who receives them, and what they trigger:

The working rule: the requisition says “we need it”, the purchase order says “we have formally ordered it”, and the invoice says “we owe for it”. Using one document for all three jobs is how teams lose track of where an order stopped.

The fields in detail

• Both parties: Your company name, address and tax registration number, against the supplier’s name, contact details and VAT number. The supplier’s VAT number is not optional: without it you will not get a compliant tax invoice, and without that invoice you cannot deduct input VAT.
• Line items: Item description, your internal SKU, quantity, unit of measure (carton, piece, kg) and unit price. The unit of measure is the single most common source of delivery errors: ordered by the carton, delivered by the piece.
• Financial terms: Net total, VAT rate, any discount, the gross total, and the payment window. Tie that window to your cash calendar so you know when the money actually leaves.
• Logistics and approval: Delivery location, required delivery date, freight responsibility, and the approver’s signature. The signature is what gives the sheet its formal standing, internally and with the supplier.

Where the purchase order sits in the procurement cycle

The full cycle runs from an internal need to a settled supplier balance, and it passes through six stations, each with its own document. The purchase order is the turning point in the middle: before it, everything is an internal intention that can still be changed or dropped; after it, you hold a commercial commitment to an outside party.

Knowing where it sits prevents two frequent mistakes. The first is issuing the order before comparing offers, which costs you the leverage to negotiate price and payment terms. The second is issuing it only after the goods have arrived, which turns the document into paperwork that controls nothing. The detail is in The Procurement Cycle: From Planning to Financial Settlement and in the procure-to-pay cycle glossary entry.

Before you reach step three, run the earlier steps properly with the supplier RFQ template, so the order goes to the best price and terms rather than to whoever answered the phone first.

How to fill the template, step by step

Filling the template takes minutes, but it needs a fixed order so no field is dropped. Work from the top down: identify the parties, then the line items, then the numbers, then the terms, and last the approval. Do not send the order before checking the total line at least once, because most purchase order errors are simple arithmetic, not failed negotiation.

The example below applies the steps to a real case: a Riyadh retail business ordering from a food supplier, three items in different quantities, VAT at the 15% standard rate, and then a partial delivery smaller than the quantity ordered. Follow the figures to the end, because they show the gap between the order value and the invoice value, a gap that recurs constantly in food and building-material supply where exact quantities are hard to hit. The numbers are deliberately simple so you can check them yourself:

1. Number the order: Use a clear sequence such as PO-2026-0142. Never reuse a number, because duplicates break filing and matching later.
2. Set the dates: Issue date 2026-09-06, expiry date 2026-09-20. The expiry protects you from a late delivery at a price that no longer works.
3. Enter the line items: 120 cartons of water at SAR 22.00, 40 cartons of juice at SAR 48.50, and 15 cartons of tea at SAR 96.00.
4. Calculate the totals: 2,640.00 + 1,940.00 + 1,440.00 = SAR 6,020.00 net. VAT at 15% is SAR 903.00. The gross total is SAR 6,923.00.
5. Write the terms: Delivery to the Riyadh warehouse within 7 days, payment within 30 days of the invoice date.
6. Approve and send: Have the authorized approver sign it, send it to the supplier, and keep one copy for the warehouse and one for finance.

Say only 110 cartons of water arrive instead of 120. The received value becomes SAR 5,800.00 net, VAT SAR 870.00, gross SAR 6,670.00. The invoice is issued for that amount, not for the original order value, and the difference stays open either for a later delivery or for closing the order short.

The journal entry belongs to the invoice, not to the order: inventory is debited SAR 5,800.00, input VAT is debited SAR 870.00, and accounts payable is credited SAR 6,670.00. The basics of that treatment are covered in accounts payable management.

Try Qoyod free for 14 days, no credit card required. Purchase orders are available on the Pro and Advanced plans.

Three-way matching before you pay

Three-way matching is the most important control in procurement: before any money goes out, you match three documents against each other and confirm they tell the same story. The idea is simple, the effect is not, because it blocks the three most common losses in a purchasing cycle: paying for goods that never arrived, paying above the agreed price, and paying twice for the same shipment.

In a small company one person runs the match before the payment is prepared. In a larger one the roles split: the warehouse confirms receipt, procurement confirms the price, and finance releases the payment. What matters is that the step exists in writing as part of your payment policy, not that a particular person performs it. Matching does not mean rejecting every difference, however small, but explaining it and having it approved by someone with the authority before payment:

• The purchase order: what you ordered, at the agreed quantity and price.
• The goods receipt note: what actually arrived after inspection. Use the goods receipt note template.
• The supplier invoice: what the supplier is asking you to pay.

Any difference between the three stops the payment until it is explained: a short delivery, a price above the agreement, or an item that was never ordered. Companies that skip this step discover the gaps months later, during reconciliation, when proving who was wrong is far harder.

Excel, Word, PDF or Google Sheets?

The template ships in five formats, and choosing between them is a question of function rather than taste. First question: does the document need to calculate for you? If the order carries several lines plus VAT and discounts, you need a spreadsheet with formulas, not a text document. Second question: how many people fill in and approve it? If more than one, and from different places, a shared cloud file saves more time than mailing copies back and forth.

Third question: what finally reaches the supplier? The answer is always a locked copy that cannot be edited, so the document you signed stays the document in the supplier’s hands. The format never changes the content or the standing of the order, only how easily your team works with it, so keep one approved copy that everyone refers to:

• Excel: Best when the order has many line items and you want formulas to calculate totals and VAT.
• Word: Fine for one or two line items, and for a formal letter-style document.
• PDF: The format you send to the supplier after approval, because the figures cannot be edited after signature.
• Google Sheets: The better choice when more than one person fills in or approves the order from different locations.

The rule: fill in Excel or Google Sheets, approve, then export a PDF and send that. Sending an editable file after approval opens the door to undocumented changes.

Purchase orders and VAT

A purchase order is not a tax document. It is not submitted to the Zakat, Tax and Customs Authority and it is not reported in the VAT return. The tax document is the purchase invoice issued by the supplier, and it alone gives you the right to deduct the input VAT charged at the 15% standard rate, when its conditions are met.

The distinction matters during an audit. An auditor does not treat purchase orders as tax documents, but may request them to show a purchase is genuine and tied to the company’s activity. Their value is evidential: the order does not set the tax treatment, the invoice does.

So keep the purchase order data identical to what will appear on the invoice: legal company name, VAT number, and item descriptions. Any mismatch complicates matching during an audit. For the invoice format itself, use the ZATCA-compliant tax invoice template, and review the e-invoicing requirements if your supplier is on Phase 2.

Seven mistakes that ruin purchase orders

None of the mistakes below is theoretical. They recur across small and mid-sized companies at similar rates, and most of them do not show their cost on the day: the bill arrives weeks later, at matching, at the stock count, or when the VAT return is prepared. The common thread is one document written in a hurry to close a conversation, rather than written to be read later by a third party.

Run through the list before you approve your final template and mark the ones that describe you today. Fixing two of them is usually enough to halve supplier disputes, because most disputes grow out of one small missing detail that could have been written in a single line when the order was issued. Note that four of the seven have nothing to do with price at all, but with description, timing and approval, the parts that get skipped because they do not feel financial at the moment of ordering:

• Issuing the order after delivery: A sheet written to justify a purchase already made controls nothing and cannot be matched.
• Leaving the unit of measure blank: “50 water” could be cartons or bottles, and the gap can run into thousands of riyals.
• No expiry date: The supplier delivers two months later at an old price, or goods you no longer need.
• Ignoring the supplier’s VAT number: The cost shows up late, when you cannot deduct input VAT.
• Verbal approval: An order without an approver’s signature does not survive a dispute.
• Never closing fulfilled orders: A list crowded with old open orders hides the ones that actually need chasing.
• Keeping orders in personal files: A file on the buyer’s laptop means the warehouse and finance cannot see what is coming.

The last one is the most damaging: when procurement is disconnected from inventory, reordering becomes guesswork. To fix that, work through reorder point and lead time, then apply the practices in Optimize Your Purchasing Management.

From the template to the system: purchase orders in Qoyod

A manual template is enough at the start. As suppliers and monthly orders multiply, its real cost appears: re-entering the same data on every order, orders whose status nobody knows without asking, and invoices paid without matching because the documents are scattered between an inbox and a file on somebody’s laptop.

The answer is not a better template, it is moving the whole cycle into one accounting system that ties the purchase order to the supplier, the item and the invoice. The order then becomes a live record with a known status instead of a sheet waiting to be remembered. That is what you actually get with purchase orders in the Qoyod purchases module, part of the sales and purchase modules, where data is entered once and recalled afterwards, so errors drop and issuing an order takes less time:

• Automatic numbering and saved data: The system assigns the order number (editable), and pulls supplier, item and default price data from your database instead of retyping it.
• Clear statuses: Draft, pending approval, approved, invoiced, late and cancelled. You can see where each order stopped without asking anyone.
• Permission-based approval: A user without approval permission saves the order as pending approval, and a user who holds the permission approves it with save and approve.
• Send it to the supplier: Print the order, download it as a PDF, or email it to the supplier from inside the system.
• Convert to a purchase invoice: The convert option opens an invoice prefilled from the order, and you can adjust quantity or price if the delivery differed from the order.
• Copy recurring orders: Duplicate an order with the same data, which is useful for repeat supply.
• Purchase order aging report: See approved orders not yet converted to invoices, with total value and count per supplier and a period-over-period comparison, so you chase the late ones before they become a supply problem.

Two points for accuracy: a purchase order in Qoyod has no accounting effect until it is converted into an invoice, and splitting one order across several invoices is done by creating each invoice manually rather than automatically. Purchase orders are available on the Pro and Advanced plans, not on the Basic plan. Plan details appear when you create an account.

Running the template day to day

How to keep a usable purchase order archive

• One naming pattern: Order number, supplier name, date, for example PO-2026-0142-Riyadh-Catering-2026-09-06. Alphabetical order alone then becomes a search tool.
• A folder per supplier: Orders, invoices and receipt notes together, so annual reconciliation means opening one folder.
• A central log: One sheet listing every order with its status, value and expected delivery date, updated weekly.

That log is the first thing an accounting system makes redundant, because the purchase order list inside it is current by design rather than by someone’s discipline.

Notes by sector

• Retail: Tie every order to current stock levels and the reorder point, because over-ordering turns into dead stock quickly.
• Restaurants: Short shelf-life items need smaller, more frequent orders with an exact delivery date rather than an open window.
• Contracting: Link the order to the project or contract number so the cost lands on the right project in profitability reporting.
• Spare parts and maintenance: State the part number and item code precisely, since near-identical parts are the norm.

When to move from a file to a system

• You issue more than 20 purchase orders a month, or work with more than 10 active suppliers.
• “Has this order arrived?” gets asked more than once a week.
• Book inventory and the physical count keep diverging, which is the theme of Periodic and Perpetual Inventory.

To organize supplier data properly from day one, use the new supplier onboarding template alongside this one.

Frequently Asked Questions

Download the template in the format that suits you and apply it to your next order this week. Once the volume outgrows a file, move the whole cycle into a system that links the purchase order to the invoice, the inventory and the supplier balance.