If you've ever had a sales rep come to you at the end of the month with a number that doesn't match yours — you've experienced shadow accounting.
Most founders treat it as an ops problem. The spreadsheet is wrong. The formula is off. Someone miscounted a deal.
So they fix the formula and move on.
The number gets corrected. The behavior doesn't change. Next month, the rep has a new spreadsheet.
Shadow accounting isn't a math problem. It's a signal. And if you're not reading it correctly, you'll keep solving for the wrong thing.
Shadow accounting is what happens when a sales rep stops trusting the company's commission calculation and starts keeping their own.
They're not doing it to be difficult. They're doing it because they don't know if they'll be paid correctly — and the money is theirs. So they track it themselves. A personal spreadsheet, usually. Updated after every deal closes. Cross-referenced against the CRM. Sometimes checked against payroll line by line.
Some reps do this quietly. Others bring it up. Most do it for longer than you'd expect before anyone notices.
And here's the thing: the rep is usually right to do it.
Not because the company is being dishonest — but because most early-stage commission plans are genuinely hard to calculate. The logic is buried in a document nobody can find. The rules for edge cases were decided in a Slack thread eight months ago. Two people on the team would calculate the same deal differently if you asked them separately.
When the plan is unclear, the rep has no choice but to verify. Shadow accounting is a rational response to an unreliable system.
Here's what's actually happening when a rep builds a shadow spreadsheet:
They don't trust that the plan is clear enough to be calculated consistently. Or they don't trust that it will be applied the same way every time. Or they've been surprised before — a clawback they didn't see coming, a deal that got reclassified after close, a bonus that paid out differently than expected — and they're not going to let it happen again.
Each of those is a design failure, not a character flaw.
A commission plan that a rep needs to verify isn't a plan they trust. And a rep who doesn't trust their comp plan is spending mental energy on something other than selling.
That matters more than it sounds. Every hour a rep spends reconciling their shadow spreadsheet against your CRM is an hour they're not spending in front of a prospect. Every conversation that starts with "I think I was underpaid last month" is a conversation that costs time, goodwill, and focus on both sides.
The cost of a confusing comp plan isn't just administrative. It shows up in the sales motion.
The standard I use with every commission plan I build: your rep should be able to calculate their own commission on a napkin.
Not with a spreadsheet. Not with a calculator. A napkin.
If they can't — the plan is too complex for the stage you're at.
That doesn't mean it needs to be simplistic. It means the logic needs to be transparent enough that the rep always knows where they stand. They should be able to look at their pipeline on any given Tuesday and know, within a reasonable margin, what they'll earn if X deals close this month.
That transparency does three things:
1. It removes the incentive to shadow account, because the rep can verify the math themselves in two minutes.
2. It changes the selling behavior, because reps who can see their earnings in real time make different decisions about where to spend their time.
3. And it builds trust in the relationship — which is harder to rebuild once it's been broken than most founders expect.
Most commission plans are clear enough for the standard deal. It's the edge cases that create shadow accounting.
What happens when a deal closes in the last hour of the month? What if a customer churns 45 days after close — is there a clawback? What if two reps both touched the deal — how is it split? What if the customer negotiated a discount below floor — does the rep still earn full commission?
These questions come up. Every time. And if the answers aren't written down somewhere everyone can find them, each one becomes a negotiation.
And negotiations about money, after the fact, feel like being cheated — even when they're not.
The fix isn't to anticipate every possible scenario in the original plan document. It's to establish a clear decision-making process: here's how edge cases get resolved, here's who decides, here's the timeline for resolution, and here's how it gets communicated.
That process, more than any formula, is what earns trust.
Don't make it about the spreadsheet.
The spreadsheet is a symptom. The question to ask is: what made them feel like they needed it?
Start there. Audit the plan for clarity. Find the edge cases that aren't documented. Ask the rep directly what they're not sure about. Then fix the plan — not to close the loop on a conversation, but because a rep who trusts their comp plan sells differently than one who doesn't.
Shadow accounting tells you something important about the health of your commission system. The founders who read that signal correctly fix it once and don't see it again.
The ones who fix the spreadsheet see a new one next month.
Photo by Money Knack on Unsplash