I am a numbers geek so when I am in an office working with
the doctor or office manager who loves to look at reports and numbers, I just
go crazy. That brings me to this week’s blog. Last week, I was working with an
office manager who takes all 12 of her fee schedules and manually enters them
into MS Excel so she can manipulate the numbers. She might add 5% to her UCR
fee schedule to see what it would do to their overall production or she might
see what it would do to the production if they just added 300 more sealants or
if they stopped charging for adult fluoride. She is a wizard with numbers and
forecasting what the changes in fees will do to their production. I was amazed.
However, she spends hundreds of hours inputting these fee
schedules into Excel. Out of the blue, she said, “It would be great if I could
export my fee schedules into Excel.” When I clicked on the button, she was the
happiest person in the room … which made me the happiest person in the room.
Maybe you are working with a company that is going to do
some negotiating of your fee schedules on your behalf or maybe you want to see
what it would look like if you put your UCR fee schedule in the 95% for dental
practices in your area and what that would do to your revenue. If you export
your fee schedules to Excel, you now have a more powerful tool and you can send
it in an e-mail to your consultant, accountant, or yourself to work on at home.
Here is how you do it . . .
Go to the Office Manager > Maintenance > Fee Schedule
Maintenance > then highlight the fee schedule you want to export (you can
select multiple by holding your CTRL key), then click on Export, save it to the
location of choice, and click OK. We just saved it to the desktop. Then double-click
on the file and it automatically launches MS Excel (assuming you have it
installed).
Hopefully I just saved you a bajillion amount of hours J
Dayna loves her work. She has over 25 years of experience in the dental industry, and she’s passionate about building efficient, consistent, and secure practice management systems. Dayna knows that your entire day revolves around your practice management software—the better you learn to use it, the more productive and stress-free your office will be. In 2016, Dayna founded Novonee ™, The Premier Dentrix Community, to help cultivate Dentrix super-users all over the country. Learn more from Dayna at www.novonee.com and contact Dayna at dayna@novonee.com.