The week-of chase checklist I use so an AR aging sheet still matches what is open

Mid-aging honesty is necessary. Week-of chase is different. The morning you decide "I will chase / send / escalate from this sheet today" is when last week's as-of is still sitting on the header, everything is still parked in 0–30 because nobody recalculated, a partial still looks like the full open balance, a disputed invoice is still in the chase filter, the same PDF+export line is still summed twice, and a raw Slack dump quietly hitchhiking into the share.

I am a freelancer admin helper. I turn messy overdue invoice dumps into a clean AR aging 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 the week I am about to treat the sheet as the chase list (the final pass before anyone emails, calls, or escalates from it) so as-of drift, bucket theater, silent partials, disputed/hold burial, and duplicate lines do not become the open story.

This is complementary to my earlier posts — not a rewrite. For the full messy overdue invoice dump → clean AR aging sheet workflow, see How I turn a messy overdue invoice dump into a clean AR aging sheet. For the mid-aging honesty pass while dumps are still arriving, see The mid-aging checklist I use so an AR aging sheet stays honest. This third pass is the week-of chase check: mid-aging honesty is not enough once someone else will treat the sheet as done.

What "honest enough to chase" looks like

• Open filter shows real money still open — not theater, duplicates, or invoices already paid/credited
• Open / partial / disputed / on hold / ask are still separated — nothing looks chaseable that is still unclear
• Every complete-looking row has a source (PDF, aging export, payment note) — "I remember it" is not a source
• Each open amount has a client + invoice # + due date from a named as-of — orphan labels do not ship as ready
• Missing PDFs, wrong due dates, and unknown clients are visible and named — not silently deleted so the sheet looks tidy
• As-of date that matters is named on the sheet — older closed noise stays out or flagged
• Raw dump artifacts (CSV leftovers, unfinished notes, named complainers) are out of the share view
• You can answer "what is still open this as-of, by client and bucket?" without reconstructing six exports

If the only chase plan you have is a sticky labeled "blast the open column," week-of chase honesty has already slipped.

The week-of chase checklist (run it before anyone hits send / call / escalate)

Use this against the near-final AR aging sheet and the live artifacts (PDF invoices, aging exports, payment/credit notes, dispute threads) before anyone treats the sheet as this week's chase truth.

1. Kill as-of drift and bucket theater before the sheet leaves

• [ ] One as-of date sits at the top — not three conflicting "as of" notes in different tabs
• [ ] Buckets (0–30 / 31–60 / 61–90 / 90+) are recalculated from due date vs that as-of — not copied from last week's export
• [ ] Everything still parked in 0–30 "for now" when due dates say otherwise is labeled bucket theater until recalc
• [ ] Rows without a usable due date are ask or incomplete — invented Net-30 folklore is worse than an honest gap
• [ ] Skim test: you can answer "as of when is this aged?" without opening Slack

2. Separate open / partial / disputed / hold from chase-ready before anyone trusts Open

• [ ] Status is open / partial / disputed / on hold / credited / paid (if still in dump) / ask — not mood words or a single Open checkbox for everything
• [ ] Partial rows name original amount and remaining open — "partial" alone is not a balance
• [ ] Disputed / on-hold invoices stay out of "ready to chase" filters until status says otherwise
• [ ] Credits applied against an invoice reduce the open amount (or sit as a linked credit note) — not left invisible while the full amount ages
• [ ] Skim test: you can answer "what is actually chaseable this as-of?" without reconstructing six exports

3. Lock sources, clients, and duplicates

• [ ] Each open amount has a source note (which PDF, which export, which payment note) — orphan amounts without a source are Needs-confirm
• [ ] Clients match a named list or are marked Needs-confirm — floating labels that look unique are folklore
• [ ] Duplicate paste across PDF batch + aging export + chase email is one row or one labeled duplicate — not two open balances
• [ ] Currency mixes are labeled — do not silently sum USD + "local" into one bucket total
• [ ] Skim test: sorting by invoice # shows one open line per invoice, not a museum of doubles

4. Catch silent partials and open theater

• [ ] Rows marked open that still need a PDF or due date move back to ask
• [ ] Fake greens (all Open, no ask section) get a forced missing-ref pass before the sheet ships
• [ ] Open theater ("chaseable" for everything) is broken into real invoice refs or Needs-confirm
• [ ] Threads titled "quick chase note" without a usable amount are labeled artifact thin
• [ ] Skim test: missing-ref filter shows real gaps, not theater

5. Honesty tripwires (before you treat the sheet as chase-ready)

• [ ] You did not promote vibes to "all open" because the Open column looked empty of red
• [ ] Disputed invoices buried in a wall of chat paste are lifted — not left under a chase headline
• [ ] Incomplete sections stay Needs-confirm — not silently promoted to "ready" because the sheet looked sparse
• [ ] Raw dump artifacts (unfinished CSV paste, named complainers, draft notes) are out of the share view
• [ ] Skim test: a stranger can answer "what is still open this as-of, by client and bucket?" from the sheet alone

Soft CTA

If you have a messy overdue invoice dump and want a clean AR aging sheet in 24 hours: agingsheet on Gumroad ($12). Code ADMIN12 for $2 off. Full shop: brittanybonds.gumroad.com. Catalog mirror: brittany-bonds.github.io.

Not a CPA. Not financial, tax, legal, or accounting advice — just admin cleanup so the open story matches what is actually still owed.