Stackrows
Dental Practice Balance Sheet Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Balance Sheet
AR Aging
Fixed Assets
Period Comparison

Dental Practice Balance Sheet Template

See exactly what your dental practice owns, owes, and is worth — a balance sheet built for dentists with insurance AR aging by payer, dental equipment depreciation, lab fees payable, and patient credit balance tracking.

$29Save 4+ hours vs. building a dental practice balance sheet spreadsheet from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx230 KB4 sheetsUpdated 2026-03-23

What's Inside This Dental Practice Balance Sheet Template

This template includes 4 worksheets, each designed for a specific part of your dental practice financial workflow:

1

Balance Sheet

The core financial statement organized around the dental practice chart of accounts. Current assets include operating cash and reserve accounts, insurance accounts receivable broken out by payer class (PPO, HMO, Medicaid/CHIP, and fee-for-service), patient portion receivables, prepaid dental malpractice insurance, prepaid practice management software subscriptions (Dentrix, Eaglesoft, Open Dental, or similar), dental supplies inventory, and other prepaid expenses. Non-current assets cover dental chairs and delivery units, digital X-ray and imaging equipment, CBCT scanners, sterilization units, intraoral cameras, computers and IT hardware, leasehold improvements for the operatories and reception area, and any vehicles — each listed at original cost net of accumulated depreciation with values fed from the Fixed Assets sheet. Current liabilities include accounts payable to dental supply vendors (Patterson, Schein, Benco), accrued lab fees for outsourced crown and denture fabrication, accrued wages and benefits for clinical and administrative staff, payroll taxes payable, and patient refund liability for insurance overpayments and patient credit balances. Long-term liabilities cover dental equipment financing, practice acquisition or startup loans, and lease obligations. Owner's equity tracks paid-in capital, retained earnings, and owner distributions. A built-in accounting equation check flags any imbalance between total assets and total liabilities plus equity.

2

AR Aging

A detailed accounts receivable aging tracker that separates insurance AR from patient AR and breaks each into aging buckets — current (0–30 days), 31–60 days, 61–90 days, and over 90 days. For insurance AR, you can track outstanding claims by payer class (PPO, HMO, Medicaid/CHIP, and fee-for-service) so you can see at a glance which payers are slow to reimburse or generating excessive denials. The sheet calculates total AR, net collection rate by payer, and average days in AR — with most well-run dental practices targeting a collection rate of 96–99% and AR in the 30–40 day range. Any balance in the 90+ day bucket is flagged, since claims that old are at high risk of denial or write-off. The aging summary rolls the net collectable AR balance into the current assets section of the balance sheet, presenting receivables at realistic collectability rather than gross billed amounts.

3

Fixed Assets

A fixed-asset register tracking every major piece of dental equipment, imaging technology, and leasehold improvement the practice owns. Each asset is listed with its description, purchase date, original cost, useful life in years, depreciation method (straight-line by default), and accumulated depreciation to date. The sheet calculates net book value for each item and rolls up to category totals — dental chairs and delivery units, digital imaging and X-ray equipment, CBCT and cone beam scanners, sterilization and autoclave equipment, intraoral cameras and CAD/CAM units, computers and administrative hardware, leasehold improvements for operatory buildout — that feed directly into the non-current assets section of the balance sheet. Dental practices often carry significant capital investment in digital imaging and CAD/CAM technology, and tracking these separately from general office equipment gives an accurate picture of practice capitalization and helps identify equipment approaching full depreciation that may need replacement or financing review.

4

Period Comparison

A side-by-side view of two balance sheet dates — typically the current period-end against the prior year-end — showing dollar and percentage change for every line item across assets, liabilities, and equity. For dental practices, the most informative comparisons are: whether insurance AR is growing relative to collections (a potential billing or payer issue), whether patient credit balances are accumulating (indicating unresolved overpayments), whether dental equipment is being actively invested in or approaching full depreciation, and whether owner's equity is building over time. This view supports conversations with a practice lender, a DSO evaluating an acquisition, a potential partner in a group practice arrangement, or an accountant preparing for practice sale or succession planning.

Dental Practice Balance Sheet Template Features

  • Insurance AR aging broken out by payer class — PPO, HMO, Medicaid/CHIP, and fee-for-service
  • Patient refund liability tracked separately for insurance overpayments and patient credit balances
  • Fixed asset register with depreciation schedules for dental chairs, digital X-ray, CBCT, and CAD/CAM equipment
  • Net collection rate and days in AR calculated automatically — benchmarked against the 96–99% collection target
  • Accounting equation check — automatically flags any imbalance between assets and liabilities plus equity
  • Period-over-period comparison for lender reporting, DSO due diligence, and practice valuations

How to Use This Dental Practice Balance Sheet Spreadsheet

Start with the Fixed Assets sheet before entering anything else. Pull your depreciation schedule from last year's tax return or your accountant's records and list every major asset: dental chairs, delivery units, digital X-ray equipment, CBCT scanner, sterilization units, intraoral cameras, CAD/CAM technology, computers, and any leasehold improvements to the operatories. Enter the original cost, purchase date, and useful life for each item — the sheet handles depreciation calculations and produces category totals that feed into the balance sheet automatically. Dental practices often carry their largest capital investment in imaging and CAD/CAM technology, and getting these properly depreciated is essential for an accurate picture of practice value.

