Handmade Pricing Calculator for Etsy Sellers

WHAT IT ANSWERS

• What should I charge to keep $8 (or any amount) on each sale, after all the fees?
• What is the lowest price before I start losing money – with and without paying myself?
• How much is left when an Offsite Ads order comes in?
• How big a sale or coupon can I run before it costs me money?
• What am I really earning per hour?

HOW IT WORKS

1. Settings: the US seller fees are filled in (listing $0.20, transaction 6.5%, payment processing 3% + $0.25, Offsite Ads 15% or 12% up to $100, Share & Save 4%). Add your pay per hour, your shop costs per item and the profit you want.
2. Products: one row per product – materials, packaging, minutes of work, the shipping you charge and the label you pay. Your current price is optional.
3. Prices: every product priced at once. Green means money kept, red means a loss.
4. What-If: pick a product to see where the money from one order goes, fee by fee, and what you keep at 0% to 50% off.

WHAT YOU GET

• Excel file (.xlsx), tested in Microsoft Excel for Windows
• Google Sheets version: a PDF with a link to make your own copy (use this one on a Mac or Chromebook if you do not have Excel)
• Start Here tab: step-by-step instructions, every fee explained, and the plain-English meaning of every number (see photo 3)
• 7 example products (a candle, earrings, a printable, a cutting board, stickers, a quilt and a baby hat) – replace them with your own

GOOD TO KNOW

• Sizes or colors that cost different amounts: give each one its own row.
• Free shipping: enter $0 as the shipping you charge and put the label cost in "Shipping label you pay" – the price then covers the label.
• Prices are worked out for an order of one item. On an order of several items you pay the $0.25 payment fee once, so you keep a little more than shown.
• Digital items work too: spread your design time over the copies you expect to sell (the guide shows how).
• Made for a computer screen: the sheets are wide, and it has not been tested on a tablet or phone.
• This is a digital download. Nothing will be shipped.
• Made for sellers in the US. Amounts are in US dollars. Sellers in other countries pay different fees (for example, VAT on fees in the UK and EU), so this file is not set up for them.
• The fees were checked against the seller fee policies on October 18, 2026. If they change, update the yellow cells in Settings and every price updates.
• Payment processing is charged on the whole order, including shipping and the sales tax the buyer pays. The calculator uses the US average sales tax (7.53%), which you can change.
• Not included: currency conversion, the one-time shop setup fee and subscriptions (you can spread a monthly cost over your shop costs per item). Results are before income tax.
• Only the yellow cells can be changed, so the formulas are hard to break by accident.
• For education and planning only. This is not financial, tax, legal or business advice.
• For personal use in your own shop. Please do not resell or share the file.
• Not sure what your materials cost per item? The Materials Cost Calculator in our shop works it out from your bulk supply prices. The Handmade Pricing Bundle has both spreadsheets for less.
• Selling at craft fairs and markets too? The Craft Fair Planner & Sales Tracker in our shop shows the sales you need to break even at each event, and what each one really made.

ABOUT THIS TEMPLATE

Designed by SlateTally with the help of AI tools. Every result was checked in Microsoft Excel against an independent calculation, including unusual inputs such as a $0 price, free shipping, a digital item, an order big enough to hit the $100 Offsite Ads cap and fees that add up to 100%. The Google Sheets version was checked cell by cell against the Excel file.

Etsy is a trademark of Etsy, Inc. This template is not created or endorsed by Etsy, Inc.

Questions? Send a message – happy to help.