All articles

QuickBooks Open Purchase Orders Cleanup: Close Stale POs

10 min read CSVQBO Team
csv / xls / xlsx → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

Short answer: Purchase orders and sales orders are non-posting transactions, so a stale one never shows up on your profit and loss or balance sheet. What it does distort is inventory. QuickBooks calculates availability as quantity on hand, plus quantity on purchase order, minus quantity on sales order, so every abandoned order skews what the system thinks you can sell and when it tells you to reorder. You clean them up by running the open order reports, then closing each order (or each unfinished line) rather than deleting it.

This is the cleanup step almost everyone skips, because nothing on the financial statements looks wrong. A bookkeeper reviewing the trial balance will never spot it. It surfaces instead as a purchasing manager who does not trust the reorder report, a warehouse that runs out of an item the system swore was available, or a job costing report showing committed costs for a project that closed two years ago.

Why open purchase orders matter if they are non-posting

Non-posting means no general ledger entry. It does not mean no effect. A purchase order raises the quantity on order for every item on it, and that quantity feeds the availability math QuickBooks uses for reorder points and, in Enterprise, for what it will promise a customer. A sales order does the opposite, reserving stock and reducing what is available to sell.

EffectOpen purchase orderOpen sales order
General ledger and P&LNoneNone
Quantity on handNo changeNo change
Availability mathIncreases quantity on orderIncreases quantity on sales order, reducing available
Reorder point alertsSuppresses reorder prompts, since stock looks like it is comingTriggers reorder prompts earlier
Accounts payableNone until you turn it into a billNot applicable
Shows on open order reportsYes, until closed or fully receivedYes, until closed or fully invoiced

The failure mode with the longest tail is the first one in that table. A purchase order that was cancelled by phone three years ago still tells QuickBooks that 40 units are inbound. The reorder report stays quiet, nobody buys, and the item runs out. Because the cause is a document nobody has looked at since 2023, the stockout gets blamed on the reorder point instead.

How do I find open purchase orders in QuickBooks?

In QuickBooks Desktop, go to Reports, Purchases, Open Purchase Orders for the list, or Open Purchase Orders Detail when you need to see how much of each line has been received. Sort by date and look at anything older than your normal lead time, because a purchase order still open well past its delivery window is almost always finished in real life and unfinished in the file.

For sales orders, run Reports, Sales, Open Sales Orders by Customer, or Open Sales Orders by Item when you are chasing an availability problem on one specific product. The by-item version is the one to run when someone reports that stock exists on the shelf but QuickBooks will not let them sell it.

Print or export both reports before you change anything. Closing an order removes it from these reports, and without a starting list you have no way to check your own work or to explain later what you closed and why.

How do I close a purchase order in QuickBooks Desktop?

Open the purchase order and select the Closed checkbox on the form to close it in full. To close only part of it, use the Clsd column at the far right of the Create Purchase Orders window and tick the individual lines that will never be received. QuickBooks then reduces the quantity on purchase order by the amount on each line you closed.

Two behaviors catch people out. A purchase order stays open as long as at least one line is still open, so ticking four lines out of five leaves it on the report. And you cannot mark a subtotal line as closed, only real item lines, which is why an order built with subtotals sometimes seems impossible to clear line by line. In that case close the whole order with the header checkbox.

Closing partially received orders is the most common case by far, and it has a name in purchasing: short closing, meaning you accept what arrived and stop expecting the rest. Most stale orders are not wrong, just unfinished, which is why the discipline of short closing every partial order is what keeps a purchasing system honest over years rather than months.

How do I close multiple purchase orders at once?

QuickBooks Desktop has a batch path that saves a lot of clicking. Go to Vendors, Bill Tracker. Under Type choose Purchase Order, set the status filter to Open, tick the orders you want to clear, then use Batch Actions, Close Purchase Orders at the bottom of the window.

Use this for genuinely dead orders only. Batch closing works at the whole-order level, so an order that is half received gets closed entirely, and any line you actually still expect gets closed with it. Handle partials one at a time with the Clsd column, and batch the rest.

A closed purchase order still shows as open. What now?

This happens, and it is usually a stale form rather than a real problem. The fix that works most often is to force QuickBooks to rewrite the record: open the purchase order, type anything into the memo field, then save. That alone frequently clears it off the Open Purchase Orders report.

