Finding 499861 (2023-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-09-30
Audit: 322720
Organization: City of Reedsburg (WI)

AI Summary

  • Core Issue: The Reedsburg Utility Commission lacked a review process for quarterly reports, leading to potential errors from using estimates instead of actual costs.
  • Impacted Requirements: Compliance with 2 CFR 200.303(a) for internal controls and PSC reporting requirements was not met.
  • Recommended Follow-Up: Implement a review and approval process for reports and ensure actual costs are reported accurately before submission to state agencies.

Finding Text

Assistance Listing Number and Program: 21.027 COVID-19 State and Local Fiscal Recovery Funds Federal Agency: U.S. Department of Treasury Pass-Through Entity and Award Number: Wisconsin Public Service Commission / 5-BF-2022 Criteria: Non-federal entities in receipt of federal funds must comply with the requirements of 2 CFR 200.303(a), which requires an entity to establish and maintain effective internal control over the Federal award to ensure compliance with Federal statutes, regulations and the terms and conditions of the federal award. Recipients of COVID-19 State and Local Fiscal Recovery Fund payments from the Wisconsin Public Service Commission (PSC) must also comply with the reporting requirements described in the terms and conditions of the PSC agreement. Condition: The Reedsburg Utility Commission did not have a process to review and approve the quarterly progress reports prior to submission to the PSC by someone other than the preparer. Additionally, estimates were used to report costs incurred in those quarterly reports. We tested four quarterly reports submitted for the Iowa County and Witwen projects. Our sample was not statistically valid. Cause: The Reedsburg Utility Commission did not have a control process in place to ensure that the reports were being reviewed by someone other than the preparer prior to submission to the PSC and that actual costs were used in the reports. Effect: Reports could contain errors due to estimation and lack of review. Questioned Costs: None reported. Recommendation: The Utility Commission should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports in place before submissions to state agencies are completed. Actual amounts supported by the financial software should be used in those reports. Management's Response: The Utility Commission General Manager or Communications System Supervisor will review the quarterly progress reports prepared by someone else. Section II of the Project Status Report instructions states “Answer each question to the best of your ability.” The work orders do not include all costs related to labor benefits and taxes, and also the electronics and customer premise equipment associated with the projects. These costs are calculated and added in when the project is completed and is being closed out. Estimating these items for the quarterly Project Status Report is providing the project costs spent through the respective quarter to the best of our ability due to the limitations of the work order reporting process.

Corrective Action Plan

Corrective Action Plan: The Utility Commission General Manager or Communications System Supervisor will review the quarterly progress reports prepared by someone else. Section II of the Project Status Report instructions states “Answer each question to the best of your ability.” The work orders do not include all costs related to labor benefits and taxes, and also the electronics and customer premise equipment associated with the projects. These costs are calculated and added in when the project is completed and is being closed out. Estimating these items for the quarterly Project Status Report is providing the project costs spent through the respective quarter to the best of our ability due to the limitations of the work order reporting process. Planned Completion Date for the Corrective Action: On-going Contact Persons Responsible for the Corrective Action Plan: The following Reedsburg Utility staff members are responsible for items outlined above in the Corrective Action Plan: • Brett Schuppner, Reedsburg Utility General Manager • Ken Las, Communications System Supervisor

Categories

Internal Control / Segregation of Duties Subrecipient Monitoring Reporting Equipment & Real Property Management Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 499862 2023-004
    Significant Deficiency
  • 1076303 2023-003
    Significant Deficiency
  • 1076304 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $725,303
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $322,500
20.509 Formula Grants for Rural Areas and Tribal Transit Program $157,151
20.106 Airport Improvement Program, Covid-19 Airports Programs, and Infrastructure Investment and Jobs Act Programs $32,000
16.540 Juvenile Justice and Delinquency Prevention $12,439
20.600 State and Community Highway Safety $7,715