2022-001 WIOA Cluster ? Assistance Listing No. 17.258/.259/.278COVID-19-Coronavirus State and Local Fiscal Recovery Funds ? Assistance Listing No. 21.027Aging Cluster ? Assistance Listing No. 93.044/.045/.053Recommendation: We recommend that the County improve its SEFA compilation process to ensure ...
2022-001 WIOA Cluster ? Assistance Listing No. 17.258/.259/.278COVID-19-Coronavirus State and Local Fiscal Recovery Funds ? Assistance Listing No. 21.027Aging Cluster ? Assistance Listing No. 93.044/.045/.053Recommendation: We recommend that the County improve its SEFA compilation process to ensure that program expenditures reported on the County?s SEFA are complete and accurate. Procedures and controls should include a process to identify programs that are new to the County and ensure they are properly reported on the SEFA.We further recommend that County?s Office of Budget and Finance (OBF) work with the County?s agencies and departments to review and update their SEFA review and confirmation procedures to ensure that expenditure information they submit to OBF is accurate, that it includes all programs expended, and ties to detail expenditure transactions in the County?s accounting system. They should also review and enhance procedures and controls to ensure that subrecipient payments are accurately reported.Explanation of disagreement with audit finding: There is no disagreement with the audit finding.Action taken in response to finding: On July 1, 2022, Baltimore County deployed Workday Financials, as a replacement for the legacy ERP system, known as CGI Advantage. The Workday system is configured in a way that silos all Federal grants or portions of grants into one fund for reporting purposes. This new configuration captures all award information including CFDA number, Grantor, and Federal/State Grant Number is captured. Additionally, all subrecipients are managed through a Supplier Contract and are categorized as such. This system implementation will ensure accurate and efficient reporting as it related to the SEFA compilation and Subrecipient reporting.Furthermore, DEWD will provide OBF the reports and cost pools to support grant draws on a quarterly basis to assist OBF in the preparation of the Schedule of Expenditures of Federal Awards. DEWD will prepare grant closeout expenditure adjustments (journal entries) on a timely basis. DEWD reviews expenditures to ensure grant eligibility and proper posting to the correct grant. On a quarterly basis, DEWD performs a reconciliation of grant expenditures during preparation of the grant draw reports. OBF will not certify any quarterly cash draws that do not tie back into the general ledger.Name(s) of the contact person(s) responsible for corrective action: Robert Preston, Leonard Howie, Angelique Pefinis-Newport, Terry HickeyPlanned completion date for corrective action plan: 8/1/2023