Convert Complex Financial Forecast to Excel Dashboard

Posted yesterday

Worldwide

Summary

I own a residential pest control company and need help rebuilding our annual forecast in Excel. I already have an existing forecast workbook, but I want to simplify it and turn it into a more useful monthly management tool. The goal is to track forecast vs actuals without overwriting the original forecast. I’m looking for someone who can build a clean Excel model that includes: Original annual forecast by month (Sales, Gross margin tracking, net margin tracking.) Monthly actuals input section Current forecast that uses actuals for closed months and forecasted numbers for future months Forecast vs actual variance reporting YTD actuals vs YTD forecast Full-year projected revenue, expenses, and profit Simple dashboard for management review Ability to update the “closed month” each month Clear formatting and instructions so our team can maintain it The business is a service business, so experience with financial modeling, FP&A, recurring revenue, labor planning, and small business forecasting would be helpful. Please include examples of Excel forecasting models or dashboards you have built. I am not looking for just a spreadsheet designer — I need someone who can help think through the structure of the model and make it useful for operating the business.

  • Less than 30 hrs/week
    Hourly
  • < 1 month
    Duration
  • Intermediate
    Experience Level
  • $20.00

    -

    $70.00

    Hourly
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Financial Analysis
Financial Accounting
Nice-to-have skills
Financial Modeling
Accounting
Activity on this job
  • Proposals:50+
  • Last viewed by client:yesterday
  • Interviewing:
    2
  • Invites sent:
    3
  • Unanswered invites:
    1
About the client
Member since Jul 9, 2026
  • United States
    8:02 AM
  • Sales & Marketing
    Mid-sized company (10-99 people)

Explore similar jobs on Upwork

Microsoft Excel
Financial Modeling
Industry Knowledge
Business Plan
Financial Projection
Business Modeling
Business Analysis
Business Process Modeling
Data Analysis
Risk Analysis
Business Plan
Market Research
Business Modeling
Data Analysis
Financial Analysis
Forecasting

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo