Product Pricing Calculator Spreadsheet, Profit Margin Excel Template for Etsy Sellers, Handmade Business

Stop guessing your prices. This Excel workbook helps handmade, Etsy and small business sellers work out what a product really costs and what to charge, using live formulas.

WHAT YOU GET: five tabs - Start Here, Single Product Pricing, Bulk Price List (20 products), Wholesale vs Retail, and Discount Impact. Sample data is pre-filled so you can see how everything works, then replace it with your own.

SINGLE PRODUCT PRICING: enter materials, labor hours and rate, packaging, shipping, platform fee %, payment fee %, ad cost %, and overhead. See total cost, minimum price, recommended price, profit per unit, margin %, markup %, and break-even units for your monthly fixed costs. A flag warns you when a price is below your target margin.

BULK PRICE LIST: compare up to 20 products side by side with live totals, status flags, and a ranking by monthly profit.

WHOLESALE VS RETAIL: set wholesale at a share of retail (50% by default), see the resulting margin, get a suggested minimum order quantity, and test other percentages.

DISCOUNT IMPACT: see profit, margin and the extra units you would need to sell after a 10%, 20% or 30% sale.

DETAILS: yellow input cells, dropdown and number validation, color-coded conditional formatting, no macros. Works in Excel, Google Sheets and LibreOffice. Includes a README and license.

PLEASE NOTE: this is a digital download (.xlsx). Nothing is shipped. Fee rates and sample numbers are examples only; results are estimates based on the numbers you enter and are not financial, tax or legal advice, or a guarantee of any outcome.