Finding 1224121 (2025-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-07-20
Audit: 407506
Organization: CITY OF FARMINGTON (MN)
Auditor: LB CARLSON LLP

AI Summary

  • Core Issue: The City lacked adequate controls to ensure the accurate preparation of the Schedule of Expenditures of Federal Awards (SEFA), resulting in an overstatement of $147,700.
  • Impacted Requirements: Compliance with 2 CFR § 200.510 and 2 CFR § 200.502, which mandate accurate reporting of federal expenditures.
  • Recommended Follow-Up: The City should enhance internal controls over reporting and verify the accuracy of expenditures on the SEFA moving forward.

Finding Text

SIGNIFICANT DEFICIENCY IN INTERNAL CONTROL OVER COMPLIANCE – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS – ALL FEDERAL PROGRAMS 2025-002 Reporting Compliance Requirement Criteria – 2 CFR § 200.510 requires that the City prepare appropriate financial statements, including the Schedule of Expenditures of Federal Awards (SEFA) for the year ended December 31, 2025, which must include the total federal awards expended as determined in accordance with 2 CFR § 200.502. Management is responsible for establishing and maintaining effective internal controls over compliance with requirements applicable to federal programs, including separately tracking federal expenditures within the finance system to provide for accurate preparation of the SEFA. Condition – During our audit, we noted the City did not have sufficient controls in place to ensure the accurate preparation of the SEFA in compliance with this requirement. The City’s SEFA for fiscal 2025 was overstated by $147,700 in federal expenditures due to the inclusion of costs that were incurred in the previous fiscal year. Questioned Costs – None. The 2025 SEFA was corrected when the misstatement was identified during the audit, and this would not have changed the determination that a Single Audit of federal awards expenditures was not required for the 2024 fiscal year. Context – The City’s SEFA presented for audit for the year ended December 31, 2025 included $147,700 in one program that should not have been included in this fiscal year. Cause – This was an oversight by city personnel. Repeat Finding – This is a current year finding. Effect – An inaccurate SEFA could result in incorrect major program determination for the Single Audit and could be considered a violation of federal award agreements. Recommendation – We recommend that the City review its internal control procedures over reporting and verify accuracy of expenditures reported on the SEFA in the future. View of Responsible Official and Planned Corrective Actions – The City agrees with the finding. The City has separately issued a Corrective Action Plan related to this finding.

Corrective Action Plan

SIGNIFICANT DEFICIENCY IN INTERNAL CONTROL OVER COMPLIANCE – SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS – ALL FEDERAL PROGRAMS 2025-002 Reporting Compliance Requirement – Schedule of Expenditures of Federal Awards (SEFA) Finding Summary 2 CFR § 200.510 requires that the City prepare appropriate annual financial statements, including the Schedule of Expenditures of Federal Awards (SEFA), which must include the total federal awards expended as determined in accordance with 2 CFR § 200.502. The City did not have proper controls in place to ensure completeness of the SEFA and compliance with this requirement. During our audit, we noted the City did not have sufficient controls in place to ensure the accurate preparation of the SEFA in compliance with this requirement. The City’s SEFA for fiscal 2025 was overstated by $147,700 in federal expenditures due to the inclusion of costs that were incurred in the previous fiscal year. Corrective Action Plan Actions Planned – The SEFA overstatement resulted from including prior-year expenditures in the 2025 reporting period. The City did not prepare a SEFA in the previous fiscal year because federal expenditures did not meet the Single Audit threshold; this contributed to the oversight in tracking the timing of eligible expenditures. To strengthen the year-end reporting process, the City has implemented updated procedures requiring a grant-level reconciliation of expenditures and revenues at year-end to ensure they are recorded in the proper fiscal period before preparing the SEFA. Federal grant coordinators and Finance Department staff will jointly review federal expenditures for accuracy and timing. This strengthened process will help ensure complete and accurate federal expenditure reporting in the SEFA. Official Responsible – Kim Sommerland, Finance Director. Planned Completion Date – June 30, 2026. Disagreement With or Explanation of Finding – The City agrees with the finding and has implemented additional procedures to strengthen controls over reporting. Plan to Monitor – The Finance Director will verify that year-end grant reconciliations are completed and reviewed prior to SEFA preparation.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1224114 2025-001
    Material Weakness Repeat
  • 1224115 2025-001
    Material Weakness Repeat
  • 1224116 2025-002
    Material Weakness Repeat
  • 1224117 2025-002
    Material Weakness Repeat
  • 1224118 2025-002
    Material Weakness Repeat
  • 1224119 2025-002
    Material Weakness Repeat
  • 1224120 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
16.753 CONGRESSIONALLY RECOMMENDED AWARDS $702,709
14.251 ECONOMIC DEVELOPMENT INITIATIVE, COMMUNITY PROJECT FUNDING, AND MISCELLANEOUS GRANTS $582,533
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $313,202
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $11,287
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $4,124
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $3,675