Kapalı

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

Job Description:

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.

Beceriler: Excel, Excel VBA, Excel Macros, Excel VB Capabilities

Müşteri Hakkında:
( 2 değerlendirme ) Bury St Edmunds, United Kingdom

Proje NO: #35847092

Bu iş için 89 freelancer ortalamada £388 teklif veriyor

schoudhary1553

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 Daha Fazla

£500 GBP in 7 gün içinde
(517 Değerlendirme)
8.4
asin1987

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 Daha Fazla

£500 GBP in 7 gün içinde
(281 Değerlendirme)
8.3
P0L

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 in 7 gün içinde
(491 Değerlendirme)
8.0
AccountantArman

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(227 Değerlendirme)
7.0
daniyal3214

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 incl Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(199 Değerlendirme)
7.1
maverick44000

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 up Daha Fazla

£500 GBP in 3 gün içinde
(72 Değerlendirme)
6.9
ShakeelASESE

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 Comput Daha Fazla

£250 GBP in 7 gün içinde
(132 Değerlendirme)
6.9
professional800

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(106 Değerlendirme)
6.1
hamidr2020

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 w Daha Fazla

£325 GBP in 3 gün içinde
(85 Değerlendirme)
6.0
AkilaArun

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 f Daha Fazla

£250 GBP in 3 gün içinde
(55 Değerlendirme)
5.7
merinsinha

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 Daha Fazla

£500 GBP in 4 gün içinde
(144 Değerlendirme)
5.7
usmanbashir12100

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 - B Daha Fazla

£500 GBP in 7 gün içinde
(10 Değerlendirme)
5.3
lkhelladi

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 in 3 gün içinde
(15 Değerlendirme)
5.3
Ahsan2526

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(64 Değerlendirme)
5.0
rahulg5466

--------------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, Daha Fazla

£250 GBP in 2 gün içinde
(29 Değerlendirme)
4.7
ammar3215

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 in 2 gün içinde
(9 Değerlendirme)
4.7
amokhtar70

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 fee Daha Fazla

£400 GBP in 3 gün içinde
(12 Değerlendirme)
4.1
freddyho

Hi, I am an expert in either Excel formula, macros, VB.NET programming, and optimizing automations. For my results, I am guarantee: - No hidden passwords (all passwords will be given at the second milestone) - No hid Daha Fazla

£250 GBP in 3 gün içinde
(6 Değerlendirme)
3.8
Goodfreelancer1

Hello, I am an expert in Excel. I can help you in your project. I have made tool for sales in this project. Please have a look: https://www.freelancer.com/projects/excel/High-Level-google-access-excel/reviews Looki Daha Fazla

£500 GBP in 7 gün içinde
(5 Değerlendirme)
3.7
tranloanhanu

Hello, I have rich experience in processing data on Excel. I have read all your explanations carefully and fully understand your requirements. So I am sure I can give you correct and good results. I would appreciate it Daha Fazla

£500 GBP in 7 gün içinde
(3 Değerlendirme)
3.8