Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceE-commerce OperationsE-commerce Profit Calculator

SpreadsheetE-commerce OperationsFree

E-commerce Profit Calculator

True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.

Shown with sample data

Colour

E-commerce Profit Calculator

True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.

Listings analysed
8
Average net margin
21%
Losing money
1
Best profit per order
$15.76
Entries by channel
  • Own store3
  • Amazon2
  • Etsy2
  • eBay1
Share of entries by channel
  • Own store338%
  • Amazon225%
  • Etsy225%
  • eBay113%

How to use it

  1. 1Add a row for each product on each channel.
  2. 2Enter the channel’s real fee rates from your seller dashboard.
  3. 3Use your average ad cost per order, not per click.
  4. 4Fix or drop anything flagged Losing money.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Revenue is not profit, and fees hide the difference. For each product and channel enter price, product cost, shipping, fee rates, ad cost per order and return rate; the sheet shows net profit and margin per order and the break-even return on ad spend, so you know which products can afford advertising.

Who it’s for

  • Pricing products for each marketplace
  • Deciding what you can pay for an order in ads
  • Finding products that sell but lose money

What’s included

  • Products sheet: One row per product per channel.
  • Summary by Channel sheet: The number of entries for each channel, calculated from the Products sheet.

How to use it

  1. 1Add a row for each product on each channel.
  2. 2Enter the channel’s real fee rates from your seller dashboard.
  3. 3Use your average ad cost per order, not per click.
  4. 4Fix or drop anything flagged Losing money.

Questions

What is break-even ROAS?

The return on ad spend at which an order makes exactly zero profit: selling price divided by profit before ads. Run ads only above it.

Related searchesecommerce profit calculatoramazon fee calculatoretsy profit calculatorproduct margin calculatorbreak even roas

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetE-commerce OperationsFree

E-commerce Profit Calculator

True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More e-commerce operations templates

View all

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

Full name *

Email *

Phone *

Place order
FormE-commerce Operations

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

10 min setupPreview
Product Catalogue with Margins2 sheets

Products

7

Average margin

64%

Low-margin products

1

ABCD
1ProductCategoryVariantSupplier
2Organic cotton teeApparelBlack / MGreenThread
3Heavyweight hoodieApparelGrey / LGreenThread
4Canvas tote bagAccessoriesNaturalBagCo
5Embroidered capAccessoriesNavyCapWorks
Products
SpreadsheetE-commerce Operations

Product Catalogue with Margins

SKUs with cost, price, margin, markup, stock and status for every product.

10 min setupPreview
Online Order Tracker2 sheets

Orders

6

Revenue

$282

To ship

2

ABCD
1Order #Order dateCustomerChannel
2#1042Nov 1Emma ClarkeWebsite
3#1043Nov 3Liam OrtizEtsy
4#1044Nov 4Sofia RossiWebsite
5#1045Nov 5Noah KimInstagram
Orders
SpreadsheetE-commerce Operations

Online Order Tracker

Track orders from payment to delivery with channel, fulfilment and shipping status.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