Audit 361547

FY End
2024-12-31
Total Expended
$226.93M
Findings
2
Programs
43
Year: 2024 Accepted: 2025-07-07

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
570547 2024-002 Significant Deficiency - N
1146989 2024-002 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
20.500 Federal Transit Capital Investment Grants $71.54M Yes 0
20.507 Federal Transit Formula Grants $24.88M Yes 0
14.871 Section 8 Housing Choice Vouchers $23.28M Yes 1
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $21.42M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $15.99M Yes 0
21.023 Emergency Rental Assistance Program $8.35M Yes 0
14.850 Public Housing Operating Fund $1.93M - 0
20.525 State of Good Repair Grants Program $1.75M Yes 0
66.468 Drinking Water State Revolving Fund $1.71M - 0
14.872 Public Housing Capital Fund $729,814 - 0
14.239 Home Investment Partnerships Program $634,136 - 0
14.276 Youth Homelessness Demonstration Program $471,225 - 0
14.195 Project-Based Rental Assistance (pbra) $379,552 - 0
14.231 Emergency Solutions Grant Program $333,073 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $246,270 - 0
81.087 Renewable Energy Research and Development $240,790 - 0
97.047 Bric: Building Resilient Infrastructure and Communities $227,474 - 0
16.817 Byrne Criminal Justice Innovation Program $213,950 - 0
81.086 Conservation Research and Development $210,432 - 0
14.182 Lower Income Housing Assistance Program_section 8 New Construction/substantial Rehabilitation $202,413 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $141,621 - 0
16.838 Comprehensive Opioid, Stimulant, and Other Substances Use Program $127,442 - 0
81.128 Energy Efficiency and Conservation Block Grant Program (eecbg) $121,912 - 0
14.191 Multifamily Housing Service Coordinators $93,511 - 0
14.870 Resident Opportunity and Supportive Services - Service Coordinators $64,733 - 0
66.312 Environmental Justice Government-to-Government (ejg2g) Program $40,940 - 0
45.312 National Leadership Grants $33,908 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $32,925 - 0
97.067 Homeland Security Grant Program $26,795 - 0
10.675 Urban and Community Forestry Program $25,000 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $18,949 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $10,897 - 0
14.267 Continuum of Care Program $5,820 - 0
16.922 Equitable Sharing Program $4,259 - 0
30.010 Employment Discrimination Equal Pay Act $3,800 - 0
16.609 Project Safe Neighborhoods $2,585 - 0
20.616 National Priority Safety Programs $1,995 - 0
16.U01 Joint Terrorism Task Force $1,477 - 0
16.710 Public Safety Partnership and Community Policing Grants $1,453 - 0
20.940 Reconnecting Communities Pilot (rcp) Discretionary Grant Program $813 - 0
66.616 Environmental and Climate Justice Community Change Grants Program $550 - 0
20.205 Highway Planning and Construction $55 - 0
14.218 Community Development Block Grants/entitlement Grants $-22,720 - 0

Contacts

Name Title Type
FS3AZ3FV8JG8 David Schmiedicke Auditee
6082678710 Amanda Blomberg Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedules are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. The accompanying schedules of expenditures of federal and state awards (the Schedules) includes the federal and state award activity of the City of Madison (the City) under programs of the federal and state government for the year ended December 31, 2024. The information in these Schedules 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 (Uniform Guidance) and the State Single Audit Guidelines. Because the Schedules present only a selected portion of the operations of the City, they are not intended to and do not present the financial position, changes in net position or cash flows of the City.
Title: Pass-Through Grantors Accounting Policies: Expenditures reported on the Schedules are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. Federal funds have been passed through the following grantors: WHEDA - Wisconsin Housing and Economic Development Authority WI DOJ - Wisconsin Department of Justice WI DOT - Wisconsin Department of Transportation WI DOA - Wisconsin Department of Administration MKE - City of Milwaukee, Wisconsin Dane Co - Dane County, Wisconsin WI DEM - Wisconsin Division of Emergency Management WI DMA - Wisconsin Department of Military Affairs Slipstream Group, Inc.
Title: Community Development Incentive Grants (WEDC) – Matching Funds Accounting Policies: Expenditures reported on the Schedules are reported on the accrual or modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedules represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. The underlying accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis indirect cost rate of the Uniform Guidance. The City met the following matching requirements: Contract: Match Requirement: FY23-53494 $ 250,000 FY23-53517 25,000 FY23-53599 750,000

Finding Details

Finding 2024-002 Assistance Listing Number: 14.871 Program Title: Housing Voucher Cluster: Section 8 Housing Choice Voucher Program Award Number / Year: WI003VO0119 (2010) / 2024 Pass-Through Entity: Not applicable Criteria: 24 CFR, sections 982.158(d) and 982.405(b) require all units leased to have a unit inspection report filed biennially to determine if the unit meets Housing Quality Standards. Condition/Context: One unit tested did not have an inspection completed within the last two years, and another unit tested did not have adequate support that the inspection was completed. Our sample was statistically valid. Cause: The City did not have internal control processes and procedures in place to ensure timely completion of inspections and a HUD 50058 report was submitted without adequate supporting documentation. Effect: A unit may have unsafe housing conditions. Questioned Costs: None noted. Recommendation: The City should review its internal control procedures to ensure all applicable requirements of the HUD 50058 are met before submissions, including making sure an inspection is performed biennially, and that adequate supporting documentation is maintained. Management's Response: On a monthly schedule, management will review Annual HQS Inspections Report that is part of the Section Eight Management Assessment Program (SEMAP) Indicators Report generated from Inventory Management System/PIH Information Center (PIC) submissions and follow up with inspectors regarding units with incomplete information of final inspection within the last 25 months, the acceptable timeline per U.S Department of Housing and Urban Development (HUD) guidelines. By year end, CDA will train staff and fully implement the use of Emphasys HQS Mobile to schedule, complete and store reports electronically, improving internal controls of tracking inspection completion.
Finding 2024-002 Assistance Listing Number: 14.871 Program Title: Housing Voucher Cluster: Section 8 Housing Choice Voucher Program Award Number / Year: WI003VO0119 (2010) / 2024 Pass-Through Entity: Not applicable Criteria: 24 CFR, sections 982.158(d) and 982.405(b) require all units leased to have a unit inspection report filed biennially to determine if the unit meets Housing Quality Standards. Condition/Context: One unit tested did not have an inspection completed within the last two years, and another unit tested did not have adequate support that the inspection was completed. Our sample was statistically valid. Cause: The City did not have internal control processes and procedures in place to ensure timely completion of inspections and a HUD 50058 report was submitted without adequate supporting documentation. Effect: A unit may have unsafe housing conditions. Questioned Costs: None noted. Recommendation: The City should review its internal control procedures to ensure all applicable requirements of the HUD 50058 are met before submissions, including making sure an inspection is performed biennially, and that adequate supporting documentation is maintained. Management's Response: On a monthly schedule, management will review Annual HQS Inspections Report that is part of the Section Eight Management Assessment Program (SEMAP) Indicators Report generated from Inventory Management System/PIH Information Center (PIC) submissions and follow up with inspectors regarding units with incomplete information of final inspection within the last 25 months, the acceptable timeline per U.S Department of Housing and Urban Development (HUD) guidelines. By year end, CDA will train staff and fully implement the use of Emphasys HQS Mobile to schedule, complete and store reports electronically, improving internal controls of tracking inspection completion.