Why do the CRM and the finance system disagree about revenue?

Almost always because they are answering different questions correctly. The CRM holds what was sold, dated when it was signed. Finance holds what was recognised, dated when it was delivered. Add mid-term changes, credits and currency, and two accurate systems produce two different numbers. The disagreement is a definition problem, not a data-quality problem.

Why it works this way

Timing is the first and largest source. The CRM records a booking on the day the contract is signed. Finance recognises revenue as it is delivered, spread across the term. A strong December of bookings and a flat December of recognised revenue are perfectly consistent with each other, and a company that has not made that explicit will spend the January review arguing about which report is broken. Neither is.

Definition is the second and it is the one that actually costs money, because it hides. ARR, bookings, billings, recognised revenue and cash collected are five different quantities that people say the word "revenue" for. The disagreements that survive longest are the ones inside a single metric — net revenue retention computed with a mid-term downgrade in the denominator versus outside it will differ by several points, and both spreadsheets will be internally correct.

Lifecycle events are the third: mid-term upgrades and downgrades, prorations, credits, refunds, pauses, currency conversion at differing rates and dates. Each of these is handled by a rule that lives in one system and is approximated in the other. The approximation is usually fine until a quarter has enough of them to move the aggregate, which is exactly the quarter somebody notices.

The fourth is ownership, and it is why the first three persist rather than getting fixed. In most companies nobody owns the reconciliation. RevOps owns the CRM, finance owns the ledger, and the gap between them is owned by whoever is asked about it in a meeting. An unowned discrepancy does not converge over time — it gets rediscovered every quarter by a different person, at full cost each time.

The practical consequence is a tax on every decision drawn from either number. Where the first twenty minutes of a review go to establishing which figure is real, the decision that follows is made with the time and attention that survived, which is the mechanism by which good data still produces slow decisions.

What it looks like

Net revenue retention reads 104% in the warehouse, 111% in the CRM and 97% in the finance model. All three are computed correctly. They disagree because they disagree about what a mid-term downgrade does to the denominator. Three teams then spend a week proving their own number rather than deciding what to do about retention.

What this establishes, and what it does not

The words this answer uses

Related questions

Frequently asked questions

Why do the CRM and the finance system disagree about revenue?

Almost always because they are answering different questions correctly. The CRM holds what was sold, dated when it was signed. Finance holds what was recognised, dated when it was delivered. Add mid-term changes, credits and currency, and two accurate systems produce two different numbers. The disagreement is a definition problem, not a data-quality problem.

Which revenue number is the right one?

The one whose definition the company has written down and agreed to for that specific question. For a board metric that is usually recognised revenue; for pipeline decisions it is usually bookings; for cash planning it is collections. The failure is not picking the wrong one, it is having no written answer, so a different one wins each meeting depending on who is in the room.

How do you reconcile CRM and finance revenue?

Pick one metric. Write the definition down, including how it treats mid-term changes, credits and currency. Compute it from both systems for the same period, then list every line where they differ and classify each as timing, definition or a genuine data error. Most companies find the third category is the smallest, which is the useful surprise.

Is this a data quality problem?

Usually not. Genuine data errors are the smallest of the three buckets. Timing and definition account for the bulk of the gap, and neither is fixed by cleaning data — they are fixed by deciding, in writing, what the company means, and by naming who owns that decision.

What is decision debt?

The accumulated cost of decisions a company deferred because the information required to make them was expensive to assemble. It compounds quietly, and is usually repaid during a crisis.