I'm looking for a commission calculator that will be able to track a base pay(draw) vs commissions earned monthly. I need to be able to also calculate the commissions at two different rates (E.G. self gen sales are 15% commission, company provided leads are 10%) and have commission paid out if YTD commissions are greater than the YTD draw AND MTD commissions are greater than MTD draw. I have a sheet already completed that calculates a single commission rate but I need it to be able to do both.
I've attached the current document so that you can see what I am trying to achieve.
11 freelancers are bidding on average $33 for this job
Hi, I am an Excel expert. I can modify existing calculator to include 2 types of commissions. Please take a look at my portfolio for Excel projects. https://www.freelancer.com/u/best4best?w=f Regards MS
I can easily do this request and get it to you quickly. I'm free the rest of the weekend, so there are no timing concerns for me. Thanks for your consideration.