Finding 1223284 (2023-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2026-07-09
Audit: 406785
Organization: CITY OF FRANKLIN (WI)

AI Summary

  • Core Issue: There were significant delays in preparing the schedule of federal and state awards and settling WI DHS cost reimbursement awards.
  • Impacted Requirements: The City must submit federal and state reports within 30 days of receiving the auditor's report or nine months after the audit period ends, as per 2 CFR 200.512(a)(1).
  • Recommended Follow-Up: Implement stronger internal controls over the financial reporting process to prevent future misstatements.

Finding Text

Preparation of the Schedule of Expenditures of Federal and State Awards and Settlement of WI DHS Cost Reimbursement Awards Federal Agencies: U.S. Department of Treasury and U.S. Department of Health and Human Services State Agencies: Wisconsin Dept. of Health Services Federal and State Programs and Assistance Listing Numbers / State IDs: 21.027 and 93.276 Type of Finding: Material Weakness in Internal Control over Compliance – Federal and State Reporting Condition: In conjunction with the performance of the audit, we observed significant delays in the preparation of the schedule of federal and state awards and the settlement of WI DHS cost reimbursement awards. Criteria or specific requirement: In accordance with 2 CFR 200.512(a)(1), the City is required to submit the federal data collection form and the reporting package within 30 calendar days after the City received the auditor's report(s) or nine months after the end of the audit period (whichever is earlier). The City is also required to submit the WI DHS cost reimbursement awards within nine months after the end of the audit period if funds received from the Department of Health Services exceed $100,000. City management is responsible for establishing and maintaining internal controls over the fair presentation of the schedule of federal and state awards and the settlement of WI DHS cost reimbursement awards, including disclosures in accordance with the Uniform Guidance, the Wisconsin State Single Audit Guidelines, and the Wisconsin Department of Health Services Audit Guide. Effect: The potential exists that a material misstatement of the schedule of federal and state awards and the settlement of WI DHS cost reimbursement awards could occur and not be prevented or detected by the City’s internal controls in the normal course of business. Cause: The City’s internal controls failed to prepare and submit timely the schedule of federal and state awards and the settlement of WI DHS cost reimbursement awards for the year ended December 31, 2023. Repeat Finding: No. Recommendation: We recommend that the City implement a system of internal controls over the financial close and reporting process that will mitigate the risk of misstatement in accordance with Uniform Guidance, the Wisconsin State Single Audit Guidelines, and the Wisconsin Department of Health Services Audit Guide. Views of responsible officials: Management agrees with the finding.

Corrective Action Plan

Recommendation: We recommend that the City implement a system of internal controls over the financial close and reporting process that will mitigate the risk of misstatement in accordance with Uniform Guidance, the Wisconsin State Single Audit Guidelines, and the Wisconsin Department of Health Services Audit Guide. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action planned in response to finding: The City is actively working with their auditors to become current with required single audit filings. Name(s) of the contact person(s) responsible for corrective action: Danielle Brown, Director of Finance & Treasurer Planned completion date for corrective action plan: September 30, 2026

Categories

Reporting Cash Management Material Weakness

Other Findings in this Audit

  • 1223282 2023-003
    Material Weakness Repeat
  • 1223283 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.276 DRUG-FREE COMMUNITIES SUPPORT PROGRAM GRANTS $116,763
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $79,735
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $40,579
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $24,433
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $18,777
16.034 CORONAVIRUS EMERGENCY SUPPLEMENTAL FUNDING PROGRAM $13,500
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $7,747
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $6,709
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $5,000
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $3,747
90.404 HAVA ELECTION SECURITY GRANTS $3,723
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $1,277
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $1,262
93.391 ACTIVITIES TO SUPPORT STATE, TRIBAL, LOCAL AND TERRITORIAL (STLT) HEALTH DEPARTMENT RESPONSE TO PUBLIC HEALTH OR HEALTHCARE CRISES $610
93.991 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT $320