Skip to content

Leather Inventory Template: Hides by the Square Foot

A free leather inventory template for a leather goods workshop: sides by the square foot with dye lots, usable area, hardware, finished goods, and a file.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 19, 2026 · 6 min read

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.

Questions people also ask

How do you keep inventory of leather?

In square feet, one row for each leather, with each delivery of hides recorded as a lot: how many sides, their footage, and the dye lot.

How much of a hide is usable?

It varies with the hide and the product. The example workshop uses about 80% of a clean side and 65% of one with brands. Measure your own offcuts to find yours.

Why does dye lot matter in leather?

Color varies between dye lots of the same named color. Goods meant to match should be cut from one lot.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.