# Ecommerce Profit Margin Calculator Excel (Free)

> Free ecommerce profit calculator for Excel and Google Sheets: profit per product after shipping, fees, returns and ads, break-even ROAS, target price.

Source: https://softwiro.com/templates/ecommerce-profit-calculator
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Ecommerce Profit Margin Calculator for Excel

A free ecommerce profit margin calculator that shows what you really keep from each product. You list your products with the channel they sell on, orders, price, product cost, shipping, packaging, ad spend and return rate. The sheet takes off the marketplace and payment fees of that channel, the cost of returns and the ads, then returns profit, margin, profit per order, ROAS and break-even ROAS for every product, and net profit for the whole store after your monthly fixed costs. A separate Price Check sheet works backwards from the margin you want to a price. It opens in Excel, LibreOffice and Google Sheets and works in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-ecommerce-profit-calculator.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-ecommerce-profit-calculator-blank.xlsx)

Excel file (.xlsx) · 76 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| Sales period | October 2026 | Change the period, fixed costs, fees and target margin on the Settings and Channels sheets. |  |
| --- | --- | --- | --- |
|  |  |  |  |
| Net revenue | 37,534.25 | Orders | 1,038 |
| Cost of goods | 14,071.10 | Units sold | 1,476 |
| Fulfilment and returns | 6,703.20 | Average order value | 36.16 |
| Channel and payment fees | 3,157.80 | Net profit per order | 9.27 |
| Ad spend | 3,640.00 | ROAS (net revenue / ads) | 10.31 |
| Profit before fixed costs | 9,962.14 | Break-even ROAS | 2.76 |
| Fixed costs for the period | 343.00 | Products below target margin | 2 |
| Net profit | 9,619.14 | Products losing money | 1 |
| Net margin | 25.6% | Most profitable product | Canvas backpack |
|  |  |  |  |
| Product | Profit | Channel | Profit |
| Canvas backpack | 2,111.19 | Own website | 5,918.40 |
| Insulated bottle | 2,078.80 | Marketplace A | 894.60 |
| Wool socks 3-pack | 1,872.48 | Marketplace B | 1,367.14 |
| Hiking poles (pair) | 1,782.00 | Wholesale | 1,782.00 |
| Wool beanie | 1,001.68 |  |  |
| Camp mug set | 886.40 |  |  |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Net revenue, each cost, profit before fixed costs, fixed costs for the period, net profit and net margin, plus orders, average order value, ROAS, break-even ROAS and the number of products below your target margin or losing money. Charts show the most profitable products, profit by channel and where the revenue goes.
- Products: One row per product and channel, up to 200. You type the inputs; the grey columns return net revenue, cost of goods, fulfilment and returns, fees, profit, margin, profit per order, ROAS, break-even ROAS, a Status (OK, Below target, Loss) and a Check message.
- Channels: The fee profile of each place you sell: marketplace or referral fee %, payment processing % and fixed fee per order. Up to 10 channels.
- Price Check: Enter one product's cost, shipping, packaging, ad cost per order, return rate and target margin. It returns the break-even price and the price that gives your target margin, with a per-order profit and loss at your current price and at the new one.
- Settings: Currency symbol, the sales period and how many months it covers, the cost of handling a return, your target net margin and up to 10 monthly fixed costs.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Many profit calculators stop at price minus cost. This one counts the things that quietly eat margin online: shipping you pay, packaging, a different fee on each channel, returns and the money spent on ads. It also shows break-even ROAS per product, so you know how much you can pay for a sale before it loses money. The sample is a small outdoor shop selling on its own website, two marketplaces and wholesale in October 2026, with one product losing money so you can see the warnings.

## How do I calculate ecommerce profit margin in Excel?

Start with net revenue: price times units sold, less refunds on returns, plus any shipping the customer pays. Subtract the cost of the goods you sold, the shipping and packaging you pay per order, the cost of handling returns, the channel and payment fees and the ad spend. What is left is profit. Divide it by net revenue for the margin.

In the sample, the Canvas backpack sells 120 orders at 48.00 on the store's own website. After product cost, shipping, packaging, card fees, returns and 900.00 of ads, it makes 2,111.19 profit on 6,128.40 of net revenue, a margin of 34.4%. The LED lantern on Marketplace A makes 8.20 on 3,408.60: the sheet marks it Below target.

## What is break-even ROAS and how do I find it?

ROAS is revenue divided by ad spend. Break-even ROAS is the ROAS at which a product earns exactly nothing after its other costs: net revenue divided by profit before ads. If your ads return less than that figure, each sale loses money. For the Canvas backpack in the sample it is 2.04, and its actual ROAS is 6.81, so there is room.

Use the figure to set a minimum ROAS in your ad platform. It depends on the price, fees and return rate you typed, so recheck it when any of them change.

## How do I price a product for a target margin?

Use the Price Check sheet. It solves for the price at which profit divided by net revenue equals your target, counting returns, the channel's fees and your ad cost per order. With the sample values the break-even price is 29.10 and the price for a 20% margin is 38.01, against the 48.00 currently charged.

