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.

Taidot: tietojenkäsittely, Tietokannan hallinto, Excel, Microsoft Access

Näytä lisää: 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

Tietoa työnantajasta:
( 2 arvostelua ) West Palm Beach, United States

Projektin tunnus: #4271938

Myönnetty käyttäjälle:


Hello Sir, Kindly check PMB.

60 $ USD 5 päivässä
(8 arvostelua)

17 freelanceria on tarjonnut keskimäärin 137 $ tähän työhön


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

250 $ USD 3 päivässä
(41 arvostelua)

Expert here, please see the PM for more details

250 $ USD 3 päivässä
(55 arvostelua)

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

250 $ USD 7 päivässä
(59 arvostelua)

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 Lisää

123 $ USD 5 päivässä
(199 arvostelua)

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

175 $ USD 5 päivässä
(38 arvostelua)

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

130 $ USD 7 päivässä
(71 arvostelua)

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 5 päivässä
(13 arvostelua)

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 20 päivässä
(10 arvostelua)

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 3 päivässä
(9 arvostelua)

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

100 $ USD 5 päivässä
(19 arvostelua)

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

85 $ USD 4 päivässä
(11 arvostelua)

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

60 $ USD 4 päivässä
(7 arvostelua)

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

40 $ USD 7 päivässä
(4 arvostelua)

I am interested in this project

50 $ USD 5 päivässä
(7 arvostelua)

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 5 päivässä
(0 arvostelua)

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 Lisää

250 $ USD 14 päivässä
(0 arvostelua)

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 Lisää

123 $ USD 3 päivässä
(1 arvostelu)

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

30 $ USD 5 päivässä
(0 arvostelua)