--0000000000002f3b4d05e1fd7a43 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I will ask John Conaway about that Foley couple. Not sure what is going on there. *Cathy Goffredo* Regional Director PA & NJ C. 267-406-5844 *Note my new email address:cathy.goffredo@TheKey.com* *TheKey.com * [image: TheKey] On Tue, Jun 21, 2022 at 7:18 PM Angie Markwell wrote: > Please review and let me know if anything jumps out so i can respond. > > ---------- Forwarded message --------- > From: Benjamin Lewis > Date: Tue, Jun 21, 2022 at 12:20 AM > Subject: Re: Client Start Pricing Exceptions > To: Tad Smith > Cc: Brian Scott , Angie Markwell angie.markwell@thekey.com>, Chen Xie , Melissa Reyes melissa.reyes@homecareassistance.com>, Aileen Ruffin aruffin@homecareassistance.com>, David Durbin david.durbin@homecareassistance.com>, Melissa Reyes melissa.reyes@thekey.com>, Tad Smith , > Mitch Belitz > > > Hello all, > > The tracking spreadsheet has been updated with last week's data: > https://docs.google.com/spreadsheets/d/1dGnrZ6lUYwLL7rk8KLePG7uSU6Rb09Mfh= FSlWAxyhYc/edit?usp=3Dsharing > > The amount of pay associated without associated billing (excluding house > accounts with zero revenue) remained relatively flat week over week > ($18,609 vs $17,988, +3.4%). These are the five largest accounts with the= se > transactions from last week: > > Week of Shift Date Division Name Division Leader Business Unit Patient Id= Client > Name Sum of Caregiver Expense > 13-June N East Angie Markwell Alpine 3368777 Barbara & John Foley $666 > 13-June N California Chen Xie Craig Cares 5499041 Alicia Hall $606 > 13-June Southwest Melissa Reyes Orange County 4705496 Nancy Nakamura $484 > 13-June S East David Durbin South Carolina 4803198 Walter "Blackie" Cook > $450 > 13-June Central Aileen Ruffin Fort Worth 5772001 Leroy Leddon $443 > > I did receive feedback on a couple of the cases that there were a few > shifts that hadn't been closed out due to the time of the data being > pulled. Moving forward, I will publish this information on Tuesdays to > minimize this, but we are planning to review this data in the Executive > Team meeting tomorrow, so I wanted to ensure you all had some amount of > time to review beforehand. I look forward to any additional feedback make > this as actionable as possible for you and your teams. > > On Mon, Jun 13, 2022 at 5:22 PM Benjamin Lewis > wrote: > >> Hello all, >> >> I have updated the tracking spreadsheet here with last week's data: >> https://docs.google.com/spreadsheets/d/1dGnrZ6lUYwLL7rk8KLePG7uSU6Rb09Mf= hFSlWAxyhYc/edit?usp=3Dsharing >> >> To help try to narrow down the pay with no bill data, I have filtered ou= t >> all clients who do not have revenue booked against them and will include >> them in a separate tab moving forward. It seems to have reduced the amou= nt >> of house accounts included in the dataset drastically. Hopefully this >> change gives you and your teams better visibility into any exce