Handmade Business Tracker & Pricing Calculator

For makers who sell online, at markets or by custom order. Work out what each product really costs (materials, packaging, your time and platform fees), price it with a target margin, then track sales, stock and monthly profit.

★ WHAT YOU GET

• 1 spreadsheet (.xlsx) with 9 tabs: Start here, Monthly summary, Setup, Materials, Recipes, Pricing, Sales, Expenses, Stock

• Materials (80 rows): pack price ÷ pack size = cost per unit

• Recipes (300 rows): which materials, and how much, go into each product. Materials cost per item adds up automatically

• Pricing calculator (40 products): packaging, making time × your hourly rate, total cost, estimated fees, profit, margin and a suggested price for your target margin

• Sales log (500 rows): channel, product, qty, item total, shipping charged and paid, fees (estimated for online marketplace sales or typed in), estimated profit per sale

• Expenses (300 rows), Stock (opening + made − sold, low-stock flag) and Monthly summary (orders, items, sales, fees, shipping, expenses, profit; sales per product; sales by channel; chart)

• 3-page printable PDF in US Letter and A4: pricing worksheet, market / craft fair sales tally, custom order form

★ COMPATIBILITY

Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Formulas were checked for Google Sheets and Excel compatibility (standard functions only, no macros, no add-ins) and tested in LibreOffice Calc. Unzip the download first (double-click on most computers). Best used on a computer or tablet. Enter dates as real dates (e.g. 3/15/2027 or 15/03/2027).

Printable PDFs in US Letter (8.5 × 11 in) and A4. Print at home or at a print shop (choose 'Actual size' or 'Fit'). The PDFs are for printing and writing by hand. They are not fillable forms.

★ GOOD TO KNOW

• Fee settings are example placeholders, not any platform's official fees. Check your platform's fee page and enter your own numbers.

• The monthly profit is a simple cash view, not an accounting or tax calculation, and not financial advice.

• Example products (candles) are included. Delete them and add your own.

• No currency symbol, so it works in any single currency.

★ For your own household or your own small business records. Please don't share, resell or redistribute the files.

★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.

★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.

Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.