Audit 315987

FY End
2023-12-31
Total Expended
$238.87M
Findings
0
Programs
68
Organization: City of Milwaukee, Wisconsin (WI)
Year: 2023 Accepted: 2024-07-25

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $123.79M Yes 0
21.023 Emergency Rental Assistance Program $16.38M Yes 0
14.239 Home Investment Partnerships Program $9.65M - 0
66.468 Capitalization Grants for Drinking Water State Revolving Funds $2.92M - 0
20.823 Port Infrastructure Development Program (b) $2.52M - 0
20.507 Federal Transit_formula Grants $2.12M - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $1.51M - 0
16.922 Equitable Sharing Program $1.48M - 0
14.256 Neiborhood Stabilization Program $1.20M - 0
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $1.13M - 0
14.241 Housing Opportunities for Persons with Aids $990,448 - 0
93.137 Community Programs to Improve Minority Health Grant Program $988,886 - 0
20.933 National Infrastructure Investments $798,235 - 0
14.218 Community Development Block Grants/entitlement Grants $740,000 - 0
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $696,143 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $620,092 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $381,276 - 0
66.469 Great Lakes Program $295,000 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $273,301 - 0
93.778 Medical Assistance Program $238,151 - 0
14.231 Emergency Solutions Grant Program $200,586 - 0
20.205 Highway Planning and Construction $195,104 Yes 0
93.268 Immunization Cooperative Agreements $189,427 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $150,000 Yes 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $148,971 - 0
81.041 State Energy Program $145,648 - 0
95.001 High Intensity Drug Trafficking Areas Program $137,259 - 0
97.044 Assistance to Firefighters Grant $136,364 - 0
93.926 Healthy Start Initiative $129,427 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $127,005 - 0
93.069 Public Health Emergency Preparedness $112,331 - 0
93.994 Maternal and Child Health Services Block Grant to the States $110,325 - 0
66.312 State Environmental Justice Cooperative Agreement Program $104,443 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $103,157 Yes 0
93.000 Impact of Immune Failure on Sars-Cov-2 $85,821 - 0
16.021 Justice Systems Response to Families $84,930 - 0
10.664 Cooperative Forestry Assistance $74,049 - 0
16.543 Missing Children's Assistance $66,932 - 0
16.839 Stop School Violence $59,224 - 0
93.991 Preventive Health and Health Services Block Grant $55,093 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $46,245 - 0
15.904 Historic Preservation Fund Grants-in-Aid $44,999 - 0
66.444 Lead Testing in School and Child Care Program Drinking Water (sdwa 1464(d)) (a) $44,265 - 0
90.404 2018 Hava Election Security Grants $31,924 - 0
45.024 Promotion of the Arts_grants to Organizations and Individuals $24,000 - 0
20.616 National Priority Safety Programs $16,887 - 0
16.817 Byrne Criminal Justice Innovation Program $15,402 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $15,198 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $13,061 - 0
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $11,459 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $11,354 - 0
66.472 Beach Monitoring and Notification Program Implementation Grants $11,000 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $6,650 - 0
16.710 Public Safety Partnership and Community Policing Grants $6,506 - 0
16.726 Juvenile Mentoring Program $5,595 - 0
97.067 Homeland Security Grant Program $5,000 - 0
93.810 Paul Coverdell National Acute Stroke Program National Center for Chronic Disease Prevention and Health Promotion $4,542 - 0
16.888 Consolidated and Technical Assistance Grant Program to Address Children and Youth Experiencing Domestic and Sexual Violence and Engage Men and Boys As Allies $3,751 - 0
45.312 National Leadership Grants $3,361 - 0
20.600 State and Community Highway Safety $3,022 - 0
66.046 Climate Pollution Reduction Grants $2,722 - 0
14.267 Continuum of Care Program $1,654 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $1,443 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $261 - 0
93.103 Food and Drug Administration_research $-248 - 0
93.322 Csels Partnership: Strengthening Public Health Laboratories $-8,957 - 0
93.539 Pphf Capacity Building Assistance to Strengthen Public Health Immunization Infrastructure and Performance Financed in Part by Prevention and Public Health Funds $-46,453 - 0
21.019 Coronavirus Relief Fund $-84,352 - 0

Contacts

Name Title Type
JYGKV746MNG2 Claudia Orugbani Auditee
4142862309 Amanda Blomberg Auditor
No contacts on file

Notes to SEFA

