Precision Revenue Reporting in HubSpot: Filtering Closed-Won Deals by Year and Type

For growth teams, accurate and granular revenue reporting is paramount. While HubSpot provides robust tools for tracking sales performance, isolating specific types of 'Closed Won' revenue—such as new logos or incremental expansions from a particular year, while excluding renewals or deals from prior periods—can present a nuanced challenge. This article explores best practices for achieving this precision, leveraging HubSpot's reporting and automation capabilities.

The Challenge: Isolating Specific Revenue Streams

Many organizations need to differentiate between various forms of 'Closed Won' revenue. A common scenario involves a growth team focused on new business and expansions, requiring reports that sum total deal revenue for the current year, specifically excluding renewals or deals closed in previous years. Standard 'Closed Won' reports often aggregate all deals, making it difficult to extract the specific data needed for forward-looking forecasts or performance analysis.

Attempting to solve this with simple calculated properties often hits a roadblock: HubSpot's calculated properties currently lack the ability to filter by date ranges on associated records. This limitation necessitates a more sophisticated approach, combining intelligent reporting strategies with advanced automation.

Solution 1: Precision Reporting with HubSpot's Custom Report Builder

The most straightforward and often sufficient method for generating specific revenue reports is to utilize HubSpot's custom report builder. This approach allows for powerful filtering and aggregation, providing the exact data needed for dashboards and strategic insights.

Step-by-Step Reporting for Current Year's Closed Won Deals:

1. Navigate to Reports: In HubSpot, go to Reports > Reports > Create custom report.
2. Select Report Type: Choose 'Single object' and select 'Deals'.
3. Configure Data:
   • X-axis: Consider 'Close Date' (Month/Year) if you want to see monthly breakdown, or simply omit if you only need a total sum.
   • Y-axis: Select 'Amount'. Ensure you select 'Sum of Amount' as the aggregation type.
   • Group by: To see revenue per client, select 'Associated Company'.
4. Apply Filters: This is the critical step for precision:
   • Deal Stage: Filter for 'is any of' > 'Closed Won'.
   • Close Date: Filter for 'is in the calendar year' > 'This year' (or 'Next year', 'Last year' depending on your needs).
   • Deal Pipeline: To exclude renewals or differentiate between new business and expansions, filter by specific pipelines. For example, 'Deal Pipeline is any of [New Business Pipeline Name], [Expansion Pipeline Name]'. If you don't use separate pipelines for new business vs. renewals, consider creating a custom 'Deal Type' property (e.g., 'New Business', 'Renewal', 'Expansion') and filtering by that instead.
5. Save and Analyze: Save your report and add it to a dashboard.

Important Note on Currency: If your HubSpot portal uses multi-currency, ensure your report aggregates 'Amount in Company Currency' to avoid discrepancies caused by fluctuating exchange rates or mixed currency totals.

Solution 2: Advanced Roll-up with Custom-Coded Workflows for Company-Level Properties

While reports are excellent for dashboards, you might need a property directly on the company record that reflects the current year's Closed Won revenue. As mentioned, standard calculated properties can't filter by date on associated deals. For this, a custom-coded workflow offers a powerful solution.

How a Custom-Coded Workflow Works:

This approach requires some technical expertise or a developer, as it involves custom code executed within a HubSpot workflow. The workflow would typically:

1. Enrollment Trigger: Enroll deals when their 'Deal Stage' changes to 'Closed Won'.
2. Custom Code Action: Execute a custom code action (serverless function) that performs the following logic:
   • Identifies the 'Associated Company' for the 'Closed Won' deal.
   • Queries all 'Closed Won' deals associated with that company.
   • Filters these deals further by 'Close Date' falling within the current fiscal year.
   • Filters by 'Deal Type' or 'Pipeline' to include only new business or expansions.
   • Sums the 'Amount' of all qualifying deals.
   • Updates a custom 'Number' property on the associated company record (e.g., 'Current Year New Business Revenue') with this calculated sum.

This method ensures that each company record dynamically displays its relevant, filtered 'Closed Won' revenue for the current period, providing immediate context for account managers and sales teams.

Considering HubSpot's Built-in Forecast Tool

For teams focused on future revenue projections and actively managing sales forecasts, HubSpot's built-in Forecast tool can be a valuable asset. This tool allows sales managers to set quotas, track progress, and generate forecast reports. While it doesn't directly address the historical filtering of 'Closed Won' deals to exclude renewals or past years' revenue in the same way custom reports do, it provides a structured framework for sales teams to submit and manage their ongoing revenue predictions.

Best Practices for Data Integrity

Regardless of the method chosen, maintaining clean and consistent data in HubSpot is critical:

• Clear Pipeline Definitions: Establish distinct deal pipelines for 'New Business', 'Renewals', and 'Expansions' if these are key differentiators for your reporting.
• Custom Properties for Deal Type: If separate pipelines are not feasible, create a custom 'Deal Type' property (e.g., dropdown select with 'New Business', 'Renewal', 'Upsell') on the deal object and ensure sales teams consistently use it. This property can then be used as a filter in your reports.
• Consistent Close Date Usage: Emphasize the importance of accurate 'Close Date' entry for all deals.

Achieving precise revenue reporting in HubSpot requires a thoughtful approach to data structure and leveraging the platform's advanced reporting and automation features. By implementing custom reports with targeted filters or, for more advanced needs, custom-coded workflows, growth teams can gain unparalleled clarity into their performance, isolating the specific revenue streams that drive strategic decisions.

Accurate revenue reporting is crucial for strategic decision-making, just as effective inbox management is vital for operational efficiency. By leveraging HubSpot's reporting and automation capabilities, teams can ensure their financial data is clean and actionable. This precision extends to every aspect of operations, including maintaining a clean CRM and preventing spam contacts from skewing data, ensuring that your shared inbox management remains streamlined and free from irrelevant noise, often aided by an automatic spam filter.