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 » Tue Oct 19, 2010 12:57 pm

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: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks » Tue Oct 19, 2010 1:42 pm

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 » Wed Oct 20, 2010 7:08 am

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: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks » Wed Oct 20, 2010 10:16 am

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 » Tue Oct 26, 2010 7:44 am

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: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks » Thu Nov 04, 2010 7:38 pm

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 » Thu Dec 30, 2010 6:53 am

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: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks » Thu Dec 30, 2010 9:10 am

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 » Sun Jan 09, 2011 11:57 am

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 » Mon Jan 10, 2011 10:30 am

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: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Report of Insurance Plans by Benefit month/year

Post by jordansparks » Tue Jan 11, 2011 7:51 am

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

Post Reply