A purchase order is a promise, and promises slip. Without a clear tracker, orders go missing, deliveries run late, and money leaves without anyone noticing. This free purchase order tracker keeps every PO in view. It follows each order from raised to received and measures how well suppliers deliver. Below, we explain the formulas, the workflow, and how to adapt the tracker to your procurement process. You will also find realistic sample data already inside the file. Therefore, you can explore every formula, dropdown and chart first, and then replace the samples with your own records in minutes.
What Is a Purchase Order Tracker?
A purchase order tracker is a spreadsheet that records every order you place with suppliers. It captures quantities, prices, dates and delivery status.
From those inputs, it calculates the value of each order and whether it arrived on time. As a result, you control both spend and supplier performance.
Why Does PO Tracking Matter?
A purchase order represents committed cash and a supplier promise. When orders live in scattered emails, both slip through the cracks. Deliveries arrive late, duplicates get raised, and nobody knows the true outstanding spend. A single tracker keeps every order visible from raised to received. Consequently, you control cash flow, chase late deliveries on time, and hold suppliers to account with real data.
Why Use This Template?
A clear tracker protects both your cash and your supplier relationships. This one helps because it:
- Shows the status of every order at a glance.
- Calculates outstanding value still to arrive.
- Measures supplier on-time delivery.
- Summarizes spend by supplier.
- Keeps procurement out of scattered emails.
What’s Inside the Template?
The workbook has five tabs:
- How to Use — a built-in guide.
- Dashboard — value, on-time rate and supplier spend.
- PO Tracker — the main log, one row per order.
- Suppliers — your vendor reference list.
- Lists — the status reference.
What Formulas Does the Template Use?
The tracker relies on clear Excel formulas:
| Formula | What it does |
| =Qty Ordered * Unit Price | Calculates the value of each purchase order. |
| =IF(Received=0,”Open”,IF(<Ordered,”Partial”,”Received”)) | Sets the delivery status. |
| =IF(Received Date<=Expected,”On time”,”Late”) | Flags on-time versus late delivery. |
| =SUM(Value)-SUMIF(Status,”Received”,Value) | Calculates the value still outstanding. |
| =SUMIF(Supplier, s, Value) | Totals spend for each supplier. |
How Do You Use the Template?
The workflow is simple. Just follow these steps:
- Open the Suppliers tab and list your vendors.
- Move to the PO Tracker and raise each order.
- Enter the supplier, dates, item, quantity and price.
- Update Qty Received and Received Date as goods arrive.
- Let status, value and on-time flags calculate themselves.
- Review outstanding value and on-time rates on the Dashboard.
What Are the Best Use Cases?
The tracker fits many teams, such as:
- Small businesses managing supplier orders.
- Operations teams chasing late deliveries.
- Buyers controlling spend across vendors.
- Finance teams forecasting incoming costs.
- Anyone replacing a messy email trail.
How Can You Modify the Template?
You can tailor it easily. To add suppliers, type them on the Suppliers tab and they appear in the tracker dropdown. You can also add columns, such as a department or budget code, then summaries them on the dashboard. Moreover, the tracker covers 40 orders by default, and you can copy the formulas down for more.
What Mistakes Should You Avoid?
A few habits quietly undermine the template. Therefore, avoid these common mistakes:
- Forgetting to log the received date, which breaks the on-time flag.
- Leaving received quantities blank, so orders look open forever.
- Raising orders outside the tracker, which hides true spend.
- Ignoring repeat late suppliers instead of acting on the data.
- Tips to Get the Most From It
- Update received quantities the day goods land.
- Use the on-time rate in supplier reviews.
- Watch outstanding value to plan cash flow.
- Close received orders promptly to keep the view clean.
Frequently Asked Questions
What does a Partial status mean?
Partial means you have received some but not all of the ordered quantity. Therefore, the order stays outstanding until the rest arrives.
How is on-time delivery measured?
The template compares the received date with the expected date. If goods arrive on or before the expected date, it marks the order on time.
Can two people use it at once?
Yes, if you store it on a shared drive or OneDrive. For simultaneous editing, open it in Excel for the web.
Does it work in Google Sheets?
It does, with small tweaks to dropdowns and formatting after importing.
Can I track partial deliveries across several dates?
The template tracks the latest received quantity and date, which suits most small teams. For multiple delivery dates, add a row per delivery or use the notes column to record the history.
Download the Template and Get Started
Every late or lost order costs time and trust. This tracker keeps your purchasing tight, visible and accountable.
Download the Purchase Order Tracker and bring order to your procurement today.