How to calculate Shopify profit from a CSV without double-counting orders

Shopify order CSVs are useful, but a spreadsheet that simply sums the Total column can misstate revenue. Shopify's own export documentation explains that an order with several products has additional lines, with many order-level fields left blank. The right unit of analysis is the order, not each row.

1. Start with the actual Orders export

In Shopify admin, visit Orders → Export, select your date range and export the CSV. Keep one currency per analysis. If you are comparing to cash payouts, also collect Shopify Payments payout or transaction data: the order export and bank deposit are different views of activity. Shopify export instructions.

2. Group line items before totaling revenue

For each unique order Name, read its order Total once. A $120 order with three separate product lines is not $360 of sales. Retain each line's SKU, quantity and unit price for later cost allocation.

3. Use the right profit formula

This is not statutory net profit. It is a management estimate built from your own inputs. Exclude unpaid and cancelled orders, state the analysis period, and do not silently set missing unit costs to zero without a warning.

4. Example: why the details matter

Suppose 50 paid orders produce $6,000 gross receipts, $500 refunds, $300 estimated retained taxes, $2,100 known product costs, $210 payment processing fees, $380 shipping labels, $900 ads and $200 other period costs. Estimated contribution is $1,410, or roughly 27.1% of $5,200 net-of-tax-and-refund sales. It is easy to mistake the $6,000 gross figure for the real picture.

5. Be especially careful with refunds and tax

The Orders export may show refunds belonging to orders placed earlier or later than the period you are evaluating. On a partially refunded sale, the export may not tell you exactly how much sales tax was returned. An estimate must say so. Reconcile against Shopify transaction histories or a finance report before treating numbers as accounting records.

6. Check cost coverage before making decisions

Each product line should have a mapped SKU unit cost. Unmapped items can make calculated profit appear too high. Then review fixed card fees on low-ticket orders, shipping subsidies and returns separately. Only after these checks should you compare products or adjust ad budgets.

Try a private browser-side reconciliation

AfterCosts lets you explore this workflow without connecting Shopify, uploading customer CSVs or handing over API keys. It is a management-estimate tool, not a bookkeeper or accounting replacement.

This article is independent educational content, not affiliated with Shopify. Estimates are not accounting or tax advice. Privacy · Terms.