Why Your HubSpot Dashboards Don't Match Your Finance Numbers (and How to Reconcile Them)

HubSpot dashboards and finance reports rarely match because they measure different things. HubSpot counts deals by close date and deal amount. Finance counts invoices or recognized revenue by its own dates and its own rules. Most of the gap comes from a handful of predictable causes, and you can close it by agreeing on definitions first and fixing the deal data second.

This comes up in almost every HubSpot cleanup I do. Here's how I work through it.

The six usual causes

1. Different dates. HubSpot uses the deal's close date. Finance uses the invoice date, the contract start date or the date revenue is recognized. A deal closed on the 30th can land in a different month for finance.
2. Different amounts. The deal amount is often the sales number before discounts, taxes, credits or changes after signing. Finance books what was actually invoiced.
3. Recurring vs one-time revenue. If annual contracts, monthly subscriptions and one-time fees all go into one amount field, the dashboard can't line up with finance's view of recurring revenue.
4. Currency. Deals in other currencies convert at a rate that may not match the rate finance uses.
5. Deals that changed after closing. Deals reopened, deleted, merged or moved to a different pipeline quietly change past totals.
6. Missing or messy data. Blank amounts and close dates show up as gaps. I covered that in fixing the "No value" problem.

How to reconcile them

1. Pick one month and one report. Start with last month's closed-won total in HubSpot and the matching finance number.
2. Match deal by deal. Export both lists and match them on customer name or invoice number. Every unmatched line falls into one of the six causes above.
3. Agree on definitions. Write down what "closed revenue" means in HubSpot: which date, which amount, which pipelines. Sales and finance should both sign off.
4. Fix the deal properties. Add the fields you need, such as contract start date, recurring amount and one-time amount, and make the key ones required at closed-won.
5. Lock closed deals. Limit who can edit or delete closed-won deals, so past months stop moving.
6. Label the dashboard. Put the definition right on the report so nobody compares it with the wrong finance number.

If extra pipelines are part of the mess, see consolidating HubSpot deal pipelines.

How to tell if this is you

• Finance and sales bring different revenue numbers to the same meeting.
• Last quarter's closed-won total changes when you rerun the report.
• Recurring and one-time revenue share one amount field.
• Nobody can say which date a deal's revenue belongs to.

FAQ

Why doesn't HubSpot revenue match QuickBooks or our accounting system?

HubSpot reports deals by close date and deal amount, while accounting reports invoices or recognized revenue. Agree on one definition and add the fields that bridge the two.

Should HubSpot be our source of truth for revenue?

Usually not for booked revenue. HubSpot is the source of truth for pipeline and bookings, and finance owns recognized revenue. The goal is a clean, explainable bridge between them.

Can HubSpot report recurring revenue?

Yes, if your deals carry a recurring amount separately from one-time fees. Set that up at the deal level so reports can split the two.

How do we stop past months from changing?

Restrict edits and deletes on closed-won deals to a small group, and review changes to closed deals each month.

If your HubSpot numbers and finance numbers never agree, let's talk.