Pricing Calculator for Handmade Sellers, Profit and Fees
$7.99
Product pricing and profit calculator spreadsheet for handmade sellers and small shops. It works with Excel and Google Sheets. Enter what a product costs you to make, pack and ship, pick where you sell it, and it shows what you really keep from each sale, your profit margin, your break-even price and the price that hits your target margin.
Share
What's inside
- Product_Profit_Calculator.xlsx: the blank workbook you work in
- Product_Profit_Calculator_EXAMPLE.xlsx: a filled sample candle shop with 8 products sold in different places, so you can see how it works before you start
- START_HERE.txt: what to open first and how to open it in Google Sheets
- Start Here: the steps in order and a few tips
- Dashboard: sales, net profit and margin per month, items sold, average profit per item, how many sales cover your fixed costs, and counts of products losing money, below target and on target. Three charts: monthly profit by product, margin by product vs. your target, and where each sales dollar goes
- Settings: your target profit margin, hourly labor rate, whether labor counts as a cost, fee presets for common places to sell (all editable, plus 2 custom rows), and your monthly fixed costs
- Profit Calculator: price one product in detail. List each material by pack cost and it works out the cost per item. Add packaging, labor time, the shipping label you pay, discounts, shipping you charge and ad spend. See profit per sale, margin, what you earn per hour, break-even price, the price for your target margin and a what-if table from 30% lower to 30% higher
- Product Catalog: up to 100 rows. List a product once for each place you sell it and see fees, total cost, profit, margin, break-even price, target price and a status for each one
- Monthly Profit Plan: enter how many of each product you expect to sell per month and see sales, fees, costs, fixed costs, net profit per month and per year, your top 5 products and a watch list
Who it's for
- Makers, crafters and small shops selling online, at markets or both, who want to set prices with real numbers instead of guesses. Good for candles, soap, jewelry, prints, stickers, baked goods, wholesale orders and anything else you make and sell
Before you buy
Planning tool only. Not tax, legal, or accounting advice. It does not connect to any shop or bank; it only shows what you enter. Check fees and costs against your own statements. Built by ReconciledBooksCo, a small shop run by an experienced accountant.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one organization per purchase.
