Audit 303673

FY End
2023-06-30
Total Expended
$97.76M
Findings
4
Programs
27
Organization: City of Cedar Rapids, Iowa (IA)
Year: 2023 Accepted: 2024-04-16
Auditor: Rsm US LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
393456 2023-003 Material Weakness - P
393457 2023-003 Material Weakness - P
969898 2023-003 Material Weakness - P
969899 2023-003 Material Weakness - P

Programs

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

Contacts

Name Title Type
NDSYD8WM9RL7 Andrew Hoenig Auditee
3192865066 Marc Sewell Auditor
No contacts on file

Notes to SEFA

Title: Note 1: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting for governmental funds and the accrual basis for proprietary funds. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of the City of Cedar Rapids, Iowa and the Eastern Iowa Airport, a discretely presented component unit for the year ended June 30, 2023. The accompanying schedule of expenditures of federal awards does not include federal grant activity of the Cedar Rapids/Linn County Solid Waste Agency, a discretely presented component unit, because they did not have federal expenditures for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City of Cedar Rapids, Iowa, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City of Cedar Rapids, Iowa.
Title: Note 4: Disaster Grants - Public Assistance (Presidentially Declared Disasters) Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting for governmental funds and the accrual basis for proprietary funds. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. After a presidentially declared disaster, FEMA reimburses eligible costs. The federal government makes reimbursements in the form of cost-shared grants that require state matching funds. Expenditures are recognized on the Schedule when both the expenditure has been incurred and FEMA has approved the project worksheet. The City recorded $28,130,770 of expenditures on the current year Schedule that were incurred in prior fiscal years.
Title: Note 5: Revolving Loan Program Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting for governmental funds and the accrual basis for proprietary funds. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The City is indebted to the Iowa Finance Authority as the result of issuance of bonds listed below. The bonds were sold under the Capitalization Grants for Drinking Water State Revolving Funds for financing qualified improvements. The amounts reflected in the Schedule represents expenditures incurred during the year ended June 30, 2023. The following table contains information about these bonds. See the Notes to the SEFA for chart/table.

Finding Details

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.
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.
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.
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.