Ecommerce profit margin formula: reconcile sales and order costs

The ecommerce profit margin formula is profit divided by net sales, multiplied by 100, with the costs behind that profit clearly defined. Product gross margin, order contribution margin, and company net margin answer different questions. Start from order sales, rather than the cash a marketplace sends to the bank.

Define the profit before calculating the percentage

Net sales = Item sales − Discounts − Customer refunds + Shipping revenue

Order contribution = Net sales − Product cost − Fulfillment − Selling and payment fees − Return handling − Attributable acquisition costs

Order contribution margin = Order contribution / Net sales × 100

Company net margin = Net profit / Net sales × 100

This is a management reporting definition of contribution. Write down which expenses it includes before comparing channels. Your ledger may classify some fulfillment costs within cost of goods sold; preserve that accounting treatment when reconciling the report.

The IRS explanation of gross profit starts with receipts less returns and allowances, then subtracts cost of goods sold. It also distinguishes freight bringing merchandise into the business from shipping or selling expenses. That distinction helps prevent one shipping charge from appearing in both product cost and fulfillment.

Keep product gross margin for product economics and company net margin for the result after all expenses. Neither substitutes for an order contribution report when a channel has high fees or expensive acquisition.

Build the report from rows you can reconcile

Use an order-line export with order ID, line ID, SKU, channel, order date, sales, discounts, and customer shipping charges. Bring the refund file, product cost records, fulfillment invoices, payment and marketplace fee statements, and campaign spending for the same reporting period.

Join refund and cost records to a unique order or line reference. Where one shipment covers several items, allocate its cost using a documented basis, such as units or shipment weight. Retain the original shipment total so the allocated costs can be checked against it.

Record whether the comparison uses the period's booked refunds or refunds associated with an order cohort. Both can be useful. Mixing the current month's sales with only the refunds already received on those sales understates eventual return costs.

Keep customer sales tax outside sales when it is collected on behalf of a taxing authority under the company's accounting policy. Keep reserve movements outside selling expenses. A cash holdback changes when money arrives; it does not by itself identify a cost of earning sales.

A worked month for a US home-goods seller

The following illustrative report separates direct-to-consumer sales, abbreviated DTC, from marketplace sales. All amounts are USD. Percentages are rounded to two decimal places after calculation; dollar amounts in the example are exact.

Net sales reconcile as $24,000 − $1,000 − $1,600 + $600 = $22,000. Product cost below is the cost charged to these sales after any inventory recovery on returned goods.

For DTC organizers, contribution is $9,400 − $3,900 − $1,100 − $350 − $150 − $1,300 = $2,600. The company calculation uses total contribution divided by total net sales: $5,300 / $22,000 = 24.09%. Do not average the displayed row percentages.

Bridge contribution to the company result

The same sales base produces several valid margins. The difference is the expenses deducted, rather than a different definition of sales.

The check is that net profit plus every deducted expense returns to $22,000. The $3,000 overhead amount must tie to remaining operating expenses after the order costs already charged above. The separate ecommerce gross margin page focuses on product cost classification; it does not replace this order-cost bridge.

The SBA's break-even guidance distinguishes fixed costs from variable costs. Use that distinction when deciding whether extra orders help cover overhead. An allocated overhead charge is useful for a full profitability view, but it does not automatically disappear if a channel closes.

Prove the marketplace payout separately

Suppose the marketplace statement contains only the organizer sales above and these deductions. The cash transfer is smaller than sales, but the difference is fully explained.

The proof runs backward: $3,900 cash + $1,000 fees + $900 fulfillment + $900 advertising + $300 reserve = $7,000 net sales. Treat the reserve according to its actual balance-sheet nature and investigate later releases or deductions. Do not enter $3,900 as sales and deduct those selling costs again.

Where ecommerce margin goes wrong

• Refunds without inventory recovery. Keep the sales reversal, product cost adjustment, and handling cost separate so a saleable return is not treated as total destruction.
• Shipping charged twice. Identify whether supplier freight is already in product cost and whether a marketplace fee already includes fulfillment.
• Campaign spending repeated by SKU. Allocate shared spending once, then check allocations against the campaign statement. Unassigned spending still belongs in the company reconciliation.
• Cash timing mistaken for profitability. Reserves, settlement delays, and supplier payment terms affect cash. They do not change contribution merely because cash moves in another month.

Review both dollars and percentages before reallocating spending. Hooks have the highest contribution margin here, but DTC organizers supply more contribution dollars. For a supplier-direct order model, the dropshipping profit margin workflow covers supplier charges and campaign costs without assuming an industry benchmark.

Reconcile your ecommerce export in Covirage

Bring a sample of your own order, refund, fulfillment, and fee files to Covirage; it maps the columns, and its tools compute and check the figures. The external AI model explains the results 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.