The mid-AR checklist I use so an accounts-receivable sheet stays honest

Two PDFs of the same invoice. A paid one still marked open. A due date that never appeared on the file. A row with an amount and no customer name. A PDF sitting in the folder with no sheet row. A credit memo filed as a payment. Aging buckets that look tidy while partials still show the full balance. A superseded invoice still greening the open list. That is not mid-AR truth. Mid-AR is where duplicate folklore inflates what is owed, paid slips look live, invented dates and missing names fake completeness, and a pretty sheet pretends the PDF pile agreed with itself.

I am a freelancer admin helper. I turn messy invoice PDF piles into a clean accounts-receivable sheet. I am not a CPA, bookkeeper, lawyer, tax advisor, or collections agent — and this is not financial, tax, legal, collections, or accounting advice. It is the checklist I run mid-AR (and again before anyone treats the sheet as what is still open) so the AR sheet stays honest while PDFs are still arriving.

(If you want the full messy invoice PDFs → AR sheet workflow, see my earlier post. This one is the second-pass checklist so duplicate invoices, paid marked open, invented due dates, missing customer names, PDF folklore without a row, credits misfiled as payments, aging buckets that ignore partials, and superseded invoices still open do not quietly rewrite what clients still owe.)

What "honest" looks like mid-AR

• Every real invoice is one row — duplicate PDFs of the same # + amount are merged, not counted twice
• Status matches evidence — paid stays paid; open stays open; partials show remaining, not the full original
• Customer name, invoice #, issue date, due date, and amount exist or are labeled ask — blank cells that look complete are worse than an honest gap
• Every PDF in scope maps to a row (or is labeled out-of-scope / estimate / void) — folder folklore without a row is not AR
• Credits are credits (or separate negative rows) — not misfiled as payments that zero the wrong invoice
• Aging buckets use evidenced due dates and remaining open — tidy 0–30 / 31–60 / 61+ that ignore partials is theater
• Superseded, voided, or replaced invoices are archived — not still looking live beside this week’s open balance

If the only “AR” you have is a green open column and a folder titled “invoices somehow,” mid-AR honesty has already slipped.

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

Use this against the dump (invoice PDF folder, scans/photos, payment notes, bank matches if provided, old export) before you paste everything into a pretty template and call the sheet current.

1. Inventory the invoice PDF dump

• [ ] Soft cutoff is named (this quarter / open only / since date X) — older noise stays out or flagged
• [ ] Every file is listed once: source, invoice # (if any), claim type (invoice / credit / estimate / void / unknown), notes
• [ ] Duplicate PDFs of the same invoice # + amount are labeled duplicate — not counted as two opens
• [ ] Partial dumps (scan with no #, filename folklore with no amount) are labeled incomplete — not invented into tidy rows
• [ ] Anything clearly superseded, voided, or replaced is labeled stay-off-open — do not resurrect as this mid-AR live invoice

2. Lock identity, dates, amount, and status before you trust aging

• [ ] Every row has a customer name or is labeled ask — missing names are not a chase list
• [ ] Invoice # is locked or ask — three near-matches are one invoice until proven otherwise
• [ ] Issue date and due date exist only when evidenced on the PDF / notes — invented due dates stay guess / ask
• [ ] Amount + currency are on the row or ask — blank cells that look billed are worse than an honest gap
• [ ] Status is open / paid / partial / void from evidence — paid marked open is folklore, not AR
• [ ] Skim test: you can answer “who owes what, by when, what’s still open?” without reopening the PDF folder

3. Kill duplicate / paid-as-open / credit-as-payment inflation

• [ ] Same invoice under two filenames or PDF + export is one row — not two open balances
• [ ] Paid invoices are marked paid (with paid date when known) — do not leave them greening the open list
• [ ] Partials show amount paid + amount remaining — full original still open is silent-partial theater
• [ ] Credits / credit memos are separate rows or negatives — not misfiled as payments that clear the wrong invoice
• [ ] Estimates, proposals, and quotes that look like invoices stay out unless marked billed
• [ ] PDF folklore with no sheet row is either added once or labeled out-of-scope — folder ghosts are not AR

4. Park open asks, tidy-bucket lies, and superseded invoices

• [ ] Invented due dates are either evidenced or labeled guess / ask — not locked because the aging column looked empty
• [ ] Aging buckets (0–30 / 31–60 / 61+) use remaining open + evidenced due — tidy buckets that ignore partials stay incomplete
• [ ] Open asks (missing customer, unclear #, which PDF is canonical, paid vs open conflict) sit in one list — not scattered across filenames
• [ ] Superseded, voided, and replaced invoices are archived once so they do not still look live
• [ ] Anything still incomplete stays incomplete — do not greenwash a mid-AR dump into a closed open-balance sheet

Soft CTA

If you want the pile cleaned into an AR sheet for you: invoice PDFs in, AR sheet out in 24 hours — $12 on Gumroad. Code ADMIN12 takes $2 off. Full catalog: shop · GitHub Pages.

Not financial, tax, legal, collections, or accounting advice. I organize the PDFs; you own the balances and the follow-up.