--000000000000cd1f65063154a523 Content-Type: multipart/alternative; boundary="000000000000cd1f64063154a522" --000000000000cd1f64063154a522 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Tim/Steve, The difference we are seeing between Clearcare and our Tableau reports (and Planful) is related to the Couples care client Sandra Cianciolo. As I referenced in the earlier email if a shift does not have revenue associated, it is not counted in the billed hours. The screenshot from Clearcare in the previous email showed the total hours for Sandra for the month, but did not include the details. When we pulled the detail from Clearcare it showed only some of the hours with revenue. See the attached screenshot. The yellow highlighted shifts are not counted towards billed hours. If you remove those hours from the total it comes out to around 121 hours for Sandra rather than the 235.8. If this client should be billed differently, that is up to our policy and procedures which I can't speak to. But as far as reporting, this is how the company has decided to count billed hours. I hope this helps clear things up. Let me know if you have any additional questions or requests. [image: image.png] Donny VP, Data and Analytics *225.916.9227 * On Thu, Mar 6, 2025 at 3:05=E2=80=AFPM Timothy Thomas wrote= : > Hi Donny, > > Were you able to identify the discrepancy between clearcare and > tableau around billable hours for Cleveland? > > On Fri, Feb 28, 2025 at 5:25=E2=80=AFPM Steve Sudberry > wrote: > >> It doesn't clear it up. I filtered out the non-billable client. See th= e >> Wellsky screenshots attached. >> >> Billed Hours Wellsky Tableau Target >> Cleveland 3,975 >> VNA of Ohio 1,184 >> Total 5,159 5038 5099 >> >> >> [image: image.png] >> [image: image.png] >> >> Steve Sudberry >> General Manager/Partner >> >> ssudberry@thekey.com >> (513) 227-8521 >> TheKey.com >> [image: TheKey] >> >> >> On Fri, Feb 28, 2025 at 4:35=E2=80=AFPM Timothy Thomas w= rote: >> >>> Does that clear it up Steve? >>> >>> On Fri, Feb 28, 2025 at 4:03=E2=80=AFPM Donny Deshotels >> donny.deshotels@thekey.com> wrote: >>> >>>> The only difference I'm aware of is where the shift has $0 revenue. >>>> Those are not included in our dashboard hours, but you have to filter = them >>>> out of the Wellsky reports. Those include orientation, training, and >>>> non-billed services. >>>> >>>> Donny >>>> VP, Data and Analytics >>>> *225.916.9227 * >>>> >>>> >>>> On Fri, Feb 28, 2025 at 2:10=E2=80=AFPM Timothy Thomas = wrote: >>>> >>>>> @Donny Deshotels Could you please help >>>>> us understand the difference in January hours for Cleveland between T= ableau >>>>> and Wellsky? >>>>> >>>>> On Fri, Feb 28, 2025 at 2:17=E2=80=AFPM Steve Sudberry >>>>> wrote: >>>>> >>>>>> The billed hours in Wellsky are more than the billed hours in >>>>>> Tableau. Wellsky billed hours met the goal, Tableau didn't. We bil= l from >>>>>> Wellsky hours. >>>>>> >>>>>> >>>>>> Steve Sudberry >>>>>> General Manager/Partner >>>>>> >>>>>> ssudberry@thekey.com >>>>>> >>>>>> (513) 227-8521 >>>>>> TheKey.com >>>>>> [image: TheKey] >>>>>> >>>>>> >>>>>> On Fri, Feb 28, 2025 at 1:01=E2=80=AFPM Timothy Thomas wrote: >>>>>> >>>>>>> What is the technical issue? >>>>>>> >>>>>>> On Fri, Feb 28, 2025 at 12:37=E2=80=AFPM Steve Sudberry >>>>>> ssudberry@thekey.com> wrote: >>>>>>> >>>>>>>> Tim, >>>>>>>> >>>>>>>> I don't fully understand the discrepancy between Tableau and >>>>>>>> Wellsky. However, due to technical issues, I want Cleveland to kee= p their >>>>>>>> January billed hours key. >>>>>>>> >>>>>>>> Thanks >>>>>>>> >>>>>>>> Steve >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> ------------------------------ >>>>>>>> >>>>>>>> >>>>>>>> Steve Sudberry >>>>>>>> General Manager/Partner >>>>>>>> >>>>>>>> ssudberry@thekey.com >>>>>>>> >>>>>>>> (513) 227-8521 >>>>>>>> TheKey.com >>>>>>>> [image: TheKey] >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Feb 26, 2025 at 2:45=E2=80=AFPM Timothy Thomas >>>>>>>> wrote: >>>>>>>> >>>>>>>>> For couples care clients, it is standard billing practice to >>>>>>>>> combine the care and generate only one set of billable hours. The= refore, we >>>>>>>>> are unable to separate these hours into two individual client rec= ords with >>>>>>>>> duplicate hours. >>>>>>>>> >>>>>>>>> On Wed, Feb 26, 2025 at 1:04=E2=80=AFPM Julie Sminchak >>>>>>>> julie.sminchak@thekey.com> wrote: >>>>>>>>> >>>>>>>>>> Michael is being charged 34.00 an hour at this time and Sandra i= s >>>>>>>>>> being charged 7.00 a hour for a couple care. >>>>>>>>>> We were charging just Michael 41.00 a hour which included Sandra= . >>>>>>>>>> We didn=E2=80=99t know we had to charge Sandra separately becaus= e billing told us >>>>>>>>>> when we started this we had to bill it to just Michael. >>>>>>>>>> Thank you >>>>>>>>>> Julie Sminchak >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> *Julie Sminchak, LPN**General Manager/**Client Care Manager * >>>>>>>>>> *@ The Key* >>>>>>>>>> 5350 Transportation