Audit 322964

FY End
2023-12-31
Total Expended
$3.96M
Findings
2
Programs
3
Organization: Charter Township of Commerce (MI)
Year: 2023 Accepted: 2024-09-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
500117 2023-003 Material Weakness - L
1076559 2023-003 Material Weakness - L

Contacts

Name Title Type
D1BYG4JR5ME1 Katelyn Massey Auditee
2486240110 Amanda Ward Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of the Charter Township of Commerce (the “Township”) under programs of the federal government for the year ended December 31, 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 Township, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Township. 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. The Township 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: The Township has elected not to use the 10 percent de minimis indirect cost rate to recover indirect costs as allowed under the Uniform Guidance.

Finding Details

Assistance Listing, Federal Agency, and Program Name - 21.027 U.S. Department of Treasury, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - Not Applicable Pass-through Entity - Not Applicable - Direct funded Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - 2 CFR 200.302, Financial Management, states the non-Federal entity's financial management systems, including records documenting compliance with Federal statutes and regulations and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes and regulations and the terms and conditions of the Federal award. Condition - The Township's March 31, 2024 report overstated expenses incurred for the reporting period by approximately $600,000. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - During testing, it was discovered that the project expenditure reported $4,128,095, representing the total amount of the award. However, as of the reporting date of March 31, 2024, the Township had not yet incurred expenditures totaling approximately $600,000. The March 31, 2024 report reflects the total activity through December 31, 2023. The U.S. Department of Treasury requires that the Township file a project and expenditure report annually for annual periods ended March 31 by April 30. Cause and Effect - The Township did not have an internal control structure that reconciled expenditures per the report to expenditures incurred as of the reporting date. The lack of internal control structure resulted in the March 31, 2024 report being overstated by approximately $600,000, i.e., the amount of expenditures not incurred as of the reporting date. Recommendation - We recommend that controls be implemented to ensure that amounts being recorded on grant reporting are traced to supporting costs incurred and documentation as of the reporting date to ensure reported amounts are accurate. Views of Responsible Officials and Corrective Action Plan- The Township will put in place a control where the treasurer, finance director, and department head responsible for the grant are reporting accurately costs incurred with reconciling supporting documentation and ensuring the reported amounts are correct.
Assistance Listing, Federal Agency, and Program Name - 21.027 U.S. Department of Treasury, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - Not Applicable Pass-through Entity - Not Applicable - Direct funded Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - 2 CFR 200.302, Financial Management, states the non-Federal entity's financial management systems, including records documenting compliance with Federal statutes and regulations and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes and regulations and the terms and conditions of the Federal award. Condition - The Township's March 31, 2024 report overstated expenses incurred for the reporting period by approximately $600,000. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not applicable Context - During testing, it was discovered that the project expenditure reported $4,128,095, representing the total amount of the award. However, as of the reporting date of March 31, 2024, the Township had not yet incurred expenditures totaling approximately $600,000. The March 31, 2024 report reflects the total activity through December 31, 2023. The U.S. Department of Treasury requires that the Township file a project and expenditure report annually for annual periods ended March 31 by April 30. Cause and Effect - The Township did not have an internal control structure that reconciled expenditures per the report to expenditures incurred as of the reporting date. The lack of internal control structure resulted in the March 31, 2024 report being overstated by approximately $600,000, i.e., the amount of expenditures not incurred as of the reporting date. Recommendation - We recommend that controls be implemented to ensure that amounts being recorded on grant reporting are traced to supporting costs incurred and documentation as of the reporting date to ensure reported amounts are accurate. Views of Responsible Officials and Corrective Action Plan- The Township will put in place a control where the treasurer, finance director, and department head responsible for the grant are reporting accurately costs incurred with reconciling supporting documentation and ensuring the reported amounts are correct.