MedLook Weekly Tip For 01/05/2007

The Patient sub-folders include seven (7) folders that show Insurance Aging:  Ins Aging Detail, Ins Aging, and Ins Aging X-Y (X-Y is 0-30, … 120+).  The Ins Aging folder begins the aging computation the moment you click on the folder.  All accounts are aged but only non-zero accounts will be displayed.  The information computed and displayed includes:  the primary and secondary insurance balances, 30, 60, 90, 120, 120+ day aging, basic patient contact information, and insurance contact information.  The aging values are a total of all amounts due from either the primary or secondary payors – nothing else.  This means the non-insurance payors (patient and Responsible Party) are not included in the calculation. Totals are computed in the footer for each column of data.

Below is a view of Ins Aging.

The Ins Aging 0-30, Ins Aging 31-60, Ins Aging 61-90, Ins Aging 91-120, and Ins Aging 120+ are aged according to their respective date ranges.  They show much of the same information as Ins Aging.

The Ins Aging Detail folder again ages only the insurance data but this report is significantly different from the others already mentioned.  To begin with the data is grouped by carrier and then by patient.  The patient header line contains the patient number, name, SSN, DOB, policy group number and number of aged procedures.  Each open procedure is displayed with the primary insurance due and aging values, the DOS, the procedure, and much more information (including secondary insurance).  Of course, the footers include totals for each grouping as well. This report is very handy.

Below is a view of Ins Aging Detail.

These folders can be very useful during a financial analysis of your business.

Email Us  Any questions, comments, or suggestions are welcome.