BillCanvas
USUnited States

Home/Templates/Excel

Templates · Excel

Free purchase order template for Excel

A purchase order workbook with line item formulas, an order total and an approval block you can print and sign.

Purchase order template (.xlsx)

US Letter · formulas · order total · approval block

Excel 2016+ / Microsoft 365 / LibreOffice / Google Sheets. No macros.

What the workbook includes

  • PO number, date and deliver-by date
  • Your details and the supplier
  • Ten line rows with quantity, rate and amount formulas
  • Subtotal, tax rate and order total formulas
  • A printable approval block at the bottom
Free purchase order template for Excel preview
Purchase order template (.xlsx) · Excel · open full size

How the formulas work

Each line amount is quantity multiplied by rate. The subtotal adds the lines, the tax line applies the rate you enter, and the order total adds the tax. The approval block is a text area, not a formula; print it and sign it.

Approval and numbering

Use a year-based sequence such as PO-2026-014 and keep a log. Put the approver’s name in the signed block. A PO without an authorized signature is a suggestion; a signed one is an instruction the supplier can rely on.

Delivery terms

Write who pays freight, where the goods are handed over and when. “FOB destination” means the seller carries the risk until delivery; “FOB origin” passes it earlier. If partial delivery is acceptable, say so.

Printing

The print area is US Letter, portrait, one page wide. Save as PDF and send it to the supplier; ask them to put the PO number on their invoice and packing slip.

FAQ

Do the totals calculate automatically?

Yes. Line amounts, subtotal, tax and order total are formulas. The approval block is text.

Does it work in Google Sheets?

Yes. Upload the .xlsx; the formulas carry over. Check the print area after import.

Is a purchase order a contract?

It can be evidence of the order terms once the supplier accepts it. Whether it is a binding contract depends on its wording and state law; this is general information, not legal advice.

Can I use it for services?

A PO can order services, but a work order is usually better for a specific job at a site.

Related templates

All templates →