Forum Discussion

daniginder's avatar
daniginder
Contributor 2
6 months ago

Forecasting in Jobber Feels Impossible — What Are Other Companies Doing?

Has anyone figured out a solid way to forecast monthly, quarterly, and yearly revenue inside Jobber?

Ever since switching to Jobber, we’ve felt completely in the dark when it comes to forecasting and planning. We base a lot of our company goals around projected monthly, quarterly, and yearly revenue, but the reporting tools seem heavily focused on completed work only — not future scheduled work.

We’ve tried:

  • Pulling Visits reports (not very accurate for forecasting revenue)
  • Separating recurring vs one-off work (also not very accurate)
  • Looking through Insights/dashboard reports

But we still can’t get a clear picture of:

  • Forecasted revenue
  • Upcoming scheduled revenue
  • Total jobs scheduled for future months/quarters
  • Number of jobs completed vs upcoming
  • How many jobs we’re actually doing each month

Ideally, we’d love to see:

  • Revenue projections based on scheduled visits/jobs
  • Monthly/quarterly/yearly forecasting
  • Scheduled vs unscheduled work totals
  • Job counts by month
  • A future-facing reporting dashboard

Right now it feels like all the reports only show historical/completed numbers, which makes planning really frustrating.

What are other companies doing for forecasting inside Jobber? Are you using a workaround, exporting reports to spreadsheets, integrating with another software, or using a marketplace app?

Would really appreciate hearing how others are handling this because we can’t be the only company struggling with this.

6 Replies

  • AnthonySalazar's avatar
    AnthonySalazar
    Verified Community Coach

    I’ve run into the same limitation.

    Jobber is really strong for operating the business, but I don’t rely on the built-in reporting alone for forward-looking forecasting.

    What I’ve done instead is pull Jobber data into custom dashboards and reporting tools so I can look at things the way I actually run the business.

    For me, that means things like recurring revenue, active clients, route capacity, visit volume, revenue by day, churn, and other KPIs that help me see what’s coming instead of only what already happened.

    I’ve also used Claude to help build some of that reporting and automate parts of the admin work around it.

    So my workaround has basically been:

    Use Jobber as the source of truth for the operational data, then build the forecasting layer outside of it.

    I’d love to see Jobber eventually add stronger future-facing reporting around scheduled revenue, recurring work, capacity, and projected monthly revenue because I agree, that would make planning a lot easier inside one system.

    • daniginder's avatar
      daniginder
      Contributor 2

      Thanks for this! This is actually the same work around that we have figured out.  We designed a custom dashboard that allows us to track all of the metrics that jobber seems to lack.  For sure would be nice to have it all within the CRM software, but it is nice to have it as an option through the custom dashboard!

      • AnthonySalazar's avatar
        AnthonySalazar
        Verified Community Coach

        I don't think there will ever be a one stop shop solution for all the metrics within one system because there's so many things connected now. Going down the custom dashboard route seems like to right move!

  • travisshepherd's avatar
    travisshepherd
    Verified Community Coach

    This is one of the most common pain points field service owners hit once they start scaling, so you are definitely not alone. Jobber’s native reporting is heavily designed around historical accounting—looking at what was visited, completed, or invoiced—rather than acting as a forward-looking revenue pipeline tool.

    ​Because Jobber doesn’t natively calculate future booked revenue by custom date ranges out of the box, established companies handle forecasting using three primary approaches.

    ​Since Jobber’s Insights tab won't aggregate uncompleted future visits into monthly revenue buckets, most owners export raw data into Excel or Google Sheets. They start by exporting the Jobs Report or Visits Report including all active and scheduled jobs. Next, they filter by Scheduled Date or Visit Date, sum the line-item total values by month, and separate one-off jobs from recurring jobs. For recurring work, it helps to group jobs by billing frequency (like monthly versus per-visit billing) so the spreadsheet formula multiplies visit counts correctly rather than double-counting contract 

    ​If exporting CSV files every week feels too manual, companies rely on direct integrations through the Jobber Marketplace or API connections to automated dashboards. For instance, if your quotes and jobs convert directly into delayed or scheduled invoices in QuickBooks Online or Xero, you can leverage their native cash flow and forecasting projection tools. Alternatively, you can connect Jobber to a business intelligence dashboard like Geckoboard or Power BI via Zapier or the Jobber API. When a job is marked as scheduled, the system pushes the job value and scheduled completion date into a live spreadsheet or dashboard to build auto-updating future pipeline charts.

    ​If you want true forecasting to predict revenue before a job is even accepted, Jobber’s Quotes report can be adapted. You can track total pending quotes grouped by sent date, then apply your historical close rate percentage—such as multiplying pending volume by your average close rate—to estimate upcoming revenue to stack on top of your already-scheduled job volume.

  • amirseg's avatar
    amirseg
    Contributor 2

    You're not the only one; there's a "Projected revenue" thread on here asking the same thing. Two workarounds that work today:

    1. In Reports → Visits, set the date range to the future (next week, rest of month), filter to not completed, and total the price column. That's your scheduled revenue. Recurring visits are already generated into the future, so they show up.

    2. Export that same report to CSV and pivot by week in a spreadsheet. If you add a column for "client start date" you also get churn visibility, which the dashboard never shows.

    The limitation is that it only knows about scheduled visits, so one-off quotes in the pipeline aren't in it. Some people add approved-but-unscheduled quotes manually.

    Separate question, since you're clearly digging into the reports: once you can see the revenue coming, do you also know which of those scheduled visits are actually profitable after drive time and labor? That's the gap I keep running into with the Visits export and I'm curious whether it matters to you as much as the forecast does.

  • One thing that helps even by hand: build the forecast from two numbers per week. Scheduled recurring visits times your average visit value, plus one-off jobs at their quoted amount. It's rough, but it looks forward, and comparing it with actual invoices each month tells you how far off it runs.

    I set this up for Jobber users as a nightly sync into your own Google Sheet, with forecast vs actual by week, month and quarter. Recurring cleaning pricing is the part I'd test on real data before promising anything. Open to trying it on your account? Read-only, and you can revoke access any time.