Finding 382738 (2023-007)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-03-21
Audit: 296327
Organization: City of Mandeville, Louisiana (LA)
Auditor: Eisneramper LLP

AI Summary

  • Core Issue: The City lacks adequate policies and procedures for timely and accurate preparation of the Schedule of Expenditures of Federal Awards (SEFA).
  • Impacted Requirements: Compliance with Title I U.S. Code of Federal Regulations Part 200 is not being met, leading to delays and significant adjustments in the audit process.
  • Recommended Follow-Up: Strengthen internal controls and review processes to ensure accurate reporting of federal expenditures in line with federal requirements.

Finding Text

PROCEDURES OVER PREPARATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Criteria: The City should have systems of internal accounting control which ensures the schedule of expenditures of federal awards (SEFA) is presented in accordance with Title I U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) on a timely basis. Condition: The City did not have adequate policies and procedures in place to prepare an accurate and complete SEFA on a timely basis. Universe /Population: None Sample size: None Questioned Cost: Not applicable Cause: The City does not have adequate policies and procedures in place for SEFA preparation. Effect: The lack of completing a detailed review over the SEFA created delays in the audit and significant adjustments necessary to correct the balances to the reconciliations and other support. This created delays with completing the audit process. Adjustments of $2,998,397 were required to decrease the federal expenditure balance in the original SEFA provided by the City for the audit. Recommendation: The City should strengthen its controls including its review and approval processes over the identification of federal programs and the information and balances that are accumulated and reported on the SEFA to make sure the expenditures reported are an accurate representation of federal expenditures and based on the reporting requirements provided in the federal award and the compliance supplement. View of Responsible Official: The City concurs with the finding and will comply with the recommendation

Categories

Reporting

Other Findings in this Audit

  • 382736 2023-007
    Material Weakness
  • 382737 2023-007
    Material Weakness
  • 959178 2023-007
    Material Weakness
  • 959179 2023-007
    Material Weakness
  • 959180 2023-007
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.923 Emergency Watershed Protection Program $613,179
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $321,787
97.029 Flood Mitigation Assistance $134,400
66.125 Lake Pontchartrain Basin Restoration Program (prp) $32,463
20.205 Highway Planning and Construction $24,523
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $21,775
20.600 State and Community Highway Safety $6,700