Free Purchase Order Template Excel (+ Construction, Manufacturing, and GST Variants)

A purchase order template is a pre-formatted spreadsheet that lets you authorize a purchase from a vendor at agreed prices, quantities, and delivery dates. This free Excel purchase order template includes a standard PO form, a construction variant with material specifications and delivery-to-site fields, a manufacturing variant with BOM and quality references, an India GST version with GSTIN and HSN/SAC fields, and a running PO log that tracks every order from open to received. It is built for procurement officers, project managers, and small business owners who need to issue a professional purchase order today without building one from scratch. Working formulas calculate line totals, subtotals, and grand totals automatically, and the log flags overdue deliveries in red. Download it below.

What is inside the template

This template has five tabs. Here is what each one covers before you download.

Tab 1: Purchase Order (standard)

The standard tab is an all-purpose PO: buyer and vendor blocks, a ten-row line items table where each line total calculates itself, and a subtotal, shipping, tax, and grand total stack that updates automatically. Use this one for general business buying.

Tab 2: Construction PO

The construction variant adds a deliver-to-site block and site contact, a grade and spec column in the materials table, and a certifications section for mill certificates, test reports, and lien waivers, so materials arrive at the job site to spec and with the paperwork you need for payment.

Tab 3: Manufacturing PO

The manufacturing variant ties the order to production: a BOM reference and approved vendor list reference in the header, a lot and batch column for traceability, and a quality section for incoming inspection, certificates of conformance, and first-article requirements.

Tab 4: India GST PO

The India variant works in rupees and adds everything a GST-ready order needs: buyer and supplier GSTIN, state codes, place of supply, HSN or SAC codes per line, and separate CGST, SGST, and IGST rows, plus reverse charge, TDS, and e-way bill fields.

Tab 5: PO Log

The log is your at-a-glance tracker: one row per order with status, expected versus received dates, invoice number, and a variance column. Overdue orders turn red, invoice mismatches turn amber, and summary counts at the bottom show how many orders are open, received, closed, and overdue.

What this purchase order template includes

The download is a single .xlsx file with five tabs plus a matching PDF. Each PO form captures the same core purchasing information, and the industry variants add the fields specific to construction and manufacturing buying. Here is what each part does.

Buyer and vendor header

Every PO tab opens with a buyer block (company name, address, PO number, PO date, buyer name and contact) and a vendor block (vendor name, number, address, contact, phone, and email). A separate ship-to field handles the common case where goods go to a different address than the billing office. The PO number is the anchor for everything downstream, so give each order a unique number and reuse it on the receiving document and the supplier invoice.

Line items table

The line items table has columns for item number, description or SKU, quantity, unit of measure, unit price, line total, required date, and notes. The line total column is a formula (quantity times unit price), so you only type the quantity and price. Ten rows are provided; copy a row down if you need more. Keep descriptions specific enough that the vendor ships exactly what you meant, and use the required date column when different items on the same PO have different delivery deadlines.

Totals block

Below the line items, the template sums a subtotal, then adds shipping or handling and tax to produce a grand total. The subtotal and grand total are formulas, so the numbers stay correct as you edit line items. Enter shipping and tax as flat amounts, or leave them at zero for orders where they do not apply.

Terms and approval

The terms section captures payment terms (Net 30, Net 60, or a custom arrangement), shipping method, FOB point, early payment discount, currency, and delivery schedule. A terms and conditions box holds your standard purchasing language. The approval block has prepared-by and approved-by rows with signature and date fields, because a purchase order is an authorization document and should show who raised it and who signed off.

PO Log tracker

The fifth tab is a running log for every purchase order you issue. Each row records the PO number, vendor, PO date, expected delivery, PO amount, status (Open, Received, or Closed), received date, invoice number, invoice amount, three-way match result, and a variance figure. The variance column is a formula (invoice amount minus PO amount) so you can spot billing mismatches at a glance. Any open PO past its expected delivery date turns red, and any non-zero variance turns amber. Summary counts at the bottom tell you how many POs are open, received, closed, and overdue.

How to use this purchase order template

1. Download and open the file in Excel, Google Sheets, or LibreOffice Calc. Pick the tab that matches your buying: standard, construction, manufacturing, or India GST.
2. Fill in your company details in the buyer header and assign a unique PO number.
3. Add the vendor details and, if the goods ship elsewhere, the ship-to address.
4. Enter the line items: description, quantity, unit, and unit price. The line totals and subtotal calculate automatically.
5. Add shipping and tax if they apply, then review the grand total.
6. Set the terms: payment terms, delivery schedule, and any special conditions.
7. Get it approved and save the tab as a PDF to send to the vendor.
8. Log the PO on the PO Log tab so you can track it from open through received and closed.

