How I turn a messy purchase-order dump into a clean open-PO tracker

A shared drive full of PO PDFs, a vendor email thread that says “we already shipped half,” a buyer’s spreadsheet with blank PO numbers, and a Slack note that “maybe this one is closed” are not purchasing control. They are how open commitments hide until someone asks “what is still owed to vendors?” and nobody has a single answer.

Here is the workflow I use when someone dumps messy purchase orders on me and wants one clean open-PO tracker: every still-open PO on one sheet, tied to a vendor and expected receipt, with partials and unknowns flagged — without me pretending to be their AP clerk or CPA.

Why open POs go missing

Most dumps I see fail in the same three places:

1. Split sources — PDFs in email, line items in Excel, receiving notes in a warehouse chat
2. Name drift — “Acme LLC,” “ACME,” and “Acme Supplies” treated as three vendors
3. Status fog — “ordered,” “partial,” “received,” and “invoiced” mixed without a rule

If those stay fuzzy, the tracker lies. So I fix the fog before I polish the formatting.

Sort into three piles first

Before columns, I sort every PO-looking item into:

• Clearly open — ordered, not fully received / not cancelled
• Partial — something received or billed against it, balance still open
• Closed or unknown — cancelled, fully received, or “we cannot tell from this dump”

Unknowns do not get silently marked closed. They get a status and a question for the buyer.

What I ask for before I start

1. The dump (PO PDFs, buyer spreadsheet, vendor confirmations, receiving notes if any)
2. As-of date that matters (today, week-end, custom)
3. Whether “open” means not fully received, not fully invoiced, or both — their rule, stated once
4. Who the sheet is for (buyer, ops, bookkeeper handoff)
5. What “done” means (open-PO tracker, optional by-vendor totals, optional chase list for missing receipts)

I am a freelancer admin / spreadsheet helper. I do not give tax or financial advice, and I am not a CPA — this is purchase-order hygiene so their open commitments stay visible, not accounting, audit, or tax advice.

Build the tracker row by row

1. Inventory every PO-looking artifact — PDF, row, email confirmation; note source and date.
2. Normalize vendor names — one canonical vendor per row; keep originals in notes if they conflict.
3. Lock the PO identity — PO # (or “missing — ask”), order date, expected date if stated.
4. Capture the money and quantity — ordered amount / qty; received or billed-to-date if known; open remainder with a clear rule.
5. Apply status honestly — open, partial, closed, cancelled, unknown — never invent “closed” to tidy the sheet.
6. Hand back — the open-PO tracker (+ short list of questions); no AP posting, no “how to book this” language.

Columns that usually work

Column	What goes here
Vendor	Canonical vendor name (note aliases in Notes)
PO #	Purchase order number or “missing — ask”
Order date	When the PO was issued, if known
Expected date	Promised / needed-by date (flag if guessed)
Ordered	Amount or qty ordered (note units / currency)
Received / billed	What came in or was invoiced against it so far
Open remainder	Still open under their stated rule
Status	Open, partial, closed, cancelled, unknown
Source	Which PDF batch, sheet, or email the line came from
Notes	Partial receipt, vendor alias, “needs buyer confirm”

Common traps I flag instead of guessing

• Duplicate PO # across two PDFs with different totals
• Line-level POs flattened into one row when the buyer cares about lines
• “Received” in chat with no date or qty
• Vendor invoice that might close the PO — but the dump does not prove it
• Blank expected dates filled in from “usually two weeks” folklore

Those become Notes or a short question list, not silent edits.

Soft CTA

If you want this done for you as a one-off: I turn a messy purchase-order dump into a clean open-PO tracker in about 24 hours.

Product: https://brittanybonds.gumroad.com/l/posheet

Shop: https://brittanybonds.gumroad.com/

Catalog mirror: https://brittany-bonds.github.io/

Code ADMIN12 for $2 off.

No fake CPA claims — spreadsheet cleanup so your open purchase orders are easier to track and hand off.