Finding 971193 (2023-003)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-04-26
Audit: 304636
Organization: City of Mason City (IA)
Auditor: Abdo LLP

AI Summary

  • Core Issue: Errors in calculating federal expenditures on the Schedule of Expenditures of Federal Awards.
  • Impacted Requirements: Uniform Guidance mandates accurate reporting of federal expenditures.
  • Recommended Follow-Up: Implement a review process and reconcile the Schedule with the accounting system; update the federal grant tracking spreadsheet.

Finding Text

Timely Reporting of Expenditures on the Schedule of Expenditures of Federal Awards. Condition: During our audit, we noted errors related to calculations of federal expenditures on the Schedule of Expenditures of Federal Awards. Criteria: Uniform Guidance requires proper reporting of federal expenditures. Cause: Federal grant reimbursement requests were not submitted timely. Management did not have the information needed to prepare the Schedule of Expenditures of Federal Awards. Effect: By not submitting timely reimbursement requests for federal grants, the Schedule of Expenditures of Federal Awards did not reflect the correct amount of federal expenditures. Recommendation: We recommend that the Organization implement a review process to ensure correct reporting on the Schedule of Expenditures of Federal Awards prior to the audit, including a reconciliation between the Schedule of Expenditures of Federal Awards and the accounting system. We also recommend updating the federal grant tracking spreadsheet to track expenditures by fiscal year. Management Response: City staff is aware of this issue and will work to resolve it as soon as possible.

Categories

Reporting Cash Management

Other Findings in this Audit

  • 394751 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.509 Formula Grants for Rural Areas and Tribal Transit Program $1.53M
21.027 Coronavirus State and Local Fiscal Recovery Funds $946,646
20.106 Airport Improvement Program $769,974
20.205 Highway Planning and Construction $705,067
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $405,899
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $84,498
97.083 Staffing for Adequate Fire and Emergency Response (safer) $45,993
16.588 Violence Against Women Formula Grants $21,148
16.726 Juvenile Mentoring Program $15,082
20.600 State and Community Highway Safety $9,509
16.738 Edward Byrne Memorial Justice Assistance Grant Program $8,441