Skip to article

Financial reporting

Dental practice financial reports: a daily, weekly, and monthly checklist

Use a dental reporting checklist with an owner and follow-up action for each report. Compare deposits, adjustments, collections, and aging without mixing them.

Which dental practice financial reports should you review first?

Start with dental practice financial reports that lead to a specific action. Assign the daily matching work to billing, the open-claim review to the billing lead, and the monthly review to the owner with the person responsible for the accounts. The schedule below is a suggested office routine.

When and whoCompareAction if it doesn't match
Daily: payment posterPayments posted against remittance and deposit referencesRecord timing differences and investigate unmatched items
Weekly: billing leadOpen claims against the last payer responseAssign the next action and check its deadline
Weekly: billing leadAdjustments against documented reasonsReview unexplained entries with the authorized approver
Monthly: owner and accounts leadCollections, adjusted production, and aging using consistent settingsExplain changes before changing targets or staffing

Save the report date, filters, and person responsible with each review. A deposit arriving the next day needs a timing explanation; it doesn't automatically mean a posting error.

How can a collection ratio improve without more cash?

Here's a fictional example using the same reporting period. Collections are $90,000 and adjusted production is $100,000, so the ratio is 90%. If another $5,000 adjustment reduces that denominator to $95,000, the ratio becomes about 94.7%. Collections are still $90,000.

An adjustment may be correct. Review its reason rather than treating the higher ratio as proof that billing collected more. Also remember that this month's collections can pay for work from an earlier month. Keep the period and calculation method consistent when you compare results.

For the working claim list behind the owner's report, use the AR worklist and the claim follow-up workflow. For an adjustment you can't explain, review the source EOB with the EOB decoder before deciding how to post it.

Which four numbers should you start with?

One practice we spoke with writes off underpayments instead of billing the patient for the balance. It isn't laziness. It's a deliberate choice to avoid an awkward conversation at checkout.

That money never shows up as a loss. It leaves as an adjustment, and every practice posts thousands of those. No report they run separates it from a normal contractual write-off.

So they're not choosing to give it up. They just can't see it. Good reporting isn't about catching anybody, and it isn't a dashboard nobody opens. It's making that money visible enough to decide on.

NumberWhat it tells you
Collection ratioWhat percent of adjusted production you actually collect
Total overheadWhether the practice makes money at its current size
Staffing percentageYour largest controllable cost, as a share of collections
AR over 90 daysWhether claims are dying before they get paid

Collection ratio is the one with a usable benchmark. Many practices aim for around 98% of adjusted production, though the right target depends on your payer mix.

Now the part nobody warns owners about. Collection ratio is measured against adjusted production, so every write-off you post improves it. An office that writes off aggressively runs a beautiful collection percentage while leaving real money behind. Read it next to your adjustments, or don't bother reading it.

AR over 90 days deserves its own report. We covered what healthy dental AR looks like separately, including why dollar totals tell you nothing and percentages tell you everything.

How often should you run each report?

Cadence matters more than completeness. A report you run monthly can't catch something that breaks on a Tuesday.

How oftenWhat to look at
DailyDeposit versus what was posted, and what was collected at the desk
WeeklyClaim follow-up, unmatched deposits, unscheduled treatment
MonthlyCollection ratio, overhead, staffing percentage, AR aging by payer

The daily row is the one billing people actually do and owners never see. Match the deposit against what got posted while you still remember the day. Let it slip a week and you're reconstructing it from statements.

The weekly row is where practices lose money without noticing, because claim follow-up is the first thing to slip when the schedule is full.

What does a billing manager watch that an owner doesn't?

The four numbers above are what you hand an owner. These are what you work from.

  • Unapplied credits. Payments sitting on an account that were never applied to a procedure. They make collections look fine and patient balances look wrong, and they're the most common reason a patient argues about a statement.
  • Credit balances and refunds owed. Overpayments sitting on accounts aren't yours to keep. Payers ask for them back, and a pile of them is money you'll owe later.
  • Aging by payer, not just by bucket. The bucket view tells you how bad it is. The payer view tells you who to call, and lets you work fifteen claims in one phone call. Nobody works an aging report alphabetically.
  • Adjustments broken out by reason. Every practice tracks total adjustments. Far fewer separate contractual write-offs, the price of your PPO contracts, from everything else, which is somebody making a decision.
  • Payment as a percent of billed fee, by payer. The best early warning that a payer changed something. It catches downgrades, changed fee schedules, and the difference between UCR and a flat maximum. A payer that drops five points and stays there has repriced you, and nobody sends a letter.
  • Claims with no activity in 30 days. Not denied, not paid, just sitting. Cheapest report in the practice, most likely to find real money, and your clearinghouse is often why they're stuck.

One office told us they had an insurer sending checks to an address they couldn't receive mail at, and lost most of a year of payments. Nothing was denied, so no denial report would have caught it.

What does the annual maximum actually tell you?

Usually told wrong. The ADA adopted a policy in 2024 opposing annual and lifetime maximums in any dental benefit program, and many plans still promote the $1,000 level set about forty years ago. But the spread has moved: NADP data cited by the ADA puts 48.2% of in-network maximums at $1,500 to $2,500, and 17.2% at $2,500 or none.

Here's the number that should change how you read a report. An ADA Health Policy Institute analysis found only 3.4% of patients actually reach their annual maximum. Median emergency savings for Americans sit around $500.

So the maximum rarely stops a case. The co-payment does. If you track unscheduled treatment without tracking what those patients were asked to pay, you're measuring the wrong barrier.

Who should see these reports?

One habit beats any report here. The person who posts payments shouldn't be the only one who sees the numbers.

That isn't suspicion. A reconciliation error, a payer repricing you, a stack of unworked claims: all of it looks normal to the person doing the work every day, and obvious to somebody seeing it fresh.

The split that works: the owner gets four numbers and fifteen minutes a month. Whoever runs billing keeps the working reports, because those need context and an owner staring at an aging report usually just creates a fire drill. That holds for whoever does your billing, in-house or outsourced.

Autumn compares what each payer paid against what they owed on every claim, which is the part nobody has time to do by hand. If you want a read on what your reports aren't showing you, we do a free billing consultation. It doesn't take anything on your end.

What is a good collection ratio for a dental practice?

Many practices aim for around 98% of adjusted production. Read it alongside your adjustments, because the ratio is measured against adjusted production and every write-off improves it. A high collection ratio with heavy write-offs is not a healthy practice.

Which financial reports should a dental practice run monthly?

Collection ratio, total overhead, staffing percentage, and AR aging by payer. Add adjustments by reason and payment as a percent of billed fee by payer, since those find the leaks the headline numbers hide. Keep patient AR and insurance AR on separate reports, because they fail differently and mixing them hides problems in both.

Let Autumn carry this workflowExplore AR Cleanup

Continue reading

Dental insurance claims moving from rejected status toward successful appeal
Denials

Dental claim denials: a review log for appeals and follow-up

Give each dental claim denial an owner, an evidence record, and a next action. Use this review log to track appeals through the payer's response.

Jake · 7 min readRead article
Dental accounts receivable files arranged into aging groups
Accounts receivable

Dental AR benchmarks: what a healthy insurance aging report looks like

Read your dental insurance aging report, calculate each bucket's share, and turn old balances into a worklist with evidence, owners, and next actions.

Jake · 7 min readRead article