Audit 356566

FY End
2023-12-31
Total Expended
$41.29M
Findings
2
Programs
11
Organization: City of Waukesha (WI)
Year: 2023 Accepted: 2025-05-19

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
560794 2023-001 Significant Deficiency Yes I
1137236 2023-001 Significant Deficiency Yes I

Contacts

Name Title Type
L8JDE6AJ83L9 Joseph Ciurro Auditee
2625243560 Wendi Marie Unger Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedules are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. Program income is reported as revenue in the year that it is received De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. The accompanying schedules of expenditures of federal and state awards (the Schedules) includes the federal and state award activity of the City of Waukesha (City) under programs of the federal and state government for the year ended December 31, 2023. The information in these Schedules is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and the State Single Audit Guidelines. Because the Schedules present only a selected portion of the operations of the City, they are not intended to and do not present the financial position, changes in net position or cash flows of the City.
Title: Restatement of Previously Issued Schedule of Expenditures of Federal Awards Accounting Policies: Expenditures reported on the Schedules are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. Program income is reported as revenue in the year that it is received De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. Subsequent to the issuance of the City of Waukesha’s single audit report for the year ended December 31, 2023, the City identified an omission of a federal grant from the schedule of expenditures of federal and state awards. The differences between this report and the report previously issued includes the addition of $1,680,584 in funding received from the U.S. Environmental Protection Agency under Assistance Listing Number (ALN) 66.458 Capitalization Grants for Clear Water State Revolving Funds. In addition, ALN 66.458 was tested as a major federal program and audit finding 2023-002 was reported in the Financial Statement Findings Required to be Reported in Accordance With Government Auditing Standards section of the schedule of findings and question costs.

Finding Details

Finding 2023-001: Procurement Policy and Related Contract Program: 66.958 Water Infrastructure Finance and Innovation Federal Agency: U.S. Environmental Protection Agency Award No: WIFIA-N18147WI Award Year: 2023 This finding is a repeat finding of 2022-001 Criteria: 2 CFR section 200.318 - General Procurement Standards, requires non-Federal entities to have and use documented procurement procedures, consistent with State, local and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non-Federal entity's documented procurement procedures must conform to the procurement standards identified in §§ 200.317 through 200.327. Condition: We reviewed the water utility's procurement policy and service contracts with costs reimbursed during 2023, noting they did not contain necessary federal language related to conflicts of interest and debarment and suspension. Cause: The water utility has not received federal funding in the past and did not update their procurement policy when they sought federal funding for the Great Lakes Water Supply project. Additionally, service contracts were entered into prior to receiving federal funds. Effect: Without adequate control of contract language the water utility could enter into contracts related to the Great Lakes Water Supply project that do not qualify for federal reimbursement. Questioned Costs: None noted. Recommendation: We recommend the water utility review its procurement policy and make necessary updates to be in compliance with federal standards. Additionally, we recommend the utility enter into contract addendums related to contracts previously executed without required federal language. Management Response: Waukesha Water utility management has worked closely with WIFIA to craft contracts that include all necessary language prior to releasing RFPs for construction contracts. WIFIA was presented all service contracts to review prior to reimbursements received in fiscal year 2023. The finance department is working to update the procurement policy to ensure necessary federal language is included. The finance department will also work with service contractors to execute contract addendums.
Finding 2023-001: Procurement Policy and Related Contract Program: 66.958 Water Infrastructure Finance and Innovation Federal Agency: U.S. Environmental Protection Agency Award No: WIFIA-N18147WI Award Year: 2023 This finding is a repeat finding of 2022-001 Criteria: 2 CFR section 200.318 - General Procurement Standards, requires non-Federal entities to have and use documented procurement procedures, consistent with State, local and tribal laws and regulations and the standards of this section, for the acquisition of property or services required under a Federal award or subaward. The non-Federal entity's documented procurement procedures must conform to the procurement standards identified in §§ 200.317 through 200.327. Condition: We reviewed the water utility's procurement policy and service contracts with costs reimbursed during 2023, noting they did not contain necessary federal language related to conflicts of interest and debarment and suspension. Cause: The water utility has not received federal funding in the past and did not update their procurement policy when they sought federal funding for the Great Lakes Water Supply project. Additionally, service contracts were entered into prior to receiving federal funds. Effect: Without adequate control of contract language the water utility could enter into contracts related to the Great Lakes Water Supply project that do not qualify for federal reimbursement. Questioned Costs: None noted. Recommendation: We recommend the water utility review its procurement policy and make necessary updates to be in compliance with federal standards. Additionally, we recommend the utility enter into contract addendums related to contracts previously executed without required federal language. Management Response: Waukesha Water utility management has worked closely with WIFIA to craft contracts that include all necessary language prior to releasing RFPs for construction contracts. WIFIA was presented all service contracts to review prior to reimbursements received in fiscal year 2023. The finance department is working to update the procurement policy to ensure necessary federal language is included. The finance department will also work with service contractors to execute contract addendums.