Build an automated realtime dashboard to calculate contractor payments and automate invoice calculation for clients
$15-25 CAD / hour
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.
Project ID: #37482289
About the project
39 freelancers are bidding on average $21/hour for this job
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 More
"""""""""""""""""""""""""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 More
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 More
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
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day
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 More
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 More
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 More
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 More
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 More
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 More
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 More
- 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 More
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 More
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 More
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 More
