Dropshipping profit margin: costs that determine the result

Dropshipping profit margin is defined profit divided by net sales, with the costs included in that profit made explicit. For product and channel decisions, calculate contribution after supplier charges, shipping, fees, return costs, and acquisition spending. Then reconcile the remaining company expenses before calling the result net profit.

Start with the exports you already have

Use order lines with order ID, SKU, channel, sale date, item sales, discounts, and refunds. Match supplier invoices and credits to those orders, then add shipping charges, transaction fees, return handling, and campaign spending. Keep customer shipping revenue in sales if your accounting policy recognizes it there; the example below has none.

The IRS gross-profit guidance subtracts returns and allowances from receipts before cost of goods sold. That provides a useful sales starting point, although this management contribution report also deducts costs below gross profit. Use the separate gross profit margin guide for that narrower measure.

Do not use the supplier's current catalog price for historical orders. Use the invoiced cost, including credits, for the orders sold. Flag unmatched invoices and unresolved refunds rather than filling blanks with zero.

Set up one calculation row per reporting group

The following illustrative US retailer sells two products during one month. Group A and group B each contain matched order lines for one product and channel. All amounts are USD; percentages are rounded to two decimal places only after calculation.

Enter these Excel formulas in row 2, then fill down to row 3:

E2=B2-C2-D2
K2=E2-F2-G2-H2-I2-J2
L2=IF(E2=0,"",K2/E2)

Format column L as a percentage. In row 4, total each money column and divide total contribution by total sales:

E4=SUM(E2:E3)
K4=SUM(K2:K3)
L4=IF(E4=0,"",K4/E4)

For grouping a longer prepared sheet, put the desired group in N2. The following adds contribution for that group, using the illustrative rows above; extend every range together for a larger export:

=SUMIFS($K$2:$K$3,$A$2:$A$3,N2)

Microsoft documents SUMIFS as adding values whose corresponding criteria match. Use the same grouping rule for sales and contribution before dividing them. Covirage is not affiliated with Microsoft.

Prove contribution and the company result

The order-cost identity is $7,200 net sales = $3,000 product + $1,020 shipping + $260 fees + $220 returns + $1,600 acquisition + $1,100 contribution. Each cost total must also match its source statement, after documented timing differences.

That gives contribution of $1,100 / $7,200 = 15.28%. Before acquisition spending, contribution would be $2,700, or 37.50%; it is a different measure, not evidence that advertising has no cost.

Operating margin is $100 / $7,200 = 1.39%. The net profit margin guide explains the further bridge through financing costs and income taxes. Keep those company items separate when deciding which product produces contribution.

Test acquisition spending against the room left

Group B has $2,700 − $1,100 − $420 − $100 − $80 = $1,000 available before acquisition costs. Its current $700 acquisition expense leaves $300. That $1,000 is the maximum spending at which this group reaches zero contribution under unchanged sales and other costs; it leaves nothing for company overhead.

This sensitivity changes only acquisition spending. It is not a prediction that revenue stays constant when campaigns change. Check the actual order cohort, including later refunds, before changing the budget.

Where dropshipping margin goes wrong

• Supplier shipping counted twice. Split an invoice only when its shipping component is not already included elsewhere.
• Refunds without supplier credits. Track the customer refund separately from whether the supplier reimburses product cost.
• Campaigns assigned more than once. Check that group allocations equal the source campaign total and retain any unassigned amount.
• Payouts treated as sales. A payment settlement may already deduct fees or hold back reserves. Reconcile it without deducting those charges again.

For the broader order-to-ledger bridge, use the ecommerce profit margin formula. Compare campaign investment separately with ROI and profit margin, since their denominators answer different questions.

Check your own order economics in Covirage

Bring a sample of your own order, supplier, and campaign exports to Covirage; it maps the columns, and its tools compute and check the figures. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your export.

See customer profitability for the supporting business context.