The mid-open checklist I use so an open-PO tracker stays honest

A shared drive of PO PDFs, a buyer spreadsheet with blank PO numbers, a warehouse Slack that says “we already got half of that,” a vendor email with a different ETA than the sheet, and a note that “maybe this one is cancelled” are not mid-open truth. Mid-open is where a PO still shows fully open after it was received, a partial receipt still looks like the full ordered qty, the same vendor+PO lands twice, cancelled lines stay Open because nobody flipped the status, guessed ETAs pretend to be promised dates, currencies get summed like they match, and “received but not invoiced” gets confused with “still open to receive.”

I am a freelancer admin helper. I turn messy purchase-order dumps into a clean open-PO tracker. I am not a CPA, bookkeeper, lawyer, or tax advisor — and this is not financial, tax, legal, or accounting advice. It is the checklist I run mid-open (and again before anyone treats the sheet as what is still owed to vendors) so the open-PO tracker stays honest while dumps are still arriving.

(If you want the full messy purchase-order dump → clean open-PO tracker workflow, see my earlier post. This one is the second-pass checklist so stale open POs, partial-qty theater, duplicate vendor+PO lines, cancelled ghosts, guessed ETAs, and Slack folklore do not quietly rewrite what is still open to receive.)

What "honest" looks like mid-open

• Every row has vendor, PO # (or “missing — ask”), order date, expected date, ordered qty/amount, received/billed-to-date, open remainder, status, and source — not vibes
• “Open” follows a named rule (not fully received, not fully invoiced, or both) — not Slack folklore that shifts by thread
• Partial receipts name ordered vs received vs still open — not silently left at full open qty
• Duplicate vendor+PO lines (same PDF + buyer sheet + email confirmation) are flagged once — not summed twice
• Cancelled or fully received POs sit as status + notes — not left Open so the open total looks bigger than reality
• Received-not-invoiced vs open-to-receive are separable when the buyer cares — not one green Open column for both
• Open questions (missing PO #, guessed ETA, currency unclear, vendor alias) are listed once so the handoff is honest

If the only “open-PO tracker” you have is a green Open column and a thread titled “all ordered,” mid-open honesty has already slipped.

The mid-open checklist (run it before / while you clean)

Use this against the dump (PO PDFs, buyer spreadsheets, vendor confirmations, receiving notes, warehouse Slack, prior open-PO exports) before you paste everything into a pretty template and call the open list current.

1. Inventory the PO dump (same day you open the pile)

• [ ] Every scrap is listed once: source, date seen, claim type (open / partial / received / cancelled / invoiced / unknown), notes
• [ ] Duplicate paste of the same vendor+PO across PDF batch + buyer sheet + email confirmation is labeled duplicate — not counted as two open commitments
• [ ] Partial dumps (“maybe Acme still owes us half,” a Slack receive with no qty) are labeled incomplete — not invented into tidy rows
• [ ] As-of date that matters is named (today, week-end, custom) — older noise stays out or flagged
• [ ] Anything clearly cancelled, fully received, or superseded is labeled stay-off-open — do not resurrect as this mid-open chase list

2. Lock the open rule before you trust any remainder

• [ ] One open rule sits at the top of the sheet (not fully received / not fully invoiced / both) — not three conflicting definitions in different tabs
• [ ] Open remainder is computed from that rule — not copied from a stale export without recalc
• [ ] If the rule or as-of moves mid-pass, every open remainder is recalculated — do not leave last week’s “still open” as this week’s truth
• [ ] Rows without a usable PO # are ask or incomplete — invented PO folklore is worse than an honest gap
• [ ] Skim test: you can answer “open means what, as of when?” without opening Slack

3. Kill partial-qty theater and stale-open inflation

• [ ] Status is open / partial / received / cancelled / invoiced / ask — not mood words or a single Open checkbox for everything
• [ ] Partial rows name ordered qty/amount and received/billed-to-date and remaining open — “partial” alone is not a balance
• [ ] POs already fully received (or cancelled) are flipped off Open — not left green because the PDF is still in the dump
• [ ] Everything still showing full open qty when receiving notes say otherwise is labeled partial-qty theater until recalc
• [ ] Currency mixes are labeled — do not silently sum USD + “local” into one open total

4. Park guessed ETAs, missing PO #s, and RNI vs open-to-receive in the open, not in silence

• [ ] Expected dates filled from “usually two weeks” folklore are labeled guessed — not locked as promised ETAs
• [ ] Missing PO numbers sit as ask with what is missing — not invented to tidy the sheet
• [ ] Vendor name drift (Acme LLC / ACME / Acme Supplies) is normalized with aliases in notes — not three ghost vendors
• [ ] Received-not-invoiced rows stay separable from open-to-receive when the buyer’s rule cares — not one Open filter that lies about both
• [ ] Anything you almost guessed (ETA, open qty after partial, which PDF matches which sheet row) stays in notes as guessed — not locked as truth

5. Mid-open skim before you call the tracker “current”

• [ ] Open totals by vendor (and optionally by status) match a quick mental check of known big open POs
• [ ] Duplicate suspects and ask rows are countable in under a minute
• [ ] As-of + open-rule labels are still correct (you did not accidentally keep cancelled or fully received POs in this mid-open list)
• [ ] Handback note names what is still open / partial / ask vs what is already received, cancelled, or invoiced — not “sheet is done”
• [ ] You could hand this to a bookkeeper or buyer without them having to reverse-engineer Slack

What I refuse to do mid-open

• Invent missing PO numbers or ETAs just to clear the incomplete filter
• Book AP entries, receiving journals, or “how to record this in QuickBooks”
• Call myself a CPA or claim the sheet is audit-ready
• Hide cancelled / fully received rows so the open total looks prettier (or bigger)

Honest mid-open tracking is boring on purpose. The point is that when someone asks “what is still open to vendors as of Friday?” you are not reconstructing six PDFs and a warehouse thread.

Soft CTA

If you want the messy dump cleaned for you: I turn a 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.