How to Make Purchase Order in Excel

Jun 17, 2025 • Zeiv

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