How to Track Missing Client Documents

To track missing client documents, keep one expected-items list per client, built from what came in last year, and give every line a status: received, missing or duplicate. Tick a line only when the document itself is matched by type, issuer and period, not when a file arrives. The missing lines become the client's outstanding list.

What belongs on a client's expected-documents list?

A client's expected-documents list is the set of individual documents the firm needs before work on the engagement can start. Each line names one document from one issuer for one period. "Bank statements" is not a line. "Harbor Federal checking, December statement" is.

The best starting point is the documents the client sent last year. A W-2 from an employer, a 1099-INT from a bank, a 1098 from a mortgage servicer and a K-1 from a partnership each tend to come back year after year. The post on using the prior-year return as a checklist walks through building the list from last year's return line by line, so this section covers how detailed each line should be.

A useful line carries five fields:

• Document type, such as W-2, 1099-DIV or credit card statement.
• Issuer, the employer, bank, broker or vendor that produces it.
• Period, a tax year for forms and a month or quarter for statements.
• Status, which the next section covers.
• Date received, filled in when the line is matched.

The issuer field does most of the work. A client with two brokerage accounts needs two 1099-B lines, because one arriving tells you nothing about the other. Without an issuer on the line, the first consolidated 1099 to arrive would tick off both, and the second account would be missed until someone noticed income was low.

Some expected items are not forms at all. A bookkeeping engagement may need twelve monthly statements for each account, and a gap in the run is as much a missing document as an absent W-2. List each month as its own line when statements matter, so a missing March shows up as one line instead of a vague sense that the folder looks thin.

New items appear during the year. A client who changed jobs, opened an account or sold a rental property will owe documents last year's list does not contain. Ask about life changes when the list is sent, and add lines as answers come back.

The received, missing and duplicate status for each document

A tracker needs three statuses for each expected line: missing, received and duplicate. Missing is the starting state for every line. Received means a document matching the line's type, issuer and period has been read. Duplicate means a second copy of an already-received document arrived and should not be counted again.

Missing is the default for a reason. A list where lines start blank invites the question "has anyone checked this?" A list where every line starts as missing can only change when something specific happens, so a quick glance shows what the firm is still waiting for.

Received should be set by a match, not by an upload. The next section covers how to match a document to a line. Until that match happens, an uploaded file is just a file.

Duplicate is the status most trackers leave out, and its absence causes real errors. Clients forward the same email twice, upload a phone photo and then the PDF, or send a corrected form without saying so. If a second W-2 from the same employer for the same year is counted as a new document, wages can be entered twice. A duplicate status keeps the second copy visible and linked to the first, without letting it change totals.

A corrected document is not a duplicate. A W-2c or a 1099 with the CORRECTED box checked replaces the original's figures. Treat it as a received document that supersedes the earlier one, and note which copy is now the source.

Two optional statuses help some firms. "Not applicable this year" closes a line the client no longer needs, such as a 1098 after a mortgage was paid off, with a note saying why. "Requested" records that a reminder went out, which helps when deciding whether to follow up again.

Matching an incoming upload to an expected document line

Matching means pairing a document with one expected line by its type, issuer and period. The file name is not evidence. "scan_0007.pdf" could be anything, and "W2.pdf" could be last year's W-2 or a spouse's. Open the document, read what it is and who issued it, then tick the line it satisfies.

Type comes first. A page labelled Form 1099-DIV matches a 1099-DIV line and nothing else. Issuer comes second: the payer name and payer TIN on a form, or the bank name and last four digits of an account on a statement. Period comes last: the tax year printed on the form, or the statement period at the top of a statement.

Multi-page files need special care. One PDF from a client can hold several documents, such as a consolidated brokerage 1099 followed by a W-2 and two bank statements. Each document inside it matches its own line. The tracking mistake this causes is common enough to get its own section below.

