Key takeaways
- Distinguish outside cash from internal allocation.
- Keep both transfer sides.
- State whether refunds are included.
- Reconcile group totals with the whole practice.
What do dental collections measure?
Collections describe money received under a stated reporting scope. Net collections also reflect the refunds included in that scope. Before comparing totals, separate the receipt or refund of money from an entry that changes where an existing payment is assigned. A provider subtotal can move without a new dollar entering the practice.
Open Dental documents income transfers as offsetting positive and negative payment splits totaling zero. They change allocation without changing total practice income. Income transfer documentation.
Its refund instructions separately allow a negative payment. Refund documentation. These are product-specific distinctions to check against the office's actual records, not instructions to edit live accounts during a buyer review.
The immediate question is whether the amount called collections represents external cash activity, internal allocation activity or an unexplained mixture. Ask for the payment total and its splits together. Reviewing only positive rows can count a transfer as new income while losing the equal negative side.
Follow the cash before the provider subtotals
This invented file covers one period and one practice. Patients pay $24,000 and insurers pay $36,000. The practice refunds $2,000 during the same period. All those receipts and refunds have cleared, with no fees or settlement delays. No loan proceeds, owner contributions or other cash movements are included.
Before the refund, the $60,000 is allocated as $35,000 to group A and $25,000 to group B. The refund belongs to A. A separate internal transfer then moves $7,000 from A to B. The groups are reporting labels, not compensation rights or clinical classifications.
| Event | Group A | Group B | Whole practice |
|---|---|---|---|
| Receipts allocated before refund | $35,000 | $25,000 | $60,000 |
| Refund paid | −$2,000 | $0 | −$2,000 |
| Internal transfer | −$7,000 | +$7,000 | $0 |
| Net after all entries | $26,000 | $32,000 | $58,000 |
External net collections are $24,000 + $36,000 − $2,000 = $58,000. The provider-group view gives the same control total: $26,000 + $32,000. The transfer changes the split between groups, but it does not add to that total.
Adding only positive rows would count the $60,000 receipts and the $7,000 positive transfer, producing $67,000. It would omit both the $2,000 refund and the $7,000 negative transfer. The resulting $9,000 overstatement is fully explained by those missing entries. It is not evidence that the practice received more cash.
A review should retain both sides of each transfer and a link to its source payment. If one side is missing from the export, request the complete scope. Do not assume it belongs outside the practice merely because a filtered report does not show it.
Change allocation and cash separately
First, increase only the internal transfer to $9,000. A becomes $24,000 and B becomes $34,000 after the unchanged refund. Their sum stays $58,000. This tests whether a change in allocation incorrectly moves the practice total in your worksheet.
For a separate test, return to the $7,000 transfer and increase only the refund to $5,000. A becomes $23,000, B stays $32,000 and net collections fall to $55,000. The extra $3,000 actually leaves the practice under these assumptions, so the whole-practice result changes.
Neither test changes fees, procedures or the value of an account balance. They isolate two different events: reassignment of existing money and a cash refund. If a real discrepancy includes more events, add each with its date and evidence rather than forcing it into either example.
Use the total for the right next decision
A reconciled collections total is a starting point for further work. It does not establish profit, sustainable earnings or cash the buyer can use after closing. Costs and ownership of any collected receivables still need their own review. Likewise, an allocation to a clinician does not settle that person's compensation agreement.
Preserve the period, included locations and refund treatment. Save the original payment identifiers with the internal reconciliation. Give an unresolved item a responsible person and a specific request, such as the missing opposite split or refund evidence. A neat total should not hide a known gap.
Keep initial sale outreach seller-blind, omitting owner and practice identity, exact location and identifying financial or staff details. Require an NDA before authorized identifying disclosure. Plan staff participation around the payment records they must explain, and agree who briefs the wider team. Handle patient-level access separately through the approved privacy process.
The production and collections guide covers bank timing differences. The receivables sale guide addresses ownership at closing. Use reconciled figures in the buyer review or a DSO discussion.
Summary
Collections should distinguish external cash from internal allocation. In this invented file, the transfer changes group totals while practice net collections remain $58,000. A larger refund changes that total; a larger zero-sum transfer does not. Discuss the reporting evidence before relying on an unexplained number.
Frequently asked questions
Why are net collections $58,000 in the base case?
External receipts total $60,000 and the refund is $2,000. The separate $7,000 transfer has equal positive and negative sides, so it does not change that total.
What is wrong with adding only positive entries?
The example would count $67,000 while omitting the $2,000 refund and $7,000 negative transfer. That overstates net collections by $9,000.
What happens when only the transfer grows to $9,000?
The groups become $24,000 and $34,000. Whole-practice net collections remain $58,000 under the supplied assumptions.
Does the allocation decide a clinician’s pay?
No. The groups are reporting labels. The example does not establish compensation rights, ownership of receivables or cash available to a buyer.
Sources
Retrieval dates appear beside each source. Figures retain their stated observation years; retrieval does not make older data current.
- Open Dental income transfers · Retrieved
- Open Dental refunds · Retrieved