Guide · HubSpot and Salesforce reporting

When closed-won doesn’t match finance, find the gap deal by deal.

Sales reports one number for the quarter, finance reports another, and the board trusts finance. After that, nobody reads the CRM dashboard. The gap is rarely one big error. It is a handful of small, fixable causes stacked on top of each other.

This guide gives a method to size each cause on one closed quarter, the exact HubSpot and Salesforce fields to check, and the rules that stop the gap from coming back.

Get a one-page teardown Read the guide

By Luis García · Last reviewed November 9, 2026 · 7 min read

First, check you are comparing the same number

Closed-won records a commercial commitment on the day a rep moves the deal. Finance usually reports something else:

  • Bookings. The signed commitment, often the contract value or its annual value, dated at signature. This is the number the CRM can own.
  • Billings. What was invoiced in the period. An annual contract billed monthly is a fraction of its value in any one month.
  • Recognized revenue. What accounting counts, spread over the service period under accounting rules. It lives in the finance system, not the CRM.

If sales means bookings and finance means recognized revenue, the numbers should not match, and no clean-up will make them. Agree in writing which number each report shows and label every dashboard with it. Then reconcile bookings with bookings.

The reconciliation method

  1. Pick one closed quarter and one number, for example new bookings last quarter. Not everything at once.
  2. Pull both lists at deal level. The CRM export with customer, amount, close date, deal type and owner. Finance’s list of contracts or orders for the same period.
  3. Match on a shared ID if one exists, such as an order, invoice or subscription ID stored on the deal. If not, match on customer and amount, and note that this is the first thing to fix.
  4. Sort unmatched rows into three piles: in the CRM only, in finance only, and in both with a different amount or date.
  5. Tag each row with a cause from the list below, then add up how much of the gap each cause explains.

The ranking tells you what to fix first. Fixing the largest cause usually changes the conversation more than fixing all the small ones.

Reconciliation sheet · excerpt Last quarter, new bookings Illustrative

Five rows, five different causes

DealPileCauseFix
Annual plan, signed in the last week of the quarterBoth, different dateMoved to won after quarter endContract date property, required at won
Three-year contractBoth, different amountAmount holds three yearsLine items with term, report on ACV
Acquired customer moved to new planCRM only as newLogged as new businessRevenue type: migration
Auto-renewalFinance onlyNo deal createdRenewal pipeline, created from contract end date
Discount agreed by emailBoth, different amountEdited after finance booked itLock amount after won

Illustrative rows. The point is one cause per row, so each can be counted.

Cause 1: dates that mean different things

Close date is whatever the rep set when they moved the stage. Finance books on the contract or order date. Deals moved to won a few days after quarter end, or pulled in before signature, land in the wrong period on one side.

How to check

HubSpot: open the property history of Close date and Deal stage on last quarter’s won deals and look for changes after the quarter ended.

Salesforce: Opportunity History tracks stage, amount, probability and close date. Run an Opportunity History report filtered to last quarter’s won deals and look at the last edit date. Salesforce docs

The fix is a separate contract date property, required when a deal moves to closed won, and reports for finance built on it rather than on close date.

Cause 2: amounts that hold the wrong thing

The deal Amount is typed by a rep, set by a workflow or calculated from line items, depending on your settings. Multi-year totals, one-time services and discounts all end up in it in different ways.

In HubSpot, line items give you separate calculated properties: Total contract value includes recurring and one-time charges, Annual contract value is the value over twelve months, and Annual recurring revenue and Monthly recurring revenue come from recurring line items and their term. ARR and MRR ignore the Amount field entirely, and assume a twelve-month term when none is set. ARR and MRR need Sales Hub Professional or Enterprise. HubSpot docs

How to check

Export last quarter’s won deals with Amount, Annual contract value and Total contract value. Rows where Amount equals TCV but the contract is multi-year are booking several years in one quarter. Rows with no line items cannot be split at all.

In Salesforce, the same question applies to Amount versus Opportunity Products, and to whether product schedules are used for multi-year deals. Pick one field as bookings and say so on every report.

