A craft business has three kinds of stock, and most makers only think about one. There are materials: the cord, clay, wax or fabric you buy. There are finished pieces: what you've made and not yet sold. And, for many, there's stock that's somewhere else: at a shop on consignment, or packed for next weekend's fair. One sheet can hold all three if each row says what it is, how many, what it cost, and where it is. That sheet then answers the questions a maker actually gets asked: what do I need to order, what can I take to the fair, what does the shop still have, and, once a year from the accountant, what was it all worth on December 31. Below is a sheet for a made-up macramé maker, how to value finished work, and the file.
The short version
- Materials, finished pieces and consignment stock: separate rows, one sheet.
- Count materials in the unit you buy. Count finished work piece by piece.
- Value finished pieces at what went into them, not at their price.
- Consignment stock is yours until it sells. Keep a row for each shop.
- A reorder level on every material you'd be stuck without.
- TaroStack takes materials off stock when you record what you made. More below.
An example sheet
| Item | Kind | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Cotton cord, 4 mm, natural, 200 m spool | Materials | 6 | 4 | $18.50 | $111.00 | OK |
| Cotton cord, 4 mm, sage, 200 m spool | Materials | 1 | 2 | $19.50 | $19.50 | REORDER |
| Kraft boxes, 8 x 8 x 4 in | Packaging | 38 | 40 | $0.92 | $34.96 | REORDER |
| Plant hanger, single, natural | Finished | 14 | 10 | $4.10 | $57.40 | OK |
| Wall hanging, small, sage | Finished | 2 | 4 | $7.60 | $15.20 | REORDER |
| Plant hanger, single, natural | On consignment, Fern & Fig | 8 | 4 | $4.10 | $32.80 | OK |
Thirteen rows in all, $507.26 of stock at cost. Four rows are at or under their level: sage cord, boxes, double plant hangers and sage wall hangings.
The flags connect. Sage wall hangings are low, and they can't be restocked because there's one spool of sage cord left. The order to place today is cord, not an evening at the workbench.
What finished work is worth
On the sheet, a finished plant hanger is $4.10, though it sells for $28. The $4.10 is what's in it:
| Cord, 38 m of a 200 m spool at $18.50 | $3.52 |
| Wooden ring, one of 20 at $7.20 | $0.36 |
| Hang tag | $0.14 |
| Ribbon | $0.08 |
| Materials in one hanger | $4.10 |
Stock is valued at cost because that's what you've spent and not yet recovered. The price is what you hope to get. Whether your own time belongs in the figure is a question for your accountant: many small makers value stock at materials only. What matters is doing it the same way every year. The sum, and what it does to profit, is in craft business cost of goods sold.
Work in progress (the half-knotted wall hanging on the rack) is materials that have left the spool and aren't yet a product. For a small maker, count it as the materials in it.
Consignment
Twelve plant hangers went to a shop on November 6. They're still yours. On the sheet they move from "Finished, in the studio" to "On consignment, at Fern & Fig": same item, same cost, different place.
Visit or ask for a count every month. On November 20 the shop had eight, so four sold, and the shop owes you for four on December 1. Without the row, you're relying on the shop's memory for what you left, what sold and what's owed. A handover sheet signed by both of you when you drop off stock settles it. The terms themselves belong in a short agreement: see wholesale agreement template.
Counting
Materials. Whole spools, packs and boxes are easy. For part-used ones, estimate to a quarter: three-quarters of a spool is 0.75. Don't measure cord to the meter. It isn't worth your evening.
Finished pieces. One by one, by design and color. This is the count that goes wrong, because pieces are in the studio, in the fair bins, in the car and at the shop. Count each place and add.
When. At least at year end, for the tax return. Better, before every fair and every reorder. How to do it is in how to count inventory.
For a fair
Before a fair, the sheet tells you what there is to take. After, what's left tells you what sold. How much to bring is in how much inventory for a craft fair, and a sheet for the day in craft fair inventory sheet. Prices are in how to price handmade items.
Get the spreadsheet
Download the craft business inventory spreadsheet. Four sheets: inventory with value and a REORDER flag, a lots sheet for dye lots and consignment drops, a count sheet to print, and a read-me. Replace the cord and rings with your own materials. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Every piece you make should take cord, a ring and a tag off the materials rows and add one to the finished rows. That's four cells to change for one plant hanger, and nobody does it at the workbench. So the materials count is right on the day you count and wrong by the weekend, and the first you know that sage cord is out is when you reach for it.
How TaroStack does it
TaroStack changes the four cells when you record what you made.
Each design is a recipe. 38 m of cord, a ring, a tag. Record six hangers made and the cord, rings and tags go down by exactly that, with the spool converted to meters for you.
"What could I make right now" says how many of each design your materials allow, and which material stops you.
The cost of a piece is real, from what the cord actually cost, so your stock value is right without a sum.
Places. The studio and a shop holding your work can each be a site, with what's there. More than one site needs Business.
Counting on a phone, bin by bin, and a reorder list for materials.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Take materials off when you make | Four cells by hand | Record the batch |
| What can I make with what I have | Work it out | What could I make right now |
| Stock value at year end | Count, then sum | Stock value, by month |
| What to reorder | A flag, after a count | The reorder list |
Starter, at $9.99 a month, holds 50 items and 5 recipes: enough for a small range. Growth, at $39 a month, has 3,000 items and 50 recipes. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
