---
title: "Why Shopify's Sales Report Doesn't Match Your Order Export | Queryful"
description: "Add up an order export and you rarely get the figure in Shopify's sales report. Five reasons why: sales records, refund dates, test orders, edited orders and timezones."
url: https://queryful.app/blog/why-shopify-sales-report-doesnt-match-order-export
locale: en
---

[All posts](https://queryful.app/blog)

[Shopify](https://queryful.app/blog/tag/Shopify)

# Why Shopify's Sales Report Doesn't Match Your Order Export

Add up an order export and you rarely get the figure in Shopify's sales report. Five reasons why: sales records, refund dates, test orders, edited orders and timezones.

20 Nov 2026 · 3 min read

Export your orders for last month, add up the totals, and compare them with net sales in Shopify’s sales report. The two rarely agree, and the gap can be large. Neither figure is wrong. They count different things.

This guide covers the five reasons they differ, and how to get a report that agrees with Shopify’s.

## 1\. The sales report counts sales, not orders

An order export lists each order as it stands today: its current total, after any edits, refunds and returns.

Shopify’s sales report works from a different record. Every time something happens to an order, Shopify records a sale against it: the original order, an edit that adds or removes an item, a return, a refund. Each has its own amount and its own date. Shopify’s own developers point to these records, called sales agreements in the API, as the source of truth for its sales figures.

So an order placed in March for $100, with $20 refunded in April, shows as $80 in an export of March orders. Shopify’s report shows $100 of sales in March and a $20 return in April.

## 2\. Refunds count on the day they happen

That example is the most common cause of a mismatch. In Shopify’s analytics, a refund is recorded on the day it was made, not the day of the order.

If your month had a lot of refunds for orders from the month before, the sales report’s net sales will be lower than an export of that month’s orders. If refunds for this month’s orders come next month, the export will look lower now than the report did at the time.

## 3\. Test orders and gift cards

Shopify’s sales reports leave out test orders. An order export includes them unless you filter them out.

Gift card sales work the other way. Shopify’s analytics doesn’t count selling a gift card as a sale; the sale is counted when the card is spent. An order export includes the gift card order at its full value.

## 4\. Edited and split orders

When an order is edited, the export shows the order’s new total. The sales report keeps the original sale on its original day and records the edit as a separate sale on the day of the edit.

Split and partly fulfilled orders add another wrinkle. The order’s original total and its current total can differ, and which one an export uses decides which figure you get. Shopify points developers at the current total for reconciliation.

## 5\. Timezones

Shopify’s reports use your store’s timezone. An export opened in a spreadsheet, or pulled from the API in UTC, can move an order placed late in the evening into the next day, and a day’s or a month’s total with it.

## How to get figures that match

To match Shopify’s sales report, a report has to be built the way Shopify builds it: from the sales records, each on the day it happened, in your store’s timezone, without test orders.

That’s how [Queryful’s sales reports](https://queryful.app/shopify-sales-reports) work. Sales come from Shopify’s sales agreements, so gross sales, discounts, returns, net sales, shipping and taxes come out the same as Shopify’s, and Queryful checks its daily totals against Shopify’s analytics every night. When you need orders as they stand today, an [order report](https://queryful.app/shopify-order-export) lists them row by row.

For the terms themselves, see [gross sales vs net sales in Shopify](https://queryful.app/blog/gross-sales-vs-net-sales-shopify).

**Queryful is coming soon** Sales and order reports inside the Shopify admin, with figures that match Shopify's own.

[Join the waitlist](https://queryful.app/#waitlist)
