How to reconcile ad platform data with your Stripe or store sales

How to reconcile ad platform data with Stripe or store sales: line up dates, currencies, refunds and fees so you can see how many claimed sales really happened.

By the Matrix ROI team at Smith App StudioOctober 18, 20263 min read

The short answer

To reconcile ad data with sales, export each platform's conversions and your Stripe or store orders for the same dates, convert both to one currency, and subtract refunds. Then compare platform by platform, never as a sum. The remaining gap shows how much each platform over-claims, which tells you how far to trust its numbers.

Compare each platform to your sales separately; never add platforms together.
Match on the same dates, time zone and currency before comparing anything.
Use revenue after refunds, and know your processor's fees.
Track the gap over time; a sudden change usually means broken tracking.

Stripe's standard US fee per successful domestic card transaction: 2.9% + 30¢; Stripe's standard US fee per successful domestic card transaction; Stripe
Stripe fee for each dispute received: $15; Stripe fee for each dispute received; Stripe

Why the numbers never match

Open Google Ads, Meta Ads Manager and your Stripe dashboard for the same week and you will see three different stories. That is normal. The platforms and your payment records measure different things.

Your Stripe or store records count money that actually arrived. An ad platform counts conversions it believes its ads influenced, inside an attribution window (the number of days after a click or view in which it still takes credit). When a customer clicks a Google ad on Monday and sees an Instagram ad on Wednesday before buying, both platforms may claim that one sale. We cover the reasons in depth in why ad platforms claim more sales than you made.

Line up dates, time zones and currencies first

Most of the gap people panic about is really a mismatch in how the numbers were pulled. Fix these before drawing any conclusions.

Click date versus sale date. Google says Google Ads has always reported conversions by the date your ad was clicked, with separate "by conv. time" columns if you want the date the conversion happened. Stripe records the day the payment went through. Pick one basis and stick to it.
Time zones. Your ad account, your store and Stripe may each use a different time zone, which shifts late-evening sales into the next day.
Currency. If you sell or advertise in more than one currency, convert everything to one, using one published rate per day. The European Central Bank publishes euro reference rates each working day, around 16:00 CET.
Late data. Platforms keep adding conversions for days. Leave the most recent few days out of any comparison.

From platform-claimed revenue to money you keep, one example week

Platforms claim (added up)$14,200
Stripe gross payments$11,800
After refunds$11,100
After Stripe fees$10,689

This is a worked calculation with illustrative inputs: 230 card payments averaging about $51, with fees at Stripe's 2.9% + 30¢ on every original charge, since fees on refunded payments are not returned.

Source: Worked example

Clean up your own sales figure

Your records are the baseline, so they need to be right. Start with gross payments for the period, then subtract refunds and failed or disputed charges. Decide whether you compare platforms against gross revenue or revenue after refunds, and use the same choice every time. Unless you send them adjustments, ad platforms do not learn about refunds, so a product with a high return rate will look better in Ads Manager than it is.

Know what your processor keeps, too. As of October 2026, Stripe's standard US pricing is 2.9% + 30¢ per successful transaction on domestic cards. Its pricing page says that when you refund a payment, the processing fees from the original transaction are not returned, and each dispute you receive carries a $15.00 fee. Those costs are real money that no ad platform report will ever show.

Compare platform by platform

Now put the numbers side by side. For each platform, compare its claimed conversions and value against verified sales for the same period. If you use UTM tags (short labels added to your ad links that tell your analytics which campaign sent a visitor), you can go further and match orders to the campaign that sent them. Our UTM parameters guide explains how.

Expect the platform totals, added together, to exceed your real sales. What matters is each platform's ratio of claimed to verified, and whether that ratio stays steady. If Meta usually claims about 30% more than you can verify and suddenly claims 90% more, look for a duplicated tracking tag or a changed attribution setting before you increase the budget. If claims drop to nearly zero while sales hold, the tracking is probably broken, not the ads.

Make it a weekly habit

Reconciling once tells you very little. Doing it every week turns the gap into a warning light. Keep a simple table: date, spend per platform, claimed conversions per platform, verified orders, verified revenue after refunds. A spreadsheet works fine.

Matrix ROI, created by Smith App Studio, keeps that table for you: it connects to Stripe, accepts spreadsheet exports from any ad platform today, converts currencies with ECB reference rates, and shows claimed beside verified day by day. A 14-day trial needs no card. Either way, the goal is the same: never move budget on a number your own records cannot back up.

Frequently asked questions

Why is my Google Ads revenue higher than my Stripe revenue?

Google Ads counts conversions its ads may have influenced within an attribution window and reports them by the date of the click. Other platforms may claim the same sale. Google also does not see your refunds unless you upload adjustments. Stripe counts only money actually paid, on the day it was paid, so the platform figure is usually higher.

Should I compare ad results to gross or net sales?

Choose one and keep it. Revenue after refunds is the more honest comparison, because ad platforms do not subtract returns. Processing fees are a cost of selling rather than a measurement difference, so track them separately when you work out profit.

How big a gap between platform claims and real sales is normal?

There is no universal number. It depends on your attribution settings, how many platforms you run and how long customers take to buy. Measure your own ratio of claimed to verified sales for each platform over several weeks, then watch for sudden changes rather than chasing a benchmark.

How often should I reconcile ad data with sales?

Weekly works for most small businesses. Leave out the most recent two or three days, because platforms keep adding late conversions. A monthly reconciliation before client reports or budget decisions is the minimum.

Found this useful? Pass it on.

X LinkedIn Facebook Email

Sources

General information only, not legal, tax or financial advice. Figures belong to the sources linked above and were checked on the date shown. See our disclaimers.

Keep reading

AttributionWhy ad platforms claim more sales than you made
StrategyUTM parameters: the simple habit that fixes messy reporting
Agencies & reportingClient reporting that agencies can stand behind

See what your ad platforms claim next to what your records prove.

14-day free trial. No card needed to start.

Start free trial Live demo