Industry

Lumber and Timber Inventory Management Software: A Practical Guide

How to track lumber and timber stock by lot, location and status, why generic inventory software struggles with logs and sawn timber, and how to choose one.

Punj Shah

A timber business holds stock that is awkward to count. A log is not a unit, a stack of sawn boards is not one thing, and a lot changes shape when it goes through a mill. That is why many yards still run on spreadsheets, and why those spreadsheets stop being trusted as the business grows.

This guide covers what to track, where inventory goes wrong, and how to judge lumber and timber inventory software. We build LumberLinq, so we are not neutral, but the points apply to any product.

Why timber is different from other stock

  • It is measured, not counted. The same 50 pieces can be 3 CBM or 6 CBM. Volume has to come from the measurements.
  • Every lot is different. Species, grade, size and supplier change the value, so lots cannot be merged into one number.
  • It changes form. Logs become sawn timber, and sawn timber becomes finished stock. Yield and waste are part of the story.
  • It sits in many places. Forest, port, yard, mill and container, often with different people recording it.
  • It is committed before it ships. Stock promised to a buyer must be held back from other sales.

What to record for each lot

FieldWhy it matters
Supplier or sourceTraceability, and who to ask when a lot is disputed
Species and gradeDrives value and what you can sell it as
Girth and length, or thickness, width and lengthThe raw measurement the volume comes from
PiecesFor counting and for loading plans
Volume (CBM and CFT)Calculated, not retyped
LocationWhich yard, stack or container
StatusAvailable, reserved, in processing, shipped

Keep the raw measurement as well as the total. If a buyer later asks for the other volume convention, or a number is questioned, you can go back to the log or board.

Available, reserved and shipped

The most useful number in a yard is not total stock, it is what you can still promise. A good system separates:

  • On hand: physically in the yard.
  • Reserved: held for a buyer or consignment.
  • Available: on hand minus reserved.
  • Shipped: gone, and linked to the consignment it left on.

Without this split, two salespeople sell the same lot, or stock that has already been promised looks free.

Tracking through the mill

If you re-saw or process, the system should record the input lots, the output lots and the volume lost, and link them. Then you can work out yield by lot and by operator, and answer the question every mill owner asks: where did the wood go?

A mill treated as a black box gives you an opening stock and a closing stock and nothing to explain the difference.

Connecting stock to shipments

Stock that is not tied to a shipment cannot be proved. When a consignment is built from specific lots, the packing list, invoice and stock movement all come from the same records. After discharge you can compare what was loaded with what arrived. See how to reconcile a timber consignment.

Where spreadsheets and generic tools fail

  • Retyping. Tallies are written at the yard and typed in later. Every retype is a chance for an error.
  • One file, many editors. Two copies appear and nobody knows which one is right.
  • No history. You see today’s number but not who changed it or why.
  • No offline. Yards and ports have weak signal, so entries are delayed or batched from memory.
  • Volume by hand. Formulas are copied between files and quietly broken.

Counting and adjustments

Physical counts will not match the system exactly. The aim is not a perfect match, it is knowing why. Count on a schedule, compare with the system, and record each difference with a reason (measurement correction, damage, theft, mislabelled lot). A system that keeps the history of adjustments turns a worrying gap into an explained one.

Questions to ask a vendor

  1. Can I track by lot with my own measurements, and does volume calculate automatically?
  2. Does it separate available, reserved and shipped stock?
  3. Can it follow logs through processing and show yield?
  4. Does stock link to consignments and documents?
  5. Does it work offline in the yard, and sync without duplicates?
  6. Can different staff see only what they need?
  7. Can I export my data?
  8. What does it cost as stock and users grow?

For a wider list, see the 12-point buyer’s checklist.

A simple way to start

Do not move everything at once. Take one yard or one product line, enter its opening stock lot by lot, and run it in parallel with your spreadsheet for a month. Compare the two. If the system holds up, move the rest.

How LumberLinq handles it

LumberLinq tracks stock by lot and location, separates available from reserved stock, records sawmill processing with the output linked to its source lots, and links stock to consignments, documents and payments. Staff tally on a phone, offline if needed, and volume is calculated in CBM and CFT from the raw measurements. There is a free plan, so you can test it with real lots. Start free or request a demo.

Related: Free timber volume calculator · Timber tally sheet format and free template · Why timber exporters need a purpose-built system

lumber inventory management softwaretimber inventory softwarelumber yard softwaresawmill softwareinventory managementtimber stock tracking

Ready to simplify your timber ops?

Start free - no credit card required.