Audit 410423

FY End
2024-12-31
Total Expended
$112.70M
Findings
81
Programs
81
Organization: MacOmb County (MI)
Year: 2024 Accepted: 2026-09-04
Auditor: UHY LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1228757 2024-006 Material Weakness Yes P
1228758 2024-006 Material Weakness Yes P
1228759 2024-006 Material Weakness Yes P
1228760 2024-006 Material Weakness Yes P
1228761 2024-006 Material Weakness Yes P
1228762 2024-006 Material Weakness Yes P
1228763 2024-006 Material Weakness Yes P
1228764 2024-006 Material Weakness Yes P
1228765 2024-006 Material Weakness Yes P
1228766 2024-006 Material Weakness Yes P
1228767 2024-006 Material Weakness Yes P
1228768 2024-006 Material Weakness Yes P
1228769 2024-006 Material Weakness Yes P
1228770 2024-006 Material Weakness Yes P
1228771 2024-006 Material Weakness Yes P
1228772 2024-006 Material Weakness Yes P
1228773 2024-006 Material Weakness Yes P
1228774 2024-006 Material Weakness Yes P
1228775 2024-006 Material Weakness Yes P
1228776 2024-006 Material Weakness Yes P
1228777 2024-006 Material Weakness Yes P
1228778 2024-006 Material Weakness Yes P
1228779 2024-006 Material Weakness Yes P
1228780 2024-006 Material Weakness Yes P
1228781 2024-006 Material Weakness Yes P
1228782 2024-006 Material Weakness Yes P
1228783 2024-006 Material Weakness Yes P
1228784 2024-006 Material Weakness Yes P
1228785 2024-006 Material Weakness Yes P
1228786 2024-006 Material Weakness Yes P
1228787 2024-006 Material Weakness Yes P
1228788 2024-006 Material Weakness Yes P
1228789 2024-006 Material Weakness Yes P
1228790 2024-006 Material Weakness Yes P
1228791 2024-006 Material Weakness Yes P
1228792 2024-006 Material Weakness Yes P
1228793 2024-006 Material Weakness Yes P
1228794 2024-006 Material Weakness Yes P
1228795 2024-006 Material Weakness Yes P
1228796 2024-006 Material Weakness Yes P
1228797 2024-006 Material Weakness Yes P
1228798 2024-006 Material Weakness Yes P
1228799 2024-006 Material Weakness Yes P
1228800 2024-006 Material Weakness Yes P
1228801 2024-006 Material Weakness Yes P
1228802 2024-006 Material Weakness Yes P
1228803 2024-006 Material Weakness Yes P
1228804 2024-006 Material Weakness Yes P
1228805 2024-006 Material Weakness Yes P
1228806 2024-006 Material Weakness Yes P
1228807 2024-006 Material Weakness Yes P
1228808 2024-006 Material Weakness Yes P
1228809 2024-006 Material Weakness Yes P
1228810 2024-006 Material Weakness Yes P
1228811 2024-006 Material Weakness Yes P
1228812 2024-006 Material Weakness Yes P
1228813 2024-006 Material Weakness Yes P
1228814 2024-006 Material Weakness Yes P
1228815 2024-006 Material Weakness Yes P
1228816 2024-006 Material Weakness Yes P
1228817 2024-006 Material Weakness Yes P
1228818 2024-006 Material Weakness Yes P
1228819 2024-006 Material Weakness Yes P
1228820 2024-006 Material Weakness Yes P
1228821 2024-006 Material Weakness Yes P
1228822 2024-006 Material Weakness Yes P
1228823 2024-006 Material Weakness Yes P
1228824 2024-006 Material Weakness Yes P
1228825 2024-006 Material Weakness Yes P
1228826 2024-006 Material Weakness Yes P
1228827 2024-006 Material Weakness Yes P
1228828 2024-006 Material Weakness Yes P
1228829 2024-006 Material Weakness Yes P
1228830 2024-006 Material Weakness Yes P
1228831 2024-008 Material Weakness Yes L
1228832 2024-007 Material Weakness Yes L
1228833 2024-007 Material Weakness Yes L
1228834 2024-007 Material Weakness Yes L
1228835 2024-007 Material Weakness Yes L
1228836 2024-007 Material Weakness Yes L
1228837 2024-007 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
93.600 HEAD START $8.78M Yes 1
93.788 OPIOID STR $1.98M Yes 0
93.563 CHILD SUPPORT SERVICES $1.43M Yes 0
93.569 COMMUNITY SERVICES BLOCK GRANT $973,144 Yes 0
17.235 SENIOR COMMUNITY SERVICE EMPLOYMENT PROGRAM $803,476 Yes 2
93.045 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART C, NUTRITION SERVICES $562,696 Yes 0
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND SUBSTANCE USE PROGRAM $538,159 Yes 0
16.820 POSTCONVICTION TESTING OF DNA EVIDENCE $407,581 Yes 0
10.558 CHILD AND ADULT CARE FOOD PROGRAM $406,195 Yes 0
10.569 EMERGENCY FOOD ASSISTANCE PROGRAM (FOOD COMMODITIES) $364,296 Yes 0
20.939 SAFE STREETS AND ROADS FOR ALL $351,962 Yes 0
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $341,400 Yes 0
17.245 TRADE ADJUSTMENT ASSISTANCE $323,924 Yes 0
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $226,949 Yes 2
16.040 MATTHEW SHEPARD AND JAMES BYRD, JR. HATE CRIMES EDUCATION, INVESTIGATION AND PROSECUTION PROGRAM $183,003 Yes 0
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $164,000 Yes 0
97.067 HOMELAND SECURITY GRANT PROGRAM $163,745 Yes 1
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $160,853 Yes 0
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $157,790 Yes 0
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $149,757 Yes 0
81.042 WEATHERIZATION ASSISTANCE FOR LOW-INCOME PERSONS $137,093 Yes 0
97.024 EMERGENCY FOOD AND SHELTER NATIONAL BOARD PROGRAM $135,447 Yes 0
64.033 VA SUPPORTIVE SERVICES FOR VETERAN FAMILIES PROGRAM $120,960 Yes 0
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $118,811 Yes 0
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $117,427 Yes 0
17.268 H-1B JOB TRAINING GRANTS $109,616 Yes 0
10.730 COMMUNITY PROJECT FUNDS - CONGRESSIONALLY DIRECTED SPENDING $109,051 Yes 0
17.285 REGISTERED APPRENTICESHIP $99,181 Yes 0
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $90,886 Yes 0
11.307 ECONOMIC ADJUSTMENT ASSISTANCE $90,117 Yes 0
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $83,520 Yes 0
84.425 EDUCATION STABILIZATION FUND $73,761 Yes 0
93.052 NATIONAL FAMILY CAREGIVER SUPPORT, TITLE III, PART E $66,266 Yes 0
93.658 FOSTER CARE TITLE IV-E $65,003 Yes 0
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $60,983 Yes 0
10.568 EMERGENCY FOOD ASSISTANCE PROGRAM (ADMINISTRATIVE COSTS) $58,288 Yes 0
17.225 UNEMPLOYMENT INSURANCE $58,146 Yes 0
93.889 NATIONAL BIOTERRORISM HOSPITAL PREPAREDNESS PROGRAM $58,100 Yes 0
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $57,239 Yes 0
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $53,978 Yes 0
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $53,533 Yes 0
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $40,938 Yes 0
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $39,920 Yes 0
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $38,924 Yes 0
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $36,440 Yes 0
14.267 CONTINUUM OF CARE PROGRAM $36,144 Yes 0
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $34,942 Yes 0
11.419 COASTAL ZONE MANAGEMENT ADMINISTRATION AWARDS $33,599 Yes 0
20.205 HIGHWAY PLANNING AND CONSTRUCTION $32,740 Yes 0
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $30,788 Yes 0
93.217 FAMILY PLANNING SERVICES $29,312 Yes 0
10.187 THE EMERGENCY FOOD ASSISTANCE PROGRAM (TEFAP) COMMODITY CREDIT CORPORATION ELIGIBLE RECIPIENT FUNDS $28,133 Yes 0
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $25,671 Yes 0
17.801 JOBS FOR VETERANS STATE GRANTS $24,663 Yes 0
93.977 SEXUALLY TRANSMITTED DISEASES (STD) PREVENTION AND CONTROL GRANTS $23,750 Yes 0
66.469 GEOGRAPHIC PROGRAMS - GREAT LAKES RESTORATION INITIATIVE $22,650 Yes 0
93.053 NUTRITION SERVICES INCENTIVE PROGRAM $19,072 Yes 0
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $18,211 Yes 0
21.009 VOLUNTEER INCOME TAX ASSISTANCE (VITA) MATCHING GRANT PROGRAM $15,124 Yes 0
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $14,726 Yes 0
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $12,599 Yes 0
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $11,461 Yes 0
66.472 BEACH MONITORING AND NOTIFICATION PROGRAM IMPLEMENTATION GRANTS $10,200 Yes 0
93.778 GRANTS TO STATES FOR MEDICAID $9,016 Yes 0
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $8,911 Yes 0
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $7,939 Yes 0
93.008 MEDICAL RESERVE CORPS SMALL GRANT PROGRAM $5,732 Yes 0
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $4,990 Yes 0
16.582 CRIME VICTIM ASSISTANCE/DISCRETIONARY GRANTS $4,764 Yes 0
16.922 EQUITABLE SHARING PROGRAM $4,480 Yes 0
16.528 ENHANCED TRAINING AND SERVICES TO END VIOLENCE AND ABUSE OF WOMEN LATER IN LIFE $2,885 Yes 0
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $2,104 Yes 0
17.259 WIOA YOUTH ACTIVITIES $1,637 Yes 1
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $1,529 Yes 1
17.258 WIOA ADULT PROGRAM $1,511 Yes 1
93.991 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT $1,400 Yes 0
84.126 REHABILITATION SERVICES VOCATIONAL REHABILITATION GRANTS TO STATES $467 Yes 0
17.207 EMPLOYMENT SERVICE/WAGNER-PEYSER FUNDED ACTIVITIES $466 Yes 0
84.002 ADULT EDUCATION - BASIC GRANTS TO STATES $466 Yes 0
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $206 Yes 0
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $44 Yes 0

