A client tracker for accountants is one row per client holding the facts the firm checks weekly: who the client is, what work is engaged, who owns it, which documents are in and missing, the return status and the due date. A spreadsheet handles this for a small book; software earns its place once several people update it daily.
Columns a client tracker for accountants needs
A client tracker for accountants needs columns that someone reads or acts on at least weekly. Twelve is a workable number for a tax practice: identity, contact, engagement, ownership, documents, status and dates. Any column nobody has filtered or sorted by in a month is a candidate to remove.
Here is a sample tracker with twelve columns and three rows. The clients, names, contacts and figures are fictional examples.
| Client | Contact | Engagement | Preparer | Reviewer | Expected docs | Received | Missing | Duplicates | Return status | Due date | Last client contact |
|---|---|---|---|---|---|---|---|---|---|---|---|
| D. and M. Alvarez | Dana Alvarez | 1040 | J. Chen | P. Shah | 11 | 9 | 2 | 1 | Waiting on client | Apr (1040) | Mar 4 |
| Example Bakery LLC | Sam Rivera | 1065 + books | R. Ortiz | P. Shah | 18 | 18 | 0 | 2 | In review | Mar (1065) | Feb 26 |
| Lakeside Dental PC | Lee Park | 1120-S | J. Chen | P. Shah | 14 | 6 | 8 | 0 | Collecting | Mar (1120-S) | Feb 10 |
What each column is for:
- Client and Contact: the legal name and the person who answers questions. These are the columns a reminder is addressed from.
- Engagement: the return type and any bookkeeping or payroll work. It drives the due date and the expected document list.
- Preparer and Reviewer: two named people. A row with a blank owner is a row nobody updates.
- Expected docs, Received, Missing and Duplicates: counts from the client's document list. The section on the document status column explains why four counts beat one checkbox.
- Return status: one value from a short fixed list. The status list and the event that moves a return into each status are defined in the post on tax return status tracker statuses and entry rules.
- Due date: the filing deadline for the engagement type, adjusted if an extension is filed.
- Last client contact: the date of the last request or reply. It is the column that tells you Lakeside Dental has not heard from the firm in weeks.
Columns that usually do not earn their place: fee and billing detail (it lives in billing), long free-text history (it belongs in notes), and a column per document (it belongs on the document list, not the tracker).
Client tracker spreadsheet or client management software?
A client tracker spreadsheet works until three things happen together: more than one person edits it every day, the document counts have to be updated by hand from another place, and the row count passes what one person can scan. When all three are true, accounting client management software usually costs less time than the spreadsheet does.
The spreadsheet has real strengths. It is free, every staff member already knows how to use it, and it can be shaped to the firm in an afternoon. For a sole practitioner with eighty clients, a well-built sheet with filters on Preparer and Return status may be all that is ever needed.
The spreadsheet's weak point is the document columns. Expected, Received, Missing and Duplicates come from somewhere else: an inbox, a shared folder, a stack of scans. Someone has to count them and type the counts in. That retyping is where a spreadsheet tracker drifts from the truth, because the counts are only as current as the last time someone sat down to update them.
Software changes that by taking the counts from the documents themselves. When the system that receives a client's files also matches them to the expected list, the Received and Missing columns update as documents arrive. The tracker becomes a view of the work rather than a second record of it.
Signs the spreadsheet has stopped working
A few symptoms show up before anyone decides the sheet is broken. Two preparers call the same client about the same missing form in one week. A partner asks which returns are ready to start and nobody can answer without opening folders. The Last client contact column is blank for a third of the rows. Someone has started keeping a private copy "just for my clients". Each of these means the tracker is no longer the record people trust, and a better-organized sheet will only delay the same problem by a few weeks.
Questions to ask before switching:
- Does the tool fill the document columns from received files, or do staff still type them?
- Can each preparer see only their own rows by default?
- Can the data be exported to Excel or CSV if the firm moves on?
- What does it cost for the firm's number of clients and staff?
Measuring whether the switch actually saved time is a separate exercise. The post on measuring tax season hours saved explains how to set a baseline before changing tools so the comparison is honest.
What does a document status column add to a client tracker?
A document status column turns a client tracker from a list of names into a list of next actions. Instead of one "docs in?" checkbox, it holds three counts per client: documents received, documents missing and duplicates found. Together they show who to chase, who is ready to start, and whose file needs cleaning before entry.
The Missing count is the one that drives follow-up. Lakeside Dental, in the sample above, has eight of fourteen documents outstanding. Sorting the tracker by Missing, highest first, gives the week's call list in one step. The details of what each client still owes, and how to ask for it, are covered across the missing documents category.
The Received count tells the preparer when a client is ready. A row reading 18 of 18 received, like Example Bakery, can move to preparation. A checkbox ticked "yes" because a large upload arrived cannot tell you that; a count matched against an expected list can.
The Duplicates count is easy to dismiss and expensive to skip. A client who forwards the same 1099-INT twice, or who sends a phone photo and later the PDF of the same W-2, has given the firm two files and one document. If the duplicate is not caught, the figure can be entered twice. A nonzero Duplicates count is a prompt to check the file before entry starts.
Filling these counts by hand is slow. Schema CPA fills them from what each client actually sent: its demo lists every document as received, missing or duplicate and then drafts a reminder for the firm to review before it goes out. You can try the demo on the homepage with fictional clients.
Client tracker mistakes that make it go stale
A client tracker goes stale when updating it is a separate job from doing the work. That usually happens in March, when the team is busiest and the tracker is the first thing dropped. The mistakes behind it are predictable, and each has a structural fix.
Updating as a chore instead of as a step
If a preparer finishes a return and then has to remember to open the tracker, the tracker will lag. Make the status change part of handing off: the return does not go to review until the row says In review. The handoff and the update become one action.
Too many columns
Every column is a cell someone must keep current. A tracker with thirty columns in January has twelve that are maintained by March and eighteen that are wrong. Start with fewer columns than you think you need and add one only when someone asks for it twice.
Counts copied from somewhere else
Document counts typed by hand from an inbox are stale the moment the next email arrives. Either take them from a system that matches documents, or update them at a fixed time each week and show the date of the last update on the sheet.
No owner per row
A row with no preparer has no one to update it. Fill Preparer and Reviewer for every client at engagement, even if the assignment may change later.
Statuses with no entry rule
When "Ready" means different things to different people, the status column stops being trusted, and an untrusted column is soon ignored. Write down the event that moves a return into each status and keep the list short.
Sharing one client tracker across preparers
Several preparers can keep one client tracker accurate if each row has one owner, each column has one source, and edits happen in a shared copy rather than in emailed versions. The tracker is a shared record, so the rules about who changes what matter more than the tool it lives in.
Assign rows, not columns. The preparer who owns a client updates that client's status and contact date. The reviewer updates the row only when moving a return through review. An admin fills Engagement and Due date at intake. With these rules, two people rarely need to edit the same cell.
Keep one copy. A tracker saved as "tracker_final_v3_JC.xlsx" on someone's laptop is a fork, and forks disagree within a day. Use a shared file or a shared system with one link.
Give each preparer a filtered view. A preparer with forty clients does not need to scroll past two hundred rows. Filters or saved views by Preparer cut each person's work to the rows they own and reduce accidental edits to other people's clients.
Review it together once a week. A fifteen-minute pass, sorted by Missing and then by days since last contact, catches rows that have gone quiet. The tracker's counts also feed planning: once you know how many returns sit in each status and who owns them, you can compare that load with available staff hours, which the post on accounting firm capacity planning works through with a sample table.
When a preparer leaves mid-season
A shared tracker earns its keep when someone leaves in February. With owners, statuses and document counts on every row, the reassignment is a filter and a find-and-replace on the Preparer column. Without them, it is a week of reconstructing where each return stands from email.