Find Jobs
Hire Freelancers

Create an advanced sales commission template in excel which pulls data from another spreadsheet automatically

£250-750 GBP

Suljettu
Julkaistu noin vuosi sitten

£250-750 GBP

Maksettu toimituksen yhteydessä
We are a recruitment agency in the UK Our sales people earn commission at the end of the month which is based on the value of fees they have had invoiced and paid The amount that is paid depends on if they have covered their "monthly cost" (which is different for each recruiter) and how much they have billed in that quarter. We have both a monthly and quarterly bonus scheme We record all sales in a spreadsheet including when the invoice has been paid (which has macros) - "placements sheet" We are looking for the new "commission sheet" to pull the data from the "placements sheet" when an invoice has been paid to show what each consultant is due to be paid commission each month and at the end of each quarter any quarterly bonuses also due. Minimising the extra inputting of data from the other spreadsheet.
Projektin tunnus (ID): 35847092

Tietoa projektista

87 ehdotukset
Etäprojekti
Aktiivinen vuosi sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
87 freelancerit tarjoavat keskimäärin £391 GBP tätä projektia
Käyttäjän avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep
£500 GBP 7 päivässä
4,9 (533 arvostelua)
8,4
8,4
Käyttäjän avatar
Dear Employer, I have checked your requirement and I understand you need to build a new commission sheet to pull data from Placement sheet for the Invoices paid. I am an Excel expert with over a decade of experience and will build a professional tool for you. Also I am a Preferred Freelancer of the "FREELANCER" platform and amongst top 5 bidders. Kindly check my previous reviews here for your kind consideration: https://www.freelancer.com/u/asin1987 Hope to connect soon!! Thanks and Regards, Ashish
£500 GBP 7 päivässä
5,0 (282 arvostelua)
8,3
8,3
Käyttäjän avatar
Hello, I am an Excel/VBA expert and I would like to help you with your commissions template. Please contact me to discuss further details. Best regards.
£400 GBP 7 päivässä
5,0 (495 arvostelua)
8,0
8,0
Käyttäjän avatar
Sir, I AM MACROS AND EXCEL ADVANCE LEVEL EXPERT. I will create this Comission template in excel with 100% automation and accuracy. The commission sheet will pull data automatically from placement sheet, when an invoice is paid and will update and calculate the commission amount of each consultant each month and at the end of each quarter and also provide figure of any quarterly bonuses due. it will require a mix of VBA coding and excel formulas and I am expert of both. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm "PWC" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 264+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar
£250 GBP 1 päivässä
4,9 (265 arvostelua)
7,3
7,3
Käyttäjän avatar
Hi, Excel expert here. I can perfectly assist you in building such a dynamic dashboard and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
£250 GBP 1 päivässä
4,8 (229 arvostelua)
7,3
7,3
Käyttäjän avatar
Hi Sir, I am highly skilled in Excel macros and I can automate the automatic pulling of data from another sheet, on the click of a button. Please share both sheets so I may take a look. There is no need to make any upfront payment. Thank you, Usman
£500 GBP 3 päivässä
5,0 (73 arvostelua)
6,9
6,9
Käyttäjän avatar
Hi Sir, Good Evening, I have more than 10 years working experience in business intelligence and automation using Excel VBA and other tools. I can do this perfectly because I have business background as well as Computer Science background. Let have chat please thanks Shakeel ahmad
£250 GBP 7 päivässä
4,9 (137 arvostelua)
6,9
6,9
Käyttäjän avatar
Greetings Thanks for checking my proposal. I worked as Manager Accounts and would develop professional Sales commission template accordingly. I can start your project immediately. I am full- time freelancer having job experience of more than two decades. It included more than decade of experience as Manager in Public Listed Companies. Having In depth knowledge of Excel for data analysis, Pivot Table and charts, Dashboard, Power query, Macros, User Forms, Advance filters, VBA, Excel Solver, Advance dynamic charts, Financial reporting by using complex Functions. I have also developed many softwares in MS Access. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews Hoping for the positive reply from your side for a long-lasting working relationship. Regards
£250 GBP 1 päivässä
5,0 (126 arvostelua)
6,2
6,2
Käyttäjän avatar
Hello, I am an Excel and VBA/Macro expert. I offer my services to create "commission sheet" (an advanced template in excel) which pulls data from "placements sheet" automatically when an invoice has been paid to show what each consultant is due to be paid commission each month and at the end of each quarter. I have completed many customised automated excel templates with 5 star ratings and excellent reviews. You can check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
£325 GBP 3 päivässä
5,0 (107 arvostelua)
6,3
6,3
Käyttäjän avatar
Hey, I'm an Advanced Level Excel VBA/Macro Expert and will automate this all. Please send me a message so we can discuss further. Thanking You
£250 GBP 1 päivässä
4,9 (144 arvostelua)
6,0
6,0
Käyttäjän avatar
Hi, I am interested in working on this project. I have 8 years of experience working with excel and excel vba related tasks. I read the requirements of this project. I can get this done successfully. Please share the files. Looking forward to hear from you. Best Regards, Akila.K
£250 GBP 3 päivässä
5,0 (55 arvostelua)
5,7
5,7
Käyttäjän avatar
Hi there, I'm an experienced Cost & Management Accountant (CMA) and Advanced Level Excel Macro/ VBA expert. Can we discuss more details about this project? If you are interested, feel free to message me and I will try to help you immediately. Looking forward to connect with you. Regards Abdul Haseeb.
£250 GBP 2 päivässä
5,0 (83 arvostelua)
5,5
5,5
Käyttäjän avatar
Hi, Excel Programming - Data Analysis For Business Plan *Income Statement (with pro forma) *Balance Sheet *Cash Flow *Basic Package Extras - Front Office Forms (Fax, Invoicing, Calendars) Excel Programming - Business Analysis For Financials & Planning *Break-Even Analysis *Startup Expenses *Monthly Budgets *Optimize Product Pricing Payroll & Salary Analysis *Business Expenses *Forecast Sales *Payroll & Salary Analysis *Estimate Commissions & Payouts *Marketing Plan Budget *Standard Package Extras - SEO Budgets & Planning Tools Excel Programming - Data Analysis Mega Toolbox With 45+ Tools *Weaponize your business plan *Essential Small Business Tools *More than 40 unique tools +Business start-up tools +20 additional business tools *Bonus & Extras Additional Tools for Personal Finance, etc.
£500 GBP 7 päivässä
5,0 (17 arvostelua)
5,7
5,7
Käyttäjän avatar
--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
£250 GBP 2 päivässä
5,0 (56 arvostelua)
5,4
5,4
Käyttäjän avatar
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
£500 GBP 4 päivässä
4,8 (147 arvostelua)
5,7
5,7
Käyttäjän avatar
Hello, I'd be glad to create the bonus sheet that pulls data from other sheets and calculates the desired bonus amounts. Looking forward to chat with you soon for more details. Best regards.
£350 GBP 3 päivässä
5,0 (16 arvostelua)
5,4
5,4
Käyttäjän avatar
Hi, I have gone through the Job details and am interested in taking it up. I need you to share the file with me along with more details and I will deliver the required tasks fast and accurately. We can negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since 1997 as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
£400 GBP 3 päivässä
5,0 (35 arvostelua)
5,3
5,3
Käyttäjän avatar
I am expert in excel with 10+ years of experience , I can surely pull data from "placement sheet" and make a new commission sheet as desired , kindly message me
£500 GBP 2 päivässä
5,0 (10 arvostelua)
4,9
4,9
Käyttäjän avatar
Hi I am an Excel expert. I have read the requirements of your project. I can make the required commission sheet for you on excel. Kindly share details in chat and assign this project to me. Looking forward working with you. Regards Asmar
£250 GBP 1 päivässä
4,9 (16 arvostelua)
4,3
4,3
Käyttäjän avatar
Hi, I am an advance level excel expert. I will create the Create an advanced sales commission template in excel which pulls data from another spreadsheet automatically. I have expertise in it. If you want I will submit you a sample without hiring me. So please message me for further discussion. -Habib
£500 GBP 7 päivässä
4,8 (22 arvostelua)
4,1
4,1

Tietoja asiakkaasta

Maan UNITED KINGDOM lippu
Bury St Edmunds, United Kingdom
5,0
2
Maksutapa vahvistettu
Liittynyt lokak. 13, 2019

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.