The Reasonable Compensation Workpaper Index
Most firms can produce a reasonable compensation figure. Fewer can produce the file behind it on demand, three years later, after the preparer who built it has left and the client has changed bookkeepers twice. The figure is the easy part. The file is the part nobody plans, and it is the part that gets assembled under pressure when someone finally asks for it.
This page is an index of that file: the ten items a complete reasonable compensation workpaper contains, in the order they belong, with a note on where the evidence for each line actually comes from. That third column is the one worth reading. Every item on the list has a source, and knowing which source feeds which line is what turns a pile of documents into a workpaper someone else can follow.
The fourth column is the honest one. For each item, it names the gap that shows up most often in files that already exist. Not hypothetical failures. The ordinary ones, the kind that come from a busy March rather than from carelessness.
What belongs in a reasonable compensation workpaper file?
Key Takeaways
Ten items, in order
Scope, profile and duties, time and effort, business economics, compensation history, comparability basis, wage evidence, adjustments, the signed conclusion, and retention.Every line names its source
A workpaper item without a stated origin is an assertion. The source column is what lets a second reader check the first reader's work instead of trusting it.Client-answerable and preparer-only facts are different things
A shareholder can describe their duties and their hours. A shareholder cannot apportion their own gross receipts among effort and capital. Mixing the two produces guesses on the record.Prior-year figures are a file item, not a nicety
Without last year's wages and distributions there is no change analysis, and the current-year number sits alone with nothing to compare it against.Judgment belongs on the record, not inside a formula
Every adjustment carries a prior value, a new value, a reason, a date, and a name. An adjustment applied silently inside a spreadsheet cell is invisible to the next reader.The Firm's own licensed professional concludes and signs
The conclusion is a professional act, and the signature identifies who performed it. No software performs it.
The index
| Feature | Why it is in the file | Where the evidence comes from | Common gap |
|---|---|---|---|
| 1. Engagement scope and who concluded | Fixes the entity, the tax year, the shareholder-employee at issue, and the professional responsible for the conclusion | Engagement letter, the firm's return file, the preparer and reviewer assignment for the engagement | Scope written for the return generally, never naming the compensation determination as work performed or naming who is responsible for it |
| 2. Shareholder-employee profile and duties | The standard turns on what the person actually does, not what the entity calls them | Shareholder interview or client organizer responses, licenses and credentials, any written job description | A job title standing in for a duty list. "Owner" and "President" price nothing |
| 3. Time and effort record | Hours worked and how those hours split between revenue-producing work and management price separately | Shareholder's own answers: hours per week, weeks per year, share of time on direct services versus management and administration | An annual hour total with no split, and no note on how the number was arrived at |
| 4. Business economics and receipts attribution | Allocates gross receipts among shareholder effort, non-shareholder employee effort, and capital | The books, the return, the payroll register, and the preparer's own attribution work | Attribution percentages recorded with no note on the basis, or the client asked to supply them |
| 5. Compensation and distribution history, current and prior year | Establishes what was actually paid, in what form, and how the amount was set | W-2s and payroll registers, the K-1 and the distributions account, shareholder loan activity, employment agreement or minutes where they exist | Current year only. No prior-year rows, so no change analysis and no explanation for a year-over-year move |
| 6. Comparability basis: industry, geography, size, comparable roles | Defines the population the wage evidence is drawn from | Preparer's characterization from the books, plus the shareholder's description of scope, locations, headcount, and complexity | "Industry" recorded as a bare code and "geography" as a state, when the work is priced by occupation and by local market |
| 7. Wage evidence relied on, with source, occupation, geography, and period | The outside anchor for the figure. Somebody else's data, not the firm's opinion | Published wage data, recorded on the line with the source name, the occupation matched to, the geography, the period covered, and the date the figure was pulled | A figure with no as-of date, and sources listed at the back of the file rather than attached to the figure they support |
| 8. Adjustments made and the documented rationale for each | Judgment enters here, and this is the only place it is visible | The preparer's own adjustment note: prior value, new value, reason, date, and who made the change | Adjustments applied inside a spreadsheet formula, so the number moved and nothing in the file says why |
| 9. The conclusion and who signed it | The concluded figure and the identity of the licensed professional who reached it | The Firm's own reviewer sign-off record against the assembled file | Nobody signed. Approval lives in an email thread, a hallway conversation, or an implied acceptance because the return was filed |
| 10. Retention: what the Firm keeps and for how long | The file has to be retrievable years later by someone who did not build it | The firm's document retention policy and the location the finished workpaper is filed to | The finished file lives only in a vendor system the firm loses access to on lapse or cancellation |
The gaps, in practice
The gap column is short by necessity. Here is what each one actually looks like when you open the file.
Scope and standing (item 1)
The engagement letter covers the return. The compensation determination is work performed inside that engagement, and often nothing anywhere names it. Two consequences follow. First, no document establishes that the determination was in scope, which matters if a client later disputes that they were charged for it. Second, when the file names no responsible professional, the question of who concluded gets answered by inference from who signed the return. Inference is a poor substitute for a name on a workpaper.
Fix: one line at the top of the file naming the entity, the tax year, the shareholder-employee, the preparer, and the reviewer.
The facts about the person (items 2 and 3)
Titles compress and duties do not. A shareholder who calls herself the owner may spend a third of her week on licensed professional work, a third selling, and a third on administration a coordinator could handle at a fraction of the rate. Those three components price separately, and a file that records only "Owner" has thrown away the information that makes the figure explainable.
The time record fails the same way. An annual total of 2,400 hours is a number without a shape. Whether those hours went to billable professional work or to running the office changes the answer materially, and the split is the thing a reader will ask for first. It is also a fact the shareholder can supply directly. There is no reason for it to be missing.
The second failure here is quieter: no note on how the hours were arrived at. A shareholder's honest estimate and a figure derived from a time-tracking system are both usable. They are not equally strong, and the file should say which one it holds.
The facts about the business (items 4 and 5)
Receipts attribution is the line most likely to be filled in by the wrong person. Splitting gross receipts among the shareholder's personal effort, the effort of non-shareholder employees, and the capital deployed in the business is preparer work. It comes out of the books, the payroll register, and the return. When a client organizer asks the business owner for those percentages, the file receives a guess dressed as a fact, and it is recorded with the same weight as a figure pulled from the general ledger.
This is why an intake that separates client-answerable questions from preparer-only work is worth the extra page. A shareholder can tell you what they do and how long it takes. They cannot apportion their own receipts, and asking them to try makes the file worse rather than better.
Compensation and distribution history fails differently. Most files hold the current year and stop. Without the prior year there is nothing to compare against, so a wage that moved from 60,000 to 95,000 sits in the file with no accompanying explanation of what changed. The prior-year rows are cheap to collect and they carry the entire change analysis. Collect them.
The comparison basis (items 6 and 7)
Comparability is where files quietly get thin. "Industry" recorded as a single classification code and "geography" recorded as a state are both technically populated fields and neither is a real comparability basis. The work is priced by occupation and by local market. A file that records the occupation actually performed, the metropolitan area, the headcount, the number of locations, and anything unusual about how the business runs is describing a population. A file with a code and a state is describing a filing cabinet.
The wage evidence line has its own recurring problem, and it is about placement rather than substance. Firms usually have the data. What they often lack is the as-of date and the attachment of the source to the specific figure it supports. Wage data gets revised. A figure pulled last spring may not match what the same publisher shows now, which is a real problem when the support for a filed return has drifted underneath it. Record the source, the occupation matched to, the geography, the period covered, and the date the figure was pulled, on the line with the figure. A source list at the back of the file does not tell a reader which number came from where.
Judgment on the record (items 8 and 9)
Adjustments are the most valuable lines in the file and the most frequently invisible. A preparer looks at a wage figure, concludes it overstates this particular shareholder's role for a stated reason, and moves it. That reasoning is exactly what a second reader wants. When the move happens inside a spreadsheet formula, the reasoning evaporates and the file shows only the result.
An adjustment on the record carries five things: the prior value, the new value, the reason, the date, and who made the change. This is the source-citation habit TracePrep records automatically as a preparer works, but the discipline predates any software and works fine in a memo. What matters is that nothing in the file moves without a reason attached to it.
The conclusion is a professional act. The Firm's own licensed professional reaches it and signs it, and the signature is what identifies who performed the act. Files without a signature usually have an approval somewhere, in an email or a conversation, but an approval that is not in the file is not in the file. A sign-off record against the assembled workpaper, dated, is the whole requirement.
Retention, and who owns the file
The last item on the index is the one most often left to chance.
Decide two things and write them down. What the Firm keeps: the assembled workpaper, the intake responses, the wage evidence as pulled, the adjustment record, and the signed conclusion, as a single retrievable file rather than as pieces scattered across a practice management system, a shared drive, and someone's inbox. And how long: your firm's document retention policy already sets a period for tax engagement workpapers, and this file belongs under it rather than under a separate rule you invent for it. Where firms commonly land is a retention period at least as long as the assessment window that applies to the return the file supports, extended for the years the client stays.
Then a question about ownership that is easy to miss until it matters. If the finished workpaper lives in an outside system, find out what happens to it when the subscription lapses or the firm switches tools. A workpaper the firm cannot retrieve is not retained, regardless of what the policy says. Finished workpapers should remain the Firm's property, exportable and readable without the software that produced them, whether that file was assembled in a system or by hand.
The test to apply to a finished file is simple. Hand it to a colleague who has never met the client. If they can follow the reasoning from duties to hours to comparability to wage evidence to the concluded figure without asking you a question, the file is complete. If they have to ask you anything, the answer they needed belongs in the file.
A note on how to use this. This index is a starting point for building your own workpaper standard, not advice about your engagements. It describes what a complete file contains. It does not establish that a file assembled this way is sufficient for any particular purpose, and no page can make that determination for your facts. Your firm's own counsel and professional-liability carrier should review any workpaper standard before you adopt it.
TracePrep is a software product from TracePrep Inc., not a CPA firm. This content is operator experience for educational purposes; it is not tax advice and has not been reviewed by a licensed CPA. Consult a qualified tax professional for guidance on your specific situation. Source citations in TracePrep workpapers support audit defense but do not guarantee IRS outcomes.
Read the index. Then build a file that matches it.
Open an engagement and work a real client, or read the six steps first.