The mid-open checklist I use so a payables sheet stays honest

Vendor PDFs still sitting in email, a Slack that says “pay when you can,” a folder named Invoices_Final_FINAL, a stale AP export with due dates that do not match the PDFs, and a sticky that guesses “about next Friday somehow” are not mid-open truth. Mid-open is where duplicate bills from email + portal + PDF inflate the open total, partial payments still look like the full amount due, paid or credited bills stay Open because nobody flipped the status, disputed or “on hold” rows hide in a thread, guessed due dates lock as Net-30 fact, and the next payment batch is vibes instead of a dated list.

I am a freelancer admin helper. I turn a pile of vendor bills into a clean accounts-payable sheet. 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) so the payables sheet stays honest while dumps are still arriving.

(If you want the full messy vendor-bill dump → clean payables sheet workflow, see my earlier post. This one is the second-pass checklist so duplicate bills, silent partials, paid ghosts, disputed/hold burial, and guessed due dates do not quietly rewrite what is still to pay.)

What "honest" looks like mid-open

• Every row has vendor, invoice # (or “none — ask”), amount, invoice date, due date, status (to pay / scheduled / paid / disputed / missing info / ask), open remainder, and source — not vibes
• “Open” follows a named rule (not fully paid, not fully credited, or both) — not Slack folklore that shifts by thread
• Partial payments name original amount vs remaining open — not silently left at the full bill total
• Duplicate vendor+invoice lines (same PDF + portal export + email forward) are flagged once — not summed twice
• Paid or credited-to-zero bills sit as status + notes — not left Open so the due-in-7-days slice looks bigger than reality
• Disputed or “on hold” bills stay out of the ready-to-pay filter until status says otherwise
• Open questions (missing due date, no invoice #, vendor alias, currency unclear) are listed once so the handoff is honest

If the only “payables sheet” you have is a green To pay column and a thread titled “pay when you can,” mid-open honesty has already slipped.

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

Use this against the dump (vendor PDFs, email forwards, portal screenshots, stale AP exports, Slack “pay when you can” pings, prior open-AP sheets) before you paste everything into a pretty template and call the open list current.

1. Inventory the vendor-bill dump (same day you open the pile)

• [ ] Every scrap is listed once: source, date seen, claim type (open / partial / paid / disputed / credited / on hold / unknown), notes
• [ ] Duplicate paste of the same vendor+invoice across PDF batch + portal export + email forward is labeled duplicate — not counted as two open bills
• [ ] Partial dumps (“maybe Acme still owes us half,” a Slack ping with no amount) are labeled incomplete — not invented into tidy rows
• [ ] As-of / pay-batch window that matters is named (today, Friday batch, month-end) — older noise stays out or flagged
• [ ] Anything clearly paid, credited to zero, or belonging to a different entity is labeled stay-off-open — do not resurrect as this mid-open chase list

2. Lock vendor, amount, due date, and open remainder before you trust the totals

• [ ] Every “to pay” row has a real vendor or is labeled ask — not blank cells that look payable
• [ ] Invoice # and invoice date are written once (or ask / “none”) — not three conflicting stories left unresolved
• [ ] Amount is a number or ask — not “about next Friday somehow” locked as the fee line
• [ ] Due date is a date or ask — invented Net-30 folklore is worse than an honest gap
• [ ] Skim test: you can answer “what is still open, who is owed, what’s still fuzzy on due date?” without reopening Slack

3. Kill duplicate / paid-ghost / silent-partial inflation

• [ ] Status vocabulary is named (to pay / scheduled / paid / disputed / missing info / ask) — not blank cells that look batch-ready
• [ ] Evidence for paid (portal confirm, bank memo, receipt match) sits in notes or source — “I think we paid that” alone is not paid
• [ ] Partial rows name original amount and remaining open — “partial” alone is not a balance
• [ ] Paid or credited-to-zero bills are flipped off Open — not left green because the PDF is still in the dump
• [ ] Everything showing full open amount when payment notes say otherwise is labeled recheck until status is honest

4. Park guessed due dates, disputed/holds, and open asks in the open

• [ ] Missing required fields sit as ask with what is missing — not invented to tidy the due-in-7-days slice
• [ ] “TBD,” “about next Friday somehow,” and “usual Net-30” without a mapping stay ask — not locked as this week’s due date
• [ ] Disputed / on-hold bills stay out of ready-to-pay filters until status says otherwise
• [ ] Vendor name drift (Acme LLC / ACME / Acme Supplies) is normalized with aliases in notes — not three ghost vendors
• [ ] Open asks are listed once — not scattered as footnotes nobody will find at handoff

5. Mid-open skim before you call the sheet ready

• [ ] To pay / scheduled / paid / disputed / ask counts match a quick mental check of known open bills
• [ ] Ask rows and duplicate-bill suspects are countable in under a minute
• [ ] Totals never invent missing dollars or dates — blanks stay ask
• [ ] You can hand the sheet to someone else without a 10-minute Slack-and-PDF tour
• [ ] Soft CTA only if useful: this is cleanup so open bills, due dates, and payment status are easier to see — not advice on cash strategy, tax, or accounting entries

Soft CTA

If you want a pile of vendor bills turned into a clean accounts-payable sheet: https://brittanybonds.gumroad.com/l/payablesheet

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

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

Code ADMIN12 for $2 off.

No fake CPA or bookkeeper claims — spreadsheet cleanup so your vendor-bill dump is easier to track and hand off.