Audit Trails and Lineage: Tracing Every Figure to Its Source Record

A board member asks why last quarter's occupancy changed between two reports. A lender asks how agency spend was calculated. A surveyor asks who changed a care record. In many organizations, each question starts an investigation that depends on who still remembers.

Lineage and audit trails make those answers routine. Lineage explains how a figure was built. The audit trail explains how the underlying records changed. Together they let an operator show its work.

SeniorCRE calls the governed record of that work the Operational Evidence Layer: a layer over existing systems where each figure carries an Evidence Card showing its sources, definition, reconciliation state and approvals. The concept matters more than the product name — any operator can begin capturing lineage with the steps below.

1. Step 1

   Decide which figures need lineage

   Start with figures that leave the building: owner, lender, board and regulatory reporting. Expand to internal dashboards later.

2. Step 2

   Record the build path

   For each figure, capture the source systems and records, the dictionary definition applied, the reconciliation it passed and the period it covers.

3. Step 3

   Collect audit logs from each system

   Bring view and change logs for governed fields into one reviewable record. Contracts should guarantee access to them.

4. Step 4

   Require a reason for changes

   Changes to governed values after close should carry a reason and an approver, not only a user and time.

5. Step 5

   Test traceability

   Each quarter, pick a reported figure at random and trace it to source records. Record how long it took against your target: [time placeholder].

• Lineage in a personal spreadsheet. When the analyst who built it leaves, the organization loses the ability to explain its own numbers.
• Logs nobody can read. Audit logs held only by the vendor, in formats the operator cannot query, are not a control.
• Changes without reasons. A log that records who and when but not why cannot answer the question auditors actually ask.

Next guide: Vendor Accountability: Contract Clauses, Data Portability and Integration Compatibility

Or return to the full data governance playbook for senior housing & care.