Finding 971534 (2023-005)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-04-30

AI Summary

  • Core Issue: Errors were found in the quarterly expenditure reports for several projects, leading to inaccurate data submitted to the Treasury.
  • Impacted Requirements: The City failed to meet the grant agreement's requirement for accurate reporting and lacked necessary internal controls as per Uniform Guidance.
  • Recommended Follow-Up: Implement a process for an independent review of report data before submission to ensure accuracy and compliance.

Finding Text

2023-005 U.S. Department of the Treasury, Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds for the period July 1, 2022 through June 30, 2023 Criteria: The Coronavirus State and Local Fiscal Recovery Funds (SLFRF) grant agreement requires the City to file a quarterly Project and Expenditure Report in the Treasury’s reporting portal that details budgeted programs, obligated expenditures, and actual expenditures to date for each grant project. In addition, administrative requirements under the Uniform Guidance require grantees to develop internal controls and procedures sufficient to prevent noncompliance. Condition: In our testing of the September and December quarterly reports, we found errors in the reporting of cumulative and quarterly expenditures for the TRUCK, LFVNT, CPLAN, and SWRKR projects. Net cumulative and quarterly reporting errors for the September report were $31,255 and $9,570, respectively. Net cumulative errors for the December report were $6,857. There were no quarterly expenditure errors. Cause: There is no control in place to ensure the quarterly report is reviewed by an independent person prior to submitting to the reporting portal. Effect: Inaccurate expenditures were reported to the Treasury’s SLFRF portal. Recommendation: Controls should be established to allow for an independent review of the report data prior to submission. Questioned Costs: None

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 395087 2023-004
    Material Weakness Repeat
  • 395088 2023-003
    Material Weakness Repeat
  • 395089 2023-003
    Material Weakness Repeat
  • 395090 2023-003
    Material Weakness Repeat
  • 395091 2023-003
    Material Weakness Repeat
  • 395092 2023-005
    Significant Deficiency
  • 395093 2023-005
    Significant Deficiency
  • 971529 2023-004
    Material Weakness Repeat
  • 971530 2023-003
    Material Weakness Repeat
  • 971531 2023-003
    Material Weakness Repeat
  • 971532 2023-003
    Material Weakness Repeat
  • 971533 2023-003
    Material Weakness Repeat
  • 971535 2023-005
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 - Elementary and Secondary School Emergency Relief III $1.42M
20.507 Federal Transit Formula Grants $821,031
84.027 Special Education State Grants Individuals with Disabilities Act $798,912
20.526 Bus and Bus Facilities Formula Grants $796,446
84.425 Covid-19 - Elementary and Secondary School Emergency Relief II $749,488
20.205 Highway Planning and Construction $720,414
10.555 National School Lunch Program $716,009
84.010 Title Ia, Disadvantaged $600,472
84.425 Covid-19 - Multilingual Learners Experiencing Homelessness $412,032
10.553 Breakfast Program $306,202
84.367 Title Iia, Supporting Effective Instruction $225,103
14.218 Cdbg - Entitlement Community (cdbg - Entitlement Grants Cluster) $190,605
10.555 Food Donation Program $148,710
84.424 Title Iv, Student Support and Academic Enrichment Program $121,835
66.818 Brownfields Multipurpose $110,101
10.582 Fresh Fruit and Vegetables $104,143
93.276 Drug Free Communities Support Program (2023 Grant) $98,142
84.027 Covid-19 - Special Education State Grants Individuals with Disabilities Act - Arp $89,073
20.507 Covid-19 - Federal Transit Formula Grants $89,000
84.365 Title Iii, English Language Acquisition Grant $84,778
10.555 State Administrative Expenses for Child Nutrition: Supply Chain Assistance $79,188
97.067 Homeland Security Grant Program- Fy 20 $58,257
10.559 Summer Food Service Program $51,725
93.276 Drug Free Communities Support Program (2022 Grant) $32,223
84.002 Adult Basic Education $28,223
97.067 Homeland Security Grant Program- Fy 21 $22,031
84.173 Preschool $16,944
84.196 McKinney-Vento Education for Homeless Children and Youth $16,370
97.067 Homeland Security Grant Program- Fy 19 $14,845
97.004 County Hazmat Grant $14,300
11.419 Coastal Zone Management Administration $13,743
20.600 State and Community Highway Safety - Speed Enforcement $7,818
84.425 Covid-19 - Elementary and Secondary School Emergency Relief I $6,347
10.649 Covid-19 - Pandemic Ebt Administrative Costs: Snap $5,024
20.600 State and Community Highway Safety - Dre Forensic $3,934
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $2,588
16.738 Justice Assistance Grant $1,784
16.922 Equitable Sharing Program $1,705
20.600 State and Community Highway Safety - Impaired Driving $1,369
20.600 State and Community Highway Safety - Distracted Driver $1,304
10.558 Child and Adult Care Food Program $788