Bionic Forms

Sawmill log and lumber inventory, with no internet

Last updated 4 November 2026.

Short answer: keep one list of logs on the yard, each with its tag number, and one list of what the saw produced. A view of logs not yet sawn is the yard count; lumber grouped by species and grade, with a total, is board feet on hand. It works on the office computer with no internet. Read where this is honest before you count on it.

On the Forestry Forum, a small mill owner posting as Kansas asked what “smaller to medium size sawmills use for their accounting”. Months later they came back with what they had settled on: “I have a part time bookkeeper that has set the log tag system up in excel.” Every month she ran a report of board feet in logs on hand and adjusted for what was cut, because “Theres no way we can try to measure and account for what lumber flows out of each individual log.” Another sawyer in the same thread had looked for a ready-made program: “Have not found a written program to just plug into.” (The thread, from 2007, read 4 November 2026.)

That is the honest shape of the job. Most small mills do not trace every board back to its log, and they do not need to. They need to know what is on the yard, what came off the saw this week, and what is stacked and sold.

How the lists fit together

ListWhat one row isPoints at
LogsOne log or one load: tag number, species, length, diameter or scaled board feet, weight if bought by the ton, bought from, date in, sawn yes or no
LumberOne stack or one tally: species, grade, thickness, width, length, piece count, board feet, dry state (green, air dried, kiln dried), where it sitsA log, if you want to say which
SalesOne sale: buyer, date, board feet or pieces, price, paidA lumber stack

The link from lumber to a log is there if you want it, not because you must fill it in. Leave it empty for pallet stock and mixed cuts, and use it for the walnut log a customer wants to see the boards from. Open that log and every stack cut from it is listed under it.

Board feet can be worked out for you. Describe it in a sentence, such as “when a lumber stack is saved, set board feet to thickness times width times length divided by 12, times the piece count”, and an automation fills it in on each save. Thickness and width go in inches, length in feet.

A database that lives on the office computer

Bionic Forms builds a small app from a spreadsheet or a sentence. Our desktop app for Windows, macOS or Linux keeps a full, encrypted copy on the computer, so a mill with poor signal can still:

When it finds a connection again, the changes go up by themselves, and a second person can open the same app from their own computer or a phone. Every change is kept with who made it and when (how history works).

Getting old records in

If the log tags already live in a spreadsheet, drop it on our home page. Each sheet comes in as its own list. Free covers unlimited apps and 10,000 entries per app; a mill tagging a thousand logs a year and tallying three thousand stacks fits for two years.

Where this is honest

Build it now. The box already says what this page is about. Change it if you like.

About 25 seconds. No signup to see the result.

Already keep a spreadsheet? Drop it on the home page instead.

Or open the live demo first. No email.

Rather not do it yourself? Tell us what you track and we will build a working version and show you. No fee.

More: firewood delivery records and tree service records, or printing a record.