Find Jobs
Hire Freelancers

Develop recruiting commission software or click and use spreadsheet

¥25000-75000 JPY

Abgeschlossen
Veröffentlicht vor mehr als 7 Jahren

¥25000-75000 JPY

Bezahlt bei Lieferung
Our consultants earn commissions at a percentage that is based on: a. their rank (e.g., Associate, Senior, etc.) and; b. their fees billed vs. targets The consultant may be, for example, be at Consultant level, but earn fees of 40%, or 45%, or 50% depending on actual vs. target billings. We also sometimes run a special contest during a quarter where consultants can earn an extra percentage based on hitting certain criteria. For example, place at least 3 candidates and be on target year-to-date, earn an extra 5% on each placement. Or, earn extra 5% on only the 3rd or more placements in a quarter. Etc. Bonuses are paid when a consultant exceeds his target for the quarter. We should be able to save the results, for each consultant, so they can see their own information, but not see the info for everyone else (because seeing everyone would give them access to confidential base draw / salary information, which is confidential). Currently, we do this manually using Excel so errors do occur. As we grow, we foresee this becoming more labor intensive, so looking for something that will make it a lot easier to calculate and absolutely must have accurate numbers.
Projekt-ID: 11622342

Über das Projekt

17 Vorschläge
Remote Projekt
Aktiv vor 8 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
So what you need is a system to manage the compensation payments for your consultants. It sounds similar to a network marketing operation. You will need a database system to do this properly, and if the system is be to be used on one network, or in one office, MS Access is more than sufficient to do the job. You can establish different accounts for admin staff and consultants to control what each of them can do, and what they can see. Your data set is (roughly speaking): consultants, billings and placings, and you will need tables created for each of these, plus another two: one containing the compensation algorithm parameters, and another calculating the actual monetary compensation for each consultant. The calculations of the latter would take place automatically as you enter the consultant's results. Without going into too much detail at this point you may want to look at an Access project I did recently called 'Class Management System' on my profile. Yours need not be as elaborate but it shows you how Access can provide you with the data entry and analysis / reporting functionality you require. Excel could also be kept in the mix for reporting purposes.
¥61.750 JPY in 14 Tagen
5,0 (2 Bewertungen)
3,4
3,4
17 Freelancer bieten im Durchschnitt ¥53.427 JPY für diesen Auftrag
Avatar des Nutzers
Hello there. This is some kind of a bonus and rebate system. I have built many calculators in Excel for these kind of systems. I build them in a way so that you can easily use with a nice interface and accurate results. I am mostly online, lets discuss about your job. Thanks..
¥52.631 JPY in 5 Tagen
5,0 (125 Bewertungen)
6,9
6,9
Avatar des Nutzers
Hi Sir, I am highly skilled in Excel and can use VBA routine to accurately calculate commission of each consultant. Please share a sample sheet so I may take a look and propose its automation. Thank you, Usman
¥60.000 JPY in 4 Tagen
4,9 (66 Bewertungen)
6,7
6,7
Avatar des Nutzers
Hello there, I would like to inform you that I have extensive experience in creating Incentive Compensation calculators owing to my work as a consultant with Synygy. I did several calculators that calculated commissions based on ranks, targets and contests. Some of these were done for clients like Daiichi Sankyo and GSK etc. For your purpose, there are more than one options we could explore. We may create an Excel+Access setup where all the data would be available in a shared Access database that would be password protected and consultants would only be able to pull their reports. The other option is to have a web-based setup that would more than this. I can help you with in both types of implementations. I have done both types of works and if you could send a message to me, I would be able to show some examples of my work. Please send a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to hear from you and thank you for considering my bid Best Regards, Rishi (Automyze Consulting) P.S. the bid amount is indicative at this stage since requirement is not clear. I would be able to offer the best price once I have had a look at the data.
¥65.000 JPY in 15 Tagen
4,9 (137 Bewertungen)
6,3
6,3
Avatar des Nutzers
I can do exactly what you need. I can create a form in Excel which each of your consultants will be able to open with their password, then they will only see their data but not the others' data. The commission calculations will be performed automatically in the form. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
¥40.000 JPY in 5 Tagen
4,8 (132 Bewertungen)
6,7
6,7
Avatar des Nutzers
Dear Project poster, I understand that you want to enhance the feature of existing macros through excel programming or VBA. I have 5 years of experience. I have good knowledge of excel. I am looking for projects. Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. We have 100% client satisfaction ratio. I had already done the same work in past. Looking forward to hear from you. Let me give an opportunity to work. We can talk further when you message me.
¥25.000 JPY in 1 Tag
4,9 (106 Bewertungen)
6,1
6,1
Avatar des Nutzers
Hello. 35 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
¥50.000 JPY in 10 Tagen
5,0 (85 Bewertungen)
5,7
5,7
Avatar des Nutzers
i can do it for you quickly and exactly by vba
¥27.778 JPY in 4 Tagen
4,9 (69 Bewertungen)
5,5
5,5
Avatar des Nutzers
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex webscrapping, Amazon, aliexpress, VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
¥77.777 JPY in 5 Tagen
4,8 (71 Bewertungen)
5,8
5,8
Avatar des Nutzers
Hello, I am Excel and VBA expert. I can write VBA macro. Can you provide more details about the project? Please note that I have 100% completion rate and 5-star feedback on 50 projects.
¥55.555 JPY in 10 Tagen
5,0 (59 Bewertungen)
5,5
5,5
Avatar des Nutzers
Hello Sir, I am interested in this project. I propose to create a Windows based application which will does the required calculations and we can store this information in SQL Server to make it secure. Besides that we can have option to send reports to individual consultant as an email. That way they will have a complete details about how they earned their commission/bonus etc as well as no access to other consultant's information. Please let me know if you want to discuss this further. Thanks Aanvik
¥55.555 JPY in 10 Tagen
4,9 (4 Bewertungen)
3,1
3,1
Avatar des Nutzers
Hello, I have read your post and I am really interested to work for the project. It is very clear that you are in need of someone who can prepare an excel spreadsheet that can automatically generate commission of your consultants. If you will give me chance to work for this project, I will make sure that you will have a result that is off quality. I will give you the best result with the lowest cost possible. I will use my Accounting profession and knowledge in the excel function to create the result you want. I look forward hearing anything from you. Just leave me a message and I would be very glad to respond immediately. Thank you and more power. Regards, Rick Laurence R. Lejano, CPA
¥25.000 JPY in 10 Tagen
4,3 (2 Bewertungen)
1,6
1,6
Avatar des Nutzers
Hi, I have 10+ years of experience in vb, excel,asp.net, SQL server. I have done several similar projects. If you have a big number of consultants I think it is best to go for online application. I can do it using vb.net and SQL server database. I can provide you demo for the same. Provide me your detail requirements (How many ranks are there and payment criteria in detail). Every consultant will be able to login to their account (Restricted to only his/her own information) and there will a different login panel for Admin.
¥72.222 JPY in 15 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von JAPAN
Tokyo, Japan
5,0
1
Zahlungsmethode verifiziert
Mitglied seit Sept. 26, 2016

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.