Need an Excel Master

I’m looking for an experienced Excel freelancer to improve an existing revenue and payroll workbook for my service company.

Current Setup

We already have an Excel workbook where we record jobs and revenue every day.

Each job has things like:

Date

Client/job name

Job revenue

Our technicians are paid a percentage of the revenue from the jobs they complete, generally between 20% and 30%.

Payroll is paid weekly, and I currently have to manually calculate how much revenue each technician completed and then calculate their percentage every Friday.

What I Need Built

I want to keep my current revenue sheet and add a simple system that connects it directly to a Payroll Calculator sheet.

For every job on the Revenue sheet, I want a Technician dropdown/tag where I can select which employee completed that job.

Example:

DateJob Revenue Technician

8/24 Client A $549 Alex

8/24 Client B $499 Ben

8/24 Client C $200 Aukahi

The employee list should be stored in one location so technicians can easily be added or removed later.

Payroll Calculator

I want a separate payroll page that automatically calculates each technician's numbers for a selected week.

It should show:

Technician name

Technician's pay percentage

Total job revenue completed that week

Number of jobs completed

Percentage payout / commission owed

Any manual adjustments or bonuses

Total weekly payroll owed

For example:

Alex

Weekly completed revenue: $5,000

Pay percentage: 20%

Payroll owed: $1,000

I want to be able to select/change the week start and week end dates, and the payroll totals should automatically update.

Important

I do not want to enter jobs or revenue twice.

The payroll calculator must pull directly from the revenue we are already entering on our existing Revenue sheet.

The finished system should be:

Simple to use

Reliable

Easy for someone without advanced Excel knowledge

Mostly automatic

Easy to add/remove technicians

Easy to change technician pay percentages

Able to handle hundreds/thousands of job rows

Designed so payroll takes only a few minutes to review each Friday

Please use appropriate Excel formulas, tables, dropdowns/data validation, and/or Power Query if necessary.

I will provide the existing Excel workbook. I would prefer that you modify and improve the existing workbook rather than rebuild our entire revenue tracking system from scratch.

Please include examples of similar Excel automation/payroll work you have completed.

Back to blog

Other Jobs To Apply

Remote Customer Support Specialist- Part Time & Full Time

PACS Admin with Site co-ordinator (reputed company and Divrad)

Social Media Lead (m/w/d) | Strategie & Performance | 100 % remote

**Experienced Online Customer Support Specialist – reputed company Chat Support (Remote) – Part-Time Opportunity**

Junior Level/ Entry Level Software Engineer (Remote)

Ramp Agent - Evening Shift

Work from Home Overnight Jobs Late Night Customer Experience Specialist $25-$35/hr ? Enhance customer experiences during late-night hours in a home-based role.

Warehouse Associate - Night Shift- Immediate Hiring

reputed company Careers - Find flexible, work-from-home jobs helping customers while earning $25-$35 per hour.

Call Center Representative- Reno, Nevada- Remote (Any city, NV, US, 99999)

Nurse Consultant (Nursing Home Surveyor)

Warehouse Worker Job at Hayes Company LLC in Forney

SOC Analyst I (Remote)

Remote Part‑Time Customer Service Representative – Flight Operations & Passenger Support – Earn $27/hr at arenaflex

Live Chat Jobs - Remote Position (Up to $35/hour) - No Degree Required, No Experience Necessary

[Remote] DR Systems PACS Administrator / Specialist

-Work From Home Position | Entry-Level | Flexible Hours

Flexible Part-Time Remote Data Entry Specialist | Flexible Hours & Training Provided | Join arenaflex Team

reputed company, Progressive Care, Per-diem

Remote Physical Therapist in ID

Overnight Positions Near Me Online – Non-Phone Digital Chat Role | $25–$35/hr

reputed company RN – Clinical Documentation Specialist – CDIP CCDS Required – 100% Remote, GA

HelpDesk (Customer Support)

Senior Technical Program Manager, Amazon Access - Apply

Entry Level Financial Protection Specialist (Remote)

[Remote] Epic- Clinical Service Desk Specialist-REMOTE

Work from Home as a Game Tester in the United States

Medical Scribe (Remote - Full Time) - Full-time

Part Time Package Handler (Twilight) - YVR Area

Lead Backend Developer – Aviation Systems (Remote, Full-Time)

Remote Cybersecurity Jobs - reputed company

Appeals Nurse (RN) Analyst (670084)

Dealer Development Manager (Nashville, TN)

Entry-Level Data Entry Specialist Remote

Part-Time Remote Typist/Data Entry Clerk

No Experience Necessary | Work from Home Chat Agent Job - $25-$35/hour (Remote), Compensation: $25-$35/hour

**Remote Data Entry Clerk – Part‑Time, Precision‑Focused, Flexible Hours, Global Collaboration**

Remote Product Support Representative (No Degree Required/High Paying)

Entry-Level Data Entry Clerk – No Experience Required – Immediate Start at arenaflex – Grow Your Career in a Dynamic Data‑Driven Environment

**Dedicated Overnight Live Chat Support Agent – Remote, Night Shift Customer Service Specialist with Strong Communication Skills**

**Customer Service & Support Representative – Remote – 6+ Month Engagement – Join arenaflex’s Dynamic Operations & Assurance Team**

Experienced Remote Administrative Support & Data Entry Assistant – Part-Time, Entry Level | Flexible Hours + Great Pay

Weekend Job / Part-time Job - Online Tutor in Türkiye

[Remote] Business Operations Admin

Remote Live Chat & Email Support Specialist – Deliver Outstanding Customer Service from Home, Earn $25–$35 per Hour

Customer Support Jobs No Phone Flexible Schedule – reputed company | $25–$35/hr

**Remote Admin Support - Data Entry Role at blithequark**

**Experienced Customer Support Representative – Night and Weekend Shift – Coppell, TX**

Part-Time Remote Live Chat Support Specialist – No Experience Required, Flexible Hours, Earn Up to $280 Daily

**Experienced Part‑Time Remote Data Entry & Market Research Specialist – Earn Competitive Pay in Paid Focus Groups & Clinical Trials**