Your team argues about which number is right. Google Analytics says 100 conversions. Your CRM says 95. Your store platform says 102. No one knows which to trust. Decisions stall while you debate the numbers.
Reconciliation is the process of understanding the gaps between tools and establishing which tool owns each metric. It's not about making numbers match. It's about understanding why they don't and deciding which to trust.
The reconciliation framework
Step 1: Identify what each tool measures
Google Analytics measures tracked events and conversions. Your store platform measures completed transactions. Your CRM measures deals entered. Server logs measure requests. Each tool measures something slightly different.
Document exactly what each tool measures: "Google Analytics tracks conversion event fired on checkout confirmation page." "The store platform tracks completed payments." "CRM tracks deals created by sales team."
Step 2: Pull the same data from each tool
For a specific date range, export conversion count from each tool. Use the exact same date range (same time zone) in each tool. If you're comparing monthly, use the same calendar month in all tools.
Example: "January 1-31, 2026 conversions"
Step 3: Calculate the differences
Analytics: 100 conversions. Store platform: 102 conversions. CRM: 95 conversions. Gap between Analytics and store platform: 2 (2%). Gap between Analytics and CRM: 5 (5%).
Is 2% normal variance? Yes. Is 5% explainable? Maybe. Investigate.
Step 4: Investigate the gaps
Why is CRM lower than the store platform? Possible explanations: offline conversions in the store platform that don't get entered into CRM yet. Refunds in CRM that the store platform still counts. Test transactions in the store platform that don't go to CRM.
For each gap, find the explanation.
Step 5: Document the explanation and accept the difference
"CRM is 3% lower than the store platform because it includes refunds (removed from revenue) and only includes sales entered within 24 hours. Some sales take longer to enter. This gap is expected."
Once you understand it, stop debating the numbers. Use the appropriate source for each decision.
Tools to use for reconciliation
Google Analytics as your traffic source of truth
Google Analytics shows how users behave and convert. It's your best source for understanding traffic patterns and user journeys. Use it for traffic analysis, segment analysis, and attribution questions.
Payment processor as your revenue source of truth
Your payment processor (such as Stripe or PayPal) shows actual money moving. Use this for revenue numbers, refund tracking, and financial analysis. This number gets sent to your accountant, so it's the most official.
CRM as your pipeline source of truth
Your CRM shows deals, opportunities, and sales progress. Use this for sales forecasting, pipeline analysis, and revenue attribution to sales teams.
Server logs as your technical source of truth
Server logs show all traffic at the technical level. Use this for technical diagnostics, bot detection, and understanding traffic the analytics tool might be missing.
Common reconciliation scenarios
Analytics shows fewer conversions than your payment processor
Normal. Likely causes: tracking code failure on some conversions, ad blockers preventing conversion tracking, third-party checkout not tracked.
Fix: calculate the gap percentage monthly. If it's consistent (say, always 5-10% lower), that's expected. If it changes suddenly, something broke.
CRM shows more deals than Analytics shows conversions
Possible causes: sales team creates deals for offline leads, deals created after initial conversion (not tracked at conversion time), test deals in CRM that aren't real.
Fix: decide which conversions go in CRM and which don't. Maybe only first-purchase conversions count for Analytics. Maybe all deals in CRM count, including renewals.
Analytics shows conversion attribution one way, CRM shows it differently
Different tools use different attribution models. Analytics uses last-click by default. CRM might use first-click or custom rules. Of course they disagree.
Fix: pick one source of truth for attribution. If Analytics says Paid Search should get credit, use that number. Don't try to make CRM match Analytics. Use each for what it's good at.
Automate reconciliation checks
Set up monthly reconciliation reports
Create a spreadsheet that pulls key metrics from each tool monthly. Google Analytics conversions. Store platform revenue. CRM deals. Compare them. Calculate variances.
If variance stays within expected range, no action needed. If something changes unexpectedly, investigate immediately.
Set up alerts for unusual discrepancies
If Analytics conversion count drops 50% relative to the store platform, alert your team. Something likely broke. Automatic alerts catch problems faster than manual reviews.
Use data integration platforms
Platforms like Fivetran, Stitch, or native integrations can automatically sync data from multiple sources into a data warehouse. Compare all sources in one place.
Frequently asked questions
How do I decide which tool's numbers to use for reporting?
Use the tool that measures closest to your actual goal. For traffic reporting, use Analytics. For revenue reporting, use payment processor. For sales reporting, use CRM. Different metrics use different sources. With WEMASY's website builder, you can set this up directly on your website.
Should I adjust one tool's data to match another?
No. Document the difference and understand why it exists. Adjusting data creates false precision and hides the real gap. Understanding the gap is more useful.
What's an acceptable variance between tools?
5% or less is excellent. 5-15% is typical and acceptable. 15-30% warrants investigation. 30%+ suggests a problem. Establish your own baseline based on your tools.
How often should I reconcile my tools?
Monthly minimum. Weekly if you're running paid campaigns. Quarterly audit of multi-month trends. The frequency depends on how fast things change in your business.
Can I use server logs to validate all other tools?
Partially. Server logs show all traffic but don't track user behavior like Analytics does. Use server logs to validate traffic volume, not user segments or conversion attribution.
Should I consolidate to one analytics tool to avoid discrepancies?
No. Multiple tools give you different valuable perspectives. The discrepancies are a feature, not a bug. Understanding them is more useful than eliminating them.