Free purchase order · Excel

Free Construction Purchase Order Template + PO Log

A job-coded PO form with live totals, and a PO log that shows what you've committed, received, and been billed — plus the open commitment still coming at you.

  • PO header — number, date, vendor quote, required-on-site date
  • Vendor + jobsite ship-to blocks with receiving hours
  • Job # and cost code on every line
  • Qty × unit price = extension, subtotal, tax, freight, total
  • Eight plain-language PO terms + authorization signatures
  • PO log: received, invoiced, open commitment, over-invoice flag
  • Instructions tab + print-ready layout

Purchase Order Template

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

Purchase Order

Vendor, ship-to, job and cost coding, 16 line items with extensions, sales tax by status, freight, other charges, PO total, terms, and signatures.

02

PO Log

Every PO with original, changes, revised, received and invoiced to date, received-not-invoiced accrual, open commitment, % invoiced, and status.

03

Instructions

How to number, code, receive, match, and close POs — and what open commitment means for your forecast.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

What should a construction purchase order include?

At minimum: a unique PO number, date, vendor legal name and address, jobsite ship-to with a site contact and receiving hours, job number and cost code, line items with quantity, unit, description, unit price and extension, sales tax, freight, total, payment terms, required delivery date, the vendor quote it is based on, and an authorized signature. This template has all of them.

What is open commitment on a PO log?

Open commitment is the part of a PO you have agreed to spend but that has not been invoiced yet: revised PO amount minus invoiced to date. It is not in your job-cost actuals yet, so you add it to actuals to see what the cost code will really finish at. The PO log calculates it automatically and zeroes it when a PO is closed or cancelled.

Should every line on a PO have its own cost code?

Yes, whenever the PO spans more than one cost code. A single supply-house order often covers conduit, wire, and gear, which live in different cost codes. Coding by line is what makes committed-cost and budget-versus-actual reports accurate.

What is "received not invoiced"?

Material that has been delivered and signed for but not yet billed by the vendor. It is a real cost the job has already incurred, so accountants accrue it at month-end. The PO log calculates it as received to date minus invoiced to date and highlights any balance.

Is a purchase order a legally binding contract?

A PO accepted by the vendor (by signature, written confirmation, or by shipping) generally forms a contract for the goods. The terms printed on your PO and the vendor's quote or acknowledgment can conflict, so keep your standard terms short, clear, and reviewed by your attorney. The terms in this template are samples, not legal advice.

Commit the cost on paper before the truck shows up

A construction purchase order locks the price from the vendor's quote, puts the cost on the right job and cost code the day it's committed, and tells the driver exactly where and when to deliver. This template covers all three in a clean, printable form.

The PO log tab is where the real control happens: it tracks every PO's revised amount against what has been received and invoiced, and calculates the open commitment that isn't in your job cost yet. Compare supplier pricing first with the bid leveling matrix.

When the log outgrows a spreadsheet, Field PM issues POs from the job, matches vendor invoices, and rolls committed cost into the budget automatically.

How to write a construction purchase order that actually protects the job

Most purchase orders in construction are written in a hurry: a super texts a list, somebody in the office types it into a PO, and it goes to the supply house with half the information missing. Then the gear shows up at the wrong gate on a Saturday, the invoice comes in 6% over the quote, and nobody can tell which cost code it belongs to. A good construction purchase order prevents all of that, and a good PO log tells you, at any point in the job, how much money you have committed that isn't in your job cost yet. The free template above gives you both.

What a construction PO is (and why "just call it in" costs money)

A purchase order is your written offer to buy specific goods or services at a specific price, delivered to a specific place by a specific date. Once the vendor accepts it, it is the document that controls price, quantity, and delivery. In construction it does three jobs at once:

  • Price control. It locks the number from the vendor's quote. When the invoice shows up higher, the PO is how accounts payable knows to stop and ask why.
  • Job cost. It carries the job number and cost code, so the cost lands in the right bucket the day it's committed — not weeks later when the invoice gets coded.
  • Field logistics. It tells the driver where to go, who to call, when the gate is open, and whether there is a forklift on site.

Verbal orders skip all three. That's how you end up with a $2,000 restocking fee on a panel nobody approved, or a copper wire invoice that quietly includes a metals surcharge nobody agreed to.

What goes on the purchase order (field by field)

