Medical Billing Forum

General Category => General Questions => Topic started by: SLITTLES on February 07, 2012, 12:34:03 PM

Title: Aged Claims
Post by: SLITTLES on February 07, 2012, 12:34:03 PM
Hello All,

Is there a magic formula that tells which percentage of accounts rolled from one aging bucket to another?  For example the % of claims that rolled from 30 to 60 days.

Thanks in advance for all you help  :)
Title: Re: Aged Claims
Post by: Michele on February 14, 2012, 10:46:57 AM
Not sure I know what you mean.....do you mean on the aging reports how the software determines what is 0-30, 30-60, etc???
Title: Re: Aged Claims
Post by: SLITTLES on February 16, 2012, 10:20:48 AM
Michelle, that's not what I meant...but thank you!!

In reality I am dealing with an Office Manager that lives, breathes and eats formulas.  She always ask for the impossible and I simply told her that I couldn't do what she was asking for
Title: Re: Aged Claims
Post by: PMRNC on February 16, 2012, 11:06:49 AM
I think what you want is to tell her, for example:  30% of our accounts were sent over to 90 days past due.  Right?   If so.. I would tell her this is where she needs her simple math skills :)    she'll just have to compare the aging report buckets (30, 60, 90) and then figure out the %.   Not sure why it matters to her but still it's simple math.