If you sell through a team, you have a spreadsheet for commissions. We have never met a sales business that does not. It lives in a shared drive, in a tab that only one person really understands, or in the head of your operations manager, who is the only one who can open it without a little panic.
It worked when you had three reps and a simple plan: eight percent on closed deals, double it if they hit quota. You could do the math in a coffee break. But somewhere along the way, the plan got more complicated. You added tiers. You added accelerators. You added team splits, a manager override, a clawback for refunds, a spot bonus for a product launch, and a quarterly SPIFF that only applies to new logos. Now the spreadsheet has eleven tabs, three macros, a color-coding system only one person remembers, and a cell somewhere on tab six that you are not entirely sure is doing what it used to do.
And every month the same scene plays out. It is payout time, and suddenly five people are emailing you. One rep thinks a deal did not count. Another is asking why a refund got pulled from last month. A third has found a formula that is double-counting a split deal. You open the file, and it takes three hours to reconstruct how you got the number you are about to send. By the time you reply, two more questions have piled up.
This is the spreadsheet headache. It is not one problem. It is a lot of small problems that arrive together, all at once, right at the moment when your people are most stressed about how much they are going to be paid.
At Acherus, we build custom software for businesses that are outgrowing their tools, and commission tracking is one of the most common places that breakage shows up. In this post, we will walk through why spreadsheets fail, what that failure is actually costing you, what proper commission tracking software does differently, and how to choose something that fits where your business actually is.
Why Spreadsheets Start Strong and Then Fall Apart
There is no shame in the spreadsheet. For a small team with a simple plan, it is the right tool. It is flexible, it is cheap, and you can change the logic in a minute when the plan changes. That last part is exactly the problem.
A spreadsheet is a model of your commission plan that someone has to build and maintain by hand. The moment your plan is more complicated than a single line of math, the maintenance burden starts to grow. The file has to encode tiers, accelerators, split deals, refunds, clawbacks, different rates by product line, and every exception you have ever made. Each new rule is another formula, another named range, another place a copy-paste can go wrong.
Here is the thing about spreadsheets: they are extremely good at whatever you tell them to do, and extremely good at doing it wrong without telling you. If you reference the wrong cell, the whole downstream calculation is wrong, and there is no red light on the dashboard. It just produces a confident, plausible number. That is worse than an error that crashes, because nobody challenges a number that looks reasonable.
And the plan does not stay still. You adjust quotas, you re-tier an accelerator, you launch a new product with a different rate. Every change is a manual edit, and every manual edit is a chance to introduce a bug. Teams that run a comp audit find this is where most of the errors live: not in the original spreadsheet, but in the version three plan changes ago, where a formula was updated in one tab but not in the tab the actual payout pulls from.
Sales compensation is one of the largest line items in a modern operating budget. For many companies, especially in SaaS, it is somewhere between fifteen and twenty-five percent of revenue. That is a big number to be tracking in a file that one person can break.
What the Spreadsheet Actually Costs You
The cost of a commission spreadsheet is not a single line on a P&L. It is spread across several places, and most of it stays invisible until a rep walks into your office and tells you the number is wrong.
Time on the back office. Someone, usually in sales ops or finance, spends real hours every payout cycle reconciling the spreadsheet against the CRM, the accounting system, and the actual closed deals. They match deal by deal: which ones closed, which were refunded, which carry splits. For a team of ten to twenty reps on monthly payouts, that reconciliation is a full day or more of careful, unfun, error-prone work, and it happens every cycle.
Time on the reps. Salespeople do not just want to be paid correctly; they want to see their own numbers as they build. The spreadsheet does not give them that. So they estimate, doing their own side math, which is usually wrong, and they carry a background anxiety about whether the total will match what you actually pay. That is a lot of wasted brainpower for people whose job is to sell.
Disputes. This is where it gets expensive. A rep who is paid the wrong amount files a ticket. Now finance has to pull the spreadsheet, reconstruct the calculation, figure out which version of the plan was in effect, check whether a refund was properly clawed back, and send a correction. Disputes are slow, and while they are being resolved, the rep is working with one eye on a number they do not trust.
Trust and morale. This is the cost nobody puts in a spreadsheet. For a lot of salespeople, commission is the core of the deal they made with you. When the number comes out wrong, or when nobody can tell them in real time exactly how they got it, trust in the whole system drops, and research on commission disputes finds that damage is durable. A team that has been paid wrong once, or that cannot verify its own number, discounts everything leadership says about the plan. Trust is the hardest thing in sales to win back.
Turnover. When a high performer figures out the number is wrong and there is no clean way to prove it, the easiest answer is to take their skills somewhere with better systems. Replacing a top rep costs a multiple of their salary in recruiting, ramp time, and lost pipeline. A single bad payout cycle can trigger a resignation you only connect the dots on a quarter later.
Add it up and the “free” spreadsheet is rarely free. It is a labor cost, a trust cost, and a risk cost, all rolled into one file that looks like it is doing everything fine until it is not.
The Math, Run Honestly
Let us put numbers on it for a team you might actually have. Say you have fifteen reps, you run monthly payouts, and you have a two-tiered plan with one team split, a refund clawback, and a quarterly SPIFF. That is a normal, unremarkable comp plan for a growing sales team.
Reconciliation. Your ops person spends about three hours a cycle matching deals and producing the numbers. Over four payouts a quarter, that is roughly forty-eight hours a year. At a fully loaded cost of about thirty-five dollars an hour, that is around one thousand seven hundred dollars a year before anything goes wrong.
Disputes. Assume two payout disputes a month across the team, each taking an hour of ops time plus twenty minutes of yours. That is roughly sixty hours a year, or about two thousand one hundred dollars, on top of your own time at a higher rate.
Turnover. If the comp friction causes even one rep to leave a year, the fully loaded cost of backfilling and ramping that role can land between thirty and sixty thousand dollars. That one event alone can cover several years of a good software system.
There is also the quiet background tax of data entry and transcription. Commission tracking is a pure data-entry workflow: close a deal, type it in, check it, reconcile it, correct it, and start over. Industry studies put the cost of manual data entry and process work at millions of dollars per year for mid-sized organizations, and the software that removes the typing removes the largest share of that cost.
None of these numbers are dramatic on their own. But they are recurring, and they are all sitting in front of a tool that is free and therefore assumed to be worth nothing. When you are paying fifty thousand dollars a year in labor, disputes, and one turnover to run a spreadsheet, the “free” option is not free at all.
What Commission Tracking Software Actually Does
Good commission tracking software is not a fancier spreadsheet. It is a system that encodes the plan once, applies it consistently every cycle, and shows every person the number behind the number. Here is what that changes in practice.
The plan is data, not formulas. You set the plan in a clean structure: base rate, tiers, accelerator triggers, split rules, clawback logic, SPIFF windows. The system does the math. When you change the plan, you change one definition, and the change applies to every rep, every deal, and every cycle. There is no orphaned formula on a hidden tab.
Real-time visibility for the reps. This is the one that changes culture. Each rep sees, at any moment, how close they are to quota, what an accelerator would look like, and what a deal will earn them if it closes. No more side math, no more anxiety, no more “I think my number is wrong.” A rep can look at a pending deal and see, before they even close it, what it will do to their payout. That is a motivational engine a monthly spreadsheet can never replicate.
Automatic deal ingestion. The software pulls closed deals from your CRM instead of someone retyping them. Splits, refunds, and clawbacks are applied by rules, not by hand. When a refund lands, the system knows exactly which rep, which cycle, and how much to claw back, and it says so.
An audit trail. Every number has a reason. For any payout, you can open it and see the exact deals, the exact rates, and the exact rules that produced it. When a rep asks “why,” the answer is a screen, not a three-hour reconstruction. That audit trail kills disputes at the source, because most disputes are not really disputes; they are just people who could not see the work.
Accrual reporting for finance. The software can tell finance what commission liability looks like in real time, not just at payout. That matters for cash-flow planning and for the accrual you have to book every month. A spreadsheet gives you a number for the month that just ended. The software gives you a running, forward-looking picture.
Version control and change history. When you change the plan, the system knows exactly what changed, when, and which reps were affected. You can re-run a cycle under the old plan to see the difference, or prove a correction. A spreadsheet only does that if you saved a copy of the old file and remembered to label it.
The Signs You Have Outgrown the Spreadsheet
You do not need a consultant to tell you it is time. You already know. Here are the signals, in the order they usually appear.
More than one person needs to understand the file. The moment a second person has to read it, and they cannot, the spreadsheet has quietly become a single point of failure.
The plan has a tier, an accelerator, a split, or an exception. If your comp plan has more than one rule that varies by condition, you are past the point where a single formula is reliable.
You are editing the file to fix a number. If you have ever opened the spreadsheet, seen a total that looked wrong, and nudged a cell to make it work, you have a process problem, not a math problem.
You cannot answer “why” quickly. If a rep asks why a number is what it is and you have to go rebuild the calculation, the visibility the team needs is not there.
Reconciliation takes a day. If matching the spreadsheet to the CRM and to accounting is a multi-hour manual effort every cycle, that is your automation opportunity, spelled out.
You have a rep who keeps guessing. If your top performer has their own private way of estimating their commission because the official one is opaque, the system is costing you their trust right now.
If you have checked three or more of those boxes, the spreadsheet is no longer a tool. It is a liability wearing a tool’s clothes.
Off-the-Shelf or Custom: The Real Decision
When you are ready to move off the spreadsheet, you face a choice, and it matters more than people expect.
Off-the-shelf commission platforms are a real option, and for a lot of businesses they are the right one. They are fast to deploy, priced per user, and they will handle a standard tiered plan with splits and accelerators without a problem. If your plan is standard, your team is a reasonable size, and you want to be running in days, a good off-the-shelf tool will serve you well and save you a lot of time versus the spreadsheet.
The place where off-the-shelf starts to strain is where your business is not standard. Maybe your commission is tied to product mix and margin, not just revenue. Maybe you have a partnership channel that earns a different structure than your direct reps. Maybe your sales comp is deeply integrated with a custom billing system, a specific CRM you already own, or a regional rule that no generic tool models. At that point, you are paying for a whole platform to use a tenth of it, and the other nine tenths are features you do not need that you are still maintaining.
This is where custom software earns its keep, and it is where we sit. A custom commission system is built around your actual plan and your actual stack. It pulls from the CRM and billing system you already run, it models the exact rules you use, and it gives your team and your reps a single, clean view of the numbers. Over time it is usually cheaper than juggling a platform subscription plus the manual workarounds, and it fits instead of forcing you to fit it.
The honest version of the decision is this: start by figuring out how standard your plan is. If it is standard, a good off-the-shelf tool is the faster, cheaper win. If it is anything unusual, or if your team is large enough that the per-user pricing adds up, a custom build usually comes out ahead the second year and is more comfortable the whole way. Either way, the spreadsheet is the option you are leaving.
How Acherus Approaches It
When a business comes to us about commission tracking, we start by reading the plan, not by showing them a demo. We want to understand your tiers, your splits, your clawbacks, your SPIFFs, and how you actually pay people today. Then we look at where the data lives: your CRM, your billing system, your accounting. The goal is a system that pulls the deals in, applies the plan, shows every rep their live number, and hands finance a clean accrual, all in one place.
We build the audit trail in from the start, because we have seen what happens when trust in the number goes. We build the real-time visibility, because that is what turns commission from a monthly event into a daily motivator. And we build it around your stack, so you are not learning a new system just to track money your team already earned.
We have built commission and sales-ops systems for teams across real estate, B2B services, SaaS, logistics, and professional services, and the pattern is the same. The headaches are almost always the same too: a plan that outgrew its formulas, a team that stopped trusting the number, and an ops person who spent every payout cycle as a reconciler instead of a strategist.
Getting Started
If your commission tracking lives in a spreadsheet and payout day is a little scary, here is a sensible path.
First, write down your plan the way it actually works, including every exception. That single act will tell you how standard you are and how much a generic tool can handle.
Second, count your cycles, your reps, and your disputes. Multiply the hours you spend reconciling and answering “why” by the cycles you run, and you have the labor cost of the spreadsheet in plain dollars.
Third, decide between a fast, standard off-the-shelf tool and a custom system that fits your plan and your stack. Both are an upgrade; the difference is how well they fit.
The spreadsheet was never the problem. The problem is that it is a model of your plan that someone has to hold in their head. Software takes the plan out of a person’s head, puts it in a system that runs it consistently, and gives every rep a number they can trust. That, more than anything else, is what the headache actually is, and it is what stops it.
If you are ready to look at where your commission process is losing time and trust, reach out. We would be glad to help you see what is possible.
About Acherus Inc.: We are a team of former small business owners turned software developers who have lived the exact problems we solve. We do not sell off-the-shelf solutions; we partner with businesses to build custom technology that scales with your ambition, operates on your terms, and delivers real return from day one.
© 2026 Acherus Inc. All rights reserved. This publication contains general guidance and should not be considered financial advice specific to your situation.