Product facts
- Best suited to: Etsy sellers, craft fair vendors, and small-batch makers tracking the materials behind finished products.
- Software: Microsoft Excel, with a separate Google Sheets version included through the supplied access guide.
- Download: one .zip with a blank Excel workbook, a populated example workbook, a Google Sheets access PDF, step-by-step instructions, a read-me, and an optional Ardent Seller comparison.
- Scope: 16 connected tabs covering materials, purchases, product costing, bills of materials, production, sales, and reporting.
- Purchase: one-time digital download. You maintain the records and can customize the workbook.
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.
Example: trace materials into a finished bouquet
The example shown below uses a White Tulip Bouquet. Its bill of materials lists artificial tulips, greenery, a vase, a thank-you card, and packaging. Each row connects the quantity used in one bouquet to a material cost. The Production table records the batch quantity and completion status, while material inventory flags show what needs attention.
To use that workflow for your own product, replace the example components with yours, enter the units needed per finished item, and record a production batch. Review the resulting material consumption and inventory status before buying supplies for the next batch. The screenshot contains illustrative sample records.
Before you buy
Is this an Etsy listing tool or a business workbook?
It is a workbook for maintaining material, production, customer, and sales records. You record orders and their fees in the Sales tab. The product is intended to organize the business behind your listings.
Can I use Google Sheets instead of Excel?
Yes. The download includes access instructions for the separate Google Sheets version, as well as the Excel workbook and a populated Excel example.
Is this suitable for a bakery?
For recipes with ingredient quantities, serving yields, unit conversions, and allergen records, compare the Bakery Business Manager. Craft Business Manager focuses on component-based products and bills of materials.
For purchase conditions and usage terms, read the Terms of Service and licensing FAQ. For setup help, contact Ardent Workshop.
