In Progress

Commissions Report

Looking to have a database created for my sales staff. They are each commissioned based and I want to be able to keep track of their different sales commissions based on a few things. Each sales person gets paid a percentage (varies) of the gross revunue earned on that particular deal. Sometimes the commission is shared between two sales people and they will split the commission percentage. Also, the company keeps a fixed dollar amount (can also vary) of the gross commission.

The idea is to run reports on a monthly and quarterly basis to see how much each sales person has earned. Report should have fields such as Sales Person Name, Client Name, Date Deal Closed, Gross Commission, Gross Fees Deducted, Commission Percentage Split, Net Fees Deducted and Total Commission Earned (that will be the calculated field).

Would also like the ability to import this data from an Excel spreadsheet. Would also be nice if I can store this file on my Sharepoint Server Space (Office 365), but not required.

Database will most likely be created in Microsoft Access.

Skills: Data Processing, Database Administration, Excel, Microsoft Access

See more: sharepoint company, how much a sales person gets paid, Sales commissions , sharepoint import, excel sales monthly report, sharepoint excel, net excel import, track commissions, space office, net import excel, excel split, report server net, net monthly report, sharepoint report, space commission, sharepoint database, commission based field sales, sales commission spreadsheet excel, staff excel, database keep track commissions, report client, office 365 sharepoint, monthly database excel, sales report spreadsheet excel, client commission spreadsheet

About the Employer:
( 2 reviews ) West Palm Beach, United States

Project ID: #4271938

Awarded to:

sinfulm3

Hello Sir, Kindly check PMB.

$60 USD in 5 days
(8 Reviews)
3.8

17 freelancers are bidding on average $137 for this job

rhomeu

MS Access expert here. We can develop a program in MS Access 2007/2010(desktop).

$250 USD in 3 days
(41 Reviews)
6.6
diamond247

Expert here, please see the PM for more details

$250 USD in 3 days
(55 Reviews)
6.4
bharanisrihari

Hello, Excel VBA expert here. I've completed similar projects. Please check PM for details. Thanks!

$250 USD in 7 days
(59 Reviews)
6.3
Premshanks

Dear Sir - this is my proposal. 1. Sales person maintenance form ---- here you can maintain the sales person static details like name/address/phone. 2. Deal screen --- here you can enter the deal details like More

$123 USD in 5 days
(199 Reviews)
6.0
kulhanekd

I have 15 years exp in access and excel. I would like to bid on your project. Donna

$175 USD in 5 days
(38 Reviews)
5.8
torajiv

MS Access guru here - have completed over 100 projects - please see PM for more details - Rajiv

$130 USD in 7 days
(71 Reviews)
5.6
expertcoder1vw

Hi, I'm an expert database programmer and can develop this database for you in MS-Access. Can complete in 4 days. Thank you for considering my bid. Bests, Larry

$140 USD in 5 days
(13 Reviews)
4.7
j2eesoafree

Hi The bid is for building a web based app using Java-JEE and a backend database (open soure free software based). We can disucss more on the business logic for calculating commissions if this is ok. regards, kD

$250 USD in 20 days
(10 Reviews)
4.7
MarlinSoftware

Hello, I have 12+ years experience developing MS Access applications and could do this project for you. Please view my portfolio for some examples of my work. Thank you.

$150 USD in 3 days
(9 Reviews)
4.5
NourElDeen

Dear Sir, I'm Export on access. Best Regards, NourElDeen

$100 USD in 5 days
(19 Reviews)
4.1
farr4u

Hello, Access VBA expert here, I have developed your application to a large extent, plz chk pm for DEMO. Regards.

$85 USD in 4 days
(11 Reviews)
3.6
haseebhm

Please check my reviews, I have quite a lot of similar projects. I hope you consider. Thanks

$60 USD in 4 days
(7 Reviews)
3.3
srdas2012

Hello Sir,We can do this ,Please see Private Message to see the Details.

$40 USD in 7 days
(4 Reviews)
2.6
nithyarajeshg

I am interested in this project

$50 USD in 5 days
(7 Reviews)
1.5
dohko1911

Dear Employer, I have understood your requirements and put a summary in separate post to you. Please read and communicate with me. Many thanks. Dohko.

$80 USD in 5 days
(0 Reviews)
1.6
TBSGADI

Hi, I'm a Senior Access Database and Excel VBA Developer. I'm new to this site, but have 20 years experience in developing, maintaining and upgrading applications,many with features similar to the one you're requesting More

$250 USD in 14 days
(0 Reviews)
0.0
Midlander

Mr. Enriquez, I am sending you a sample database and dashboard complete with a "speedo" dial graph showing how one sales person perfored against their target. This will demonstrate that I have the skillset to pro More

$123 USD in 3 days
(1 Review)
0.8
sstorm548

This is a simple project, and I've developed similar things in my professional career.

$30 USD in 5 days
(0 Reviews)
0.0