Audit 40977

FY End
2022-12-31
Total Expended
$7.64M
Findings
2
Programs
18
Organization: City of Beloit (WI)
Year: 2022 Accepted: 2023-07-13

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
GWBPLNMWLVB6 Dawn Deuvall Auditee
6083646686 Carla Gogin Auditor
No contacts on file

Notes to SEFA

Title: Pass-Through Agencies Accounting Policies: Expenditures reported on the Schedules are reported on the 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The following identifies the pass-through agency acronyms used on the schedule of expenditures of federal awards:C/ JanesvilleCity of Janesville, WisconsinWI DOAWisconsin Department of AdministrationWI DOTWisconsin Department of TransportationWI DOJWisconsin Department of JusticeWI DNRWisconsin Department of Natural ResourcesIL DOTIllinois Department of Transportation
Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedules are reported on the 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedules of expenditures of federal and state awards (the Schedules) includes the federal and state grant activity of the City of Beloit (the City) under programs of the federal and state government for the year ended December 31, 2022. The information in these schedules are 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, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.The reporting entity for the City is based upon criteria established by the Governmental Accounting Standards Board. The City is the primary government according to GASB criteria, while the Beloit Community Development Authority (CDA) is a component unit. Federal and state awards received directly by the CDA are included in this report.
Title: Pre-2022 Expenditures on Schedule of Expenditures of State Awards Accounting Policies: Expenditures reported on the Schedules are reported on the 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. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Knowles-Nelson Stewardship Program - Urban Rivers, State Number 370.TA1, was a major program for 2022. During our testing, we noted that all the expenditures related to this grant were incurred prior to 2022, but the City was not reimbursed until 2022. These expenditures should have been included on the Schedule of Expenditures of State Awards in the years that they were incurred. As they were missed, we elected to include them on the 2022 Schedule of Expenditures of State Awards and test it as a major program.

Finding Details

Finding 2022-003 Program Assistance Listing Number: 21.027 COVID-19 Coronavirus State & Local Fiscal Recovery Funds Federal Grantor: U.S. Department of Treasury Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations, and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: The Project and Expenditure Report and the Interim Report tested were not reviewed by an independent person before submission. Cause: The City did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurate and submitted timely. The sample was not a statistically valid sample. Effect: Reports that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The City should review its internal control procedures to ensure there are proper review and approval processes in place over completeness and accuracy of its reporting requirements. Management's Response: The City has established a procedure where the Finance Director will extract all the appropriate documentation from MUNIS and assemble the applicable report. The Finance Director will print the report for review and approval by the Director of Accounting prior to submitting the report to the United States Treasury via the Treasury Portal.
Finding 2022-003 Program Assistance Listing Number: 21.027 COVID-19 Coronavirus State & Local Fiscal Recovery Funds Federal Grantor: U.S. Department of Treasury Criteria: The Uniform Guidance and State Single Audit Guidelines require that local entities receiving federal and state awards establish and maintain internal control designed to reasonably ensure compliance with laws, regulations, and program compliance requirements. The Uniform Guidance and State Single Audit Guidelines further require auditors to obtain an understanding of the local entity's internal control over federal and state programs. To minimize the risk of errors, internal controls should be in place for all program compliance requirements, including the preparation and submission reports, which should be reviewed and approved by a responsible party other than the original preparer. Condition/Context: The Project and Expenditure Report and the Interim Report tested were not reviewed by an independent person before submission. Cause: The City did not have internal control procedures in place requiring an independent person to review the reports before submission and ensure the reports were accurate and submitted timely. The sample was not a statistically valid sample. Effect: Reports that were submitted could contain errors. Questioned Costs: None noted. Recommendation: The City should review its internal control procedures to ensure there are proper review and approval processes in place over completeness and accuracy of its reporting requirements. Management's Response: The City has established a procedure where the Finance Director will extract all the appropriate documentation from MUNIS and assemble the applicable report. The Finance Director will print the report for review and approval by the Director of Accounting prior to submitting the report to the United States Treasury via the Treasury Portal.