u/HeyBaldur

I have an engineering background and extensive experience working with incentive compensation systems, and I'm currently exploring an idea to improve how companies manage and understand sales compensation.

Before taking the idea further, I'd like to understand how companies actually deal with commission questions and discrepancies today.

I'm particularly interested in situations where someone asks:

• "Why was I paid this amount?"
• "Why didn't this transaction generate commission?"
• "Why was this commission clawed back?"
• "What happened to this transaction?"
• "What's this rep's current commission balance?"
• "Why is my quota attainment different from what I expected?"
• "Which transactions are included in this payout?"

For companies with more complex compensation plans, what does the investigation process actually look like?

Do you typically:

• Dig through spreadsheets?
• Export data from HubSpot?
• Check CRM records and commission calculations separately?
• Ask someone in Sales Ops or Finance?
• Use a dedicated commission management platform?
• Something else?

And perhaps the most important question:

How long does it usually take to get a clear answer when a rep disputes a commission?

I'm not looking to promote a product here. I'm trying to understand where the biggest operational pain points actually are and whether there is an opportunity to improve this process.

I'd especially appreciate hearing from Sales Ops, RevOps, Finance, or anyone responsible for managing sales compensation.

I'm curious how companies are handling commission management when the sales process becomes more complex.

For example, imagine a company with 50–200 sales reps where commissions depend on things like:

• Different commission plans for different roles or teams
• Commission splits between multiple reps
• Changes in deal ownership
• Returns or cancellations after a commission has already been paid
• Adjustments or clawbacks
• Different commission rates depending on the product, customer, or deal
• Managers needing visibility into their team's commissions
• Finance needing to audit exactly how a commission was calculated

At what point does managing this in spreadsheets or manually exporting data from HubSpot become too difficult?

I'm particularly interested in how people are handling this today.

Do you use HubSpot alone, spreadsheets, a dedicated commission/compensation tool, or something else?

And what is the biggest pain point you've encountered with your current setup?

https://reddit.com/link/1vqoshz/video/sjyf62ewywjh1/player

Hello guys!
A long time ago when I was a kid there was a very popular card game that came along with the chips (I am talking about more than 20 years ago).I am developer so I decided to try to build it.

The game mechanics were very simple (just for fun), but out of pure nostalgia I wanted to revive it. I am developing this in my free-time like a aside project. Not looking for anything special, just wanted to share here to see options and know if you'd like to see it finished.

https://reddit.com/link/1vqmbbq/video/tu1wx1fh9wjh1/player

Alguien se acuerda de las Tosty-Caos?
Recorde este juego hace un par de meses y como soy dev, decidi crear una version en mi tiempo libre. Son las mismas dinamicas y todo. Afortunadamente las tengo todas, aun no he terminado el juego dado que lo estoy haciendo por ratos y en mi tiempo libre. Pero durante lo que he desarrollado me llego la nostalgia. No se si alguien los recuerda. Aun no lo termino, pero pregunto, les gustaria verlo completado?

I'm a software developer researching the commission management space for a side project. I've been talking to a few Sales Ops folks and keep hearing the same thing, Excel works until it doesn't, and the jump to enterprise software feels like overkill for mid-sized teams (Price, Complexity, Onboardings, Plans Development).

I'm trying to understand where that "tipping point" is. Specifically:

