IT DSP Findings & Recommendations

Findings and Recommendations City of Berkeley: Digital Strategic Plan and Cost Allocation Plan

October 17, 2016 v5.1

Recommendations  Implement a new ERP Solution: Features/Functions  Integrated modules 

Consistent business rules and Standard Operating Procedures (SOPs).  Identify batches at the time of deposit, involving accounting in the process.  Adopt scanning on payment posting.  Adopt electronic lock box process.  Direct posting of payments.  Generate a TROD.  Automatic generation of delinquency notices.  Provide robust search tools.  Provide accounting based adjustment work flow.  Provide accrual basis of accounting.  Payments should work in multiple batches for one user.  Easily configurable  Ability to break out cash receipts consistent with subsidiary.  Provide automated bank reconciliation.  Embedded internal controls Interfaces  Accela  ETIMs  Wells Fargo  Official payment  Pay lock  Bank Up (Refuse payment) Benefits :  Happy customers/staff.  Staff time savings.  Eliminate timing discrepancy, eliminating need for adjustments.  Reconciliation process would be faster and easier.  Reduced errors.  More relatable detailed data, creating more confidence.  Accurate account balances.  Improved efficiency, preventing fraud and there is no need to create an Excel file.  Easier/timely collection has increased revenue.  No duplicate accounts, making it easier to find older accounts.  User/customer satisfaction.  Prepare CAFR from the system, reducing overtime.  Improved confidence of data.  Could provide salary increases for staff from cost savings.  Increased confidence in the IT department.  Clean audit opinion.  Possible increase in revenue.

Digital Strategic Plan: Findings & Recommendations

© 2016 97 ThirdWave Corp 11400 W. Olympic Blvd. Suite 200 Los Angeles CA 90064 310.914.0186 V 310.312.9513 F

Made with FlippingBook HTML5