What Dental Practice Bookkeeping Should Show Beyond Collections
Reconcile dental production, collections, receivables, and deposits, then trace lab invoices to completed cases and procedure mix with hypothetical worked examples.
Reconcile dental production, collections, receivables, and deposits, then trace lab invoices to completed cases and procedure mix with hypothetical worked examples.
Dental production, posted collections, open receivables, and bank deposits answer different questions. A useful monthly owner report connects all four before the practice decides whether to add staff, change billing follow-up, or commit to equipment. Start with a dated reconciliation, then explain the remaining exceptions and the next action.
This guide focuses on that owner report. For account setup and transaction recording, use our dental practice bookkeeping guide. For individual payer remittances and claim balances, use the insurance receivables reconciliation guide. Keeping those tasks connected gives the owner a summary supported by detailed records.
The ADA's practice-measurement guidance distinguishes gross production from adjusted, or billable, production. Gross production includes dentistry produced before reductions; adjusted production reflects amounts considered collectible after adjustments. The ADA also identifies production, collections, profit, overhead, accounts receivable, and insurance claim aging as useful measures.
For the monthly packet, document the practice's reporting definitions. Specify whether collections are payments posted to patient accounts, whether refunds are deducted, and how credits or unapplied payments are handled. Use the same cutoff for production, adjustments, collections, and receivables. Save the exports used for the close so a later posting does not silently change the comparison.
Review adjustment categories separately: contractual reductions, courtesy adjustments, corrections, and approved older-balance write-offs. Ask for support and authorization for unusual entries. A combined adjustment total gives the owner little basis for deciding whether the change came from payer terms, posting corrections, or a collection problem.
Assume an established practice has the following September practice-management activity. Every amount is invented for this example. There are no refunds, reversals, advance payments, or unapplied receipts. Current-period production adjustments and older-receivable write-offs are separate, and each appears only once.
| Practice-management measure | Amount |
|---|---|
| Gross production | $140,000 |
| Less approved current production adjustments | ($24,000) |
| Adjusted production | $116,000 |
| Beginning receivables | $78,000 |
| Plus adjusted production | $116,000 |
| Less posted collections | ($108,000) |
| Less separately approved older-balance write-offs | ($2,000) |
| Ending receivables | $84,000 |
The ending aging report must support $84,000: $78,000 + $116,000 − $108,000 − $2,000. If it shows $85,500, the unexplained $1,500 belongs on the close exception list. Trace the underlying entries and cutoff before changing a balance. The $8,000 difference between adjusted production and collections does not, by itself, explain the $6,000 increase in receivables because the additional write-off matters.
Now reconcile settlement separately. Assume $1,500 of receipts from August settles in September, $4,500 of September receipts remains unsettled at month-end, and $1,200 of processor fees is withheld from September deposits. There are no other settlement deductions or deposit delays. September's related bank deposits are $103,800: $108,000 + $1,500 − $4,500 − $1,200. Keep the opening and closing unsettled items on a dated schedule, supported by settlement reports and subsequent bank activity. Fees explain a deposit reduction; they do not create an unpaid patient balance in this example.
The ADA's practice-purchase financial guidance calculates collection rate as collections divided by adjusted production, multiplied by 100. Here, $108,000 ÷ $116,000 is approximately 93.1%. It compares two September totals; it does not establish that 93.1% of September treatment has been paid. Some receipts may relate to earlier treatment.
Include prior months beside the current month and investigate changes with the receivables schedule. In this example, ask which unpaid balances grew, whether current adjustments were posted consistently, and whether the unsettled receipts subsequently reached the bank. Set practice-specific follow-up priorities after reviewing those records.
A lab total can rise because the practice completed more lab-dependent cases, changed its procedure mix, paid invoices for earlier work, or received fewer credits. Those explanations call for different follow-up. The ADA's fee-analysis guidance recommends considering lab costs alongside equipment, supplies, and employee benefits. Its practice-expense guidance also notes that patient mix affects laboratory spending. Use your own matched records before interpreting a percentage.
The following is a suggested management-reporting method, not a tax classification rule. Start with the lab invoices and issued credit memos for the close period. Record the vendor, invoice number and line, invoice date, case reference, practice-defined procedure group, quantity, billed amount, credit amount, net amount, and payment status. Add the practice's completion date and the matching adjusted production from its saved practice-management export. Use a restricted case reference rather than patient details in the owner summary. Keep the underlying support available to authorized staff.
The IRS supporting-document guidance identifies invoices and payment evidence as records supporting book entries; expense support should show the payee, amount, proof of payment, date incurred, and description. The case and procedure grouping adds management detail to that evidence. Agree on the grouping and completion cutoff with the practice team; these are reporting labels and do not instruct clinical decisions or billing-code selection.
Continue the September example above. All amounts and case counts below are invented and are not market prices or benchmarks. Assume that the completed-case support is complete, September invoices contain all outside-lab charges for those completed cases, and the issued credits are matched to the same cases. Each counted case has one reporting unit; no case appears in two groups. Of the practice's $116,000 adjusted production, these lab-dependent completed cases account for $36,000 and other procedures account for $80,000.
| Completed September group | Cases | Adjusted production | Lab charges | Issued credits | Net outside-lab cost |
|---|---|---|---|---|---|
| Crowns | 20 | $20,000 | $4,200 | ($200) | $4,000 |
| Dentures | 8 | $12,000 | $3,600 | ($400) | $3,200 |
| Appliances | 10 | $4,000 | $1,000 | $0 | $1,000 |
| Total matched completed cases | 38 | $36,000 | $8,800 | ($600) | $8,200 |
September's invoice-date schedule contains another $3,000 for earlier completed cases, $1,000 for future or incomplete cases, and $400 awaiting a case match, with no credits for those lines. Total charges are $13,200 and issued credits are $600, leaving $12,600 net. The grouping reconciles: $8,200 + $3,000 + $1,000 + $400 = $12,600. The unmatched $400 stays visible until the invoice support identifies its case and period; do not spread it across the groups to make the report look complete.
The matched completed-case ratio is $8,200 ÷ $36,000 = approximately 22.8%. Dividing the invoice-date total by all practice adjusted production gives $12,600 ÷ $116,000 = approximately 10.9%. The second calculation uses a broader production denominator and includes other case periods and an unmatched item. Label it accordingly; it cannot replace the matched completed-case measure. Neither figure is a recommended target.
Payment timing answers another question. Assume beginning unpaid lab invoices of $5,000, net new invoices and credits of $12,600, and $11,000 of payments against those invoices, with no other payable changes or vendor advances. The ending unpaid schedule is $6,600: $5,000 + $12,600 − $11,000. Reconcile payments to the bank and unpaid invoices to the vendor statement. The $11,000 paid is neither the $12,600 invoice-date total nor the $8,200 attributed to completed September cases.
In this hypothetical example, net cost per case is $200 for crowns, $400 for dentures, and $100 for appliances. Imagine a comparison period with 24 crown cases, four denture cases, and ten appliance cases at those same net costs. Its 38 cases would have cost $7,400: $4,800 + $1,600 + $1,000. September still has 38 cases, but four more denture cases and four fewer crown cases raise matched lab cost by $800. That comparison isolates a mix change while holding the assumed group costs fixed; it does not establish a vendor price increase. Real comparisons also need to check case complexity and what each invoice includes.
Link a billed remake to its original case and flag the extra charge; count a no-charge remake separately for operational follow-up without inventing an invoice expense. An anticipated credit remains a pending exception until supported by an issued credit memo. When an issued credit relates to an earlier case, show that link and the effect on the comparison period rather than silently reducing unrelated current cases. Keep both the original invoice and credit so the net cost can be traced.
If a contract calls for a lab charge to be passed through or recovered from a patient or associate, show the lab invoice and the separately documented recovery in the review packet. An expected recovery is not a lab-vendor credit or proof of cash received. Ask the accountant to apply the actual agreement and appropriate presentation; do not automatically net it against lab spend or patient production. Keep in-house milling supplies, equipment, and labor identifiable when comparing them with outside-lab work, because an outside-lab-only schedule excludes those costs.
Adjusted production less outside-lab cost is a limited management measure. Here, $36,000 − $8,200 = $27,800 remains before clinical supplies, provider and staff compensation, occupancy, equipment costs, and other expenses; collection timing still matters. Calling $27,800 a case profit or a complete margin would omit those costs. Use the schedule to choose a supported next action: resolve the $400 unmatched invoice line, verify an issued credit, or review the cause of a change within a procedure group. The accountant can then connect that evidence with the full income statement and cash plan.
Split the $84,000 ending receivables between insurance and patient balances, then use consistent aging groups such as 0–30, 31–60, 61–90, and over 90 days. These groups are a suggested reporting format. The ADA's overdue-accounts guidance supports documented collection procedures and attention to overdue balances. Give each material exception an owner, reason, next step, and review date under the practice's financial policy.
Alongside the reconciliation, summarize payroll, lab fees, clinical supplies, occupancy, and other material expenses using consistent ledger categories. The IRS transaction-recording guidance supports clear income and expense records backed by source documents. TaxBowl's bookkeeping team can help connect those records with the practice-management report.
Keep the income statement and planned cash uses visible together. The SEC's financial-statement guide explains that profit and cash generation are different measures, and distinguishes equipment purchases and loan repayment within cash flow reporting. Ask the accountant to explain the practice's accounting basis and treatment of those items before interpreting the totals.
Close with a concrete decision: assign the unexplained $1,500 to a posting review, confirm the $4,500 settlement after month-end, or investigate the oldest insurance balances. TaxBowl's dental practice accounting service can help establish the monthly review; our monthly-close guide covers the supporting close routine.
Before committing to a major purchase, apply the dental equipment cash budget to your reconciled collections and payment dates. It compares the full acquisition cost, financing and a weekly reserve test.