Library


Monthly Management Reports




In past issues of this newsletter, we’ve worked through the methodology to use in the analysis of your practice’s financial performance. In the next two issues, we’ll look at a set of regular management reports formatted for review by you and the physicians in your practice.

The reports to consider include the following:

Income

  • Product-line
  • Productivity
  • Payor-mix
  • Collection performance
  • Accounts Receivable


Expense

  • Expenses as a percent of income

First, a review. In order to have meaningful management reports, the setup of your computer system is critical (see the March 13, 2000 issue of this newsletter). Particular emphasis should be placed on your assignment of each insurance plan to a payor class based on expectation of payment.

Second, remember that some of the reports we discuss here will have to be generated manually, using data from your computer billing system. These may include your product-line, productivity, and payor-mix reports, as well as a summary table of collection performance.

Third, keep in mind the purpose of this report set. It should be a concise snapshot of the performance of the business of the practice, and it should be reviewable in 15 to 30 minutes. This report set should be distinct from the reports you generate for managing your billing operation and for collecting receivables.


The first issue of Watching Your Bottom Line explained this report. To review, it can be presented in major categories and subcategories with volumes expressed as the number of charges, dollars charged, and RVUs. The categories and subcategories are arrayed in a chart as in the following example:

 Number This MonthNumber YTDNumber YTD Last YearCharges This MonthCharges YTDCharges YTD Last YearRVUs This MonthRVUs YTDRVUs YTD Last Year
I. Medical-surgical
a. Encounters
i. Total new patients
1.Office consults
2. Hospital consults
3. New patient office visits
ii. Total established patients
1. Post-operative (no charge) visits
2. Total established patients
3. Total patient encounters
b. Surgeries
i. Total surgeries
1. Total office surgeries
a. Lasers
b. Minor surgeries (chalazion, etc.)
2. Total hospital surgeries
a. Cataracts
b. Other surgeries
II. Vision (routine eye exams and refractions)
a. Vision exam
b. Refractions only
III. Dispensing (eyeglasses and contact lenses)
a. Contact lenses
i. Fitting and serviceN/AN/AN/A
ii. RefillN/AN/AN/A
b. Eyeglasses
i. Number of frames soldN/AN/AN/A
ii. Single vision lensesN/AN/AN/A
iii. Progressive lensesN/AN/AN/A
iv. Frame upgradesN/AN/AN/A
IV. Refractive surgery (# of eyes)N/AN/AN/A
V. Cosmetic surgery (# of cases)
VI. TOTAL CHARGESN/AN/AN/A

In this report (originally covered in the May 19, 1999 issue of Watching Your Bottom line), insurance plans are assigned to categories and tracked to define the characteristics of the practice’s “customers.” The data can be displayed as follows:

PayorClassCharges
(1/1/98-12/31/98)
Mix Medicare$680,00034%
Medicaid$100,0005%
Medicare/Medicaid$40,0002%
Contracted Fee-For-Service$620,00031%
Indemnity$40,0002%
Workers Compensation$80,0004%
Capitation – Commercial$160,0008%
Capitation – Senior$260,00013%
Self Pay$20,0001%
TOTAL Charges$2,000,000100%

This distribution is tracked over time. Additionally, it can be displayed in a chart as follows:


These reports describe the practice’s clinical activity and patient type. In the next issue we’ll put these reports together and show how to describe the examination of the charges generated by this activity, of the collections from these charges, and of the collection performance on charges from earlier time periods.



Leave a Reply