Purchase order generator
Create a purchase order with stock lines, delivery charges and your supplied terms. Your entries stay in this browser.
Purchase order
Order total
Including tax
$387
Tax
$35
Entered costs exclude tax. Tax applies at 10% to taxable lines.
Example purchase order ready for review.
Purchase order preview
Buyer, supplier and delivery
| Stock line | Quantity | Unit cost | Before tax | Tax | Total |
|---|---|---|---|---|---|
| Sage ceramic mug Supplier code: 00048 Retailer SKU: BH-MUG-SAGE | 24 | $12.50 | $300.00 | $30.00 | $330.00 |
| Linen fabric (metres) Supplier code: FAB-007 Retailer SKU: BH-LINEN | 2.5 | $11.25 | $28.13 | $2.81 | $30.94 |
Delivery including tax: $26
Total before tax: $352
Delivery and payment terms
Each line and its tax round to cents before the order totals are added.
Keep product codes with order lines
Paste up to 500 rows without a header. Use six tab-separated columns in this order: supplier code, retailer SKU, description, quantity, unit cost ($), taxable (yes or no). Codes can be blank. Quantities allow six decimal places and unit costs allow two.
Replace the example with your supplied terms. The document preserves your wording and line breaks.
The example is a hypothetical stock order. Zero-priced samples and fractional quantities are accepted.
Open the downloaded HTML document in your browser. Use Print to print it or save a PDF.
The purchase order generator keeps supplier references and your retailer stock keeping units (SKUs) beside each description. It preserves their spelling and leading zeros. Supplier code 00048 stays 00048 when you download the document.
Copy six columns from your spreadsheet without a header row. Enter the quantity in the unit named in the description, such as metres or cartons. A quantity of 2.5 is accepted. A sample can have a unit cost of $0.
The preview and printable document contain every accepted line, up to 500 rows. The document repeats its order reference and column headings when a long order continues onto another printed page.
Costs, delivery and payment terms
Choose whether your entered unit costs and delivery charge include tax. Mark each line yes or no for tax, then enter the applicable rate. The tool uses that rate only on taxable lines.
In the hypothetical example, 24 mugs at $12.50 cost $300 before tax. The fabric line is 2.5 metres at $11.25, rounded to $28.13. Delivery adds $24 before tax. At the entered 10% rate, line-by-line tax totals display as $35 and the order total as $387.
For an including-tax amount, the tool extracts the tax already in that amount. It uses the entered rate divided by 100 plus that rate. Moneysmart’s GST calculation guide explains the equivalent divide-by-11 calculation when the rate is 10%.
Each line extension rounds to cents first. Its tax rounds to cents next, and the tool adds those displayed amounts. Your supplier’s rounding method can produce a different cent total. Keep the delivery and payment terms you agreed with the supplier in the terms field.
Review before ordering
Download the purchase order and review it through your normal approval process. Check both product codes against the quote, including variant details and pack sizes. Confirm the delivery address and your supplied payment terms before sending it.
Creating or downloading the document does not send an order to the supplier or confirm supplier acceptance. The document records your requested order. Keep the supplier’s confirmation with your order records after you send it.
Open the downloaded HTML document in your browser and use Print to create a paper copy or save a PDF. Review the print preview for long descriptions and terms before saving the final copy.