1. At what team size / plan complexity did Excel stop working for you?
2. What made you choose software over sticking with spreadsheets? (Or why haven't you switched?)
3. For those who evaluated tools like CaptivateIQ, Spiff, or QuotaPath, what made you say "yes" or "no"?
4. What's the one feature you wish your commission tool had?

This is pure research, I'm not selling anything. Happy to share findings back with the community if there's interest.

Thanks in advance for any insights.

I'm a software developer researching the commission management space for a side project. I've been talking to a few Sales Ops folks and keep hearing the same thing, Excel works until it doesn't, and the jump to enterprise software feels like overkill for mid-sized teams (Price, Complexity, Onboardings, Plans Development).

I'm trying to understand where that "tipping point" is. Specifically:

1. At what team size / plan complexity did Excel stop working for you?
2. What made you choose software over sticking with spreadsheets? (Or why haven't you switched?)
3. For those who evaluated tools like CaptivateIQ, Spiff, or QuotaPath, what made you say "yes" or "no"?
4. What's the one feature you wish your commission tool had?

This is pure research, I'm not selling anything. Happy to share findings back with the community if there's interest.

Thanks in advance for any insights.

Hi r/SalesOperations,

I'm a software developer researching the commission management space for a side project. I've been talking to a few Sales Ops folks and keep hearing the same thing, Excel works until it doesn't, and the jump to enterprise software feels like overkill for mid-sized teams (Price, Complexity, Onboardings, Plans Development).

I'm trying to understand where that "tipping point" is. Specifically:

1. At what team size / plan complexity did Excel stop working for you?

2. What made you choose software over sticking with spreadsheets? (Or why haven't you switched?)

3. For those who evaluated tools like CaptivateIQ, Spiff, or QuotaPath, what made you say "yes" or "no"?

4. What's the one feature you wish your commission tool had?

This is pure research, I'm not selling anything. Happy to share findings back with the community if there's interest.

Thanks in advance for any insights.

I’ve been talking to 5 Sales Ops Managers this week, and something surprised me. A lot of people still seem to be setting up commission plans in Excel.

Not because software tools don't exist, they do. But they tell me that implementing them takes 3-6 months normally, requires consultants, and on top of that, they are extremely expensive.

If you set up commissions, let me know in the comments or via DM. I’m building a small benchmark and would love your perspective.

Hi guys, I am curious how you actually handle this in practice, because I keep seeing it described differently.

When a rep is on more than one plan at the same time, say a base commission plan plus a short-term SPIFF, or a hybrid role with new-business + renewals plans. How does a single deal get treated?

Specifically:

• Does the same deal pay out on multiple plans at once (e.g. it counts toward base AND the SPIFF), or does each deal belong to exactly one plan?
• If a deal can hit multiple plans, how do you decide which ones, product, territory, deal type, manual tagging?
• How common is the "same deal pays twice across plans" setup vs. "each deal goes to one plan" in your org?
• What's the actual pain here, is it the calculation, the visibility for reps, the exceptions, or something else?

Trying to understand how teams really run this day to day, not the theory. Whether you're on a dedicated ICM tool, spreadsheets, or something homegrown, would love to hear what your setup looks like and what's annoying about it.

Sorry for sounding quite robotic, I needed from ChatGPT because this was a very difficult question and I needed to make it clear and sound concrete for the community.

I've been talking to a few sales ops people and I keep hearing the same thing all the time like somewhere between 25 and 100 reps (not many), commission management turns into a chaos, but the current tools like xactly, SAP, Spiff feel too complex and super expensive, sometimes does not make sense to use those tools because I will end up paying more money than the incomes the company sales.

So I'm curious what people here actually do day to day

• What do you use right now to calculate commissions, spreadsheet, a tool (which one), or a mix?
• If it's spreadsheets, what's the part that actually hurts? multi-currency? quota changes mid-period? splits? month-end reconciliation?
• If you tried a commission tool and went back to Excel, why you go back?
• Roughly how many hours a month does the whole commission process eat, and who eats them?
• Has a commission error ever blown up into a dispute with a rep? How do you manage that?

I am trying to understand how bad this really is and how people cope.

I've been talking to a few sales ops people and I keep hearing the same thing all the time like somewhere between 25 and 100 reps (not many), commission management turns into a chaos, but the current tools like xactly, SAP, Spiff feel too complex and super expensive, sometimes does not make sense to use those tools because I will end up paying more money than the incomes the company sales.

So I'm curious what people here actually do day to day

• What do you use right now to calculate commissions, spreadsheet, a tool (which one), or a mix?
• If it's spreadsheets, what's the part that actually hurts? multi-currency? quota changes mid-period? splits? month-end reconciliation?
• If you tried a commission tool and went back to Excel, why you go back?
• Roughly how many hours a month does the whole commission process eat, and who eats them?
• Has a commission error ever blown up into a dispute with a rep? How do you manage that?

I am trying to understand how bad this really is and how people cope.

Hi everyone,

I've been spending a lot of time analyzing how mid-market sales organizations manage incentive compensation, and I keep running into the same problem. Enterprise giants like Xactly and SAP Commissions are good, but they have several issues, besides being expensive.

The licensing costs are brutal. They have good UIs, but since the corporate acquisitions, their roadmaps seem focused on integrating their own platforms rather than on the flexibility of the commission engine.

If you don't use their specific CRM or manage a hybrid, multi-currency operation, the tool becomes a mess. The common alternative? Going back to Excel or Google Sheets. But as soon as a team reaches 25 to 100 reps, maintaining those spreadsheets with dynamic quotas, time-based adjustments, and split commissions becomes a real pain.

I'm evaluating the architecture for a completely standalone commission engine focused on eliminating this chaos for small and medium-sized businesses.

Without real-time integrations that break. Mid-market plans are complex and require initial human validation to translate the unusual Excel rules into the system correctly.

Before moving forward with the development of the execution engine, I'd like to open a discussion with those who truly struggle with commissions every month.

• Do you consider automatic, real-time synchronization with the CRM a mandatory requirement, or would a file-controlled upload model give you more peace of mind during month-end closing?
• What has been your biggest frustration or hidden cost when trying to migrate from spreadsheets to traditional commission software?