Audit 402331

FY End
2025-09-30
Total Expended
$168.16M
Findings
38
Programs
66
Organization: Oakland County, Michigan (MI)
Year: 2025 Accepted: 2026-05-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1215636 2025-004 Material Weakness Yes L
1215637 2025-004 Material Weakness Yes L
1215638 2025-004 Material Weakness Yes L
1215639 2025-004 Material Weakness Yes L
1215640 2025-004 Material Weakness Yes L
1215641 2025-004 Material Weakness Yes L
1215642 2025-004 Material Weakness Yes L
1215643 2025-004 Material Weakness Yes L
1215644 2025-004 Material Weakness Yes L
1215645 2025-004 Material Weakness Yes L
1215646 2025-004 Material Weakness Yes L
1215647 2025-004 Material Weakness Yes L
1215648 2025-004 Material Weakness Yes L
1215649 2025-004 Material Weakness Yes L
1215650 2025-004 Material Weakness Yes L
1215651 2025-004 Material Weakness Yes L
1215652 2025-004 Material Weakness Yes L
1215653 2025-004 Material Weakness Yes L
1215654 2025-004 Material Weakness Yes L
1215655 2025-005 Material Weakness Yes J
1215656 2025-005 Material Weakness Yes J
1215657 2025-005 Material Weakness Yes J
1215658 2025-005 Material Weakness Yes J
1215659 2025-005 Material Weakness Yes J
1215660 2025-005 Material Weakness Yes J
1215661 2025-005 Material Weakness Yes J
1215662 2025-005 Material Weakness Yes J
1215663 2025-005 Material Weakness Yes J
1215664 2025-005 Material Weakness Yes J
1215665 2025-005 Material Weakness Yes J
1215666 2025-005 Material Weakness Yes J
1215667 2025-005 Material Weakness Yes J
1215668 2025-005 Material Weakness Yes J
1215669 2025-005 Material Weakness Yes J
1215670 2025-005 Material Weakness Yes J
1215671 2025-005 Material Weakness Yes J
1215672 2025-005 Material Weakness Yes J
1215673 2025-005 Material Weakness Yes J

Programs

