How do senior housing & care operators reconcile conflicting data?
Direct answer
By replacing monthly manual investigation with a standing reconciliation process: one definition per metric, a named authoritative source, a deterministic precedence rule, a variance tolerance, and an escalation path whose rulings are recorded. Reconciliation done this way produces a governed value instead of a debate.
The spreadsheet is the symptom
In most portfolios the true reconciliation engine is a workbook maintained by one or two people in finance. It works, and it is the single largest undocumented dependency in the operating model. When those people are unavailable, the close slows and the numbers become contestable.
The goal is not to remove the judgment in that workbook. It is to move the judgment into a written rule that anyone can inspect and that a system can apply consistently.
A standing reconciliation process
The same four-step pattern applies to census, labor hours, revenue, and care minutes.
- 01Align the period and the measurement moment across sources before comparing anything.
- 02Apply the written precedence rule to produce a candidate governed value.
- 03Compare the candidate to each source and record the variance, not just the winner.
- 04Escalate only variances outside tolerance, and record the ruling with the value.
What finance gets from it
The output is a figure with its own audit trail: the sources considered, the rule applied, the variance accepted, and the person who ruled where a ruling was needed. That is what makes a number defensible to a board, a lender, or a diligence team without reassembling the analysis from scratch.
Read the full argument
Who decides which number the business accepts when two systems disagree.
The Operator Authority Chain™Related questions
If this is the question your operating committee is arguing about, the briefing walks through how the governed record is defined, ruled, and recorded.
Explore the Operating Record