Does the owner package match what operations reports?
Build occupancy, rate, NOI margin and resident A/R from Yardi and Sage Intacct, then set finance's occupancy beside operations' weekly report and explain the difference.
Open QuerriWhat you'll need
Querri (Free trial) to build the owner package and reconcile it
Yardi, Sage Intacct and the weekly census report: Step 1 says what each adds
Your occupancy definition: so finance and operations count 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
Every quarter the owner package goes out with occupancy, rate, margin and receivables. Then a capital partner sets it beside the operations report, the occupancy doesn't match, and the questions start. Finance counts from the resident system and the ledger; operations counts from its own weekly report.
This playbook builds the four owner metrics for Q2 and Q3, sets finance's occupancy beside operations', and shows exactly which counting differences explain the gap.
How it works:
- • Upload Yardi, Sage Intacct and the census report
- • Build the four owner metrics for Q2 and Q3
- • Set finance's occupancy beside operations'
- • Explain each difference between the two
- • Build the quarterly owner package
Follow the steps
Upload Yardi, Sage Intacct and the census report
Three sources, one project:
- •
Yardi (or your resident system): occupancy by day, residents, and the aging report by payer.
- •
Sage Intacct (or your ledger): revenue and expenses by community.
- •
Operations' weekly census report (Excel): residents in house and move-ins, each Sunday.
Each comes in as an export or upload; next quarter's files rebuild the package.
Tip: Bring two quarters, so the package shows the change, not just the level.
-
Yardi occupancy and aging
-
Sage Intacct GL actuals
-
Weekly census report (Excel)
Build the four owner metrics for Q2 and Q3
Start with the four numbers capital partners ask for:
"Build occupancy, revenue per occupied unit, NOI margin and resident A/R over 60 days for Q2 and Q3, with A/R by payer."
Occupancy and rate held. Resident A/R over 60 days rose from $163,341 to $287,777, and long-term care insurance balances drove most of the rise.
| Metric | Q2 2026 | Q3 2026 |
|---|---|---|
| Occupancy | 92.89% | 92.97% |
| Revenue per occupied unit, monthly | $6,336 | $6,353 |
| NOI margin | 29.4% | 28.2% |
| Resident A/R over 60 days | $163,341 | $287,777 |
Owner metrics, all communities. A/R over 60 days at the quarter's last day.
Set finance's occupancy beside operations'
Then put the two occupancy figures side by side:
"Set finance's occupancy for Q2 and Q3 beside the occupancy in operations' weekly census report, by community."
Operations reported 93.65% for Q3 and finance 92.97%. The gap runs both ways: Linden Hill is 2.73 points higher in operations' report, Kestrel Grove 2.23 points lower.
| Community | Finance | Operations |
|---|---|---|
| Ashby Commons | 94.64% | 96.47% |
| Kestrel Grove | 93.29% | 91.06% |
| Linden Hill | 95.58% | 98.31% |
| Harrowby House | 88.45% | 88.11% |
| All communities | 92.97% | 93.65% |
Q3 2026 occupancy, finance against operations' weekly report.
Explain each difference between the two
Rebuild operations' figure from finance's, one definition at a time:
"Explain the gap for Q3: rebuild operations' number from Yardi one definition at a time and show what each is worth. Do the same for move-ins."
Three counting differences rebuild operations' 93.65% from finance's 92.97% exactly. Second occupants add the most. Operations' three extra move-ins are transfers to memory care.
| Difference | Effect | Running total |
|---|---|---|
| Finance: occupied units over units in service | 92.97% | |
| Divide by all units, including out of service | -0.79 | 92.18% |
| Count residents, including second occupants | +1.40 | 93.58% |
| Count on Sundays only | +0.07 | 93.65% |
From finance's Q3 occupancy to operations', all communities, in percentage points.
Build the quarterly owner package
Four numbers for capital partners, each tied to its system.
The narrative Querri writes:
Occupancy and rate held in Q3 while NOI margin fell from 29.4% to 28.2% and resident A/R over 60 days rose, led by long-term care insurance.
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
| Metric | Q3 2026 | Ties to |
|---|---|---|
| Occupancy | 92.97% | Yardi resident records |
| Revenue per occupied unit | $6,353 | Sage Intacct and Yardi |
| NOI margin | 28.2% | Sage Intacct |
| A/R over 60 days | $287,777 | Yardi aging by payer |
Q3 2026 owner package.
Send the package with the occupancy reconciliation already in it, before anyone asks.
Try it on your own dataTips for an owner package people trust
Say how occupancy is counted
Units or residents, units in service or all units, every day or each Sunday. Each choice moves the number; state it next to the figure.
Keep the same code from quarter to quarter
A saved report re-runs the same calculation, so last quarter's figure doesn't quietly change when this quarter's goes out.
Teach Querri your rules once. Every answer after that follows them.
How occupancy is counted, what a move-in is, how A/R is aged, which accounts make NOI: 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. A second occupant is not a unit. Save that as a rule for the Yardi occupancy table."
Or bring the document that already says it
Upload your investor reporting definitions 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:
- Occupancy: occupied units over units in service, daily
- Second occupants count as residents, not units
- A transfer between care settings is not a move-in
- Revenue per occupied unit: revenue over average occupied units, monthly
- NOI margin: revenue minus operating expenses, over revenue
- A/R over 60 days: 61 to 90 days plus over 90
"Read our investor reporting definitions and propose the rules they state about occupancy and receivables. 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 with capital partners
Finance and operations agree on the number, and the package says why. Changing a definition is a sentence.
Frequently asked questions
Why do finance and operations report different occupancy?
Which difference matters most?
Does this reconcile the whole package?
Why does operations show more move-ins?
What drove the rise in A/R over 60 days?
Why did margin slip when occupancy held?
Do I need connectors for Yardi or Sage Intacct?
How often should this run?
Other popular resources
Playbook
Community margin against budget
Where is each community's margin going: occupancy, labor or agency?
Playbook
Care billing check
Did every community bill for the care it delivered last month?
Demo
Request a walkthrough
See Querri in action with your own data.
Pricing
Compare plans
Find the right plan for individuals, teams, or enterprise.