ALN Program Spent Major Findings
66.458 CLEAN WATER STATE REVOLVING FUND $15.33M Yes 0
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $2.62M Yes 0
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $2.52M Yes 0
93.563 CHILD SUPPORT SERVICES $1.51M Yes 0
93.493 CONGRESSIONAL DIRECTIVES $1.30M Yes 0
66.202 CONGRESSIONALLY MANDATED PROJECTS $1.01M Yes 0
66.468 DRINKING WATER STATE REVOLVING FUND $947,464 Yes 0
17.225 UNEMPLOYMENT INSURANCE $813,059 Yes 0
93.778 GRANTS TO STATES FOR MEDICAID $615,255 Yes 0
21.019 CORONAVIRUS RELIEF FUND $577,946 Yes 0
93.870 MATERNAL, INFANT AND EARLY CHILDHOOD HOME VISITING GRANT $556,814 Yes 0
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $531,516 Yes 0
16.741 DNA BACKLOG REDUCTION PROGRAM $421,443 Yes 0
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $389,912 Yes 0
11.307 ECONOMIC ADJUSTMENT ASSISTANCE $386,444 Yes 0
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $326,907 Yes 2
17.268 H-1B JOB TRAINING GRANTS $295,897 Yes 0
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $275,816 Yes 0
97.039 HAZARD MITIGATION GRANT $265,802 Yes 0
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $255,622 Yes 0
16.321 ANTITERRORISM EMERGENCY RESERVE $226,024 Yes 0
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $223,653 Yes 0
17.285 REGISTERED APPRENTICESHIP $210,578 Yes 0
93.658 FOSTER CARE TITLE IV-E $201,342 Yes 0
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $199,588 Yes 0
97.067 HOMELAND SECURITY GRANT PROGRAM $187,142 Yes 0
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $176,929 Yes 0
10.331 GUS SCHUMACHER NUTRITION INCENTIVE PROGRAM $166,175 Yes 0
97.132 FINANCIAL ASSISTANCE FOR TARGETED VIOLENCE AND TERRORISM PREVENTION $142,792 Yes 0
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $134,453 Yes 0
81.041 STATE ENERGY PROGRAM $100,000 Yes 0
66.469 GEOGRAPHIC PROGRAMS - GREAT LAKES RESTORATION INITIATIVE $95,000 Yes 0
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $84,800 Yes 0
17.259 WIOA YOUTH ACTIVITIES $76,019 Yes 0
93.977 SEXUALLY TRANSMITTED DISEASES (STD) PREVENTION AND CONTROL GRANTS $72,409 Yes 0
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $67,506 Yes 0
17.245 TRADE ADJUSTMENT ASSISTANCE $63,972 Yes 0
93.991 PREVENTIVE HEALTH AND HEALTH SERVICES BLOCK GRANT $63,016 Yes 0
17.258 WIOA ADULT PROGRAM $53,500 Yes 0
17.277 WIOA NATIONAL DISLOCATED WORKER GRANTS / WIA NATIONAL EMERGENCY GRANTS $47,703 Yes 0
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $46,607 Yes 0
10.553 SCHOOL BREAKFAST PROGRAM $45,250 Yes 0
10.727 INFLATION REDUCTION ACT URBAN & COMMUNITY FORESTRY PROGRAM $43,896 Yes 0
17.207 EMPLOYMENT SERVICE/WAGNER-PEYSER FUNDED ACTIVITIES $42,034 Yes 0
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $41,618 Yes 0
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $36,450 Yes 0
10.558 CHILD AND ADULT CARE FOOD PROGRAM $29,298 Yes 0
93.597 GRANTS TO STATES FOR ACCESS AND VISITATION PROGRAMS $29,288 Yes 0
10.555 NATIONAL SCHOOL LUNCH PROGRAM $29,042 Yes 0
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $24,960 Yes 0
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $22,647 Yes 0
16.742 PAUL COVERDELL FORENSIC SCIENCES IMPROVEMENT GRANT PROGRAM $16,256 Yes 0
16.U00 CIRCUIT COURT TECHNICAL ASSISTANCE $14,284 Yes 0
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $13,061 Yes 0
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $11,348 Yes 0
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $10,350 Yes 0
14.169 HOUSING COUNSELING ASSISTANCE PROGRAM $4,738 Yes 0
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $4,384 Yes 0
20.205 HIGHWAY PLANNING AND CONSTRUCTION $3,810 Yes 0
17.801 JOBS FOR VETERANS STATE GRANTS $2,028 Yes 0
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $861 Yes 0
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $437 Yes 0
16.582 CRIME VICTIM ASSISTANCE/DISCRETIONARY GRANTS $427 Yes 0
84.126 REHABILITATION SERVICES VOCATIONAL REHABILITATION GRANTS TO STATES $353 Yes 0
16.001 LAW ENFORCEMENT ASSISTANCE NARCOTICS AND DANGEROUS DRUGS LABORATORY ANALYSIS $-496 Yes 0
16.824 EMERGENCY LAW ENFORCEMENT ASSISTANCE GRANT $-1,143 Yes 0

Contacts

Name Title Type
HZ4EUKDD7AB4 Brian Lefler Auditee
2488580049 Nathan C. Baldermann, Cpa, Cgfm Auditor
No contacts on file

Notes to SEFA

The County receives certain federal grants as subawards from non-federal entities. Pass-through entities, where applicable, have been identified in the Schedule with an abbreviation, defined as follows: “See the Notes to the SEFA for chart/table”.

Finding Details

