Multi-location dental membership plans: reconcile the ledger

Your membership platform can say 1,400 active members and still be wrong in a way that matters to finance. At group scale, the real question is not whether the dashboard shows recurring revenue. It is whether the vendor, the PMS ledger, and the bank agree on who is active, what was collected, what was written off, and what the plan actually cost each location.

The short answer: an in house dental membership plan is only as good as the ledger behind it. If you run the plan across multiple offices, check four numbers every month per location. Compare active paid members in the membership platform to active members flagged in the PMS, membership fees posted in the PMS to deposits in the bank or GL, discount write-offs by adjustment type, and included-service production given away to members. If those do not tie out, the MRR in the dashboard is not the same thing as plan economics.

That sounds basic, but it is the part most plan software does not solve for a multi-location group. The vendor handles enrollment, billing, and the member-facing side. The PMS handles production and adjustments. Finance handles cash. The gap appears when those systems have to answer one question together.

What an in-house dental membership plan actually is

An in-house dental membership plan is a direct-to-patient subscription offered by a practice or group. The patient pays a recurring fee, preventive care is usually included, and other services may be discounted. It is not insurance. In many setups, the plan is presented as a membership or savings plan rather than a risk-transfer product, which is why many practices use ADA-style language and vendor compliance guidance when they describe it.

For a single office, that definition is usually enough. For a 5-50 location group, the plan becomes a financial system, not just a marketing offer. Once you add multiple PMS instances, regional fee differences, and different front-office workflows, the question changes from “Can we sell this?” to “Can we prove it is working?”

Three systems, three versions of the truth

Most groups are looking at three different records of the same plan.

• Membership platform: knows who enrolled, who paid, who lapsed, and what the vendor thinks recurring revenue is.
• PMS ledger: knows the patient account, posted adjustments, production, and whether the member is still flagged active inside the practice system.
• Bank or general ledger: knows what actually hit cash and when the deposits cleared.

Each system is useful, but none of them is complete on its own. The vendor may know a card failed yesterday, while the PMS still shows the patient as eligible. The PMS may show a discount adjustment, while finance classifies it as a generic courtesy write-off. The bank may show a deposit, while the platform has not yet recognized the fee because of timing or a processor hold.

The job of a finance lead is not to force all three systems to say the same thing in every field. It is to decide which numbers should reconcile every month and which ones are allowed to differ because they measure different things.

The four monthly reconciliations that matter

1. Active paid members

What it is: members who are current in the membership platform and should be receiving plan benefits.

Where it breaks: failed cards, canceled plans not marked inactive in the PMS, or manual overrides that keep a member flagged active after payment stopped.

How to detect it: pull a monthly list of active members from the vendor and compare it to active membership flags in the PMS by location. Then isolate accounts with no successful payment in the last billing cycle but still receiving member pricing or included preventive care.

The point is not only counting members. It is finding people who look active in one system and inactive in another, because those are the patients most likely to receive benefits without payment.

2. Membership fees posted versus deposits

What it is: the membership fees the PMS or accounting system shows as posted, versus what actually cleared the bank.

Where it breaks: processor timing, refunds, chargebacks, split deposits across locations, or revenue recorded in a central entity while collections flow through an office-level account.

How to detect it: compare the month’s membership fee postings in the PMS to the bank deposit total and the processor settlement report. The totals should match after timing differences are explained. If they do not, you need a specific reason, not a generic “pending reconciliation” note.

Groups often discover that the dashboard’s recurring revenue is directionally useful but not the same as collected cash. That distinction matters when the plan is being used to support staffing or offset hygiene capacity.

3. Discount write-offs by adjustment type

What it is: the value of discounts given to members when a procedure is billed below standard fee schedule.

Where it breaks: membership discounts get mixed with PPO contractual adjustments, courtesy adjustments, bad-debt write-offs, or provider discounts. Once that happens, nobody can tell whether the plan is generating strategic write-offs or just hiding general discounting.

How to detect it: create a distinct adjustment type in the PMS for membership-plan discounts and keep it separate from insurance write-offs and courtesy write-offs. Then review monthly adjustment totals by location. If a location has membership activity but no membership-specific adjustment code, the discount is probably being buried somewhere else.

This matters because a membership plan has a known price and a known discount structure. If the discount is not isolated, you cannot measure its cost or compare locations fairly.

4. Included-service production given to members

What it is: the preventive services and any other included care the member used at no additional charge under the plan.

Where it breaks: a member lapses in the vendor system but still receives covered hygiene, or the PMS still treats the patient as active because no one updated eligibility status at checkout.

How to detect it: compare the list of lapsed or failed-payment accounts in the vendor platform to preventive services posted in the PMS after lapse date. The question is not only whether the office provided care. It is whether the office provided care to a patient who should have lost benefit eligibility.

In a single practice, this kind of leakage may be small. Across many offices, it becomes a pattern. And once the pattern exists, it is hard to untangle after the fact because the revenue impact is spread across dozens or hundreds of appointments.

How to measure plan profitability per location

To see whether the plan is worth it, you need a per-location P&L, not just a company-wide member count. Keep the model simple enough that finance can run it every month.

A practical template looks like this:

