Finding 568845 (2024-005)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-06-30
Audit: 360575
Organization: County of Berrien (MI)

AI Summary

  • Core Issue: The County failed to file the required second quarter Project and Expenditure report for the CSLFRF grant, leading to noncompliance.
  • Impacted Requirements: Quarterly reporting obligations for the Coronavirus State and Local Fiscal Recovery Funds were not fully met.
  • Recommended Follow-Up: The County should review grant reporting requirements and ensure all reports are filed accurately and on time, with enhanced oversight for compliance.

Finding Text

2024-005 – Reporting Finding Type. Immaterial Noncompliance; Significant Deficiency in Internal Controls over Compliance (Reporting). Federal program(s) U.S. Department of Treasury -  Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) (ALN 21.027); Direct award. Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. The County has not performed all of the required Coronavirus State and Local Fiscal Recovery Funds expenditure reporting. Specifically, the Project and Expenditure report for the second quarter of 2024 was not filed. However, these reports were filed for the first, third and fourth quarters of 2024. Cause. This condition is the result of the grant administrator not following County policies and procedures to ensure that reports filed were accurate, complete, and timely. Effect. As a result of this condition, the County did not comply completely with the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds grant. Questioned Costs. No costs have been questioned as a result of this finding inasmuch as no unallowable costs were identified. Recommendation. We recommend that the County review the reporting requirements for each grant and complete all reporting as required under the terms of the grant agreement. View of Responsible Officials. Management acknowledges the oversight regarding the 2nd quarter reporting and agrees with the condition as noted. The County will provide a reminder to all grant administrators of the policy. An additional confirmation step is under consideration for verification of completion, at the discretion of County Administration, which would require notification to Financial Services personnel that filing activities have occurred. This oversight process change would require additional resources to complete. Responsible Official. County Administrator/Controller Estimated Completion Date. December 31, 2025

Corrective Action Plan

Finding: 2024-005 – Reporting Auditor Description of Condition and Effect: The County has not performed all of the required Coronavirus State and Local Fiscal Recovery Funds expenditure reporting. Specifically, the Project and Expenditure report for the second quarter of 2024 was not filed. However, these reports were filed for the first, third and fourth quarters of 2024. As a result of this condition, the County did not comply completely with the reporting requirements of the Coronavirus State and Local Fiscal Recovery Funds grant. Auditor Recommendation: We recommend that the County review the reporting requirements for each grant and complete all reporting as required under the terms of the grant agreement. Corrective Action: Management acknowledges the oversight regarding the 2nd quarter reporting and agrees with the condition as noted. The County will provide a reminder to all grant administrators of the policy. An additional confirmation step is under consideration for verification of completion, at the discretion of County Administration, which would require notification to Financial Services personnel that filing activities have occurred. This oversight process change would require additional resources to complete. Contact Person: Brian Dissette, County Administrator/Controller Estimated Completion Date: December 31, 2025

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 568846 2024-007
    Significant Deficiency
  • 568847 2024-006
    Significant Deficiency
  • 568848 2024-007
    Significant Deficiency
  • 568849 2024-006
    Significant Deficiency
  • 568850 2024-007
    Significant Deficiency
  • 568851 2024-006
    Significant Deficiency
  • 1145287 2024-005
    Significant Deficiency
  • 1145288 2024-007
    Significant Deficiency
  • 1145289 2024-006
    Significant Deficiency
  • 1145290 2024-007
    Significant Deficiency
  • 1145291 2024-006
    Significant Deficiency
  • 1145292 2024-007
    Significant Deficiency
  • 1145293 2024-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $994,845
93.268 Immunization Cooperative Agreements $150,870
93.959 Block Grants for Prevention and Treatment of Substance Abuse $79,014
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $73,054
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $71,515
93.994 Maternal and Child Health Services Block Grant to the States $43,521
20.509 Formula Grants for Rural Areas and Tribal Transit Program $43,372
93.069 Public Health Emergency Preparedness $39,023
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $31,891
93.778 Medical Assistance Program $29,902
93.658 Foster Care Title IV-E $18,596
66.472 Beach Monitoring and Notification Program Implementation Grants $17,000
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $14,351
93.991 Preventive Health and Health Services Block Grant $14,250
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $12,788
93.092 Affordable Care Act (aca) Personal Responsibility Education Program $9,474
93.217 Family Planning Services $7,966
93.788 Opioid Str $6,031
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $5,070
97.042 Emergency Management Performance Grants $4,907
20.600 State and Community Highway Safety $3,365
10.553 School Breakfast Program $2,925
10.555 National School Lunch Program $1,262
93.563 Child Support Services $396
93.940 Hiv Prevention Activities Health Department Based $242
16.540 Juvenile Justice and Delinquency Prevention $78