---
title: Why your HubSpot dashboard and spreadsheet differ
description: "Why a HubSpot dashboard and a spreadsheet show different numbers: check the metric definition, the date field and hidden filters, then pick one source."
image: https://crmotive.com/hubfs/raw_assets/public/crmotive/images/og-image.png
---
[Skip to content](https://crmotive.com/blog/why-your-hubspot-dashboard-and-spreadsheet-differ#top)
[](https://crmotive.com/)
[Services](https://crmotive.com/services) [Case studies](https://crmotive.com/case-studies) [Reviews](https://crmotive.com/reviews) [Blog](https://crmotive.com/blog) [About](https://crmotive.com/about) [FAQ](https://crmotive.com/help) [Book a call](https://crmotive.com/meeting)
[عربي](https://crmotive.com/ar-eg/blog/why-your-hubspot-dashboard-and-spreadsheet-differ) [Book a call](https://crmotive.com/meeting)
[All posts](https://crmotive.com/blog)
# Why your HubSpot dashboard and spreadsheet differ
ReportingNov 13, 2026, 6:30:50 PMKareem
Why a HubSpot dashboard and a spreadsheet show different numbers: check the metric definition, the date field and hidden filters, then pick one source.
A manager opens the HubSpot dashboard and sees 42 new deals this month. The sales lead opens her spreadsheet and sees 47. Neither number is a mistake. Both of them would be defended in a meeting, and the meeting would last 40 minutes and end without a decision.
When two numbers for the same thing disagree, the cause is usually two definitions of the same metric. Here is how to find the gap, in the order we check things, and how to make sure it stays closed.
## Check the definition
Start with the question that sounds too simple. What counts as a new deal? A deal created in HubSpot, a deal that reached a certain stage, or a deal for a new customer rather than a renewal? What counts as a lead: a form submission, any new contact, or a contact someone has qualified?
Write each definition in one sentence next to the metric, and use the same sentence everywhere. Most gaps close at this step.
## Check the date
Reports can count by create date, close date, last activity date or a custom date field. The same deal lands in a different month depending on which one you choose. A deal created on the 28th and closed on the 3rd belongs to two different months in two different reports.
Also check the time zone. A report and a spreadsheet exported from a different system can place a record that was created near midnight on different days.
## Check the filters
A hidden filter is the most common cause of a gap we find. Open the settings of the report and compare them with the rules the spreadsheet uses. Things to look for:
- A filter on owner, team or pipeline that leaves some deals out.
- A filter on a property that is empty for some records.
- A date range that is relative in one place and fixed in another.
- Whether archived, merged or deleted records are counted in one source and not in the other.
- The currency, if you sell in more than one.
## Check who the record belongs to
If you report by owner, team or company, check how the record gets assigned. A deal that changed owner halfway through the quarter, or a contact linked to two companies, can be counted twice or not at all. This is where a clean data model pays off.
## Why the spreadsheet exists in the first place
A spreadsheet next to a dashboard is a sign that the team does not trust the portal, or that something people need is missing from it. In one portal we worked on, sales were run from spreadsheets, so ad spend could not be compared with deal revenue and campaign performance was hard to measure. We rebuilt the lifecycle and deal pipeline model so the reports could answer the question. You can see the details in the Coursinity case study.
So ask what the spreadsheet does that the dashboard cannot. The answer tells you what to fix in the portal.
## Pick one source and retire the other
Once the numbers match, decide which source is official and say so. Two sources of truth will drift apart again. Move the useful part of the spreadsheet into HubSpot, share the dashboard instead of sending a file, and switch the spreadsheet off.
## A short metrics sheet
Keep one page, in HubSpot or a shared document, with a row for each key metric.
- The name of the metric.
- The definition in one sentence.
- The date field it uses.
- The filters that always apply.
- Who owns it.
- The report that is the official version.
It looks like paperwork, and it ends most arguments before they start. If your numbers still disagree after these checks, the problem is probably in the structure underneath, and that is what an audit finds. Tell us which number you cannot trust.
## Keep reading
- [HubSpot analytics and dashboards](https://crmotive.com/services)
- [Case study: Coursinity](https://crmotive.com/case-studies/coursinity)
In this article
## Book a diagnostic call about your HubSpot portal
Tell us what is going wrong, such as reports that disagree or workflows that collide. We will tell you where to start.
[Book a diagnostic call](https://crmotive.com/meeting)
Architecting Systems. Accelerating Revenue.
[Book a call](https://crmotive.com/meeting)
- [kareem@crmotive.com](mailto:kareem@crmotive.com)
- [crmotive.com](https://crmotive.com)
- [LinkedIn](https://www.linkedin.com/company/crmotive)
- [Services](https://crmotive.com/services)
- [Case studies](https://crmotive.com/case-studies)
- [Reviews](https://crmotive.com/reviews)
- [Blog](https://crmotive.com/blog)
- [About](https://crmotive.com/about)
© 2026 CRMotive HubSpot, Odoo, lemlist, MigrateMyCRM and Coefficient are trademarks of their owners.
[Book a call](https://crmotive.com/meeting)
```json
{
"@context" : "https://schema.org",
"@id" : "https://crmotive.com/#org",
"@type" : [ "Organization", "ProfessionalService" ],
"address" : {
"@type" : "PostalAddress",
"addressCountry" : "EG",
"addressLocality" : "Alexandria"
},
"areaServed" : "Worldwide",
"email" : "kareem@crmotive.com",
"image" : "//47990825.fs1.hubspotusercontent-na1.net/hubfs/47990825/raw_assets/public/crmotive/images/og-image.png",
"knowsLanguage" : [ "en", "ar" ],
"logo" : "//47990825.fs1.hubspotusercontent-na1.net/hubfs/47990825/raw_assets/public/crmotive/images/crmotive-mark-color.svg",
"name" : "CRMotive",
"sameAs" : [ "https://www.linkedin.com/company/crmotive", "https://ecosystem.hubspot.com/marketplace/solutions/crmotive" ],
"url" : "https://crmotive.com/"
}
```
```json
{
"@context" : "https://schema.org",
"@id" : "https://crmotive.com/#website",
"@type" : "WebSite",
"inLanguage" : [ "en", "ar" ],
"name" : "CRMotive",
"publisher" : {
"@id" : "https://crmotive.com/#org"
},
"url" : "https://crmotive.com/"
}
```
```json
{
"@context" : "https://schema.org",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Kareem",
"url" : "https://crmotive.com/blog/author/kareem"
},
"dateModified" : "2026-11-13T18:30:50.302Z",
"datePublished" : "2026-11-13T18:30:50.000Z",
"headline" : "Why your HubSpot dashboard and spreadsheet differ",
"mainEntityOfPage" : {
"@id" : "https://crmotive.com/blog/why-your-hubspot-dashboard-and-spreadsheet-differ",
"@type" : "WebPage"
},
"publisher" : {
"@type" : "Organization",
"logo" : {
"@type" : "ImageObject",
"url" : "https://crmotive.com/hubfs/__hs-marketplace__/CRMotive-logo-01-1-1-1-1-1-1.png"
},
"name" : "CR Motive Integrated Solutions"
}
}
```
```json
{
"@context" : "https://schema.org",
"@type" : "Organization",
"name" : "CRMotive",
"url" : "https://crmotive.com"
}
```
```json
{
"@context" : "https://schema.org",
"@id" : "https://crmotive.com/blog/why-your-hubspot-dashboard-and-spreadsheet-differ#article",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Kareem"
},
"dateModified" : "2026-11-13",
"datePublished" : "2026-11-13",
"description" : "Why a HubSpot dashboard and a spreadsheet show different numbers: check the metric definition, the date field and hidden filters, then pick one source.",
"headline" : "Why your HubSpot dashboard and spreadsheet differ",
"image" : "//47990825.fs1.hubspotusercontent-na1.net/hubfs/47990825/raw_assets/public/crmotive/images/og-image.png",
"inLanguage" : "en",
"isPartOf" : {
"@id" : "https://crmotive.com/#website"
},
"mainEntityOfPage" : "https://crmotive.com/blog/why-your-hubspot-dashboard-and-spreadsheet-differ",
"publisher" : {
"@id" : "https://crmotive.com/#org"
}
}
```
```json
{
"@context" : "https://schema.org",
"@id" : "https://crmotive.com/blog/why-your-hubspot-dashboard-and-spreadsheet-differ#breadcrumb",
"@type" : "BreadcrumbList",
"itemListElement" : [ {
"@type" : "ListItem",
"item" : "https://crmotive.com/",
"name" : "Home",
"position" : 1
}, {
"@type" : "ListItem",
"item" : "https://crmotive.com/blog",
"name" : "Blog",
"position" : 2
}, {
"@type" : "ListItem",
"item" : "https://crmotive.com/blog/why-your-hubspot-dashboard-and-spreadsheet-differ",
"name" : "Why your HubSpot dashboard and spreadsheet differ",
"position" : 3
} ]
}
```