Next, complete the AR Aging sheet. Pull your accounts receivable aging report from your practice management software (Dentrix, Eaglesoft, Open Dental, or your billing system) and enter outstanding balances by payer class and aging bucket. The sheet calculates your net collectable AR and feeds the realistic balance into current assets — not the gross billed amount, which overstates the asset considerably in a dental practice with PPO fee write-offs. Then fill in the rest of the balance sheet: operating cash from your bank statement, dental supplies inventory from your supply closet count, prepaid malpractice insurance from your premium schedule, patient credit balances from your billing system's credit balance report, lab fees payable for outstanding crown and denture cases, and accounts payable from your dental supply vendor aging.

Update the balance sheet monthly if you carry equipment debt or are preparing for a practice sale, partnership arrangement, or bank renewal. At minimum, review it quarterly. The AR aging is the most time-sensitive section — a rising AR balance relative to production is an early warning sign of a billing problem, payer dispute, or staffing issue worth catching before write-offs accumulate. Use the Period Comparison sheet when presenting financials to a lender, responding to due diligence from a DSO or partner, or reviewing year-end financial health with your accountant. Dental practices with well-maintained balance sheets — especially those accurately presenting net AR and patient credit liabilities — move through practice valuations and financing conversations significantly faster than practices relying on tax returns alone.

15 minutes from download to your first practice balance sheet

Download the template, enter your accounts and AR aging, and see your dental practice's full financial position — assets, liabilities, patient credit obligations, and owner's equity included.

Why Every Dental Practice Needs a Balance Sheet Template

Most dental practice owners spend their time watching production and collections, but rarely look at the balance sheet. The P&L tells you whether you produced and collected more than you spent this month; the balance sheet tells you what the practice is actually worth and whether it has the financial stability to absorb an equipment failure, a slow quarter, or an ownership transition. Dental practices face a specific balance sheet challenge that complicates asset presentation: the difference between gross production and net collected revenue is large, and the same gap exists in AR. A practice might bill $180,000 in a month but collect $130,000 after PPO write-offs — and the outstanding AR on the balance sheet should reflect the net collectable amount, not the gross billed figure.

Three line items on a dental practice balance sheet deserve particular attention. First, insurance AR should be carried at net realizable value after contractual adjustments — PPO and HMO fee schedules typically require write-offs of 20–40% of gross billed charges, and Medicaid write-offs are often higher. Carrying gross billed AR on the balance sheet overstates assets and gives a misleading picture of practice liquidity. Second, patient refund liability: when insurance overpays, when a patient overpays their portion, or when a treatment is cancelled after payment is received, those credit balances are a liability until returned. Third, lab fees payable: dental practices with active restorative and prosthetic cases often carry $5,000–$20,000 or more in outstanding lab work that has been delivered but not yet paid for — these are a real current liability that should be separated from general accounts payable.

Lenders evaluating a practice loan, DSOs performing acquisition due diligence, and partners in a group practice arrangement all look at the same questions: Is the AR clean and aged reasonably, or is it loaded with old claims that will never be collected? What does the equipment position look like — is the practice investing in modern digital technology, or running fully depreciated equipment that will soon need replacement? Is the practice retaining earnings over time, or are distributions consistently exceeding retained income? A practice owner who maintains an accurate, current balance sheet — properly presenting net AR, tracking patient refund liabilities, and maintaining a depreciation schedule for all dental equipment — presents a dramatically cleaner financial story than one pulling numbers together under deadline pressure.

Dental Practice Industry at a Glance

Financial templates built for dental practices — from solo general dentists to multi-provider offices. Pre-loaded with CDT billing categories, insurance adjustment tracking, and the KPIs that matter to practice owners.

Revenue Drivers

  • Patient exam and hygiene visits
  • Restorative procedures (fillings, crowns, root canals)
  • Implants and prosthetics
  • Specialty services (whitening, Invisalign)
  • Insurance reimbursements and fee-for-service collections

Key Cost Categories

  • Staff salaries and benefits
  • Dental supplies (chairside materials)
  • Lab fees (outsourced crown and denture fabrication)
  • Rent and facility
  • Equipment and depreciation
  • Marketing and patient acquisition
  • Practice management software and billing systems
  • Professional services (accounting, legal)

Typical Margins

Gross: 75-80% · Net: 30-40%

Seasonality

Summer peak driven by children's appointments before school year; year-end surge as patients use expiring insurance benefits; January restorative surge as annual maximums reset.

Key Performance Indicators

Collection rate (target: 96-99%)Case acceptance rate (target: 75-80%)New patients per monthOverhead as % of collections (target: 59-65%)AR over 90 days (target: under 10% of total AR)

Dental Practice Balance Sheet Template FAQ

Dental Practice Balance Sheet Template

$29