Imagi-Tech

Software

Wood Products Software: Tracking Lumber, Orders and Yield

Wood products software has to count what a mill actually sells: board feet by species and grade, lumber moving through a kiln lot, and the yield each log returns. Most general inventory software counts boxes on a shelf instead, which is why so many yards still run on a whiteboard, a notebook and an old database.

We work out of Marietta, in the hardwood country of southeast Ohio, and the mills and yards around us share one problem. The work is measured in volume that changes shape, and the software they were sold measures pieces.

What a mill tracks that off-the-shelf software does not

A general inventory app counts items: you have 40 of this and 12 of that. A mill’s stock doesn’t behave like that. A log comes in on a scale ticket, goes out as boards of several grades, loses moisture in the kiln, and ships on a tally sheet listed by species, grade, thickness and length. What a mill needs to track:

  • Logs and lumber by species and grade, in board feet, not in pieces.
  • Each kiln lot: what went in, when, and the moisture readings along the way.
  • Orders and tally sheets, from order entry through shipping.
  • Yield: what came out of each log or lot against what went in.

If you sell finished goods by the piece and buy few raw materials, a standard inventory app may be all you need. The gap is widest for a sawmill or lumber yard, and it shows up in a cabinet shop too: it buys lumber by the board foot and sells cabinets by the piece, and somewhere between the two units the margin goes missing.

Board feet, species and kiln lots in one table

A board foot is 144 cubic inches of wood: a board one inch thick, twelve inches wide and twelve inches long. For any board, multiply thickness by width by length in inches and divide by 144. Lumber inventory software for a small business should do that sum for you every time stock moves.

The core of the system is one table, with a row for each lot of lumber:

ColumnWhat it holds
Species and gradeThe species and grades you sell, such as white oak or red oak, by grade
ThicknessThe thickness the lot was sawn to
Board feetWorked out from the tally, never typed in by hand
Kiln lotWhich charge it went into, and when
MoistureEach reading, with the date it was taken
LocationWhere in the yard or shed it sits
StatusGreen, in the kiln, dry, reserved for an order, or shipped

With that table, board feet inventory tracking becomes a total you read off a screen, so the tally matches the yard without a walk-around. Stock on hand, what is in the kiln this week and what is promised to orders are all different views of the same rows.

Connecting estimating to the shop floor

The same table should feed the estimate. A quote is priced in board feet by species and grade, with a waste allowance taken from your own yield history rather than a guess. When the customer says yes:

  • The stock for the order is reserved, so two people can’t sell the same lumber twice.
  • A cut list or work order goes to the floor, on a screen or a phone the crew already carries.
  • The kiln schedule shows when the order’s lumber will be dry, and the whole crew can see it.
  • What the floor actually got out of the lumber is recorded against the order.

That last step closes the loop. Recorded yield on real jobs makes the next estimate more accurate, and over a season it gives you yield reporting good enough to set prices from.

Access, Excel or a real system: how to decide

  • Excel works for one person tracking stock in one office. It struggles once several people edit at once, once you need a history of who changed what, or once somebody in the yard needs it on a phone. Our post on when a spreadsheet quietly becomes a system covers the signs.
  • Access is where a lot of mills already are, usually in a database built years ago that runs on one machine. Moving it keeps the workflow your people know, and the old file keeps running until the new system matches its numbers. Our page on Access migration for sawmills and lumber yards covers that move.
  • A real system makes sense when the yard, the scale house and the office all need the same numbers at once, or when orders, kiln and yield have to connect.

Some of the paperwork can be helped along the way. AI can turn a photo of a tally sheet into rows, but it can’t supply yield or moisture figures you never recorded, so the table comes first.

What a build costs and how long it runs

We don’t publish a price for custom software, because the scope sets it. Every build starts with a free audit of what you track today and gets a fixed quote in writing before anything is billed. What moves the price most:

  • How many of the four jobs it covers: inventory, kiln, orders and yield.
  • How many people use it, and where: the office, the scale house, phones in the yard.
  • What it has to connect to, such as accounting or your website.
  • How much history comes across from an old database or spreadsheet, and how clean it is.

The work is done in stages, so the yard keeps shipping. We sit with the people doing the work first, you approve a written blueprint before any building starts, and you click through working versions at each checkpoint. If the starting point is an Access file, a single-department database usually takes eight to twelve weeks from audit to cutover. Our page on custom software for sawmills and lumber yards covers how we build, and website design for sawmills and lumber yards covers the other side: pages by species and grade, so buyers find the mill before they find a broker.

Free audit

Let's get started

Tell us what's giving you trouble, in your own words. "Our Access database is dying" is plenty to go on.