Near-misses deserve a note rather than a tick. A December statement for the wrong account, last year's 1098, or a W-2 for the client's spouse are all real documents that do not satisfy the line in front of you. Record them so the client can be told what they sent, and leave the line missing.

Matching by hand is where tracking takes the most time, and it is the step software can do. Schema CPA classifies every page by document type, issuer and period, checks it against last year's documents, and flags duplicates instead of double-counting them. The workflow section of the homepage shows each step.

How often should the missing-documents report be reviewed?

A missing-documents report lists every client with at least one line still marked missing. During tax season most firms review it weekly, with one person responsible for each client's list. Outside the season, a review when an engagement starts and again before it is due is usually enough.

Weekly works because documents arrive in waves. Employers and payers send most year-end forms in late January. The IRS Instructions for Forms 1099-MISC and 1099-NEC, for example, say payers must furnish both forms to recipients by January 31 of the year after the tax year. A review in the first week of February 2027 catches the tax year 2026 forms that should have arrived and did not.

Review against an owner, not a group. A report that "the team" reviews tends to be skimmed. When each client has a named preparer who owns its list, the weekly review becomes a short pass through that person's clients, sorted by how many lines are missing and how close the deadline is.

The report should show more than counts. "Four items missing" prompts a question; "Ridgeline Brokerage 1099-B, Harbor Federal December statement, two K-1s" prompts an action. Sort each client's missing lines by issuer type, because brokerage and partnership documents tend to arrive later than wage and bank forms.

Watch for clients whose lists do not move. A client with the same six missing lines for three weeks needs a different kind of contact than a reminder email. The post on whether to use a missing document tracker spreadsheet or software compares how each approach handles a report like this as the client count grows.

Tracking mistake: marking a client complete before every page is read

The most expensive tracking mistake is marking a client complete because files arrived, before every page was read. A received file is not a received document. One 40-page PDF can hold six forms, and if the tracker ticks one line for the whole file, the other five documents are either missed or never matched to their lines.

This happens because uploads look like progress. A client sends a large PDF with a note saying "everything is here." Someone ticks the expected items they assume are inside. Weeks later, a preparer opening the return finds no 1099-INT from the second bank, because the PDF held the first bank's form twice.

The fix is a rule: a line moves to received only when a person or software has read the page that satisfies it. For a large file, that means splitting it into its documents first, then matching each one. It takes longer per file and saves the search later.

A second version of the mistake is closing a client when the count looks right. Eight expected items and eight documents received sounds complete. It is not complete if two of the eight are duplicates and two expected lines are still empty. Count matched lines, not files or pages.

A third version is trusting the client's list over the firm's. Clients often send what they remember. The expected-items list exists because last year's documents are a better guide than memory. When a client says they sent everything, compare against the list before agreeing.

Turning the tracker into the client's outstanding list

The client's outstanding list is the tracker's missing lines rewritten for the client to act on. Each line becomes a specific request: the document, the issuer and the period. The client does not need the statuses or the received items, only what is still owed and where it usually comes from.

Generating the list straight from the tracker keeps it accurate. If the request is typed separately, it drifts from the tracker within a week. When the outstanding list is the missing lines and nothing else, a client who sends one document gets a shorter list next time, which shows progress.

How to word the list so clients act on it, including which details to include for each item, has its own post. Read how to tell a client what is still missing for the wording, and the client document collection category for how documents reach the firm in the first place.

A worked tracker for one client

This example tracks one fictional individual client with a Form 1040 engagement. All names, issuers and dates are made up for the example. The return is for tax year 2026, so every date received falls in 2027.

Five of eight lines are matched, but only four distinct documents are in: the second 1099-INT is a forwarded copy of the first, kept visible and not counted. Three lines are missing. The outstanding list sent to this client has three items: the Fieldwork Collective W-2, the Ridgeline 1099-DIV and the Canopy Partners K-1.

Schema CPA keeps this view for every client and drafts the reminder from the missing lines. The firm reviews the draft before it is sent; the client tracker demo shows one in action.