Product profit calculator spreadsheet for Etsy, Shopify, TikTok Shop & Amazon sellers

Sales tell you what sold. Your numbers tell you what's working.

See the real profit on every product and every channel, after fees, shipping and landed cost. Then price, choose channels and restock with confidence, instead of guessing from revenue.

One-time purchaseInstant downloadAmazon, Etsy, Shopify, TikTok Shop, wholesale, Faire
Product profit calculator spreadsheet showing net profit per unit, profit margin, ROI and break-even price for example products
Etsy candle keeps $14.62 of $30.50
Multi-channel profit comparison: one $29.99 product on Amazon, Etsy, Shopify, TikTok Shop, wholesale and Faire
Same product, 8 channels
Small business owner reviewing her shop numbers on a laptop

Know your numbers

Healthy shops are run on profit, not revenue

A busy month can still lose money once every fee, label and unit cost is counted. Knowing what each sale actually leaves you is what turns a busy shop into a healthy one.

Pricing

Set prices that protect your margin

See your break-even price and the price that hits your target margin, for every product on every channel.

Channels

Sell where each product earns most

Compare one product across six built-in channels and two of your own, side by side.

Inventory

Restock what makes money

Rank products by monthly profit, so reorders go to the items that pay, not only the ones that sell.

Etsy profit calculator example

Where a $30.50 Etsy order actually goes

This is the first example row in the calculator. Change any yellow number to see how the profit moves.

Etsy sale, one unit

Example data from the file
Customer paysitem + shipping charged
Etsy feeslisting, transaction, processing
Landed costproduct, freight, packaging
Postage label
Returns allowanceshare of the item price
Net profit per unit
Etsy US fees as set in the file (checked November 2026): 6.5% transaction fee on item + shipping, $0.20 listing, 3% + $0.25 processing.
profit margin on what the customer paid
break-even list price
list price for a 30% margin

The full workbook does this for up to 300 product and channel rows at once.

Multi-channel profit calculator

One product. Same $29.99 price. Four different profits.

The Channel Compare tab runs one product through every channel at once, so you can see where each sale earns the most.

TikTok Shop
$13.8446.2% margin
Etsy
$12.6442.2% margin
Shopify
$11.7739.2% margin
Amazon
$8.0426.8% margin
$5.80

difference in profit per unit between the best and worst channel, for the same product at the same price.

Example data from the file: silicone kitchen set, $6.65 landed cost, 4% returns allowance. Amazon includes a $6.10 FBA fee and $3.50 ads per unit; Shopify includes $3.00 ads per unit. Your results depend on your own costs.

Amazon

referral + FBA fee

Etsy

listing, transaction, processing

Shopify

card processing by plan

TikTok Shop

referral fee

Wholesale

direct to retailers

Faire

marketplace commission

Custom 1

eBay, Walmart, markets

Custom 2

any channel you add

Pricing & profit margin calculator

A working business tool, not a printable template

Type in the yellow cells. Everything in grey calculates. Nothing is locked.

Price every product for every channel

One row per product and channel. Enter list price, shipping, fulfillment, ad spend and your target margin.

  • Net profit, margin and ROI on landed cost
  • Break-even price and the price for your target margin
  • Status flag: loss, below target or on target
  • Monthly profit per product, for restocking decisions
Profit Calculator
Profit calculator template inputs in Excel and Google Sheets: list price, discount, shipping, fulfillment, ad spend, returns and target margin
Start Here

Set up in three steps

A short guide with a worked example, so you can start without a tutorial.

Fee Settings

Editable marketplace fees

Pre-filled US fees for each channel, checked November 2026, with sources. Change a rate once and every row updates.

Products

Landed cost calculator

Product cost, freight, duties, packaging, labor and other costs, for up to 200 products.

Profit Calculator

Profit margin calculator

Up to 300 product and channel combinations, with clear status colors.

Channel Compare

Channel comparison

One product on all eight channels, with the price each one needs to hit your margin.

Monthly Summary

Monthly profit summary

Profit by channel after platform plans and subscription costs.

Excel and Google Sheets templateExcel 2010 or newer, Excel for Mac, Microsoft 365, or Google Sheets with a free Google account. No macros or add-ins.

