Append-only: why a good cellar book forgets nothing
Correction by reversing entry instead of an eraser — what audit-proof record keeping means in practice and what a wine inspection wants to see.
In a spreadsheet you correct a transposed figure by overwriting it. In a cellar book you cannot — and that is not harassment, it is the whole point of the exercise.
What “append-only” means
Append-only means: entries are only added, never changed and never deleted. A wrong entry is not corrected but cancelled by a reversing entry — and then entered again correctly. In the end there are three lines where there was one, and that is exactly what is wanted: the stock is right, and the way it got there can be followed.
The difference only shows up at an inspection. A corrected spreadsheet always looks as though it had been right all along. A cellar book with a reversing entry shows that a mistake happened and was put right — and when.
What wine record keeping requires
Wine records are not accounting in the fiscal sense but a record of quantities: what came in, what went out, what happened in the cellar. They have to be kept promptly — every treatment, every blend, every bottling, every disposal.
The relevant operations are always the same:
- Intake — grape delivery with quantity, variety, origin and must weight.
- Oenological practices — enrichment, acidification, de-acidification, fining, all with date and quantity.
- Blends — which batch went into which, and in what proportion.
- Transfers — from tank to tank, from barrel to barrel.
- Disposals — bottling, sale as bulk wine, losses.
The batch history is the real value
The reason everything has to be entered without gaps is not the inspection. It is traceability. If something is noticed about a batch, it has to be possible to follow it in both directions: which earlier stages did it come out of — and which bottlings did it go into?
Anyone who blends knows how quickly that gets out of hand. Three base wines in two blends, one of those blended again, then bottled in two formats — that is already six links, and they cannot be shown cleanly on one sheet of paper. A book kept append-only can resolve that chain in both directions at any time, because no intermediate stage was ever deleted.
Why a spreadsheet fails at it
Not because spreadsheets are bad. Because a spreadsheet has no history. A cell has exactly one value — the current one. Overwrite it and the previous one is gone, and nobody can say later whether anything else ever stood there.
Then there is the practical side: two people cannot enter at the same time, formulas break when rows are inserted, and the connection between the cellar book and the stock declaration consists of retyping. An inspection that wants to see a particular entry gets a spreadsheet to scroll through.
What an inspection actually wants to see
In practice it usually comes down to three things:
- Is the stock right? Calculated stock against actual stock, per vessel.
- Can the path be followed? For any bottling: where did the wine come from?
- Does it match the declarations? Do the harvest, production and stock declarations agree with what the book says?
The third question is the one where keeping data in two places comes apart. Whoever keeps the cellar book in one system and adds up the declarations in another has two truths — and has to hope they agree.
The quiet state
The most comfortable way of dealing with audit-proof records is the one in which you do not think about it. You enter the racking where you are standing — in the cellar, at the vessel, even without a connection. The entry is unalterable, the batch history grows with it, and the stock declaration due on 31 July calculates itself from what is already there.
Having forgotten nothing because there was nothing to add later — that is the difference between a cellar book you keep and one that comes about.