E-commerce profit and loss calculator
Enter your orders, ad spend and costs for a day, a week or a month. See your real profit after returns, courier charges and confirmation calls, and download the full Excel sheet.
Free to use, no account needed. What you type stays in your browser.
Net profit or loss
—
Enter the orders received and the selling price to see the result.
Net margin
—
Profit per delivered order
—
ROAS
—
Break-even ROAS
—
Your ROAS must be above this to make a profit.
Ad cost per delivered order
—
Confirmation rate
—
Delivery rate
—
Return rate
—
Where the money goes
- Revenue (cash collected)
- —
- Product cost
- —
- Ad spend
- —
- Confirmation calls
- —
- Packaging
- —
- Courier charges
- —
- COD fee and tax
- —
- Other and fixed costs
- —
Track it every day in Excel
The free sheet has a daily log, a profit and loss statement for any dates, a monthly summary with a chart and a what-if page. All formulas are built in. It opens in Excel and Google Sheets.
Download the Excel sheetThis is an estimate for planning, based on the numbers you enter. It is not accounting or tax advice. Parcels still in transit have already cost you but have not paid yet, so the latest days can look worse than they will end up.
How this is calculated
Everything is worked out from the numbers you enter:
- Revenue (cash collected)
- Delivered × (price + shipping charged)
- Product cost
- (Delivered + returned × lost share) × product cost
- Packaging
- Dispatched × packaging per parcel
- Confirmation calls
- Orders received × call cost
- Courier charges
- Delivered × delivery charge + returned × return charge
- COD fee and tax
- Revenue × COD fee %, plus tax on the courier and COD fee
- Net profit or loss
- Revenue − product cost − ads − calls − packaging − courier − COD fee and tax − other − fixed
- Break-even ROAS
- Revenue ÷ (revenue − every cost except ads)
Only delivered parcels bring in cash. A returned parcel brings no revenue, but it still costs you packaging, a courier return charge and, if it is lost or damaged, the product.
Worked example
Out of 40 orders, 28 were confirmed, 19 were delivered and 6 came back. With a price of $2,500.00, a product cost of $1,000.00 and $8,000.00 of ads, revenue is $47,500.00 and net profit is $10,820.00.
E-commerce questions
What are ROAS and break-even ROAS?
ROAS is revenue divided by ad spend. Break-even ROAS is the lowest ROAS at which you still cover every cost. Below it, each extra unit of ads loses money. Here it is worked out from your own numbers, including returns and courier charges.
Why do confirmation calls and returns matter so much for COD?
With cash on delivery you pay for ads, calls and packaging on every order, but you are paid only for parcels that are delivered. A low confirmation or delivery rate raises the real cost of each delivered order.
What counts as lost or damaged returns?
Returned parcels you cannot sell again. They cost you the product. Parcels that go back on the shelf cost only the packaging and the courier return charge.
Which period should I enter?
Use one period at a time, such as a week or a month, and enter the fixed costs for the same days. Parcels still in transit have not paid you yet, so give recent days about two weeks to settle.
Is my information stored, and what is in the Excel sheet?
No. The calculator runs in your browser and what you type is not sent to us. The Excel sheet is a template you download and fill in on your own computer. Its example costs are only examples, so replace them with your own.
Related calculators
- Profit margin calculatorEnter your revenue and costs to see gross profit, gross margin, markup and net margin.
- Break-even calculatorFind how many units you must sell to cover your costs. Add a target profit to see how many you need to earn it.
- Pricing calculatorWork out the selling price that covers your costs and fees and gives the profit margin or markup you want.
Results are estimates for planning. They are not financial, tax or religious advice.