Audit 323562

FY End
2023-12-31
Total Expended
$112.22M
Findings
4
Programs
50
Year: 2023 Accepted: 2024-10-01

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
501493 2023-003 Significant Deficiency - L
501494 2023-002 Significant Deficiency - L
1077935 2023-003 Significant Deficiency - L
1077936 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
20.500 Federal Transit_capital Investment Grants $33.11M Yes 0
14.871 Section 8 Housing Choice Vouchers $19.38M - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $4.71M Yes 1
66.468 Capitalization Grants for Drinking Water State Revolving Funds $4.67M Yes 0
21.023 Emergency Rental Assistance Program $3.14M - 0
93.498 Provider Relief Fund $2.61M Yes 1
14.850 Public and Indian Housing $1.81M - 0
14.872 Public Housing Capital Fund $702,438 - 0
14.218 Community Development Block Grants/entitlement Grants $676,621 - 0
14.239 Home Investment Partnerships Program $581,287 Yes 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $544,446 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $385,606 - 0
81.041 State Energy Program $332,897 - 0
20.525 State of Good Repair Grants Program $329,302 Yes 0
14.195 Section 8 Housing Assistance Payments Program $306,903 - 0
20.205 Highway Planning and Construction $304,238 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $276,320 - 0
14.276 Youth Homelessness Demonstration Program $246,484 - 0
45.024 Promotion of the Arts_grants to Organizations and Individuals $243,759 - 0
20.507 Federal Transit_formula Grants $206,389 Yes 0
97.047 Pre-Disaster Mitigation $199,249 - 0
16.922 Equitable Sharing Program $181,786 - 0
14.182 Section 8 New Construction and Substantial Rehabilitation $173,194 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $170,732 - 0
16.817 Byrne Criminal Justice Innovation Program $166,026 - 0
66.312 State Environmental Justice Cooperative Agreement Program $128,962 - 0
14.267 Continuum of Care Program $111,465 - 0
14.870 Resident Opportunity and Supportive Services - Service Coordinators $98,615 - 0
14.191 Multifamily Housing Service Coordinators $89,733 - 0
14.231 Emergency Solutions Grant Program $72,636 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $69,615 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $66,667 - 0
20.600 State and Community Highway Safety $62,183 - 0
45.312 National Leadership Grants $61,897 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $46,834 - 0
10.935 Urban Agriculture and Innovative Production $43,500 - 0
16.710 Public Safety Partnership and Community Policing Grants $39,889 - 0
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $26,044 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $25,000 - 0
15.904 Historic Preservation Fund Grants-in-Aid $19,154 - 0
16.U02 Safe Streets Task Force $17,955 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $13,046 Yes 0
81.128 Energy Efficiency and Conservation Block Grant Program (eecbg) $12,617 - 0
81.086 Conservation Research and Development $11,603 - 0
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $9,229 - 0
16.609 Project Safe Neighborhoods $5,189 - 0
20.616 National Priority Safety Programs $4,444 - 0
16.U01 Joint Terrorism Task Force $1,314 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $494 - 0
30.001 Employment Discrimination_title Vii of the Civil Rights Act of 1964 $93 - 0

Contacts

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

Notes to SEFA

Title: 1. 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, 2023. 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: 3. 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 WI SHPO - Wisconsin State Historic Preservation Office MKE - City of Milwaukee, Wisconsin Dane Co - Dane County, Wisconsin WI DEM – Wisconsin Division of Emergency Management WI PSC - Wisconsin Public Service Commission WI DHS - Wisconsin Department of Health Services WI DMA – Wisconsin Department of Military Affairs Slipstream Group, Inc.
Title: 5. Restatement of Previously Issued Schedule of Expenditures of Federal Awards 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. Subsequent to the issuance of the City of Madison's single audit report for the year ended December 31, 2023, the City identified an omission of a federal grant from the schedule of expenditures of federal and state awards. The differences between this report and the report previously issued includes the addition of $4,675,000 in funding received from the U.S. Environmental Protection Agency under Assistance Listing Number (ALN) 66.468 Capitalization Grants for Drinking Water State Revolving Funds. In addition, ALN 66.468 was tested as a major federal program and audit finding 2023-001 was revised to reflect this omission.

Finding Details

