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 — the kind we walk through in a real £16,000 commission error and how to audit your own numbers. 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:
- Give every rep a statement every period. List each deal, its value, the rate and tier applied, and the arithmetic. If a rep can check the official calculation in two minutes, they won't maintain their own.
- Show it before payroll, not after. A short review window lets reps flag a missing deal before it becomes a correction on a later payslip.
- Explain every adjustment. Clawbacks, splits and manual changes need a reason attached, visible to the rep. This is also why a clear sales commission agreement that sets out what to include and when matters — reps can't trust an adjustment against terms they've never seen written down.
- Keep an audit trail. When a number changes, record who changed it, when and why.
- Fix errors visibly. When a rep finds a real mistake, correct it quickly and fix the cause for everyone. That's how the next rep learns the official number can be trusted.
For the errors that start this cycle, see our guide to commission calculation errors, or our deep dive on auditing a commission error nobody noticed.
Shadow accounting also tends to disappear once reps can see exactly how commission data should flow from a HubSpot deal to a Xero payslip, rather than guessing at what happens between the CRM and payroll. And disputes over when commission is actually earned are common too — see our guide on whether commission on sales should be paid before or after VAT for how to settle that question in the scheme itself.
Ready to fix your commission process?
Run your own comp plan in Commit, from HubSpot to Xero payroll. 14-day free trial, no credit card.