Query for write-offs and or adjustments by insurance plan

[Tom Zaccaria]

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]

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)

[Arna]

I'm assuming you're after this, just subtotaled by carrier?http://opendental.com/manual/reportppowriteoffs.html

[Tom Zaccaria]

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

drtmz