Open the Shopify admin and look at Monday’s revenue. Open Amazon Seller Central and look at the same date. Then open your accounting software. If you sell on both platforms, those three numbers are almost never going to match. If they do, something has probably been reconciled behind the scenes.
The default conclusion is "one of the platforms is wrong." The honest conclusion is "both platforms are counting different things, in a different order, and calling them by the same name." Once you know what each one is really measuring, reconciling them is a tractable problem.
Shopify counts orders. Amazon counts settlements.
Shopify, by default, counts an order when the order is placed. The revenue number you see on a given day is the sum of orders placed that day, with fulfilment, returns, and chargebacks still in the future.
Amazon, by contrast, is more conservative about when a number is "real." Amazon reports and payouts work on a settlement cycle. Returns are deducted inside the settlement window, fees are deducted at settlement, and chargebacks can land after the fact.
That one difference alone is enough to create a mismatch of 10 to 30 percent in a given week for a brand that sells across both platforms. One platform is reporting a gross forward looking number. The other is reporting a net backward looking number. Comparing them side by side is apples to oranges.
The second difference: fees
Shopify fees are mostly payment processing, charged on each transaction and visible as a separate line. Amazon fees include referral fees, FBA fulfilment fees, storage fees, long term storage fees, inbound shipping, labelling, and advertising placements. Each of them is a different fee schedule, with its own trigger.
A single Amazon order can involve five to seven separate fee deductions, applied over time, in different reports. Reconciling a given order to its true net revenue is a non trivial exercise. Many brands do not try, which is why the two platforms appear to disagree.
The third difference: returns
Returns are reversed sales. On Shopify, a return typically shows up as a refund against the original order, with a date of its own. On Amazon, returns can appear as inventory adjustments, reimbursement claims, or reserve adjustments, depending on the reason. Return rates can also differ meaningfully between the two platforms for the same SKU, because the buyer populations and the return policies differ.
How to reconcile the two
This is a solvable problem, but it is a modelling problem, not a dashboard problem. The approach we take looks like this:
- Define one canonical "order event" model that applies across platforms. For each order, record the order placed date, the fulfilment date, the settlement date, and the return date, if any.
- Normalise fees. For each order, attach the full stack of fees that apply to it: payment processing, referral, FBA, advertising, promotion funding. Attach the fee at the earliest date you can confirm it.
- Settle one date definition. Pick one. Most finance teams want settlement date, because that is when the money is real. Most marketing teams want order placed date, because that is when the campaign effect is measured.
- Build dashboards around two views, not one. The "operations" view shows orders placed and expected revenue. The "finance" view shows settled revenue, net of fees and returns.
- Reconcile monthly. A one page report that shows the gap between the two views and explains it. Over time, the explanations become patterns, and the patterns become reporting rules.
Done once, this takes weeks. Done every month, it takes an hour. The payoff is that nobody in your team is ever caught between two numbers that disagree without an answer. "Shopify says X and Amazon says Y, and here is the reconciliation" becomes a standing line in the weekly review, not a crisis every month.
A note on what Amazon reports
If you want to start from the primary records, the Payments report and the Settlement report in Amazon Seller Central are the most reliable sources of truth. They contain the fee breakdown and the settlement date for every disbursement. The Business Reports section is useful for order and traffic, but it is not where you reconcile money. For the authoritative description of what each report contains, see Seller Central Help.
The honest, defensible, finance ready version of a multichannel revenue number is almost always built in a reporting layer that sits on top of both platforms, rather than in either platform itself. That is where the reconciliation can live, and where the whole team can agree on one number.