Shadow Accounting

Shadow accounting is when reps maintain their own commission spreadsheets alongside the official statement. Every deal, every split, and every rate gets re-entered by hand so the rep can check whether the payment is correct. The practice is a response to a statement that cannot be verified from the outside.

The behavior is rational

A rep whose variable pay is a large share of total earnings has a strong reason to audit it. When the official statement shows a single payout figure with no visible path back to the deals behind it, rebuilding the calculation privately is the only way to check it. The reps who invest the most effort are usually the strongest performers, because they carry the largest variable component and the most complex credit situations.

Plan complexity makes this worse without anyone intending it. Split credit, overlay participation, mid-year quota adjustments, and tiered rates each add a step that the rep cannot observe. A plan can be entirely fair and still be impossible to verify, and reps treat opacity the same way they treat unfairness.

The cost is selling time

Shadow accounting consumes hours that would otherwise go to pipeline. The time is invisible in most reporting because it never appears in the CRM, but it comes directly out of the same capacity the plan is trying to maximize. Hours spent reconciling a statement are hours not generating the pipeline coverage the next quarter depends on. Quantify it by asking the team how long reconciliation takes each cycle and multiplying by headcount, then compare that number against the quota those hours were supposed to produce.

The second cost is slower to appear. A rep who does not trust the statement stops treating plan mechanics as a reason to change behavior. Accelerators only shape effort when the rep believes the payout will arrive as described.

Fix it with traceability, not with policy

Telling reps to stop keeping spreadsheets does nothing, because the underlying reason to keep one is unchanged. The fix is a statement that answers every question the spreadsheet was built to answer. Show the deals credited in the period, the attainment those deals produced, the rate schedule applied at that attainment, and any adjustment carried in from a prior period, with each figure linked to the underlying record.

ORM's view of revenue analytics generally is that a number is only trustworthy when it points back to the source that produced it, and validating an opaque figure costs as much as building it yourself. Compensation is the sharpest case, because the audience checks every line. The same discipline that makes a sales forecast defensible in a board meeting makes a commission statement defensible on payday, and it retires the shadow spreadsheet without a policy.