Treat the result as a floor and round it to a price your customers will accept. For the break-even volume of a business, see the [break-even calculator](https://softwiro.com/tools/break-even) and the [break-even and unit economics sheet](https://softwiro.com/templates/ad-breakeven-roas-calculator).

## How to use it

1. On the Settings sheet type your currency symbol, the period your sales cover (for example October 2026) and how many months that is, the cost of handling one return, your target net margin, and your monthly fixed costs.
2. On the Channels sheet list each place you sell (your own site, marketplaces, wholesale) with its referral fee %, payment processing % and fixed fee per order.
3. On the Products sheet add one row per product and channel: orders, units per order, price, unit cost, shipping you charge and pay, packaging, ad spend and return rate.
4. Read the grey columns: net revenue, each cost, profit, margin, profit per order, ROAS and break-even ROAS. The Status column marks products below your target margin or losing money.
5. Use Price Check to find the break-even price and the price that gives your target margin for any product, before you change a listing.
6. Open Dashboard for net profit after fixed costs, the most profitable products, profit by channel and where each dollar of revenue goes.

**Before you start:**

- Capacity: 200 product rows (a product sold on two channels takes two rows), 10 channels, 10 fixed costs.
- Revenue is the price times units, less refunds on returned units, plus the shipping customers pay. Returned units are assumed to go back into stock, so their product cost is not lost.
- Each return costs the handling amount on Settings (return postage, inspection). Channel and payment fees are charged on the full sale and are not refunded.
- Shipping, packaging and fixed fees are counted per order, not per unit. Ad spend is the total spent on that row for the period.
- Fixed costs on Settings are monthly; the Dashboard multiplies them by the months your sales cover.
- Break-even ROAS is net revenue divided by profit before ads: the return on ad spend at which a product earns nothing. Below it, the ads lose money.
- The channel rates in the sample are made-up examples. Use the real rates from your own plans and statements, and use one currency throughout.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-ecommerce-profit-calculator.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-ecommerce-profit-calculator-blank.xlsx)

Excel file (.xlsx) · 76 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet needs someone to transfer every order into it. In a Softwiro E-Commerce store, the order is recorded the moment of purchase and followed through to delivery, with shipping costs you set for each governorate.

| In this sheet | In Integrated E-Commerce Platform |
| --- | --- |
| You move orders from messages and comments into the sheet. | A store of your own that follows every order from creation to delivery, with a shipping cost you set separately for each governorate. |
| You find out a product is out of stock after you've sold it. | It tracks the available quantity in each warehouse and alerts you when any product runs low. |
| Payment only on delivery. | It accepts Visa cards and other payment methods, and you manage the available payment methods from the dashboard. |
| Every offer or coupon needs manual follow-up. | You manage products, categories, offers, discount coupons and site content from the dashboard, without a developer. |

[See Integrated E-Commerce Platform](https://softwiro.com/product/kidswear) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You type orders and costs for each product | Orders and costs are read from your store and suppliers |
| Fee percentages typed by hand | Real fees taken from each channel's statements |
| Return rate is an estimate | Returns recorded per order with the reason and the cost |
| Profit worked out per period | Profit visible per order, per customer and per day |
| Charts in a workbook | A live dashboard for owners and partners |

### Extra features in the app

- Orders flow in from your store and marketplaces automatically, so nobody types sales
- Product costs and fees kept up to date and applied to every order as it happens
- Profit per order shown the moment the order arrives
- Stock quantities that fall with each sale and alert you before a product runs out
- Returns recorded against the original order with their real cost
- Daily and monthly profit on your phone, per channel and per product

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this ecommerce profit calculator free?

Yes. Download it, use it for your own store and change anything you like. There is nothing to sign up for to open the file.

### Does it work for Shopify, Amazon, Etsy and other channels?

It is not tied to any platform. On the Channels sheet you type each channel's own fee percentages and fixed fee per order, taken from your plan or statement. The rates in the sample are made-up examples.

### How are returns treated?

The refunded share of product revenue is removed, returned units are assumed to go back into stock so their product cost is not lost, and each return costs the handling amount you set on Settings. Fees are not refunded.

### How many products can it hold?

200 product rows, 10 channels and 10 fixed costs. A product sold on two channels uses two rows.

### Can I use my own currency?

Yes. Nothing is fixed to a currency; type your symbol on Settings if you like. Use one currency in the workbook.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Online selling

## More free templates

- Installment Payment Tracker for Excel
- Social Media Content Calendar Template for Excel
- Class Schedule Maker for Excel
- GPA Calculator for Excel (Weighted and Unweighted, by Term)
- Lesson Plan Template for Excel with Curriculum Tracker
- Donation Tracker Spreadsheet for Nonprofits (Excel)
- Expiry Date Tracker for Excel (Inventory)
- HOA Dues Tracking Spreadsheet for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
