Walk into any craft shop and the making — the candles, the soap, the jewelry, the embroidery — is the part already handled. It is the rest of it that quietly eats your evenings. This excel craft business manager is built for Etsy sellers, craft fair vendors, and small-batch makers who would rather spend that time at the bench.
Most craft sellers we talk to are running their numbers across a half-dozen places. A purchases sheet from last year, a notes app full of supplier emails, a calculator on the kitchen counter for margin math, a separate document for the price list, sticky notes for which orders shipped. Costs creep, inventory drifts, and pricing becomes a guess dressed up as a decision. Tax time arrives and the reconstruction begins.
The excel craft business manager replaces that pile with sixteen connected tabs. Materials tracks raw stock and packaging with automated status flags and a running inventory value, so you stop ordering ribbon you already have. Purchases logs every raw material order and averages cost across purchase dates, which is how the Products tab can quote you an honest cost per item — fixed, labor, and materials broken out separately, with COGS and profit margin calculated for you. The Suppliers tab keeps contact details and lead-time notes where you can actually find them.
The Bill of Materials tab is where the workbook earns its keep. Assign components to a finished product once, then every batch you record on the Production log draws those materials down automatically and flags low-inventory items in conditional formatting. Status drop-downs cover Complete, In Process, and Pending so nothing sits half-finished in your head. SKU generation is automatic, and traceability runs from a raw material purchase all the way through to the sale that consumed it.
On the sales side, the Sales tab captures customer information, fulfillment and payment status, shipping and handling, platform and transaction fees, discounts, and sales tax — the line items Etsy, Shopify, and Amazon Handmade quietly skim before the deposit hits. The Customers tab keeps repeat buyers organized, the Invoice sheet prints cleanly for wholesale and custom orders, and the Price List prints for craft fair booths. The Dashboard rolls revenue, cost, and profit into a visual that updates the moment you log a sale, and a Traceability Report is there for quality reviews.
What disappears, more than anything, is the mental math. Update a material price once and every product cost, every margin, and every dashboard chart re-settles around it. The file ships in both Excel and Google Sheets versions, supports any currency, comes with step-by-step instructions and a populated example workbook, and the Settings tab is editable without any Excel expertise — though if you have it, the whole workbook is open for customization. Quiet tools, doing the bookkeeping so the craft can stay the loud part.
