Fwd: New Client Audit Results- Action Required

From
Angie Markwell <angie.markwell@thekey.com>
To
Kim Kranwinkel <kimberly.kranwinkel@thekey.com>, Kimberly Guerci <kguerci@thekey.com>, Cathy Goffredo <catherine.goffredo@thekey.com>, Jay Skypeck <jason.skypeck@thekey.com>, Audra Williams <audraw@thekey.com>, Timothy Thomas <tt@thekey.com>, Carol Miller <carol.miller@thekey.com>, Jennifer Muskat <jmuskat@thekey.com>, Jennifer Piper <jennifer.piper@thekey.com>
Date
Wed, 10 Aug 2022 23
Folder
INBOX
📎 image001.png; 8.5.22.LeaderUpdate_NewClientAudit.xlsx
I know you all may have received this - just making sure you see the
deadline and respond if needed before the deadline please.

From: <eclark@thekey.com>
Date: Fri, Aug 5, 2022 at 5:56 PM
Subject: New Client Audit Results- Action Required
To: Melissa Reyes <melissa.reyes@thekey.com>, David Durbin <
david.durbin@thekey.com>, Angie Markwell <angie.markwell@thekey.com>, Chen
Xie <chen@homecareassistance.com>, Audra Williams <audraw@thekey.com>,
Alicia Broussard <abroussard@thekey.com>, Alisha Wise <awise@thekey.com>,
Amy Harris <aharris@thekey.com>, Araceli Gutierrez <
araceli.gutierrez@thekey.com>, Bobby Kou <bkou@homecareassistance.com>, <
carol.miller@thekey.com>, Cassi Gilkeson <cgilkeson@thekey.com>, Cathy
Goffredo <cathy.goffredo@thekey.com>, Charlie Ferro <cferro@thekey.com>,
Christa Chalfa <cchalfa@homecareassistance.com>, Gail Carboy <
gcarboy@thekey.com>, James Buscemi <jbuscemi@thekey.com>, <
jmuskat@homecareassistance.com>, Kim Kranwinkel <
kimberly.kranwinkel@thekey.com>, Kimberly Guerci <kguerci@thekey.com>, <
laura.hintz@thekey.com>, Peggy Anderson <panderson@homecareassistance.com>,
Triff Cook <triff@thekey.com>, Yukari Roberts <yroberts@thekey.com>, <
bethann.rosario@thekey.com>, Jay Skypeck <jason.skypeck@thekey.com>,
Claudia Hernandez <chernandez@thekey.com>, <peter.dacosta@thekey.com>
Cc: <gscott@homecareassistance.com>

Hello All-

The linked spreadsheet has the details of our ongoing New Client Audit and
the details on missing documents as of 8/5. *We need your help to ensure
these items are updated/loaded by COB Friday 8/12 for any clients not
labeled as “Low Priority.”*

This is a manual audit we expect will evolve over time and appreciate your
feedback and participation in ensuring this is an efficient and effective
process as we distribute this on a weekly basis moving forward. We will be
auditing all clients on this file in two days so no need to reply as
documents are loaded/updated however, if you have questions or need
clarification, please feel free to reach out to me directly. Along those
lines, it’s our understanding these requirements should be known, however,
please feel free to reach out directly if you have any questions why these
are needed and critical to our business.

   - *When does Finance audit clients & when**?*
      - Clients are created in NetSuite when a client is moved to an
      Activated Status and has a Location assigned to their Client Profile in
      ClearCare. Finance audits new clients each Monday, for clients created in
      the prior Friday through Thursday week.
         - For example, on August 1st, we’re auditing clients created July
         22 – July 28sth

   - *All Clients should be set up with the below documents, tags, and
   basic demographic information before the first day of care:*
      - Signed Client Consent Agreement (CCA) in ClearCare
      - Signed Payment Authorization Form (PFA) in ClearCare or, a stored
      payment method in Versapay
      - Be tagged to their method of payment, which should mirror their PAF
         - Fiduciary, LTC-AOB, PMT-CC, etc.
      - Have an Address or Email on file (both are preferred) for the
      Client or Payer Contact for Invoice Delivery

Reading & filtering the audit file:

1.       *Location-* Filter for your Location(s) in Column E

2.       *CCA*-Filter column AF for a status of “Not Loaded” and “Loaded
but Incomplete” to determine which clients need their CCA loaded/updated.

§  Loaded but Incomplete would imply the form is blank, or missing
signature.

3.       *PAF*- Filter column AG for a status of “Not Loaded” and “Loaded
but Incomplete” to determine which clients need an PAF loaded/updated.

§  Loaded but Incomplete would imply the form is blank, missing signature,
or that the account information is invalid or expired

