Skip to content

Woodworking Inventory Spreadsheet: Lumber by the Board Foot

A free woodworking inventory spreadsheet: lumber in board feet by species and load, sheet goods, finishes with dates, hardware, finished pieces, 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

Lumber is bought and counted in board feet: thickness in inches, times width in inches, times length in feet, divided by 12. A board 1 inch thick, 8 inches wide and 10 feet long is 6.67 board feet. A woodworking inventory spreadsheet keeps one row for each species and thickness, in board feet, with what you paid a foot. A second sheet records each load as a lot, with its moisture when it arrived, so you know what's ready to cut. Sheet goods, finishes, glue, abrasives, hardware and finished pieces get their own rows. Below is a sheet filled in for a made-up woodshop, the sum for how much rough lumber a job really takes, and the file.

The short version

  • Board feet = thickness (in) × width (in) × length (ft) ÷ 12.
  • One row for each species and thickness.
  • Each load is a lot, with its moisture on arrival and the date.
  • Rough lumber yields less than its footage. Find your own share.
  • Finishes and glue have shelf lives. Date them.
  • TaroStack takes lumber and hardware off stock with each batch and notes which load it came from. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Walnut, 4/4, rough bd ft 142 100 $11.50 $1,633.00 OK
White oak, 4/4, rough bd ft 210 150 $7.80 $1,638.00 OK
Hard maple, 8/4, rough bd ft 64 80 $8.40 $537.60 REORDER
Cherry, 4/4, rough bd ft 96 60 $8.90 $854.40 OK
Baltic birch plywood, 3/4 in, 5x5 sheet 9 6 $78.00 $702.00 OK
Cutting board, walnut, 12x18 each 14 10 $44.60 $624.40 OK

Eleven rows in all, $6,741.60 of stock, with hard maple and serving trays to reorder.

Board feet, worked

Board Sum Board feet
4/4 walnut, 8 in × 10 ft 1 × 8 × 10 ÷ 12 6.67
8/4 maple, 6 in × 8 ft 2 × 6 × 8 ÷ 12 8.00
4/4 oak, 5.5 in × 12 ft 1 × 5.5 × 12 ÷ 12 5.50

"4/4" is quarters of an inch: 4/4 is one inch rough, 8/4 is two. Rough lumber is measured before it's surfaced, so the footage you buy is always more than the footage you end up with.

Tally a load when it arrives. Measure each board, write the footage on its end in marker, and add them up against the invoice. From then on, taking a board off the rack means subtracting the number on its end.

What a job really takes

Eight walnut cutting boards
Finished size each, 12 × 18 × 1.5 in 2.25 bd ft
Finished wood in eight boards 18 bd ft
Rough walnut used 30 bd ft
Yield 60%

Forty percent of the walnut became shavings, sawdust, end trim and the sapwood that was cut away. That's normal for rough stock, and worse for walnut than for most because of the pale sapwood. It's also where the money is: at $11.50 a foot, each board has $43 of walnut in it, not the $26 its finished size suggests.

So the 142 board feet on the rack isn't 63 cutting boards. At this shop's yield it's about 37. Quote from the yield, not from the finished dimensions, and keep a figure for each species: clear maple wastes less than walnut.

Loads are lots

Received or made Item Lot Quantity Note
Oct 5 Walnut, 4/4 WN-1005 180 bd ft Kiln dried; 7% on arrival
Oct 5 White oak, 4/4 WO-1005 250 bd ft Kiln dried; 8%
Nov 9 Hard maple, 8/4 HM-1109 64 bd ft 10%: sticker and wait two weeks
Nov 12 Cutting board, walnut CB-1112 8 Walnut WN-1005; 30 bd ft used

Two reasons to keep loads apart. Moisture: the maple came in at 10%, wetter than this shop likes to cut, so it's on the sheet and not yet available. Counting it as ready would promise a job the wood can't keep. Matching: boards from one load, often one tree, match in color and grain. A table top glued up from two loads of walnut can show a line. Note the load on each batch of finished pieces, the way lot codes are used in how to create lot numbers.

Finishes and glue

A can of hardwax oil skins over once it's opened, and wood glue thickens with age and frost. Both are on the Lots sheet with a use-by, and this shop writes the opening date on every lid. A finish that fails on a delivered piece costs far more than the can.

Selling the finished pieces online and at shows is in Etsy inventory spreadsheet and craft fair inventory sheet. Adding time and overhead to the wood is in batch cost calculator.

Get the spreadsheet

Download the woodworking inventory spreadsheet. Four sheets: inventory with value and REORDER, lots for loads and batches, 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

The rack changes every time someone pulls a board, and nobody walks to a laptop with sawdust on their hands. A month in, the walnut row is whatever it was after the last delivery, and the only way to trust it is to tally the whole rack again.

How TaroStack does it

TaroStack takes the wood off when the pieces go on.

Each product is a recipe. A cutting board takes 3.75 board feet of rough walnut, glue, oil and a label, with a scrap allowance. Record eight boards and 30 board feet come off the rack on the sheet.

The load is noted. The lot of lumber used goes onto the batch record automatically.

A load can wait. Put lumber on hold while it acclimates. It's counted, and it's kept out of what's available until you release it.

Recipe truth. From your own batches, TaroStack shows whether a product really uses the lumber its recipe says. That's your yield, kept current.

What things really cost. Each batch is costed from the loads it used, so a price rise at the dealer shows up in the next board's cost.

The job Spreadsheet In TaroStack
Subtract the wood a job used By hand, later Recorded with the batch
Wood that's still acclimating A note On hold
Yield by product Measure and guess Recipe truth
Cost of a board at today's prices Retype the price From the loads used

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 calculate board feet?

Thickness in inches times width in inches times length in feet, divided by 12. A 1 × 8 inch board 10 feet long is 6.67 board feet.

How do you keep track of lumber inventory?

One row for each species and thickness, in board feet. Tally each load on arrival, write the footage on each board's end, and subtract as boards are used.

How much extra lumber should I allow for waste?

It depends on the species, the grade and the product. The example shop gets 60% of its rough walnut into finished cutting boards. Measure a few jobs to find yours.

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.