In Progress

Excel Application to calculate multi faceted complex monthly sale commission calculations

I am looking to use an excel application to automate the calculation of monthly salesperson commissions.

We have 2 groups

Capital Sales – Runs January to December

Parts Sales – Runs April to March

Within each category the rates, abatements and calculations all vary slightly.

It will need to include a monthly and running summary of commission tally’s

From a set of raw data I need the application to calculate the commission for each person and create a calculation sheet that can be emailed direct to each sales staff member.

The raw data is as follows (and is stored in an exel table we use for sales recording)

Territory 1 Sales

Territory 2 Sales

Territory 3 Sales

Territory 4 Sales

Territory 5 Sales

Product 1

Product 2

Product 3

Individual sales by product

Customer 1 - 20

Then for each sub set of data, it needs to calculate

YTD sales

Need to apply an abatement before commission starts

Different commission rates for each staff members

Calculate GP% on YTD sales

Used the GP% to determine certain calculations

Calculate commission on specific product and customer spend at varying %’s and abatement amounts

Combine different territories and products

Individual sale

It is most likely easiest for me to attached examples of my current manual output sheets. I will also attach a sheet that forecasts the sales staff commission

There is a complication in the fact that on sales from 0 – 12.5M commission is paid to sales staff based on set territory but once 12.5M is reached it is based on all territories. Then the payment structure changes.

There are thresholds that need to be met before certain commission is due

The abatement only applies once, so once the threshold is met the abatement ceases to apply

I wonder if the application needs to cater for ALL the commission elements and they can be selected or de selected for individual employees??

See the excel sheet for extra details

Skills: Excel, Visual Basic

See more: excel application month wise account maintenance, excel application, convert excel application stand alone, excel, excel report script multi linked webpage, excel 2007 calculate savings, refer excel application access, excel application optimization, monthly sale report asp, custom excel application price, excel application frozen, convert excel application web application, converting excel application converting excel, excel application define vbnet using office 2007, excel formula calculate staying nights, excel vba calculate critical path, excel application hotel, vba excel application sum multi cell

About the Employer:
( 0 reviews ) Hamilton, New Zealand

Project ID: #20037012

Awarded to:

P0L

Hello, I’m an Excel expert and I would like to help you with your commission calculations. Please check my profile and contact me to discuss further details. Regards.

$500 NZD in 10 days
(296 Reviews)
7.2

18 freelancers are bidding on average $614 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$700 NZD in 4 days
(700 Reviews)
8.4
Webxpert4u

I am ready to create excel using vba to calculate monthly sales and commissions. can we discuss in details before starting? thx

$882 NZD in 7 days
(222 Reviews)
7.9
sandroshubladze

Hello I am Excel Expert and VBA developer Can definitely help you with reporting task and create desirable automations If you will be interested contact me thanks & regards

$705 NZD in 5 days
(200 Reviews)
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application to automate your monthly commissions. I plan to use a combin More

$600 NZD in 5 days
(203 Reviews)
7.3
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can help you to make application macro VBA excel for calculate multi faceted complex monthly sale commission like you need please ping me now and we can discuss m More

$250 NZD in 10 days
(344 Reviews)
7.1
dgled

Hi, I can create for you a Sales Commission Module in Excel to calculate commissions to salespersons based personal parameters, by sales or collections (including by partitional payments). I will add a procedure to co More

$500 NZD in 10 days
(79 Reviews)
7.0
periyannas

Ok Sure let me help. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

$823 NZD in 12 days
(101 Reviews)
6.1
shikhamehta

Hey, I am an Excel expert and have delivered more than 500 projects successfully here on Freelancer itself. I would also like to inform you that I have created commission calculators for Pharma companies like Daiichi- More

$710 NZD in 10 days
(98 Reviews)
6.4
diorisaguilar

Hi! Automate Excel processes is my business, improve the user experience to manage complicated formulas and calculations. I can help you on this project to automate this commission calculation. I just reviewed the fil More

$680 NZD in 6 days
(42 Reviews)
6.0
aubrey03

I am an MS Excel and Access Specialist and an experienced Freelancer who is dedicated to provide quality results within a reasonable timeline and budget. Accuracy is my priority so I believe I am the best freelancer fo More

$300 NZD in 3 days
(99 Reviews)
5.7
KavTan

Hi there, I have read your brief and understand that you require to have running commission rate for set of complex data sets. I am a professional freelancer having advance skills in MS Excel and have experience in cr More

$750 NZD in 7 days
(48 Reviews)
5.7
afenache

Hi, I can build the excel commission calculator tool that you described. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot tab More

$700 NZD in 7 days
(19 Reviews)
5.2
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam More

$300 NZD in 10 days
(31 Reviews)
5.0
Diliphero

Greetings, I am a professionally qualified Business & Financial Consultant from Sri Lanka with a degree in Management & Finance. I have the experience in Excel dashboards, VBA and Macros. I have a very good business More

$800 NZD in 10 days
(14 Reviews)
4.8
NoelReubenMuturi

Greetings, I am Noel, a BA in ECONOMICS, MA in ECONOMICS, ACCA, and an MS Excel guru. You need an excel application to automate the calculation of monthly salesperson commissions. I am qualified to take up the projec More

$750 NZD in 10 days
(8 Reviews)
4.1
sergeyprince

Hello. I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processing , Excel VBA Expert who knows the value of time, very hard working and always delivers the work o More

$500 NZD in 10 days
(6 Reviews)
2.3
newworld926

Dear Sir! I read your description carefully! As I have rich experiences in VBA programming from school ages, I can offer you the excellent result. I hope to discuss in detail via chat. Best Regards.

$600 NZD in 3 days
(1 Review)
1.0