How to Make Purchase Order in Excel

Microsoft Excel and Google Sheets both offer free purchase order templates you can customize. I’ve put together an easy-to-use version based on those.

Here’s a simple step-by-step guide to using the purchase order template in Excel. It's helpful if you're managing purchases manually and need a basic, trackable format. You can download the template here.

Step-by-Step Guide

1. Start with a Header

Fill in the following information:

• Purchase Order (title)

• PO Number

• Date

• Buyer info (your company name, address, contact)

• Vendor info (supplier name, address, contact)

2. Add/Update Item Table

Update the item table with: Item, Description, Quantity, Unit Price, and Total

3. Add Delivery and Payment Info

• Delivery address

• Expected delivery date

• Payment terms (e.g., Net 30, advance, etc.)

4. Final Touches

• Add your company logo if needed

• Use borders and shading to make it easy to read

• Lock formulas to avoid accidental edits