Ecommerce profit calculator in Excel: how to build one

A spreadsheet is the simplest profit calculator: one row per product, one column per cost. Here is a layout you can copy.

Columns to include

Sell price
Product cost (including inbound shipping)
Platform fee (% of sell price, plus any fixed fee)
Payment fee
Outbound shipping and packaging
Returns allowance (a % you set)
Net profit = sell price minus columns 2–6
Margin = net profit ÷ sell price
ROI = net profit ÷ product cost

Tips

Keep fee rates in separate cells so you can update them when the platform changes them.
Add a target ROI cell and a "max buy price" column: sell price minus all fees, divided by (1 + target ROI).
Use conditional formatting to colour rows under your target.

For a free quick check see what you really make per online sale.

Prefer a ready-made sheet?

The FBA Profit & ROI Calculator (€12) has these columns set up for Amazon UK, with editable rates.

Is this product worth buying? Enter buy price, sell price and fees; the FBA Profit & ROI Calculator shows profit, ROI and BUY or SKIP. Example data.

Not affiliated with, endorsed or sponsored by Amazon. Excel and Google Sheets belong to their owners. Written with AI assistance. General information only, not tax, legal or financial advice; fee and rule examples as at Oct 2026 — check current fees and rules with the official source. No particular sales or profit result is promised.