Query for write-offs and or adjustments by insurance plan

For users or potential users.
Post Reply
Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Query for write-offs and or adjustments by insurance plan

Post by Tom Zaccaria » Tue Mar 14, 2017 6:23 am

Been asked if we have a report/query similar to Softdent that shows the fee charged, amount paid and writeoff per insurance plan?

Guessing it would be:
Insurance....procedure..fee...amt paid by ins..amt paid by patient...writeoff
Delta dental, prophy, fee charged, amount paid by ins, amount paid by patient, writeoff

I searched the query page but nothing seems to give these results. Anyone have something like this?

drtmz (in a blizzard on the East coast, USA)

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: Query for write-offs and or adjustments by insurance pla

Post by Tom Zaccaria » Tue Mar 14, 2017 10:22 am

OK so I have this much so far:

SELECT patnum, DateService, PlanNum, Claimfee, InspayAmt, dedapplied, writeoff
FROM claim
WHERE dateservice >'2017-1-1'
AND dateservice < '2017-4-1'
Group by plannum

But I would like to add the ADA procedures to the line, or abbrdesc from the Proccode table. I stink at joins.
Anyone point me on how to do this?
Come on, I know we are better than Softdent!!

drtmz (stuck at home)

User avatar
Arna
Posts: 444
Joined: Tue Jul 09, 2013 3:16 pm

Re: Query for write-offs and or adjustments by insurance pla

Post by Arna » Tue Mar 14, 2017 3:15 pm

I'm assuming you're after this, just subtotaled by carrier?http://opendental.com/manual/reportppowriteoffs.html
Entropy isn't what it used to be...

Arna Meyer

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: Query for write-offs and or adjustments by insurance pla

Post by Tom Zaccaria » Wed Mar 15, 2017 2:55 am

Cool. Not exactly what I needed but this should help.
Thank you

drtmz

Post Reply