Audit 321788

FY End
2023-12-31
Total Expended
$36.15M
Findings
2
Programs
6
Organization: City of Sheboygan (WI)
Year: 2023 Accepted: 2024-09-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
498967 2023-006 Significant Deficiency Yes L
1075409 2023-006 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
66.468 Drinking Water State Revolving Fund $22.15M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.55M Yes 1
66.202 Congressionally Mandated Projects $2.00M Yes 0
14.218 Community Development Block Grants/entitlement Grants $1.58M Yes 0
20.507 Federal Transit Formula Grants $1.22M - 0
20.600 State and Community Highway Safety $20,000 - 0

Contacts

Name Title Type
JJ7BCGBDMBN5 Kaitlyn Krueger Auditee
9204593304 Wendi 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. 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 Sheboygan (the 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: Loan and Loan Guarantee Programs 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. 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. Loans issued under the U.S. Department of Housing and Urban Development Section 108 loan program (14.248) were $-0- during the year ended December 31, 2023. The balance of loans outstanding under the Section 108 loan program was $2,720,000 at December 31, 2023.

Finding Details

Criteria: The U.S. Department of the Treasury requires quarterly submission of Project and Expenditure Reports for Metropolitan cities with a population below 250,000 residents that are allocated more than $10 million in SLFRF funding. These quarterly reports should report expenditures for costs incurred during that reporting period. Condition/Context: The City reported $9,550,000 as expenditures for an infrastructure project in the Water Utility when only $9,308,214 was actually spent on the project during 2022 and 2023. Cause: The City used the amount that was disbursed to the Water Utility as the expenditure, not the amount the Water Utility spent in 2022 and 2023. Effect: The City overstated project expenditures in the quarterly submission of Project and Expenditure Reports during for 2022 and 2023. Questioned Costs: Unknown Recommendation: We recommend that the City work with the Water Utility to determine and report actual expenditures incurred for the project for each quarterly submission.
Criteria: The U.S. Department of the Treasury requires quarterly submission of Project and Expenditure Reports for Metropolitan cities with a population below 250,000 residents that are allocated more than $10 million in SLFRF funding. These quarterly reports should report expenditures for costs incurred during that reporting period. Condition/Context: The City reported $9,550,000 as expenditures for an infrastructure project in the Water Utility when only $9,308,214 was actually spent on the project during 2022 and 2023. Cause: The City used the amount that was disbursed to the Water Utility as the expenditure, not the amount the Water Utility spent in 2022 and 2023. Effect: The City overstated project expenditures in the quarterly submission of Project and Expenditure Reports during for 2022 and 2023. Questioned Costs: Unknown Recommendation: We recommend that the City work with the Water Utility to determine and report actual expenditures incurred for the project for each quarterly submission.