Finding 974507 (2023-002)

Significant Deficiency
Requirement
AB
Questioned Costs
$1
Year
2023
Accepted
2024-05-21
Audit: 306784
Organization: Lee County, Florida (FL)

AI Summary

  • Core Issue: The County failed to keep proper documentation for payroll expenses charged to the grant, leading to potential compliance risks.
  • Impacted Requirements: This finding violates 2 CFR 200.302(b)(3) and 2 CFR 200.403, which require adequate recordkeeping and documentation for federal funds.
  • Recommended Follow-Up: Implement internal controls to ensure payroll charges are reconciled with employee records and maintain supporting documentation throughout the grant period.

Finding Text

2023-002 Grant Payroll Documentation and Recordkeeping 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: SLFRP3404 - 2021 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: Significant Deficiency in Internal Control over Compliance, Other Matter Criteria: Compliance: 2 CFR 200.302(b)(3) states that records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. 2 CFR 200.403 states that costs must be adequately documented. Controls: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the ”Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The County did not maintain documentation supporting certain payroll expenditures charged to the grant. Questioned Costs: Under $25,000. Context: For four of the sixty employee pays selected for testing the underlying payroll records did not support the amount charged to the grant. Cause: Payroll documentation supporting the wage amounts charged to the grant program was not properly maintained by the County. Effect: Failure to maintain supporting documentation to the employee payroll charged to grant programs may result in unallowed cost and activities being charged to the grant, causing noncompliance with the Federal compliance requirements. Repeat Finding: No Recommendation: We recommend the County establish internal control procedures to ensure that all amounts charged to grant programs for employee payroll costs be reconciled to the specific employee payroll records and that supporting documentation be maintained throughout the grant award period and beyond.

Categories

Questioned Costs Allowable Costs / Cost Principles Significant Deficiency Internal Control / Segregation of Duties Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 398065 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
10.923 Emergency Watershed Protection Program $8.38M
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.52M
21.023 Emergency Rental Assistance Program $2.51M
20.106 Airport Improvement Program $2.37M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $1.77M
20.507 Federal Transit_formula Grants $990,379
14.239 Home Investment Partnerships Program $718,238
97.039 Hazard Mitigation Grant $644,504
93.568 Low-Income Home Energy Assistance $519,281
93.563 Child Support Enforcement $356,130
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $340,368
16.922 Equitable Sharing Program $312,052
93.499 Low Income Household Water Assistance Program $203,986
90.404 2018 Hava Election Security Grants $189,955
97.042 Emergency Management Performance Grants $162,959
21.016 Equitable Sharing $151,008
20.205 Highway Planning and Construction $134,098
20.509 Formula Grants for Rural Areas and Tribal Transit Program $131,325
14.267 Continuum of Care Program $119,388
14.231 Emergency Solutions Grant Program $93,790
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $88,918
93.569 Community Services Block Grant $56,302
14.261 Homeless Management Information Systems Technical Assistance $55,917
14.241 Housing Opportunities for Persons with Aids $48,332
16.738 Edward Byrne Memorial Justice Assistance Grant Program $33,770
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $20,388
93.558 Temporary Assistance for Needy Families $16,307
97.067 Homeland Security Grant Program $15,328
15.657 Endangered Species Conservation Ð Recovery Implementation Funds $13,597
16.606 State Criminal Alien Assistance Program $4,280
14.218 Community Development Block Grants/entitlement Grants $3,686
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $1,757