Purchase Order Template
Prepare a purchase order with item quantities, prices, discounts, tax rates and an automatically calculated total.
Free Excel workbook · direct .xlsx file · no signup · works without JavaScript
What is in the file
The Purchase order sheet, exactly as you will get it. Cells shown as=… are live formulas in the download, not text. The How to use tab explains what to change first.
| PURCHASE ORDER | |||||||
|---|---|---|---|---|---|---|---|
| Order number | PO-0001 | ||||||
| Supplier | Example supplier | ||||||
| Date | 2026-10-08 | ||||||
| Deliver to | Your company or site | ||||||
| SKU | Description | Qty | Unit cost | Discount | Net amount | Tax rate | Total incl. tax |
| P-100 | Office chairs | 4 | 110 | 0.05 | =C8*D8*(1-E8) | 0.19 | =F8*(1+G8) |
| P-200 | Desk lamps | 6 | 25 | 0 | =C9*D9*(1-E9) | 0.19 | =F9*(1+G9) |
| P-300 | Monitor arms | 3 | 65 | 0.1 | =C10*D10*(1-E10) | 0.19 | =F10*(1+G10) |
| P-400 | Cable organizer | 10 | 8 | 0 | =C11*D11*(1-E11) | 0.19 | =F11*(1+G11) |
| P-500 | Delivery charge | 1 | 25 | 0 | =C12*D12*(1-E12) | 0.19 | =F12*(1+G12) |
| Order total | =SUM(F8:F12) | =SUM(H8:H12) |
How this template works
A purchase order should make quantities and line prices unambiguous to both buyer and supplier. This spreadsheet multiplies units by price, applies each line discount, adds the entered tax rate and totals the order. It keeps the commercial inputs separate from the formulas so you can review the document before sending it.
Use it for
- Recording small business supply orders
- Calculating totals when different items have different discounts
- Sharing a simple purchase list for internal approval
Related templates
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this purchase order template free?
Yes — free to download and free to use, personally or commercially. There is no email gate, no account and no watermark.
Do the formulas work, or are they just shown?
They work. The file contains live formulas, so editing a value recalculates everything that depends on it. The "How to use" tab lists which cells are formulas so you know what you are typing over.
Which apps open it?
Any spreadsheet that reads .xlsx: Excel, Google Sheets, LibreOffice Calc and Apple Numbers. To use it in Sheets, upload the file to Drive and open it with Google Sheets.
Where does the file come from?
The Excel workbook is a ready-made static file hosted by FormulaSmith. The direct link also works when JavaScript is switched off; nothing needs to be uploaded or signed up for.