A marketplace sale is profitable only after every relevant cost is accounted for. This reusable marketplace profit margin template shows how to calculate SKU-level net profit, compare seller fees and fulfillment costs across platforms, test price changes, and identify products that look successful in sales reports but contribute little cash.
Overview
Marketplace dashboards often emphasize revenue, order volume, or gross sales. Those measures are useful, but they do not answer the more important question: how much remains from each order after marketplace fees, product costs, fulfillment, advertising, returns, and other deductions?
A practical marketplace fees comparison should use the same product, selling price, order assumptions, and accounting treatment for every channel. Otherwise, a platform with a lower referral commission may appear more attractive even though it creates higher shipping, storage, advertising, or support costs.
Use the worksheet below for each SKU and marketplace combination. The core calculation is:
Net profit per order = recognized revenue − total variable costs − allocated fixed costs
Then calculate the margin percentage:
Net margin = net profit per order ÷ recognized revenue × 100
Keep taxes collected on behalf of a tax authority outside revenue and profit unless your accounting method specifically treats them differently. Also decide whether customer-paid shipping is included in revenue and shipping income before comparing channels. Apply that decision consistently.
This approach is more useful than comparing headline seller marketplace fees alone. It produces an apples-to-apples view of contribution by SKU, channel, and fulfillment method.
How to estimate
Build the worksheet with one row for each product and marketplace. Record the following fields in separate columns:
- Marketplace and SKU: Identify the channel, product variation, and fulfillment method.
- Recognized selling price: Enter the expected price paid for the product, net of discounts that you fund. If the marketplace funds the promotion, record its treatment separately if it affects your payout.
- Marketplace commission: Apply the relevant referral, transaction, category, or final-value percentage to the correct fee base. Some schedules may use item price, order value, or another defined amount.
- Payment processing: Record payment fees as a percentage, fixed amount, or both. Do not assume this cost is included in the marketplace commission.
- Fulfillment and shipping: Include pick-and-pack, delivery, postage, packaging, and any seller-paid shipping subsidy. If you use your own warehouse, include the direct labor or carrier cost attributable to the order.
- Storage: Allocate storage by unit, order, cubic volume, or time period. For slow-moving inventory, use a realistic average rather than ignoring storage because it is billed separately.
- Advertising: Allocate sponsored listing or external advertising costs to the orders they generate. If attribution is uncertain, use a stated assumption and test a conservative scenario.
- Returns and adjustments: Estimate the expected cost of refunds, return shipping, write-offs, replacements, chargebacks, and damaged inventory. A reserve is usually more useful than waiting for a return to occur before recognizing the cost.
- Currency conversion and payout deductions: Include conversion spreads, international payment costs, withholding adjustments, and other deductions that reduce the amount received.
- Product cost: Use the landed cost where possible: supplier price plus inbound freight, duties, inspection, and other costs needed to place the unit into sellable inventory.
- Operating allocation: Optionally assign a reasonable per-order share of software, customer service, warehouse overhead, or platform management costs. Keep this separate from contribution profit so you can see both short-term economics and fuller profitability.
For percentage fees, convert each rate into a currency amount before totaling the row. For example, a 10% commission on a $40 recognized selling price is $4. A fixed fee should be added directly. If a fee has a minimum, maximum, tier, or threshold, use the actual rule for that order rather than applying a simple percentage.
A useful comparison table has these columns: marketplace, selling price, commission, payment fee, fulfillment, storage, shipping, advertising, returns reserve, currency or payout adjustments, product cost, other costs, net profit, and net margin. Add a notes column for assumptions and a date column for the fee schedule used.
Inputs and assumptions
The quality of a marketplace profit margin calculator depends on its assumptions. Label every input as either an observed cost, a contracted rate, or an estimate.
Use SKU-level data
Average store-wide margins can conceal unprofitable products. A lightweight product with low shipping cost may support a different channel from a bulky or fragile item. Calculate at the SKU level, then summarize by category, marketplace, and fulfillment method.
Separate variable and fixed costs
Variable costs change with each order, such as commission, payment processing, shipping, packaging, and product cost. Fixed costs do not change directly with one additional order, such as a monthly subscription or warehouse lease. Track both, but do not mix them without labeling the result.
Contribution profit subtracts costs that are directly linked to the order. Net operating profit may also include an allocation of fixed expenses. Contribution profit helps with pricing and channel decisions; net operating profit helps assess whether the overall business model is sustainable.
Model uncertainty with scenarios
Create at least three versions of the worksheet: expected, conservative, and improved. The conservative version might use a higher return rate, more advertising cost, or a less favorable shipping assumption. The improved version might reflect a negotiated carrier rate, better conversion, or reduced ad spend. Do not present scenarios as forecasts; use them to show how sensitive the product is to changing inputs.
For platform-specific rules, check the current fee schedule, fulfillment terms, payment documentation, and payout reports. This article intentionally does not state marketplace rates because those inputs vary by platform, category, seller plan, location, and date. For shipping and return assumptions, see the comparison of marketplace shipping policies. For broader channel changes, the marketplace audit and migration playbook can help structure an audit.
Worked examples
Assume a seller lists one product at a recognized selling price of $40. The following figures are illustrative inputs, not current marketplace prices:
| Cost or revenue item | Illustrative amount |
|---|---|
| Recognized selling price | $40.00 |
| Marketplace commission, assumed at 15% | $6.00 |
| Payment processing, assumed at 1.5% | $0.60 |
| Fulfillment | $5.25 |
| Seller-paid shipping | $3.00 |
| Storage allocation | $0.40 |
| Advertising allocation, assumed at 6% | $2.40 |
| Returns reserve, assumed at 3% | $1.20 |
| Currency conversion allocation, assumed at 2% | $0.80 |
| Landed product cost | $12.00 |
| Packaging | $0.75 |
| Allocated operating cost | $1.50 |
Total modeled costs are $34.90, leaving $5.10 in net profit. The net margin is 12.75% ($5.10 divided by $40). If allocated operating cost is excluded, contribution profit is $6.60, or 16.5%. Reporting both figures makes the decision clearer: the order contributes cash before overhead, but its fuller profitability is lower.
Now test a $3 price increase while holding dollar costs constant. The new recognized selling price is $43. If commission, payment processing, advertising, currency conversion, and returns reserves remain percentage-based, those costs rise; fixed fulfillment, packaging, and some shipping costs may not. Recalculate every affected column rather than adding the full $3 to profit. The result shows whether the price change improves margin without materially reducing expected order volume.
You can also compare a second marketplace by replacing only the assumptions that change: commission structure, payment fee, fulfillment charge, shipping responsibility, advertising cost, and return exposure. Keep the same product cost and selling price where the customer offer is genuinely comparable. This is the foundation of a useful online selling platforms comparison.
When to recalculate
Recalculate the worksheet at least monthly for active products, and immediately before major pricing or inventory decisions. Revisit it in these situations:
- A marketplace changes commissions, payment processing, fulfillment, storage, returns, payout, or advertising terms.
- A carrier, supplier, warehouse, or payment provider changes its rates.
- You change price, discounting, shipping promises, fulfillment method, or advertising strategy.
- Returns, cancellations, chargebacks, or damaged-stock rates move away from the assumed reserve.
- You enter a new country, currency, category, or marketplace.
- Seasonal demand changes storage duration, shipping costs, conversion, or advertising efficiency.
- You are deciding whether to reorder, discontinue, bundle, or migrate a product.
Keep an archived copy of each version with its effective date and source notes. After a month closes, compare modeled costs with actual payout reports and update the assumptions that were consistently wrong. Flag products below your minimum acceptable margin, then test a price change, packaging change, fulfillment change, or channel change before taking action.
Finally, connect product economics to channel quality. A listing that generates leads or orders is not automatically valuable if the resulting contribution is weak. For directory or lead-based channels, the same discipline applies: review the directory listing ROI framework and compare spend with qualified leads, customers, and revenue. Recalculated regularly, this worksheet becomes a practical decision tool for marketplace fees, product pricing, and sustainable growth.