Contacts

Name Title Type
MUN5FKTBJLQ5 John Scanlon Auditee
5864695250 Amber Sutter Auditor
No contacts on file

Notes to SEFA

The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) includes federal grant activity of Macomb County, Michigan (the “County”) under programs of the federal government for the year ended December 31, 2024. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) 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 County, it is not intended to and does not present the financial position, changes in net position, or cash flows of the County.
Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in 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 County passes a certain amount of these federal awards to other local governments and nonprofit agencies (subrecipients) who provide the program services. These federal awards passed through to subrecipients are recognized as expended by the County in the period the program services are provided. The pass-through entity identifying numbers are presented on the Schedule when available.
The County does not charge indirect cost rates to the grants and therefore, the County has elected to not use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.
All subsequent events relative to the major programs were evaluated through August 31, 2026, the date the accompanying reports were available to be issued.

Finding Details

Assistance Listing Number, Federal Agency, and Program Name: All major programs Federal Award Identification Number and Year: 2024 Finding Type – Material weakness over compliance Repeat Finding - Yes Criteria – Per 2 CFR 200.512 (a) (1), the audit must be completed, and the data collection form described in paragraph (b) of this section and reporting package described in paragraph (c) of this section must be submitted within the earlier of 30 calendar days after receipt of the auditor's report(s), or nine months after the end of the audit period. Per 2 CFR 200.501 (b), a non-Federal entity that expends $750,000 or more during the non-Federal entity's fiscal year in Federal awards must have a single audit conducted in accordance with § 200.514. Condition – The data collection form was not submitted within the required time as required by 2 CFR 200.512 for the year ended December 31, 2024. Context – The County’s single audit was not completed prior to the due date of data collection form. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause – The County’s Schedule of Federal Awards was not prepared in a timely manner. Effect – Data collection forms were not submitted on time. Recommendation – We recommend that the County develop a reliable system to close the financial records in a timely manner. View of Responsible Officials and Corrective Action Plan – Management agrees with finding. See corrective action plan.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 17.235, Senior Community Service Employment Program Federal Award Identification Number and Year: 2022-1 Finding Type – Significant deficiency in internal control over compliance Repeat Finding - No Criteria – Per 2 CFR § 200.303, the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable 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 – During our testing for Reporting compliance, it was noted the client failed to submit the monthly expenditure reports for the period ended June 30, 2024 within the required time frame. Context – The required reports were not submitted by the due date. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause – Management noted that the accounting staff were not completing necessary accounting tasks in a timely manner and, therefore required reports were not submitted on time. Effect – The reports were submitted late. Recommendation – We recommend management increase awareness of federal program compliance requirements and monitor compliance with the requirements on regular basis. In addition, we recommend that management review its procedures and controls in place to ensure that reports are completed and submitted by the required due dates. View of Responsible Officials and Corrective Action Plan – Management agrees with finding. See corrective action plan.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 21.027, Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year: 2022-0001 & E20250728-002 & E20250157-001 Finding Type – Significant deficiency in internal control over compliance Repeat Finding - No Criteria – Per 2 CFR § 200.303, the non-Federal entity must establish and maintain effective internal control over the Federal award that provides reasonable 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 – During our testing for Reporting compliance, it was noted the client failed to submit the monthly expenditure reports for the period ended January 31, 2024, February 29, 2024, April 30, 2024, June 30, 2024, July 31, 2024, September 30, 2024, November 30, 2024, and December 31, 2024 within the required time frame. Context – The required report was not submitted by the due date. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause – Management noted that the accounting staff were not completing necessary accounting tasks in a timely manner and, therefore required reports were not submitted on time. Effect – The report was submitted late. Recommendation – We recommend management increase awareness of federal program compliance requirements and monitor compliance with the requirements on regular basis. In addition, we recommend that management review its procedures and controls in place to ensure that reports are completed and submitted by the required due dates. View of Responsible Officials and Corrective Action Plan – Management agrees with finding. See corrective action plan.