Shopify, Meta and your bank never show the same number because each one answers a different question. Shopify tells you which orders were placed and how much they were worth under its own rules for taxes, shipping and returns. Meta tells you which purchases it believes its ads influenced, under its attribution settings. Your bank tells you how much cash actually arrived, after payment fees and refunds, on the day the payout landed. None of them is wrong. The mistake is reading any one of them as if it were your profit.
Three systems, three questions
| Source | What it counts | Dated by | Usually includes VAT and shipping? |
|---|---|---|---|
| Shopify | Orders and returns | Order date (returns on the date processed), store time zone | Depends on the metric: net sales excludes them, total sales includes them |
| Meta Ads | Purchases attributed to ads | Date of the ad impression or click, ad account time zone | Usually yes: it reports the value the pixel or Conversions API sent |
| Bank | Cash deposited | Date the payout arrives | Yes, minus payment fees and refunds |
The seven reasons the numbers differ
1. Attribution windows and conversion dates
Meta's default attribution setting is 7-day click and 1-day view: it credits a purchase to an ad if the buyer clicked that ad in the previous 7 days or saw it in the previous day. View-through purchases often come from people who would have bought anyway, or who also clicked a Google ad or an email, and every platform claims the same order for itself. On top of that, Meta reports conversions by default on the date of the impression or click, not on the date of the purchase. A click on Monday that turns into an order on Thursday shows up as a Monday conversion in Ads Manager and a Thursday order in Shopify.
2. Taxes and shipping, in or out
Shopify's reports separate gross sales, net sales (after discounts and returns, excluding taxes and shipping) and total sales (including taxes and shipping). The value Meta receives depends on how the pixel or Conversions API is set up, and is often the full order total, VAT and shipping included. In a country with 21% VAT, comparing Meta's purchase value with Shopify's net sales builds in a gap of more than 20% before anything else happens.
3. Refunds and their dates
Shopify records a return on the date it is processed, not on the date of the original order, so a refund issued today lowers today's sales even if the order was placed last month. Meta does not subtract refunds from the purchase value it has already reported. The bank sees the refund as money taken out of a payout. Three systems, three different treatments of the same event.
4. Time zones
Your store has a time zone and your ad account has another one, chosen when the account was created. If they differ, 'Monday' in Ads Manager covers different hours than 'Monday' in Shopify, and every daily comparison drifts. It shows up most on days with a spike, like a launch or a sale that starts at midnight.
5. Currency
If the ad account is billed in dollars and the store sells in euros, Meta converts values at its own rate, your card is charged at your bank's rate, and Shopify converts orders placed in other currencies at the rate it applied at checkout. Each conversion is reasonable on its own; together they leave small differences that never fully close.
6. Payouts and payment fees
Payment providers do not send each order to your bank. They batch them into payouts that arrive after a delay that depends on your country and provider, with processing fees and refunds already deducted. Orders paid by PayPal or another gateway settle in that account, not in the same payout. So the deposit you see on a given day belongs to orders from earlier days, minus their fees.
7. Test orders, draft orders and duplicate events
Test orders, draft orders that were never paid and orders created by apps can end up in some reports and not in others. On the Meta side, if the pixel and the Conversions API both send the same purchase without a shared event ID, Meta can count it twice.
A worked reconciliation: one Monday
Here is a hypothetical store in Spain, prices including 21% VAT, store and ad account on the same time zone, all orders paid by card through one payment provider. On Monday it spends €1,000 on Meta and receives 40 orders.
Step 1: what Shopify says
| Line | Including VAT | Excluding VAT | VAT |
|---|---|---|---|
| 40 orders: products | 3,388.00 | 2,800.00 | 588.00 |
| 40 orders: shipping charged | 242.00 | 200.00 | 42.00 |
| Total charged to customers | 3,630.00 | 3,000.00 | 630.00 |
| Refund processed today (order from last week) | −121.00 | −100.00 | −21.00 |
Net sales = 2,800 − 100 = €2,700 (excludes VAT and shipping) Total sales = net sales + shipping + taxes = 2,700 + 200 + 609 = €3,509 Check: 3,630 − 121 = €3,509
Step 2: what Meta says, and what it really covers
Ads Manager reports 34 purchases worth €3,740 for Monday, a ROAS of 3.74. Matching those purchases against Shopify orders splits them like this:
| Group | Purchases | Value |
|---|---|---|
| Clicked Monday, ordered Monday | 22 | €2,420 |
| 1-day view-through, ordered Monday (buyer also came via other channels) | 6 | €660 |
| Clicked Monday, ordered Tuesday to Thursday | 4 | €440 |
| Duplicate events (pixel and API, not deduplicated) | 2 | €220 |
| Total reported by Meta | 34 | €3,740 |
Check: 2,420 + 660 + 440 + 220 = €3,740 and 22 + 6 + 4 + 2 = 34 Real Monday orders Meta claims: 22 + 6 = 28 orders, €3,080 of Shopify's €3,630 Click-attributed Monday orders excluding VAT: 2,420 / 1.21 = €2,000 Stricter ROAS: 2,000 / 1,000 = 2.00 (vs 3.74 in Ads Manager)
The two duplicates are not real orders at all. The four later orders are real but belong to other days in Shopify. The six view-through orders are real Monday orders, but Meta's share of the credit is debatable. The 2.00 is still Meta's claim, only a stricter one; for decisions about total budget, look at blended numbers too.
Step 3: from Shopify to the bank
Assume a hypothetical processing fee of 2% plus €0.25 per order (check your own provider's rates).
| Line | Amount |
|---|---|
| Total charged to customers | €3,630.00 |
| Processing fees: 2% × 3,630 + 40 × €0.25 = 72.60 + 10.00 | −€82.60 |
| Refund processed Monday | −€121.00 |
| Payout for Monday's activity | €3,426.40 |
| of which VAT owed to the tax office (630 − 21) | €609.00 |
That €3,426.40 does not land on Monday. It arrives in a later payout, possibly combined with other days, while the deposit you see on Monday belongs to earlier orders. And €609 of it is VAT you will have to pay, so it was never yours.
What the three numbers mean
- Meta: €3,740, a claim that includes VAT, shipping, orders from other days and duplicates.
- Shopify: €2,700 net sales, or €3,509 total sales, depending on the metric you open.
- Bank: €3,426.40, a few days later and mixed with other payouts, VAT still inside.
- Your profit for the day is none of them: you still have to subtract product cost, the shipping you pay the carrier and the €1,000 of ad spend.
How to reconcile every week
- Put the store and the ad account on the same time zone, and note the currency of each.
- Use Shopify orders as the reference and compare net sales excluding VAT, not total sales.
- In Ads Manager, compare click-only attribution with the default to see how much of the value is view-through.
- Check that the pixel and the Conversions API share an event ID so purchases are deduplicated.
- Reconcile payouts against orders, not against days: each payout report lists the orders, fees and refunds it contains.
- Look at the week, not the day; timing differences mostly cancel out over seven days.
This is the work ProfitFly does automatically: it takes Shopify orders as the source of truth, removes VAT, anchors refunds to their orders and puts ad spend next to them on the same time zone, so the number you read is the one you keep.
Frequently asked questions
Why is Meta's revenue higher than Shopify's?
Usually a mix of view-through attribution, purchases reported on the date of the click rather than the order, VAT and shipping included in the value, and sometimes duplicated pixel and API events. Other channels also claim the same orders.
Should Shopify net sales match my bank deposits?
No. Deposits include VAT and shipping, have payment fees and refunds deducted, and arrive in payouts after a delay. Reconcile each payout against the orders it lists instead.
Which number should I use to calculate ROAS?
Use revenue excluding VAT from your real orders, against ad spend in the same time zone and currency. Platform ROAS is useful for comparing campaigns inside the platform, not for knowing whether ads pay.
Does changing the attribution window change my sales?
No. It only changes how many existing orders Meta claims for its ads. Your orders in Shopify stay the same.