Purchase Order Template for Manufacturers
A PO template with supplier lead time and MOQ built in — download, fill in, and send.
Download Free PO TemplateCSV format — opens directly in Excel, Google Sheets, or Numbers. No signup.
What's in the template
- po_number
- Unique order identifier
- supplier_name
- Who the order is going to
- order_date
- Date the order was placed
- item_sku / item_name
- What's being ordered
- quantity / unit
- How much, in what unit
- unit_price / line_total
- Price and line cost
- lead_time_days
- Supplier's quoted lead time
- moq
- Supplier's minimum order quantity
How to use it
- Download the template and open it in Excel or Google Sheets.
- The file ships with three example line items — assign each new order its own po_number so you can reference it later.
- Add one row per line item, repeating the po_number and supplier_name for every item on the same order.
- Fill in quantity and unit_price, then calculate line_total (quantity × unit_price) for each row.
- Record lead_time_days and moq from your supplier agreement so you know when to reorder and how much you're committing to.
- Export as PDF or CSV and send it to your supplier, or print it for a paper trail.
The limits of a spreadsheet PO
A spreadsheet PO documents an order, but it doesn't do anything after that. There's no built-in way to track whether the supplier acknowledged the order, whether it shipped against its lead time, how much was actually received against what was ordered, or to email it directly from your own company domain so it looks professional in the supplier's inbox. See sending purchase orders from your own email domain and supplier management for small manufacturers for what a more complete process looks like.
When you outgrow this template
Nstock can import this CSV directly to seed your supplier and item records. From there, purchase orders track status automatically — sent, acknowledged, partially received, closed — instead of living only as a static file. See order document workflows for how Nstock issues and tracks documents from your own domain, or use the EOQ calculator to size the order quantity that minimizes ordering and holding cost before you fill in the next PO.
Frequently asked questions
How do I use this purchase order template in Excel or Google Sheets?
Download the file and open it directly in Excel or Google Sheets — it's CSV, which both tools read natively. Each row is one line item on a purchase order, so a PO with three items gets three rows sharing the same po_number and supplier_name. Fill in quantity and unit_price and calculate line_total, then export or print the sheet to send to your supplier.
Why does a manufacturing PO template need lead time and MOQ columns?
Generic office purchase order templates skip supplier lead time and minimum order quantity (MOQ), but manufacturers need both to plan production. Lead time tells you how far ahead to place the order so raw materials arrive before a run starts; MOQ tells you the smallest quantity a supplier will sell, which affects how much cash you tie up in a single order. Recording both on the PO itself keeps that context next to the order instead of buried in an email thread.
Can this template track order status or receiving?
No. This is a static document template — it captures what you ordered and from whom, but it doesn't track whether a PO was sent, acknowledged, partially received, or closed, and it won't tell you when a shipment is running late against its lead time. That kind of status tracking needs a system that updates the record as events happen, not a spreadsheet you edit by hand.
Is this purchase order template really free?
Yes. The template is free to download and use with no signup or account required.
Send POs your suppliers actually track
Nstock imports this CSV directly, then lets you create, send, and track purchase orders from your own verified company domain, with receiving status updated automatically as shipments arrive.