Shadow Accounting: Why Reps Track Their Own Commission (Fix It)

Shadow accounting is when sales reps maintain their own commission spreadsheet because they don't trust the official numbers. It emerges when reps experience unexplained discrepancies, discover calculation errors, or inherit warnings from colleagues who were underpaid. While it costs roughly 30 minutes per week per rep in direct time, the real cost is eroded trust, mental overhead, and adversarial dynamics between reps and finance. The fix requires three changes: eliminating the opacity that makes verification feel necessary, providing real-time visibility into accruing commissions, and making calculation logic transparent so reps can trace any number back to its source.

Published 7 January 2026

There's a spreadsheet your reps haven't told you about.

It lives on their laptop, maybe in a personal Google Drive. It lists every deal they've closed this quarter, their expected commission on each, and a running total of what they believe they're owed. Every time they close a deal, they add a row. Every time a commission statement arrives, they compare it against their own numbers.

This is shadow accounting. And if you manage a sales team that runs commissions through spreadsheets, there's a good chance most of your reps are doing it.

Shadow accounting isn't laziness or paranoia. It's rational behaviour in an environment where trust is uncertain. Reps who've been underpaid once — or who've heard stories from colleagues who were — protect themselves the only way they can: by keeping their own records.

The problem is what shadow accounting costs. Not just the time reps spend maintaining it, but what it reveals about the relationship between your team and their compensation.

Why Reps Start Shadow Accounting

Nobody begins a sales job planning to track their own commissions. Shadow accounting emerges gradually, usually triggered by one of a few experiences.

The unexplained discrepancy. A rep closes a deal, expects a certain commission, and receives something different. They ask why. The explanation is vague, or delayed, or involves tracing through formulas they can't see. Even if the official number turns out to be correct, the experience teaches them something: the numbers aren't self-evident. They need to be verified.

The discovered error. Worse than a discrepancy is finding an actual mistake. A deal that wasn't included. A rate that was applied incorrectly. A clawback that shouldn't have happened. These are the types of commission calculation errors that destroy trust. Once a rep discovers that the official process can be wrong, they stop assuming it's right.

The inherited warning. Sales teams talk. A rep who was underpaid tells their colleagues, and a cautionary tale circulates. New starters hear it in their first week, and they start tracking their own numbers before anything has ever gone wrong for them.

What Shadow Accounting Costs You

The obvious cost is time: hours each month that reps spend rebuilding a calculation someone else is already doing. The larger cost is what the spreadsheets are used for. Every discrepancy between a rep's version and the official one becomes a query, and every query is a small dispute that sales leaders and finance have to resolve by hand. It also tells you something about the team: they don't believe the official number until they've checked it themselves.

How to Make Shadow Spreadsheets Unnecessary

You can't ban shadow accounting, and you shouldn't try. The way to end it is to make it pointless:

For the errors that start this cycle, see our guide to commission calculation errors.