ALCOA+ and Audit Trails: The Data Integrity Auditors Expect
Having lots of records is not the same as having credible records. The international yardstick auditors use for data credibility is called ALCOA+. Understand it once, and you'll see immediately why notebooks and Excel stop being enough.
ALCOA+ in farmer's language
| Principle | Meaning | The auditor's question |
|---|---|---|
| A — Attributable | Traceable to a person | "Who made this entry?" |
| L — Legible | Readable, clear | "Is that a 6 or an 8?" |
| C — Contemporaneous | Recorded when it happened | "Logged during the work, or filled in at month's end?" |
| O — Original | The first record, not a tidy rewrite | "Is this the original, or copied out neatly later?" |
| A — Accurate | True to reality | "Was this reading from a calibrated instrument?" |
The "+" adds four more: Complete, Consistent, Enduring, and Available — records must have no gaps, not contradict each other, survive 5–10 years, and be producible on request.
What an audit trail is
An audit trail is the record of the records: an automatic history of who created, changed, or deleted what, when, and why. The key rule: the original is never destroyed. A proper correction adds a new entry with a reason while the old value stays inspectable — the digital equivalent of a single strike-through with initials, never correction fluid.
Why notebooks and Excel start to fail
- Notebooks — hard to read (L), usually backfilled (C), no backup — one flood or lost book and it's gone (Enduring).
- Excel — any number can be silently changed with no trace (no audit trail), one shared file means nobody knows who typed what (A), and files corrupt or overwrite easily.
That doesn't make paper illegal — plenty of farms start there. But as the farm grows, with multiple workers and parallel batches, maintaining ALCOA+ by hand gets steadily more expensive, while a properly designed digital system gets ALCOA+ "for free": every entry tied to a user account, timestamped automatically, corrected append-only, and backed up off-site nightly.
One question to test any system: "If someone quietly changed yesterday's numbers, would you know?" If the answer is no, it doesn't have a real audit trail.
Continue: What is a batch record? · GACP software vs spreadsheets