jesseroads
New Member
- 2
Hi all,
New member here. I've built a collections estimate calculator in excel as part of my job. We do intake for a number of treatment centers around the country and would like to accurately quote a caller on how much treatment will cost them, and the particular treatment center on how much they can expect to collect from insurance.
I'm stuck on one technical point. Let's say that a client's DED will be met part of the way through a particular service on a particular day. 32 minutes into receiving group therapy on a Tuesday, suddenly that client's DED is met! So, Does the client also pay a copay on that day? What if the DED is met after only 3 minutes in group therapy on that day... the client's payment for that day won't even meet the amount of the copay!
It's possible that different insurance companies handle this situation differently, but I'm hoping that there's a general rule, as I don't want to code that much into excel! Thanks to any replies!!!
New member here. I've built a collections estimate calculator in excel as part of my job. We do intake for a number of treatment centers around the country and would like to accurately quote a caller on how much treatment will cost them, and the particular treatment center on how much they can expect to collect from insurance.
I'm stuck on one technical point. Let's say that a client's DED will be met part of the way through a particular service on a particular day. 32 minutes into receiving group therapy on a Tuesday, suddenly that client's DED is met! So, Does the client also pay a copay on that day? What if the DED is met after only 3 minutes in group therapy on that day... the client's payment for that day won't even meet the amount of the copay!
It's possible that different insurance companies handle this situation differently, but I'm hoping that there's a general rule, as I don't want to code that much into excel! Thanks to any replies!!!