Audit 357711

FY End
2024-12-31
Total Expended
$4.34M
Findings
4
Programs
7
Organization: Charter Township of Northville (MI)
Year: 2024 Accepted: 2025-06-02

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
562080 2024-001 Material Weakness - L
562081 2024-002 Material Weakness - I
1138522 2024-001 Material Weakness - L
1138523 2024-002 Material Weakness - I

Contacts

Name Title Type
JAAJHNDH2M23 Wendy Hillman Auditee
2486620490 Kari Shea 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 Charter Township of Northville (the “Township”) under programs of the federal government for the year ended December 31, 2024. 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 Modified Accrual Basis of accounting. 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 and frequently asked questions as outlined in the 2024 Compliance Supplement Addendum. The pass through entity identifying numbers are presented where available. The Township has elected to use the 10 percent de minimis indirect cost rate to recover indirect costs as allowed under the Uniform Guidance. De Minimis Rate Used: Y Rate Explanation: The Township has elected 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 - ALN 21.027, COVID-19 - Coronavirus State and Local Fiscal Recovery Fund (CSLFRF) Federal Award Identification Number and Year - FAIN not available, 2022 Pass-through Entity - N/A - Direct funded Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.303(a), nonfederal entities must establish and maintain effective intenral control over the federal award that provides resonable assurance that the non federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The Township did not have controls in place surrounding the review of annual performance reporting. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not Applicable If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not Applicable Context - As the Township recieved less than $10 million of CSLFRF funding, the Township is required to submit an annual report for the program and have controls in place to ensure the report is filed on time and no errors in reporting occur. Cause and Effect - During the review of internal controls over the annual performance report required by the program, it was noted that there was no secondary review of the annual report before or after submission however, the report was filed on time and no errors in reporting were noted as a result of our audit procedures. Recommendation - In order to ensure reporting requirements are met and that reports are accurate, we recommend the Township incorporate a formal review process of the annual report. Views of Responsible Officials and Corrective Action Plan - The Township has implemented a formal review process within the Finance and Budget Department to ensure the integrity of annual performance reporting. One staff member has been designated to compile and complete the performance reports, while a separate finance team member is responsible for conducting an independent review prior to submission. To support this process, an internal timeline has been established to allow sufficient time for thorough review and validation of all performance data before final submission.
Assistance Listing, Federal Agency, and Program Name - ALN 21.027, COVID-19 - Coronavirus State and Local Fiscal Recovery Fund (CSLFRF) Federal Award Identification Number and Year - FAIN not available, 2022 Pass-through Entity - N/A - Direct funded Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.501(h), for procuremnt transactions in which the contractor is made responsible for meeting program requirements, the auditee must ensure those requirements are met, including by clearly stating the contractor's responsibilities within the contract and reviewing the contractor's records to determine compliance. Per the Department of Treasury’s 2022 Final Rule, recipients of Coronavirus State and Local Fiscal Recovery Funds who report expenditures under the revenue loss category are required to follow their internal policies related to incurring expenditures and procuring goods and services. The Township’s procurement policy requires ensuring contractors are not suspended or debarred prior to entering into a contract that is funded with federal awards. Condition - The Township engaged a contractor to perform procurement activities funded by the revenue loss component of their Coronavirus State and Local Fiscal Recovery Funds award and did not have controls in place to ensure that the contractor was following the Township's procurement policy related to, specifically checking and ensuring vendors were not suspension and debarred prior to the Township entering into the agreements with the contractors. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not Applicable Identification of How Questioned Costs Were Computed - Not Applicable Context - As the Township applied contractor expenses to the revenue loss category of CSLFRF, the Township is required to have a system of internal controls to ensure the contractor hired to perform procurement activities followed their Township’s policy regarding suspension and debarment requirements. Cause and Effect - The Township hired a contractor to perform procurement and suspension and debarement activities, however, did not have controls in place to monitor that activity and ensure procurement transactions recommended by the contractors for the project were entered into with vendors that were not suspended or debared. This lack of control did not result in any unallowable costs to the federal program. Recommendation - In order to properly monitor compliance passed through the contractor, we recommend that the Township incorporates controls for obtaining supporting documentation of the suspension and debarment check being performed by the contractor. Views of Responsible Officials and Planned Corrective Actions - As part of the procurement process, the Township will require all contractors to provide documentation verifying that neither they nor their subcontractors are suspended or debarred from conducting business with federal agencies. This verification will be conducted through the federal System for Award Management (SAM.gov). To ensure compliance, procurement files will include printed or electronically saved screenshots from SAM.gov confirming the status of each contractor and subcontractor at the time of the contract award.
Assistance Listing, Federal Agency, and Program Name - ALN 21.027, COVID-19 - Coronavirus State and Local Fiscal Recovery Fund (CSLFRF) Federal Award Identification Number and Year - FAIN not available, 2022 Pass-through Entity - N/A - Direct funded Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.303(a), nonfederal entities must establish and maintain effective intenral control over the federal award that provides resonable assurance that the non federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition - The Township did not have controls in place surrounding the review of annual performance reporting. Questioned Costs - None Identification of How Questioned Costs Were Computed - Not Applicable If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not Applicable Context - As the Township recieved less than $10 million of CSLFRF funding, the Township is required to submit an annual report for the program and have controls in place to ensure the report is filed on time and no errors in reporting occur. Cause and Effect - During the review of internal controls over the annual performance report required by the program, it was noted that there was no secondary review of the annual report before or after submission however, the report was filed on time and no errors in reporting were noted as a result of our audit procedures. Recommendation - In order to ensure reporting requirements are met and that reports are accurate, we recommend the Township incorporate a formal review process of the annual report. Views of Responsible Officials and Corrective Action Plan - The Township has implemented a formal review process within the Finance and Budget Department to ensure the integrity of annual performance reporting. One staff member has been designated to compile and complete the performance reports, while a separate finance team member is responsible for conducting an independent review prior to submission. To support this process, an internal timeline has been established to allow sufficient time for thorough review and validation of all performance data before final submission.
Assistance Listing, Federal Agency, and Program Name - ALN 21.027, COVID-19 - Coronavirus State and Local Fiscal Recovery Fund (CSLFRF) Federal Award Identification Number and Year - FAIN not available, 2022 Pass-through Entity - N/A - Direct funded Finding Type - Material weakness Repeat Finding - No Criteria - Per 2 CFR 200.501(h), for procuremnt transactions in which the contractor is made responsible for meeting program requirements, the auditee must ensure those requirements are met, including by clearly stating the contractor's responsibilities within the contract and reviewing the contractor's records to determine compliance. Per the Department of Treasury’s 2022 Final Rule, recipients of Coronavirus State and Local Fiscal Recovery Funds who report expenditures under the revenue loss category are required to follow their internal policies related to incurring expenditures and procuring goods and services. The Township’s procurement policy requires ensuring contractors are not suspended or debarred prior to entering into a contract that is funded with federal awards. Condition - The Township engaged a contractor to perform procurement activities funded by the revenue loss component of their Coronavirus State and Local Fiscal Recovery Funds award and did not have controls in place to ensure that the contractor was following the Township's procurement policy related to, specifically checking and ensuring vendors were not suspension and debarred prior to the Township entering into the agreements with the contractors. Questioned Costs - None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported - Not Applicable Identification of How Questioned Costs Were Computed - Not Applicable Context - As the Township applied contractor expenses to the revenue loss category of CSLFRF, the Township is required to have a system of internal controls to ensure the contractor hired to perform procurement activities followed their Township’s policy regarding suspension and debarment requirements. Cause and Effect - The Township hired a contractor to perform procurement and suspension and debarement activities, however, did not have controls in place to monitor that activity and ensure procurement transactions recommended by the contractors for the project were entered into with vendors that were not suspended or debared. This lack of control did not result in any unallowable costs to the federal program. Recommendation - In order to properly monitor compliance passed through the contractor, we recommend that the Township incorporates controls for obtaining supporting documentation of the suspension and debarment check being performed by the contractor. Views of Responsible Officials and Planned Corrective Actions - As part of the procurement process, the Township will require all contractors to provide documentation verifying that neither they nor their subcontractors are suspended or debarred from conducting business with federal agencies. This verification will be conducted through the federal System for Award Management (SAM.gov). To ensure compliance, procurement files will include printed or electronically saved screenshots from SAM.gov confirming the status of each contractor and subcontractor at the time of the contract award.