Inaccurate Reporting/Lack of Independent Review and Approval of Reporting (Repeat) Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. (Reporting) Federal program(s) U.S. Department of Housing and Urban Development - Community Development Block Grants/Entitlement Grants Cluster; Assistance Listing Number 14.218; Direct award; All project numbers Criteria. Recipients of federal awards are required to report periodically on financial information, as specified by the grant agreement. Reported information should be supported by the entity’s accounting records and subjected to an independent review and approval prior to submission in order to detect and correct any errors or omissions. Additionally, the PR-26 financial summary reports are submitted as part of the Consolidated Annual Performance Evaluation Report (CAPER) and should be properly reconciled to present all inflows and outflows of resources related to the program including the appropriate unexpended balance. Condition. During our audit procedures over the County's CDBG reporting, we noted that none of the reports were subject to an independent review and approval prior to submission in order to detect and correct potential errors or omissions until partway through the year under audit. We also noted that the PR-26 was submitted as required, but contained financial data that did not agree to the County's underlying accounting records. Expenditures were properly reported for the year under audit, but it was identified that the County had incorrectly reported its unexpended balance going back to 2020, when the unexpended balance was not properly carried over from the 2019 report to the 2020 report. This resulted in an incorrect unexpended balance which presented as a net negative unexpended balance in the current year report. Cause. The County implemented a review and approval process during calendar year 2025 in response to the findings from the prior year's audit, and appears to have controls in place moving forward. However, for the period under audit the County did not yet have the internal controls in place to ensure that financial reports were reviewed and approved prior to submission. In addition, the County does not have proper internal controls in place to ensure that the reporting submitted agrees to underlying accounting records with respect to the requirement that unexpended balances are properly carried forward between reporting periods. Effect. The County submitted inaccurate reporting in its PR-26 that was inconsistent with other financial reports submitted and with the County's general ledger. The County is also exposed to an increased risk that future noncompliance could occur and not be prevented or detected by the County's internal controls until controls are consistently implemented across fiscal years. Questioned Costs. None. Recommendation. We recommend that the County implement necessary internal controls to ensure that proper review and approval is documented and reports agree to accounting records. Financial information being submitted to outside entities should be reviewed and approved by the Financial Services department to ensure that it is in agreement with the County's general ledger and consistent with other required financial reporting. View of Responsible Officials. Management acknowledges that financial reporting requires enhanced controls and reconciliation procedures. A review of detailed reconciliation steps will be conducted to identify areas within current processes where regular reviews can be implemented to ensure accuracy and completeness. The County plans to implement this process by July FY2026, which will provide two full quarters of reviewed and monitored activity prior to year-end reporting.
Reporting of Prior Year Program Income Finding Type. Material Noncompliance; Material Weakness in Internal Controls over Compliance. (Program Income) Federal program(s) U.S. Department of Housing and Urban Development - Community Development Block Grants/Entitlement Grants Cluster; Assistance Listing Number 14.218; Direct award; All project numbers Criteria. In accordance with 2 CFR § 200.307, program income must be used in accordance with the terms and conditions of the federal award and must be accounted for and reported accurately. Recipients are required to reconcile program income received and expended during the grant period to ensure it is used for allowable purposes and properly reflected in financial reports. Failure to reconcile and report program income may result in noncompliance with federal grant regulations and could impact the allowability of costs charged to the award. Condition. The County recognized a substantial amount of program income during the fiscal year ended September 30, 2025, for program income that was received in prior periods but incorrectly reported as unearned over many years. It is unclear what portion of this prior year unearned revenue was reported to the Department of Housing and Urban Development ("HUD") through the Integrated Disbursement and Information System ("IDIS") now that the revenue has been properly recognized in the general ledger. Cause. In prior years, the County did not have the proper internal controls in place to ensure that program income was properly tracked, monitored and reported. Effect. The County has a risk of inaccurately reporting program income to HUD. The County is also exposed to an increased risk noncompliance could occur and not be prevented or detected by the County's internal controls. Questioned Costs. None. Recommendation. We recommend the County review its prior year records to determine which portion of the currently recognized revenue has already been reported to HUD. Additionally, the County's Neighborhood and Housing Development ("NHD") department should coordinate with HUD to establish the appropriate approach for reporting and expending this program income going forward. View of Responsible Officials. An in-depth review of all program income activity dating back to 1995 is currently underway within both the general ledger and the IDIS system. The purpose of this review is to determine the total amount of program income received and reported to HUD. Upon completion of the review, the County will collaborate with HUD to determine the appropriate use and expenditure of the identified funds in accordance with applicable program requirements.