Skip to content
Elison Maclaud | 22 July, 2025

How We Built a Custom Revenue Forecast Report in HubSpot

Accurate forecasting is critical — but many businesses hit a wall when trying to get month-over-month revenue projections in HubSpot. Native reporting has its limits, especially for subscription-based or multi-phase revenue models. That’s where our team at Unlimited Tech Solutions comes in.

In this walkthrough video, we’ll show you a custom revenue forecast report built by our HubSpot experts — tailored to handle everything from probability-weighted forecasts to contract-specific terms and multi-location revenue views.

 

📺 Watch the video walkthrough below to see it in action.

 

 

The Challenge: Native Forecasting Limitations

While HubSpot’s beta revenue report offers a helpful view of closed-won deals over time, it doesn’t address some of the most common forecasting needs, including:

 

  • Month-over-month projections that include open deals.
  • Forecasting based on probability-weighted values.
  • Support for multi-month contract terms and recurring revenue models.
  • Filters that reflect how the business actually segments revenue.

For businesses operating on subscription models, long-term projects, or regional pipelines, the lack of flexibility makes strategic forecasting nearly impossible without external tools.

 

The Custom Solution

Unlimited Tech Solutions built a custom forecast report that works seamlessly inside HubSpot — no exports, spreadsheets, or external tools required. Here's how it works:

 

Parent + Child Deal Architecture

Each primary deal (the “parent”) contains the standard details — amount, term length, start date, and probability. From this, a set of child deals is automatically generated to represent monthly revenue installments across the contract period.

 

Real-Time Updates

When the parent deal is updated — whether it's the value, timeline, term, or probability — the report recalculates automatically. No manual updates or maintenance needed.

 

Combined Forecast View

The dashboard clearly separates:

 

  • Closed-Won Revenue: Represented as actuals by month

  • Open Pipeline: Shown as probability-weighted forecasts
    This dual view enables sales and revenue teams to quickly understand both what's booked and what’s likely to close.

 

Advanced Filtering

Because the report references both parent and child deals, users can filter forecasts by key properties inherited from the parent such as:

 

  • Region or territory

  • New vs. existing business

  • Product line or service type

  • Any custom HubSpot property

 

Fully Native to HubSpot

This entire solution operates within HubSpot. Teams can continue using the CRM as usual — the forecasting layer runs quietly in the background, delivering clean, reliable data with no disruption to daily workflows.

 

Screenshot 2025-07-22 at 12.27.14 PM

 

Who It's For

This custom forecast report is ideal for businesses that need more than just static reporting. It supports a wide variety of use cases across industries:

 

  • SaaS – Forecast MRR/ARR based on contract terms

  • Marketing Agencies – Visualize recurring retainers vs. one-time projects

  • Construction & Engineering – Spread large project revenue across build phases

  • Franchises – Track performance across regions or locations

  • MSPs & IT Services – Monitor monthly recurring revenue and renewals

  • Nonprofits – Plan around funding periods, grants, or program timelines


Why It Matters

A forecast should reflect the real structure of your revenue, not just what the CRM is capable of reporting. This custom-built solution brings flexibility, automation, and visibility into the forecasting process — unlocking true revenue intelligence inside HubSpot.

If your team is running into limitations with native reporting, Unlimited Tech Solutions can help. This report is just one example of how their experts create scalable, custom-built systems tailored to your business model.

 

Ready to see it live?
Book a demo to talk with the team and explore what’s possible inside your HubSpot portal.


 

Elison Maclaud

Elison Maclaud

Elison Maclaud Barbeta-Comstock is a HubSpot Consultant and seasoned inbound marketing specialist with over 5 years of hands-on experience. As a HubSpot Certified Trainer, he has empowered businesses of all sizes to unlock the full potential of their CRM platforms by simplifying complex marketing strategies and delivering clear, actionable insights.

Explore More On The Blog

Thomas Richard 07 February, 2023

Salesforce vs. HubSpot: Why I Moved 120 Sales Reps To HubSpot

Salesforce and HubSpot are two of the most popular CRMs on the market today. Both offer a powerful...

Selim Maalouf 22 October, 2024

The Power of HubSpot’s UI Extensions: Enhancing Your App Experience

As part of HubSpot's recent feature updates, the introduction of user interface (UI) extensions...

Selim Maalouf 27 November, 2024

Why You Should Bring Your Team to INBOUND 25

Let’s face it: remote work is amazing until it isn’t. Sure, you’ve mastered the art of the “can you...

Diamond Partner Badge

We Take HubSpot Further

As a certified HubSpot solutions partner, we've helped clients across multiple industries build innovative solutions on the HubSpot platform, align marketing and sales, launch high-performance websites and boost growth. Want in?