One paper sheet, one spreadsheet

A paper field book and a spreadsheet drift apart because they are updated at different moments, by different hands, with different assumptions. The fix is not to abandon one, but to decide which format is the source of truth for each kind of entry and how the other catches up.

What should live on paper and what should live in the spreadsheet?

Paper should hold anything written where the record is made: a paddock observation, a stock movement, a sketch of a gate or trough. Spreadsheets should hold anything you need to total, sort or hand to someone else: stock reconciliations, feed figures, unit registers.

A field note is fast and honest but hard to combine with last month's figures; a spreadsheet combines well but is clumsy in the rain. Beef+Lamb New Zealand's farm plan material makes the same point: the choice matters less than whether the plan stays a living document your team uses. Many farms already hold maps or information from councils or earlier workshops, so you are usually not starting from nothing.

So the split is not paper versus digital. It is quick capture versus working total.

How do I stop the two versions from telling different stories?

Give each entry one home and one backup direction.

• Every field observation goes to paper first, then to the spreadsheet in the same week.
• Every spreadsheet correction that changes a fact goes back to the paper margin, dated and initialled.
• Nothing gets deleted. A wrong line is struck through, not erased, so the change is visible.
• Each format carries the same identifiers for the same thing.

If the paper says "north block" and the spreadsheet says "Block 3", the two records are already two stories, even if the numbers match. Decide the naming system once and use it on both sides. Our guide on naming units so others can follow covers how to do that so a seasonal worker, a partner or an accountant can read the same label and find the same ground.

Which one wins when the paper and the spreadsheet disagree?

Decide this before it happens, not during a disagreement.

A workable rule: the paper field note wins on what was observed, and the spreadsheet wins on what was calculated. If the paper says a mob moved out on the fourteenth and the spreadsheet shows the fifteenth, the paper is probably right. If the spreadsheet totals a feed figure differently from a margin scribble, the spreadsheet is probably right, because the totals were built from a formula you can recheck.

This rule only works if the paper note carries enough detail to date and trust it: a date, a place, the observer's initials and enough plain words that someone who was not there can picture the scene. Our piece on dating and signing a field note walks through that minimum.

Disagreement type	Which record governs	Why
A date or time of an event	Paper field note	Written closest to the moment
A location on the farm	Base map, then paper note	The map fixes place, the note fixes the detail
A calculated total	Spreadsheet	Built by formula, recheckable
A stock class count	Spreadsheet, cross-checked against paper	Totals need reconciliation across classes
A name or unit label	Whichever holds the current register	One naming system, one authority

If you cannot decide who wins for a given kind of entry, that is a sign the entry does not belong in two places at all.

How do I reconcile the two records without retyping everything?

Reconcile on a rhythm, not in a panic. A weekly pass handles most farms: move the week's paper entries into the spreadsheet, mark the transfer done, and flag anything that did not transfer cleanly.

Enter the date as a field rather than in the middle of a sentence. Keep one row per event or per unit, so sorting later does not scramble attached information. Use the same column headings every season so an old sheet still makes sense. B+LNZ's farm data workbook shows the kind of instruction that works for this, including using a formula so a total recalculates when the inputs change, and using sort and filter to view one slice at a time.

A small, real warning from that same workbook: after sorting or filtering, the view can hide rows you still need. Always return the sheet to its full view before you decide anything, and check that the totals still match what the paper says.

What makes a spreadsheet row trustworthy a year later?

A trustworthy row is one you could explain to someone else without being in the room. That usually means it carries the date, the unit name, the source of the figure, and whether it was measured, estimated or carried over.

Three habits do most of the work here:

• Keep one row per recorded event, not one row per paddock with notes crammed into a cell.
• Keep the identifier columns, such as unit name and date, at the left so sorting does not separate them from their data.
• Never overwrite a figure without an adjacent note saying what changed and why.

This is close to the logic behind a resource chart, where each land management unit gets a description alongside its management notes rather than a bare label. Our guide on building a resource chart shows how that structure translates into a working sheet.

If you want a quick test of whether your sheet is trustworthy, try to re-total a single period from the raw rows alone. If you can, the sheet is probably sound. Our piece on totals that can be rechecked suggests how to set that up so the check is easy rather than painful.

How do I check the records against the ground?

Periodically walk the farm with the paper book and a printed spreadsheet extract to confirm what the records claim is actually there. This catches drift no internal tidying will find: a fence that moved, a track realigned, units that no longer match how the farm is run.

A base map is the anchor for that walk. It shows where things are relative to each other, and it makes mismatches visible in a way a list never does. Our guide on what a base map actually shows explains the minimum a working base map should carry, and checking a map against the ground describes how to run that comparison honestly.

Keep the walk short and specific. Pick a handful of entries, find them on the ground, and note any difference in the paper book the same day.

When should a season be closed off and archived?

Close a season when the figures for it are reconciled and you have stopped adding to them. Then archive deliberately rather than leaving everything in one growing file.

A simple archive set for one season usually includes:

• The paper field book or a scan of it, unedited.
• The spreadsheet as it stood at close, exported to a fixed format rather than left live.
• The base map version used that season, so the unit boundaries are recoverable.
• A one page note recording what changed during the season, such as units added or renamed.

Exporting to a fixed format matters. A spreadsheet that kept changing after the season ended is not an archive, it is a moving target. Our guide on archiving a season of records covers the practical shape of that set.

What should I fix first if the two have already drifted?

Start with names, not numbers. If the paper and the spreadsheet use different labels for the same ground, every figure attached to those labels is suspect until that is resolved. Fix the unit names, then rebuild the totals from the raw entries, then set a date for the first reconciliation pass.

Do not try to reconstruct a whole history at once. Take the current season, get it straight, and let older records stay as they are, clearly marked as pre-cleanup. A record that is honest about its own rough edges is more useful than one that pretends to be complete.