• Membership fee revenue collected
• Minus processor and vendor fees
• Minus membership discount write-offs
• Minus the value of included services delivered to members
• Minus the chair time or production capacity you would otherwise have used for paying patients
• = Net plan contribution by location

That last line is the one owners care about. It answers a different question than MRR. MRR tells you how much recurring fee revenue the plan generated. Net contribution tells you whether the office made money after giving away benefits and discounts.

If you want a better comparison, measure the same cohort of patients before they joined the plan. Look at their production and visit pattern over the prior 12 months. Then compare it to the 12 months after enrollment. Use the same office, or at least the same region, so differences in payer mix or fee schedule do not distort the result. The point is to estimate whether the plan changed behavior enough to justify the included care and discounts.

Do not use a broad company average if one location has mostly preventive-heavy patients and another has more restorative work. That will hide the site-level economics that matter when you decide where to expand the plan and where to pause it.

How to read vendor claims without getting fooled by them

Vendors often publish impressive uplift numbers. A claim like “172% production lift” may be directionally useful, but it is usually a self-reported comparison. It can be true for the cohort they chose and still be misleading for your group.

Test the claim on your own data with a simple before-and-after cohort:

• Pick patients who enrolled in the plan during a fixed month or quarter.
• Measure their production in the 12 months before enrollment.
• Measure their production in the 12 months after enrollment.
• Separate by location, because office mix matters.
• Exclude patients who moved, changed insurers, or had unusual one-time treatment if you want a cleaner read.

Then ask one hard question: did the plan increase production, or did it mostly attract patients who were already likely to spend? Self-selection is a real issue. People who enroll in membership plans are often more price-sensitive and more likely to accept treatment when they see a known discount. That can help production. It can also make the uplift look better than the plan itself deserves.

What the platforms do well, and where they stop

Most dental membership plan software does a decent job at the member-facing workflow. It can enroll patients, run billing, send reminders, and present a clean compliance story. Some products also advertise PMS integration, and newer links can reduce manual work in Open Dental, Dentrix, Eaglesoft, or Denticon environments.

That is useful, but it is not the same as a finance-grade reporting layer. A platform that can sync enrollment status may still leave you with separate views of discounts, write-offs, and deposits. If you run one office, that gap may be manageable. If you run 20 offices on different versions of the PMS, it becomes a monthly close problem.

This is why the right question is not “Which plan software has the best dashboard?” It is “Which setup gives us one clean monthly truth at location level?” Sometimes the answer is better integration. Sometimes it is a reporting layer on top of the vendor and PMS data.

When a group should build the reporting layer

At some point, the simplest adequate answer is not another dashboard from the vendor. It is a read layer that combines the PMS, the membership platform, and the bank or general ledger into one reporting model.

That usually starts making sense when most of these are true:

• You have 10 or more locations.
• You run multiple PMS instances or versions.
• Your membership plan changes by region or office.
• Finance is closing the books with spreadsheets and manual exports.
• Leadership wants location-level profit, not just system-level enrollment metrics.

When those conditions show up, the cost of not reconciling usually grows faster than the cost of building the reporting layer. The build is not a replacement for the membership platform. It is the control surface that tells you whether the platform is doing its job.

That is the kind of layer Better has built for multi-location operators, including reporting and business operations across a large dental group. The Apex Dental Partners case study is a good example of the sort of cross-practice reporting problem groups run into once the number of locations gets large enough that spreadsheets stop being enough: Apex Dental Partners case study.

A practical monthly close for your finance lead

If you want to start this week, do not ask for a full system overhaul. Ask for one monthly report per location with four rows:

• Active paid members
• Membership fees collected and posted
• Membership discount write-offs
• Included preventive production delivered

Then add two checks. First, identify failed-payment members who still showed up as active in the PMS. Second, compare plan-enrolled patients’ production before and after enrollment using a fixed cohort window.

If the numbers tie out, you have a real operating model. If they do not, you have a data and process problem that will keep affecting revenue recognition, chair utilization, and location-level profit.

FAQ

Are in house dental plans worth it?

For a multi-location group, the plan is worth it only if the net contribution stays positive after discounts, included care, and operating overhead. The right test is a per-location P&L, not total member count. If the plan helps retention and fills hygiene chairs without giving away too much production, it can work. If not, the recurring fee revenue may hide real margin loss.

What is in house dental insurance?

It is usually a loose way of describing a membership plan, but it is not insurance. Insurance transfers risk and follows regulated insurance rules. An in-house membership plan is a direct arrangement between the practice and the patient for included preventive services and discounts. If you market it, use language that fits your state rules and the plan structure you actually offer.

How do membership discounts post in the PMS?

They should post as a distinct membership-plan adjustment type, separate from PPO contractual write-offs, courtesy adjustments, and bad-debt write-offs. If they are mixed together, you lose the ability to measure plan cost or compare locations consistently.

What happens when a member card fails?

In a clean process, the member is marked inactive in the vendor platform, the PMS eligibility flag is updated, and front-office staff are alerted before the next included visit. If the PMS still shows the patient as active, the office may continue giving plan benefits after payment has stopped. That is the exact leakage the monthly reconciliation should catch.