Leather is sold by the square foot, and no two hides are the same size, color or quality. So a leather inventory template counts leather in square feet, one row for each leather, and keeps a second sheet where every delivery of sides is a lot with its own footage and, for dyed leather, its dye lot. That's what tells you whether you can cut 30 matching wallets, and whether the 21 square feet on the rack are one clean side or three ragged remnants. Hardware, thread, finishes and finished goods get ordinary rows. Below is a sheet filled in for a made-up workshop, the sum for usable area, and the file.
The short version
- Leather in square feet, as the tannery measured it.
- Each delivery is a lot: how many sides, their footage, the dye lot.
- Usable area is less than measured area. Find your own share.
- Cut matching parts from one dye lot.
- Hardware in eaches, with a reorder point per product.
- TaroStack takes leather and hardware off stock with each batch and notes which lot it came from. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Veg-tan side, 8-9 oz, natural | sq ft | 84 | 60 | $9.50 | $798.00 | OK |
| Chrome-tan side, 4-5 oz, chestnut | sq ft | 46 | 40 | $7.25 | $333.50 | OK |
| Chrome-tan side, 4-5 oz, black | sq ft | 21 | 40 | $7.25 | $152.25 | REORDER |
| Pigskin lining, tan | sq ft | 35 | 20 | $3.10 | $108.50 | OK |
| Belt buckles, 1.5 in, brass | each | 64 | 50 | $4.80 | $307.20 | OK |
| Belt, 1.5 in, natural | each | 18 | 12 | $21.40 | $385.20 | OK |
Eleven rows in all, $2,463.85 of stock, with black chrome-tan and edge paint to reorder.
Measured feet and usable feet
The tannery's footage covers the whole side: the firm back, the stretchy belly, the neck, the ragged edge, and any brands or scars. You pay for all of it and cut from part of it.
| Veg-tan side from lot T-4417 | |
|---|---|
| Measured | 23 sq ft |
| Straight, firm back, good for belt straps | about 9 sq ft |
| Shoulder and belly, good for small goods | about 9 sq ft |
| Edges, flanks and flaws | about 5 sq ft |
Twelve belts were cut from that side. Each strap is 1.5 inches by 50, about half a square foot, so the twelve took 6.3 square feet off the sheet. But they used most of the 9 square feet that can make a belt at all. The 84 square feet of veg-tan on the sheet doesn't mean 160 belts. It means roughly 14 a side for the sides not yet cut, and a lot of wallet leather.
This workshop reckons on using about 80% of a good side and 65% of one with brands. Weigh or measure your offcuts for a few sides and you'll have your own figure, which is the one to cost with.
Lots and dye lots
| Received or made | Item | Lot | Quantity | Note |
|---|---|---|---|---|
| Oct 12 | Veg-tan side, natural | T-4417 | 4 sides, 90 sq ft | 22, 23, 21 and 24 sq ft |
| Oct 26 | Chrome-tan side, chestnut | CT-2288 | 3 sides | Dye lot 2288 |
| Sep 8 | Chrome-tan side, black | CT-2190 | 2 sides | One side with brands |
| Nov 9 | Belt, 1.5 in, natural | BL-1109 | 12 | From T-4417 |
"Chestnut" from one dye lot and "chestnut" from the next can be visibly different side by side. For a wholesale order of matching goods, cut everything from one lot, and if the lot won't cover it, order the whole job's leather at once. The sheet has 46 square feet of chestnut, all from dye lot 2288, so the 30 wallets are safe. Had it been two lots of 23, they might not be.
Veg-tan natural darkens with light and age, so a side that's sat by the window for six months won't match a new one either. Oldest first applies to leather too.
Writing the leather lot on each batch of goods (BL-1109 came from T-4417) costs nothing and answers the question a customer asks a year later: can I get another one that matches? Lot codes are in how to create lot numbers.
Hardware and small things
A belt takes one buckle, one keeper and two rivets or screws. Set each hardware reorder point from the product: 64 buckles is 64 belts, and at 12 belts a week that's five weeks. The cheapest part on the sheet, a rivet at six cents, stops a $90 belt as surely as the leather does.
Finished goods at a market or on a shop page are covered in craft fair inventory sheet and Etsy inventory spreadsheet. Cloth by the yard has the same lot problem, in fabric inventory spreadsheet.
Get the template
Download the leather inventory template. Four sheets: inventory with value and REORDER, lots, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Every product takes a little of five things: leather, lining, thread, a buckle, rivets. After a day at the bench, nobody updates five rows. The leather rows drift first, because the amount cut is never the amount the pattern says, and the sheet can't see the offcut bin.
How TaroStack does it
TaroStack takes the parts off as the goods go on.
Each product is a recipe. Half a square foot of veg-tan, a buckle, a keeper, two rivets, with a scrap allowance for what the knife wastes. Units convert, so leather bought by the side and used by the square inch is one item.
Recording a batch moves the stock. Twelve belts on, and the leather, buckles and rivets off, from the lots you used. Those lots are noted on the batch record automatically.
"What could I make right now" says how many belts the leather and the hardware on hand allow, and which runs out first.
Recipe truth. From your own batches, TaroStack shows whether a product really uses the leather its recipe says, which is how a scrap allowance gets corrected.
A reorder list for hardware and leather below their reorder points.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Take leather and hardware off | Five rows by hand | Recorded with the batch |
| Which side these belts came from | A note | On the batch record |
| Is the scrap allowance right? | Measure the offcut bin | Recipe truth |
| What to reorder | Scan the sheet | The reorder list |
Stock, lots, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (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.
