Analytics and Tracking

Reconciliation

Also called data reconciliation, number matching

The disciplined comparison of platform, analytics and business records, done to explain their differences rather than to force agreement.

Quick facts: Reconciliation

Category
Analytics and Tracking
Also called
data reconciliation, number matching
Level
Intermediate
Affects
Trust in reporting, fault detection, budget decisions
Where to see it
Google Ads, GA4, Meta Ads Manager, your CRM or order database, Looker Studio
In this article4
  1. How reconciliation works
  2. Why reconciliation matters
  3. Common mistakes with reconciliation
  4. How to act on it

How reconciliation works

Three systems usually claim to count the same thing. An ad platform reports conversions it can attribute to its own clicks. An analytics property reports events fired on the website. The business reports orders, invoices or qualified enquiries from its own database or CRM. Reconciliation is the disciplined comparison of those three, done to explain the differences rather than to remove them.

The work is mechanical. You fix a single date range and time zone, define exactly which action counts on each side, then walk the gap down cause by cause: conversions credited to the click date instead of the purchase date, estimated data filling gaps in observation, duplicate firing, blocked tags, refunds and cancelled orders, enquiries that were never genuine.

A useful sequence when the numbers refuse to line up:

  1. Match the date range, time zone and currency on both sides before anything else.
  2. Confirm the two systems define the action identically, including whether repeats count.
  3. Check for duplicate or missing firing on the website itself.
  4. Allow for attribution timing, then for estimated and unobserved data.
  5. Remove refunds, cancellations and rejected enquiries from the business figure last.

Why reconciliation matters

Unreconciled numbers destroy trust faster than bad results do. Once a client or a finance team sees two figures for one month, every later report is met with suspicion, and good decisions get delayed while people argue about which screen to believe.

It also protects the money. A gap can hide a genuine fault — a tag that stopped firing after a website release, a payment step that fails on certain phones, an enquiry form silently rejecting long messages. Reconciliation is often how those are found, because the mismatch appears before anyone notices the drop.

Common mistakes with reconciliation

Expecting a perfect match is the big one. The systems measure different things by different methods, and a stable, explained gap is the realistic goal. Chasing zero difference wastes days and usually ends with someone quietly changing a setting to force agreement.

The other mistake is reconciling only when something looks wrong. A gap you have never measured has no normal, so you cannot tell a routine difference from a broken one. Comparing time zones carelessly causes more false alarms than any real fault.

How to act on it

Reconcile on a fixed rhythm, monthly for most small businesses, and record the size of the gap each time rather than only the verdict. A gap that holds steady is a known quantity; a gap that moves is the signal worth investigating.

Decide in advance which system is the source of truth for each question, so a difference triggers an explanation instead of a debate. Keep the definitions, filters and time zone written down beside the report, and build the comparison into your reporting and dashboards rather than doing it from memory each time.

Do and do not

Do

  • Match date range, time zone and currency before comparing
  • Record the size of the gap every month
  • Write down how each system defines the action

Do not

  • Expect the numbers to match exactly
  • Change a setting just to force agreement
  • Reconcile only when something already looks wrong

Questions people ask about this

How close should platform and business numbers be?

There is no correct figure, because the systems count different things. What matters is that the gap is measured, explained and stable. Start recording the difference every month, and treat a sudden change in the gap as the alarm rather than the gap itself. A steady difference is normal and usually harmless.

What causes the biggest gaps?

Usually timing and definition rather than faults. Ad platforms credit a conversion to the date of the click, while your records use the date of purchase, so the same sale lands in different months. Beyond that, look at duplicate firing, blocked or consent-limited tracking, refunds still counted as sales, and mismatched time zones.

Who should do the reconciliation?

Whoever can see both sides. In a small business that is often the owner working with whoever manages the marketing, because it needs access to the ad account and to the sales records. The important thing is that one named person does it on a regular schedule and writes down the result.

Related terms

Found this useful?

Share it, or ask an AI to summarise it

Back to the glossary

Knowing the term is the easy part

Applying it to your own site and budget is the work. Book a call and I will tell you what actually applies to you.