HomeMy WebLinkAbout09.a EDB ERP Board Briefing Final EXECUTIVE SUMMARY
AGENDA ITEM:
Enterprise Resource Platforms (ERP) Project Update
Date: May 17, 2024
UPDATE:
CCUA went live with the new Customer Information System and customer portal with SpryPoint on April
22,2024.We also implemented Workday our new human resource and financial management systems and
InvoiceCloud as our new payment processor.
Customers continue to respond and register their accounts through our new customer portal. As of
Thursday,May 16th,the number of customers who activated their accounts in the new customer portal was
14,776 (19.7%). In addition, we observed an increase in total AutoPay customers of 1,924 accounts.
We continue to experience high call volumes for assistance registering withe the new customer portal.At
times, all our phone lines are occupied with callers who experienced significant wait times. To address
this issue, we continue to redirect team members to assist the Customer Service and Billing Department.
Staff indicates the trend in the volume of calls and emails is downward indicating positive movement to
the new customer portal.
We also continue to experience elevated numbers of customers visiting our office. Many of the customers
are visiting for assistance to set-up their accounts in the new system due to the wait times experienced
when calling the office. Our team reports that customer visits to set-up their accounts generally take 10 to
15 minutes which further strains the availability of our staff. To address this issue, we set-up an area in
the lobby where a member of our team is dedicated to helping customers specifically with account set-up
questions and issues.
Our team completed billing for the month of April in four (4) of the five (5) billing cycles. Each billing
cycle represents a geographic area along with a certain number of customers to facilitate timely response
times from the meter reading and data exchange between platforms.Four(4)billing cycles were completed
without issue. The fifth billing cycle is experiencing data corruption issues between CCUA and our bill
vendor Infosend. Our team is engaged with Infosend to address this issue as quickly as possible.
At the last Board meeting, we reported a technical issue regarding the incorrect data mapping between
SpryPoint and InvoiceCloud that impacted 610 customers. InvoiceCloud correctly matched 19 payments
and 546 payments were transferred to the appropriate customer account. The remaining 45 unmatched
payments were returned to the original payee. The way the 546 payment transfers were reported on the
customer statements was confusing. We prepared apology letters to the customers affected by this issue.
We are also working with SpryPoint to correct the reporting of payment transfers for the future.
The next issue we experienced involved payments made by 136 customer accounts. Due to the customer
matching issue previously mentioned, InvoiceCloud's payment matching system was turned off. When
//JDJ(Author)
//KO/AB (Review)
//JDJ(Final)
the previous issue was resolved the matching was supposed to be turned back on and then the 136
payments were to be matched. InvoiceCloud ran into an issue on their end and did not communicate this
delay and the payments were returned without a notification or reasoning. We prepared apology letters to
the affected customers explaining the issue and requesting they resubmit their payments.
We experienced an issue with a delay in InvoiceCloud remitting payments to CCUA totaling roughly
$300,000.We understand this issue centered on InvoiceCloud's system and their account with Chase Bank.
While the $300,000 in payments was eventually remitted to CCUA, we continue to engage InvoiceCloud
regarding timely remittance of payments.
With the update to the Board of Supervisors at the last meeting, we noted the issue of reconciliation
transactions between the platforms of SpryPoint, InvoiceCloud, and Workday. The technical teams
continue to work on this issue. As of the writing of this executive summary, the technical teams have not
completed a workable automated solution.
Our team focused considerable effort coordinating with InvoiceCloud.An issue we are experiencing with
InvoiceCloud centers on their inability to provide technical experts on scheduled coordination calls to
quickly resolve issues. Our team stated the technical and customer support being received by InvoiceCloud
can be characterized as poor.Our team will continue to engage with InvoiceCloud for their team to perform
their contracted services. If the issues we are experiencing with InvoiceCloud persist,we will return to the
Board of Supervisors with further information along with a potential course of action.
We reported an issue with the payment to vendors at the last Board of Supervisors meeting. Our team
coordinated with our bank regarding this issue. The issue centered on the bank's system dropping
electronic transactions, not CCUA's new system with payments through Workday. To our knowledge, this
issue has been resolved.
As previously reported, we understand the biggest point of frustration remains the $1.50 charge from the
payment processor for e-checks. While our team has offered alternatives for customers to avoid this
charge, we continue to receive complaints about the charge.
Our team remains engaged with the technical teams to address the technical issues stated above. In
addition, we continue to coordinate with the Dalton Agency regarding a balanced approach of individual
customer communications and much broader social media communications.
RECOMMENDATION:
Staff does not have any recommended action items at this time.
//JDJ(Author)
//KO/AB (Review)
//JDJ(Final)