Purchase order templatesbasic purchase order template
Basic Purchase Order Template
Use this basic purchase order template when bill-to details, ship-to details, item numbers, descriptions, quantities, unit prices, tax, shipping and handling, total, shipping method, and approval need to stay together.
Format
XLSX
Category
General
Use
Download or fill
Basic purchase order template
Built-in template
Real sample
A public PO source maps into basic PO fields.
This public Montana purchase order sample has the same field families a basic PO template needs: PO number, order date, invoice-to, ship-to, item rows, freight terms, totals, and payment terms. Fields that are not visible, such as approval, signature, tax, or receiving status, stay out of the generated rows.
Source page
1
Line rows
4
CSV columns
14
Visible total
$1,524.48
What this source proves
The sample shows the visible fields, row order, totals, and review boundaries used by the filled result. Hidden business facts stay out of the output.
Basic Purchase Order Template proof
Download workbookSource-backed field behavior
Visible fields are mapped, formulas and review notes stay inspectable, and hidden business facts are not invented just to fill empty cells.
| field | value | review behavior |
|---|---|---|
| purchase_order_number | 1234567 | Copied from the source PO number. |
| order_date | 11/12/13 | Kept as printed on the sample page. |
| payment_terms | 2% 10, Net 30 | Kept exactly as written. |
| freight_terms | CUST PICKUP | Mapped from the visible freight field. |
| line_items | 4 | One row per visible ordered item. |
| approval_status | Left blank because the source does not show it. |
Fill this template
Turn supplier files into this PO workbook.
Upload files or paste buying notes. Template mode is already attached to Basic purchase order template.
Working from a full PO packet instead of one template? Use purchase order automation to map the packet before filling rows.
Basic Purchase Order Template
Upload supplier quotes, purchase request emails, PDFs, screenshots, price lists, CSV exports, or pasted buying notes. The selected purchase order template is already attached.
XLSX structure
Purchase order rows, formulas, and approval fields.
The workbook includes a printable Purchase Order sheet, structured line items, and instructions for filling it from messy purchasing documents.
Company details
Date, PO number, and customer number
Bill to
Ship to
Salesperson and payment reference
Item number and description
Quantity and unit price
Subtotal, tax, S&H, other, and total
Shipping method and delivery date
Order approval
More templates
View all templatesOther purchase order templates
FAQ
Questions
What is a purchase order template?
A purchase order template is a spreadsheet layout for PO number, buyer, vendor, ship-to address, SKU or item, description, quantity, unit price, tax, freight, terms, approval, and status.
Can I download the purchase order template as Excel?
Yes. Each built-in purchase order template is available as an editable XLSX file with a printable Purchase Order sheet and a structured Line Items sheet.
Can Messy2Sheet fill a PO template from supplier quotes?
Yes. Upload supplier quotes, PDFs, emails, screenshots, price lists, or pasted buying notes and Messy2Sheet can fill the selected Excel PO template for review.
Which purchase order template should I start with?
Start with the basic purchase order template for general buying. Use vendor, construction, restaurant, or inventory templates when the source belongs to one of those workflows.