Build an automated realtime dashboard to calculate contractor payments and automate invoice calculation for clients

Suljettu Julkaistu 2 kuukautta sitten Maksettu toimituksen yhteydessä
Suljettu

I am looking for a skilled freelancer who can build an automated realtime dashboard for our company. The dashboard will be used to calculate contractor payments and automate invoice calculations for our clients.

1. Payroll Calculation

Need to automate payroll calculation for each driver based on:

-WooDelivery outputs

-Delivery fee based on location (Some variances for each driver)

-Pick-up fees (unique to some drivers)

Need to have a real-time dashboard that drivers can individually access how much they’ve made in real-time based on the inputs from the Woo Delivery platform.

2. Need to automate invoice calculation for each pharmacy client. Need to take completed tasks from WooDelivery and create a calculation for the fees generated based on delivery location. Each pharmacy has a different fee structure for deliveries.

Ideally, these calculations would be able to auto generate a monthly invoice based on all of the inputs. Namely, Pharmacy Name; Delivery fee by location; and number of deliveries to a specific location.

Preferred Platform:

- The client has expressed a preference for using Excel as the platform for building the dashboard, but open to other ideas as well.

Ideal Skills and Experience:

- Proficiency in Excel and experience in building automated dashboards

- Experience with WooCommerce but specifically, WooDelivery Platform and Zapier

- Knowledge of contractor payment calculations and invoice automation

- Strong attention to detail and accuracy in calculations

- Ability to customize the dashboard to meet unique delivery fee requirements based on location (unique to each pharmacy)

If you have the skills and experience required for this project, please submit your proposal.

tiedonlouhinta Excel Data Integration

Projektin tunnus: #37482289

Tietoa projektista

39 ehdotusta Etäprojekti Aktiivinen kuukausi sitten

39 freelanceria on tarjonnut keskimäärin $21/tunti tähän työhön

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Lisää

$20 CAD / tunti
(544 arvostelua)
8.4
AccountantArman

"""""""""""""""""""""""""ADVANCE EXCEL DASHBOARD EXPERT/REALTIME DASHBOARD""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATI Lisää

$20 CAD / tunti
(266 arvostelua)
7.3
daniyal3214

Hello, Excel expert here. I can perfectly assist you with this 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, Auto Lisää

$15 CAD / tunti
(229 arvostelua)
7.3
periyannas

Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai

$20 CAD / tunti
(183 arvostelua)
7.0
writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day

$20 CAD / tunti
(255 arvostelua)
6.8
AwaisChaudhry

Hi Good evening , How are you? I just saw your job posting . I see you have been looking for someone experience with these technologies Excel, Data Mining and Data Integration. I believe this is some thing I can help Lisää

$34 CAD / tunti
(1 arvostelu)
6.3
leadconcept

Hi there, Can you please confirm if you want us to create dashboard and integrate it with the Woo Delivery platform to get details from there and then calculate payroll based on the data fetched from the Woo Delivery p Lisää

$25 CAD / tunti
(3 arvostelua)
5.9
arunkumar9896

Hi Hope you are doing good! I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc Lisää

$20 CAD / tunti
(37 arvostelua)
5.5
AmazingEngr76386

Hello Client, my name is Adnan Gohar and I'm an experienced and results-driven professional with extensive knowledge in project management, strategic planning, marketing and data analysis. With a track record of succes Lisää

$20 CAD / tunti
(6 arvostelua)
5.2
dataEntryExperty

I will create real time application to calculate contract and client invoice. Driver can see their payroll projection. All things will be done on real time bases. Alot of website and Web applications are already comple Lisää

$15 CAD / tunti
(16 arvostelua)
3.7
meenumaurya105

I understand that you are looking for a skilled freelancer who can build an automated realtime dashboard for your company. Specifically, you need the dashboard to calculate contractor payments and automate invoice calc Lisää

$20 CAD / tunti
(9 arvostelua)
4.3
ytpaussie

Hello mate Excel Expert Here, I have developed many customised solutions to many businesses via Freelancer and directly. My expertise is in spreadsheet automation using complex formulas and/or VBA/google appscript. Hap Lisää

$25 CAD / tunti
(4 arvostelua)
3.1
UsmanNasar87

Hi, Its Usman Nasar having advance skills in Microsoft Office especially Excel such as Dashboards, Formatting, Charts, Table, Slicers, Macros, Data analysis work, Formulas like Vlookup, Xlookup, Sumifs, Countifs, Index Lisää

$15 CAD / tunti
(21 arvostelua)
3.2
ajamshad162

- I understand that you are looking for a skilled freelancer who can build an automated realtime dashboard for your company. Specifically, you need the dashboard to calculate contractor payments and automate invoice ca Lisää

$20 CAD / tunti
(9 arvostelua)
2.7
lampd0

Hi✅ Good Day Dear Client, I am a highly skilled data analyst and dashboard developer with extensive experience in automating calculations and creating real-time dashboards using Excel and other tools. I am well-verse Lisää

$15 CAD / tunti
(1 arvostelu)
2.0
shahhiral27

Hello there! I'm a clinical research professional with 10+ years of experience in the industry and an Excel expert in building automated processes, data management and visualization, and creating interactive dashboar Lisää

$23 CAD / tunti
(3 arvostelua)
2.1
tangramua

Dear Gave L.,   We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project Lisää

$30 CAD / tunti
(1 arvostelu)
2.1
janaabdullah

Hello, its Jana Ahmad. I am a Python developer with a strong background in computer programming(EXCEL ADVANCE), a huge knowledgeable in software engineering practice, and a great statistical skills. Also, a Performan Lisää

$30 CAD / tunti
(2 arvostelua)
1.7
Nakimp

Hello, I am Nakim and I'm excited to tell you about the services that I can provide for building an automated realtime dashboard for your company. Specifically, I can help build an Excel-based platform that allows driv Lisää

$20 CAD / tunti
(0 arvostelua)
0.0
arsyllanisrina

I can generally compile up to 10 pages of lecture notes per day. I’m interested to hear more about the project and the subject matter of the lectures. If you award me the project, I’d be pleased to discuss this further Lisää

$20 CAD / tunti
(0 arvostelua)
0.0