Finding 969899 (2023-003)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-04-16
Audit: 303673
Organization: City of Cedar Rapids, Iowa (IA)
Auditor: Rsm US LLP

AI Summary

  • Core Issue: The City incorrectly reported FEMA expenditures on a cash basis instead of when eligible expenses were incurred and approved.
  • Impacted Requirements: This misreporting led to an inflated federal expenditure amount of $12,515,044 on the Schedule of Expenditures of Federal Awards (SEFA).
  • Recommended Follow-Up: Management should continue reviewing all grants to ensure accurate reporting on the SEFA moving forward.

Finding Text

Finding 2023-003 - Schedule of Expenditures of Federal Awards U.S. Department of Homeland Security Pass Through Entity: Iowa Homeland Security & Emergency Management Federal Program: Disaster Grants – Public Assistance (Presidentially Declared Disasters) Assistance Listing Number: 97.036 Federal Award Number: FEMA-IA-DR4483 / FEMA-IA-DR4557 Federal Award Year 2023 Repeat Comment: No Type of Finding: Material Weakness Criteria: The Federal Emergency Management Agency (FEMA) requires that Nonfederal entities must record expenditures on the schedule of expenditures of federal awards (SEFA) when (1) FEMA has approved the nonfederal entity’s Project, and (2) the nonfederal entity has incurred the eligible expenditures. Federal awards expended in years subsequent to the fiscal year in which the Project is approved are to be recorded on the nonfederal entity’s SEFA in those subsequent years. Condition: The City previously recorded FEMA expenditures from Disaster Grants on their SEFA on the cash basis instead of the FEMA requirement of reporting the expenditures when the City has incurred an eligible expenditure and the project had been approved by FEMA. Cause: During a previous disaster the City experienced significant de-obligations from FEMA subsequent to project approval by FEMA. The City adopted a process of reflecting this grant on the financial statements and on the SEFA on the cash basis due to the uncertainty related to future de-obligations. Effect: The City increased the amount federal expenditures for this program on the SEFA by $12,515,044. This error could have also potentially impacted the City’s major federal program determination, however this change did not change any of the City’s major programs in fiscal year 2023. Questioned Costs: None. Prevalence: This issue is isolated to this FEMA program. Repeat Finding: No. Recommendation: We recommend management of the City continue to review all grants to ensure they are properly reflected on the SEFA. Views of Responsible Officials: Management agrees with the recommendation and made the adjustment once this issue was further discussed with management and the auditor.

Categories

Reporting

Other Findings in this Audit

  • 393456 2023-003
    Material Weakness
  • 393457 2023-003
    Material Weakness
  • 969898 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program $32.67M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $27.69M
66.468 Capitalization Grants for Drinking Water State Revolving Funds $9.97M
20.507 Federal Transit_formula Grants $3.93M
10.923 Emergency Watershed Protection Program $821,592
14.218 Community Development Block Grants/entitlement Grants $601,939
21.027 Coronavirus State and Local Fiscal Recovery Funds $601,477
14.871 Section 8 Housing Choice Vouchers $298,752
14.239 Home Investment Partnerships Program $290,063
20.205 Highway Planning and Construction $253,448
21.016 Equitable Sharing $172,696
10.932 Regional Conservation Partnership Program $131,515
10.675 Urban and Community Forestry Program $121,250
14.231 Emergency Solutions Grant Program $120,373
14.896 Family Self-Sufficiency Program $102,487
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $65,353
95.001 High Intensity Drug Trafficking Areas Program $43,637
16.034 Coronavirus Emergency Supplemental Funding Program $43,566
16.738 Edward Byrne Memorial Justice Assistance Grant Program $24,601
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $19,105
45.312 National Leadership Grants $16,771
14.401 Fair Housing Assistance Program_state and Local $13,000
20.600 State and Community Highway Safety $8,978
20.616 National Priority Safety Programs $8,088
10.664 Cooperative Forestry Assistance $7,335
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $345
97.067 Homeland Security Grant Program $179