Skip Navigation

Spreadsheet

Handmade-Seller Pricing & Profit Workbook — Price Your Craft from True Cost, Markup vs Margin, Marketplace Fees & Wholesale (Excel + Google Sheets)

A handmade pricing workbook for Excel & Google Sheets — price every product from true cost (materials, labor, overhead, fees) and see the real profit on each.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • A Price a Product calculator — list materials, packaging, your labor at a wage you set, and overhead; it returns your true cost, a fee-aware retail price, a wholesale price, and the real profit on each
  • A Pricing Lab — set the gross margin you need and it hands you the markup and the cost multiplier to charge (a 50% margin needs a 100% markup, not 50%), with a keystone explainer and a margin → markup table
  • An Overhead Calculator — a year of booth fees, subscriptions, tools and your camera → the per-item overhead every product must carry
  • A Marketplace Fees profile — set your listing, transaction, payment and ads fees once; the pricing tabs read it, so the profit you see is after the cut, not the sticker price
  • A Materials Library — your own price book; enter a pack price and its units and the true cost per unit divides down for you (a $90 hide becomes the few dollars a product really uses)
  • A Product Catalog — every product side by side (cost, price, fees, profit & margin) so you can see which listings actually make money
  • A Start Here guide plus a Pricing & Profit guide, a Wholesale & Sales-Channels guide, a Cost Checklist & Materials reference, and printable worksheets
  • A 7-tab workbook (works in Excel, Google Sheets & LibreOffice) + 5 PDF guides · evergreen · instant download
  • For every craft — jewelry, leather, fiber, ceramics, candles, paper goods and more

Price your handmade work for real profit — not on gut feel

If you sell handmade, one question quietly decides whether your shop makes money: what does each thing you make really cost? It’s easy to stop at materials and multiply by some comfortable-sounding number — leaving out your labor, your overhead, and the cut the marketplace takes on every sale. A price that looks healthy can pay you almost nothing.

The Handmade-Seller Pricing & Profit Workbook counts all of it. List a product’s materials, the packaging it ships in, the minutes it takes and the wage you pay yourself, and the overhead it carries — that’s your true cost. The workbook then marks it up to a retail price and a wholesale price, nets out the marketplace’s cut, and shows the real profit on each listing — so you can see which products actually make money.

It’s one file you own — a 7-tab workbook that works in Excel, Google Sheets, and LibreOffice — not another monthly app to rent.

What’s inside the workbook

  • Price a Product — the flagship. Materials + packaging + labor + overhead → your true cost, then a fee-aware retail and wholesale price and the profit (and take-home per hour) on each. Pre-loaded with a worked example you overwrite with your own products.
  • Pricing Lab — markup is not margin, and the gap is your money. Set the margin you need and it hands you the markup and the cost multiplier to charge, with a keystone explainer and a full margin → markup table.
  • Overhead Calculator — add up a year of booth fees, subscriptions, tools, and your camera, and it works out the per-item overhead every product must carry.
  • Marketplace Fees — your listing, transaction, payment, and ads fees in one place. The pricing tabs read it, so the profit you see is what’s left after the cut — with a channel-by-channel reference.
  • Materials Library — your own price book. Enter what a pack, spool, or hide costs and how many units it holds, and the true cost per unit divides down for you.
  • Product Catalog — every product by cost, price, fees, profit, and margin, so you can finally see which listings carry the shop and which only look busy.

A Read Me tab ties the six working tabs together. And it’s not just a spreadsheet: four plain-language guides cover paying yourself a wage, marking cost up to a price, handling marketplace fees, setting wholesale, and raising prices without losing customers — plus a printable-worksheets PDF for costing by hand (five PDFs in all).

Pay yourself first — then add profit

The single line most makers leave out is their own time. This workbook puts your labor inside cost at an hourly wage you choose, so the markup on top is real profit — not your wage in disguise. In the workbook’s worked example, counting an hour of work at a fair wage turns a $6 pile of materials into a $32.50 true cost; priced right, the same piece earns $37.64 after fees instead of a few dollars.

Markup is not margin — and keystone has its limits

A “50% markup” is not a 50% margin. Add 50% to a $20 cost and you’ve kept only 33% of the price. The Pricing Lab converts the margin you need into the markup to charge for you, and explains where keystone (double the cost) fits — and where, for labor-heavy handmade, it doesn’t.

Retail and wholesale, in the right relationship

Sell to shops as well as to buyers? The workbook gives you a wholesale price alongside your retail, and the guides walk the wholesale-to-retail ladder so your own price never undercuts the stores that carry you.

Own it, don’t rent it

This sits exactly where you want a pricing tool: between a blank spreadsheet (free, but you build every formula) and a monthly SaaS app (powerful, but rented forever and overkill for a small shop). It’s a done-for-you pricing system you buy once and keep — your numbers stay in your file, yours forever.

When your shop outgrows a spreadsheet, it graduates cleanly to Ardent Seller — the living version, where your priced products become a real catalog with tracked costs and your materials become inventory that draws down as you buy and make.

Try the free calculator first

Want a taste before you buy? The free Handmade Pricing Calculator prices one product right in your browser — materials, packaging, labor, overhead, and a marketplace fee into a suggested retail price and your real profit. The full workbook prices your whole shop: every product, a markup-vs-margin Pricing Lab, per-channel fees, wholesale, a materials price book, and the catalog that shows which listings actually earn.

A pricing framework, not financial advice. Every figure in the examples is illustrative — material prices, wages, overhead, and marketplace fees vary by craft, region, supplier, and channel, so you enter your own. Sales tax, business registration, and your channel’s current fees are yours to verify.

Instant digital download. Nothing ships — you get the workbook and guides the moment you buy, yours to use forever.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 01 — The Pricing Workbook (.xlsx, 7 tabs): Read Me, Price a Product, Pricing Lab, Overhead Calculator, Marketplace Fees, Materials Library, Product Catalog — pre-loaded with a worked example; opens in Excel, Google Sheets, or LibreOffice
  • One-click Google Sheets copy — open the included 'Open in Google Sheets' PDF and click Make a copy for a ready-made native version (no import needed)
  • 00 — Start Here Guide (PDF)
  • 02 — Pricing & Profit Guide (PDF)
  • 03 — Wholesale & Sales-Channels Guide (PDF)
  • 04 — Cost Checklist & Materials Reference (PDF)
  • 05 — Printable Pricing Worksheets (PDF): pricing worksheet, materials log, price list, cost checklist
  • READ-ME-FIRST.txt

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Running an operation that's genuinely outgrown the file? Ardent Seller isn't the generic SaaS app this ladder warns about — it's maker-first software built by the same workshop: your data stays yours, you can start free or pay as you go with no subscription required, and it's sized for your operation, not someone bigger. The platform to graduate to when a spreadsheet honestly can't keep up.

Ready to start

Instant download · Free lifetime updates · Personal use license

$24.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.