How to Track Material Inventory in a Small Woodworking Shop

Walk into most small shops and ask "how many sheets of 3/4 birch ply do you have right now?" and you'll get a shrug and a walk over to the rack to count.

That not-knowing costs real money in three quiet ways:

• Double-buying. You order a few sheets for a job because you're not sure what's on hand — and you already had three leaning against the wall. Now your cash is sitting in plywood instead of your bank account.
• Dead stock. Material you bought for a job that changed, or over-ordered "to be safe," slowly turns into a pile nobody remembers. It's money you spent that may never become a finished product.
• Emergency runs. You run out of 3/4 ply halfway through a cut and make a panic trip to the lumberyard, often paying retail for the one sheet you're short — plus an hour of your day.

None of these show up as a line item. They hide inside "materials cost went up this year." A simple inventory habit converts that fog into a number you can manage.

This guide is about the stock you buy — full sheets and lengths. The remnants left after cutting are their own discipline; we cover those in our offcut tracking guide. You want both, but they're tracked differently.

It's worth separating the two from the start, because they behave differently:

• Stock is material you purchased and haven't cut into: full 4×8 sheets, full lengths of lumber, trim, or bar stock. It has a cost — you paid the lumberyard for it — and a quantity that goes down as you consume it.
• Offcuts are the usable remnants left after a cut. They're effectively *free* (you already paid for the parent sheet), they come in odd sizes, and the discipline is about surfacing them before you cut fresh material.

Mixing them into one list muddies both. Your stock list answers "what did I buy and what's it worth?" Your offcut list answers "what free material can I use before buying more?" Keep them as two lists that talk to each other.

Resist the urge to track everything about everything. For each stock item, you need just enough to answer "do I have this, how much, and what did it cost?":

• Material / species + thickness. "3/4 birch ply," "5/4 hard maple," "1/2 MDF." This is how you tell from across the shop whether an item fits the job.
• Dimensions. For sheet goods, that's width × height (e.g. 1220 × 2440 mm, or 4×8 ft). For linear materials (lumber, trim, molding, bar stock), it's the length.
• Quantity. How many sheets or lengths you currently have.
• Unit cost. What you paid per sheet or per length. This is the number that turns "I have 5 sheets" into "I have $425 of plywood."
• A label (optional). A nickname like "Home Depot batch, May" that helps you tell two otherwise-identical entries apart.

On price changes: when you buy the same size again at a different price, keep it as its own batch with its own unit cost rather than overwriting the old number. That way your material cost reflects what you actually paid, batch by batch — the $85 sheets and the later $80 sheets stay distinct instead of collapsing into a single guessed average.

The single most useful thing an inventory gives you is a clean answer to: for this next job, what do I actually need to order?

Done by hand, that's a four-step slog every time:

1. Build the cut list and optimize it to know how many sheets of each size the job needs.
2. Walk to the rack and count what you already have in those sizes.
3. Subtract on-hand from needed to get "to buy."
4. Check whether any big offcuts could cover part of the need before you order full sheets.

Every one of those steps is a place to make a mistake — miscount the rack, forget the offcut pile, round the wrong way — and you're back to double-buying or coming up short. This is exactly the calculation worth automating, because you do it on every single job.

EZNESTING Pro turns the manual slog above into the by-product of planning you're already doing.

The Stock list. Add the sheets and lengths you own. Sheet materials are tracked by width × height; linear materials by length. Each entry carries a quantity, a unit cost, an optional material name, and an optional label. Add the same size again at a new price and it's kept as its own batch with its own cost — no overwriting, no fake averages.

Prices flow into quotes. When you import a project's stock into a quote, any line linked to an inventory item arrives with its unit cost already filled in. No retyping prices, no spreadsheet lookups.

The Purchase Orders view answers "what do I buy?" Pick a project, and EZNESTING groups the stock the job needs by size, subtracts what you already own, and shows the quantity to buy for each size — with the cost pulled from your inventory. Any matching offcuts are listed right alongside the buy list, so the free material in your rack stays in view and you can choose to pull from it before ordering. (You decide what to use from offcuts — EZNESTING surfaces them rather than silently assuming you'll cut them up.)

Inventory stays honest at completion. Inventory isn't decremented in real time as you cut — by design. When you mark a project Completed, the reconciliation step asks how many sheets you actually used versus planned, and your stock counts update then. You sync with reality at the moment the job ends, instead of trusting a running count that drifts.

What it doesn't do, to be clear: it doesn't reserve stock for in-progress jobs, auto-decrement mid-cut, or compute a single blended average cost across batches. It's a deliberate, lightweight loop — not a real-time ERP.

The smallest version of a stock system that actually works:

1. Inventory what you own once. Spend a morning counting your full sheets and lengths by size and species. Record quantity and what each cost.
2. Separate stock from offcuts. Full sheets go on the stock list; usable remnants go on the offcut list (with a threshold so you don't log slivers).
3. Update on purchase and at job completion. Add stock when you buy it (as a new batch with its price); decrement when you finish a job and reconcile what you actually used.
4. Check before you buy. Make "what do I already have, and what do I actually need to order?" the first question on every new job — not the rack-counting afterthought.

Do this for a few months and the payoff is concrete: less cash tied up in plywood you forgot you had, fewer emergency lumberyard runs, and a material-cost number you can actually trust when you quote the next job.

EZNESTING Pro is $19.99/month and includes stock and offcut inventory plus the purchase-order view. You can start free with the optimizer and upgrade when you're ready to close the loop.

How do small woodworking shops track material inventory? The simplest workable system is two lists — stock you've bought (with quantity and unit cost) and usable offcuts — updated when you buy material and when you finish a job. A spreadsheet works if someone maintains it; dedicated software like EZNESTING Pro keeps it tied to your cut lists and quotes so it doesn't drift.

What should I record for each piece of stock? Material/species and thickness, dimensions (width × height for sheets, length for linear stock), quantity, and unit cost. An optional label helps tell similar batches apart. That's enough to answer "do I have it, how much, and what's it worth?"

Should I track inventory in a spreadsheet or software? A maintained spreadsheet beats neglected software. But a spreadsheet can't tell you what to buy for a specific job, and it drifts because every change is a manual edit. Software that's tied to your cut lists — so the "what do I buy?" answer is automatic and reconciliation updates counts for you — earns its keep once you're running multiple jobs.

Does EZNESTING track lumber as well as sheet goods? Yes. Stock is tracked as either sheet (by width × height) or linear (by length), so plywood, MDF, and melamine sit alongside lumber, trim, molding, and bar stock in the same inventory.

Does EZNESTING automatically subtract offcuts from what I need to buy? No — and that's deliberate. The purchase-order view shows your matching offcuts alongside the buy list so you can decide whether to use them, rather than assuming you'll cut up a remnant. It subtracts the full stock you already own from what the job needs; offcuts are surfaced for you to choose.

Does inventory update automatically as I cut? No. EZNESTING updates stock counts when you mark a project Completed and reconcile what you actually used. It intentionally avoids real-time decrement so your counts reflect reality at job's end rather than a running guess that drifts.