Audit 47633

FY End
2022-12-31
Total Expended
$20.93M
Findings
4
Programs
9
Organization: City of Sheboygan (WI)
Year: 2022 Accepted: 2023-10-01

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
44454 2022-006 Significant Deficiency - L
44455 2022-007 Significant Deficiency - H
620896 2022-006 Significant Deficiency - L
620897 2022-007 Significant Deficiency - H

Contacts

Name Title Type
JJ7BCGBDMBN5 Kaitlyn Krueger Auditee
9204593304 Wendi Unger Auditor
No contacts on file

Notes to SEFA

Title: Loan/loan guarantee outstanding balances 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 Schedule 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. Loans issued under the U.S. Department of Housing and Urban Development Section 108 loan program (14.248) were $3,200,000 during the year ended December 31, 2022. The balance of loans outstanding under the Section 108 loan program was $3,040,000 at December 31, 2022.
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 Schedule 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) include 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, 2022. The information in this 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 Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.

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: The City reported $9,550,000 as expenditures for an infrastructure project in the Water Utility when only $7,689,637 was actually spent on the project during 2022. 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. Effect: The City overstated project expenditures in the quarterly submission of Project and Expenditure Reports during for 2022. 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 contract for Loan Guarantee Assistance under Section 108 of the Housing and Community Development Act of 1974 between the City and the U.S. Department of Housing and Urban Development (HUD) states that all funds in the Guaranteed Loan Fund Account must be withdrawn and disbursement by the Borrower for approved activities by September 30, 2022. Condition/Context: During our testing, we noted 46 out of 72 transactions claimed under the grant that were paid after September 30, 2022. Cause: The City was unaware of any deadlines to disburse the funds received from HUD. Effect: Costs could be claimed outside of the allowable period of performance. Questioned Costs: Unknown Recommendation: We recommend that the City develop and implement procedures for reviewing contracts and award agreements to determine the grant period of performance.
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: The City reported $9,550,000 as expenditures for an infrastructure project in the Water Utility when only $7,689,637 was actually spent on the project during 2022. 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. Effect: The City overstated project expenditures in the quarterly submission of Project and Expenditure Reports during for 2022. 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 contract for Loan Guarantee Assistance under Section 108 of the Housing and Community Development Act of 1974 between the City and the U.S. Department of Housing and Urban Development (HUD) states that all funds in the Guaranteed Loan Fund Account must be withdrawn and disbursement by the Borrower for approved activities by September 30, 2022. Condition/Context: During our testing, we noted 46 out of 72 transactions claimed under the grant that were paid after September 30, 2022. Cause: The City was unaware of any deadlines to disburse the funds received from HUD. Effect: Costs could be claimed outside of the allowable period of performance. Questioned Costs: Unknown Recommendation: We recommend that the City develop and implement procedures for reviewing contracts and award agreements to determine the grant period of performance.