Tuesday, January 26, 2016

Forecasting how a change in fees will affect your production

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 Johnson, Certified Dentrix Trainer
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.