FieldWhat to enter and why
PO #Job-based and sequential, e.g. PO-2417-006. Never reuse a number. The vendor must print it on every delivery ticket and invoice.
VendorLegal name and remit-to address from the vendor's W-9, plus the inside-sales contact and account number.
Vendor quote #The quote number and date the price came from. If the invoice doesn't match, this is your reference.
Ship toJobsite address, site contact and phone, receiving hours, gate, and laydown instructions. Most refused or misdelivered loads trace back to a blank ship-to block.
Required on siteThe date you need it, not the date you'd like it. Pull it from your look-ahead schedule.
Job # / cost codeHeader default plus a cost code on every line. One order usually spans several codes.
Line itemsQuantity, unit, description, catalog or part number, unit price. Extension calculates. For engineered items (gear, fixtures, pumps, valves) write "per approved submittal" and the submittal number.
Tax status & rateTaxable, exempt with certificate, separated contract, or tax included. Sales tax only calculates when the status is Taxable.
Freight / otherDelivery, fuel surcharge, pallet, cut or reel fees. Put them on the PO so they aren't a surprise on the invoice.
Payment terms / FOBNet 30, 2% 10th prox, etc. FOB jobsite means the vendor owns the risk until it's on your site.
AuthorizationSigned by someone within their approval limit. The vendor countersigns or confirms by email.

PO terms worth printing on every order

You don't need two pages of boilerplate. You need a handful of terms that match how problems actually happen on a job. The template includes eight sample terms written in plain language: PO number on every document, no substitutions or price changes without a written revision, 24-hour delivery call-ahead during receiving hours, the right to reject damaged or non-conforming material, back-order notice within two business days, one invoice per PO with signed delivery tickets attached, certs and MTRs where the specs call for them, and tax-exemption handling. Edit them to match your company's standard terms, and have your attorney review whatever you print on a PO — the vendor's quote and acknowledgment often carry their own terms, and when the two conflict, the details matter.

The PO log: committed cost is the number that saves the job

Your job-cost report shows what's been invoiced. It doesn't show the $86,400 switchboard you released for fabrication two months ago that won't be billed until it ships. If you're only watching actuals, that cost code looks great right up until the invoice lands. The PO log fixes that by tracking every PO's commitment alongside what has been received and invoiced:

ColumnHow it's calculated
Revised PO $Original PO $ + approved changes (+ or −).
Received not invoicedReceived to date − invoiced to date, never below zero. Accrue it at month-end.
Open commitmentRevised PO $ − invoiced to date, never below zero. Forced to 0 when a PO is Closed or Cancelled.
% invoicedInvoiced to date ÷ revised PO $.
Over-invoice flagInvoiced to date turns red when it exceeds the revised PO amount, and the summary counts how many POs are over.

For a forecast you can trust: cost at completion = actual cost to date + open commitments + remaining uncommitted budget. Pair the PO log with the WIP schedule template and you'll stop getting surprised at month-end.

Receiving, three-way match, and closing a PO

  1. Receive against the PO. Whoever signs the delivery ticket counts it against the PO lines and notes shortages or damage on the ticket before the driver leaves. Take a photo.
  2. Three-way match. Accounts payable matches the PO, the signed delivery ticket, and the invoice. Quantity or price that doesn't match gets kicked back to the PM before it's paid.
  3. Update the log. Received to date from tickets, invoiced to date from AP. Do it weekly on active jobs.
  4. Handle back-orders in writing. A back-order that slips past your required date is a schedule problem — log it in Notes and in your three-week look-ahead.
  5. Close it. When everything's received, invoiced, and returns or credits have posted, mark the PO Closed. Cancel unused balances in writing so the vendor can't ship against them six months later.

Common PO mistakes

  • Writing the PO after the invoice arrives. A PO written to match an invoice controls nothing. Issue it before the order.
  • One cost code for the whole order. Your budget report ends up with $40,000 of "misc materials" and no idea which scope is over.
  • No quote reference. When pricing is disputed you have nothing to point to.
  • Blanket POs with no ceiling. A blanket PO for consumables or rentals still needs a not-to-exceed amount and an end date.
  • Letting the log go stale. A PO log updated once a quarter is a historical document, not a control.

Material escalation and long-lead gear

Copper, steel, and electrical gear pricing can move between quote and ship date. If a vendor's quote includes an escalation clause (metals surcharge, "price in effect at time of shipment"), note it on the PO and in the log so the PM isn't blindsided. For long-lead items — switchgear, transformers, generators, large valves, air handlers — the PO date is often the date that controls your schedule. Log the promised ship date, follow up on it every week, and track the release-for-fabrication date separately from the PO date.

When to move beyond Excel

A spreadsheet PO log works for a few jobs and a single buyer. It breaks when multiple PMs issue POs, invoices arrive by email to three different inboxes, and the log never matches what AP has actually paid. Field PM issues POs from the job, matches vendor invoices against them, and rolls open commitments straight into the job budget, so committed cost, actuals, and forecast are always the same number. Start a free 30-day trial — no credit card required.

Related templates

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice