Why the Numbers Don’t Match
The three systems are each telling the truth. They’re just telling different truths, on different timelines, using different definitions. Here’s what’s actually happening under the hood.
Shopify counts orders. When a customer hits “Place Order,” Shopify books revenue. That number is gross. It doesn’t care whether the order later gets refunded, whether the shipping was comped, whether the discount code cut 20% off, or whether a third of it was sales tax.
Amazon counts disbursements. Amazon’s reporting is built around what eventually lands in your bank account — which is gross sales minus referral fees, FBA fees, storage fees, returns, promotional rebates, and whatever else Amazon decides to deduct in a given 14-day settlement window. By the time you see the number, it has already been reshaped.
QuickBooks counts deposits. Most SMB accounting setups simply record the bank deposit — whether from a Shopify payout or an Amazon settlement — as revenue. That means QuickBooks is looking at net-of-fees, cash-basis, sometimes-weeks-delayed numbers. It has no idea how many units were sold, at what price, through which channel, or with what margin.
So when someone asks “How much did we make last week?” — Shopify, Amazon, and QuickBooks are each answering a different question.
What This Actually Costs You
On paper, mismatched numbers look like an accounting nuisance. In practice, they quietly cost multi-channel retailers real money — in three specific ways.
You can’t trust channel profitability. If Shopify says a product grossed $18,000 last month and QuickBooks shows $14,200 deposited, you have no idea what the actual contribution margin was. Decisions about ad spend, SKU rationalization, and inventory allocation are being made on incomplete data.
Inventory and COGS drift. If returns, refunds, and fee structures are hitting the accounting system in a different shape than the orders they relate to, your cost of goods sold calculation is almost certainly wrong — usually in the direction of making margins look better than they are.
Sales tax gets messy. Shopify collects and remits differently than Amazon. If your books treat both as identical revenue deposits, you’re either over-remitting, under-remitting, or flying blind at year-end.
Industry benchmarks put the cost of poor data quality at roughly 12% of annual revenue. For a $3M multi-channel retailer, that’s north of $350K a year hiding inside the gaps between these three systems.
The Right Question Isn’t “Which Number Is Real?”
It’s “Which definition of revenue am I trying to see right now?”
Because the honest answer is: all three numbers are real. They’re just measuring different things.
Gross order revenue tells you how your customers and marketing are performing.
Net channel revenue tells you what each platform is actually worth to the business after its cut.
Cash-basis revenue tells you what hit the bank.
A healthy multi-channel business needs all three — clearly labeled, consistently defined, and built on the same underlying data. Not three Monday-morning tab-switches producing three disconnected guesses.
What the Fix Actually Looks Like
The fix isn’t to pick one system as the “source of truth” and ignore the others. Shopify isn’t going to start reporting Amazon’s fees, and QuickBooks isn’t going to start tracking SKU-level orders. That’s not what they’re built for.
The fix is a thin data layer underneath the three systems that does four things:
Pulls raw transactional data from each source — orders from Shopify, settlements from Amazon, deposits from QuickBooks — without modifying anything in the systems themselves.
Reconciles them to a shared definition. Every order gets tracked from gross → net → deposited, so you can always see where the money went between sale and bank.
Exposes three labeled revenue metrics — gross, net, and cash — in one place, with filters for channel, SKU, and time period.
Flags discrepancies automatically. If Amazon’s reported sales don’t reconcile to its deposits within the expected fee range, the system tells you — you don’t have to find it three weeks later.
This isn’t an enterprise data warehouse. For most SMBs, it’s a focused pipeline that takes somewhere between four and eight weeks to build and runs quietly in the background forever. The output is one dashboard where leadership can finally answer “How much did we make last week?” without opening three tabs.
The Real Goal
The goal isn’t perfect numbers. It’s consistent numbers — where the business, the finance team, and the accountant are all working off the same definitions, and the differences between Shopify, Amazon, and QuickBooks are explained, not argued about.
That’s what separates a multi-channel business running on instinct from one running on information.
And it’s almost always closer than retailers assume.
Evulta helps small and midsize businesses unify data from Shopify, Amazon, QuickBooks, CRMs, and other systems into one reliable reporting layer. If you’re tired of chasing three different numbers every Monday, book a free 15-minute Data Clarity Call — we’ll walk through your current setup and show you where the gaps are.
