Finding 479400 (2023-001)

-
Requirement
M
Questioned Costs
-
Year
2023
Accepted
2024-07-25
Audit: 315895
Organization: Midland County (MI)

AI Summary

  • Core Issue: The County reported inconsistent expenditure amounts in quarterly reports compared to the SEFA, primarily due to misreporting interest earned on advanced funds.
  • Impacted Requirements: This noncompliance affects the County's adherence to the Uniform Guidance for CSLFRF grant reporting.
  • Recommended Follow-Up: The County should ensure future quarterly reports are reconciled with prior SEFA amounts to prevent similar discrepancies.

Finding Text

Finding Type. Immaterial Noncompliance (Reporting). Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027. Criteria. CSLFRF grant recipients are required to file quartlerly reports that include period-to-date and cumulative expenditures. Condition. During our audit We noted a variance of between amounts report on the quarterly reports and amounts reported on the schedule of expenditures of federal awards (SEFA) over the life of the grant. This variance appears to be related to the expenditure of interest earned on advanced funds and thus is not reportable on the SEFA and should not be included in the quarterly reporting. Cause. This condition was caused by management oversight in not understanding fully the applicable reporting requirements. Effect. As a result of this condition, the County did not fully comply with the requirements of the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the County reconcile quarterly reporting with amounts reported on previous SEFA's. View of Responsible Officials. The County's system of internal control detected this error prior to commencement of audit procedures for 2023 and was corrected during the grant reporting process for the quarter ended March 31, 2024.

Corrective Action Plan

The County's system of internal control detected this error prior to commencement of audit procedures for 2023 and was corrected during the grant reporting process for the quarter ended March 31, 2024.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $5.61M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $188,280
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $148,804
16.738 Edward Byrne Memorial Justice Assistance Grant Program $110,609
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $87,501
11.469 Congressionally Identified Awards and Projects $67,409
20.509 Formula Grants for Rural Areas and Tribal Transit Program $53,742
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $36,300
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $34,368
97.067 Homeland Security Grant Program $33,119
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $32,267
93.069 Public Health Emergency Preparedness $30,174
93.563 Child Support Enforcement $26,071
93.788 Opioid Str $25,358
16.034 Coronavirus Emergency Supplemental Funding Program $24,642
97.042 Emergency Management Performance Grants $10,405
93.217 Family Planning_services $5,380
16.606 State Criminal Alien Assistance Program $4,979
10.555 National School Lunch Program $3,500
10.553 School Breakfast Program $2,800
93.268 Immunization Cooperative Agreements $2,481
93.994 Maternal and Child Health Services Block Grant to the States $2,200
93.778 Medical Assistance Program $1,777
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $620