Query to compare insurance reimbursements by ADA code

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

Query to compare insurance reimbursements by ADA code

Post by Tom Zaccaria » Fri Oct 15, 2021 1:42 pm

Looking for a query to compare insurance plan reimbursement in a spreadsheet form for all or some of the ADA procedure codes such as:

Insurance Plan...............Aetna......MetLife....Cigna......Delta
Ada code....Description.....Fee.........Fee........Fee.........Fee

It would be helpful if you could select which insurance plans you could select to compare.

Thanks,
drtmz

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Query to compare insurance reimbursements by ADA code

Post by joes » Tue Oct 19, 2021 9:17 am

The closest query we have on our Query Examples page is #493. There are a few steps for setting it up properly mentioned in the query's comments. The first column lists all the codes, and each following column lists the fees for a given fee schedule. You could set it up for all of the fee schedules attached to the insurance plans that you are interested in.

Link to the Query Examples page: https://opendentalsoft.com:1943/ODQuery ... yList.aspx
Joe Sullivan
Open Dental Software
http://www.opendental.com

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

Re: Query to compare insurance reimbursements by ADA code

Post by Tom Zaccaria » Tue Oct 19, 2021 10:48 am

Thanks for your help.

drtmz

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

Re: Query to compare insurance reimbursements by ADA code

Post by Tom Zaccaria » Tue Oct 19, 2021 11:50 am

Did a little fiddling with a list of Fee Schedules and their corresponding Plan Numbers and it works perfectly. Exactly what I was looking for.
Thanks again,

drtmz

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

Re: Query to compare insurance reimbursements by ADA code

Post by Tom Zaccaria » Thu Oct 21, 2021 5:32 am

To get rid of the procedures with no fee(s), procedures you do not do in your practice such as ortho, export the report to Excel.
Data sort on the Standard column from low to high value. Then delete all the rows with zero Standard fees.
Lastly, resort on ProcCode column to get your final report.

drtmz

Post Reply