If that does not work, toggle the status. Mark the order open, save and close it, then reopen it and mark it closed. Adding a line and deleting it again, with quantity and amount both cleared, has the same rewrite effect. These are workarounds rather than explanations, but they are what reliably clears a stuck order.

If a batch of orders refuses to close even after that, raise it with Intuit support rather than keep fighting it. Stuck-open purchase orders have been a recurring reported issue rather than a sign that something is wrong with your file.

Should I delete or close an old purchase order?

Close it. Deleting removes the record that the order ever existed, which breaks the audit trail and, if any of it was received, orphans the receipt history a vendor dispute would depend on. Closing keeps the document, keeps the history, and takes the quantity out of the availability math, which was the only real problem.

There is one narrow exception. If a purchase order was entered by mistake, has never been received against, and represents nothing that ever happened, deleting it is reasonable and keeps the file cleaner. The test is whether the document describes a real event. If it does, close it.

How do purchase orders and sales orders work in QuickBooks Online?

Purchase orders in QuickBooks Online require Plus or Advanced. Sales orders require Plus, Advanced, or Intuit Enterprise Suite, and like their Desktop equivalents they are non-posting and reserve items from inventory without touching your books. From the Action column you can convert a sales order into an invoice to bill the customer, or into a purchase order to buy the stock you need to fulfill it.

A purchase order in QuickBooks Online closes on its own once you have copied all of it to a bill, and you can set the status to Closed by hand when the rest is never arriving. The cleanup logic is identical to Desktop: find the ones that outlived their delivery window, decide whether anything is still genuinely coming, and close what is not.

Where open orders belong in a cleanup

Do this after the register is right and before you touch inventory quantities. Open orders are downstream of the bank feed and upstream of stock valuation, so cleaning them first means redoing the work once the underlying transactions land. The order that holds up is bank activity, then bills and payables, then open orders, then inventory.

If the register itself is the weak link, that is a separate job. Bank feeds routinely stop at 90 days, and QuickBooks Desktop cannot import a bank CSV in any version, so a year of missing history has to be converted into a Web Connect file first. The comparison of the best CSV to QBO converters covers which tools handle a multi-year backfill, and the converter at the top of this page will do a single file while you are reading.

Stale orders also travel with the same problems every time. If availability looked wrong before you started, check negative inventory and the COGS damage it causes, and if the stock figure on the balance sheet does not agree with the valuation report, the inventory valuation mismatch is the usual reason. Payables that never got matched to their orders are covered in the accounts payable cleanup. For the sequence across a whole file, use the cleanup checklist for a new client, and for the recurring version, the month-end close checklist.

Frequently asked questions

Do open purchase orders affect my financial statements?

No. Purchase orders are non-posting, so they never appear on the profit and loss, the balance sheet, or accounts payable. Nothing hits the ledger until you convert the order into a bill or an item receipt. This is exactly why stale orders survive for years: every financial report a bookkeeper checks looks correct while the inventory and purchasing side quietly drifts.

Why does a purchase order still show as open after I received everything?

Usually because the bill or item receipt was entered separately instead of created from the purchase order, so QuickBooks never linked the two and never marked the lines received. It can also happen when the received quantity differs slightly from what was ordered, leaving a small remainder open. Either way the fix is the same: tick the Clsd column on the finished lines, or the Closed checkbox on the order.

Does closing a purchase order change my inventory quantity on hand?

No. Quantity on hand only changes when you actually receive items. Closing an order reduces the quantity on purchase order, which changes what QuickBooks reports as available and when it prompts you to reorder, but the physical count it holds for the item is untouched. That is what makes this cleanup safe to do in bulk.

Can I reopen a purchase order I closed by mistake?

Yes. Open the order and clear the Closed checkbox, or untick the Clsd column on the lines you closed, and it returns to the open reports with its quantities restored. Nothing is destroyed by closing an order, which is the main reason closing is the right tool here and deleting is not.

How often should open orders be reviewed?

Monthly for a business that carries inventory, quarterly for one that does not. Tie it to the close so it actually happens: run the open purchase order and open sales order reports, ask whether anything older than your lead time is genuinely still coming, and close what is not. A few minutes a month prevents the multi-year backlog that takes a full afternoon to unwind.

Last updated August 2026.

Convert your CSV to QBO now

Upload your CSV or Excel statement, map the columns, and download a QuickBooks ready QBO file in seconds.

Start converting