Unearned Income Reports in Open Dental Explained
Understanding Unearned Income Reports in Open Dental (And When to Use Each One)
Unearned income is one of the most misunderstood (and most misused) areas in Open Dental reporting. I see offices collect money, leave it sitting unearned, and then wonder why their reports don’t match reality, their balances feel off, or their database slowly becomes a mess.
This post breaks down the four Unearned Income Reports in Open Dental, what each one actually shows, and when you should (and shouldn’t) be using them.
If you’ve ever asked:
Why do we have money sitting in unearned?
Which unearned report should I run?
Why doesn’t this patient’s balance make sense?
This guide is for you.
First: What Unearned Income Really Means (In Practice)
In Open Dental, unearned income typically shows up as patient prepayments or overpayments that haven’t been fully allocated to completed procedures yet.
Technically, that’s correct.
Operationally? I treat unearned income as a big red flag.
Here’s why:
True prepayments should be allocated to treatment planned procedures
Leaving money unearned creates extra manual work later
It increases the risk of missed allocations, inaccurate reports, and patient confusion
Unearned income is not a “holding account” you want growing quietly in the background. It’s something that should be actively monitored and cleared.
That’s where these reports come in.
Where to Find Unearned Income Reports in Open Dental
Go to:
Reports → Standard Reports → Monthly → Unearned Income
You’ll see four different reports:
Unearned Accounts Report
Unearned Allocation Report
Net Unearned Income Report
Line Item Unearned Income Report
Each one answers a different question, and using the wrong one is where teams get stuck.
1. Unearned Accounts Report
Best for: Finding families with leftover unearned balances
What this report shows
Total family-level unearned income balance
Grouped by guarantor
Broken out by unearned type and clinic (if applicable)
When to use it
Use this report when you want a high-level cleanup list:
Families who still have money sitting unearned
Accounts that need allocation, scheduling, or refunds
How I use this in real life
This is my starting point report.
If your office philosophy is “we don’t leave money unearned,” this report should:
Be reviewed routinely (monthly at minimum)
Have very few names on it
If it’s long? That’s not normal, that’s a process issue.
2. Unearned Allocation Report
Best for: Catching missed allocations after treatment is completed
What this report shows
This report flags families where:
Unearned income exists and
Completed procedures still have a remaining patient balance
In other words: the money was collected, but never applied.
When to use it
Use this report when:
Patient balances don’t make sense
You’re seeing unexpected AR
You suspect allocations were missed during busy clinical days
Why this report matters so much
This is the report that catches silent errors.
These are the accounts where:
The office already has the patient’s money
But the procedure still looks unpaid
And nobody realizes it until much later
This report helps you fix that before it becomes a patient trust issue.
3. Net Unearned Income Report
Best for: Identifying money with no clear next step
What this report shows
Patients who:
Have a net unearned income balance
Have no unallocated procedures waiting
Translation: the money has nowhere obvious to go.
When to use it
Run this report when you need to decide:
Does this patient need to be scheduled?
Should a refund be issued?
Does this payment need to be applied to an adjustment or charge?
My honest take
This report often exposes why unearned income is risky.
If there’s no treatment planned and no balance due, unearned money becomes ambiguous, and ambiguity is where databases get messy.
4. Line Item Unearned Income Report
Best for: Auditing activity and troubleshooting
What this report shows
Individual unearned payment splits
Within a specific date range
Including positive (collected) and negative (allocated/refunded) amounts
When to use it
This is your investigative report.
Use it when:
Reconciling month-end numbers
Investigating a refund
Tracking down how (or when) unearned was moved
If the other reports tell you who, this one tells you what happened
A Note on Negative Unearned Income (Don’t Ignore This)
A negative unearned balance means:
More money was allocated than ever existed.
This should never happen intentionally.
When it does, it usually points to:
Over-allocation
Incorrect refunds
Manual income transfers done incorrectly
Negative unearned always requires cleanup, and usually a review of workflows to prevent it from happening again.
My Philosophy: Unearned Income Should Be Temporary
I’ll say it plainly:
Unearned income is not a strategy, it’s a signal.
The longer money sits unearned, the more:
manual work it creates
reporting confusion it causes
trust risk it introduces
Clean systems allocate payments as close to treatment as possible, keep reports boring, and make balances make sense at a glance.
If your Unearned Income Reports are noisy, that’s not a reporting problem, it’s a workflow problem.
Final Thoughts
If you want your Open Dental database to stay clean and your reports to stay trustworthy:
Use Unearned Accounts to find leftover money
Use Unearned Allocation to catch missed applications
Use Net Unearned Income to decide next steps
Use Line Item Unearned Income to audit and troubleshoot
And most importantly: don’t normalize unearned income sitting untouched.
If your reports feel confusing or your team is constantly second-guessing what they’re seeing, it’s usually not a reporting issue. It’s a workflow issue.
That’s exactly what we help fix.
If you want a clear, outside perspective on how your system is actually functioning, you can learn more about our process here 👉 SKF Practice Solutions
Because clean reports don’t happen by accident. They come from systems that are built to support them.
