Page 1 of 1

Collections Reporting

Posted: Thu Dec 17, 2015 8:18 am
by canyonfalls1
Hello

I am currently working on figuring out our collections percentage. I run our annual production and income report and then divide the "Total Income" column by the "Total Production" column to get my results. Is there a better way to get these results or is there another report that I should be using to get a more accurate result?

Thanks!

Re: Collections Reporting

Posted: Thu Dec 17, 2015 3:56 pm
by cmcgehee
It is difficult to get a meaningful collections percentage figure because the period that the collections occurs is different than the period that the production occurs. A number that is more helpful is the Collections Ratio. On our website in the last section of this page, http://www.opendental.com/manual/productionincome.html, there is an explanation of the significance of the Collections Ratio and the query used to calculate it.