§  If a client has their payment method stored in Versapay, this item is
marked Accurate & Complete, and the location is not marked negatively for
the audit.

§  If the client is paying via check due to a Fiduciary set up, Facility
Billing, or was approved by Finance Leadership the PAF should be loaded
with “Check Exception” written on the PAF

1.       This is new, but is the only way to ensure Finance is aware
approval was obtained by Gary Scott or Brian Scott

4.       *Tags*- Filter column AH for a status of “Not Loaded” and “Loaded
but Incomplete” to determine which clients need their Tags updated to
mirror their PAF.

§  These should be outstanding until the PAF is loaded and
validated/accurate

5.       *Invoice Delivery-* Filter column AI for “No Address or Email for
Client or Payer” to determine which clients need their contacts updated
and/or their basic demographics added in ClearCare.

§  NetSuite will use the Payer (not e-payer or any other contact type)
address and email.

§  If there is no Payer, NetSuite will use the Client address and email. If
neither are found this means there is no reliable method of emailing or
sending invoices via USPS mail.

§  We add any contacts marked as “Email Invoices” to Versapay directly
however, changes to those contacts will not push to NetSuite daily
therefore it’s critical we use the Client & Payer fields. This allows the
local team ownership over updates without requiring emails or manual
updates by the Finance Teams. If applicable, the “Email Invoices” Contacts
should be updated to a “Payer” to ensure changes to the Payer are
automatically fed to the Versapay billing system.

6.       *First Scheduled & Completed Date*- View Column AM to help
determine the level of priority and/or delay in set up by viewing the 1st
Scheduled & Completed date in CC

Below is a summary of the success rate for each required item by specific
Location, and a percentage of improvement when reviewing 7/25 versus 8/4

*Location Updates 7/25 versus 8/4*

*Signed Consent Agreement on File?*

*% Change*

*Valid Payment Authorization on File? *

*% Change*

*Payment Tags selected*

*% Change*

*Address or Email On File for Client or Payer*

*% Change*

123 Home Care

94%

8%

81%

-1%

84%

-3%

97%

-3%

Annapolis

100%

7%

100%

13%

100%

13%

94%

-6%

Atlanta

85%

-5%

89%

-1%

89%

-7%

100%

0%

Austin

68%

-10%

68%

-10%

68%

-10%

91%

-10%

Bay Area North

66%

4%

63%

7%

63%

7%

95%

-1%

Palm Beach

93%

3%

91%

4%

93%

1%

98%

-2%

BERGEN

100%

10%

91%

23%

100%

10%

100%

0%

Bethesda

64%

-18%

55%

-38%

55%

-38%

100%

0%

Boca Raton

80%

25%

80%

25%

80%

25%

100%

20%

Boise

90%

-11%

70%

-2%

70%

-2%

100%

0%

Broward County

67%

50%

50%

100%

67%

50%

100%

0%

Carmel/Monterey

83%

-20%

83%

-20%

83%

-20%

100%

0%

Central LA

78%

4%

67%

0%

72%

8%

94%

3%

Central NJ

95%

-6%

89%

-2%

95%

3%

95%

-6%

Charleston

100%

0%

75%

-33%

100%

0%

100%

0%

Chicago

65%

-8%

61%

-16%

61%

-16%

96%

-5%

Clemson

100%

0%

100%

0%

100%

0%

100%

0%

Cleveland

100%

0%

50%

-100%

50%

-100%

100%

0%

CNRS

88%

-3%

88%

-3%

88%

-3%

83%

-20%

Colorado

83%

10%

50%

0%

67%

-13%

100%

0%

Colorado Springs

100%

0%

100%

0%

100%

0%

100%

0%

Columbus

60%

0%

40%

0%

40%

0%

100%

0%

Daughterly Companions

78%

20%

78%

36%

44%

72%

100%

0%

East Bay

86%

2%

83%

-2%

81%

-4%

93%

-7%

ECS GCM Clearcare

100%

0%

100%

0%

100%

0%

100%

0%

Fairfield

100%

25%

100%

25%

100%

25%

100%

25%

Frederick

50%

20%

67%

40%

67%

40%

100%

0%

Grand Rapids

85%

0%

81%

0%

82%

-1%

100%

1%

Milwaukee

100%

17%

90%

7%

90%

7%

100%

17%

Midland

80%

4%

48%

3%

48%

3%

100%

1%

Grand Strand

60%

-25%

70%

-43%

70%

-43%

100%

0%

Greenville

67%

0%

67%

0%

67%

0%

100%

0%

Hartford

89%

13%

89%

13%

89%

13%

100%

22%

