The Reconciliation Gap
Enterprise ecommerce brands running on NetSuite face a persistent challenge: advertising platforms and ERP systems measure different things at different times.
Google Ads records a conversion when someone clicks "complete purchase." NetSuite records revenue when the order ships or invoices. Between those moments, orders cancel, items get returned, and currency rates fluctuate.
The gap isn't a bug. It's a fundamental difference in what each system is designed to measure. Bridging it requires intentional architecture.
Enterprise brands typically see 10-25% variance between Google Ads reported revenue and NetSuite realised revenue. At £1M/month spend, that's a £100-250k planning gap.
Conflicting Data Sources
Understanding why numbers differ starts with understanding what each system measures:
Data Source Comparison
Common Discrepancies
The most frequent causes of Google Ads/NetSuite variance:
Returns and Refunds
Google Ads never deducts returns. A £100 order returned after 14 days still shows as £100 revenue in Google Ads but £0 in NetSuite.
Order Cancellations
Payment failures, out-of-stock items, and customer cancellations create phantom conversions in Google Ads that never become NetSuite revenue.
Post-Sale Adjustments
Goodwill credits, price matches, and partial refunds reduce NetSuite revenue but don't update Google Ads.
Currency Conversion
International orders use different exchange rates at conversion versus settlement. 5% FX variance is common.
Root Causes
Beyond individual discrepancies, structural issues create persistent reconciliation challenges:
Attribution Model Mismatch
Google Ads uses its attribution model. NetSuite records the order. Multi-touch journeys create multiple Google Ads "conversions" for one NetSuite order.
Data Lag
Google Ads reports in near-real-time. NetSuite data depends on warehouse operations, invoicing schedules, and payment processing.
System Integration Gaps
Without proper integration, there's no automated way to reconcile. Manual reconciliation happens quarterly at best, revealing problems months late.
Reconciliation Framework
A practical reconciliation approach for enterprise brands:
1. Define Source of Truth
NetSuite is the source of truth for revenue. Google Ads is the source of truth for campaign signals. Accept this distinction rather than fighting it.
2. Build Adjustment Factors
Calculate historical variance by channel and category. If returns average 18% on fashion, apply that adjustment to Google Ads reported revenue.
3. Implement Offline Conversion Import
Feed NetSuite's actual order values back to Google Ads after settlement. This retrains Smart Bidding on realised revenue.
4. Create Reconciliation Dashboard
Weekly reporting that shows both sources side by side, with variance tracking and trend analysis.
Perfect reconciliation isn't the goal. Consistent, understood variance is. When you know Google Ads overstates by 15%, you can plan accordingly.
Practical Solutions
For Campaign Optimisation
Use Google Ads data for bidding decisions but apply category-level adjustment factors. Target 4.0x ROAS in Google Ads if you need 3.4x after adjustments.
For Budget Planning
Use NetSuite-adjusted figures for CFO reporting and budget allocation. Never present Google Ads revenue as actual business revenue.
For Performance Reporting
Show both figures with clear labelling: "Google Ads Reported Revenue" and "NetSuite Realised Revenue." Stakeholders understand context when you provide it.
Frequently Asked Questions
Why do Google Ads and NetSuite report different revenue figures?
Google Ads reports at the point of conversion (transaction initiation). NetSuite reports at the point of fulfilment or invoice. The timing gap creates discrepancies. Add refunds, cancellations, and currency conversions and the numbers diverge further.
How can I get accurate ROAS when using NetSuite as my source of truth?
Use offline conversion imports to feed NetSuite's actual order values back to Google Ads after settlement. This retrains Smart Bidding on realised revenue rather than checkout values. The lag is acceptable because accuracy matters more.
Should I trust Google Ads or NetSuite for campaign performance?
NetSuite for actual business performance. Google Ads for campaign optimisation signals. The reconciliation layer bridges them. Never make budget decisions solely on Google Ads reported revenue when NetSuite tells a different story.
Running NetSuite with Google Ads?
We help enterprise brands build reconciliation frameworks that bridge ERP and advertising data.
Book a Reconciliation ReviewGet our insights in your inbox
Plain-English thinking about Google Ads. No spam, unsubscribe anytime.