Skip to content

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 Querri

What 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

Open Querri →
1 Step 1:

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)
Querri One project
2 Step 2:

Build the four owner metrics for Q2 and Q3

Start with the four numbers capital partners ask for:

Prompt

"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.

Build the four owner metrics for Q2 and Q3
MetricQ2 2026Q3 2026
Occupancy92.89%92.97%
Revenue per occupied unit, monthly$6,336$6,353
NOI margin29.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.

3 Step 3:

Set finance's occupancy beside operations'

Then put the two occupancy figures side by side:

Prompt

"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.

Set finance's occupancy beside operations'
CommunityFinanceOperations
Ashby Commons94.64%96.47%
Kestrel Grove93.29%91.06%
Linden Hill95.58%98.31%
Harrowby House88.45%88.11%
All communities92.97%93.65%

Q3 2026 occupancy, finance against operations' weekly report.

4 Step 4:

Explain each difference between the two

Rebuild operations' figure from finance's, one definition at a time:

Prompt

"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.

Explain each difference between the two
DifferenceEffectRunning total
Finance: occupied units over units in service92.97%
Divide by all units, including out of service-0.7992.18%
Count residents, including second occupants+1.4093.58%
Count on Sundays only+0.0793.65%

From finance's Q3 occupancy to operations', all communities, in percentage points.

5 Step 5:

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:

Build the quarterly owner package
MetricQ3 2026Ties to
Occupancy92.97%Yardi resident records
Revenue per occupied unit$6,353Sage Intacct and Yardi
NOI margin28.2%Sage Intacct
A/R over 60 days$287,777Yardi 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 data
Querri for senior living finance See how Querri helps finance teams check care levels against every bill, explain each community's margin, and send an owner package that matches operations. See Querri for finance

See Querri for the whole operator

Tips 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.

Prompt

"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
Prompt

"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?
They count differently. Here finance counts occupied units over units in service every day; operations counts residents over all units each Sunday. Those three differences rebuild operations' Q3 figure exactly.
Which difference matters most?
Second occupants: counting residents instead of units adds 1.40 points. Units out of service take 0.79 points off, and counting on Sundays adds 0.07.
Does this reconcile the whole package?
It reconciles the occupancy difference in this sample. Revenue, margin and A/R come from the ledger and the aging report and are checked against those systems, not against operations' report.
Why does operations show more move-ins?
Its report counts transfers to memory care as move-ins. In Q3 that was three of its 34; Yardi shows 31 new move-ins.
What drove the rise in A/R over 60 days?
Long-term care insurance balances over 60 days went from $24,189 on June 30 to $106,135 on September 30. Private pay rose too. The aging by payer shows which to chase.
Why did margin slip when occupancy held?
Revenue per occupied unit rose slightly, so the change is on the cost side. The community margin playbook splits each community's gap.
Do I need connectors for Yardi or Sage Intacct?
No. Both come in as exports, with operations' report as an upload. Next quarter's files rebuild the package.
How often should this run?
Quarterly for the package, and monthly for the occupancy check so a new counting difference shows up early.