Why most NZ sawmills outgrow Excel for inventory management

Excel is a brilliant tool. It runs most of the world’s businesses and probably a good chunk of NZ’s sawmills too. For a small operation processing a few thousand cubic metres a year with a handful of species and treatment classes, a well-maintained spreadsheet can track inventory adequately.

The problems start when the spreadsheet stays the same but the operation grows. More packs, more species combinations, more treatment classes, more customers, more dispatches, more staff touching the data. At some point the spreadsheet becomes the bottleneck rather than the solution. Recognising when that point has arrived is the hard part, because the shift is gradual. Each individual problem seems manageable. The compound effect is what costs real money.

Here are five signs the spreadsheet has become the problem.

1. Your stocktake variance is growing

You run a physical stocktake and the count doesn’t match your spreadsheet. That’s expected to some degree. But if the gap is widening each time you count, something systemic is wrong.

The usual cause: data entry lag. Packs get created but don’t get entered into the spreadsheet until later. Packs get dispatched but the spreadsheet doesn’t get updated until the end of the week. Packs get moved and nobody records it at all. Each delay introduces a window where the spreadsheet’s version of reality diverges from the yard’s version.

At a variance rate of 5%, a mill holding 2,000 packs at an average of $200/m3 and 1.5 m3/pack has $30,000 worth of inventory that exists in the spreadsheet but not in the yard, or vice versa. That’s real money sitting in an information gap.

2. Dispatch errors are costing you customers

A customer orders 50 packs of SG8 H3.2 90x45 at 4.8m. Your dispatch team pulls packs based on the spreadsheet, loads the truck, and sends it off. The customer receives the delivery and finds 3 packs of H3.1 mixed in with the H3.2. Or 5 packs that are 3.6m instead of 4.8m. Or a pack of SG6 that somehow ended up in the SG8 row.

In a spreadsheet system, the connection between the digital record and the physical pack relies on human verification at every step. Someone has to check the pack label, confirm it matches the order, and load the right packs. At volume, errors are inevitable because the verification is manual.

The cost is more than the replacement freight. A dispatch error to a commercial customer erodes trust. Two errors and they’re looking for another supplier.

3. Treatment tracking is a compliance risk

NZ Building Code clause B2 requires that timber used in construction meets specific treatment requirements. If your mill dispatches timber with the wrong treatment class for the application, the liability sits with you.

In a spreadsheet, treatment class is typically a text field in a row. There’s no system-level validation that prevents someone from entering “H3.2” when the pack is actually H3.1. There’s no alert when a dispatch order pulls an untreated pack for a job that requires H1.2. The compliance check is entirely manual and depends on whoever is doing the dispatch getting it right every time.

For mills handling multiple treatment classes and preservative types, this becomes increasingly precarious as volume grows.

4. You spend more time managing the spreadsheet than the yard

When the spreadsheet is the inventory system, someone has to maintain it. That means entering new packs, recording movements, updating dispatch records, correcting errors found during stocktakes, and building reports for management and accountants.

In a small operation, this might take a few hours a week. In a medium mill processing 10,000+ m3/year, spreadsheet maintenance can consume a full-time role. That person isn’t adding value to the operation. They’re translating reality into a spreadsheet format and fixing the gaps that accumulate between the two.

The question to ask: if the spreadsheet disappeared tomorrow, what would replace it? If the answer is “we’d need to walk the yard and count everything,” the spreadsheet is a single point of failure for your inventory knowledge.

5. You can’t answer basic questions quickly

How much H3.2 90x45 SG8 do you have in stock right now? Not approximately. Exactly. If the answer requires opening the spreadsheet, applying filters, cross-referencing against recent dispatches that might not be entered yet, and adding a disclaimer that the number could be out by a few packs, you’ve outgrown the spreadsheet.

Customers asking “do you have X in stock?” need a fast, accurate answer. Your accountant asking “what’s the inventory value at balance date?” needs a defensible number. Your operations manager asking “which packs have been sitting in the yard longer than 90 days?” needs data you can act on. A spreadsheet can theoretically answer all these questions, but the accuracy degrades in direct proportion to the complexity of the question and the lag in data entry.

What a sawmill inventory system actually needs

If you’ve recognised the signs above and you’re evaluating alternatives to the spreadsheet, here’s what matters for NZ timber operations specifically. Generic warehouse management systems and retail inventory software won’t cover these.

Pack-level tracking

The fundamental unit of timber inventory is the pack. Not a SKU, not a product category, not a bin location. An individual pack with its own barcode, species, grade, treatment class, preservative type, dimensions, piece count, volume, creation date, location history, and current status.

Your system needs to track each pack as a unique entity through its entire lifecycle: creation, movement, treatment, drying, storage, sale, dispatch, and (sometimes) return. This is fundamentally different from a retail system that tracks quantities of interchangeable items.

NZ-specific measurement and grading

The system must work in cubic metres and metric dimensions. It needs to understand NZ structural grades (SG6/8/10/12), NZ treatment hazard classes (H1.2 through H5), NZ timber species, and NZ-standard pack dimensions. Systems built for the US or Canadian market use board feet, Doyle scale, #1/#2 Common grades, and SPF species groups. None of this translates to NZ operations.

Barcode scanning integration

Scanning at pack creation, movement, and dispatch should feed directly into the inventory database. If your “inventory system” requires someone to scan a pack and then manually enter the data into a separate application, you’ve replaced the spreadsheet with a spreadsheet with extra steps.

Offline operation

NZ sawmills are often in areas with limited connectivity. Your system needs to work when the internet doesn’t. That means offline-first mobile applications on the scanning devices, with automatic sync when connectivity returns.

Dispatch and docket generation

Creating a dispatch, attaching packs to it, generating a docket PDF, and automatically updating inventory status (in stock to dispatched) should be a single workflow. In a spreadsheet, each of these steps is a separate manual process with its own error rate. See how a purpose-built dispatch system handles this.

Reporting and export

Inventory reports by species, grade, treatment, location, and status. Pack history reports. Dispatch summaries. Stocktake variance reports. Data export for your accountant. All of these should be generated from the live data, not built manually in a second spreadsheet.

The transition

Moving from a spreadsheet to a dedicated system is a process, not an event. The practical path for most mills:

Start with an initial stocktake to establish a baseline. Enter your current inventory into the new system pack by pack (this is the most labour-intensive step, but it only happens once). Begin scanning new packs as they’re created. Progressively migrate operations (movements, dispatches, stocktakes) to the new system over a few weeks. Retire the spreadsheet once you’re confident the new system is the reliable source of truth.

The biggest risk in the transition is running the old and new systems in parallel for too long. Dual entry creates its own errors. Commit to a cutover date and stick to it.

The real question

The decision to move from Excel to a purpose-built system comes down to one calculation: is the cost of the system less than the cost of the errors the spreadsheet causes?

For most mills processing more than a few thousand cubic metres per year, the answer becomes obvious once you add up dispatch errors, stocktake labour, treatment compliance risk, the salary of the person maintaining the spreadsheet, and the revenue lost from being unable to quickly confirm stock availability to customers.

If you’re at the point where the spreadsheet is creating more problems than it solves, that’s the signal. The tools exist. The question is whether you’re ready to make the switch.