Dental collections and billed production: reconciling the cash gap

Keep three ledgers with three different jobs

The clinical/production ledger records completed treatment episodes and fee codes. The receivable ledger records contractual adjustments, patient and payer responsibilities, expected allowances, posted payments and outstanding claims. The bank ledger records cash received, processing settlements and refunds. A reconciliation connects them; a production report cannot replace the bank statement and a bank statement alone cannot explain a claim still being processed.

ADA distinguishes adjusted production after third-party discounts from the money actually collected. We use that distinction, rather than importing a universal collection target as a guarantee. The case also separates net revenue from adjusted production using an explicitly assumed ultimate-realization haircut. This is a planning convention; the real accountant must decide the appropriate recognition, allowance and write-off policy. ADA definitions.

The case covers fee-for-service and commercial PPO care only. Capitation, Medicaid, subscription plans, refunds for incomplete treatment and outside patient financing would need additional terms and ledgers. A quoted list crown fee is not evidence of the PPO allowed amount. Obtain the actual payer contract, limitations and patient balance policy before forecasting collections.

Walk one crown cohort from charge to net receivable

The hypothetical cohort completes 10 crown episodes. Each carries list fee $1,550.00 and PPO allowed fee $1,050.00; both are case assumptions. The payer class reaches 96.0% ultimate realization of allowed fees. It therefore expects $10,080 cash over the cohort’s life, rather than its $15,500 list production.

Contractual discount and realization allowance have different reasons. The first is part of the agreed fee basis; the second is an expected shortfall on otherwise adjusted production. Do not book a contractual discount as bad debt again or treat a missing quote as a zero discount. This example records the allowance immediately to produce a net AR balance. A system showing gross adjusted AR would need the allowance beside it to reproduce the same net balance.

Lab work and supplies have their own payment dates. The crown episode includes one laboratory charge, even though preparation and seating use different appointments. A refund, remake or failed claim needs a documented adjustment to the original cohort; it is not a reason to bill a second full crown fee or to hide the lab obligation.

Follow collections across months without rebilling

The base PPO kernel receives 30.0% in the completion month, 50.0% in the next and 20.0% in the second following month. These weights describe the total PPO-class collectible fee, including an assumed immediate patient portion; they are not a contractual insurer service-level promise. A real practice should separate patient and insurer balances and measure their own payment ages.

Current-month cash divided by adjusted production is only 28.8% for this new isolated cohort, while its eventual realization is 96.0%. Cash divided by list production over its full life is 65.0%. Those denominators answer different questions. Calling the first percentage a failure rate would mistake timing for permanent loss; calling the last one a payer realization rate would ignore contractual discounts.

In a growing practice, old claims and new claims overlap. A current-month collections/production ratio can exceed full realization when receipts from previous months arrive. Age the cohorts, compare their original adjusted balances and explain every movement. The isolated example has no opening AR or other cohorts so the identity is visible; the full monthly model keeps the overlapping histories.

Separate a slower payment from a lower allowed fee

Change only the isolated timing weights to 20.0%, 40.0% and 40.0%. Completion-month cash falls to $2,016, a $1,008 cash delay versus the base cohort. Eventual collectible amount remains $10,080. The isolated worksheet’s treatment revenue does not change; AR is higher until later receipts arrive. In the full model, actual-receipt processing expense can shift between months, and financing/tax effects must also be checked.

A lower allowed fee or an increased ultimate nonpayment assumption is different: it reduces the lifetime collectible amount. Moving cash to a later month cannot repair a permanent fee shortfall. Conversely, recognizing every slow claim as a permanent loss can understate collectible assets. Keep payment-timing evidence, denials, contractual adjustments and write-off authorizations as separate fields in the reconciliation.

For a new practice, credentialing readiness is an opening gate. Do not forecast contracted fees before participation becomes effective or assume a patient’s plan will pay every proposed code. The fee and timing assumptions here are not actual coverage verification, fee advice or an executed contract.

Use the same bridge in the 60-month practice model

Base Year 1 list production is $843,065, adjusted production is $676,777 and expected collectible net revenue is $659,823. Bank collections are $626,794 and closing net receivables are $33,029. Opening receivables are zero, so net production less collections exactly explains the closing balance. Neither loan proceeds nor the owner’s equity are operating collections.

For operating cash: net income −$218,720 plus noncash depreciation $44,514 less receivable increase $33,029 equals operating cash −$207,234. Deduct principal $29,456 to get cash after debt −$236,691. Interest is already inside net income. Adding the full loan payment again would double-count interest; omitting principal would overstate available cash.

The base practice remains underfunded even after its $220,000 reserve. Timing matters, but paid labor and the fee mix also leave inadequate mature contribution. A billing-process improvement cannot be claimed to solve that structural gap without rerunning the receipts, processing, tax and debt bridge. Keep the adverse result alongside any proposed revision.

Close the month with a usable exception register

Run the register by payer and service cohort, then tie it to the general ledger and bank. A spreadsheet total is not a substitute for claim-level support, but an anonymized aggregate roll-forward can explain the planning effect without exposing patient details. HHS states that providers conducting adopted-standard electronic transactions are covered entities, and contracting out essential work does not remove privacy duties. Use secure operational systems rather than this public case for actual records. Privacy boundary.

Read the practice cash and profitability guide for the reconciled monthly statements and the funding preparation guide for evidence a lender can review. The useful collections report tells you which dollars are discounted, which are delayed, which are unlikely to arrive and which have actually reached the bank.