Shopify can show gross sales, net sales, total sales, orders, and average order value for the same period. The numbers differ because they answer different questions. The trick is not finding one “true” number; it is choosing the right number for the decision, then preserving the same supporting fields every month.
Leafy’s Quick Answer
Read net sales first when you want to understand product revenue after discounts and sales reversals. Use gross sales to see demand before those adjustments, and total sales when shipping, taxes, duties, and fees belong in the view. Then use LedgerLeaf Free to save the order, payment, customer, and tax columns behind your bookkeeping workflow as a reusable CSV or Excel export.
That last step matters. A report can explain this month, but a saved LedgerLeaf profile makes the explanation repeatable next month.
Gross, net, and total sales answer different questions
Shopify’s current analytics field reference defines the three figures this way:
| Shopify number | Simplified meaning | Best first use |
|---|---|---|
| Gross sales | Product price × quantity before discounts and sales reversals | See full-price demand |
| Net sales | Gross sales − discounts − sales reversals | Compare product revenue across periods |
| Total sales | Net sales + fees + duties + shipping + taxes | See the wider customer-charge picture |
Suppose a store records €12,000 in gross sales, €900 in discounts, and €600 in sales reversals. Net sales are €10,500. Add €480 in shipping and €2,205 in tax, and total sales become €13,185.
Those figures do not conflict:
- €12,000 shows demand before reductions;
- €10,500 shows sales revenue after reductions;
- €13,185 includes amounts that are not all product revenue.
For most performance reviews, net sales is the clearest starting point. Gross sales and the deductions explain how you arrived there. Total sales is useful when you need the complete customer-charge view, but tax collected should not quietly become a revenue assumption.
Use four views instead of one overloaded dashboard
1. Net sales over time: “Are product sales improving?”
Start with net sales grouped by week or month and compare like-for-like periods. Keep gross sales, discounts, and sales reversals visible beside it. A rising gross figure with flat net sales can point to heavier discounting or more reversals rather than healthier revenue.
2. Sales by product or variant: “What is actually selling?”
Use product or variant views to compare net sales and net quantity. Shopify notes that product reports exclude shipping because one shipping charge cannot be reliably divided across several products. Variant-level reporting is the more useful view when size, colour, or SKU changes the commercial decision.
3. Orders and average order value: “Did volume or basket size change?”
Order count adds context to the revenue trend. Shopify currently calculates average order value as (gross sales − discounts) ÷ orders, excluding post-order adjustments. Read the formula before comparing AOV with a number created elsewhere.
4. Discounts and sales reversals: “What pulled gross sales down?”
Do not hide the bridge between gross and net sales. Review discounts separately from sales reversals so a promotion, cancellation, return, refund, or order edit does not disappear inside one net figure. Shopify records reversals on the date they are processed, which can make a period look unexpectedly low or even negative.
Turn the report review into a LedgerLeaf export
Once you know which numbers matter, preserve the evidence behind them. In LedgerLeaf Free:
- Set the period and filters for the bookkeeping task.
- Choose the order, payment, customer, tax, and other sales columns the handoff actually needs.
- Export CSV or Excel.
- Save the column preset and export profile.
- Reuse the same structure next period and investigate only what changed.
This is where LedgerLeaf earns its place in the workflow. Shopify’s reports help you interpret performance; LedgerLeaf turns the relevant Shopify sales data into a consistent working file for month-end review or accountant handoff. Without the saved profile, the same report-reading decision becomes another round of deleting, renaming, and rearranging columns.
Leafy’s Watch-Out
Sales reports are not bank reports. Shopify says they track the value of goods and adjustments, not the timing of money received, and chargebacks are not included. Use payments and payout records for cash movement; do not force a sales total to equal a bank deposit.
If two reports still disagree, check the date range, time zone, filters, grouping, returns or sales-reversal timing, order edits, deleted or test orders, and whether one file is a sales report while the other is an orders export. Shopify’s sales discrepancy guidance explains why those views can legitimately differ.
The memorable habit is simple: read net sales first, explain the bridge, then save the supporting data with LedgerLeaf.
Start with free, reusable Shopify sales exports in LedgerLeaf.
