Skip to content

Did every community bill for the care it delivered last month?

Set each resident's care level in PointClickCare beside their bill in Yardi. See where the charge doesn't match the care level, before the month closes.

Open Querri

What you'll need

Querri (Free trial) to set care records beside every bill

PointClickCare, Yardi and your rate sheet: Step 1 says what each adds

Your care levels and fees: so every bill is checked against the same prices

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

A resident's care level changes in the care records, and the bill changes only when someone updates the charge. Before close, the business office lines up assessments, transfers and move-outs against the charge register by hand, community by community. The care level lives in PointClickCare, the charges in Yardi and the prices in a spreadsheet.

This playbook checks every assisted living and memory care resident's September bill against their care level and the rate sheet, and lists what to review.

How it works:

  • • Upload PointClickCare, Yardi and the rate sheet
  • • Check each care level against the September bill
  • • Find transfers at the old rate and charges after move-out
  • • See how often increases reach the first bill
  • • Build the month-end billing review

Follow the steps

Open Querri →
1 Step 1:

Upload PointClickCare, Yardi and the rate sheet

Three sources, one project:

  • •

    PointClickCare (or your care records): each resident's care level and when it took effect.

  • •

    Yardi (or your resident system): who lives where, the move-ins and move-outs, and every monthly charge.

  • •

    Rate sheet (Excel): rents and care-level fees by community.

Each comes in as an export or upload; drop in next month's files and every check rebuilds.

Tip: Bring nine months of charges, so you can see how long care-level changes take to reach the bill.

  • PointClickCare care levels
  • Yardi residents and charges
  • Rate sheet (Excel)
Querri One project
2 Step 2:

Check each care level against the September bill

Start with every assisted living resident's care charge:

Prompt

"Check every assisted living resident's care level in PointClickCare against the care charge on their September bill in Yardi, using our rate sheet."

Of 242 assisted living residents, 235 were billed for their care level. Five care charges were below the rate for the care level on file, $3,280 a month in all.

Check each care level against the September bill
ResultResidentsMonthly difference
Charge matches the care level235$0
Charge below the care level5$3,280
No assessment on file2Not priced

Assisted living residents in house on September 1, 2026, by result of the care level check.

3 Step 3:

Find transfers at the old rate and charges after move-out

Then look for the two cases a care-level check misses:

Prompt

"Now find residents who moved to memory care and are still billed at the assisted living rate, and September charges for anyone who had already moved out."

One resident who moved to memory care in July is still billed as assisted living, $1,235 a month under the memory care rate. One resident who moved out in August was charged $7,470 for September.

Find transfers at the old rate and charges after move-out
CommunityResidentsPotential monthly gap
Harrowby House4$3,290
Kestrel Grove2$1,225
Ashby Commons0$0
Linden Hill0$0

Potential gaps to review on the September bill, by community. Monthly amounts.

4 Step 4:

See how often increases reach the first bill

A gap at close usually started months earlier:

Prompt

"For every care level increase this year, did the higher fee show up on the first bill after it took effect? Show the share by community."

Across the portfolio, 47 of 55 care level increases this year reached the first bill. At Harrowby House it was 10 of 14, the lowest share.

See how often increases reach the first bill
CommunityIncreasesOn the first bill
Ashby Commons15100%
Linden Hill1090.0%
Kestrel Grove1681.3%
Harrowby House1471.4%

Care level increases effective January 1 to September 1, 2026, and whether the higher fee was on the first bill.

5 Step 5:

Build the month-end billing review

Four numbers for the close, and what the business office reviews.

The narrative Querri writes:

Six residents' September bills are below their care level or care setting, $4,515 a month in potential gaps to review, most of it at Harrowby House.

What you can create or export:

Build the month-end billing review
ExceptionResidentsNext step
Care charge below the care level5Review the charge
Memory care billed as assisted living1Review the rate
Charged after move-out1Review for credit
No assessment on file2Assess first

Exceptions for the business office, September 2026.

Close the month with the care-level changes already on the bill, not found next quarter.

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 a billing review people trust

Check transfers separately

A move to memory care is a new unit and a new rate. A care-level check only compares fees, so it won't catch a transfer still billed at the old rate.

Assess before you bill

A resident with no assessment on file can't be checked. List them on their own so the care team assesses first and billing follows.

Teach Querri your rules once. Every answer after that follows them.

Which care level is in effect, which fee goes with it, when a change reaches the bill, what counts as a transfer: 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

"A care level change takes effect on the bill from the first of the month on or after its effective date. Save that as a rule for the charge register."

Or bring the document that already says it

Upload your care and billing policy 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:

  • Care level: the latest assessment on or before the first of the month
  • Care fee: the rate sheet amount for the community and level
  • A change bills from the first of the month on or after it takes effect
  • Memory care residents pay the memory care rate, with no separate care fee
  • A transfer between care settings is not a move-out
  • Charges stop after the move-out date
  • No assessment on file means assess before billing
Prompt

"Read our care and billing policy and propose the rules it states about care levels and charges. 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 and the business office
  • • 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 at close

The business office starts the close with a short list of bills to review, not a spreadsheet to build. Changing a fee is a sentence.

Frequently asked questions

Does a gap mean the resident was under-billed?
Not on its own. The check compares the care records with the bill and the rate sheet. It lists potential gaps to review, $4,515 a month here; the business office confirms each one with the care team before changing a charge.
Why check transfers separately?
A move to memory care is a new unit and a new rate, so a fee check won't catch it. Here one resident who moved to memory care in July was still billed as assisted living, $1,235 a month under the memory care rate.
What about residents with no assessment?
They can't be priced, so they aren't counted in the dollar figures. Two residents at Harrowby House had none on file and are listed to assess first.
Why September charges after a move-out?
Charges should stop at the move-out date. One resident who moved out on August 26 was charged $7,470 for September, a potential credit to review.
When does a care level change reach the bill?
In this sample, the higher fee should appear on the first bill dated on or after the change's effective date. That rule is stated once and every check uses it.
Which community needs attention?
Harrowby House: four of the six potential gaps, $3,290 a month, and 10 of 14 increases on the first bill this year against 47 of 55 across the portfolio.
Do I need a connector for PointClickCare or Yardi?
No. Both come in as exports. Upload next month's files over the old ones and every check rebuilds.
How often should this run?
Monthly, before close, once the month's charges are posted. Running it each month keeps the list short.