Free Purchase Order Template for Excel
A free Excel purchase order template that does the math. Add each item’s quantity and unit price and the amounts, subtotal and order total update automatically. No signup, no watermark, and it works in Google Sheets too.
⇩ Download the Excel PO (.xlsx)
Totals calculate automatically
Fill in the quantities and unit prices; the line amounts multiply and the order total sums itself. Add a tax percentage if needed and the total updates instantly.
Prefer a document?
Use the Word PO template, or raise one with the free generator.
Related templates
- Purchase order template
- Purchase order – Word
- Commercial invoice template
- Credit note template
- Invoice template · Receipt template · Quote template
What’s on a purchase order
| Part | What it shows |
|---|---|
| Buyer & vendor | Who’s ordering and who supplies |
| PO number & delivery date | A reference and when it’s needed |
| Items | Quantities and unit prices |
| Order total | The amount authorised |
| Payment terms | For example, Net 30 |
Frequently asked questions
Is the purchase order template in Excel format?
Yes, download the Excel version above, the columns and formulas are already set up so the total updates as you fill in quantities and prices.
Does the Excel PO template calculate totals automatically?
Yes. Line amounts and the order total are formulas that update as you type.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets.
Is it free?
Yes. Free, no signup, no watermark.