To reconcile dental production vs collections, separate three events: recording services, adjusting the amount due, and receiving money. Reconcile those events through the patient ledger and cash records for a defined period. Then calculate collections attributable to a specific group of services separately. This month's receipts may pay for earlier work or future care, so dividing them by this month's production does not measure how much of that production was collected.
Start with the exact reports and definitions your financial lead can reproduce. A familiar report title such as “net production” is insufficient if no one knows which adjustments or dates it includes.
Put a date rule beside every amount
The ADA distinguishes production at the office's full fees, adjusted billable production, and the money actually collected. Those definitions provide a starting vocabulary; your reconciliation still needs explicit posting and allocation rules. ADA definitions of production and collections
Create a small report dictionary:
| Amount | Definition to settle |
|---|---|
| Gross production | Recorded services valued at the applicable full fees; specify service-date or posting-date selection |
| Production adjustments | Named reductions and corrections, with their transaction dates and affected services |
| Net production | Gross production less the defined production adjustments |
| Period receipts | Money received during the selected period, with refunds and reversals shown separately |
| Applied payments | Receipts allocated to identified ledger balances, possibly from another receipt period |
| Accounts receivable | Open balances at a stated cutoff, with credits and unapplied funds separately visible |
Keep contractual reductions, courtesy adjustments, service corrections, and uncollectible balances distinguishable. They explain different events. An approved reduction in the charge is different from failure to collect an amount previously expected.
Confirm the full-fee baseline through the controlled dental fee schedule. A fee-master change can move gross production even when service counts are unchanged.
Work from the opening balance to the closing balance
Use a ledger roll-forward before interpreting percentages. In general, opening receivables plus charges, less applicable reductions and applied payments, plus or minus other documented movements, should reproduce closing receivables.
The following month is entirely hypothetical. All $24,000 of production reductions relate to services recorded this month. The $1,000 older-balance write-off is separately authorized. There are no refunds, reversals, transfers, beginning unapplied funds, or other movements in this example.
| Receivables movement | Amount |
|---|---|
| Opening accounts receivable | $60,000 |
| Gross production recorded this month | +$120,000 |
| Contractual production reductions | −$24,000 |
| Payments applied to balances | −$92,000 |
| Write-off of an older balance | −$1,000 |
| Closing accounts receivable | $63,000 |
Check the bridge: $60,000 + $120,000 − $24,000 − $92,000 − $1,000 = $63,000.
Net production for the month is $120,000 − $24,000 = $96,000. The separate older-balance write-off explains receivables movement; it does not reduce this month's service cohort.
Now trace the $92,000 of applied payments. Assume $52,000 paid older balances and $40,000 paid this month's services. The older receivables remaining are $7,000 after the write-off, while $56,000 remains from this month's services. Together, those balances reproduce $63,000.
An unexplained difference belongs in a reconciliation exception, with its supporting transaction and reviewer. Do not create a miscellaneous adjustment merely to force agreement.
Reconcile receipts to deposits separately
Suppose the same fictional month brought in $98,000 of cash receipts. Of that, $92,000 was applied as shown above, and $6,000 remained as unapplied advance payments. Those advances explain why total receipts exceed payments used in the receivables bridge.
In actual reports, check whether unapplied funds and patient credits are already netted against receivables. If they are, adapt the bridge and avoid subtracting them twice. Keep their gross balances visible for review.
Match receipts to processor settlements and bank deposits. Differences can arise from settlement timing, fees deducted before deposit, returned payments, refunds, or posting errors. Match individual batches where possible and list deposits still in transit at the cutoff. Identify nonpatient inflows, such as an owner contribution, so they do not become dental collections.
The IRS explains that cash and accrual methods recognize income at different times. That distinction is another reason a production report is not automatically the practice's accounting revenue. Have the CPA reconcile management reporting to the actual accounting basis. IRS explanation of accounting methods
Ask a different question with a production cohort
A production cohort is a defined set of services, such as services completed in May. To measure its collection progress, follow payments allocated to those services through a stated later cutoff.
For the fictional month:
- Period receipts divided by current net production are
$98,000 ÷ $96,000 = 102.1%, rounded. - Collections attributable to current services at month-end are
$40,000 ÷ $96,000 = 41.7%, rounded.
The first figure compares two period totals. The second measures collection progress for matching services. Neither is an industry target, and the first cannot establish that more than all of May's production was collected.
If that same cohort has collected $90,000 by a later review, with its defined net production unchanged, its collection progress is 93.75%. The remaining $6,000 needs its own status. Compare cohorts at the same age; a recently completed month has had less collection time.
Preserve later service corrections and explain any denominator change. Show uncollectible amounts as an outcome rather than quietly removing them to improve the percentage. If your system cannot reliably allocate payments to services, label that limitation and retain the period comparison without claiming a cohort rate.
Turn the reconciliation into a specific follow-up
Have the owner review the closing balance, receipt-to-bank differences, adjustment categories, and cohort progress together. A fall in receipts can reflect settlement timing; a rise in receivables can reflect recent production; a lower balance can reflect a write-off. The transaction evidence determines the explanation.
Send verified unpaid items into the accounts receivable workflow. Use the separate profit-margin calculation when the question is earnings after expenses.
Close the review with a dated record of the reports used, totals reconciled, unresolved differences, responsible reviewer, and next action. The useful result is an explainable movement in dollars, supported by percentages whose numerator and denominator answer the same question.
