Open Purchase Order Report: What It Is and Why It Matters
Jul 10, 2026
Jul 10, 2026
Convert a purchase order to Excel, CSV, or JSON
Submit your purchase orders
Drop documents here, or click to file
Up to 50 files per batch
Uploading...
An open purchase order report lists every purchase order that has been issued to a supplier but not yet fully received, invoiced, and closed. It shows finance and procurement how much money is already committed but not yet spent, which is what drives month-end accruals, cash-flow forecasting, and follow-up on orders that are running late.
Last updated July 2026.
If your open POs are sitting in a stack of PDFs rather than in one system, the tool above pulls each purchase order into structured rows, PO number, supplier, dates, and line items, in about ten seconds, so building the report does not start with retyping. The report itself lives in your ERP or a spreadsheet; extraction just gets the data there faster.
A purchase order is open from the moment it is approved and sent to a supplier until it is fully received and matched to an invoice, at which point it is closed. In between, it represents a commitment: the company has agreed to buy something and owes the money once the goods or services arrive, even though nothing has been paid yet. That gap between commitment and payment is exactly what the report exists to make visible.
A PO can also be partially open. Order 100 units, receive 60, and 40 remain outstanding, so the PO stays open for the balance. Good reporting tracks the received and outstanding quantity on each line, not just whether the whole order is open or closed.
The report is a working list, not a summary. Each row is a PO or a PO line, and the columns are what let finance and procurement act on it. A useful open PO report carries these fields at minimum.
| Column | What it tells you |
|---|---|
| PO number and date | Which order this is and how old the commitment is |
| Supplier | Who owes the delivery, and who to chase |
| PO amount | Total committed value of the order |
| Received to date | How much has actually arrived and been receipted |
| Outstanding balance | The uncommitted-to-cash gap still open on the line |
| Expected delivery date | Whether the order is on time, due, or overdue |
| Invoiced to date | Whether AP has billed against it yet |
Sorted by age, the report surfaces stale POs that should be closed. Sorted by supplier, it shows total exposure to one vendor. Sorted by expected date, it becomes a delivery follow-up list. The same data answers three different questions depending on how you cut it.
An open purchase order report is a list of all purchase orders that have been issued but not yet fully received, invoiced, and closed. It shows the outstanding commitment on each order, the supplier, the expected delivery, and how much has been received so far. Finance uses it to accrue for goods not yet billed, and procurement uses it to chase late orders and close stale ones.
An open purchase order is one that is still active because the goods or services have not been fully delivered and invoiced. It represents money the company has committed to spend but has not yet paid. A PO stays open from approval until the last line is received and matched to an invoice, and it can be partially open when only some of the ordered quantity has arrived.
An open PO has an outstanding balance: goods still to be delivered, or an invoice still to be matched. A closed PO is complete, everything ordered has been received and billed, or the order was cancelled, so no further activity is expected. Closing a PO removes it from the commitment total, which is why keeping the open list accurate matters for the numbers.
Open purchase orders are the clearest picture of committed spend that has not hit the books yet. They tell finance what accruals to post at month-end, tell cash forecasting what payments are coming, and tell procurement which orders are late. Left untracked, they cause surprise invoices, understated liabilities, and budget that looks available but is already spoken for.
The accounting reason the report matters is the accrual. When goods have been received but the supplier invoice has not arrived, the company still owes the money, and the period it belongs to has closed. Accountants call this goods received not invoiced, and it is booked as an accrued liability so the expense lands in the right month. The open PO report, read against what has been received, is where those accruals come from. The mechanics are covered in goods received not invoiced.
Cash forecasting uses the same list from the other direction. An open PO with a near-term delivery date is a payment that is about to become due, so treasury can plan for it. Without the report, that outflow only appears when the invoice does, which is too late to manage.
They set the accruals. At close, finance compares what has been received against what has been invoiced; anything received but not yet billed is accrued as a liability so the cost hits the correct period. The open PO report, with its received-to-date and invoiced-to-date columns, is the source for that calculation. A messy open list produces wrong accruals and a close that does not tie out.
An open PO report is only useful if it reflects reality, and the common failure is stale orders that were fulfilled but never closed. A few habits keep it honest:
The other half is capture. Much of the mess comes from POs and receipts that never made it into the system cleanly in the first place, which is where getting the source documents into structured data early pays off. If you are still assembling the list by hand, how to track purchase orders covers the workflow, and procurement leaders use the rolled-up view described in purchase order data for procurement leaders to watch open commitments across suppliers.
You clear an open PO by completing or cancelling it. If the order was fully received and invoiced, closing it is a matter of confirming the three-way match and marking it complete. If it will never be fully delivered, cancel the outstanding balance so it stops inflating your commitment total. Regular review by age is how the stale ones get found and cleared before they distort the report.
Building the report means pulling PO data, receipts, and invoices together, usually in an ERP, sometimes in a spreadsheet. PurchaseOrders sits at the front of that: it reads purchase order documents and returns the PO number, supplier, dates, and line items as Excel, CSV, or JSON, so the raw orders enter your system as data instead of as PDFs someone retypes. It does not run the report, post accruals, or track receipts; that stays in your ERP. What it removes is the manual keying that makes the open PO list late and error-prone. Accuracy on the line table, which is where the outstanding balance is calculated, is covered in purchase order line item extraction, and getting the data into your system is covered in how to import purchase orders to your ERP. Closing each PO cleanly depends on the three-way match between the order, the receipt, and the invoice.