Commission vs Draw spread sheet calculator

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.

Skills: Excel

See more: web service spread sheet, iphone spread sheet, stock control spread sheet, time managment spread sheet, online sheet calculator, time management spread sheet, lock excel spread sheet, excel sheet calculator web, copy product spread sheet, draw flow sheet, j2me spread sheet, operating budget excel spread sheet exampleproject, convert word document spread sheet, usable spread sheet, excel dispatch spread sheet, time management spread sheet free, contact spread sheet excel, respond data spread sheet, sales commission sales persons spread sheet, forex commission vs spread

About the Employer:
( 0 reviews ) Orlando, United States

Project ID: #20022245

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. Regards MS

$20 USD in 1 day
(131 Reviews)

Hi! I believe I can help you with the formulas you're trying to create. I am an organized, experienced professional with more than fifteen years of experience. I have held titles such as Publishing Assistant, Administ More

$30 USD in 2 days
(7 Reviews)

Hi, Hope you are doing well! I would like to work on your project. I have excellent in skills with more than 6 Years experience. I'm sure that I will complete with high quality in the shortest time. I am always availa More

$90 USD in 7 days
(4 Reviews)

I'm an experienced Excel user and coder. I can add the functionality for an extra commission rate.

$25 USD in 7 days
(5 Reviews)

$ 15 ONLY !!!!! Sir, I have seen your attachment and understand your requirements very well, it is quite basic to me. I have expertise in Excel, Excel VBA, Pivot Table, Chart, Graph etc. I can assure you I will delive More

$15 USD in 1 day
(2 Reviews)

Portfolio: [login to view URL] Cv:[login to view URL] With a Bachelor’s Degree in Electronic Engineering, hands-on experience creating and implementing software applications, and the ability to d More

$55 USD in 1 day
(0 Reviews)

I am a controller and have worked with commissions spreadsheets and structures for a few different companies. I am certain that I can have this completed for you in a timely manners. Let me know if you would like me to More

$35 USD in 1 day
(0 Reviews)

It is logical reason and I can do it and fix the formula in order to be used after that in easy way. Hope to serve you

$10 USD in 1 day
(0 Reviews)

Hello, I have 15 years excel experience. I can add in another line for sales so as you can split sales into self generated and company provided leads. I will then update the formulas for monthly commission, YTD commis More

$30 USD in 7 days
(0 Reviews)
$19 USD in 1 day
(0 Reviews)

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.

$30 USD in 0 days
(0 Reviews)