Track missing client documents without a portal

For solo and 1–3 person bookkeeping practices. Line items beat laundry lists.

Month-end slip usually isn’t “clients ignore email.” It’s that nobody can see which statement, receipt pack, or access item is still open. A lightweight tracker (Airtable, Sheets, or Notion) with one row per required document beats another SaaS portal most freelancers don’t want to buy.

Minimum columns

Client · Period (e.g. Aug 2026)
Item (named: “Chase Sapphire PDF”, not “statements”)
Owner (client / you / bank feed)
Status: Missing · Received · N/A (pullable)
Last ask date · Next ask (Day 3 / 7 / 10)

Operating rhythm

Day 0: seed rows from the engagement checklist; mark pullable accounts N/A
Only email rows still Missing — never re-blast the full list
Day 3 / 7 / 10: filter by Status=Missing and Next ask ≤ today
Close gate: billable close starts when every required row is Received or N/A

Related free guides

Grab the free phased monthly-close checklist, or join the CloseReady early-access waitlist for the full intake + monthly ask kit (tracker schema + chase packs).