Why Your Shopify Reports Don't Match Your Orders

Updated November 2026

You export your orders, add them up, and the total doesn't match Shopify's Sales report. Or the order count is off by a handful. It's natural to conclude that Shopify's dashboard reporting isn't accurate. Almost always, it is. The report and the export are counting different things, on different dates, in different time zones.

Below is a checklist of the real causes, each with what you'll see and how to check it. Work through it in order: the first three explain most gaps.

1. Test orders

Orders placed through Shopify's Bogus Gateway or a payment provider's test mode are marked as test orders. Shopify's analytics discrepancies page says test orders aren't included in Sales reports but are included in your orders export.

What you'll see: the export has more orders and more sales than the report, often from the week the store was set up or a checkout change was tested.

How to check: in your export, look for orders whose payment method is "bogus" or a test gateway. Remove them and compare again.

2. Time zones

Shopify's reports use the time zone in your store settings. Exports and third-party tools may use UTC instead. Supermetrics' time zone doc walks through a store set to UTC-7 where one order lands on September 21 in Shopify and September 22 in a report built in UTC.

What you'll see: daily totals that disagree while the monthly total is close. Late evening orders move to the next day, and the first and last day of any range are off the most.

How to check: find your store's time zone in Settings, under Standards and formats. Set the other tool to the same zone, or shift its timestamps by the offset, then compare a single day.

3. Order date, paid date or payout date

An order has several dates: when it was created, when it was paid or processed, and when the money reached you in a payout. Shopify's sales reports date an order by when it was processed. Orders imported from another system, or created through an app or the API, can have a processed date that differs from the date the record was created. A payout covers orders from earlier days, after fees.

What you'll see: the right orders in the wrong date range, or a payout that never equals any one day's sales.

How to check: pick one date for both sides. In the export, use the Paid at or Created at column that matches how the report is dated. For payouts, match by the orders each payout lists, not by date.

4. Refunds and order edits land in a later period

A refund, a return, or an edit to an order after it was placed is recorded on the day it happens, not on the original order date. Shopify's discrepancies page also notes that a refund entered as a custom amount, with no products restocked, doesn't show in the Sales report but is included in the orders export.

Merchants comparing exports to analytics in the Shopify Community point to this as a common reason an order matches on gross but not on net.

What you'll see: last month's order total matches on gross but not on net, or this month has a negative day with no matching sale.

How to check: widen the date range so it covers both the order and its refund, and compare gross sales and refunds as separate lines rather than one net figure.

5. Order-level discounts are spread across line items

A discount code applied to the whole order is allocated across its line items. The order shows one discount, but each line carries its share.

What you'll see: line totals in a line-item export that don't add up to the order total, or a product report where per-product sales look slightly low.

How to check: sum each line's price times quantity minus its discount allocation. That total should match the order subtotal. If you only subtract line-level discounts, the order-level code is left out.

6. Gift cards and zero-value lines

Selling a gift card brings in money but isn't a sale of goods until it's redeemed, so sales reports treat it separately. Free items, samples and $0 lines add to an order's line count without adding revenue.

What you'll see: order counts that differ while revenue is close, or extra $0 orders in one view and not the other.

How to check: filter gift card products and $0 orders out of both sides, then compare counts again.

7. Taxes, shipping and currency

Gross sales, net sales and total sales each include or leave out taxes and shipping. If you sell in more than one currency, a report in your store currency and an export in the customer's currency will differ by the conversion.

What you'll see: a steady gap of a few percent that grows with tax rates, shipping charges or foreign orders.

How to check: compare like with like, for example net sales before tax and shipping on both sides, in the store currency.

8. Deleted orders, products and customers

Shopify's discrepancies page is direct about this one: if you delete an order, customer, product or variant, its data is removed from the reports.

What you'll see: an older export, or another tool that copied the order before it was deleted, still has it, while Shopify's reports no longer do.

How to check: look up the missing order number in your admin. If it isn't there, it was deleted, and reports from now on will leave it out.

9. Sales versus payouts: fees, refunds, chargebacks and tax

If the number you're comparing against is your bank account, the gap is bigger again, because Shopify's headline sales figure comes before several deductions:

  • Processing fees come off before the payout. Shopify Payments charges 2.9% plus 30 cents per transaction on the Basic plan, lower on higher plans. On a $50 order that's $1.75, and on 200 orders a month it's $350 that's in sales but never reaches you.
  • Refunds are taken out of your next payout, while the original sale stays in the period it happened.
  • Chargebacks take the sale amount plus a $15 fee out of your payout, and the original sale stays in your sales history.
  • Sales tax is in the total sales figure but isn't yours. At 8% tax, about $740 of $10,000 in sales is tax.
  • Timing: Shopify Payments usually deposits a sale about two business days later, so a Friday sale lands Tuesday or Wednesday and weekly totals rarely match your deposits.

How to check: match each payout to the orders it lists rather than to a date. Once a month, take gross sales, subtract fees, refunds and tax, and compare that with your deposits for the month. For most stores on the Basic plan the gap between gross and what you keep is 8 to 15%, and knowing your own rate makes the rest of your numbers easier to trust.

10. Analytics sessions and GA4

Shopify's sessions and conversion rate come from browser tracking, so ad blockers, rejected cookie banners and people switching devices are undercounted. The orders are real; the sessions behind them are missing. Merchants have reported conversion rates of 0.2% in analytics when their real orders were 4 to 6% of visitors.

Google Analytics 4 adds a third set of numbers. It counts purchase events by session, can put a delayed purchase in a different place than Shopify records the order, and only reflects refunds if refund events have been set up, which most small stores haven't.

How to check: use Shopify's orders for revenue, and analytics and GA4 for traffic and relative trends. Trying to make all three agree exactly isn't a fixable problem.

How Flumen counts each of these

Flumen's Shopify dashboards pick one definition for each point above and stick to it, so the numbers you see line up from one chart to the next:

  • Test orders: left out, the same as Shopify's Sales reports.
  • Time zone: every order is shown in your store's time zone, read from your Shopify settings.
  • Date: orders are dated by when they were processed, as Shopify's reports do.
  • Refunds and edits: refunds are recorded on the day they happen, as their own line, and orders edited in the last seven days are synced again.
  • Discounts: every discount on a line, order-level codes included, comes off that line's sales.
  • Gift cards and $0 lines: a gift card sold counts as a sale on the day it's bought, and orders paid with a gift card show Gift Card as the payment method. Lines with no quantity are skipped.
  • Taxes, shipping and currency: net sales are line items after discounts, without tax, tips or shipping, in your store's currency. Tax is shown on its own.
  • Deleted records: an order Flumen has already synced stays in your dashboard if it's later deleted in Shopify, so a deleted order can explain a difference here too.

Below is a live Flumen e-commerce dashboard with sample data.

Loading dashboard...

Frequently asked questions

Is Shopify's dashboard reporting inaccurate?

Usually not. Shopify's reports and your order export count different things: reports leave out test orders, follow your store's time zone, date refunds on the day they happen, and treat taxes, shipping and gift cards in their own way. Line the two up on the same definitions and most of the gap disappears.

Why does my Shopify order export show more sales than my Sales report?

The most common reasons are test orders, which are in the export but not in Sales reports, refunds entered as a custom amount without restocking, which are in the export but not in the Sales report, and refunds or edits that land in a different date range than the original order.

Why don't my Shopify sales match my payouts?

Payouts come from payments, not orders, and they arrive on a schedule after the sale with Shopify's fees already taken out, so a day's sales and a day's payout will rarely match. To tie them together, look at which orders each payout covers rather than matching dates.

See what Shopify Analytics doesn't show you