Product Profit Calculator - Product Pricing Worksheet in Sheets and Excel

Want confident pricing before busy season? This Product Profit Spreadsheet (Google Sheets and Excel) shows your true product profit and profit margin -- so you can price smarter, set discounts safely, and stop guessing.

Perfect for handmade products and small e-commerce shops, it includes two tabs:

• Etsy Tab: builds in the $0.20 listing fee + 6.5% transaction fee and payment processing. Handles shipping charged vs. free shipping, and shows net shipping contribution.

• Shopify/Other Tab: without Etsy’s per-item fees—perfect for Shopify and other platforms.

What it calculates (automatically):

• Profit per item (with or without charged shipping)

• Margin %

• Impact of ads % and admin % on pricing
  

What’s included:

• Google Sheets file (share/copy link)

• Excel workbook (.xlsx)

• Step-by-step example showing exactly which numbers to gather and where to put them

Perfect for:

• Etsy sellers and Shopify store owners

• Handmade product businesses, makers, crafters, POD/light assembly

• Anyone who wants clear product pricing and profit visibility 

How it works (simple):

1. Start with your regular price and direct materials.

2. Automatically adds Etsy platform selling fees 

3. Automatically calculates payment processing %

4. Helps you calculate your ads %, and admin % costs

5. Shipping (tracks shipping revenue, label cost, and fees) 

6. Review Profit and Profit Margin per product—then tweak price, materials, or ads.

Why it works:

• Built for real-world e-commerce math (fees on shipping, per-order listing fees, etc.).

• Gives you instant clarity on what you can discount without killing profit.
  

FAQ

Q: Does this work if I offer free shipping?
A: Yes

Q: Can I use this for Amazon ?
A: No—this  spreadsheet is not designed to calculate Amazon selling fees

Q: Can I edit and reuse it for multiple products?
A: Absolutely—comes ready with room for 20 products, but simply drag the last column further to create additional columns with the same formula

Q: Beginner friendly?
A: Very. The example tab walks you through each step.

As this is a digital product there are no refunds or returns.