A missing document tracker can live in a spreadsheet or in dedicated software. A spreadsheet costs nothing and works for a few dozen simple clients if one person keeps it current. Software earns its cost when several preparers share the list, clients send multi-form files, or typing each arrival in by hand falls days behind.
The columns a missing document tracker spreadsheet needs
A missing document tracker spreadsheet needs one row per expected document, not one row per client. The minimum columns are client, document type, issuer, account or reference, period, status, date received, owner and a note. Anything less and a row cannot say exactly which document is still outstanding or who is chasing it.
Each column has a job:
- Client. The household or business name, spelled the same way on every row so a filter catches all of them.
- Document type. W-2, 1099-INT, 1098, K-1, bank statement. One type per row.
- Issuer. The employer, bank, broker or partnership that produces the document.
- Account or reference. The last four digits of an account, so two accounts at one bank stay on separate rows.
- Period. The tax year for a form, the month for a statement.
- Status. A short fixed list of values. The status model in the post on tracking missing client documents explains why missing, received and duplicate are the three that matter.
- Date received. Blank until the document itself is matched to the row.
- Owner. The preparer responsible for chasing the row.
- Note. Why a row was closed, or what the client said about it.
Lock the status column to its allowed values. Microsoft's guide to applying data validation to cells in Excel describes restricting a cell to a drop-down list, which stops one person typing "rcvd" and another typing "in". A filter on that column then gives a clean count of what is still missing.
The rows themselves come from last year. The post on using the prior year return as a checklist covers turning a filed return into expected rows with an issuer on each one.
A column list to copy
Example values below are fictional; the period is tax year 2026, so the date received is in 2027. Paste the header row into a new sheet and add one row per expected document.
Client | Document type | Issuer | Account | Period | Status | Date received | Owner | Note
Avery Household | 1099-INT | Harbor Federal Credit Union | XXXX-4821 | 2026 | Missing | | J. Ortiz |
Avery Household | W-2 | Northgate Media Group | | 2026 | Received | Feb 3 | J. Ortiz |
Avery Household | 1098 | Example Mortgage Servicing | XXXX-1190 | 2026 | Not applicable | | J. Ortiz | Loan paid off in June; client confirmed
Where does a spreadsheet tracker break during tax season?
A spreadsheet tracker breaks in tax season at three points: entry lag, shared editing and multi-form files. Every arrival has to be opened, identified and typed in by a person, so the sheet is only as current as the last time someone caught up. When arrivals spike, that lag grows from hours to days.
Entry lag. A spreadsheet has no idea a document arrived. Someone has to open the email or upload, read the form, find the right row and change its status. In a quiet week that takes minutes. In the weeks after year-end forms go out, the backlog builds, and a reminder sent from a stale sheet asks a client for a W-2 they sent four days ago. That reminder costs goodwill.
Several preparers editing. Microsoft's page on co-authoring Excel workbooks says simultaneous editing needs the file stored in OneDrive, OneDrive for Business or SharePoint Online, with AutoSave on. A firm that keeps its tracker on a local file server, or emails copies around, ends up with versions that disagree. Even with co-authoring working, two people can sort the same sheet differently or overwrite each other's note.
Files that hold several forms. A client sends one 30-page PDF with a consolidated brokerage statement, two W-2s and a 1098 inside. The spreadsheet has four rows those documents should satisfy, and nothing connects the file to them. The person entering it has to page through the whole PDF. If they tick rows based on the email ("sent everything"), the sheet is wrong from that moment.
No memory of last year. A spreadsheet only knows the rows someone typed. Building next year's sheet means copying rows forward and hoping the copy is complete.
Silent formula and filter mistakes. A sorted range that excludes one column, or a filter left on, can hide rows. Nobody sees an error message. The sheet just looks shorter than it should.
What does dedicated missing-document software do differently?
Dedicated missing-document software sets each row's status by reading the document that arrived, not by waiting for a person to type it. It starts from a prior-year checklist, matches each page to an expected row by type, issuer and period, flags second copies, and turns the rows still open into a reminder the firm can send.
The difference shows up in four places:
- Reading the file sets status. A page that is a Form 1099-INT from Harbor Federal for 2026 ticks that row. A 30-page PDF is split into its documents, and each one is matched separately.
- The checklist starts from last year. Instead of copying rows forward by hand, the expected list comes from what the client sent last year, with each issuer already named.
- Duplicates are caught. A W-2 scanned twice or an email forwarded twice is marked as a duplicate rather than ticking a second row or inflating a total.
- The reminder draft comes from the open rows. The client's outstanding list is the missing rows, so it is never out of step with the tracker.
Schema CPA works this way: one upload link per client, every page classified by document type, issuer and period, last year's return as the checklist, and a reminder draft the firm reviews and sends itself. The client tracker demo shows received, missing and duplicate rows for sample clients.
Software still needs people. It cannot know about a job the client started in October or an account opened in March, because nothing from last year points to them. The post on a new income source not on last year's return covers the questions that catch those, whichever tracker you use.
Spreadsheet versus software tracker, side by side
A spreadsheet versus software comparison comes down to six criteria: cost, setup time, upkeep per client, how status gets set, how many people can edit, and where errors creep in. A spreadsheet wins on cost and setup. Software wins on upkeep and accuracy once volume and staff grow.
The table below compares a typical shared spreadsheet with a typical document-reading tracker. The figures are descriptions, not measured benchmarks.
| Criterion | Spreadsheet tracker | Software tracker |
|---|---|---|
| Cost | Included in office software the firm already pays for | A monthly subscription, or a free tier with limits |
| Setup time | An afternoon to build the columns and validation | Connecting last year's documents and sending upload links |
| Upkeep per client | Every arrival opened, read and typed in by hand | Arrivals read and matched; a person reviews exceptions |
| How status is set | A person changes a cell | Reading the document matches it to a row |
| Several preparers | Works with co-authoring set up; conflicts otherwise | Built for several users on one client list |
| Error points | Entry lag, multi-form files, copied-forward rows, hidden filters | New items last year cannot predict; misread pages a person must correct |
Cost deserves an honest look. A spreadsheet is not free once staff time is counted, because each arrival takes a few minutes to log. The hours calculator on the homepage lets a firm put its own numbers on that: clients, documents per client, minutes per document and staff cost. Schema CPA's plans are priced per firm rather than per client, starting with a Free plan for up to 3 clients; the pricing section lists each plan.
Setup is where software asks more up front. Someone has to load last year's documents and tell clients about their upload link. After that, the per-client work drops to reviewing what the tool flagged.
Error points differ in kind. A spreadsheet's errors come from people falling behind or misreading a file. A software tracker's errors come from what it cannot know, such as a new account, and from pages it reads wrongly that a person has to correct. Neither removes the need for a final review before a return is opened.
When not to buy a missing document tracker
A firm does not need to buy a missing document tracker when one preparer handles a small, stable client list with few documents each. Under those conditions a well-built spreadsheet stays current, nobody edits it at the same time, and the person who logs a document is the same person who will prepare the return.
Signs a spreadsheet is enough:
- One person owns every client. No shared editing, no version conflicts.
- Clients send a handful of forms. A W-2, a 1099-INT and a 1098 are quick to log. Thirty monthly statements per client are not.
- Documents arrive one at a time. Separate files for separate forms map cleanly to rows.
- The client list barely changes. Rows copied forward from last year stay accurate.
- The firm is not doing monthly bookkeeping. Monthly statement runs multiply the rows fast.
Signs it is time to move:
- Reminders go out asking for documents the client already sent.
- Two preparers keep different copies of the tracker.
- Clients send large combined PDFs, and logging them takes longer than preparing the return.
- The firm adds bookkeeping clients whose statements need a row per month.
A middle path works for some firms: keep the spreadsheet for the expected list and status, and change how documents arrive. One intake address or one upload link per client makes logging faster even without software reading the files. The tax season workflow category covers the rest of a season's routine, from intake to review.
Making a spreadsheet last one more season
A firm that keeps its spreadsheet can remove the worst failure points with a few habits. Log arrivals the same day, even if preparing the return waits. Split combined PDFs into one file per document before logging, and name each file after the row it satisfies. Never tick a row from a client's email; tick it from the page. Freeze the header row and keep filters off when saving, so the next person sees every row. Once a week, filter the status column to missing and sort by owner, then compare the count with last week's. A count that does not fall is the first sign the sheet has stopped keeping up.
A worked decision for one firm
Example only. Brightwater Tax Partners, a fictional three-preparer firm, has 140 individual clients averaging nine expected documents each, so about 1,260 rows. In February its shared sheet ran three days behind, and two clients got reminders for forms they had already uploaded. At that size, with three editors and combined PDFs arriving daily, the firm's own checks pointed to software. A solo preparer down the street with 45 clients and four documents each, about 180 rows, kept the spreadsheet and added a status drop-down.