Finding 30355 (2022-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-03-28
Audit: 33097
Organization: City of Cheboygan (MI)
Auditor: Gabridge & CO

AI Summary

  • Core Issue: The City failed to accurately prepare the Schedule of Expenditures of Federal Awards, leading to a material weakness in compliance.
  • Impacted Requirements: The City did not follow the Uniform Guidance criteria for preparing the schedule, resulting in potential misstatements.
  • Recommended Follow-Up: Develop and implement written procedures for preparing the schedule to ensure accuracy in future audits.

Finding Text

2022-001 - Preparation of the Schedule of Expenditures of Federal Awards Finding Type: Material weakness. Programs: Capitalization Grants for Clean Water Revolving Funds (ALN #66.458) Criteria: The Uniform Guidance, ?200.510, requires that a recipient of federal awards subject to a single audit ?prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements, which must include the total Federal awards expended as determined in accordance with ?200.502.? In addition, the City is required to prepare appropriate financial statements, including the Schedule of Expenditures of Federal Awards (the "Schedule") in accordance with these guidelines. Condition/Finding: Management provided an initial Schedule of Expenditure of Awards; however, material adjustments were discovered during the audit process. This condition was primarily caused by the extreme infrequency of the City being required to prepare a Schedule of Expenditures of Federal Awards and the corresponding lack of established policies and procedures to produce an accurate Schedule. As a result of this condition, the City is not in compliance with the required written procedures under the Uniform Guidance. Cause: Required federal expenditures where not accurately recorded on the Schedule of Expenditures of Federal Awards. Effect: The schedule of expenditures of federal awards, would have been materially misstated if audit adjustments hadn?t been made. Questioned Costs: No costs have been questioned as a result of this finding. Recommendation: The City should develop and implement written procedures over the preparation of the schedule of expenditures of federal awards to be used as a reference for future year(s) subject to single audit reporting.

Corrective Action Plan

Finding: 2022-001 ? Material weakness over federal award ? Preparation of the Schedule of Expenditures of Federal Awards Auditor Description of Condition and Effect: Management provided an initial Schedule of Expenditure of Awards; however, material misstatements of federal expenditures recorded on the Schedule of Expenditures of Federal Awards were discovered during the audit process. This condition was primarily caused by the extreme infrequency of the City being required to prepare a Schedule of Expenditures of Federal Awards and the corresponding lack of established policies and procedures to produce an accurate Schedule. As a result of this condition, the City is not in compliance with the required written procedures under the Uniform Guidance. The schedule of expenditures of federal awards, would have been materially misstated if adjustments hadn?t been made. Auditor Recommendation: The City should develop and implement written procedures over the preparation of the schedule of expenditures of federal awards to be used as a reference for future year(s) subject to single audit reporting. Corrective Action: We agree with the finding and will develop and implement written procedures required for federal awards.

Categories

Reporting Material Weakness

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
66.458 Capitalization Grants for Clean Water State Revolving Funds $3.81M
21.027 Coronavirus State and Local Fiscal Recovery Funds $84,138