Title: Reporting Entity Accounting Policies: The City has a centralized accounting system for grant programs. The accounting records for grant programs are maintained on the modified accrual basis of accounting. Under this basis, revenues are recognized in the accounting period in which all eligibility requirements have been satisfied and the resources are available. Eligibility requirements include timing requirements which specify the year when the resources are required to be used or the fiscal year when use is first permitted, matching requirements in which the City must provide local resources to be used for specified purpose, and expenditure requirements in which the resources are provided to the City on a reimbursement basis. Budgetary control is maintained by a formal appropriation and encumbrance system. Encumbrances are made against appropriations prior to issuance of purchase requisitions. Purchase requisitions which exceed appropriation balances are not released until additional appropriations are made available. Expenditures are recorded when the services or materials are received. Accounting and budgeting for grants is further controlled by Milwaukee Code of Ordinances Section 304 81. This ordinance provides that no grant programs can be put into operation (expenditures incurred) unless the program has been approved by the Common Council of the City of Milwaukee. The ordinance also provides other procedural guidelines for budgeting and accounting of grant programs. De Minimis Rate Used: N Rate Explanation: The City of Milwaukee has not elected to apply the 10% de minims indirect cost rate to awards for the year ended December 31, 2023. The funds and entities presented in the City of Milwaukee’s Federal and State Single Audit Report are controlled by or are dependent on the City of Milwaukee (the City). The basis for defining the reporting entity of the City of Milwaukee is discussed in the summary of significant accounting policies note in the City’s Annual Comprehensive Financial Report, which can be found on the City’s website at http://city.milwaukee.gov/AnnualComprehensiveFinancialReport. The Assistance Listing Number (ALN) or State Appropriation Number has been provided on the accompanying schedule of expenditures of federal, state, and other awards to the extent it is available. Financial data for the Milwaukee Public School System, the Milwaukee Metropolitan Sewerage District, Milwaukee County government, Wisconsin Center District and the Milwaukee Area Technical College have not been included in this report. These governmental entities are not considered component units of the City, the primary government, because these entities do not meet the criteria established by Governmental Accounting Standards Board Statement (GASB) No. 14, The Financial Reporting Entity (as amended by GASB No. 39 and GASB No. 61). Grants made directly to the City’s component units, the Redevelopment Authority of the City of Milwaukee (RACM) and the Neighborhood Improvement Development Corporation (NIDC) are not included in this report. The Redevelopment Authority and the Neighborhood Improvement Development Corporation publish separate financial and single audit reports.
Title: Annual Comprehensive Financial Report Accounting Policies: The City has a centralized accounting system for grant programs. The accounting records for grant programs are maintained on the modified accrual basis of accounting. Under this basis, revenues are recognized in the accounting period in which all eligibility requirements have been satisfied and the resources are available. Eligibility requirements include timing requirements which specify the year when the resources are required to be used or the fiscal year when use is first permitted, matching requirements in which the City must provide local resources to be used for specified purpose, and expenditure requirements in which the resources are provided to the City on a reimbursement basis. Budgetary control is maintained by a formal appropriation and encumbrance system. Encumbrances are made against appropriations prior to issuance of purchase requisitions. Purchase requisitions which exceed appropriation balances are not released until additional appropriations are made available. Expenditures are recorded when the services or materials are received. Accounting and budgeting for grants is further controlled by Milwaukee Code of Ordinances Section 304 81. This ordinance provides that no grant programs can be put into operation (expenditures incurred) unless the program has been approved by the Common Council of the City of Milwaukee. The ordinance also provides other procedural guidelines for budgeting and accounting of grant programs. De Minimis Rate Used: N Rate Explanation: The City of Milwaukee has not elected to apply the 10% de minims indirect cost rate to awards for the year ended December 31, 2023. In the Annual Comprehensive Financial Report, City grant projects are accounted for in the Special Revenue Funds, Capital Projects Funds, and Enterprise Funds. Details on the individual grant projects are not readily identifiable in the Annual Comprehensive Financial Report. However, allowable grantor expenditures as reported within the schedule of expenditures of federal, state, and other awards have been reconciled with the balances reported within the Comprehensive Annual Financial Report.
Title: Loan Programs Accounting Policies: The City has a centralized accounting system for grant programs. The accounting records for grant programs are maintained on the modified accrual basis of accounting. Under this basis, revenues are recognized in the accounting period in which all eligibility requirements have been satisfied and the resources are available. Eligibility requirements include timing requirements which specify the year when the resources are required to be used or the fiscal year when use is first permitted, matching requirements in which the City must provide local resources to be used for specified purpose, and expenditure requirements in which the resources are provided to the City on a reimbursement basis. Budgetary control is maintained by a formal appropriation and encumbrance system. Encumbrances are made against appropriations prior to issuance of purchase requisitions. Purchase requisitions which exceed appropriation balances are not released until additional appropriations are made available. Expenditures are recorded when the services or materials are received. Accounting and budgeting for grants is further controlled by Milwaukee Code of Ordinances Section 304 81. This ordinance provides that no grant programs can be put into operation (expenditures incurred) unless the program has been approved by the Common Council of the City of Milwaukee. The ordinance also provides other procedural guidelines for budgeting and accounting of grant programs. De Minimis Rate Used: N Rate Explanation: The City of Milwaukee has not elected to apply the 10% de minims indirect cost rate to awards for the year ended December 31, 2023. The City provides loans to various businesses and individuals using funds from various grant programs. These loans are primarily for the rehabilitation of commercial and residential properties. At December 31, 2023, the outstanding balances of the loans by grant program are as follows: The loan balances reported include forgivable amounts and the forgiveness occurs when all eligibility requirements have been met.
Title: Related Party Transactions Accounting Policies: The City has a centralized accounting system for grant programs. The accounting records for grant programs are maintained on the modified accrual basis of accounting. Under this basis, revenues are recognized in the accounting period in which all eligibility requirements have been satisfied and the resources are available. Eligibility requirements include timing requirements which specify the year when the resources are required to be used or the fiscal year when use is first permitted, matching requirements in which the City must provide local resources to be used for specified purpose, and expenditure requirements in which the resources are provided to the City on a reimbursement basis. Budgetary control is maintained by a formal appropriation and encumbrance system. Encumbrances are made against appropriations prior to issuance of purchase requisitions. Purchase requisitions which exceed appropriation balances are not released until additional appropriations are made available. Expenditures are recorded when the services or materials are received. Accounting and budgeting for grants is further controlled by Milwaukee Code of Ordinances Section 304 81. This ordinance provides that no grant programs can be put into operation (expenditures incurred) unless the program has been approved by the Common Council of the City of Milwaukee. The ordinance also provides other procedural guidelines for budgeting and accounting of grant programs. De Minimis Rate Used: N Rate Explanation: The City of Milwaukee has not elected to apply the 10% de minims indirect cost rate to awards for the year ended December 31, 2023. The City expended $28,000 in 2023 of its CDBG funds for the RACM. The expenditures incurred by RACM related to CDBG planning and environmental inspection reviews of rehabilitation projects in the City. The City entered into a cooperation agreement with RACM, which detailed responsibilities and allowable expenditure categories.
Title: State Programs Excluded from Testing Accounting Policies: The City has a centralized accounting system for grant programs. The accounting records for grant programs are maintained on the modified accrual basis of accounting. Under this basis, revenues are recognized in the accounting period in which all eligibility requirements have been satisfied and the resources are available. Eligibility requirements include timing requirements which specify the year when the resources are required to be used or the fiscal year when use is first permitted, matching requirements in which the City must provide local resources to be used for specified purpose, and expenditure requirements in which the resources are provided to the City on a reimbursement basis. Budgetary control is maintained by a formal appropriation and encumbrance system. Encumbrances are made against appropriations prior to issuance of purchase requisitions. Purchase requisitions which exceed appropriation balances are not released until additional appropriations are made available. Expenditures are recorded when the services or materials are received. Accounting and budgeting for grants is further controlled by Milwaukee Code of Ordinances Section 304 81. This ordinance provides that no grant programs can be put into operation (expenditures incurred) unless the program has been approved by the Common Council of the City of Milwaukee. The ordinance also provides other procedural guidelines for budgeting and accounting of grant programs. De Minimis Rate Used: N Rate Explanation: The City of Milwaukee has not elected to apply the 10% de minims indirect cost rate to awards for the year ended December 31, 2023. Certain programs funded by the State of Wisconsin that are included in the schedule of expenditures of federal, state and other awards are not required to be tested under Wisconsin State Single Audit Guidelines as follows: • Local Roads Improvement Program (State ID #395.206)
Title: Subsequent Event Accounting Policies: The City has a centralized accounting system for grant programs. The accounting records for grant programs are maintained on the modified accrual basis of accounting. Under this basis, revenues are recognized in the accounting period in which all eligibility requirements have been satisfied and the resources are available. Eligibility requirements include timing requirements which specify the year when the resources are required to be used or the fiscal year when use is first permitted, matching requirements in which the City must provide local resources to be used for specified purpose, and expenditure requirements in which the resources are provided to the City on a reimbursement basis. Budgetary control is maintained by a formal appropriation and encumbrance system. Encumbrances are made against appropriations prior to issuance of purchase requisitions. Purchase requisitions which exceed appropriation balances are not released until additional appropriations are made available. Expenditures are recorded when the services or materials are received. Accounting and budgeting for grants is further controlled by Milwaukee Code of Ordinances Section 304 81. This ordinance provides that no grant programs can be put into operation (expenditures incurred) unless the program has been approved by the Common Council of the City of Milwaukee. The ordinance also provides other procedural guidelines for budgeting and accounting of grant programs. De Minimis Rate Used: N Rate Explanation: The City of Milwaukee has not elected to apply the 10% de minims indirect cost rate to awards for the year ended December 31, 2023. The City of Milwaukee received a total of $394 million of direct award through the American Rescue Plan Act – State and Local Fiscal Recovery Relief Fund (SLFRF) in response to the COVID-19 global pandemic. The SLFRF was received in two installments of $197 million each in May 2021 and in June 2022. The SLFRF continues to provide direct relief to units of local government in speeding up recovery from the economic and other impact of the COVID-19 pandemic. The funds will cover costs obligated through December 2024. The City received a total of $75 million in direct award provided by the United States Department of Justice – Office of Justice Programs to support law enforcement related activities associated with the 2024 Presidential Candidate Nomination during the Republican National Convention. The convention is scheduled to take place in the City of Milwaukee on July 15 through July 18, 2024.