Dental Practice Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the Collections & AR Tracker — enter your prior month's production by payer type (insurance and fee-for-service), your contractual adjustment percentages for each major carrier, and your current AR aging balances. The sheet will calculate your collection rate immediately, which tells you whether your starting cash position is based on a practice collecting close to 100% of what it's owed or one with a meaningful receivables problem. Then enter your outstanding AR by age bucket — this is the starting input that makes the 13-week projection accurate, because most of the insurance payments you'll collect over the next two to three weeks are for procedures already completed and claims already submitted.

Move to the 13-Week Cash Flow sheet and fill in projected insurance inflows week by week based on your current claim aging and your carriers' typical payment timelines. Most commercial PPO carriers pay within 14–30 days of clean claim submission; Medicaid and some HMO plans run 30–45 days. Patient portion collections are more predictable — co-pays collected at the chair on appointment days, billed balances spread over the following 30–60 days based on your statement cycle and patient payment rate. Enter your bi-weekly payroll dates and gross payroll amounts in the expense rows — this is the single most important item to get right because it's non-negotiable, and the weeks when payroll lands during a slow insurance payment window are where cash shortfalls occur. Add lab invoice payment dates (typically net-30 from the lab's invoice date) and supply order payment dates.

Reconcile the Monthly Cash Flow sheet against your bank statements at month-end and update the AR aging in the Collections Tracker at the same time. After three to four months of data, the Annual Summary will show your collection rate trend, your overhead percentage, your lab cost ratio, and the seasonal production and cash flow pattern for your specific practice. The gap between production and collections is the number to watch most closely — a practice with $200,000 in monthly production and a 92% collection rate is leaving $16,000 per month on the table compared to a 99% collection rate, and most of that gap lives in the 61–90 and 90+ day AR buckets. Seeing this in a single view is what makes the Collections Tracker worth maintaining consistently.

Dental practices face a cash flow structure that looks simple on paper — patients come in, procedures are done, money is collected — but plays out very differently in practice. The core tension is between production and collections. A practice produces $180,000 in a given month, but 70% of that is billed to insurance carriers who will pay in 14–45 days, and another 15% is billed to patients who will pay over the next 30–90 days. Only about 15% — the patient portions collected at time of service — arrives as cash in the same week it was earned. The result is that a growing, productive dental practice can run perpetually short on cash not because it's unprofitable but because its receivables cycle creates a structural 30–45 day gap between when the work is done and when the cash lands. Understanding this gap, and projecting it forward week by week, is the primary job of a dental practice cash flow statement.

The metrics that matter most in dental practice cash flow are collection rate, overhead percentage, and AR aging. Collection rate — net collections divided by net adjusted production — should stay at 96–99% for a well-managed practice. Every percentage point below 99% represents real money that was earned but not collected; at $2M in annual adjusted production, the difference between 96% and 99% collection is $60,000 per year. Overhead as a percentage of collections should target 59–65% for a general practice; above 70%, the practice is typically unprofitable at current production levels. AR aging over 90 days is the early warning signal: once a balance ages past 90 days, the probability of collection drops to 60–70% for patient AR and even lower for disputed insurance claims. Lab fees deserve separate tracking because they scale directly with restorative production — as crown and implant cases grow, lab expenses should grow proportionally, and a lab cost ratio above 12% of collections typically signals either high-volume restorative (good) or a fee schedule problem (bad).

The cash management workflow for a well-run dental practice looks like this: submit claims within 24 hours of service, work unpaid insurance claims at 30 days with automated follow-up, send patient statements within 5 days of the appointment and collect outstanding balances at the next visit, review AR aging weekly rather than monthly because the 30–60 day window is where insurance denials and patient balance disputes are still recoverable, and project cash forward 13 weeks using your current AR aging and payroll schedule to identify any weeks where inflows won't cover payroll and lab obligations. Practices that do this consistently never face a true cash crisis — they see the gap coming two to three weeks out and can draw on their line of credit or delay a discretionary equipment purchase before payroll is at risk. This template is built to support exactly that workflow.