Medical Billing Forum

General Category => General Questions => : SLITTLES February 07, 2012, 03:34:03 PM

: Aged Claims
: SLITTLES February 07, 2012, 03: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  :)
: Re: Aged Claims
: Michele February 14, 2012, 01:46:57 PM
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???
: Re: Aged Claims
: SLITTLES February 16, 2012, 01:20:48 PM
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
: Re: Aged Claims
: PMRNC February 16, 2012, 02:06:49 PM
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.