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.
17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
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
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.