Investor-Ready SaaS Reporting in HubSpot

Every RevOps conversation about HubSpot eventually hits the same wall.

"Our data is clean. Our pipeline is built. But leadership doesn't trust the numbers."

The problem is almost never the data or the pipeline. It's the reporting layer. Specifically, it's the gap between what HubSpot can track natively and what investors and executives actually want to see.

Here's how to close that gap without Enterprise pricing.

What Investors Actually Want to See

Most investor reporting requests come down to four things: MRR/ARR, churn, expansion revenue, and pipeline health. The SaaS metrics that tell the story of whether the business is growing efficiently.

HubSpot doesn't have native MRR or ARR objects out of the box. It also doesn't have a churn dashboard. These aren't HubSpot failures, they're deliberate design choices that assume you'll build your revenue tracking model on top of the CRM.

The good news: you can build everything you need without HubSpot Enterprise or a separate BI tool.

Building MRR Tracking in HubSpot

The foundation of SaaS reporting in HubSpot is deal architecture. Specifically, how you structure the Deal object to capture recurring versus one-time revenue.

The core setup:

• New Business pipeline for first-time customers
• Renewals pipeline for recurring revenue
• Expansions tracked either in a separate pipeline or as a deal type on the Renewals pipeline
• A calculation property for One-Time Revenue (total contract value minus ARR)

This separation lets you build reports that show:

• New MRR by close month
• Expansion MRR separately from new business
• Churned MRR when renewal deals close as lost
• Net Revenue Retention calculated from these three inputs

The calculation isn't complex. The discipline is getting teams to use the pipelines correctly and keep close dates accurate.

Tracking Churn Without a Churn Object

HubSpot doesn't have a native churn object, but you can track churn through the Renewals pipeline.

The model: every customer gets a renewal deal created before their contract end date. If the deal closes as Won, revenue continues. If it closes as Lost, it's churn.

To make this work, you need:

• A Renewals pipeline with a closed lost reason specifically for "Non-renewal / churn"
• Automation that creates renewal deals 90 days before contract end
• A report filtering Renewals pipeline for closed lost deals by close month

This gives you a churn rate report built on real deal data, not manual tracking. For the full setup, read our post on the SaaS HubSpot operating system.

The ARR Dashboard That Actually Works

Once the deal architecture is right, build three reports and one dashboard.

Report 1: New MRR by month. Deal properties: amount (ARR), close date. Filter: New Business pipeline, closed won. Group by: close month.

Report 2: Expansion MRR by month. Same structure, Expansions pipeline or deal type.

Report 3: Churned MRR by month. Renewals pipeline, closed lost, churn reason filter. Amount = the ARR that was lost.

Dashboard: combine all three into a waterfall. Starting ARR + New + Expansion - Churn = Ending ARR. This is what investors ask for in board meetings.

No Enterprise license required. No external BI tool. Just deal architecture and three reports.

Forecasting Without Custom Forecast Categories

HubSpot Enterprise has custom forecast categories. Pro doesn't. If you're on Pro, here's the workaround.

Create a deal property called "Forecast Category" with dropdown values: Commit, Best Case, Pipeline, Omit. Train reps to update this when they update close date.

Build a forecast report grouped by Forecast Category and Stage. Filter to open deals with close dates in the current quarter.

This isn't as elegant as Enterprise's native forecast tool, but it gives leadership a number they can trust without waiting for an upgrade.

What to Build First

If you're starting from scratch, the order matters.

First: get the deal architecture right. Pipelines, deal types, required fields, and closed lost reasons. Without clean deal data, no report will be reliable.

Second: build the churn tracking model. Renewal deals, automation, and a churn reason dropdown.

Third: build the ARR waterfall dashboard. This is the one that gets pulled up in board meetings. Get it right before anything else.

Fourth: add the forecast report. This is for weekly sales reviews, not just quarterly investor updates.

The foundation for all of this is a clean HubSpot implementation with the right deal architecture, and strong HubSpot consulting to make sure the model reflects how you actually run the business.

If your current reporting requires a lot of explanation before anyone trusts it, that's not a communication problem. It's a data architecture problem. Fix the foundation, and the reports fix themselves.