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
Forecasting how a change in fees will affect your production
0 comments:
Post a Comment