Handmade Pricing Bundle for Etsy Sellers

Materials Cost and Fee Calculator

Excel + Google Sheets
Instant download

Two spreadsheets that work together: first find what each handmade item costs you in materials and packaging, then the price to charge after every selling fee, your shipping and your time.

You get both calculators in full – the Materials Cost Calculator and the Handmade Pricing & Fee Calculator – for less than buying them separately in our shop.

WHAT IT ANSWERS

What do the materials and packaging in one candle, bar of soap or pair of earrings really cost, when I buy supplies by the pound and use them by the ounce?
How much do failed items add to the cost of the ones I sell?
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?
How much is left when an Offsite Ads order comes in, and how big a sale can I run?

HOW THEY WORK TOGETHER

Materials Cost Calculator: type what you paid for each supply and what each product uses. The Costs tab shows the materials per item and the packaging per item, counting the items that fail.
Handmade Pricing & Fee Calculator: type those two numbers into its Products tab, with your minutes of work and your shipping. The Prices tab shows the price that keeps your profit after the listing, transaction, payment processing and Offsite Ads fees.
The examples (a soy candle, beaded earrings and a crochet baby hat) use the same numbers in both files, so you can follow one product from its supplies to its price (see photo 2).

WHAT YOU GET

2 Excel files (.xlsx), tested in Microsoft Excel for Windows – on a Mac, use the Google Sheets versions
2 Google Sheets versions: PDFs with a link to make your own copy (use these on a Mac or Chromebook if you do not have Excel)
A Start Here tab in each file: step-by-step instructions and the plain-English meaning of every number
Example products in each file – replace them with your own

GOOD TO KNOW

The fee calculator is made for sellers in the US. The fees were checked against the seller fee policies on October 18, 2026; if they change, update the yellow cells in its Settings tab. Sellers in other countries pay different fees (for example, VAT on fees in the UK and EU), so it is not set up for them.
The materials calculator has 32 units built in (oz, lb, troy oz, pennyweight, fl oz, yard, square foot, board foot, dozen and more) plus rows for units of your own. Weight and volume do not mix: its Start Here tab shows how to measure once.
Room for 80 supplies and 30 products in the materials calculator, and 30 products in the fee calculator. Adding more rows is not supported; if you need more, use a second copy of the file (for example, one per product line).
Amounts are in US dollars.
Only the yellow cells can be changed, so the formulas are hard to break by accident.
Made for a computer screen: the tabs are wide, and the files have not been tested on a tablet or phone.
Already have one of the two? Each is also sold on its own in our shop.
This is a digital download. Nothing will be shipped.
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 files.

ABOUT THIS BUNDLE

Designed by SlateTally with the help of AI tools. Every result in both spreadsheets was checked in Microsoft Excel against an independent calculation, including unusual inputs, and the Google Sheets versions were checked cell by cell against the Excel files.

Etsy is a trademark of Etsy, Inc. These templates are not created or endorsed by Etsy, Inc.

Questions? Send a message – happy to help.