--- title: Why Your HubSpot Reports Don't Match — and What to Check description: Why HubSpot reports show different numbers, what to check first, and how dates, filters, associations, definitions and data quality affect reporting. --- [Skip to content](https://www.hubflowconsulting.com/hubflow-blog/why-your-hubspot-reports-don-t-match-and-what-to-check#main-content) [![](https://www.hubflowconsulting.com/hubfs/Hubflow_Favourite_Logo_Exact_WhiteBG.svg)Homepage](https://www.hubflowconsulting.com/hubflow-blog/www.hubflowconsulting.com) Get started Get started # Why Your HubSpot Reports Don't Match — and What to Check ![Charlotte Mortimer](https://7528315.fs1.hubspotusercontent-na1.net/hub/7528315/hubfs/raw_assets/public/mV0_d-cms-elevate-theme_hubspot/elevate/images/avatar-placeholder.jpg?width=48&height=48&name=avatar-placeholder.jpg) Charlotte Mortimer September 27, 2026 **Quick answer:** HubSpot reports usually disagree because they are not measuring exactly the same thing. Different date properties, filters, data sources, associations, pipelines or record definitions can all produce different numbers without either report being technically “broken”. The fastest way to troubleshoot it is to stop comparing totals first and compare the **logic behind the totals**. > **Before changing a report:** write the business question it should answer in one sentence. If two reports answer different questions, their numbers should not be expected to match. ## What to check first when HubSpot reports don't match 1. **Question:** are both reports genuinely answering the same business question? 2. **Date property:** are both using close date, create date, activity date or another date consistently? 3. **Filters:** compare pipeline, stage, owner, team and any hidden filters. 4. **Data source:** check which CRM objects each report is built from. 5. **Associations:** confirm the contacts, companies and deals are associated as expected. 6. **Definitions:** check lifecycle stages, pipeline stages and important property values. 7. **Data quality:** look for duplicates, blanks and inconsistent values. ## Start with the question, not the report builder “How many deals did we close last month?” is not the same question as “How much revenue came from marketing-sourced opportunities last month?” Both involve closed deals, but they need different logic. Write down the question, the record type being counted, the relevant date and the filters that should apply. This gives you a simple reporting definition to test both reports against. ## Check the date property CRM records contain several dates. A report using deal close date can legitimately disagree with one using deal create date even when both are filtered to the same calendar month. This is one of the first things I check when troubleshooting reporting: **same period does not necessarily mean same date logic.** ## Compare every filter A pipeline, owner, team, stage or property filter can quietly change the population being measured. Compare filters side by side rather than relying on the report name. Also check whether a dashboard-level filter is affecting one view. A report can be correct in isolation and still display differently in a dashboard context. ## Understand the report's data source A deal-led report and a contact-led report with associated deals are not interchangeable. Associations can change which records qualify and how the data is represented. For revenue questions, start by asking whether the deal itself should be the primary record. For contact engagement questions, contact-led reporting may make more sense. Choose the data source around the question rather than around whichever report template is easiest to find. ## Check record associations If a deal is missing the company or contact association your report expects, it may disappear from a cross-object view. Conversely, one record associated with several other records can affect how a dataset behaves. HubSpot's data-quality and data-model tools are useful here, but the practical check is straightforward: sample a handful of records that should appear and inspect their associations. If association quality is a wider problem, it is worth including it in a [HubSpot portal audit](https://www.hubflowconsulting.com/hubspot-audit-optimisation) rather than patching reports one by one. ## Review pipeline stages and property definitions Reporting is only as consistent as the definitions underneath it. If teams use lifecycle stages differently, pipeline stages no longer reflect real milestones, or the same information is stored in multiple properties, reporting becomes harder to reconcile. This is why good [HubSpot onboarding](https://www.hubflowconsulting.com/hubspot-onboarding) spends time on definitions and data structure before dashboards are built. ## Look for duplicates, blanks and inconsistent values Data quality problems can make perfectly configured reports unreliable. Duplicate records can distort counts; missing associations remove records from some views; inconsistent values fragment what should be one reporting category. Do not just clean the symptom. Work out how the poor data entered the CRM so the same issue does not return after the tidy-up. For migrations and larger data projects, see [HubSpot data migration and cleansing](https://www.hubflowconsulting.com/hubspot-data-migration). ## Create a simple reporting standard You do not need a huge governance document. A useful reporting standard can fit on one page and should record: - the business question each important report answers; - the primary CRM object being counted; - the agreed date property; - standard pipeline, stage and team filters; - definitions for important lifecycle and status fields; - who owns the report and its underlying data; - when the report should be reviewed. > **A good reporting setup is boring in the best possible way:** people know what the number means, where it comes from and why they can trust it. ## When the problem is bigger than one report If several dashboards disagree, teams maintain their own spreadsheets, lifecycle stages are unclear or nobody knows which properties are authoritative, you probably have a portal-foundation problem rather than a report-builder problem. At that point, fixing reports individually creates rework. Review the data model, pipeline structure, definitions and associations first; rebuild the important reporting afterwards. ## Frequently asked questions ### Can two correct HubSpot reports show different numbers? Yes. If they use different objects, dates, filters or definitions, both can be technically correct while answering different questions. ### What should I check first? Start with the business question, then compare date properties and filters. Those checks often explain the difference quickly. ### Can duplicate records affect reporting? Yes. Duplicates, incomplete associations and inconsistent property values can all distort reporting, depending on how the report is built. ### Should I fix the reports or clean the CRM first? If the underlying data and definitions are unreliable, clean the foundations first. Otherwise you may rebuild the same reports again later. Hubflow Consulting helps UK SMEs and growing teams untangle reporting, data and CRM structure without adding unnecessary complexity. If your numbers have become difficult to trust, start with [Audit & Optimisation](https://www.hubflowconsulting.com/hubspot-audit-optimisation) or [get in touch](https://www.hubflowconsulting.com/contact). ## Share this post [mailto:https%3A%2F%2Fwww.hubflowconsulting.com%2Fhubflow-blog%2Fwhy-your-hubspot-reports-don-t-match-and-what-to-check](mailto:https%3A%2F%2Fwww.hubflowconsulting.com%2Fhubflow-blog%2Fwhy-your-hubspot-reports-don-t-match-and-what-to-check) ## Keep reading ### [7 Signs Your HubSpot Portal Needs Cleaning Up](https://www.hubflowconsulting.com/hubflow-blog/7-signs-your-hubspot-portal-needs-cleaning-up) ### [Freelance HubSpot Consultant vs Agency: How to Choose](https://www.hubflowconsulting.com/hubflow-blog/freelance-hubspot-consultant-vs-agency-how-to-choose) [![](https://www.hubflowconsulting.com/hubfs/Hubflow_Favourite_Logo_Exact_WhiteBG.svg)](https://www.hubflowconsulting.com) --- Privacy Policy · Legal · © 2026 Hubflow Consulting. All rights reserved. ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Charlotte Mortimer", "url" : "https://www.hubflowconsulting.com/hubflow-blog/author/charlotte-mortimer" }, "dateModified" : "2026-09-27T19:21:45.382Z", "datePublished" : "2026-09-27T19:21:45.000Z", "headline" : "Why Your HubSpot Reports Don't Match — and What to Check", "mainEntityOfPage" : { "@id" : "https://www.hubflowconsulting.com/hubflow-blog/why-your-hubspot-reports-don-t-match-and-what-to-check", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.hubflowconsulting.com/hubfs/Hubflow_Favourite_Logo_Exact_WhiteBG.svg" }, "name" : "Hubflow Consulting" } } ```