Save the original file as your master template and make a copy for each new order, or keep issuing POs from the same file and rely on the log tab to hold the full history.

Construction purchase orders: what makes them different

A construction purchase order does more than list quantities and prices. It has to pin down material specifications and get the right goods to the right job site on the right day, because a late or wrong delivery can idle a crew. The construction PO tab adds a deliver-to-site field, a site contact, and a grade or spec column in the materials table, so a rebar order reads as "No. 5 rebar, ASTM A615 Grade 60" rather than just "rebar."

The material specifications and certifications section captures whether mill certificates and test reports are required, whether a lien waiver must accompany the delivery, and the delivery-to-site window with any off-load requirements. These fields matter because construction buyers frequently need documentation for quality records and payment release. The tab also includes a retention or holdback field in the terms, which is common on larger material supply agreements.

Typical construction PO scenarios include ordering concrete, structural steel, lumber packages, MEP fixtures, and finish materials. Because these often deliver directly to the site rather than a central warehouse, the deliver-to-site and site-contact fields keep the driver and the crew coordinated.

Manufacturing purchase orders: BOM, quality, and traceability

A manufacturing purchase order ties back to production. The manufacturing PO tab starts with a BOM reference and an approved vendor list (AVL) reference, because parts are usually bought against a bill of materials and from vendors that have already been qualified. The parts table adds a lot or batch column so incoming material can be traced to a specific production run, which is essential in regulated or safety-critical manufacturing.

The quality and traceability section records whether incoming inspection is required, whether a certificate of conformance (CoC) must ship with the goods, whether lot or batch traceability applies, and whether a first article is needed. It also captures the quality specification or standard and the vendor's AVL status. These fields turn a plain PO into a document that receiving and quality can act on without chasing the buyer for missing requirements.

Manufacturing buyers also care about Incoterms and freight, which are in the terms block, because raw materials and components often ship from distant or overseas suppliers where delivery responsibility needs to be explicit.

Indian purchase order format: GST, GSTIN, and HSN/SAC

The India GST PO tab is built for Indian businesses that need a purchase order format in Excel that is ready for GST. It uses rupees throughout and adds the fields a compliant Indian PO needs, so you are not retrofitting a US template every time you raise an order.

The header captures both the buyer GSTIN and the supplier GSTIN, along with each party's state and state code, plus the place of supply. This matters because the place of supply and the two GSTINs determine whether the transaction is intra-state or inter-state, which in turn decides the tax type. The line items table adds an HSN or SAC code column and a taxable value column (quantity times rate), because GST is charged on the taxable value and reported by HSN or SAC code.

The tax block has separate rows for CGST, SGST, and IGST. For an intra-state purchase (buyer and supplier in the same state), you split the GST into CGST and SGST at half the rate each. For an inter-state purchase (different states), you charge IGST at the full rate and leave CGST and SGST at zero. The grand total adds the taxable value and the applicable tax rows. A compliance section records reverse charge applicability, TDS applicability with section and rate, and an e-way bill number for inter-state shipments above the threshold. Fill the GSTIN fields carefully, since an incorrect GSTIN blocks input tax credit for the buyer.

What to look for in a good purchase order template

1. A unique PO number and clear header

The PO number is how you connect the order to the receipt and the invoice. A good template makes it prominent and pairs it with buyer and vendor blocks so there is no ambiguity about who is buying from whom.

2. Working formulas

Line totals, subtotals, tax, and grand totals should calculate automatically. If you are adding up columns by hand, you are inviting arithmetic errors into a document that authorizes spending.

3. Fields that match your industry

Construction buyers need material specs and delivery-to-site fields; manufacturers need BOM references and quality requirements; Indian businesses need GSTIN and HSN or SAC codes. A generic template forces you to scribble these in the margins.

4. Delivery and terms

A purchase order is a contract offer. It should state required delivery dates, payment terms, and any conditions clearly enough that the vendor knows exactly what they are agreeing to.

5. An approval block

Because a PO commits money, it needs a prepared-by and approved-by signature area. This is your internal control that spending was authorized.

6. A tracking log

Individual PO forms tell you about one order. A log tells you which orders are still open, which are overdue, and where invoice amounts do not match what you ordered. Both are needed to run purchasing well.

7. Print-ready layout

Vendors still work with PDFs and printed copies. The template should print cleanly on standard paper without cutting off columns.

