Combine PointClickCare® With Accounting and Payroll Data
Join clinical, financial and labor data on two keys and one period: the resident identity key and the property/entity key, reconciled to a single closed accounting period. Read census, acuity and documented care from the EHR; read posted revenue and expense from the general ledger; read worked, paid and agency hours from payroll and time. Land each read-only with lineage attached, map every field to a canonical entity, then reconcile before deriving anything: clinical census against billed census, documented care minutes against worked hours, and payroll cost against the GL within a written t…
On this page
The EHR, the ledger and payroll are read independently and joined only after each has been reconciled on its own terms.
The right-hand column is the part most integration projects skip. Every one of these conflicts is normal; the failure is resolving it silently.
The shared five-phase sequence from the pillar , with the reconciliation phase carrying the three ties described above.
Key points
- A read-only, reconciliation-first workflow for joining EHR census and acuity data to general-ledger and payroll data inside a governed operating record.
- Read census, acuity and documented care from the EHR, posted revenue and expense from the general ledger, and worked, paid and agency hours from payroll and time — all read-only. Join them on the resident identity key, the property or entity key and a single closed accounting period. Reconcile clinical census to billed census, documented care minutes to worked hours, and payroll cost to the GL wi…
- Neither wins automatically. Clinical census counts residents present; billing census counts residents billed, and the two legitimately differ around admissions, discharges, hospital leaves and billing cutoffs. Both values are retained, the difference is raised as a reconciliation item, and the operator declares which definition drives the published occupancy figure. When systems disagree, the ope…
- Interface access, permitted uses and any associated fees are governed by the operator’s own agreement with the vendor, and operators should confirm scope with the vendor and their counsel. SeniorCRE reads only what the operator is entitled to make available and does not represent any vendor’s commercial terms.
- No. The default posture is read one direction only; the EHR is left untouched and remains the operator’s clinical system of record until the operator decides otherwise. SeniorCRE also includes its own EHR and eMAR and can serve as the clinical system of record if an operator chooses that configuration, with exactly one authoritative MAR at all times.
- The four recurring failures are an ambiguous occupancy denominator, resident identity matched on name alone, care minutes compared against scheduled rather than worked hours, and derived per-resident-day metrics published before the GL tie passes. Each is a definition failure rather than a technical one, which is why definitions come first.
- Every admitted field carries its source system, source identifier, interface and extraction timestamp, and every published figure references the record version it was computed from. That is what allows a board number to be defended months later, including after a restatement.
https://seniorcre.com/senior-living-data-integration/pointclickcare-accounting-payroll