This is a multipart message in MIME format. ------=_NextPart_000_0242_01D9C947.C4EE68C0 Content-Type: multipart/related; boundary="----=_NextPart_001_0243_01D9C947.C4EE68C0" ------=_NextPart_001_0243_01D9C947.C4EE68C0 Content-Type: multipart/alternative; boundary="----=_NextPart_002_0244_01D9C947.C4EE68C0" ------=_NextPart_002_0244_01D9C947.C4EE68C0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Happy Monday Everyone,=20 =20 Thank you for your patience as I worked through some technical issues today= . Please see the below summary by division for clients in need of attention= due to missing or incomplete mandatory documents in accordance with our on= boarding process. Also below is a breakdown of almost $96k open balance for= these client=E2=80=99s missing documentation listed by division. Please re= view and address the document attached in the link below, including any cli= ents with start months from Jan-Jun who account for over $59k of these open= balances. The deadline for July commissions is this Friday August 11th. P= lease reach out to me and Michelle Kenaga with any discrepancies or questio= ns. Please note changes made after the updated report has been generated wi= ll not be reflected until the client is re-audited and an updated report is= generated. =20 Please click here to review the updated audit tracker. =20 * West Division is leading the charge with the largest open balance at just= over $48k in total and over $30k open for clients with start dates in Jan-= Jun. * S East is in the lead for clients that have started services in need of a= ttention with 28 and the second largest open balance at over $25k in total = and over $12k open for clients with start dates in Jan-Jun. =20 Approx $96k open balance due for clients with a missing CCA or payment auth= orization forms. $59k open balance for clients with start dates in Jan-Jun. =20 =20 =20 Please note that recent Google updates has changed how the file appears whe= n you open it as a commentor. Once you open the Google Sheet you will need = to click the drop-down arrow on the right-hand side of the sheet to expand = the menu. This will allow you to download the spreadsheet by going to File = > Download > Excel (Snip included below for reference). You can also create= a new temporary filter view for the Google Sheet which will allow you to a= djust the filters on the Google Sheet using the icon that looks like a Goog= le Sheet/Calculator.=20 =20 Filtering Google Sheets in the new view Downloading document in the new view =20 =20 Thank you, Kristy =20 =20 From: kristy.poyner@thekey.com =20 Sent: Monday, July 31, 2023 10:08 AM To: michelle.kenaga@thekey.com; 'Northeast/Canada Regional Operation Direct= ors' ; 'Coddye Rin= g-Noonan' ; 'Gayle Soulides' ; 'Melissa Reyes' ; 'Angie Markwell' ; 'Ginger McVeigh' ; 'Audra= Williams' ; 'Alicia Broussard' ;= 'Alisha Wise' ; 'Amy Harris' ; 'Arac= eli Gutierrez' ; carol.miller@thekey.com; 'Ca= ssi Gilkeson' ; 'Cathy Goffredo' ; 'Christa Chalfa' ; 'James Buscemi'= ; 'Kim Kranwinkel' ; = 'Kimberly Guerci' ; 'Triff Cook' ; 'Y= ukari Roberts' ; bethann.rosario@thekey.com; 'Claudia = Hernandez' ; 'Matthew Neal' ; 'Jen= nifer Piper' ; 'Jessica Pascasio' ; 'Karoline Da Silva' ; dmockenhaupt@thekey.= com; 'Chen Xie' ; 'Matt Nyberg' ; 'Lei= gh Smith' ; krichard@thekey.com; 'Tiffany Sil= ton' ; 'Kirk Hayes' ; 'Grace Labrecq= ue' ; jennifer.geist@thekey.com Cc: 'Mandi Cheslock' ; 'Benjamin Lewis' ; 'Sarah Powers' ; 'Jennifer Allen' ; 'Alan Badger' ; 'Bri Bailey' ; tsmith@thekey.com; eclark@thekey.com; 'Cody Gardner' ; 'Laszlo Kovacs' ; 'Paul Kahn' ; 'Gerard Draetta' Subject: 7/31/23 - Action Required - $84k Open Balance - New Client Audit R= esults =20 Happy Monday Everyone,=20 =20 Please see the below summary by division for clients in need of attention d= ue to missing or incomplete mandatory documents in accordance with our onbo= arding process. Also below is a breakdown of over $84k open balance for the= se client=E2=80=99s missing documentation listed by division. Please review= and address the document attached in the link below, including any clients= with start months from Jan-Jun who account for over $59k of these open bal= ances. The deadline for July commissions is next Friday August 11th. Pleas= e reach out to me and Michelle Kenaga with any discrepancies or questions. = Please note changes made after the updated report has been generated will n= ot be reflected until the client is re-audited and an updated report is gen= erated. =20 Please click here to review the updated audit tracker. =20 * West Division is leading the charge with the largest open balance with ju= st over $39k in total and over $27k open for start dates in Jan-Jun. * S East is in the lead for clients that have started services in need of a= ttention with 29 and the second largest open balance with over $26k in tota= l and over $15k open for start dates in Jan-Jun. =20 Approx $84k open balance due f