Free Resources
Practical tools for small-batch product businesses — templates, spreadsheets, and calculators you can use today. All free: the spreadsheets are sent to your email, and the calculators run in the browser with no sign-up.
General-purpose templates for materials, production records, and cost of goods sold — whatever you make.
GMP-ready Excel template for recording production batches — ingredients, lot numbers, manufacturing steps, QC results, and operator sign-off. Works in Excel, Google Sheets, and Numbers.
Seven-tab Excel template for tracking raw materials, purchases, manufactures, finished products, and orders — with automatic landed costs, batch costs, and COGS tallies. Works in Excel, Google Sheets, and Numbers.
Calculate cost of goods sold from real records rather than a year-end estimate — beginning inventory, purchases at landed cost, and ending inventory, all tallied for you. Works in Excel, Google Sheets, and Numbers.
Track material stock levels, landed unit costs, and what each production run consumed — in whatever unit you actually issue to production. Works in Excel, Google Sheets, and Numbers.
Printable stocktake sheet with columns for product, SKU, location, expected quantity, and counted quantity — so a physical count records what is actually on the shelf before anyone looks at the system figure.
Rolling cycle-count workbook for Excel, Numbers, and Google Sheets — schedule counts by material group, log variances, and keep stock accurate without shutting production down for a full stocktake.
Ingredient tracking and recipe costing for bakeries, cafes, roasteries, and small food producers.
Seven-tab template for cafes, espresso bars and roasteries — beans, dairy, syrups, packaging and food, with automatic cost and COGS tallies. Works in Excel, Google Sheets, and Numbers.
Track ingredients on hand, monitor stock levels, and know exactly when to reorder flour, butter and supplies. Works in Excel, Google Sheets, and Numbers.
Calculate recipe costs, cost per batch, cost per item, and profit margins — so you know what each bake costs before you price it. Works in Excel, Google Sheets, and Numbers.
Fabric by the metre, finished stock by style and size, and a cost per garment that includes the offcuts.
For brands that cut and sew — fabric and trims tracked by the metre, garments by style and colourway, and a cost per garment built from landed cloth costs. Works in Excel, Google Sheets, and Numbers.
Yardage on hand per cloth, weight and colourway, landed cost per metre including freight and duty, and consumption logged per cut. Works in Excel, Google Sheets, and Numbers.
Finished stock by style, size and colourway, one order log covering every channel, and margin per line visible on the same row. Works whether you produce in-house or have units made for you.
Long ingredient lists, small usage rates, and packaging that costs more than the contents.
Bills of materials, material requirements planning, and production scheduling — for when a stock list stops being enough.
Seven-tab material requirements planning workbook — material inventory, purchases, manufactures, product inventory, orders, and reports, with cost of goods manufactured rolling up automatically.
Pre-built BOM workbook for Excel and Google Sheets with columns for component, quantity, unit cost, line total, and preferred supplier — plus a rolled-up cost per finished unit.
Plan and schedule production runs against real material availability — what to make, in what order, and whether you actually have the stock to finish the batch.
Track raw materials, work in progress, and finished goods in one workbook — the three-stage view a manufacturing business needs and a plain stock list never gives you.
Work out what a product really costs you and what it needs to sell for. No sign-up, results as you type.
Selling price from cost and markup, markup from any sale price, and a markup ↔ margin converter — the one that stops you quoting 40% markup when a buyer asked for 40% margin.
Spreads batch overhead and admin costs across the run, then applies your markup — so a wholesale price sheet starts from real per-unit cost rather than a guess at volume.
What Shopify actually takes per sale, by plan and payment processor — including the extra transaction fee that only applies if you use a third-party gateway.
True cost per unit including tariffs, import duties, freight and brokerage — then labour, overhead and platform fees, so you see the real margin before you set a price.
What running out actually costs you — lost orders, refunds and fees, the hours spent fixing it, and the customers who don't come back. Monthly and annual totals.
Work out what a Faire wholesale order actually pays you — 15% marketplace commission, the $10 new-customer fee, and payment processing that changes with your payout speed.
Cost a recipe ingredient by ingredient, add labour and overhead, and see food cost percentage against three pricing methods — built for batch production, not restaurant plating.
Generate the codes your catalogue needs and handle the arithmetic that comes up mid-batch.
Build consistent SKU codes from a product name and up to three variant attributes. Set your own segment length and separator, then export the whole list as CSV for bulk upload.
Validate a UPC-A, EAN-13 or GTIN-14 barcode, or generate the missing check digit from your payload. Catches the typo before you print a run of labels.
Convert between grams and millilitres using real ingredient densities — pre-loaded with 30+ oils, waxes, liquids and powders. Converts in both directions and shows the fl oz equivalent.
Turn a percentage-by-weight formulation into gram weights for any batch size. Handles up to 20 ingredients, accepts grams or ounces, and flags a formulation that doesn't total 100%.
Go beyond the spreadsheet
These templates are a solid starting point. Stocksmith takes it further — batch records generated automatically from production logs, real-time inventory tracking, and full lot traceability without the manual work.
No credit card required. Takes hours to set up, not weeks.