If you’ve ever second-guessed a revenue report in HubSpot, you’re not alone. Maybe it looked right at first glance, but then a rep moved a deal, or a pipeline update threw everything off. Suddenly, your trusted dashboard doesn’t match the numbers in accounting. That disconnect slows decisions, breaks forecasts, and forces your team to spend hours in spreadsheets instead of selling.
Here’s the issue: HubSpot has robust reporting tools, but unless your inputs are rock-solid, including deal stages, close dates, and deal amounts, your outputs won’t be trustworthy. You need more than just effort to fix this. You need precision.
In this guide, you’ll learn how to configure revenue tracking in HubSpot the right way. You’ll understand how HubSpot calculates revenue, how to avoid the setup traps that throw off your numbers, and how to build reports that give your sales and RevOps teams real clarity. By the end, you’ll have a practical, technical workflow you can use to confidently measure revenue across your funnels.
Step-by-Step Guide for Tracking and Reporting on Total Revenue Within HubSpot
Revenue reporting in HubSpot helps you track actual income based on the deals your team creates and closes. At its core, it’s about using the Amount field inside the Deals object to understand where revenue is coming from, how it trends over time, and what’s driving the results.
You’ll create these reports inside HubSpot by navigating to Reports > Reports > Create Report, selecting Deals as your object. From there, you can pull in standard fields like Deal Stage, Close Date, and Deal Owner, and optionally, map in custom ones such as Forecast Category or Revenue Source for deeper segmentation.
If you’re on HubSpot’s Professional or Enterprise plan, the built-in Revenue Analytics Tool visualizes this data across teams, giving you interactive dashboards for closed revenue totals, trends, and forecasts. It ties directly into your sales dashboards and, if enabled, your forecast tool.
If you connect HubSpot to payment infrastructure or subscription engines, that financial data automatically enhances revenue reporting. This reduces the need for manual updates and increases accuracy.
How It Works Under the Hood
The accuracy of your revenue reports rests on one foundation: clean deal records. Every time a rep creates or updates a deal, HubSpot uses the Amount, Close Date, and Deal Stage to determine what appears in your reports. If any one of these is missing or outdated, the numbers won’t match reality.
Here’s how deals flow through the system:
- A lead converts and enters your pipeline.
- Someone records the expected deal value and projected close date.
- The deal moves through stages until it’s Closed Won.
- HubSpot logs the Closed Won value using the amount and close date for reporting.
HubSpot lets you slice this data across pipelines, reps, regions, and time periods. Depending on your reporting needs, you can also:
- Use Weighted Pipeline Revenue to project revenue based on probabilities for each deal stage.
- Add Forecasting Columns sourced from your stage calculations.
- Integrate Recurring Revenue Add-ons to report on monthly or annual contracts instead of just lump sums.
Output formats include area or bar charts that show MRR growth, pipeline-specific revenue trends, or rep-by-rep breakdowns. All can be routed into custom dashboards and auto-refreshed daily.
Main Uses Inside HubSpot
Forecasting Future Sales Revenue
You can’t afford poor forecasting. HubSpot helps you estimate future revenue by weighting open deals based on their pipeline stage.
For example, Build a “Forecast Amount by Close Date” report that multiplies deal values by probabilities like 60% for proposals or 80% for contracts sent. This helps you see expected revenue in the next 30 to 90 days, spot gaps early, and ramp efforts where needed.
Tracking Closed-Won Revenue Over Time
To assess actual sales performance, use reports that filter only Closed Won deals and organize them by close date.
For example: A RevOps manager sets up a monthly revenue report split by rep. The result? Clarity on who’s delivering, where peaks or slumps occur, and how to rebalance efforts.
Comparing Pipelines or Teams
If your company has multiple sales lines, such as enterprise, partner, or renewals pipelines, keeping their performance isolated is important.
For example: A “Revenue by Pipeline” report shows that enterprise deals bring larger values, but renewals convert faster. With this view, you can allocate marketing, sales training, or headcount accordingly.
Evaluating Campaign-Driven Revenue
You don’t just want to know which marketing campaigns generate leads; you want to know which ones drive revenue.
For example: By using the “Original Source” property and associating deals to campaigns, HubSpot can produce a “Revenue by Campaign” report. You can compare performance from webinars, paid ads, and email sequences to guide future spend.
Common Setup Errors and Wrong Assumptions
Missing deal amounts
If reps skip the Amount field, your revenue reports miss those deals altogether. Set workflows to require an amount or alert when it’s left blank.
Incorrect close dates
Some reps let the create date double as the close date. That skews timing in your monthly or quarterly reports. Always have the close date update when a deal moves to Closed Won.
Multiple currencies ignored
If you’re selling across markets, deal amounts need to be standardized. Set a company default currency and convert before aggregating reports, or you’ll inflate or deflate totals without realizing it.
Relying only on manual data entry
Reps often forget to update deal data. Instead, try linking HubSpot’s Products tool to deals or build workflows that update values once a key event, like a signed quote, occurs.
Confusing pipeline filters
It’s easy to forget to segment by pipeline, especially in portals with multiple sales flows. Always filter reports by the correct pipeline, or you risk blending unrelated business units.
Step-by-Step Setup or Use Guide
- Go to Reports > Reports > Create Report
Start here for any custom report tied to the CRM object “Deals.”
- Select Single Object > Deals
You’re working only with the Deals object, which holds the revenue info.
- Choose Deal Amount, Deal Stage, and Close Date
These fields are required to calculate revenue by time or status.
- Apply filters
Set filters like “Deal Stage = Closed Won” and “Close Date = This Quarter” to isolate actual earned revenue.
- Add a visualization
Use a line, area, or bar chart to show revenue by week or month trends. Tables work great for granular comparisons.
- Adjust format settings
Set the operation to “Sum of Amount,” group by “Close Date by month,” and choose relevant sorting.
- Save the report
Give it a useful name (e.g., “Closed Revenue Last Quarter by Owner”) and save it to your team’s dashboard.
- Automate distribution
Set the report to send weekly or monthly to stakeholders, so the right people always have current results.
Optional upgrades:
- Add custom dimensions like “Industry” or “Contract Type” to break down revenue across segments.
- Use “Weighted Amount” for forecasting workflows.
- Integrate with the Forecast Tool (Enterprise only) for a full pipeline vs. outcome match-up.
Measuring Results in HubSpot
Your report is set up, but is it helping you make the right decisions? Here’s how to validate data quality and keep performance in check:
- Match closed revenue to accounting: Spot-check your HubSpot totals against billing tools or finance records to ensure alignment.
- Monitor deal stage conversion: See how many deals convert from proposal to close to understand funnel health.
- Track revenue by rep: See who’s hitting targets, where performance is lagging, and what quota adjustments are needed.
- Measure time to close: Add “Days to Close” as a metric to identify long sales cycles or friction points in the funnel.
- Audit forecast accuracy: Compare projected revenue (weighted pipeline) with the actual closed numbers each month.
Recommended dashboards:
- Revenue Dashboard: Clarity on total closed revenue by time period and team.
- Forecast Dashboard: Highlights whether your pipeline matches target expectations.
- Sales Performance Dashboard: Combines deals closed, revenue earned, and stage movement into one view.
Ideally, your RevOps team reviews forecasts and closed revenue weekly, with a deeper monthly review tied to pipeline metrics and booking goals.
Short Example That Ties It Together
Take a SaaS company with two deal pipelines: “New Business” and “Renewals.” The RevOps lead builds two distinct reports. One shows Closed Won amounts by month for new business. The other tracks renewal revenue by deal rep.
Because Close Dates and Amounts are required fields, HubSpot automatically populates both reports as reps close deals. Every week, managers check these dashboards in leadership meetings. If fields are blank, workflows send reps a reminder to complete them.
This setup removes the need for Excel cleanups. Everyone trusts the same numbers, sees performance trends clearly, and makes strategic decisions without waiting for manual follow-ups.
How INSIDEA Helps
Building solid revenue reports in HubSpot isn’t just about clicking through menus. If your CRM data is messy, or your deal properties aren’t aligned with how finance tracks revenue, you’ll end up chasing fixes instead of forecasting growth.
That’s where INSIDEA comes in. Our HubSpot-certified experts specialize in aligning data, automation, and reporting, so revenue insights come standard.
Here’s how we help:
- Smart onboarding: We set up deal pipelines, stages, and permissions from the start to eliminate reporting misfires later.
- Ongoing management: We maintain data hygiene, enforce data entry best practices, and ensure dashboards stay relevant.
- Automation support: We build workflows that auto-update deal records based on contract activity, signatures, or integrations.
- Cross-platform alignment: We connect HubSpot’s deals, reports, and campaigns to your finance tools so RevOps, sales, and accounting all work from the same source of truth.
Curious how better revenue reporting could support your team? Explore what INSIDEA can do, talk to the consultants, or check out INSIDEA’s HubSpot consulting services.
