Online clothing store profit margin: costs and returns

Online clothing store profit margin uses sales after discounts and refunds, with a clear distinction between gross profit, order contribution and net income. Match returned inventory and return handling to the same orders before comparing products. A strong product markup can still leave little profit after shipping, fees and customer acquisition costs.

Start with the order and returns exports

Export order ID, line ID, SKU, category, sale date, gross sales, discounts, refunds and shipped inventory cost. Exclude sales tax held as a liability; treat customer shipping charges consistently with the ledger.

Match the returns file by order and line, retaining refund date, returned quantity, condition and inventory value restored. Do not restore inventory at the refund amount: revenue uses selling price; inventory uses the applicable cost. IRS Publication 334 describes customer returns and allowances as deductions in arriving at net receipts and then deducts cost of goods sold to reach gross profit.

Bring fulfillment, return handling, selling fee and advertising records. Assign costs to orders or products where supported. Document shared campaign allocations separately from directly observed expenses.

Calculate revenue and merchandise cost

This illustrative US clothing store has the following monthly ledger totals. Discounts and refunds occupy separate columns, so refunds are not already deducted from gross sales. There are no customer shipping charges or other revenue in this example. Inventory credits are the recorded cost of inspected returns restored to stock.

Use a worksheet called Orders. Columns A–I below define the first part of the calculation; headings occupy row 1 and the category totals occupy rows 2–3.

Enter these Excel formulas in E2, H2 and I2, respectively, then fill down through row 3:

=B2-C2-D2
=F2-G2
=E2-H2

Total net sales are $50,000 − $2,500 − $10,500 = $37,000. Net merchandise cost is $20,000 − $4,200 = $15,800. Gross profit is therefore $37,000 − $15,800 = $21,200, a 57.3% gross margin.

All money inputs are unrounded; displayed percentages use one decimal place after division. The gross profit margin guide covers the general ratio. Here the important check is that refunds and inventory credits are different records, often arriving on different dates.

Deduct the costs of fulfilling and selling orders

Continue Orders with J for fulfillment, K for return handling, L for selling fees, M for advertising, N for contribution and O for margin. Fulfillment covers outbound shipping and packing; return handling covers postage and processing. Both sit outside merchandise COGS here. Enter these formulas in N2 and O2, respectively:

=I2-SUM(J2:M2)
=IF(E2=0,"",N2/E2)

Dresses contribute $12,000 − $2,000 − $1,000 − $900 − $2,500 = $5,600. Their margin is $5,600 / $21,000 = 26.7%. Total contribution is $21,200 − $3,500 − $1,500 − $1,500 − $4,300 = $10,400; divide by total net sales of $37,000 for 28.1%.

If your worksheet instead holds individual orders, summarize a selected category with SUMIFS. With the category name in Summary!A2, this totals contribution:

=SUMIFS(Orders!$N$2:$N$5000,Orders!$A$2:$A$5000,A2)

Microsoft's SUMIFS documentation explains the sum range and matching criteria range. Covirage is not affiliated with Microsoft.

Reconcile contribution to net margin

Order contribution does not include every business expense. Bring in the remaining ledger lines for the same month, checking that none already appears in the order costs.

Overhead totals $5,200 + $1,200 + $800 = $7,200. Contribution less overhead is $10,400 − $7,200 = $3,200. Then $3,200 − $200 − $600 = $2,400, giving net margin of $2,400 / $37,000 = 6.5%. The income tax expense is a ledger assumption, not a recommended tax rate.

Use the net profit margin guide or profit margin calculator for that final layer. The SEC's financial statement guide distinguishes income statements from cash flows; payment deposits do not establish profit.

Use the result without hiding return timing

Dresses produce more contribution dollars, but T-shirts retain a larger share of sales. Merchandising should review both measures alongside availability and return reasons.

Keep the closed-month ledger view separate from an order-cohort view that tracks later refunds against original sales. Finance owns the period reconciliation; operations owns return condition and inventory recovery; marketing owns campaign cost attribution. For a physical-store comparison, hardware-store margin puts inventory counts and store expenses at the center of the review.

Where it goes wrong

• Refunds deducted twice. Determine whether the order export's sales amount is already net of refunds before applying the formula.
• All returns treated as resalable. Restore only the supported inventory value and account for damage or disposal separately.
• Fees estimated from deposits. Use transaction-level charges and reconcile settlement timing rather than assuming every withheld amount is a fee.
• Advertising omitted or repeated. Include the selected campaign costs once, and distinguish direct assignments from shared-cost allocations.

Analyze your own clothing orders in Covirage

Bring a sample of your own order, returns, fulfillment and expense exports. Covirage maps the columns, and its tools compute and check the margin layers; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, set up your business and bring your records.

See the related approach to customer profitability.