TOOLS CLUB TEMPLATE

Purchase Order Template

A purchase order is your formal commitment to a vendor before goods or services are delivered — it protects both sides by documenting exactly what was ordered, at what price, and under what terms. This template calculates your subtotal and total automatically as you build the order.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Businesses formally ordering from suppliers or vendors
Anyone who wants a clear paper trail before goods or services are delivered
Businesses whose vendors require a formal PO before fulfilling an order
Bookkeepers matching vendor bills against what was actually ordered

What's included

Vendor info and PO number fields
Line-item table with automatic Subtotal and Total calculations
Delivery date and shipping terms section
Built-in AI prompt to review the order for completeness before sending

Why use a template instead of starting from scratch?

Ordering informally over email or a phone call leaves no clear record of exactly what was agreed if a delivery comes in wrong or a price is disputed later. A formal purchase order creates that reference point up front, before any money changes hands.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Fill in vendor info and assign a PO number

A unique number per order makes it easy to reference later, especially when matching against the vendor’s eventual bill.

Add line items for what you’re ordering

The subtotal and total calculate automatically once quantity and price are entered.

Set the expected delivery date and shipping terms

Clear terms upfront reduce disputes if something arrives late or different than expected.

Send it to the vendor and keep a copy for reference

Match the vendor’s eventual bill against this PO when it arrives, using the Accounts Payable Ledger.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether the order looks complete and clearly specified before you send it to the vendor, no accounting background required.

Common Mistakes to Avoid

Ordering without a formal PO for larger purchases

For anything beyond a small routine purchase, a formal PO protects you if there’s ever a dispute about price, quantity, or terms.

Not matching the vendor’s bill against the original PO when it arrives

This is exactly what catches a pricing error or an unauthorized addition on the vendor’s invoice — always cross-check.

Leaving delivery expectations vague

A specific expected delivery date, noted upfront, gives you a clear basis to follow up if a shipment is late.

Skipping a PO number

Without a unique reference number, it becomes hard to track which order a vendor bill actually corresponds to, especially with an active vendor relationship.

Frequently Asked Questions

What is a purchase order used for?

It’s a formal document sent to a vendor specifying exactly what you’re ordering, at what price, and under what terms — it protects both sides and creates a clear reference point before the vendor bill arrives.

Do small businesses really need formal purchase orders?

For routine, low-value purchases, many small businesses skip formal POs. For larger or recurring vendor relationships, a PO reduces disputes and makes reconciling vendor bills much easier.

How does a purchase order connect to accounts payable?

When the vendor’s bill arrives, you match it against the original PO to confirm the price and quantity match what was agreed — then the bill gets logged in your Accounts Payable Ledger for payment.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a Tools Club Accounts Payable Ledger for tracking the resulting vendor bills.

What’s the difference between a purchase order and an invoice?

A purchase order is sent by the buyer to formally request goods or services. An invoice is sent by the seller (the vendor, in this case) afterward to request payment — they’re issued by opposite sides of the transaction.

Should every vendor purchase go through a PO?

Not necessarily — many businesses reserve formal POs for larger or first-time vendor purchases, while routine small purchases are handled more informally. Set a threshold that makes sense for your business.

What happens if the delivered goods don’t match the PO?

The PO is your reference point for raising the discrepancy with the vendor — having it in writing makes that conversation far more straightforward than relying on a verbal agreement.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club