Dental AR Aging: Reconcile Credits and Age Buckets

Why can AR aging reports disagree?

Open Dental normally ages charges by charge date and applies credits to the oldest charges first. An optional setting can apply procedure-attached credits before aging. Its report has an As of Date control, but estimated write-offs use the current date even with a historical cutoff. Save the setup with the report. See aging logic and report settings.

Do not treat an older-bucket subtotal as self-explanatory. First establish whether two files contain the same charges and credits, use the same date and apply the same allocation rule. The worksheet below isolates allocation. It does not estimate collection chances or the value of receivables in a sale.

Worked example: same debt, different buckets

All inputs are invented. At the fixed cutoff, one charge is 80 days old and equals $500. A second charge is 20 days old and equals $200. A $150 credit adjustment is attached to the younger procedure. Both charges and the credit are posted by the cutoff. There are no other entries, interest, payment plans or insurance estimates.

Under the first supplied rule, apply the credit to the oldest charge. That leaves $350 on the older charge and $200 on the younger one. Under the second rule, apply the attached credit to the younger charge first. That leaves $500 older and $50 younger.

The older bucket differs by $150, while the total remains $550. No payment arrived and no new charge was added. The allocation rule explains this difference. It does not show that either balance is more likely to be paid.

Test amount and time separately

First, change only the supplied credit to $100. Oldest-first allocation gives $400 in the older bucket and $200 in the younger bucket. Applying the attached credit first gives $500 older and $100 younger. Both totals are $600. The older-bucket difference is now $100.

Next, reset to the $150 credit and move the cutoff 20 days later, with no intervening entries. The older charge is now 100 days old; the younger one is 40 days old. The amounts move into over-90 and 31–60 buckets, respectively. Oldest-first still gives $350 older and $200 younger. Attached-first still gives $500 older and $50 younger. Both totals remain $550.

Preserve a useful review trail

Keep the charge dates, credit links, cutoff and allocation settings together. Ask the report owner to reproduce the bridge from the original entries to each bucket. Do not change account records just to make competing reports match. Investigate the actual source of a difference and document any supported correction through the proper process.

For a sale, begin with seller-blind outreach and omit owner and practice identity, exact location, financials and staff details. Obtain an NDA before an authorized buyer receives identifying ledgers. Involve staff when their real reporting or transition duties require it. Share aggregate schedules first and review patient-data access separately.

Summary: explain the split before judging the balance

The base case preserves $550 under both allocation rules. Changing only the credit changes the total; moving only time changes the buckets. Keep those explanations separate when discussing the report.

Review receivables in a practice sale, production and collections, write-offs and fee schedules. The buyer guide and DSO overview address the wider transaction. Discuss the reconciliation.