Finding 1092129 (2024-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2024-12-18
Audit: 333552
Organization: City of Bettendorf, Iowa (IA)

AI Summary

  • Core Issue: The City lacks proper procedures for identifying federal expenditures, leading to omissions in reporting.
  • Impacted Requirements: The Schedule of Expenditures of Federal Awards was misstated, violating federal regulations outlined in Title 2 U.S. Code of Federal Regulations Part 200.
  • Recommended Follow-Up: The City should establish a process to accurately identify all federal expenditures and ensure timely reimbursement requests to grantors.

Finding Text

Finding: The City has insufficient procedures over the process for identifying federal expenditures for reporting on the City’s Schedule of Expenditures of Federal Awards. Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Subpart F 200.510 states, “the audit must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements. The schedule must include the total Federal awards expended as determined in accordance with section 200.502.” Condition: Hazard Mitigation Grant Program expenditures of approximately $1.1 million were omitted from the Schedule of Expenditures of Federal Awards presented for the audit. Cause: Reimbursement for expenditures made under the federal grant had not yet been requested. The City prepared the Schedule of Expenditures of Federal Awards based on receipts rather than expenditures incurred. The expenditures are not coded to be specifically identified as federal. Effect: The Schedule of Expenditures of Federal Awards presented for the audit was misstated. Context: Federal expenditures of approximately $1.1 million were not included on the Schedule of Expenditures of Federal Awards presented for the audit. Identification as a repeat finding: This is not a repeat finding. Recommendation: We recommend the City determine a process to identify federal expenditures for reporting including those not yet reimbursed by the grantor. We recommend the City submit reimbursement requests to grantors on a timely basis. Response and Corrective Action Plan: The City will review current processes and realign duties and processes to improve internal controls within the identification of federal award expenditures.

Categories

Reporting Cash Management

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus Relief Fund $5.46M
20.205 Highway Planning and Construction $1.78M
97.083 Staffing for Adequate Fire and Emergency Response (safer) $160,958
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $86,608
16.738 Edward Byrne Memorial Justice Assistance Grant Program $86,098
97.039 Hazard Mitigation Grant $49,769
16.922 Equitable Sharing Program $24,184
20.507 Federal Transit_formula Grants $3,600
16.607 Bulletproof Vest Partnership Program $2,792
20.600 State and Community Highway Safety $892