Where is each community's margin going: occupancy, labor or agency?
Set each community's NOI margin from Sage Intacct against the budget, with occupancy from Yardi and hours from Workday. See which gap is census and which is labor.
Open QuerriWhat you'll need
Querri (Free trial) to explain each community's margin against budget
Sage Intacct, the budget workbook, Yardi and Workday: Step 1 says what each adds
Your margin and labor definitions: so every community's gap is split the same way
Free resources
Start your free trial here →Sample data sets
Synthetic data for Tallowmere Senior Living, a made-up operator with four communities. Residents appear as codes only. Not real resident, family, staff or financial data.
Need help?
If you have any questions, you can request a demo or email our team.
Before we begin
The P&L by community shows that margin moved. Explaining why means pulling census from the resident system and hours from payroll, then lining them up against the budget, community by community. The ledger, the budget workbook, occupancy and labor all live in different places.
This playbook sets September's NOI margin against budget for every community, splits each gap into occupancy, rate and labor, and breaks care labor into hours, overtime and agency.
How it works:
- • Upload Sage Intacct, the budget, Yardi and Workday
- • Set each community's margin against budget
- • Split each gap into occupancy, rate and labor
- • Break care labor into hours, overtime and agency
- • Build the monthly margin review
Follow the steps
Upload Sage Intacct, the budget, Yardi and Workday
Four sources, one project:
- •
Sage Intacct (or your ledger): revenue and expenses by community and account.
- •
Budget workbook (Excel): the budget by account, plus budgeted census and hours.
- •
Yardi (or your resident system): occupied units and units in service, day by day.
- •
Workday (or your payroll): care hours by employee or agency, regular or overtime.
Each comes in as an export or upload; next month's files rebuild every view.
Tip: Bring hours from January, so you can see when a change started.
-
Sage Intacct GL actuals
-
Budget workbook (Excel)
-
Yardi occupancy
-
Workday hours
Set each community's margin against budget
Start with the number the regional review asks about:
"For September, set each community's NOI margin from the ledger against the budget workbook. Which communities are under, and by how much?"
The portfolio is 0.3 points under budget, which hides two different misses: Kestrel Grove 4.1 points under and Harrowby House 2.6 points under.
| Community | NOI margin | Budget |
|---|---|---|
| Kestrel Grove | 21.9% | 26.0% |
| Harrowby House | 26.0% | 28.5% |
| Linden Hill | 33.7% | 32.1% |
| Ashby Commons | 32.5% | 30.1% |
| All communities | 29.0% | 29.4% |
NOI margin against budget, September 2026.
Split each gap into occupancy, rate and labor
Then split each gap so the review starts in the right place:
"Split each community's September gap: how much is occupancy against budget, how much is rate, and how much is labor?"
Harrowby House's miss is occupancy: 87.1% against 93.0% budgeted, $47,342 of revenue. Kestrel Grove's occupancy is close to plan, and its labor is $28,155 over budget.
| Community | Occupancy effect | Labor against budget |
|---|---|---|
| Harrowby House | $47,342 under | $11,140 under |
| Kestrel Grove | $1,254 over | $28,155 over |
| Ashby Commons | $15,509 under | $6,199 under |
| Linden Hill | $2,391 over | $1,403 under |
September 2026 against budget. Occupancy effect: revenue from occupied units above or below budget. Labor: wages, benefits and agency against budget.
Break care labor into hours, overtime and agency
A labor gap can be hours, overtime or agency. Look at each:
"Break September care labor into hours, overtime and agency for each community, against budget. What share of care hours is agency, and how has that moved since January?"
Agency staff worked 17.8% of Kestrel Grove's care hours in September, up from 5.0% in January. Overtime stayed between 4.1% and 5.0% everywhere.
| Community | Agency | Overtime |
|---|---|---|
| Kestrel Grove | 17.8% | 4.1% |
| Linden Hill | 4.5% | 4.7% |
| Harrowby House | 4.1% | 5.0% |
| Ashby Commons | 3.9% | 5.0% |
Share of care hours, September 2026.
Build the monthly margin review
Four numbers for the regional review, and where each gap comes from.
The narrative Querri writes:
Two communities missed budget margin in September for different reasons: Harrowby House on occupancy and Kestrel Grove on labor, where agency hours rose.
What you can create or export:
- The table, to Excel, CSV or Google Sheets
- A live dashboard that refreshes when new exports land
- A presentation for the meeting, to PDF or PowerPoint
| Community | Margin against budget | Start with |
|---|---|---|
| Kestrel Grove | 4.1 points under | Agency hours |
| Harrowby House | 2.6 points under | Occupancy |
| Linden Hill | 1.6 points over | On track |
| Ashby Commons | 2.4 points over | On track |
September 2026 margin review.
Walk into the regional review knowing which gap is census and which is labor.
Try it on your own dataTips for a margin review people trust
Split revenue before you blame cost
A community short on census looks like a cost problem when margin is all you see. Separate occupancy from rate first.
Count agency by hours, not only dollars
Agency spend rises with rates too. The share of care hours shows whether more of the work moved to agency staff.
Teach Querri your rules once. Every answer after that follows them.
What counts as revenue and labor, how occupancy is counted, how a gap is split, which hours are agency: say each rule once and Querri applies it to every question on that data.
Show me how
Say it in chat
Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.
"Occupancy is occupied units divided by units in service, counted every day. Save that as a rule for the Yardi occupancy table."
Or bring the document that already says it
Upload your chart of accounts and close checklist like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:
- NOI margin: revenue minus operating expenses, over revenue
- Occupancy: occupied units over units in service, daily
- Occupancy effect: occupied units against budget, at budget revenue per unit
- Labor: wages, benefits and agency together
- Agency hours: contingent workers in Care Services
- Overtime: hours with the Overtime time type
- Concessions reduce revenue
"Read our chart of accounts and propose which accounts count as labor. I'll review them in the Inbox."
Where the rules reach
A rule is attached to the data, not to one person's chat, so it follows the data everywhere:
- • Every question asked in chat, by anyone on the finance team
- • Every view the Librarian builds on that data
- • Every step of a project, including the code it writes
- • Dashboards and scheduled runs, each time they refresh
- • Claude and ChatGPT, when they ask Querri
You stay in control
Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.
The payoff in the review
Each community's gap comes with its driver already split out. Changing how occupancy is counted is a sentence.
Frequently asked questions
What does the occupancy effect measure?
Why split the gap before looking at cost?
Is agency the cause of Kestrel Grove's miss?
Why look at overtime too?
What does an agency hour cost here?
Can communities ahead of budget still have a problem?
Do I need a connector for Sage Intacct or Workday?
How often should this run?
Other popular resources
Playbook
Care billing check
Did every community bill for the care it delivered last month?
Playbook
Owner package that ties to operations
Does the owner package match what operations reports?
Demo
Request a walkthrough
See Querri in action with your own data.
Pricing
Compare plans
Find the right plan for individuals, teams, or enterprise.