Amazon profit margin worksheet: an illustrative SKU example
Revenue is not profit. A useful Amazon seller profit calculation starts with a consistent time period and a complete cost list. This worksheet is an illustrative management estimate, not a marketplace fee schedule or tax calculation.
Choose a consistent basis
Record currency, SKU, reporting period and unit count. Use sale revenue and costs on the same basis and avoid mixing a tax-inclusive selling price with tax-exclusive costs. Separate a forecast based on assumptions from a historical report based on posted transactions. Ask your accountant how taxes should be treated for your business.
List every cost once
Include product purchase cost, inbound freight, packaging, applicable marketplace fees, fulfillment or delivery charges, storage allocations, advertising and expected return losses. Distinguish per-unit costs from monthly overhead. If fulfillment already includes a delivery charge, do not deduct the same charge again.
Work through an example
Assume a net selling price of 1,000 currency units, product cost of 400, marketplace fees of 150, fulfillment of 100, packaging of 20, advertising of 80 and a returns allowance of 30. Estimated contribution is 1,000 − 400 − 150 − 100 − 20 − 80 − 30 = 220. Contribution margin is 220 ÷ 1,000 × 100 = 22%, before unallocated overhead and taxes. These numbers are hypothetical, not Amazon fee rates.
Stress-test the result
If advertising rises from 80 to 130 per unit while everything else stays unchanged, contribution falls to 170 and margin to 17%. Test a lower sale price or a higher return allowance too. This reveals which assumption matters most before you change a price or advertising budget.
Reconcile estimates with actual records
Compare the worksheet with supported financial records in AI Listers Profit & Loss. Check missing product costs, later refunds, delayed fees and the selected date range. Settlement cash and order profit can differ because they cover different timing and adjustments. General profit analysis needs seller financial records, not buyer names or delivery addresses.