When you outgrow Excel for purchase orders

An Excel purchase order template works well when you issue a handful of POs a week and one person owns the process. It starts to strain when purchasing volume grows, when several people raise and approve orders, or when you need to know in real time what has been ordered, received, and billed.

The pain points that signal you have outgrown spreadsheets are specific:

• Enforcing approval workflows, such as any PO above a set amount needing a manager sign-off, which a spreadsheet cannot enforce.
• Tracking delivery status and receiving goods against the PO rather than checking a separate log.
• Three-way matching (PO vs delivery receipt vs invoice) at scale, instead of eyeballing it row by row.
• Maintaining an approved vendor list with current pricing that everyone buys from.
• Reporting on spend by vendor, category, or project without rebuilding a pivot table each month.

For manufacturers, procurement lives inside ERP. MRPeasy runs about $49 to $149 per user per month and Katana starts around $299 per month for the base plan plus a manufacturing add-on, so a small team is looking at a few thousand dollars a year on a per-user subscription that never ends. For contractors, construction management platforms like Buildertrend ($99 to $399 per user per month) fold purchasing into project and materials management. A custom purchasing app on a managed platform is the alternative when off-the-shelf tools do not fit how you buy.

Related templates

A purchase order is one document in a longer procurement workflow. If you are using this template, you will also need:

• Free RFQ Template (Excel): A request for quotation template for collecting and comparing vendor pricing before you raise a PO. The RFQ starts the buying process; the purchase order finishes it.
• Free Work Order Template (Excel): Construction, manufacturing, and maintenance work order forms. A work order that needs materials or parts often triggers a purchase order to a supplier.
• Free Contractor Invoice Template (Excel): The billing side of the workflow, including a GST invoice format for India. Match supplier invoices back to your POs using the PO log.
• Construction Project Cost Control Template: Budget-versus-actual tracking. Purchase order commitments roll up into project cost control.

Frequently asked questions

What is a purchase order template?

A purchase order template is a standardized spreadsheet you use to authorize a purchase from a vendor. It records the buyer and vendor details, the items and quantities being ordered, the agreed prices, delivery dates, and payment terms, along with an approval signature. Using a template means every PO captures the same information, which makes ordering, receiving, and paying consistent and auditable.

What is the difference between a purchase order and an invoice?

A purchase order is issued by the buyer to the vendor before the goods or services are supplied; it says what the buyer wants to order and at what price. An invoice is issued by the vendor to the buyer after the goods or services are delivered; it requests payment. In a healthy process the invoice should match the purchase order and the receiving record, which is what three-way matching checks.

What should a construction purchase order include?

A construction purchase order should include the standard PO fields plus material specifications (grade, size, finish), a deliver-to-site location and site contact, required delivery dates, and any documentation requirements such as mill certificates, test reports, or lien waivers. These details matter because construction materials are often shipped directly to a job site and need to meet a specification for quality records and payment.

How do you track purchase orders in Excel?

Use a PO log with one row per order, capturing the PO number, vendor, dates, amount, status, received date, invoice number, and a variance figure. The template included in this post has a PO Log tab that highlights overdue orders in red and non-zero invoice variances in amber, and it summarizes how many POs are open, received, closed, and overdue. Update the status column as each order moves from open to received to closed.

What is three-way matching (PO vs receipt vs invoice)?

Three-way matching is a control that checks three documents against each other before a supplier invoice is paid: the purchase order (what you ordered), the receiving record (what actually arrived), and the invoice (what the vendor is billing). If all three agree on quantity and price, the invoice is cleared for payment. If they disagree, the mismatch is investigated. It prevents overbilling, duplicate payments, and paying for goods you never received.

What is the purchase order format for GST in India?

A GST-ready purchase order in India includes both the buyer and supplier GSTIN, each party's state and state code, the place of supply, and HSN or SAC codes against each line item. Tax is charged on the taxable value: for an intra-state purchase you split it into CGST and SGST, and for an inter-state purchase you charge IGST. The India GST PO tab in this template has all of these fields, plus reverse charge, TDS, and e-way bill references.

When should you switch from Excel purchase orders to procurement software?

The usual triggers are approval control (you need POs above a threshold to require a sign-off), volume (too many open POs to track by hand), and integration (you want purchasing to connect to receiving, inventory, and accounting automatically). Manufacturing ERP tools like MRPeasy and construction platforms like Buildertrend include procurement modules, and a custom build on a managed platform is an option when off-the-shelf software does not match your buying process.