Orders6 min read
Why Shopify's Orders CSV Double-Counts Discounts and Refunds
Shopify orders CSV discount and refund totals don't add up? Learn why order-level columns get double counted and how to export one row per order with a net total.
In this guide
If your Shopify orders CSV double-counts discounts and refunds, the cause is the file’s shape, not your maths. Shopify’s orders export has one row per line item, but discount and refunded amounts belong to the whole order, so any step that copies them onto every line of a multi-product order makes the column sum too big. The fix is to total from a file with one row per order, and to work out the net total once per order: total minus refunded.
You or your accountant export a month of orders, add up the Discount Amount and Refunded Amount columns, and the result doesn’t match what you expected. This post explains where the extra comes from, how to check your own file in a few minutes, and how to get a file with one row per order and a net total after refunds.
This is practical guidance on getting data out of Shopify, not tax or accounting advice.
Why do the discount and refund totals come out wrong?
Shopify’s order export is built around line items. An order with three products becomes three rows. That works for picking and packing. It is awkward for money.
Discount Amount, Refunded Amount, Shipping, Taxes and Total belong to the order, not to a single product line. In Shopify’s export they sit on the order’s first row, and the extra rows of a multi-product order are left mostly blank. The trouble starts when someone makes that file easier to work with:
- Filling down. The blank cells make the sheet hard to sort and filter, so many people fill the order’s values down onto every line. That copies the order-level discount and refund onto each line too. A 10 EUR discount on a three-product order now adds up to 30 EUR. (We covered the blank cells in Shopify Order Export Has Blank Cells on Multi-Product Orders.)
- Pivoting by product. A pivot table or SUMIF by product picks up the order-level amount on whichever rows carry it, so the discount and refund land on one product or on all of them, never split the way they were applied.
- Mixing line and order discounts. The export also has a Lineitem discount column. A product discount can show up there and in the order’s Discount Amount, so adding the two columns together can count the same discount twice.
Partial refunds make it worse. If a customer returns one of three items, Refunded Amount is still one figure for the whole order, and a one-row-per-product file has no clean way to put it on the right line. The same mismatch comes up in Shopify Community threads, including thread 580682.
One more gap is about dates, not rows: the order export shows a refund on the original order whenever it happened, while Shopify’s finance reports record it on the date it was processed. If you compare the CSV with a report, compare the same thing.
How do I check whether my file has this problem?
Before changing anything, confirm that this is your problem:
- Export a month of orders from Shopify as CSV and work in a copy.
- Add a column that counts rows per order, for example
=COUNTIF(A:A, A2)if the Name column is A. - Filter for orders with more than one row.
- Look at the Discount Amount and Refunded Amount cells for those orders. Are the values on the first row only, or repeated on every row?
- Sum each column twice: once over all rows, once over the first row of each order only. If the two sums differ, the repeated values are your gap.
If the gap exists only on multi-product orders, you have found it. Single-product orders always add up, which is why the error looks random.
What layout gives totals that add up?
Stop summing order-level values across line-item rows. For totals, you want a file where each order is one row and each money column appears once:
| Layout | Good for | Discount and refund sums |
|---|---|---|
| One row per line item (Shopify’s export) | Picking, packing, product detail | Wrong as soon as order values are filled down |
| One row per line item, filled down | Sorting and filtering by product | Counted once per line, so too high |
| One row per order | Accounting and month-end totals | Each order counted once |
In the one-row-per-order file, keep at least:
- Order number and date
- Currency
- Discounts
- Total
- Refunded
- Net total, a formula you add: Total minus Refunded
Then a plain SUM works on every column. If you still need product detail, such as engraving text or a gift message, keep it in a separate line-item export, never in the sheet you use for totals.
How do I export one row per order with Columna?
Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX from a saved template, and the file is built in your browser. A template can put one row per order, with order columns such as Subtotal, Shipping, Taxes, Discounts, Total and Refunded.
- Install Columna: Order Export & Sheets and open it from your Shopify admin.
- Build a template: choose one row per order, then pick Order, Created at, Currency, Discounts, Total and Refunded. Put them in the order your accountant expects and rename the headers if needed.
- Filter by date range, for example last month, plus the payment status, fulfillment status or tags you always use.
- Download the file as XLSX, so the money columns can be summed straight away.
- Add a Net total column, Total minus Refunded, and run the check from the section above. Each order now has one row, so nothing is counted twice.
Next month, open the same template and change only the date range. On the Pro plan, the same export can be emailed to you on a schedule, daily or weekly. The app does not connect to accounting software; you send the file on.
Refunds come out per order. If you need to know which item a partial refund was for, open that order in Shopify.
Month-end checklist
- Use one row per order for totals, and a separate line-item file for product detail.
- Never fill down order-level columns in a sheet you sum.
- Don’t add Lineitem discount and Discount Amount together.
- Compute the net total once per order: Total minus Refunded.
- Keep the same template and filters every month, so the months are comparable.
For which columns an accountant usually wants and how they relate to Shopify’s finance reports and payouts, see our Shopify order export for accounting guide.
FAQ
Why are discounts double counted in my Shopify orders CSV?
Because the export has one row per line item and Discount Amount is an order-level value. If it ends up on more than one row of the same order, for example after filling cells down, every copy is added to the sum.
Does Shopify repeat the refunded amount on every line item?
No. Shopify’s export puts order-level values such as Refunded Amount on the order’s first row. They get repeated when the file is filled down or merged by hand.
Can I split a partial refund across line items in the CSV?
Not cleanly. Refunded Amount is one figure for the order. Keep refunds at order level for totals, and check the order in Shopify when you need to know which item was returned.
How do I get a net total after refunds?
Export one row per order with Total and Refunded columns, then add a column that subtracts Refunded from Total. Summing that column gives the month’s net order total.
Why doesn’t my CSV refund total match Shopify’s finance reports?
The order export shows a refund on the original order whenever it was made; finance reports record it on the date it was processed. A refund in October for a September order lands in different months.
Get totals that add up
Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties such as engraving, gift messages and upload links, built in your browser, for shops that hand orders to production, fulfilment or accounting. A one-row-per-order template gives your accountant discounts, totals and refunds that are counted once.
Try Columna: Order Export & Sheets on the Shopify App Store and run last month’s orders through a one-row-per-order template.