Corrective Action Plan: OCD anticipates utilizing the following protocol to resolve the finding: Step 1 and Future The Ohio Department of Development is under contract with a consultant to build OCD?s new grant management system and migrate out of OCEAN. Neither enhancing existing reports nor build...
Corrective Action Plan: OCD anticipates utilizing the following protocol to resolve the finding: Step 1 and Future The Ohio Department of Development is under contract with a consultant to build OCD?s new grant management system and migrate out of OCEAN. Neither enhancing existing reports nor building new ones in OCEAN are feasible options at this point. The new system will allow OCD to have control in building custom reports to meet numerous needs. OCD also anticipates having increased automation features, enhanced validations, and data linkage on a broader spectrum. All these aspects will reduce the risk of error and will allow for reporting on precise information to assist in the new reconciliation process which will be structured as follows. A. New system reports will be pulled by Senior Financial Analysts and compared with the IDIS PR28 report and OAKS data once per quarter for each funding source. B1. If there are no discrepancies, the reconciliation will be logged in the system with the date and time it occurred. End. B2. If there are discrepancies, the Senior Financial Analyst will meet with the Operations Manager to present the discrepancies and determine if there is a quick explanation. C1. If so, the resolution will be logged. Adjustments will be made accordingly and documented. End. C2. If not, create a plan of action for a deeper dive. Continue to circle back and alter the plan of action until the source of the discrepancy is found, adjustments are made and actions are logged. End. Step 1 is complete in the sense that there is a contract in place for a new grant management system that will provide OCD with tools necessary to carry out reconciliation procedures accurately and efficiently on a regular basis. OCD will meet with the consultants to inquire about the system?s capability of storing historical data to access historical reports. The future of the resolution is outlined within A. through C2 after the system is built. It is too early in the program development to provide names for the new reports. Step 2 and Present In the meantime, while the system is being built, the Operations Manager and Staff will collectively utilize a more manual process that will include pulling the current PR28 report from IDIS to reconcile with OCEAN and OAKS data for the grants listed in this finding. Report options are limited in OCEAN, therefore, it may be necessary for staff to maneuver through layers throughout the projects? data. After the discrepancies are found, adjustments are made, and actions are logged. A follow-up response will be submitted along with necessary documentation to evidence the grants have been reconciled and all systems and reports match. Anticipated Completion Date for Corrective Action: December 2023 Contact Person Responsible for Corrective Action: Talia D. Givens-Gore, Program Operations Manager, Ohio Department of Development 77 South High Street, 26th floor, Columbus, Ohio 43215 Phone Number: 614-728-8140, E-Mail Address: Talia.Givens-Gore@development.ohio.gov