Finding 516601 (2024-001)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2024-12-23
Audit: 334578
Organization: Harford County, Maryland (MD)

AI Summary

  • Core Issue: Expenditures were reported in the wrong period, leading to inaccurate financial reporting.
  • Impacted Requirements: Compliance with federal reporting standards under the Uniform Guidance (2 CFR Part 200) and SLFRF guidelines was not met.
  • Recommended Follow-Up: Enhance internal controls, provide consistent training for staff, and conduct periodic audits to ensure accurate reporting.

Finding Text

Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP0316 Compliance Requirement: Reporting Award Period: March 3, 2021 – December 31, 2024, liquidated by December 31, 2026 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matter Criteria or specific requirement: According to the Uniform Guidance (2 CFR Part 200), expenditures should be reported in the period in which they are incurred. Accurate reporting is essential for compliance with federal requirements and for the proper matching of expenditures with the corresponding fiscal year. Per the SLFRF Compliance and Reporting Guidance, SLFRF funds recipients are required to submit quarterly Project and Expenditure Report. These reports include current period expenditures as well as cumulative expenditures. Condition: During our audit of the Schedule of Expenditures of Federal Awards (SEFA), we identified that expenditures were reported in the incorrect period. Specifically, expenditures incurred in the prior fiscal year were included in the current year's SEFA. Additionally, SLFRF reports submitted did not report the correct amount of cumulative expenditures. Questioned Costs: None. Context: Two of two compliance reports selected for testing did not properly report the cumulative expenditures, $797,843.36 of expenditures were omitted. These expenditures were improperly included on the initial 2024 SEFA prepared by the County. Cause: The misreporting occurred due to a lack of adequate training on the reporting requirements for this grant program across departments within the County. County personnel did not have a consistent understanding of the program requirements to ensure all allowable expenditures were properly reported on the SEFA and included in the applicable SLFRF reports. Effect: Reporting expenditures in the wrong period or omitting expenditures may lead to inaccurate financial and compliance reporting and non-compliance with federal regulations. Repeat Finding: This is not a repeat finding. Recommendation: We recommend that the organization implement stronger internal controls over the SEFA preparation process and consistent training among County staff. This should include: -A thorough review and reconciliation of expenditures to ensure they are reported in the correct period. -A thorough review and reconciliation of SLFRF reports to ensure they are complete and accurate before submission. -Training for staff involved in the SEFA preparation to ensure they understand the requirements for accurate reporting. -Periodic internal audits to verify compliance with federal reporting requirements. Views of responsible officials: Management agrees with the finding.

Corrective Action Plan

Coronavirus State and Local Fiscal Recovery Funds – Assistance Listing No. 21.027 Recommendation: We recommend that the organization implement stronger internal controls over the SEFA preparation process and consistent training among County staff. This should include: -A thorough review and reconciliation of expenditures to ensure they are reported in the correct period. -A thorough review and reconciliation of SLFRF reports to ensure they are complete and accurate before submission. -Training for staff involved in the SEFA preparation to ensure they understand the requirements for accurate reporting. -Periodic internal audits to verify compliance with federal reporting requirements. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: A more thorough review and reconciliation of expenditures will be completed throughout the year and at year end, including the SLFRF reports, to ensure they are complete and accurate before submission. This process will include a reviewer to ensure that expenditures are captured within the correct reporting period and prevent other reporting errors. Training will be provided to all individuals working on the SEFA to ensure the requirements for accurate reporting are understood and periodic internal audits by a reviewer will be done to verify compliance with federal reporting requirements. Name(s) of the contact person(s) responsible for corrective action: Rick Pernas Planned completion date for corrective action plan: The corrective action plan will start immediately and will continue indefinitely. December 6, 2024 If the Department of the Treasury (Treasury) Office of Inspector General (OIG) has questions regarding this plan, please call Rick Pernas at 410-638-3416.

Categories

Reporting

Other Findings in this Audit

  • 1093043 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $10.89M
21.027 Coronavirus State and Local Fiscal Recovery Funds $9.29M
20.507 Federal Transit Formula Grants $4.49M
20.205 Highway Planning and Construction $1.31M
97.067 Homeland Security Grant Program $813,167
14.879 Mainstream Vouchers $698,814
17.278 Wioa Dislocated Worker Formula Grants $648,259
17.258 Wioa Adult Program $463,508
93.563 Child Support Services $438,395
14.218 Community Development Block Grants/entitlement Grants $378,423
17.259 Wioa Youth Activities $371,636
97.042 Emergency Management Performance Grants $224,328
16.922 Equitable Sharing Program $208,728
21.023 Emergency Rental Assistance Program $202,790
93.959 Block Grants for Prevention and Treatment of Substance Abuse $197,647
16.606 State Criminal Alien Assistance Program $177,180
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $155,377
14.241 Housing Opportunities for Persons with Aids $138,343
16.738 Edward Byrne Memorial Justice Assistance Grant Program $101,536
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $92,787
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $74,790
16.575 Crime Victim Assistance $73,420
93.778 Medical Assistance Program $64,336
11.020 Cluster Grants $58,675
14.169 Housing Counseling Assistance Program $52,543
11.420 Coastal Zone Management Estuarine Research Reserves $50,000
20.616 National Priority Safety Programs $42,160
95.001 High Intensity Drug Trafficking Areas Program $36,754
14.896 Family Self-Sufficiency Program $36,176
20.600 State and Community Highway Safety $29,495
93.324 State Health Insurance Assistance Program $27,298
93.052 National Family Caregiver Support, Title Iii, Part E $22,469
93.048 Special Programs for the Aging, Title Iv, and Title Ii, Discretionary Projects $21,329
15.904 Historic Preservation Fund Grants-in-Aid $18,130
93.071 Medicare Enrollment Assistance Program $15,048
21.000 Equitable Sharing $13,812
20.218 Motor Carrier Safety Assistance $13,544
93.043 Special Programs for the Aging, Title Iii, Part D, Disease Prevention and Health Promotion Services $12,222
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $10,411
14.239 Home Investment Partnerships Program $6,114
16.111 Joint Law Enforcement Operations $3,259
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $3,194
15.670 Adaptive Science $1,500