Who it's for

For owners who want to see the whole picture

Handmade seller packing orders at her desk

Makers and handmade sellers

Know whether each product covers your materials, labels and time, and price new items with a margin you chose on purpose.

Online seller checking product margins on his laptop

Sellers on more than one platform

See Amazon, Etsy, Shopify, TikTok Shop and wholesale in one file, and put your effort where each product earns most.

Comparison

Built for sellers on more than one platform

Most calculators we reviewed in November 2026 cover one marketplace. If you sell in more than one place, that means one tool per channel.

SKU & SenseSingle-platform calculator
Channels in one file✓6 built in + 2 customOne marketplace
Compare one product across channels✓Channel Compare tabRe-enter it in each tool
Landed cost (freight, duties, packaging, labor)✓Itemized per productOften a single cost field
Break-even and target-margin price✓Every rowVaries by template
Monthly platform and subscription costs✓Monthly Summary tabUsually not included
Fee rates you can edit✓One settings tabSometimes locked

Pricing

One file, one payment

Product Profit Calculator

Excel + Google Sheets · version 1.0

Introductory price
$19USD, one-time.
No subscription.
  • The calculator workbook (.xlsx, 6 tabs)
  • Fee settings for Amazon, Etsy, Shopify, TikTok Shop, wholesale and Faire + 2 custom channels
  • Room for 200 products and 300 product + channel rows
  • Worked examples and a Start Here guide
  • A fresh copy of the original file whenever you need one
Get the calculator $19
Secure checkout by PayhipDownload link right after paymentSales tax or VAT added at checkout where required

10-day support and refund window

If the file won't download or open in a supported app, doesn't do what this page describes, or you were charged twice, tell us within 10 days and we'll fix it or refund you.

Product defects are always handled

If a formula in our original file is wrong, we fix it or refund you as your consumer rights require, even after 10 days.

Changed a formula by accident?

Edits you make aren't a product defect, but they're easy to undo. Ask and we'll send a fresh copy of the original file, free.

Your numbers stay with you

The file lives on your computer or in your own Google Drive. There's no account to create.

FAQ

Before you buy

Questions? Email us. We reply within 2 business days. support@skuandsense.com

Does it work in Excel and Google Sheets?

Yes. It works in Excel 2010 or newer, Excel for Mac and Microsoft 365, and in Google Sheets (upload the file to Google Drive and open it). We tested it in both Google Sheets and Excel before release. There are no macros or add-ins.

What exactly do I receive?

One .xlsx workbook with six tabs: Start Here, Fee Settings, Products, Profit Calculator, Channel Compare and Monthly Summary. The download link appears right after checkout and is also emailed to you.

Does it track inventory?

It doesn't count stock. It shows profit per unit and per month for each product and channel, which tells you which items are worth reordering and at what price.

What happens when a platform changes its fees?

Update the rate once on the Fee Settings tab. Every product row and the channel comparison recalculate automatically.

Does it handle Amazon FBA?

Yes. Set the referral rate for your category and enter your FBA fee per unit in the fulfillment column.

I sell on eBay or Walmart. Can I add them?

Yes. Rename one of the two custom channels and enter its fees. It then works everywhere in the file, including Channel Compare.

What is your refund policy?

  • Within 10 days: if the file won't download or open in a supported app, doesn't work as described, or you were charged twice, we fix it or refund you.
  • Defects in our file: handled as your consumer rights require, with no 10-day limit.
  • Changes you make: not a defect. We'll send a fresh original copy free.
  • Change of mind: digital files can't be returned, so no refunds after download, except where the law gives you that right.

EU and UK buyers: before payment you tick a box giving consent to immediate download and acknowledging that the 14-day withdrawal right ends once the download starts. Your answer is recorded with your order and listed in your receipt. If you didn't give that consent, use our EU/UK withdrawal form within 14 days. Etsy orders are also covered by Etsy's own purchase protection. Nothing in this policy limits your rights under the consumer law that applies to you.

Is this tax or accounting advice?

No. It's a planning tool. Amounts work in any currency, and fees are set for US sellers and easy to change for other countries.

Make your next pricing decision with real numbers.

$19 one-time · Excel + Google Sheets · Instant download

Get the calculator $19