How is the cost calculated?

Materials plus hours of work multiplied by your hourly rate, plus other costs per item.

No. Account for taxes and marketplace fees in other costs or in the price. Check the rules for the self-employed and sole traders with a tax adviser.

Can I set my own price?

Yes. If you enter your own price, it is used in orders and the markup is recalculated.

How many products and orders does it hold?

Up to 40 products and 500 orders.

No. The file works in Excel 2007 and later and in LibreOffice; all calculations use ordinary formulas.

← All templates

Handmade Workshop: Product Costs, Orders and Profit — Excel Template

A spreadsheet for a craft workshop: product costs including your labour, recommended price, an order log with payments and due dates, and profit by product.

250 ₽

≈ 3 USD

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it's for

Makers often sell by gut feeling and don't know how much they actually earn. The spreadsheet calculates the cost of each product (materials, hours of work, packaging), suggests a price with markup, tracks orders with payments and due dates, and shows profit for each product and for the workshop as a whole.

What's inside

"Settings": hourly rate, markup, report date.
"Products": up to 40 products — materials, hours, other costs; cost, recommended price and markup are calculated automatically.
"Orders": up to 500 orders — customer, product, due date, status, payment; amount, balance and profit are calculated automatically.
"Summary": revenue, profit, balance due, sales and profit by product, a chart.

Who it's for

Handmade makers: candles, soap, knitting, woodwork, jewellery, ceramics; the self-employed and small workshops.

Compatibility

Excel 2007 and later, LibreOffice. No macros. Rates and thresholds are in the settings: adjust them to suit you.

The file is in English.

Questions and answers

How is the cost calculated?: Materials plus hours of work multiplied by your hourly rate, plus other costs per item.
Are taxes included?: No. Account for taxes and marketplace fees in other costs or in the price. Check the rules for the self-employed and sole traders with a tax adviser.
Can I set my own price?: Yes. If you enter your own price, it is used in orders and the markup is recalculated.
How many products and orders does it hold?: Up to 40 products and 500 orders.
Do I need macros?: No. The file works in Excel 2007 and later and in LibreOffice; all calculations use ordinary formulas.