Why your HubSpot sales reports don't match reality
HubSpot sales reports usually don't match reality because each report answers a slightly different question. They use a different date, start from a different object, or hide a filter. The data can also be wrong, but check the report setup first. It is faster and it is the more common cause.
Below are the 6 usual causes, in the order we would check them.
1. The reports use different dates
A deal has more than one date. It has a create date, a close date, a last activity date, and a "date entered" for each stage.
Say a deal is created in September and won in October. A report by create date counts it in September. A report by close date counts it in October. Both are right. They just measure different things: what you started, and what you finished.
Check: open each report and look at which date the date range filters on. Put that date in the report title. Ex: "Closed won revenue by close date".
2. Close date moves
HubSpot sets the close date to the day a deal is moved to closed won or closed lost, unless you turn that off in the pipeline settings. So if a customer signs on March 30 and the rep updates the deal on April 2, the revenue lands in April.
If your reps update deals on Mondays or after quarter end, your quarter edges will be soft. This is a write-up on why two reports disagree that covers the same trap.
Check: compare 5 deals that closed near the end of last month. Does the close date match the day the customer said yes?
3. The same deal is counted more than once
This happens in reports that join objects. Take one $50,000 deal with 3 contacts attached. A report that starts from contacts and pulls in deal amount can show that deal 3 times. Your report says $150,000. Your revenue is $50,000.
Check: make Deals the main data source for any revenue report. If a report starts from contacts, check whether the total matches the deals list.
4. A filter is hiding or adding deals
Reports often come with filters already on. Watch for:
- Closed lost deals left out.
- One owner or one team picked when you wanted all of them.
- Several pipelines mixed in. If you have a new business pipeline and a renewal pipeline, a report over all pipelines adds renewals to your new sales.
- A rolling range like "last 90 days" next to a fixed one like "this quarter".
Also check the amount. Some revenue reports show the weighted amount, which is the deal amount times the stage probability. A $1,000 deal at 40% shows as $400.
Check: open the filter list on each report side by side. They should match, line for line.
5. The data is missing or wrong
A report can only count what is in the CRM. Reps skip fields that are not required. Deals sit in "Proposal sent" for months. Amounts are guesses. Two tools push half a record into HubSpot.
This is the usual cause when the report setup looks fine. One partner writes that dirty data is the most common reason reports stop matching reality, and the least exciting thing to fix.
Check:
- Count open deals with no amount.
- Count open deals with no next step or no activity in 30 days.
- Count deals with no close date.
- Count duplicate contacts and companies.
If any of these is more than a few, the report is showing the mess, not the market.
6. The report has not updated yet
Custom reports built with the report builder refresh about every two hours, according to HubSpot's custom report guide. Single object reports are quicker because they read the live CRM. So if you changed a deal a minute ago and the dashboard did not move, wait or refresh it.
Write down what each number means
Most of the above is a definition problem. Nobody wrote down what "a closed deal" is. So each person builds their own report, and the room argues over screenshots.
Take your 5 numbers and write one line for each. The object, the date, the filters and who owns it.
| Number | Object | Date | Filters |
|---|---|---|---|
| New business won | Deals | Close date | Pipeline: new business. Stage: closed won |
| New pipeline created | Deals | Create date | Pipeline: new business |
| Open pipeline | Deals | Current | Pipeline: new business. Not closed |
| Win rate | Deals | Close date | Pipeline: new business. Closed won / all closed |
| Deals with no next step | Deals | Last activity date | Open, no activity in 14 days |
Then rebuild each report from its line. Check it against your invoices once a month. When it is off, you will know which line to look at.
Our view
We think the owner should see the whole pipeline in one place without asking anyone. When a CRM fails, the usual cause is that nobody keeps it up. A well-known stat says 55% of CRM projects fail. It comes from a 2001 Gartner question about meeting expectations. Only about 5% were outright failures. The CRM is rarely the problem. The upkeep is.
Reports are the first place that shows up. If your leader does not trust the numbers, they go back to spreadsheets and asking people.
Who can fix this for you
| Option | Best for |
|---|---|
| Do it yourself | A small account where one person knows the setup and has a free afternoon. |
| A HubSpot agency | A full rebuild when the whole account needs rework. |
| An independent consultant | One clear job, like cleaning the data and rebuilding 5 reports. |
| Scaling Studio | Teams that want the numbers fixed and the follow-up rules, routing and reports run as one system. |
One client added $1.5M in new revenue in 12 months. Another added $1M in 12 months.
FAQ
Why is my HubSpot revenue report higher than my closed won deals?
Usually the deal is counted more than once because it has several contacts or companies attached, or the report shows a different pipeline. Make Deals the main data source and check the pipeline filter.
Why do my HubSpot reports change after the month ends?
Close date is set when someone moves the deal to closed won. If reps update late, the deal lands in a later month. Ask reps to update the deal the day the customer says yes.
How often do HubSpot reports refresh?
Single object reports read the live CRM. Custom reports built with the report builder refresh about every two hours.
Can I trust HubSpot reports at all?
Yes, when the data is complete and each report has a written definition. HubSpot counts what it is told to count. The work is making sure the data and the definitions are right.