Assistance Listing Number: 21.027 Program Title: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Award Number / Year: SLT-0704 / 2023 Pass-Through Entity: Not applicable Criteria: The award agreement with U.S. Treasury states that the recipient agrees to comply with any reporting obligations established by Treasury as they relate to this award. Condition: Two of the four quarterly Project and Expenditure Reports were selected for testing. For the reports tested, the expenditures related to the Revenue Replacement category were not included. Additionally, the expenditures of Public Health Madison and Dane County (PHMDC), a separate legal entity and subrecipient of the City, were reported rather than the payments made to PHMDC. The sample was not statistically valid. Cause: Management was not aware of the requirement to report the revenue replacement related expenditures until the 2024 quarter 1 report when U.S. Treasury updated the reporting portal to provide clearer guidance. Additionally, since the PHMDC expenditures are included in the City's accounting system, they were erroneously used instead of the transfer to PHMDC. Effect: The cumulative expenditures for the Project and Expenditure Reports were understated. Questioned Costs: None noted. Recommendation: When reviewing the reports, ensure that the total City expenditures are reported for all projects.
Assistance Listing Number: 93.498 Program Title: COVID-19 Provider Relief Fund Award Number / Year: Not applicable / 2023 Pass-Through Entity: Not applicable Criteria: Non-federal entities in receipt of federal funds must comply with the requirements of 2 CFR 200.303(a), which require an entity to establish and maintain effective internal control over the Federal award to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Recipients of Provider Relief Funds (PRF) payments must also comply with the reporting requirements described in the PRF terms and conditions and specified in directions issued by the U.S. Department of Health and Human Services (DHHS). Condition: The Period 5 Report (only report for FY2023) and the revenue loss calculation were not reviewed and approved by an independent person separate from the preparer prior to submission to DHHS. The sample was statistically valid. Cause: The City did not have internal control processes and procedures in place requiring an independent person to review the reports before submission to ensure the loss revenue calculation and amounts reported were accurate. Effect: Information within the period reports submitted, including the lost revenue calculations, could contain errors. Questioned Costs: None noted. Recommendation: The City should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports in place before submissions to federal agencies.
Assistance Listing Number: 21.027 Program Title: COVID-19 Coronavirus State and Local Fiscal Recovery Funds Award Number / Year: SLT-0704 / 2023 Pass-Through Entity: Not applicable Criteria: The award agreement with U.S. Treasury states that the recipient agrees to comply with any reporting obligations established by Treasury as they relate to this award. Condition: Two of the four quarterly Project and Expenditure Reports were selected for testing. For the reports tested, the expenditures related to the Revenue Replacement category were not included. Additionally, the expenditures of Public Health Madison and Dane County (PHMDC), a separate legal entity and subrecipient of the City, were reported rather than the payments made to PHMDC. The sample was not statistically valid. Cause: Management was not aware of the requirement to report the revenue replacement related expenditures until the 2024 quarter 1 report when U.S. Treasury updated the reporting portal to provide clearer guidance. Additionally, since the PHMDC expenditures are included in the City's accounting system, they were erroneously used instead of the transfer to PHMDC. Effect: The cumulative expenditures for the Project and Expenditure Reports were understated. Questioned Costs: None noted. Recommendation: When reviewing the reports, ensure that the total City expenditures are reported for all projects.
Assistance Listing Number: 93.498 Program Title: COVID-19 Provider Relief Fund Award Number / Year: Not applicable / 2023 Pass-Through Entity: Not applicable Criteria: Non-federal entities in receipt of federal funds must comply with the requirements of 2 CFR 200.303(a), which require an entity to establish and maintain effective internal control over the Federal award to ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Recipients of Provider Relief Funds (PRF) payments must also comply with the reporting requirements described in the PRF terms and conditions and specified in directions issued by the U.S. Department of Health and Human Services (DHHS). Condition: The Period 5 Report (only report for FY2023) and the revenue loss calculation were not reviewed and approved by an independent person separate from the preparer prior to submission to DHHS. The sample was statistically valid. Cause: The City did not have internal control processes and procedures in place requiring an independent person to review the reports before submission to ensure the loss revenue calculation and amounts reported were accurate. Effect: Information within the period reports submitted, including the lost revenue calculations, could contain errors. Questioned Costs: None noted. Recommendation: The City should review its internal control procedures to ensure there are proper review and approval processes over completeness and accuracy of reports in place before submissions to federal agencies.