Ecommerce Profit Calculator

What the formula says

Ecommerce profit at the business level is revenue less returns, less cost of goods on what was kept, less fulfilment, less advertising, less platform and payment fees, less overheads. The order matters because each line applies to a different base.

Returns come off first, because refunded revenue was never revenue. Advertising, though, applies to gross orders including the ones later refunded; you paid to acquire them either way. Getting those two bases the wrong way round understates the cost of returns, which is the most common error in ecommerce profit modelling.

The numbers, worked through

Monthly revenue $80,000 with a 12% refund rate leaves $70,400 net. Cost of goods at 40% of net is $28,160. Fulfilment and shipping $11,200. Platform and payment fees $6,400. Advertising at 18% of gross, not net. Is $14,400. Overheads $9,000.

Profit is $1,240, a 1.6% net margin on $80,000 of gross sales.

Now cut the refund rate to 7%. Net revenue becomes $74,400, cost of goods $29,760, and profit rises to $3,640, nearly tripling on a five-point change in returns. Nothing about the product, the price or the advertising moved.

What the number leaves out

It treats stock purchases as cost of goods sold, which they are not until the goods sell. A month with a large inbound shipment shows a cash outflow that the profit calculation should not recognise, and a business reading its bank balance as its profit will conclude it lost money in a month it did well.

It also flatters businesses that are not paying their owners. A profit figure that exists because nobody drew a salary is a wage in disguise, and it disappears the moment the owner needs replacing.

Turning it into a decision

Separate the profit calculation from the cash calculation and run both. Profit tells you whether the trading works; cash tells you whether you survive the next stock order. A business can be right on one and fatally wrong on the other, and each month should produce both numbers.

Then attack the cost lines in order of size. On the example above that is cost of goods, then advertising, then fulfilment, and the returns rate, which does not appear as a cost line at all but changes three of them at once.

Why returns move profit more than anything else

A refund reverses the revenue and leaves most of the cost behind. The outbound shipping is spent. The picking and packing is spent. The payment processing fee is generally not returned in full. The advertising that acquired the order is entirely gone. And the returned item may come back unsellable or need discounting.

That is why a five-point improvement in the refund rate outperformed everything else in the worked example. The five points did not simply add revenue; they removed the full cost stack on those orders while adding back the margin.

The practical consequence is that returns work deserves more attention than it usually gets, and specifically the information kind: accurate sizing, honest photography, clear material and dimension detail. Most excess returns in ecommerce are expectation mismatches, and expectation mismatches are cheap to fix relative to what they cost.