Most small bookkeeping firms don’t lose time on the bookkeeping. They lose it in the gap before the work starts: working out which client has sent what, scrolling back through email to find the statement someone said they’d “send tonight”, then writing the same polite nudge for the fourth time.
The fix isn’t a better email. It’s a small system that answers one question at a glance: who still owes me what, and for how long? Here is the version we run, and how to set it up in an afternoon.
Why chasing eats so much time
Chasing feels like a client problem, but most of the cost comes from three habits on our side:
- The list lives in your head or your inbox. If the only record of “Brightline still owes the September bank statement” is an unread email thread, you have to rebuild that list every time you check.
- Every reminder is written from scratch. Ten clients with two or three missing items each means ten custom emails a month.
- There is no clock. Without a date requested, “a while ago” turns into three weeks before anyone notices.
Fix those three and chasing becomes a ten-minute weekly task.
Step 1: send the same request list every month
Decide, per client, which documents you need each month. For most small businesses that’s a short list:
| Document | Who usually has it |
|---|---|
| Bank statements, every account | Owner or office manager |
| Credit card statements | Owner |
| Merchant reports (Stripe, PayPal, Square) | Whoever runs sales |
| Payroll report, if run elsewhere | Payroll provider |
| Receipts for card and cash spending | Everyone who spends |
Agree that list during onboarding, then send it on the same day each month, ideally the first working day. Clients learn the rhythm quickly when it never changes. Our free document request checklist covers monthly, onboarding and year-end items if you want a starting point.
Step 2: log every request with a date
The moment you ask for something, write it down with the date. One line per client, per document, per month:
| Client | Month | Document | Status | Date requested |
|---|---|---|---|---|
| Brightline Plumbing | Sep | Bank statement | Requested | Sep 19 |
| Brightline Plumbing | Sep | Sales report | Requested | Sep 28 |
| Maple Street Bakery | Sep | Bank statement | Received | Sep 17 |
This looks like extra work. It is the opposite: it is the only thing that lets you stop thinking about it. When a document arrives, change the status to Received. Everything else stays visible until it does.
Step 3: pick an overdue limit and stick to it
Choose how many days you wait before something counts as late. Seven days works for most firms; use five if your month-end close is tight.
Then let the date do the work. With a “days waiting” column (today’s date minus the date requested), anything past your limit can turn red automatically in Google Sheets with conditional formatting. You no longer decide who to chase. The sheet tells you.
Step 4: send one reminder per client, not per document
The worst reminders are the ones that arrive one item at a time. Group everything a client owes into a single short message:
Hi Daniel,
Just a friendly reminder, I’m still waiting on the following for Brightline Plumbing: • Bank statement (Sep) • Sales report (Sep)
Could you send these by Friday?
Thank you!
Keep it short, list exactly what’s missing with the month, and give a specific date. Specific dates get answers; “when you get a chance” gets ignored.
If your tracker is in Google Sheets, you can build this message with a formula. TEXTJOIN with FILTER pulls every overdue item for a client into one cell, so the reminder writes itself and you only copy and paste.
Step 5: run it on a fixed weekly rhythm
Block fifteen minutes on the same day every week:
- Mark anything that arrived as Received.
- Open the list of overdue items.
- Send one grouped reminder to each client on it.
That’s the whole routine. Firms that do it weekly rarely need a second reminder, because the first one lists everything at once and gives a date.
What to do about clients who still don’t send
Some clients will ignore every system. Two things help:
- Make the consequence clear during onboarding. “If documents arrive after the 15th, that month’s reports move to the following month” is a reasonable term in an engagement letter.
- Escalate the channel, not the tone. If two emails go unanswered, a short phone call or text usually works better than a sterner third email.
Build it or use a ready-made tracker
You can build everything above yourself in Google Sheets: a documents tab, a days-waiting formula, a conditional formatting rule and a TEXTJOIN reminder. It takes an afternoon if you’re comfortable with formulas.
If you’d rather skip that, the Client Onboarding & Document Tracker is this exact system, set up and tested: an onboarding checklist, a monthly documents tab that flags late items, a chase list that writes one reminder per client, and a dashboard. Make a copy, add your clients, and you’re running the routine the same day.
This guide covers running the practice, not tax law. Rules differ by country and change often, so check anything technical with your local tax authority or professional body.
