ADSX
NOVEMBER 16, 2026

Trace Shopify Net Sales When a Refund Lands Next Month

Reconcile two reporting periods with a variant worksheet that preserves the date and sign of each adjustment.

AUTHOR
AT
AdsX Team
ECOMMERCE EDITORIAL
READ TIME
3 MIN
SUMMARY

Reconcile two reporting periods with a variant worksheet that preserves the date and sign of each adjustment.

A jacket sells on October 31. The buyer returns it on November 2. The team sees negative November net sales for a jacket it never sold in November. Before correcting the catalog or blaming an ad campaign, follow the two dates in the sales report.

October 31 — Gross $100 — Discount $20. November 2 — Full reversal — Net change -$80. Both months — +$80 then -$80 — Net sales $0
OCTOBER 31 — GROSS $100 — DISCOUNT $20. NOVEMBER 2 — FULL REVERSAL — NET CHANGE -$80. BOTH MONTHS — +$80 THEN -$80 — NET SALES $0

Original AdsX illustration.

Put the sale and the reversal on their own rows

Shopify records sales on the day they occur and reversals on the day they are processed. Sales reversals can arise from edits and cancellations as well as physical returns. Keep the report date, variant identifier, currency, order reference and adjustment description when you export. Replace customer details with an internal alias before sharing rows with an assistant. Shopify sales report definitions

Suppose the jacket sells for $100 with a $20 discount. Ignoring tax, shipping and fees, October net sales are $80. A full merchandise reversal in November contributes minus $80 to November. Combined net sales are zero. If your export breaks the reversal into components, sum the associated signed amounts once. Subtracting the original $20 discount from the already discounted $80 a second time will leave a spurious balance.

Give the assistant a control total

Export the same report twice, once for each month, using identical channel and currency filters. Supply the native net-sales totals alongside your rows. Ask the assistant to sum each month, match the two entries by reference and flag the residual between its sum and Shopify’s figure. If the totals disagree, look first for missing rows, mismatched filters and repeated order-level values on variant lines.

A payment payout can cross yet another date boundary. For this merchandise check, finish with the sales report. Bring in product costs only when the question shifts to gross profit. A matched return can explain a negative sales day without establishing whether a campaign earned money. Shopify profit reports

Try the worksheet prompt

Illustrative prompt, not execution-tested.

Using these fictional dated merchandise rows, preserve signed values and currency. Show net sales per month, pair each reversal with its original order reference and calculate the residual against each supplied control total. Flag unknown adjustments and duplicate values. Do not infer payout or profit.

Copy the prompt from the merchant library. For related work, see Why Shopify Gross Profit Can Leave Out a Best Seller.

ABOUT THE AUTHOR
AT
AdsX Team
ECOMMERCE EDITORIAL

AdsX Team is the shared editorial byline for our Shopify and ecommerce publication. Guides combine primary sources with practical decision frameworks and clearly labeled examples. See our editorial policy for sourcing and corrections.

MORE BY ADSX TEAM →