Cause 3: new business that isn’t new

This is a cause Drivant teardowns flag again and again at companies that have made an acquisition. HubSpot’s default Deal type has two values, New Business and Existing Business. Salesforce’s default Opportunity Type splits existing customers into upgrade, replacement and downgrade, plus New Customer. Neither has a value for "customer we acquired, now moving to our contract".

So acquired customers get logged as new business. New bookings look strong, expansion looks weak, and finance, which already counted those customers, sees no new revenue at all. Comp gets paid on revenue the company already had.

  • Add the missing values. New logo, expansion, renewal and migration of an acquired customer, each with a one-line definition.
  • Set it from data where you can. If the company already had a closed-won deal, or came from the acquired company’s customer list, a workflow can flag a deal marked new logo for review.
  • Report new bookings on new logo only. Migration gets its own line, so the board sees it as retention work, not growth.

Cause 4: revenue with no deal

Auto-renewals, upgrades taken by customer success, self-serve plan changes and add-ons billed directly often never get a deal. Finance sees all of it. A CRM-based report sees none of it, and in a business with a large installed base this can be a big share of the gap.

The fix is a renewals and expansion pipeline with its own stages, and a rule that creates a renewal deal a set number of days before each contract end date, so every renewal exists in the CRM before it is invoiced.

How to check

Take finance’s list of renewals and upgrades for last quarter. Count how many have a matching closed deal in the CRM. The ones without a deal show the size of this cause.

Cause 5: one customer, several entities

The CRM has the trading name. Finance has the legal entity that pays. A group customer can be one company in the CRM and four billing entities in the ledger, or the reverse. Matching on company name fails before anything else is tested.

Store the finance system’s customer ID on the CRM company, and model groups with a parent and child hierarchy so a deal sits on the entity that signs. See parent and child companies in HubSpot for how to set that up.

Stop the gap coming back

Once deals reconcile, edits after close are what pull them apart again. Restrict who can change amount, close date and deal type on won deals, and alert finance when someone does.

In Salesforce, a validation rule can block those edits for everyone except admins. Replace the stage name with yours and test it in a sandbox first:

AND( ISPICKVAL(PRIORVALUE(StageName), "Closed Won"), OR(ISCHANGED(Amount), ISCHANGED(CloseDate), ISCHANGED(Type)), $Profile.Name <> "System Administrator" )

In HubSpot, use field-level edit permissions where your subscription has them, and a workflow that notifies finance when Amount changes on a closed won deal. Then run the same reconciliation on the next quarter. The gap should be smaller and every remaining row should have a cause.

Sources used in this guide

Last reviewed November 9, 2026 by Luis García Checked against the HubSpot and Salesforce documentation linked above

Questions

Why doesn’t HubSpot closed-won match what finance reports?

Usually because the two sides measure different things, bookings in the CRM and billed or recognized revenue in finance, plus timing, amount, deal type and missing-deal differences. Reconcile one quarter deal by deal and size each cause.

Should the CRM be the source of truth for revenue?

No. Finance owns billed and recognized revenue. The CRM should own bookings and pipeline, defined so each closed deal can be traced to a contract or order.

Do ARR and MRR in HubSpot use the deal amount?

No. HubSpot calculates ARR and MRR from recurring line items and term length, and ignores the Amount property. With no term set, it assumes twelve months.

How often should sales and finance reconcile?

Monthly for the first quarter after fixing the causes, then quarterly before board reporting. Each run should end with every difference explained in writing.

Want to know where your gap comes from?

Send your website and the two numbers that disagree. The teardown names the most likely cause and the one CRM pull that confirms it.

Get a one-page teardown

Written by Luis, back within 1 business day. No call needed. Prefer to talk? Book a 20-minute fit call.

Sample teardown · real, anonymized Acquired customers are a migration, not a pipeline. One page for a new CRO, written from public information before any call: what public signals show, the likely gap, the fix order and one CRM pull to check it. Read the full page →