Etsy & Shopify Margin Calculator

See what you keep from every Etsy or Shopify order after listing, transaction and payment fees, shipping and packaging, and the lowest price that keeps your target margin.

Platform fees are small percentages that add up: on Etsy they apply to the shipping you charge too. This file shows the profit per order and per month for each product, side by side for Etsy and your own Shopify store.

What's in the file

  • Start here — step-by-step guide and colour legend
  • Guide — How to read the numbers. Plain explanations of every number, how to read the result and the mistakes to avoid.
  • Setup — Fee rates and target. You fill in: Currency, Target margin, Etsy listing fee per sale, Etsy transaction fee %, Etsy payment processing %, Etsy payment processing, fixed, Etsy offsite ads, average % of sales, Shopify Payments %, Shopify Payments, fixed, Shopify extra fee (other payment provider) %.
  • Products — One line per product and platform. You fill in: Product, Platform, Price, Shipping charged, Product cost, Shipping cost, Packaging, Orders / month. Worked out for you: Platform fees, Profit / order, Margin, Lowest price for target, Sales / month, Profit / month, Status.
  • Dashboard — What you keep. Shows: Orders / month, Sales / month, Profit / month, Margin, Below target, a chart.
  • Summary — What the numbers say. Shows: Profit / month, Margin, Products to reprice.
  • Action plan — What you will change next. Write what you will change, why, who owns it and by when; status shows in colour.
  • Checklist — Monthly pricing check. 2 steps to tick off, with a progress bar.

How to use it

  1. Open Setup and check the fee rates against your Etsy and Shopify plan; set your target margin.
  2. Add one line per product and platform: price, shipping you charge, product cost, real shipping cost, packaging and orders per month.
  3. Compare each price with the lowest price column and fix products below target.

What it does

  • Etsy and Shopify fees worked out per order
  • Profit per order and per month for each product
  • Lowest price for your target margin
  • Fee rates in one place, easy to update
  • Status: OK, below target or losing money
  • Two files in each language: a blank Template to fill in, and an Example filled with sample data
  • Available in several languages; Arabic files are laid out right-to-left
  • Formulas only, no macros or add-ins
  • Instant download after purchase

Included Files

  • A file in the language you choose
  • Arabic files laid out right-to-left
  • Step-by-step guide
  • Free updates for this version

Works With

  • Microsoft Excel
  • Excel for Mac

Support

Questions about setup? Send us a message from your account page and we reply by email.

Etsy & Shopify Margin Calculator

The video tutorial for this template is coming soon.

No reviews yet. Reviews appear here after customers rate the template.

Write a review
Your rating
FAQ
  • Which language is the file in?

    You get the file in the language you pick at the top of the site. If a template is not available in that language yet, you get the English file. Arabic files are laid out right-to-left.

  • Do I need macros or add-ins?

    No. The templates use formulas and built-in charts only.

  • Can I change the template?

    Yes. Rename columns, add rows, change colours and add your logo.

  • How do I get the files after paying?

    The download link appears on the order page and in your account right after payment.

Personal License

For you, on your own projects and your own company reports.

Team License

Share the files with up to 10 people in your company.

$25.00

Free

File language: English

Add To Cart
Mia Ready
39 templates in the shop
View All Templates
  • Last updateNov 18, 2026
  • PublishedNov 18, 2026
  • CategoryE-commerce
  • File format.xlsx
  • LanguagesEnglish
  • LayoutLeft-to-right; Arabic right-to-left
  • MacrosNone
  • Works WithMicrosoft Excel, Excel for Mac
  • Tags Excel, E-commerce
Like this template?

Found it useful? Recommend it to other marketers and earn 30% of every sale you bring in.

Become an affiliate