How to Track Purchase Orders: Open PO Tracking Guide

To track purchase orders, record every issued PO as line-level data (PO number, supplier, order date, promised delivery date, quantity ordered per line), then decrement each line as goods are received and invoices are matched. Anything with quantity still outstanding is an open purchase order. The tracking is trivial arithmetic. The hard part is getting the orders into the tracker in the first place.

Last updated July 2026.

That is the step you can automate today. Upload a purchase order above and the PO number, supplier, dates, and every line item come back as spreadsheet rows in about ten seconds, which is the raw material any tracker, from a Google Sheet to NetSuite, runs on.

How do you track purchase orders?

Keep one record per line item, not per order, and give each line four moving numbers: quantity ordered, quantity received, quantity invoiced, and quantity outstanding. Update received when the goods arrive, update invoiced when accounts payable matches the bill, and outstanding falls out as ordered minus received. Sort by promised delivery date to see what is late, and by supplier to see who is late repeatedly.

That structure answers the questions people actually ask a tracker. What is still coming from this vendor. Which orders are past their promised date. How much have we committed but not yet been billed for. A tracker organized by order rather than by line can answer none of them once a delivery arrives partially, which is most of the time.

What is an open purchase order?

An open purchase order is one where goods or services have been ordered but not fully received and invoiced. It represents a financial commitment: money the company has promised to spend but has not yet paid. Open POs sit on the commitment ledger and are what a controller means when asking how much is encumbered. An order closes when every line has been received, invoiced, and paid, or when it is canceled.

What data do you need to track a purchase order?

Six fields carry the tracker: PO number, supplier, order date, promised delivery date, and per line the SKU, quantity, and unit price. Add ship-to when you receive at multiple sites, and payment terms when you forecast cash. Header totals alone are enough to track spend and useless for tracking delivery, because a partially received order looks identical to an untouched one at the header level.

Notice how many of those fields live on the supplier's acknowledgment rather than on the PO you sent. The promised date in particular is set by the supplier, not by you, and it arrives as a separate document. Reading acknowledgments matters as much as reading orders, which is covered in purchase order acknowledgment. The full field list is in purchase order fields.

How do you track purchase orders in Excel?

Build the sheet line-per-row. Columns: PO number, supplier, order date, promised date, line number, SKU, description, unit of measure, quantity ordered, unit price, line value, quantity received, quantity outstanding, status. Then a pivot table by supplier over quantity outstanding gives you the open PO report, and a filter on promised date before today gives you the expediting list.

Two rules keep the sheet honest. First, never edit a row's ordered quantity after the PO is issued; a change means a revised PO and a new row with a revision number. Second, do not maintain the sheet by typing. Export extraction results straight into it, because the failure mode of every Excel PO tracker ever built is that somebody got busy for a week. If your sheet is downstream of a purchase order PDF to Excel converter, staying current costs a few seconds per order instead of a few minutes.

How do you track partial deliveries against a purchase order?

At the line level, by comparing quantity received against quantity ordered on each line separately. A ten-line order where four lines arrived is not forty percent complete in any useful sense; six specific lines are outstanding, and one of them may be the item holding up production. Record receipts against line numbers, not against the order, and the report tells you which SKU to chase.

This is also what makes the three-way match work. Accounts payable compares the invoice line to the PO line and to the receipt line. If the tracker only stores order-level totals, AP has nothing to match against and the check falls back to a human reading two PDFs side by side.

What is a purchase order tracking system?

A purchase order tracking system is software that stores every issued PO, records receipts and invoices against it, and reports on status, aging, and outstanding commitments. Full procurement suites include one. So do most ERPs. Many smaller teams run a spreadsheet, which works fine until order volume outruns the person maintaining it. The comparison between approaches, and where AI capture fits, is on the AI purchase order tracking system page.

What is the difference between an open PO report and a commitment report?

An open PO report lists orders with quantity still outstanding, and it is an operational document: what is late, what to chase, who to call. A commitment report values that same population in dollars and shows finance how much of the budget is already spoken for even though no invoice has arrived. Same underlying data, two audiences. Procurement reads one, the controller reads the other, and they disagree whenever line-level receipts have not been posted.

Can purchase order tracking be automated?

The data capture and the reporting can be fully automated. The judgment cannot. Software can read every PO, acknowledgment, and revision without a person retyping them, keep the open-order register current, and flag lines past their promised date. Deciding whether to expedite, accept a slipped date, or dual-source stays with a buyer, and the tolerance rules that trigger those alerts live in your ERP.

In practice the automation that pays for itself fastest is the least glamorous: stopping the retyping. Most teams find their tracker is not wrong because the logic is bad, it is wrong because entry fell behind. If your orders and acknowledgments arrive as attachments in a shared procurement mailbox, you can pull the data straight out of the inbox as documents land, so the register updates itself rather than waiting for someone's Tuesday.

A tracking setup that survives contact with reality

Three habits separate the teams whose open PO report is trusted from the teams whose report is quietly ignored.

• Capture the promised date, not just the requested date. Otherwise every order looks late and the report gets ignored within a month.
• Post receipts the day goods arrive. Late receipting is what creates goods-received-not-invoiced balances at month end, covered in goods received not invoiced.
• Never let the register be the only copy. The source of truth is the document. If the tracker is rebuilt from the POs themselves, an error in the sheet is a nuisance rather than a disaster.

Where to start

Take one supplier you buy from weekly. Run last month's purchase orders through bulk purchase order processing, export line-per-row to a spreadsheet, and mark off what you know arrived. The gap between that sheet and whatever your current tracker says is your real error rate, and it is usually the argument that settles whether the capture step is worth automating.

From there the same extracted rows feed everything downstream: the ERP import, the spend rollups that procurement leaders report on, and the match-ready records accounts payable needs. If you buy on standing agreements, drawdown tracking works the same way and is covered in blanket purchase order software.