AnalystBuilt home Etsy shop

Small Business Finance

Pricing Calculator

Material costs, your labor, overhead and fees turned into recommended prices, break-even and wholesale checks

Pricing Calculator: For makers · recommended price, break-even, wholesale & retail
For makers · recommended price, break-even, wholesale & retail
  • Pricing Calculator: For makers · recommended price, break-even, wholesale & retail
  • Your recommended price: Covers materials, your time, overhead, fees and shipping
  • Your shop at a glance: Where each sale goes, margins and what to fix first
  • On target or below cost? See which products lose money and which earn the most per hour
  • What if I charge more? Price scenarios, wholesale vs retail and every sales channel
  • Enter materials once: Pack price and size → cost per unit; gaps and old prices flagged
  • Your recipe, costed: Quantities per batch → cost per batch and cost per item
  • Every fee counted: Percent, per-order and per-item fees, ads and tax on fees

from $12 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

Know your real cost, then price on purpose. This pricing calculator turns your materials, your time, your monthly costs and your selling fees into a recommended price for every product — plus the break-even price, wholesale and retail prices, and how much you really earn per hour of making.

Made for makers who sell online, at craft fairs or wholesale: candles, soap, jewelry, sewing, baked goods, crafts, and services that use a few materials.

What's inside

  • Start Here

    Quick guide and settings: currency, your hourly rate, target margin, how to share overhead, wholesale/retail multipliers, price rounding

  • Dashboard

    Your top 12 products side by side: where each sale goes (materials, your labor, overhead, fees, profit) and the margin; plus profit a month, earnings per hour, break-even and "What needs attention"

  • Price Builder

    Pick one product: recommended, current, break-even and wholesale price, a cost breakdown, every fee, price scenarios and the same product on each sales channel

  • Products

    Up to 40 products: channel, batch size, making time, shipping, discount, your price and planned sales

  • Product Materials

    The recipe for each product, per batch (600 lines)

  • Materials

    What you buy: pack price, pack size and unit; cost per unit is calculated (200 materials)

  • Fees

    Up to 8 places you sell: percent and fixed fees, ads, tax on fees, fees on shipping

  • Overhead & Break-Even

    Monthly fixed costs, overhead per hour or per unit, break-even units and revenue, and a break-even chart

Why you'll like it

  • A recommended price for every product that already covers materials, your labor, overhead, fees, discounts and shipping — rounded up to .99, .95, .50 or whole numbers, never below your target
  • Materials entered once, used everywhere: recipes per batch, cost per unit from pack price and pack size
  • Pay yourself first: your hourly rate is built in, and you see your earnings per making hour for each product
  • Selling-fee calculator for any marketplace, your own website or a craft fair (percent + per-order + per-item fees, ads and tax on fees) — compare one product across channels
  • Break-even price, break-even units a month, a safety margin and a break-even chart
  • Wholesale vs retail (2× / 2× keystone, adjustable) with an honest check: see if wholesale works for you
  • What-if price scenarios (−10% / +10% / +20%, your own numbers) and a "What needs attention" list
  • Margin vs markup explained in plain words. Any currency; sample data included. Built by a data analyst — every number is a formula you can trace. No subscription, no app

How you get it

  1. Download on Etsy

    Buy the template on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download

  2. Make a copy

    Click MAKE A COPY in the PDF: your own Google Sheet is saved to your Google Drive. Prefer Excel? Open the .xlsx.

    How to make your copy

  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets link + quick guide
  • pricing-calculator-excel.zip — Excel version

Good to know

  • Also in the Small Business Finance Starter bundle with Cash Flow Forecast & P&L, Small Business Bookkeeping and Invoice & Receivables Tracker: all four for less than the price of three.
  • Need stock tracking too? The Small Business Finance Complete bundle adds the Inventory & COGS Tracker to all four.
  • You type your own fees: the sample fees are examples, not any platform's official rates.
  • Prices exclude sales tax / VAT you collect from buyers.
  • It prices recipes you already use; it doesn't calculate or check recipe safety (for example lye amounts for soap).
  • Best used on a computer; you can view it in the Google Sheets app on your phone.
  • For use in one business. Please do not resell or share the files.

Not financial or tax advice.

Designed by me with the help of AI tools.

View Pricing Calculator on Etsy

More in Small Business Finance