Senior living accounting software vs care platform: which system owns which number
Which numbers belong in your care platform and which in senior living accounting software, plus the reconciliation questions for multi-community CFOs.
Senior living finance leaders face a question that sounds simple: which system is the system of record for which number? Clear ownership and documented handoffs between the care platform and the financial system support a more efficient close, fewer manual steps in consolidation and a board view of margin by community.
This post maps where each type of number usually lives, sets out the reconciliations and checks that connect the two systems, and offers evaluation questions to take into any shortlist conversation.
Key takeaways
- As a starting map, the care platform holds resident records, census, care levels and often resident billing; the financial system holds the general ledger, accounts payable, consolidation across communities, budgets and management reporting.
- Much of the finance work in a multi-community operator sits in the handoffs: resident billing to the ledger, payroll to the ledger, and census and care levels to labor and margin analysis.
- Manual transfers, inconsistent mappings and spreadsheet consolidation can lengthen the close and delay the board’s view of margin by community.
- The most useful evaluation question is which system should own each number, and how the handoff between the two is reconciled.
What we’ll cover
What belongs in each system: a senior living accounting map
Use this as a starting allocation, then confirm it against the systems and modules in your own setup.
Care platform (the operational record):
- Resident records and admission data
- Census and occupancy by community and care level
- Care level assessments and level-of-care changes
- Resident billing and per diem charges, in many setups
- Clinical documentation and care plans
Financial system (the accounting record):
- General ledger (GL), including intercompany transactions and eliminations
- Accounts payable (AP) across all communities
- Payroll journals and labor cost allocation
- Budgets and forecasts by community, care level and cost center
- Consolidated financial statements and management reporting
- Audit trails and covenant reporting
The care platform tracks who is in each community, at what care level, and what they are being billed. The financial system closes the books, consolidates across entities and produces the numbers lenders and boards ask for. Resident billing can sit on either side: Nisbet Lodge, a nonprofit senior living community in Toronto, configured Sage Intacct to generate resident invoices, send them electronically and record electronic funds transfer payments. What matters is that each number has one owner and a documented route to the ledger.
The reconciliations and checks that connect them
Knowing which system owns which number is the first step. The second is understanding how data moves between the two systems and where each handoff needs checking. Review two accounting reconciliations and one operational check each month.
Resident billing to the ledger. Reconcile resident billing summaries to revenue postings in the GL, explaining credits, accruals, deferred revenue and cutoff differences under your accounting policies. The evaluation question: how does resident billing reach the ledger today, and who owns the exception when the two disagree?
Payroll to the ledger. Labor is typically the largest cost line in a senior living community. Reconcile payroll control totals and allocations to GL postings by cost center, community and care level. The evaluation question: how are payroll journals mapped to your chart of accounts, and how much time does that add to your close?
Census and care levels to labor and margin. This is an operational analysis: census drives staffing needs, and care level mix drives labor intensity. Validate census and care-level data first, then analyze staffing and margin using documented allocation methods, such as the weekly labor cost and occupancy numbers by community. The evaluation question: can you see margin by community and care level from the financial system, or does that analysis live in a spreadsheet?
What the symptoms look like when ownership is unclear
Finance leaders who inherit a setup where the care platform or spreadsheets carry finance work often recognize the same symptoms.
The close stretches. When resident billing, payroll and AP all need manual reconciliation before the books can close, the close gets longer. For a multi-community operator with lender covenants and investor reporting, a late close can put reporting deadlines at risk.
Consolidation is manual. Combining the financials for five, ten or twenty communities from separate ledgers or care-platform exports is spreadsheet work: slow, open to error and harder with every community added.
The board view lags. Without a link between census, labor expense and margin, the board sees per-community performance later than it could. Overtime drift, occupancy changes and care level mix shifts can surface after the chance to adjust has passed.
Audit preparation takes longer. When supporting documents are spread across a care platform, a payroll system and spreadsheets, assembling them for auditors is a manual project. At Nisbet Lodge, CFO Dennis Donovan estimates that giving auditors self-service access to supporting documents in Sage Intacct saves him 40 or more hours during each audit cycle.
Why multi-community operators feel this most
A single-community operator can manage a surprising amount in a care platform or a basic general ledger. Growth changes that, because each community can bring its own entity, payer mix and labor market.
Consolidation is usually the pressure point. Consolidated financials across several entities, with intercompany eliminations, entity-level margin and covenant reporting, call for a financial system built for multi-entity work, so evaluate consolidation against your own entity structure.
Acquisitions add to it. When an operator adds a community, finance needs to map a new chart of accounts, bring the community into the first month-end close and give lenders consolidated numbers on their timetable.
Skilled nursing operators face the same question, with their own reimbursement and operating model. Hickory Creek Healthcare Foundation, which operates 16 skilled nursing homes in Indiana and Ohio, had relied on a decades-old clinical and financial system built around electronic medical records. After moving its finance to Sage Intacct, it shortened its monthly close by three to five days.
Evaluation questions for the CFO
Before you evaluate any software, work through these questions about your current setup. They can help you assess whether system ownership is behind the problems you see, and they sharpen any shortlist conversation.
- Close and consolidation. How many days does your close take, and how much of that is manual reconciliation between the care platform and the ledger? Can you produce consolidated financials across all communities without a spreadsheet?
- Resident billing to revenue. Where does resident billing originate, how does it reach the GL, and who owns the exception when the two disagree?
- Census and labor. Can you see margin by community and care level? If not, where does that analysis live, and how current is it when the board sees it?
- Audit readiness. For the audits that apply to your organization, how quickly can you assemble the supporting evidence, and is it held in one system or several?
- Growth. If you added a community next quarter, what would it take to bring it into your close and consolidation?
Ask vendors to demonstrate consolidation, eliminations and reporting for your entity structure with your own data. To see how Sage supports operators like yours, explore our nursing home accounting software.
Frequently asked questions
What is the difference between a care platform and senior living accounting software?
A care platform manages resident records, census, care levels and, in many setups, resident billing: the operational data of running a community. Senior living accounting software manages the general ledger, accounts payable, multi-entity consolidation, budgets and management reporting. Many operators use both, so the question is which system owns which number.
Can a care platform handle multi-community financial consolidation?
Capabilities vary by product and implementation, so test it against your entity structure. Ask any vendor to demonstrate consolidation across your legal entities, intercompany eliminations, adjustments and the audit trail with your own reporting requirements.
What reconciliations should a senior living CFO review each month?
Resident billing to revenue postings in the general ledger, and payroll control totals to ledger postings by community and cost center. Alongside them, validate census and care-level data before using it to analyze labor cost and margin. For each, ask how the handoff works today and who owns the exception.
How does multi-community consolidation work in senior living accounting software?
A financial system built for multi-entity work typically consolidates the communities’ ledgers, records intercompany eliminations as journal entries and keeps an audit trail of adjustments. Ask vendors to show this with your entities and reporting requirements, and confirm what adding a new community involves.
What metrics should senior living finance leaders track by community?
Common ones include revenue per occupied room (RevPOR), margin by community and care level, labor cost as a percentage of revenue, occupancy rate and days sales outstanding on resident billing. Agree the definition, source system and owner for each before it goes into board reporting.
Start with one question: which system owns which number in your setup, and how is the handoff between them reconciled today?
Browse more topics from this article
Explore more wisdom
Dental practice KPIs for multi-location groups: a scorecard by location
Build a dental KPI scorecard by location: production, collections, overhead and staffing cost, which system each number comes from, and who owns each.