Help at Home

50%

-33%

25%

-33%

25%

-33%

100%

0%

Houston

100%

0%

100%

6%

100%

0%

100%

0%

Indiana

100%

0%

100%

0%

100%

0%

100%

0%

Kansas

100%

20%

71%

44%

71%

44%

100%

20%

Kenwood

71%

16%

86%

30%

86%

30%

86%

-17%

Lake Oswego

86%

-17%

86%

-17%

86%

-17%

100%

0%

Las Vegas

40%

-150%

60%

-67%

60%

-67%

100%

0%

Los Gatos

91%

-10%

86%

-9%

86%

-9%

95%

-5%

Lynchburg

88%

-2%

69%

-29%

81%

-23%

100%

0%

McKinney

80%

-25%

60%

-11%

60%

-11%

100%

0%

Mesa

75%

11%

75%

11%

75%

11%

100%

0%

Millenia

100%

0%

100%

0%

100%

0%

100%

0%

SPS - Santa Barbara

100%

0%

100%

0%

100%

0%

100%

0%

N. Fort Worth

50%

33%

33%

0%

33%

0%

100%

0%

Napa

69%

21%

56%

19%

69%

21%

100%

18%

Naples (Help At Home)

79%

-2%

75%

0%

75%

0%

96%

1%

Nassau

100%

0%

100%

0%

100%

0%

100%

0%

Newport

75%

-5%

70%

18%

70%

8%

100%

0%

Northern Virginia

68%

-4%

55%

-8%

55%

-8%

100%

0%

North LA

100%

0%

100%

0%

100%

0%

100%

0%

Palm Desert

100%

0%

75%

-33%

75%

-33%

100%

0%

Park Vista NP

50%

100%

50%

100%

50%

100%

100%

0%

Pennsylvania

100%

0%

91%

-10%

91%

-10%

65%

8%

Puget Sound

98%

15%

88%

22%

90%

20%

98%

-2%

Raleigh

95%

2%

75%

-14%

80%

-16%

100%

0%

Riverside

50%

-100%

50%

-100%

50%

-100%

100%

0%

Roanoke

95%

2%

85%

6%

90%

4%

100%

0%

Rockwall

100%

0%

100%

0%

100%

0%

100%

0%

Roseville

70%

29%

70%

29%

70%

17%

95%

4%

Salt Lake

100%

0%

100%

0%

100%

0%

100%

0%

San Antonio

78%

-29%

78%

-29%

78%

-29%

100%

0%

San Diego

88%

-5%

94%

-7%

94%

-7%

100%

0%

San Dimas

80%

0%

80%

-25%

100%

0%

100%

0%

Santa Rosa

95%

-6%

58%

-30%

63%

34%

100%

0%

Sarasota

55%

-67%

50%

-9%

50%

-27%

100%

0%

Scottsdale

56%

10%

67%

25%

67%

25%

100%

0%

South bay

80%

-25%

100%

0%

100%

0%

100%

0%

Southern NJ

85%

14%

77%

17%

77%

17%

85%

3%

Spokane

89%

13%

68%

19%

79%

16%

100%

0%

Springfield

82%

-22%

73%

-15%

82%

-22%

100%

0%

SRG SB

100%

0%

100%

0%

100%

0%

100%

0%

SRG SC

100%

0%

100%

0%

100%

0%

100%

0%

St. Louis

100%

0%

100%

0%

92%

5%

100%

0%

Steps Home Care

100%

0%

100%

0%

100%

0%

83%

-20%

Suffolk County

100%

13%

100%

13%

100%

13%

100%

13%

The Peninsula

97%

7%

89%

14%

91%

17%

97%

12%

TRDS

75%

100%

75%

-33%

75%

-33%

100%

0%

Virginia Beach

67%

-25%

67%

-13%

67%

-13%

100%

0%

VNA New Jersey

100%

0%

75%

0%

100%

0%

100%

0%

Wellesley

67%

-13%

67%

-13%

67%

-50%

100%

0%

West Chester

75%

-33%

75%

-33%

75%

-33%

100%

0%

SRG CAL

100%

0%

100%

0%

100%

0%

100%

0%

Life Matters

0%

#DIV/0!

0%

#DIV/0!

0%

#DIV/0!

100%

0%

Canoga Park

100%

0%

50%

100%

50%

100%

100%

0%

Average Success Rate

83%

76%

78%

98%

Kind regards-

Elizabeth Clark

*Sr. Manager, Continuous Improvement *

*TheKey*

Office|Cell : 619-822-4855

eclark@thekey.com

*TheKey.com <https://www.thekey.com/>*

[image: TheKey] <https://homecareassistance.com/>