Key takeaways
- Use supplier and product master data instead of retyping details on each order.
- Give every purchase order a unique, permanent reference.
- Track ordered and received quantities so outstanding commitments remain visible.
Build supplier and item records first
Create controlled supplier records with name, address, email, telephone, payment terms and reference details. Keep a separate item list for codes, descriptions, units, standard costs and preferred suppliers.
Use unique purchase-order numbers
Generate a sequential or structured PO number and never reuse it. The reference should appear on the order, supplier email, receipt record and any later query.
Create clear order lines
- Product or service code
- Description
- Quantity
- Unit price
- Tax or VAT treatment
- Line total
- Required date
Lock or validate formulas so a user cannot accidentally replace a calculated total.
Include delivery and approval information
Record the delivery address, requested date, buyer, approver and any terms or notes. A draft should be distinguishable from an approved or sent order.
Export a stable PDF
A PDF gives the supplier a fixed version of the approved order. Use a consistent filename containing the PO number and supplier. Keep the editable workbook record as well as the final issued document.
Email through the supported Outlook version
An Excel VBA email function may create a prepared draft in Classic Outlook for Windows. Check compatibility carefully because New Outlook, Outlook on the web, Mac and mobile apps may not support the same automation.
Track order and receipt status
| Status | Meaning |
|---|---|
| Draft | Still being prepared |
| Approved | Authorised for issue |
| Sent | Provided to the supplier |
| Part received | Some quantities remain outstanding |
| Received | All expected quantities accepted |
| Closed or cancelled | No further receipt is expected |
Review supplier performance
Once expected and actual delivery dates are recorded, Excel can calculate lead time, late orders and on-time delivery. This turns the PO history into a useful supplier-performance record.
Protect the audit trail
Do not overwrite an issued PO to represent a different order. Use amendments, cancellation notes or a replacement reference so the original commitment remains understandable.
Frequently asked questions
Can Excel generate purchase-order numbers automatically?
Yes. A formula or VBA process can generate sequential references, but the workbook should prevent duplicate numbers and preserve issued records.
Should a purchase order be saved as PDF?
A PDF is useful as the fixed document sent to the supplier. Keep the underlying order record for tracking and reporting.
How do I track partial deliveries?
Store ordered and received quantity for each line and calculate the remaining amount. Keep the order open until the outstanding quantity is received or formally closed.
Can Excel email a purchase order?
Yes, with a supported desktop Outlook automation workflow. Check the product requirements because browser and New Outlook versions may differ.
Treat the PO as a process, not just a form
Excel can create professional purchase orders, but the real value comes from consistent supplier records, unique references, approval, PDF output and receipt tracking. That history helps the business control commitments and learn which suppliers deliver reliably.
