How to Review Dental Production and Collections

What do production and collections measure?

Gross production is the value of the fees charged before the stated reductions. Adjusted production accounts for the items used to reduce or change those fees. Collections are receipts from patients, insurers or other payment sources. A charge can appear in one month and be paid in another. Those dates answer different questions.

The software's definitions matter. Open Dental describes net production as gross production plus adjustments less insurance write-offs. It treats a refund as payment activity, distinct from an adjustment to a charge. Check how the target office uses its own system before importing labels into a model. (Source: Open Dental: Production and income definitions, retrieved September 2026.)

Ask the seller to define each column in plain language. If the office says “revenue,” clarify whether it means billed fees, adjusted fees, money posted in the patient ledger or revenue in the accounts. A label that sounds familiar can conceal a different calculation. Write the definition next to the number the first time you use it.

Which reports should a buyer request first?

Start with reports that can resolve the main revenue questions without exposing patient identities. Ask for monthly totals across the periods under review, a provider breakdown, and the matching accounting records. Request supporting detail only for gaps that matter. The ADA's buyer guidance includes production and collections by dentist and hygienist as part of financial review. (Source: ADA: How to purchase with confidence, retrieved September 2026.)

Keep the originals read-only in the deal folder. Give each new export a date and version. A spreadsheet that has been edited to match the model is no longer the original evidence. Preserve the link from every adjustment back to its supporting file.

How do you make the report scope consistent?

Use the same start and end dates for the reports you compare. Record whether a report uses service, payment or posting dates. Include the locations and providers that belong to the proposed purchase. Ask how departed providers, hidden locations and receipts without an assigned provider are handled.

In Open Dental, the Production and Income report has provider and clinic filters, an option for unearned income, and several report types. The monthly view can include scheduled production. Its totals need not represent completed care alone. Those features are reasons to save the settings with the export, not to assume a report total is wrong. (Source: Open Dental: Production and income report settings, retrieved September 2026.)

Build a small extraction log. Name the person who ran the report, the software version, the filters and the file date. If a later export changes a past month's result, request the reason. A posted correction may be valid. A changed filter may also be valid. The model must identify which occurred before replacing the old amount.

How does a collection rate work?

A simple period collection rate divides collections by the chosen production base for the same period. State whether the denominator is gross or adjusted production. Neither ratio tracks the eventual payment of one specific set of procedures unless the data follows that same group of charges over time.

Consider this invented example. It is arithmetic for a buyer's worksheet, not an industry benchmark or a report from a real practice. Assume all figures cover the same full year and only completed work enters gross production.

Both percentages are mathematically correct. They answer different questions. Neither proves that the unpaid balance is collectible. Neither shows whether current receipts include payment for work performed before the year began. Do not call the difference between the ratios a loss without tracing the adjustments.

A period ratio can exceed 100% if receipts include enough older charges. That result deserves explanation rather than automatic praise. Separate the opening receivables collected during the period from payments for current work when the information is available. Use the valuation guide to connect verified revenue with costs and earnings.

How do you reconcile collections to the bank?

Create a bridge from posted receipts to bank deposits. Merchant fees, settlement timing, refunds and transfers may create differences. They are possible explanations to test, not blanket permission to disregard a mismatch. Ask the accountant to confirm the sign and evidence for each item.

For a second invented example, assume software shows $82,000 of posted receipts for a month. The table below traces that amount to $79,200 deposited. These figures demonstrate reconciliation only. They are not typical fees or settlement terms.

The bridge works only if the entries are supported and not counted twice. For example, do not deduct a refund again if both the opening receipt number and the bank total already reflect it. A loan deposit or owner contribution is cash in the bank, but it is not patient revenue. Keep financing flows out of the operating receipts comparison.

Reconcile several periods, including a period near the proposed closing. One matching month cannot resolve a persistent mismatch elsewhere. If a difference remains, show it as unexplained with an owner and next step. Do not plug it into miscellaneous income to make the spreadsheet balance.

What does the provider breakdown reveal?

