Dental Practice Invoice Template

Start by opening the Service Fee Schedule sheet and entering your standard fees and contracted PPO rates for the procedures you perform most often. This sheet is your reference library — having it pre-filled means you'll pull accurate CDT codes and fees into every patient invoice without looking them up. For a typical general practice, this takes 20-30 minutes on setup and rarely needs updating outside of your annual fee schedule review.

For each patient visit, open the Patient Invoice sheet and complete the header fields (patient name, date of birth, date of service, provider name and NPI). Then add each procedure performed as a line item — pull the CDT code and fee from your Service Fee Schedule, enter the insurance adjustment for PPO patients, and the patient balance calculates automatically. When you've filed the insurance claim, log it in the Insurance Claim Tracker so you have a running record of what's outstanding and what's been paid.

At the end of each month, spend 15 minutes updating the Monthly Collections Summary with your gross production, total insurance adjustments, and collections received. Then run through the AR Aging Report to see which balances have moved into the 31-60 and 60-90 day buckets. Practices that review their aging report monthly and follow up on overdue accounts consistently hit collection rates above 96% — which on a $1 million production practice is the difference between $960,000 and $940,000 collected.

Dental billing is more complex than most small business invoicing because every transaction involves three parties: the patient, one or more insurance carriers, and the practice. A cleaning billed at $175 might result in a $60 PPO write-off, a $95 insurance payment arriving three weeks later, and a $20 patient co-pay collected at the time of service. Managing that three-way reconciliation without a structured system leads to overlooked balances, claim follow-up falling through the cracks, and a collection rate that quietly erodes practice profitability.

The key financial metrics in a dental practice are collection rate, overhead percentage, and AR aging. A healthy practice collects 96-99% of adjusted production (gross fees minus PPO write-offs). Total overhead should land between 59-65% of collections — the largest buckets being staff salaries (25-30%), lab fees (6-8%), and dental supplies (5-6%). AR aging should show less than 10% of total receivables in the 90+ day bucket; when that number creeps above 15-20%, it signals a collections process problem or an insurer payment issue that needs investigation. Tracking these numbers monthly, not quarterly, is what separates practices that hit their income targets from those that perpetually wonder where their production went.

The workflow that works best: invoice at every visit, file insurance same-day, post EOBs within 24 hours of receipt, and run an AR aging report on the last business day of the month. Following up on claims at 30 days prevents them from aging into the 60 and 90 day buckets where recovery rates drop. For patient balances, send a statement immediately after the insurance pays — patients pay faster when the bill arrives promptly rather than a month after their visit. This template is built around that workflow, giving you a claim log, an aging report, and a collections dashboard in one place.