Audit 398574

FY End
2023-12-31
Total Expended
$130.60M
Findings
19
Programs
75
Organization: MacOmb County (MI)
Year: 2023 Accepted: 2026-04-13
Auditor: UHY LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1206505 2023-008 Material Weakness Yes P
1206506 2023-008 Material Weakness Yes P
1206507 2023-008 Material Weakness Yes P
1206508 2023-008 Material Weakness Yes P
1206509 2023-009 Material Weakness Yes L
1206510 2023-009 Material Weakness Yes L
1206511 2023-009 Material Weakness Yes L
1206512 2023-010 Material Weakness Yes L
1206513 2023-010 Material Weakness Yes L
1206514 2023-010 Material Weakness Yes L
1206515 2023-010 Material Weakness Yes L
1206516 2023-011 Material Weakness Yes L
1206517 2023-011 Material Weakness Yes L
1206518 2023-011 Material Weakness Yes L
1206519 2023-011 Material Weakness Yes L
1206520 2023-012 Material Weakness Yes E
1206521 2023-012 Material Weakness Yes E
1206522 2023-012 Material Weakness Yes E
1206523 2023-012 Material Weakness Yes E

Programs

ALN Program Spent Major Findings
20.205 HIGHWAY PLANNING AND CONSTRUCTION $6.37M Yes 0
21.023 COVID-19MSHDA CERA 2 $2.16M Yes 0
93.788 OPIOID STR $1.69M Yes 0
93.600 HEAD START $816,562 Yes 0
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $783,063 Yes 0
17.235 SENIOR COMMUNITY SERVICE EMPLOYMENT PROGRAM $724,905 Yes 0
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $574,500 Yes 0
16.922 EQUITABLE SHARING PROGRAM $511,734 Yes 0
10.569 EMERGENCY FOOD ASSISTANCE PROGRAM (FOOD COMMODITIES) $491,362 Yes 0
93.499 LOW INCOME HOUSEHOLD WATER ASSISTANCE PROGRAM $465,737 Yes 0
93.563 CHILD SUPPORT SERVICES $375,579 Yes 0
17.268 H-1B JOB TRAINING GRANTS $363,977 Yes 0
93.045 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART C, NUTRITION SERVICES $354,507 Yes 0
64.033 Supportive Services for Veteran Families $349,155 Yes 0
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $278,238 Yes 0
93.569 COMMUNITY SERVICES BLOCK GRANT $261,629 Yes 1
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $213,770 Yes 0
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $196,250 Yes 0
84.425 EDUCATION STABILIZATION FUND $176,270 Yes 0
93.217 FAMILY PLANNING SERVICES $160,983 Yes 0
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $152,902 Yes 0
97.024 EMERGENCY FOOD AND SHELTER NATIONAL BOARD PROGRAM $150,000 Yes 0
93.778 MEDICAL ASSISTANCE PROGRAM $147,202 Yes 0
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $139,000 Yes 0
10.558 CHILD AND ADULT CARE FOOD PROGRAM $124,910 Yes 0
97.067 HOMELAND SECURITY GRANT PROGRAM $109,590 Yes 0
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $105,738 Yes 0
17.259 WIOA YOUTH ACTIVITIES $103,280 Yes 0
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $95,629 Yes 0
17.258 WIOA ADULT PROGRAM $95,335 Yes 0
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $95,207 Yes 0
93.977 SEXUALLY TRANSMITTED DISEASES (STD) PREVENTION AND CONTROL GRANTS $95,000 Yes 0
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $82,971 Yes 0
10.568 EMERGENCY FOOD ASSISTANCE PROGRAM (FOOD COMMODITIES) $72,361 Yes 0
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $70,205 Yes 0
93.991 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT $70,000 Yes 0
66.469 GEOGRAPHIC PROGRAMS - GREAT LAKES RESTORATION INITIATIVE $67,515 Yes 0
17.245 TRADE ADJUSTMENT ASSISTANCE $65,017 Yes 0
17.225 UNEMPLOYMENT INSURANCE $57,938 Yes 0
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $53,578 Yes 0
16.034 CORONAVIRUS EMERGENCY SUPPLEMENTAL FUNDING PROGRAM $51,600 Yes 0
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $51,183 Yes 0
10.568 EMERGENCY FOOD ASSISTANCE PROGRAM (ADMINISTRATIVE COSTS) $46,748 Yes 0
17.285 REGISTERED APPRENTICESHIP $43,348 Yes 0
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $42,975 Yes 1
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $42,064 Yes 0
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $40,000 Yes 0
14.267 CONTINUUM OF CARE PROGRAM $35,485 Yes 0
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $31,401 Yes 1
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $30,376 Yes 0
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $29,621 Yes 0
84.126 REHABILITATION SERVICES VOCATIONAL REHABILITATION GRANTS TO STATES $28,211 Yes 0
10.187 THE EMERGENCY FOOD ASSISTANCE PROGRAM (TEFAP) COMMODITY CREDIT CORPORATION ELIGIBLE RECIPIENT FUNDS $24,580 Yes 0
11.307 ECONOMIC ADJUSTMENT ASSISTANCE $22,671 Yes 0
10.730 COMMUNITY PROJECT FUNDS - CONGRESSIONALLY DIRECTED SPENDING $15,460 Yes 0
93.070 ENVIRONMENTAL PUBLIC HEALTH AND EMERGENCY RESPONSE $14,346 Yes 0
81.042 WEATHERIZATION ASSISTANCE FOR LOW-INCOME PERSONS $13,491 Yes 0
17.801 JOBS FOR VETERANS STATE GRANTS $12,397 Yes 0
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $11,715 Yes 0
93.053 NUTRITION SERVICES INCENTIVE PROGRAM $10,871 Yes 0
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $9,635 Yes 0
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $9,400 Yes 0
66.472 BEACH MONITORING AND NOTIFICATION PROGRAM IMPLEMENTATION GRANTS $6,200 Yes 0
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $4,950 Yes 0
93.568 LOW-INCOME HOME ENERGY ASSISTANCE $4,212 Yes 2
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $3,820 Yes 0
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $2,355 Yes 0
93.658 FOSTER CARE TITLE IV-E $1,333 Yes 0
66.468 DRINKING WATER STATE REVOLVING FUND $1,313 Yes 0
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $1,092 Yes 0
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $787 Yes 0
17.207 EMPLOYMENT SERVICE/WAGNER-PEYSER FUNDED ACTIVITIES $426 Yes 0
84.002 ADULT EDUCATION - BASIC GRANTS TO STATES $396 Yes 0
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $329 Yes 0
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $32 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 the Macomb County, Michigan (the “County”) under programs of the federal government for the year ended December 31, 2023. 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 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 April 8, 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: 2023 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, 2023. 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 93.558, Partnership, Accountability, Training, Hope (PATH) Federal Award Identification Number and Year: 2201MITANF & 2301MITANF 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 quarterly expenditures report for the period ended March 31, 2023 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.
Assistance Listing Number, Federal Agency, and Program Name: Assistance Listing Number 93.568, Low-Income Home Energy Assistance Federal Award Identification Number and Year: E20230849-001, E2024242910-00, E20230808-00, E2024-1887-00 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 Statement of Expenditures for six months between two programs and the final Statement of Expenditures 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 93.569, Community Services Block Grant Federal Award Identification Number and Year: E20234456-001, E20242464-001, E20230048-001, E20241850-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 Statement of Expenditures for four months and the final Statement of Expenditures 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 – The 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 93.568, Low-Income Home Energy Assistance Federal Award Identification Number and Year: E20230849-001, E2024242910-00, E20230808-00, E2024-1887-00 Finding Type – Significant deficiency in internal control over compliance Repeat Finding - No Criteria – Per the State of Michigan’s Program Guidance, an eligible participant in the program must fill out the declaration of no income to certify that the participant does not have any income to declare at the date of apply for the program. Condition – The County could not provide the declaration of no income to support the eligibility requirement for 1 of 60 participant files selected for testing. Context – The participant self-declaration of no income was missing. Identification of How Questioned Costs Were Computed – N/A Questioned Costs – None Cause – The County neglected to obtain and or keep the required declaration. The participant’s file does not contain the required information. Effect – The eligibility criteria for one participant subject to our testing was not supported. Recommendation – We recommend management increase awareness of federal program compliance requirements and monitor compliance with the requirements on a regular basis. In addition, we recommend that management review its procedures and controls in place to ensure that required eligibility documentation is completed and maintained. View of Responsible Officials and Corrective Action Plan – Management agrees with finding. See corrective action plan.