Finding 1054356 (2023-001)

Significant Deficiency
Requirement
G
Questioned Costs
-
Year
2023
Accepted
2024-07-09
Audit: 314617
Organization: County of Calhoun (MI)

AI Summary

  • Core Issue: The County miscalculated lost revenue by including ineligible items in its calculation for COVID-19 relief funds.
  • Impacted Requirements: Compliance with the Final Rule of the Uniform Guidance for the Coronavirus State & Local Fiscal Recovery Funds.
  • Recommended Follow-Up: Update the current quarterly report with corrected revenue loss calculations and ensure future calculations adhere to guidelines.

Finding Text

2023-001 - Revenue Loss Calculation (Earmarking) 2023-001 - Revenue Loss Calculation (Earmarking) Finding Type. Immaterial Noncompliance; Significant Deficiency in Internal Controls over Compliance. Federal program(s) U.S. Department of Treasury COVID-19 - State and Local Fiscal Recovery Fund (CSLFRF) - American Rescue Plan Act (ALN 21.027); Direct award Criteria. In accordance with the Uniform Guidance, recipients of Coronavirus State & Local Fiscal Recovery Funds may use payments from CSLFRF to replace lost public sector revenue to provide government services. Recipients may use this funding to provide government services to the extent of the reduction in revenue experience due to the pandemic. Under the Final Rule, recipients can elect a one-time “standard allowance” or they can calculate lost revenue based on the formula provide in the Final Rule to determine the amount of funds that can be used for the provision of government services. Condition. The County calculated lost revenue for fiscal years 2020-2023; however, certain items included in the calculation are not allowed per the Final Rule. Cause. The County included accounts and account classifications that should have been excluded from the calculation. Effect. As a result, the amount of revenue loss reported on the SLFRF compliance/P&E reports was incorrect. Recommendation. Management has revised its internal revenue loss calculation. We recommend the County update the amount on the current quarterly report and ensure that any future calculations are correct. Questioned Costs. None. View of Responsible Official. The County agrees that management has already taken appropriate action and will continue to provide correct calculations of revenue loss for future quarterly reports. The amount of the County’s revenue loss far exceeds the amount of ARPA funds spent within that category, and so this item did not and will not impact the accuracy of the County’s ARPA expenditure reports. Responsible Official. Finance Director

Categories

Matching / Level of Effort / Earmarking Significant Deficiency

Other Findings in this Audit

  • 477914 2023-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.36M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $812,640
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $621,419
93.563 Child Support Enforcement $263,409
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $210,178
93.994 Maternal and Child Health Services Block Grant to the States $126,965
93.268 Immunization Cooperative Agreements $117,801
93.788 Opioid Str $90,000
16.753 Congressionally Recommended Awards $85,550
97.048 Federal Disaster Assistance to Individuals and Households in Presidential Declared Disaster Areas $73,631
93.778 Medical Assistance Program $58,365
93.658 Foster Care_title IV-E $49,495
10.555 National School Lunch Program $36,718
93.889 National Bioterrorism Hospital Preparedness Program $24,761
20.600 State and Community Highway Safety $19,765
93.217 Family Planning_services $19,739
93.991 Preventive Health and Health Services Block Grant $19,508
10.553 School Breakfast Program $14,815
97.042 Emergency Management Performance Grants $11,057
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $10,000
90.404 2018 Hava Election Security Grants $7,101
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $6,500
16.738 Edward Byrne Memorial Justice Assistance Grant Program $4,040
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $1,260
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $1,223
93.940 Hiv Prevention Activities_health Department Based $960
93.071 Medicare Enrollment Assistance Program $400