Finding 576087 (2024-012)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-09-10
Audit: 365989
Organization: City of Shreveport (LA)

AI Summary

  • Core Issue: The City of Shreveport lacks adequate internal controls for reviewing and approving federal report submissions, leading to inaccurate reporting of program income and expenditures.
  • Impacted Requirements: Non-compliance with 2 CFR 200.1 and 200.303, which mandate accurate reporting and effective internal controls for federal funds.
  • Recommended Follow-Up: Implement stronger controls to review reports and address discrepancies, ensuring accurate and compliant submissions to the U.S. Department of the Treasury.

Finding Text

Federal Program, Assistance Listing # and Year, Federal Agency, Pass-Through Entity: COVID-19 - Coronavirus State & Local Fiscal Recovery Fund, Assistance Listing #21.027, 2021, U.S. Department of Treasury. Criteria or Specific Requirement: In accordance with 2 CFR 200.1, all recipients of federal funds must complete and submit annual project and expenditure reports on all SLFRF funded projects. Also, 2 CFR 200.303 requires the entity to establish and maintain effective internal controls over compliance with respect to federal awards and Section 1111(b)(2)(A) of the ESEA for compliance accountability. Proper internal controls require supporting documentation to be retained as evidence for effectiveness of the controls in place. In accordance with 2 CFR.307, program income earned during the period of performance must be used in accordance with the terms and conditions of the federal award. Condition: During our testing, CRI identified a lack of internal controls related to reviewing and approving report submissions. During our testing, CRI identified 2024 report submissions did not agree to cumulativeto- date expenditures of the fiscal years 2021-2024. During our testing, CRI identified revenue recognized/earned during the period was improperly reported as program income and expenditures were improperly included as program income expenditures, causing inaccurate reporting. Program income was materially overstated. Effect: The City of Shreveport risks reports required to be submitted to the U.S. Department of the Treasury to be materially misstated. Cause: A lack of adequate controls over reporting requirements. Questioned Costs: Not applicable Context: The issue was identified while testing the population of reports. Recommendation: We recommend the City implements proper controls to review reports submitted, so as to identify and address any discrepancies. Views of responsible officials and corrective action plan: Accounting has reviewed all projects and Ordinances related to ARPA and has updated reports and records to fully account for ARPA funding. From the Chief Administrative Officer (CAO) and the department responsible for a specific project that has multiple funding sources, confirmation was obtained on what amounts were obligated ARPA funds. This strengthens the controls over the report submission process to ensure the reported amounts are accurate and reconciled properly.

Corrective Action Plan

Accounting has reviewed all projects and Ordinances related to ARPA and has updated reports and records to fully account for ARPA funding. From the Chief Administrative Officer (CAO) and the department responsible for a specific project that has multiple funding sources, confirmation was obtained on what amounts were obligated ARP funds. This strengthens the controls over the report submission process to ensure the reported amounts are accurate and reconciled properly. Person Responsible: Sheila Faour, CFO Anticipated Completion Date: Immediately

Categories

Reporting Subrecipient Monitoring Period of Performance Internal Control / Segregation of Duties Program Income

Other Findings in this Audit

  • 576085 2024-011
    Significant Deficiency
  • 576086 2024-011
    Significant Deficiency
  • 1152527 2024-011
    Significant Deficiency
  • 1152528 2024-011
    Significant Deficiency
  • 1152529 2024-012
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $21.38M
14.889 Choice Neighborhoods Implementation Grants $3.60M
20.106 Covid-19 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $2.00M
66.458 Clean Water State Revolving Fund $1.84M
14.218 Community Development Block Grants/entitlement Grants $1.59M
20.507 Federal Transit Formula Grants $457,261
17.259 Wioa Youth Activities $398,123
15.904 Historic Preservation Fund Grants-in-Aid $385,464
17.258 Wioa Adult Program $361,321
16.U03 A.f.i.s.2024 $265,880
17.278 Wioa Dislocated Worker Formula Grants $192,018
16.034 Covid-19 Coronavirus Emergency Supplemental Funding Program $181,921
16.U02 A.f.i.s.2023 $177,599
14.231 Emergency Solutions Grant Program $145,867
14.218 Covid-19 Community Development Block Grants/entitlement Grants $125,234
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $123,920
14.239 Home Investment Partnerships Program $84,287
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $60,030
97.090 Law Enforcement Officer Reimbursement Agreement Program $45,716
16.U06 Organized Crime Enforcement Task Force 2023 $33,789
16.U01 A.f.i.s.2021 $25,773
16.609 Project Safe Neighborhoods $24,689
20.600 State and Community Highway Safety $21,083
16.738 Edward Byrne Memorial Justice Assistance Grant Program $20,659
16.166 Safe Streets 2023 $14,824
16.U04 Federal Atf Grant 2023 $13,351
16.U08 U S Marshalls 2023 $12,320
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $9,108
16.588 Violence Against Women Formula Grants $8,500
16.817 Byrne Criminal Justice Innovation Program $4,700
16.U05 Federal Atf Grant 2024 $3,832
16.166 Safe Streets 2024 $3,694
95.001 High Intensity Drug Trafficking Areas Program $3,135
16.U09 U S Marshalls 2024 $937
16.U07 Organized Crime Enforcement Task Force 2024 $613