Listings analysed
8
Average net margin
21%
Losing money
1
E-commerce Profit Calculator
True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.
SpreadsheetE-commerce OperationsFree
Break each order into referral, fulfilment and refund deductions, then reconcile expected payouts with what reached your bank.
Shown with sample data
Break each order into referral, fulfilment and refund deductions, then reconcile expected payouts with what reached your bank.
Marketplaces pay you a net amount after dozens of deductions, and errors hide in the gap. The Orders sheet takes each order’s item price, shipping charged, referral fee rate, fulfilment fee and any refund and calculates the referral fee, net proceeds and the share of revenue lost to fees. The Payouts sheet totals proceeds per settlement period, subtracts advertising and account-level fees to give the expected payout, and compares it with the actual bank deposit so every difference is flagged for investigation.
Payouts are net of referral fees, fulfilment fees, advertising, subscription fees, refunds, reserves held back and sometimes taxes collected on your behalf. Timing also matters: settlement periods rarely line up with calendar months.
The commission a marketplace charges on each sale, usually a percentage of the total price including shipping. Amazon, for example, charges a category-specific percentage, often around 8–15%.
Check for reserves held back, chargebacks, adjustments and storage or long-term fees not yet entered. If the difference remains, open a case with seller support with the order IDs and settlement ID.
Download a copy
Downloads need a free account.