Acquisition-Day Data Integration for Senior Housing & Care
An acquisition is the moment an operator inherits someone else’s definitions. Handle it in four windows: in diligence, capture every source system and the seller’s written definitions — or record that none exist; on close day, freeze a dated pre-close baseline, take read-only custody of the clinical, payroll, billing and property systems, and leave the authoritative MAR exactly where it is; through the first close period, reconcile census to the unit inventory, payroll hours to the period, and revenue and expense to the general ledger, then restate the underwriting figures against…
On this page
Each window has a single objective. Attempting the next one before the current objective is met is how a portfolio acquires an unreconcilable first period.
The acquisition case adds one requirement to the standard mapping: every row carries an effective date, so pre-close and post-close periods stay comparable. See also the acquisition integration checklist .
Key points
- A four-window workflow for taking custody of an acquired portfolio’s operating data and producing a defensible first post-close reported period.
- Take read-only custody rather than attempting migration. Freeze a dated pre-close baseline of census, unit inventory, payroll period and open receivables; establish read-only access to the clinical, payroll, billing and property systems as they exist at close; leave the authoritative MAR where it is; map each property to one operating entity as of the close date; then reconcile the stub period to…
- Clinical continuity comes first, so the authoritative medication administration record should not move on close day. Any consolidation is a separate, sequenced decision made after the record is reconciled — govern first, replace only by choice, with exactly one authoritative MAR at every point in a transition.
- The variance is reported rather than absorbed. The underwritten figures are recomputed from the reconciled record, and the difference is presented to the investment committee with its lineage — which source, which definition, which period. That is usually a definitional difference rather than a performance surprise, and it is only visible if the definitions were captured in diligence.
- SeniorCRE does not publish an implementation duration. Timing depends on how many source systems survive the transaction, what interface access the operator’s agreements provide, and whether written definitions exist for the contested metrics. Any operator-specific sequence would be scoped in a briefing rather than asserted here.
- Permitted transfers, business-associate coverage and retention obligations are governed by the transaction documents and the operator’s agreements with each vendor, and should be confirmed with counsel. SeniorCRE reads only what the operator is entitled to make available and states no legal conclusion about a specific transaction.
- Yes, because the entity model carries effective dates. Each property maps to exactly one operating entity per effective date with prior structure retained as history, so staged acquisitions and mid-period transfers remain comparable instead of collapsing into a single ambiguous roll-up.
https://seniorcre.com/senior-living-data-integration/acquisition-day-integration