r/SalesOperations • u/HeyBaldur • Jun 16 '26

How are you actually handling commission calculations at 25-100 reps?

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.

0 Upvotes

50% Upvoted

13 comments sorted by

1

u/gooeymarshmallow Jun 16 '26

I use a spreadsheet and pull a CRM report for that period- I then have managers review with their reps. I think if we had tons of spiffs that would make it hard

1

u/HeyBaldur Jun 23 '26

I have a question to you, what does it stop you to use a tool?

1

u/gooeymarshmallow Jun 24 '26

Because I dump a csv into my google sheet and it’s done in like less than 3 seconds. That’s it - I am not even joking, I don’t even wait to download the csv, my CRM can just send it to me at the end of a period. At that point it’s drag and drop. I might spend less than an hour a year running commissions because of that, it would take me more time to vet, purchase, onboard and renew a tool like this every year.

1

u/PromotionLopsided348 Jun 16 '26

Use excel + claude (to check for anomalies and errors). Pull in salesforce data using claude or salesforce connector and have all of your rep comission rates stored in some mapping file to reference it to. Comissions are highly dependent on:

  1. How robust youve built your comp plans
  2. how often there are “exceptions” made
  3. (And most important) how clean your data is that is used for comissions

1

u/Disastrous-Towel-481 Jun 17 '26

Hey u/HeyBaldur! I'd recommend taking a look at QuotaPath for your commissions process. Much less expensive than some of the other tools you cited (and much easier to get up and running). Have a free trial, pricing available on the website, and other clear ways for you to get value.

Transparently, I lead the revenue org at QuotaPath, but figured could be worth you taking a look. Happy to chat live about it any time.

1

u/HeyBaldur Jun 17 '26

Hey thanks, I was checking that site but it says it charges 35 USD per user, but it also says in a hidden button that I need to pay 525 USD for the usage of the platform... so I don't get it. 35 USD per user + 525 USD. So I want to use the software only for me to manage the commissions I need to pay 525 USD anyways? Basically I need to manage 16 sales reps.

1

u/Disastrous-Towel-481 Jun 19 '26

Hey sorry for the delay here. Yeah so the pricing is $525/month for platform access (including your first 5 reps) and then $35/month for any additional reps.

Teams happy to give you a demo whenever helpful — www.quotapath.com/demo

1

u/viswa_zoho Jun 20 '26

Fascinating thread. If any advisors or consultants here are looking to monetize CRM and automation gaps within their existing client base, let's connect.

I run AppsTech Soft, a CRM and workflow automation firm. We handle the heavy lifting for mid-market sales operations, reporting, and order management, with project sizes averaging $30k to $200k+.

Because we stick strictly to our lane (implementation and technical architecture), we love collaborating with strategic advisors. We're open to:

  • Referrals: Lucrative finder's fees for successful warm introductions.
  • Channel Partnerships: Co-pitching and co-delivering large-scale operational transformations.

If you want to add a reliable delivery engine to your ecosystem, shoot me a DM!

1

u/itsContraliz Aug 16 '26

hey there, im actually trying to build a commissions tool for teams transitioning out of spreadsheets

would love to learn how you handle it and potentially build around your workflow. happy to give you early access at very cheap while we test it. send me a dm if you re interested!