Select Page

May 2020 Add Expenses to Your Dashboard

Another way to manage your practice during covid-19 is to pay special attention to expenses.  Putting expenses from your accounting system on your dashboard is the topic of today’s BIG Idea podcast.  Many general ledger systems allow expenses to be subdivided by...

read more

May 2020 Patient AR

Today's BIG Idea is a couple of ideas around managing patient accounts receivable.  Of course it is best to collect as much as you can at the time of service, but unfortunately that still leaves money to be collected.  Listen for ideas on trending A/R balances,...

read more

April 2020 Filled vs Unfilled Appointments

Today's BIG Idea is a project I did last week to analyze filled vs unfilled appointment slots for a group that is trying to adjust their appointment templates in response to coronavirus.  The practice is trying to rebalance their templates in the short term to make...

read more

March 2020 Billing Office Productivity

The BIG Idea for today is from a practice that wants to allow employees to work from home, but at the same time wants to keep an eye on productivity.  I have built some SQL queries over the years to let them see the amount of charges, payments, adjustments, and notes...

read more

February 2020 3D Maps

Today's BIG Idea is to visualize your data, especially with Excel's 3D Maps feature.  I did this for a group in the Southeast the week before last.  If you haven't seen your Excel data in a map, here's a way to get started.  The group I was helping did billing for...

read more

January 2020 Prescriptions

Today's BIG Idea is a combination of several projects I'm working on to pull prescription data into a dataset and Pivot Table.  If you had all of your prescription data from the current year and the prior 2 years, what would you be able to see?  Opioids prescribed on...

read more

January 2020 Billing Audit

My friend David Zetter and I have helped a couple of practices with payer contracting questions lately.  In the process of analyzing their billing data to look for payer contracting issues, we have found significant issues with unpaid claims.  When was the last time...

read more

January 2020 Report Physician Comp Metrics

Happy New Year!  If one of your practice's new year's resolutions is to increase physician productivity or if you have recently changed your physician comp plan, this BIG Ideas podcast is for you.  Too many practices take too long to report back to providers on basic...

read more