Pricing Calculator for Sellers

Description

Pricing Calculator Spreadsheet for Etsy & Online Sellers — Materials, Labor, Platform Fees, Shipping & Profit Margin Calculator with Printable Pricing Worksheet | Google Sheets & Excel

What’s Included (your download)

• Pricing-Calculator.xlsx — the blank calculator (3 sheets: START HERE · Calculator · Scenarios)
• Pricing-Calculator-SAMPLE.xlsx — the same workbook filled in for a fictional candle seller, every formula live
• Pricing-Calculator-Guide.pdf — 2-page quick-start guide with the worked example, margin vs markup, and troubleshooting
• Pricing-Worksheet-US-Letter.pdf + Pricing-Worksheet-UK-A4.pdf — the printable one-page pricing worksheet, both paper sizes

Product Details

Overview

Underpricing is the quiet killer of small shops. This is the full pricing calculator sellers keep asking for: one sheet that takes a product’s real costs — materials, packaging, your time priced at an hourly rate, postage you pay vs shipping you charge — then layers in your platform fee %, payment fee % plus its fixed per-order fee, and the average discount you give, and hands you back the only two prices that matter: your break-even floor and the price that delivers the profit margin you chose. A check-any-price section dissects any price you already have in mind, and a Scenarios sheet compares break-even, target-margin and a premium test price side by side, per item and per month.

What’s Included

• Calculator sheet: true cost per item (materials + packaging + other costs + labour from minutes × hourly rate + net shipping cost)
• Fee layer: platform % + payment % + fixed payment fee + average discount %, all applied the way platforms actually charge them — on the amount the customer pays after discount
• Break-even price, target-margin price, and the target price rounded UP to the nearest 50¢
• Check-a-price section: fees, what you receive, profit per item, margin % and markup % for any price you type
• Scenarios sheet: 3 price points with fees, profit per item, margin, and monthly profit at your sales volume
• Filled SAMPLE copy (fictional candle seller “Harbor & Pine”) + 2-page PDF guide + printable pricing worksheet in US Letter AND UK A4

Key Benefits

• Never list below break-even again — the floor is a number, not a feeling
• Your time is priced as a cost, not taken from whatever is left over
• The fixed per-order payment fee (the silent margin-eater on small orders) is inside every price
• Discounts stop being accidental losses: your average discount is built into the price from the start
• The premium-test row shows exactly what a +20% price rise would do to monthly profit

Who Is This For?

• Etsy, eBay, Shopify, Amazon Handmade and market-stall sellers who make or stock physical products
• Makers and crafters who suspect their prices are too low but can’t prove it
• Sellers whose current “method” is copying a competitor’s price and hoping
• Anyone repricing after a platform fee rise

How It Works

1. Download the files as soon as your payment is confirmed — they also wait in your account’s Downloads library.
2. Open the SAMPLE first and click through the candle example: $9.05 true cost → $10.82 break-even → $16.61 at a 30% margin.
3. Open the blank copy, fill the gold cells (about five minutes per product), and read your prices in the pale plum cells.
4. Print the worksheet for products you price at the bench or the market stall.

Why It’s Different

Most pricing spreadsheets are a thin cost-plus-fee box — the popular rival file is three tabs and stops there. This calculator adds the layers sellers actually lose money on: the fixed payment fee, shipping charged vs shipping cost, and a discount allowance — then goes further with a margin-vs-markup breakdown, a three-price scenario table with monthly profit, and a printable worksheet (in both US Letter and UK A4) that no rival in this niche includes. It is also deliberately light: standard formulas only, tested in older Excel and Google Sheets, and honest about its maths — the guide shows every step.

Delivery & Compatibility

Instant download after payment confirmation. Works in Microsoft Excel (2007 and newer, Windows & Mac), Google Sheets (free) and Apple Numbers (import). No macros, no add-ins, nothing to install — every formula is a standard one, tested for older-Excel + Google Sheets parity. The SAMPLE is included beside the blank file so what you see in the gallery is exactly what arrives.

Disclaimer

This calculator is an educational pricing tool for your own products. It is not financial, accounting or tax advice. Platform and payment fees change and differ by country — always set the percentages to your platform’s current rates.

Pairs well with

Small-Business & Seller Bookkeeping Bundle ($39) — price it right here, then track what it actually earned there. (Cross-sell both ways.)