Excel Purchase Order Template Generator
Build a purchase order workbook with supplier details, item codes, and totals that calculate themselves.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | PURCHASE ORDER | |||||||
| 2 | ||||||||
| 3 | Order from | Supplier | PO number | PO-001 | ||||
| 4 | Your Company Name | Supplier Name | Order date | |||||
| 5 | Address line 1 | Address line 1 | Required by | |||||
| 6 | Address line 2 | Address line 2 | ||||||
| 7 | Email / phone | Email / phone | ||||||
| 8 | ||||||||
| 9 | Item code | Description | Qty | Unit price | Total | |||
| 10 | =IF(COUNT(C10,D10)=2,C10*D10,"") | |||||||
| 11 | =IF(COUNT(C11,D11)=2,C11*D11,"") | |||||||
| 12 | =IF(COUNT(C12,D12)=2,C12*D12,"") | |||||||
| 13 | =IF(COUNT(C13,D13)=2,C13*D13,"") | |||||||
| 14 | =IF(COUNT(C14,D14)=2,C14*D14,"") | |||||||
| 15 | =IF(COUNT(C15,D15)=2,C15*D15,"") | |||||||
| 16 | =IF(COUNT(C16,D16)=2,C16*D16,"") | |||||||
| 17 | =IF(COUNT(C17,D17)=2,C17*D17,"") | |||||||
| 18 | =IF(COUNT(C18,D18)=2,C18*D18,"") | |||||||
| 19 | =IF(COUNT(C19,D19)=2,C19*D19,"") | |||||||
| 20 | =IF(COUNT(C20,D20)=2,C20*D20,"") | |||||||
| 21 | =IF(COUNT(C21,D21)=2,C21*D21,"") | |||||||
| 22 | =IF(COUNT(C22,D22)=2,C22*D22,"") |
Preview of the first 22 rows. Cells shown as =SUM(...) are live formulas in the downloaded workbook, not pasted numbers.
What you get
- •Separate blocks for your company and the supplier, plus PO number and required-by date.
- •An item-code column, which is what separates a purchase order from an invoice.
- •Line totals as Quantity x Unit price, with subtotal, tax, and total below.
- •A notes block for delivery instructions or terms.