Finding 498801 (2023-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-09-27
Audit: 321508
Organization: Livingston County, Michigan (MI)

AI Summary

  • Core Issue: The SEFA initially excluded $1,024,472 in expenditures for the Congressional Directives program, leading to a material weakness in reporting.
  • Impacted Requirements: Compliance with the Uniform Guidance (2 CFR 200.502) was not met due to ineffective internal controls over expenditure reporting.
  • Recommended Follow-Up: Strengthen internal control procedures and implement a review process to ensure all expenses are accurately reported in future SEFAs.

Finding Text

Assistance Listing, Federal Agency, and Program Name - 93.493, Congressional Directives Federal Award Identification Number and Year - 2023 Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria - The Uniform Guidance requires organizations to properly reflect federal expenditures in the schedule of expenditures of federal awards (SEFA), as determined by 2 CFR 200.502. Condition - The total amount of expenditures originally reported on the SEFA excluded $1,024,472 of expenditures related to the Congressional Directives program. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - All of the expenditures that were incurred related to the Congressional Directives program were originally excluded from the SEFA. The adjustment resulted in an additional major program. Although the SEFA was originally incorrect, the SEFA was corrected after this error was noted by the auditor. Cause and Effect - Internal control procedures over determining the correct amount of expenditures to record on the SEFA did not operate effectively. This resulted in an adjustment to the schedule of expenditures of federal awards. Recommendation - Internal control procedures should continue to be enforced to ensure the proper expenditures are reported in the schedule of federal awards. Views of Responsible Officials and Corrective Action Plan - Livingston County, Michigan will implement a review process going forward to ensure all expenses fall within the grant period.

Corrective Action Plan

Condition: The total amount of expenditures originally reported on the SEFA excluded $1,024,472 of expenditures related to the Congressional Directives program. Planned Corrective Action: Livingston County will implement a review process going forward to ensure all expenses are included on the SEFA. Contact person responsible for corrective action: Cynthia Arbanas, Deputy County Administrator Anticipated Completion Date: 12/31/2024

Categories

Reporting Material Weakness

Other Findings in this Audit

  • 1075243 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $18.47M
93.493 Congressional Directives $1.02M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $417,409
93.323 Covid-19 - Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $380,078
93.563 Child Support Enforcement $224,417
93.069 Public Health Emergency Preparedness $218,835
93.268 Covid-19 - Immunization Cooperative Agreements $125,741
20.507 Federal Transit_formula Grants $60,807
93.658 Foster Care_title IV-E $56,051
97.042 Emergency Management Performance Grants $41,744
93.778 Medical Assistance Program $33,434
20.600 State and Community Highway Safety $31,167
16.034 Covid-19 - Coronavirus Emergency Supplemental Funding Program $30,915
20.509 Formula Grants for Rural Areas and Tribal Transit Program $25,000
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $23,798
97.067 Homeland Security Grant Program $20,887
16.922 Equitable Sharing Program $20,417
20.106 Airport Improvement Program $18,865
93.991 Preventive Health and Health Services Block Grant $18,750
16.585 Drug Court Discretionary Grant Program $16,630
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $15,328
93.354 Covid-19 - Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $13,864
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $12,859
97.012 Boating Safety Financial Assistance $10,100
93.994 Maternal and Child Health Services Block Grant to the States $8,745
93.788 Opioid Str $8,237
16.738 Edward Byrne Memorial Justice Assistance Grant Program $4,500
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $3,584
66.468 Capitalization Grants for Drinking Water State Revolving Funds $3,512
93.268 Immunization Cooperative Agreements $2,577
16.824 Emergency Law Enforcement Assistance Grant $1,825
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $454