Why do sales and finance always have different revenue numbers?

Because they define revenue differently. Sales counts deals when they close. Finance counts money when it's invoiced or collected. Both are valid, but without a shared definition and a single place to query it, they'll never match.

How do I get departments to agree on one definition of revenue?

Don't rely on a meeting or a wiki page. Define each metric once in a data warehouse using a transformation layer like dbt: what's included, what's excluded, how it's calculated. Then point every dashboard at that definition. Agreement becomes infrastructure, not conversation.

Is this just a revenue problem?

No. The same thing happens with customer count, churn, acquisition cost, and active users. Any metric that matters to more than one team will eventually have competing definitions. Revenue is just where it shows up first because the stakes are highest.

Can a shared spreadsheet fix this?

For a while, maybe. But spreadsheets don't refresh automatically, can't reconcile across multiple source systems, and break when someone edits the wrong cell. They paper over the problem without fixing the structure underneath.

Why Your Sales and Finance Teams Disagree on Revenue

Quick answer

Sales and finance disagree on revenue because they define it differently. Sales counts deals when they close in the CRM. Finance counts invoices when they're paid in the billing system. Nobody is wrong. They're looking at different slices from different tools with no shared definition. The fix isn't a meeting to "align." It's a single source of truth where revenue is defined once and every report reads from that same definition.

Why each team sees a different number

The root cause is definitional. Each function defines customers, activities, and outcomes differently, and each uses a different system to track them.

Sales defines revenue as deals closed. The CRM marks "closed won" when the contract is signed. The customer hasn't paid yet. Maybe they won't for 60 days.
Finance defines revenue as cash collected. The billing system shows invoices paid, refunds processed, credits applied. This number lags sales by weeks or months.
Product defines revenue as active subscriptions. A customer who signed but never onboarded doesn't show up. Neither does one who's paying but stopped logging in.

Three systems, three definitions, three numbers that are each correct in their own context and completely incompatible in a slide deck. The same pattern repeats for customer count, churn, acquisition cost, and every other metric that crosses team boundaries.

What this actually costs

Wasted meetings. The first 20 minutes of a leadership meeting spent debating which number is right instead of making decisions.
Parallel reporting. Each department builds its own dashboard because they don't trust the other's. More dashboards, more drift.
Reconciliation tax. Someone (usually the most senior person) spends hours each month playing detective across tools. Expensive time, zero new insight.
Forecasting on sand. If sales and finance can't agree on what already happened, projecting what comes next is guesswork.

From the team

Ready for one revenue number everyone trusts?

We connect your CRM, billing, and product data into a single source of truth. Same definition, same number, every time.

Build your data foundation →

Why "let's just align" doesn't last

The usual fix is a meeting. Teams agree on a definition, someone writes it in a wiki. It works for a week. Then a new quarter starts, edge cases pile up (multi-year contracts, pilots, credits), and each team reverts to whatever their tool shows. The wiki gets outdated. The Slack message gets buried.

Alignment by agreement has no enforcement mechanism. Nobody intentionally deviates. They just use their tool's default, which was never built to match the other team's tool. For teams already past this point, it's usually one of the clearest signs the data stack needs attention.

What actually fixes it

Centralize the data. Get CRM, billing, product, and every other source into one data warehouse (BigQuery, Snowflake, or similar). Each tool connects once through a managed pipeline. No more exporting.
Define each metric once. Use a transformation layer like dbt to write down exactly what "revenue" means: what's included, what's excluded, how refunds are handled. This lives in code, versioned and reviewable. Not in someone's memory.
Point everything at the same source. Every dashboard reads from the warehouse. Same query, same definition, same number. The argument ends.

And because the warehouse is system-agnostic, when you swap your CRM or billing tool in three years, the data and definitions carry over. You change the connector, not the foundation.

For the full approach, see how to consolidate data from multiple tools.

Getting this built

Connect the sources, define the metrics, build the dashboards, document everything. For most companies with 3–10 tools, it's a few weeks of focused senior work. A fractional data engineer can build it end-to-end and hand it off so your team maintains it independently. It typically costs a fraction of a full-time engineer.

Start with the roadmap below to see what this looks like for your specific setup.