How much commissions to pay your partners? Learn the math and logic behind it. Read here →

SUCCESS STORY

Clawback commission calculation on ElevateHQ is 5x faster than spreadsheets

“Clawback is a big chunk of our commission process based on the trade dates and profits made. Doing this on spreadsheets was getting more difficult as we scale.”

Morgan Sanders,

Chief Marketing Officer

4 weeks

Implementation Time

5x

Faster Calculation

99%

Less Payout Errors

About the company

USA Mutuals is a financial services company offering various mutual funds and investment products. They aim to provide investors with opportunities for growth and income through a diversified portfolio of investments. The company focuses on delivering competitive returns while managing risk and offers various funds that cater to different investment objectives.

Problem

USA Mutuals faced significant challenges in accurately calculating and managing complex commission structures, including time-based clawback logic. They also increased their commission rate last year, making calculations difficult on spreadsheets and leading to inefficiencies.

Outcome

We automated calculations, and they are 3x faster on ElevateHQ than on spreadsheets. Before, a significant amount was invested in tweaking formulas on spreadsheets and cross-checking.

What were the pain points?


Here's what troubled them the most:

1. Points-based commission structure + clawback

Applying different basis points depending on the trade date, as well as handling clawbacks for withdrawals, was complex to manage on spreadsheets, increasing the risk of errors, especially when formulas are manually entered or adjusted.


2. Scaling was difficult on spreadsheets

As the number of trades and wholesalers grew, the spreadsheet approach became less efficient and more time-consuming. Large volumes of data can slow down performance, making it difficult to manage commission calculations promptly.


“We pay commissions of profit margins, and the commissions for different people involved in the project are based on their hierarchy. The senior people in the hierarchy work with multiple projects, making tracking difficult on spreadsheets.”

Morgan Sanders,

Chief Marketing Officer

What were their requirements?




How ElevateHQ changed their game?


group icon
Calculation 5x faster with automation

We set up their intricate clawback process based on trade on our plan designer to automate calculations. Our software now calculates it 5x faster than spreadsheets and updates the commission statement monthly with 0 errors.

group icon
Full commission visibility to reps

Reps see their commission statements when they are released every month and raise a query within the software in case of any discrepancy. They also use the commission simulator to predict their earnings.

group icon
99% fewer errors during payouts

They no longer need to check an employee's rate start date, end date, and billing rate from spreadsheets.

group icon
Seamless integration with Google Sheets

We helped them with data normalization on their data source and created a streamlined process for commission management.

"The dashboard is informative so that we can take action quickly. The training from the team was helpful. It is good to know we can do things on our own, but we will always get instant help if needed."

Morgan Sanders,

Chief Marketing Officer

Ready to automate sales commissions?

Check out how ElevateHQ can automate your commissions. Get a free, personalized demo today!
Book Demo - It’s Free