Report of Insurance Plans by Benefit month/year

For users or potential users.
Post Reply
snofalls
Posts: 9
Joined: Wed Aug 11, 2010 1:08 pm

Report of Insurance Plans by Benefit month/year

Post by snofalls »

Is there a way to run a report/list of patients with insurance plans based on when their benefit year ends? Would like to send out an end of the year for those with outstanding treatment before their insurance year ends, but don't want to send letters to patients whose benefit year is April for example or to teachers their's run September to October. Let me know...

Linda
Snoqualmie Falls Dental
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks »

Not easily. There might be a query, but I would have to search. I don't think that specific query has been written.
Jordan Sparks, DMD
http://www.opendental.com
Tracey
Posts: 38
Joined: Wed Mar 12, 2008 12:14 pm
Location: East Islip Long Island

Re: Report of Insurance Plans by Benefit month/year

Post by Tracey »

I would like to know how I can break down the insurance claims sent per month with their totals. Is there a report for that?
Thanks;
TRACEY
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks »

Hmm. No, I don't recall a report about that either. Someone might have to hunt through the query examples page.

But back to the first question. We just began an overhaul of that report to turn it into an interactive grid with more filters. Should be released in a few weeks. That's obviously late, but it might help a little.
Jordan Sparks, DMD
http://www.opendental.com
snofalls
Posts: 9
Joined: Wed Aug 11, 2010 1:08 pm

Re: Report of Insurance Plans by Benefit month/year

Post by snofalls »

Thank you so much for looking into it...I am planning on sending out letter November 1st, maybe by next year that would be great!

Linda
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks »

We're down to a few days now, but it will probably have bugs at first.
Jordan Sparks, DMD
http://www.opendental.com
Tracey
Posts: 38
Joined: Wed Mar 12, 2008 12:14 pm
Location: East Islip Long Island

Re: Report of Insurance Plans by Benefit month/year

Post by Tracey »

Has this report become availble yet? :idea: We would like to know how many claims and their totals sent per month. Not just whats outstanding. Thanks and Happy New Year!
Thanks;
TRACEY
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks »

The original topic was about sending out letters for year end. Yes, that's part of version 7.5.

But you are asking about something totally different which is a "report" that we don't have and that we don't plan on adding soon. In cases like that, you can look through our queries. There are over 300 of them. If there's not one that exactly matches your needs, we can write one as a paid service.
http://70.90.133.65:1942/ODQueryList/QueryList.aspx
Jordan Sparks, DMD
http://www.opendental.com
babysilvertooth
Posts: 129
Joined: Sat Jun 12, 2010 3:18 pm

Re: Report of Insurance Plans by Benefit month/year

Post by babysilvertooth »

THis would be a great feature, we have a lot of Municipal workers as patients (police, fire, teachers) and their benefit years are not Jan, but July or Sept. Offhand, we type in Employers (like TOwn of or City of) and find the patients that way....tedious but is a work around.
Tracey
Posts: 38
Joined: Wed Mar 12, 2008 12:14 pm
Location: East Islip Long Island

Re: Report of Insurance Plans by Benefit month/year

Post by Tracey »

On the 7.5 version where would we find the report for insurance claims sent per month? Will this show total billed and total paid?
Thanks;
TRACEY
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks »

As I said, we don't plan on adding such a report anytime soon.
Jordan Sparks, DMD
http://www.opendental.com
Post Reply