Net Collections Report

[cmclean]

I am looking for a report to aide in a bonus calculation.  I need to obtain net collections by posting date for a specific service date.  Example:  bonus period starts 7/1/18; at the end of the third quarter I need to be able to run a net collections report for all monies collected on service dates 7/1/18 and after (not collections posted in July for services dates prior to July)  Thank you in advance for any assistance.  

[nancyandrews]

Did you ever find a solution to this? I have a provider whose comp method changed as of 1/1. He was paid on production PRIOR to 1/1 and is now being paid on collections. We want to avoid paying him on collections for services that he has already been paid on production for. HELP!!! I don't want to do this by hand!!!!

[cmclean]

Unfortunately not, I had to create a entire new doctor in the system to be able to track effectively.

[matt_ackerman]

help me understand what you are calculating here -- is it a bonus on the amount of (or percentage of) collections done on a patient balance that happens within the same calendar month?  Is this to encourage full collection of outstanding balances at the time of surgery?  Therefore there is no bonus for payments collected on "old" services?

After some tinkering, I do not think there is a report that can generate this kind of result.  I also tried using our data export, creating a transaction list, but the payments are not referencing what transaction they are distribute to.  It sounds like the best report would give you a list of "distributions" of payments that occurred during this month (or any specified month) to charges that happened this month (or any specified month).  Correct?

[nancyandrews]

Matt - thanks for looking in to it. Yes, this provider was paid a bonus on production PRIOR to 1/1/19 and now gets paid on collections. His contract with us changed as of the 1st of the year. So basically, let's say the doctor did a service on 12/1/18. He received a bonus on the production for that procedure. Now on 1/25/19 we get paid for the services done on 12/1/18. Technically, he would get a bonus AGAIN because now he is on collections model. We want to make sure he doesn't receive a bonus TWICE for the same DOS. It would be great if there was a payment transaction report that showed the DOS the payment was distributed to. Which I believe is what you are saying below. For the time being we are going to run a daysheet for payments by month and review each account. I'm not really looking forward to this but think this is the only way.

[ajohnson87]

The only report I think that may be able to help with this would be to run a Day Sheet (Reports>>Daily>>Day Sheet) and adjust the dates to cover the range you are looking for. It can become a lengthy report but on the last page it shows the amounts collected under the Payments column. You could print off the last page only or just view it as a Print Preview to see the amount collected. I hope this may help!

[ajohnson87]

Sorry, I think I may have misunderstood what you were looking for. I'll keep looking as I believe you want all money taking in for the dates of service for the 3rd quarter only, not including payments that were taken in the 3rd quarter but are from dates of service prior to the 3rd quarter (referencing your example)

[cmclean]

Hi Amy Jo, Thank you for taking the time to respond. Yes you are correct on your second reply. I feel like I am beating my head against the wall on this one.