Provider reports help test what the buyer must replace. Compare each clinician's work, schedule and receipts with the staffing plan after closing. If the seller performs procedures the buyer cannot cover, the model needs a staffing response, a referral plan or a lower revenue assumption. A purchase price does not supply the missing clinical capacity.

Use caution when receipts are assigned to providers. An office may receive payment after a clinician leaves. Open Dental notes both payment allocation and timing as issues in provider income reports. Review how the office handles those items before concluding that a clinician's current schedule generated all reported collections. (Source: Open Dental: Production and income definitions, retrieved September 2026.)

Separate a documented service line from an idea for future growth. For a proposed new service, list the required training, equipment, staff and patient demand. Assign a cost and feasible start date only when supported. A buyer can choose to invest in growth without paying as if that growth has already occurred.

Which patterns deserve a closer look?

A trend deserves a question before it deserves a conclusion. Rising charges with flat receipts may reflect fee changes, payer adjustments, payment timing or a billing issue. A sudden cash increase may reflect old balances being collected. Lower production may reflect fewer workdays instead of lost demand. Inspect the supporting data before assigning a cause.

Compare the same months across years where possible. Note office closures, provider leave, vacancies and unusual billing events. Ask whether the current schedule supports the most recent results. A full year of collections can lag a staffing change that has already reduced new work.

Patient prepayments need separate attention. Confirm what money has been received for care still to be delivered and how the purchase agreement treats the related obligation. Do not count the cash as freely available and omit the work or refund exposure attached to it. Bring unresolved treatment obligations to the dental attorney, CPA and clinical reviewer.

The active-patient guide examines whether recent patient activity supports the revenue story. It uses a different unit of analysis: unique people and their return behavior. Do not turn visits, charts and receipts into interchangeable measures.

How should findings change an offer or financing model?

End the review with an issue sheet, not just a folder of reports. For each unresolved item, write the question, the evidence received, the missing evidence and the potential effect. Distinguish a timing difference from a reduction in sustainable earnings. The response to each can be very different.

A timing gap may require more working capital after closing. A permanent loss of a provider may require new labor costs or a lower revenue case. An unexplained gap may require more diligence before the buyer proceeds. Ask the lender how the revised assumptions affect its review. Do not describe the lender's acceptance of a report as proof that all buyer risks are resolved.

Keep the base case tied to verified current operations. Show the downside case beside it with each changed assumption labeled. For instance, a delay in replacing a hygienist should affect the available schedule and the labor budget together. Reducing wages while leaving the same level of production in place can overstate cash flow.

How do you protect patient data during the review?

Begin with totals and summaries that answer the commercial question. Do not place patient names, treatment notes or account details in an ordinary shared spreadsheet merely to support a price discussion. Removing names alone does not necessarily make a dataset de-identified.

Healthcare counsel should determine the proper basis for any patient-level access and the required safeguards. A commercial NDA does not itself authorize every disclosure of protected health information. Keep the privacy decision distinct from the buyer's promise to keep business information confidential. (Source: HHS: Summary of the HIPAA Privacy Rule, retrieved September 2026.)

Common mistakes in a collections review

Do not compare a full calendar year with an incomplete year and call the change growth or decline. Use matching periods and show the workdays if they explain a difference. Do not combine scheduled work with completed procedures unless the purpose and label make that choice clear.

Do not deduct the same write-off in both the source report and the model. Trace the sign convention before adjusting any total. Do not apply a fixed value multiple to gross charges when the selected method requires collections or earnings. The base and the multiple must describe the same measure.

Finally, avoid treating an unresolved variance as a seller misstatement without evidence. Give the seller's team a precise reconciliation request. A clear answer can resolve the issue. If it does not, retain the uncertainty in the decision rather than forcing a favorable conclusion.

Summary

A useful collections review ties definitions, dates and report settings to the numbers in the purchase model. It explains cash timing and separates recurring work from old balances and future plans. It also tests whether the buyer can staff the services that produced the receipts. Bring the reconciliation and open issues to the transaction team before relying on the revenue figure in an offer.

After reconciling the historical reports, use the payer-mix analysis to separate payment source from network terms. Its fixed-volume fee comparison tests how the buyer's rates could change service value without treating that change as collected cash.