Sit ten craft sellers down and you’ll get two answers about margin: “to the cent” or “I think so.” If you have ever raised wax or resin costs and forgotten to reprice three SKUs, you already know the failure mode. This google sheets craft business manager closes that gap by tying every raw material cost directly to every finished product through one connected workbook.
The killer feature is the materials-to-margin chain. Log a purchase on the Purchases tab and the Materials inventory auto-updates the average cost across every purchase date for that item. The Bill of Materials tab then pulls those live costs into each product recipe, and the Products tab rolls fixed, labor, and material costs into a per-unit Cost of Goods Sold with the profit margin calculated for you.
Change one supplier price and the entire chain recalculates. That means the google sheets craft business manager stops you from selling at last year’s numbers, and it surfaces which SKUs quietly stopped being profitable when packaging or shipping crept up.
The Sales tab logs orders with customer info, fulfillment status, payment status, platform fees, transaction fees, shipping, handling, and discounts, then calculates total revenue, cost, and profit per order. Inventory drops automatically as you fulfill, so the Materials counts stay honest without a separate reconciliation pass.
The Production log records manufacturing batches and pulls materials out of stock the moment you build. The Dashboard visualizes the data, the Price List prints clean for craft fairs and wholesale buyers, and a Traceability report walks any finished unit back through the materials that built it.
Sixteen tabs total, supports any currency, every table filters and sorts, and the Settings tab lets you reconfigure without touching a formula. The download includes both the Google Sheets version and an Excel file with example data, so the google sheets craft business manager works whether you live in Drive, on your desktop, or both, and your margin math stops being a guess.
