FAC Explorer

Audit 14451

FY End
2023-06-30
Total Expended
$4.16M
Findings
4
Programs
4
Organization: City of Swartz Creek, Michigan (MI)
Year: 2023 Accepted: 2024-01-30
Auditor: Plante & Moran PLLC

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
10799 2023-003 Material Weakness - L
10800 2023-003 Material Weakness - L
587241 2023-003 Material Weakness - L
587242 2023-003 Material Weakness - L

Programs

ALN Program Spent Major Findings
10.766 Community Facilities Loans and Grants $2.84M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $263,705 Yes 1
20.205 Highway Planning and Construction $12,083 - 0
14.218 Community Development Block Grants/entitlement Grants $2,101 - 0

Contacts

Name Title Type
PELPKJKR8JM8 Amy Nichols Auditee
8106354464 Pamela Hill Auditor
No contacts on file

Notes to SEFA

Title: Loan Balances Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of City of Swartz Creek, Michigan (the "City") under programs of the federal government for the year ended June 30, 2023. The information in the Schedule 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 (the "Uniform Guidance"). 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. Expenditures reported in the Schedule are reported on the same basis of accounting as the basic financial statements. Such expenditures are recognized following the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The pass-through entity identifying numbers are presented where available. City of Swartz Creek, Michigan has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: City of Swartz Creek, Michigan has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs, as allowed under the Uniform Guidance. Loans outstanding at the beginning of the year and loans made during the year are included in the federal expenditures presented in the schedule of expenditures of federal awards. Existing loans are included because there are continuing compliance requirements. The balances of loans outstanding at June 30, 2023 consist of the following: See the Notes to the SEFA for chart/table

Finding Details

Finding 2023-003
Assistance Listing Number, Federal Agency, and Program Name - 21.027, U.S. Department of the Treasury, Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - N/A Pass-through Entity - Genesee County, Michigan Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expenses. Condition - The SEFA for the year ended June 30, 2023 was not accurately prepared, as it originally included expenditures that were improperly excluded from the SEFA for the year ended June 30, 2022. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated. These revisions related to $136,295 of federal awards expended during the year ended June 30, 2022 that were not reported on the SEFA until the year ended June 30, 2023. These expenditures related to ALN 21.027 (Coronavirus State and Local Fiscal Recovery Funds). This amount did not impact the program type or major program determination for the year ended June 30, 2022. Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the City's schedule of expenditures of federal awards for the prior year being understated and the amounts included in the current year expenditures of federal awards prior to audit-identified revisions. The amounts did not impact the program type or major program determination for the year ended June 30, 2022. Recommendation - The City should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The City will implement additional supervisory review of expenditures included on the SEFA.
Finding 2023-003
Assistance Listing Number, Federal Agency, and Program Name - 21.027, U.S. Department of the Treasury, Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - N/A Pass-through Entity - Genesee County, Michigan Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expenses. Condition - The SEFA for the year ended June 30, 2023 was not accurately prepared, as it originally included expenditures that were improperly excluded from the SEFA for the year ended June 30, 2022. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated. These revisions related to $136,295 of federal awards expended during the year ended June 30, 2022 that were not reported on the SEFA until the year ended June 30, 2023. These expenditures related to ALN 21.027 (Coronavirus State and Local Fiscal Recovery Funds). This amount did not impact the program type or major program determination for the year ended June 30, 2022. Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the City's schedule of expenditures of federal awards for the prior year being understated and the amounts included in the current year expenditures of federal awards prior to audit-identified revisions. The amounts did not impact the program type or major program determination for the year ended June 30, 2022. Recommendation - The City should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The City will implement additional supervisory review of expenditures included on the SEFA.
Finding 2023-003
Assistance Listing Number, Federal Agency, and Program Name - 21.027, U.S. Department of the Treasury, Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - N/A Pass-through Entity - Genesee County, Michigan Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expenses. Condition - The SEFA for the year ended June 30, 2023 was not accurately prepared, as it originally included expenditures that were improperly excluded from the SEFA for the year ended June 30, 2022. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated. These revisions related to $136,295 of federal awards expended during the year ended June 30, 2022 that were not reported on the SEFA until the year ended June 30, 2023. These expenditures related to ALN 21.027 (Coronavirus State and Local Fiscal Recovery Funds). This amount did not impact the program type or major program determination for the year ended June 30, 2022. Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the City's schedule of expenditures of federal awards for the prior year being understated and the amounts included in the current year expenditures of federal awards prior to audit-identified revisions. The amounts did not impact the program type or major program determination for the year ended June 30, 2022. Recommendation - The City should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The City will implement additional supervisory review of expenditures included on the SEFA.
Finding 2023-003
Assistance Listing Number, Federal Agency, and Program Name - 21.027, U.S. Department of the Treasury, Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - N/A Pass-through Entity - Genesee County, Michigan Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expenses. Condition - The SEFA for the year ended June 30, 2023 was not accurately prepared, as it originally included expenditures that were improperly excluded from the SEFA for the year ended June 30, 2022. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated. These revisions related to $136,295 of federal awards expended during the year ended June 30, 2022 that were not reported on the SEFA until the year ended June 30, 2023. These expenditures related to ALN 21.027 (Coronavirus State and Local Fiscal Recovery Funds). This amount did not impact the program type or major program determination for the year ended June 30, 2022. Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in the City's schedule of expenditures of federal awards for the prior year being understated and the amounts included in the current year expenditures of federal awards prior to audit-identified revisions. The amounts did not impact the program type or major program determination for the year ended June 30, 2022. Recommendation - The City should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards. Views of Responsible Officials and Corrective Action Plan - The City will implement additional supervisory review of expenditures included on the SEFA.