PRO EXCEL WORKBOOK

Handmade Product Pricing Calculator

A reusable Excel workbook for tracking product costs, setting prices, checking profit, managing products, and testing wholesale pricing.

Workbook dashboard
Dashboard
Pricing calculator
Pricing Calculator
Product database
Product Database
Wholesale calculator
Wholesale Calculator

Cost & pricing

Bring materials, labor, packaging, shipping, fees, and other costs into one pricing workflow.

Product database

Keep product-level information organized instead of rebuilding calculations from scratch.

Wholesale workflow

Compare retail and wholesale numbers before accepting a lower-price order.

WHAT'S INSIDE

What's inside the workbook

The workbook is organised into four working views. Each one answers a different question about how a product earns money, and they all point back to the same product information, so you are not retyping the same figures into separate files.

Dashboard

A summary view that pulls the headline numbers from the other tabs. Use it to see cost, price, and expected profit side by side before you commit to a change.

Pricing Calculator

Enter materials, labour, packaging, shipping, and the fees you expect to pay. Set the margin you want and the sheet works backward to a suggested selling price.

Product Database

Keep one row per product with its costs, size, and notes so the same information can be reused. When a supplier price moves, you update it in one place rather than rebuilding the calculation.

Wholesale Calculator

Test what a lower unit price does to your margin when a shop or reseller asks for trade pricing, and see whether a larger order still works once your time and materials are paid for.

Who it's for

The workbook suits sellers who make a repeatable product and want a consistent way to price it, and who want that knowledge in a form they can reuse and update.

    Good fitMakers working in batches, small catalogues, or a handful of core designs who price new items by hand.
    Good fitSellers who need a retail number and a separate wholesale or consignment number for the same product.
    Good fitAnyone who wants pricing recorded in one file rather than spread across notes, receipts, and memory.
    Not the right fitOne-off pieces where every cost is genuinely different, or sellers who already track all of this inside an accounting or inventory system and do not want a second copy.

It is a planning workbook, not an accounting system. It does not connect to your shop or import orders, and it will not tell you what to charge.

How to use it

Open the file, work through the views in order, and save your own copy under a new name.

  • Start in the Product Database and add your products, one row each, with the costs you already know.
  • Move to the Pricing Calculator and enter materials, labour time, packaging, shipping, and the fees you expect for a single sale.
  • Set the margin you want to make, and read the suggested selling price the sheet returns.
  • Check the Dashboard to compare the result against your other products before you settle on a number.
  • Keep the wholesale view for trade enquiries, and update the database whenever a supplier price changes.

Treat the results as estimates to review rather than a final answer.

Delivery and access

Checkout and delivery are handled through Payhip, so payment and the download sit in one place.

  • The product is a digital file. Nothing is posted, and there is no physical item to ship.
  • After a completed purchase, access to the download is provided through Payhip according to the delivery options shown on the product page.
  • The workbook opens in a spreadsheet program on a desktop or laptop; it is not a mobile app.
  • If a download link does not work or you cannot open the file, contact support through the site and we will help you get it.

Frequently asked questions

Do I need to be good at spreadsheets to use it?

No. The workbook is built around input fields and labelled columns. If you can type numbers into a cell and read a total, you can use it.

Is this a one-time purchase or a subscription?

It is a digital workbook you download and keep. There is no subscription, and the file does not stop working after a period of time.

Can I use it for more than one product?

Yes. The Product Database is designed to hold several products, and the same pricing workflow is reused for each one.

Will it tell me exactly what to charge?

No. It calculates a suggested price from the costs and margin you enter. The final decision, and the assumptions behind it, stay with you.

Can I edit the file after I buy it?

Yes. It is a normal spreadsheet file, so you can add rows, columns, and your own notes, or rename it and keep a personal copy for your records.

HOW TO BUY

Simple checkout, instant digital delivery.

Payment and delivery are handled through Payhip. Review the product page, complete checkout, and access the digital download according to the delivery options shown there.

Open Payhip Product Page