Create Line Item Revenue Reports in HubSpot

HubSpot gives you powerful reporting tools to understand how each product and service drives revenue. By building line item revenue reports, you can analyze product performance, pricing, and revenue trends at a granular level, and connect that data back to your deals and sales pipeline.

This step-by-step guide walks you through how to use the custom report builder to create detailed line item revenue reports, what each field means, and how to structure your data for accurate results.

Before You Build Line Item Reports in HubSpot

To get accurate revenue insights, make sure your CRM and product library are properly configured. Line item reporting in HubSpot depends on the relationship between deals and associated line items.

• Confirm that your products and services are created in the product library.
• Ensure deals have associated line items with correct prices and terms.
• Verify that users have permission to access deals, products, and reports.

If you need help with broader CRM or reporting strategy beyond this tutorial, you can also explore consulting resources such as Consultevo for additional guidance.

Understanding Line Item Revenue Data in HubSpot

When you create a revenue report with line items, the custom report builder pulls data from several objects. In HubSpot, line items represent the individual products or services attached to a deal, and each one contributes to deal revenue.

Key objects and properties used in these reports include:

• Deals – carry overall pipeline information such as stage, close date, and amount.
• Line items – store product-level details such as price, quantity, and billing terms.
• Products – define reusable catalog entries that can be added as line items.

Because line items roll up to deals, the same closed won deal can appear more than once in a report when it includes multiple products. Understanding this relationship helps you interpret totals and avoid confusion when you see duplicate deal names in a table.

How to Create a Line Item Revenue Report in HubSpot

Use the custom report builder to combine deal and line item data into a single, flexible report. Follow these steps inside your HubSpot account:

Step 1: Open the Custom Report Builder in HubSpot

1. In your HubSpot account, go to Reports > Reports.
2. Click Create report.
3. Select Custom report builder to start a new report.

The custom report builder lets you combine multiple data sources and gives you full control over filters, fields, and visualizations.

Step 2: Choose Deals and Line Items as Data Sources

1. In the data source selection panel, choose Deals.
2. Add Line items as an additional data source.
3. If available and relevant, you can also connect Products to analyze product catalog data.

This combination ensures that your report can display deal-level properties such as deal stage and pipeline, alongside line item properties such as unit price and quantity.

Step 3: Add Revenue and Line Item Fields in HubSpot

Next, select the fields that will power your revenue analysis. Typical fields from HubSpot objects include:

• From Deals
  • Deal name
  • Deal stage
  • Pipeline
  • Close date
  • Amount
• From Line Items
  • Line item name
  • Product name
  • Price
  • Quantity
  • Term, billing frequency, or discount (if configured)

Drag and drop these fields into the report canvas. You can add them to the Display section or use them in Filters and Breakdowns, depending on the visualization type you choose.

Step 4: Configure Filters for Accurate HubSpot Revenue Data

Filters make sure you only include the deals and line items that matter. In HubSpot, some of the most useful filters for revenue reporting include:

• Deal stage – for example, only show Closed won deals.
• Close date – restrict results to a specific month, quarter, or year.
• Pipeline – focus on one pipeline or compare multiple pipelines.
• Product or line item name – report on specific products or product families.

To configure a filter:

1. In the report builder sidebar, click Add filter.
2. Select the property (for example, Deal stage).
3. Set the condition (such as is any of > Closed won).
4. Apply the filter and confirm that your chart or table updates accordingly.

Step 5: Select a Visualization for HubSpot Line Item Revenue

Once your data and filters are set, pick a visualization that best represents your revenue:

• Table – ideal for detailed lists of deals and line items, including price and quantity.
• Column or bar chart – great for comparing revenue by product, owner, or pipeline.
• Line chart – useful for tracking revenue over time (by close date or create date).
• Pie or donut chart – for high-level breakdowns, such as revenue share by product.

HubSpot lets you switch between visualization types as you refine your report, so you can test different layouts until the insights are clear.

Common Ways to Analyze Line Item Revenue in HubSpot

With the report configured, you can answer several key revenue questions. Here are common use cases for line item reports in HubSpot:

Revenue by Product or Line Item

To see which products or services generate the most revenue:

• Use a table or bar chart.
• Break down by Product name or Line item name.
• Summarize by total amount or total price multiplied by quantity.

This helps you identify top-selling items and products that may need more promotion or adjustment.

Revenue by Deal Owner with Line Item Detail

To compare performance across sales reps in HubSpot while still seeing product detail:

• Break down your report by Deal owner.
• Add line item fields to the table so you can see which reps sell which products.
• Filter by close date to compare specific periods.

This reveals not only which owners close the most revenue, but also which product combinations drive their success.

Revenue Trends Over Time

To understand how revenue is changing across months or quarters:

• Use a line chart.
• Set the X-axis to Close date and group by month or quarter.
• Apply a filter for Closed won deals.
• Optionally break down by product or line item to see category-level trends.

HubSpot time-series visualizations make it easy to spot growth patterns and seasonality in your product revenue.

Tips for Reliable Line Item Revenue Reporting in HubSpot

To maintain accurate and consistent reports, keep these best practices in mind:

• Standardize product setup – define consistent names, SKUs, and pricing in the product library.
• Train sales teams – ensure users always add the correct line items instead of manually editing deal amounts.
• Review associations – confirm that deals are correctly associated with line items before closing.
• Validate totals – periodically compare report totals to expected revenue from your pipeline.

When everyone follows the same process in HubSpot, your line item reports will better reflect real business performance.

Learn More About Line Item Reporting

If you want deeper reference documentation, you can read the original product instructions in the HubSpot knowledge base here: How to create line item revenue reports. Combining that resource with the steps in this article will help you configure, refine, and scale your revenue analytics with confidence.

By setting up thoughtful line item revenue reports in HubSpot, you gain clear visibility into which products drive growth, where to optimize pricing and packaging, and how your sales team can focus on the most profitable opportunities.

Need Help With Hubspot?

If you want expert help building, automating, or scaling your Hubspot , work with ConsultEvo, a team who has a decade of Hubspot experience.

Scale Hubspot

“`