Audit 306422

FY End
2023-08-31
Total Expended
$76.46M
Findings
0
Programs
70
Organization: City of Lincoln, Nebraska (NE)
Year: 2023 Accepted: 2024-05-16
Auditor: Forvis LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.023 Emergency Rental Assistance Program $13.37M Yes 0
20.507 Federal Transit_formula Grants $10.08M - 0
97.025 National Urban Search and Rescue (us&r) Response System $1.92M - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $1.21M - 0
20.519 Clean Fuels $1.11M - 0
93.137 Community Programs to Improve Minority Health Grant Program $1.09M - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $868,530 Yes 0
14.231 Emergency Solutions Grant Program $849,356 - 0
97.039 Hazard Mitigation Grant $805,809 - 0
17.259 Wia Youth Activities $780,004 - 0
17.258 Wia Adult Program $647,666 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $598,933 - 0
20.205 Highway Planning and Construction $424,258 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $375,790 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $373,675 - 0
93.069 Public Health Emergency Preparedness $326,025 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $323,521 - 0
14.905 Lead Hazard Reduction Demonstration Grant Program $297,173 - 0
93.268 Immunization Cooperative Agreements $277,780 - 0
93.997 Assisted Outpatient Treatment $212,371 - 0
93.103 Food and Drug Administration_research $166,204 - 0
16.575 Crime Victim Assistance $155,515 - 0
10.664 Cooperative Forestry Assistance $147,855 - 0
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $146,286 - 0
17.260 Wia Dislocated Workers $128,314 - 0
93.053 Nutrition Services Incentive Program $122,950 - 0
14.267 Continuum of Care Program $119,823 - 0
93.658 Foster Care_title IV-E $117,790 - 0
14.191 Multifamily Housing Service Coordinators $115,742 - 0
66.605 Performance Partnership Grants $113,004 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $95,743 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $79,502 - 0
95.001 High Intensity Drug Trafficking Areas Program $77,541 - 0
14.401 Fair Housing Assistance Program_state and Local $74,723 - 0
20.600 State and Community Highway Safety $74,189 - 0
17.278 Wia Dislocated Worker Formula Grants $73,214 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $72,232 - 0
21.019 Coronavirus Relief Fund $69,518 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $66,469 - 0
14.276 Youth Homelessness Demonstration Program $59,087 - 0
14.218 Community Development Block Grants/entitlement Grants $58,713 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $52,739 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $52,348 - 0
16.710 Public Safety Partnership and Community Policing Grants $47,210 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $47,143 - 0
14.239 Home Investment Partnerships Program $46,310 - 0
16.588 Violence Against Women Formula Grants $45,816 - 0
14.416 Education and Outreach Initiatives $45,259 - 0
15.904 Historic Preservation Fund Grants-in-Aid $42,250 - 0
20.616 National Priority Safety Programs $39,159 - 0
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated and State Partnership Marketplaces $37,511 - 0
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $36,894 - 0
16.922 Equitable Sharing Program $32,177 - 0
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $27,784 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $25,334 - 0
93.940 Hiv Prevention Activities_health Department Based $21,873 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $20,829 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $19,227 - 0
93.197 Childhood Lead Poisoning Prevention Projects_state and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children $18,834 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $18,157 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $18,036 - 0
93.991 Preventive Health and Health Services Block Grant $15,086 - 0
93.758 Preventive Health and Health Services Block Grant Funded Solely with Prevention and Public Health Funds (pphf) $10,500 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $9,380 - 0
93.667 Social Services Block Grant $8,372 - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $4,413 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $3,307 - 0
21.167 Hn Arp Grant $1,961 - 0
45.310 Grants to States $1,670 - 0
93.461 Covid-19 Testing for the Uninsured $360 - 0

Contacts

Name Title Type
H6DFKBPHK6U6 Melinda Jones Auditee
4024418302 Chris Lindner Auditor
No contacts on file

Notes to SEFA

Title: Reporting Entity Accounting Policies: 1. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the City of Lincoln, Nebraska (the City) under programs of the federal government for the year ended August 31, 2023. The City for purposes of the Schedule, includes all funds of the City as defined in Note 1 of the Notes to the Financial Statements, including Lincoln Electric System, Lincoln Water System, and Lincoln Wastewater System. Lincoln Electric System (LES) operates on a calendar year basis for reporting purposes as opposed to the August 31 fiscal year basis of the City. As a result, the amounts included in the City’s August 31, 2023, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2022. The information in this schedule 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). Therefore, some amounts presented in this Schedule may differ from amounts presented in or used in the preparation of the basic financial statements. Because the schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City. 2. Expenditures reported on the Schedule are reported on the modified cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Federal awards provided to subrecipients are treated as expenditures when paid to the subrecipient. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the City of Lincoln, Nebraska (the City) under programs of the federal government for the year ended August 31, 2023. The City for purposes of the Schedule, includes all funds of the City as defined in Note 1 of the Notes to the Financial Statements, including Lincoln Electric System, Lincoln Water System, and Lincoln Wastewater System. Lincoln Electric System (LES) operates on a calendar year basis for reporting purposes as opposed to the August 31 fiscal year basis of the City. As a result, the amounts included in the City’s August 31, 2023, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2022. The information in this schedule 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). Therefore, some amounts presented in this Schedule may differ from amounts presented in or used in the preparation of the basic financial statements. Because the schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.
Title: Basis of Accounting Accounting Policies: 1. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the City of Lincoln, Nebraska (the City) under programs of the federal government for the year ended August 31, 2023. The City for purposes of the Schedule, includes all funds of the City as defined in Note 1 of the Notes to the Financial Statements, including Lincoln Electric System, Lincoln Water System, and Lincoln Wastewater System. Lincoln Electric System (LES) operates on a calendar year basis for reporting purposes as opposed to the August 31 fiscal year basis of the City. As a result, the amounts included in the City’s August 31, 2023, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2022. The information in this schedule 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). Therefore, some amounts presented in this Schedule may differ from amounts presented in or used in the preparation of the basic financial statements. Because the schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City. 2. Expenditures reported on the Schedule are reported on the modified cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Federal awards provided to subrecipients are treated as expenditures when paid to the subrecipient. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Expenditures reported on the Schedule are reported on the modified cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Federal awards provided to subrecipients are treated as expenditures when paid to the subrecipient.
Title: Pass-Through Awards Accounting Policies: 1. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the City of Lincoln, Nebraska (the City) under programs of the federal government for the year ended August 31, 2023. The City for purposes of the Schedule, includes all funds of the City as defined in Note 1 of the Notes to the Financial Statements, including Lincoln Electric System, Lincoln Water System, and Lincoln Wastewater System. Lincoln Electric System (LES) operates on a calendar year basis for reporting purposes as opposed to the August 31 fiscal year basis of the City. As a result, the amounts included in the City’s August 31, 2023, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2022. The information in this schedule 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). Therefore, some amounts presented in this Schedule may differ from amounts presented in or used in the preparation of the basic financial statements. Because the schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City. 2. Expenditures reported on the Schedule are reported on the modified cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Federal awards provided to subrecipients are treated as expenditures when paid to the subrecipient. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The City receives certain federal awards in the form of pass-through awards. Such amounts received as pass-through awards are specifically identified on the Schedule.
Title: Major Programs Accounting Policies: 1. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the City of Lincoln, Nebraska (the City) under programs of the federal government for the year ended August 31, 2023. The City for purposes of the Schedule, includes all funds of the City as defined in Note 1 of the Notes to the Financial Statements, including Lincoln Electric System, Lincoln Water System, and Lincoln Wastewater System. Lincoln Electric System (LES) operates on a calendar year basis for reporting purposes as opposed to the August 31 fiscal year basis of the City. As a result, the amounts included in the City’s August 31, 2023, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2022. The information in this schedule 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). Therefore, some amounts presented in this Schedule may differ from amounts presented in or used in the preparation of the basic financial statements. Because the schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City. 2. Expenditures reported on the Schedule are reported on the modified cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Federal awards provided to subrecipients are treated as expenditures when paid to the subrecipient. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. In accordance with the Uniform Guidance, major programs are determined using a risk-based approach. Programs in the accompanying Schedule denoted with an asterisk (*) are determined by the independent auditor to be major programs.
Title: Federal Loans Outstanding Accounting Policies: 1. The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal award activity of the City of Lincoln, Nebraska (the City) under programs of the federal government for the year ended August 31, 2023. The City for purposes of the Schedule, includes all funds of the City as defined in Note 1 of the Notes to the Financial Statements, including Lincoln Electric System, Lincoln Water System, and Lincoln Wastewater System. Lincoln Electric System (LES) operates on a calendar year basis for reporting purposes as opposed to the August 31 fiscal year basis of the City. As a result, the amounts included in the City’s August 31, 2023, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2022. The information in this schedule 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). Therefore, some amounts presented in this Schedule may differ from amounts presented in or used in the preparation of the basic financial statements. Because the schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City. 2. Expenditures reported on the Schedule are reported on the modified cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. Federal awards provided to subrecipients are treated as expenditures when paid to the subrecipient. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The federal loan programs listed subsequently are administered directly by the City and balances and transactions relating to these programs are included in the City basic financial statements. Loans outstanding at the beginning of the year and loans made during the year are included in the federal expenditures presented in the Schedule. The balance of loans outstanding, at August 31, 2023, consists of: Assistance Listing # Program Name Outstanding Balance as of August 31, 2023 14.218 Community Development Block Grant $12,943,688 14.228 Community Development Block Grant - Neighborhood Stabilization Program 79,502 14.239 HOME Investment Partnership Program 10,036,590 New loans included in the Schedule totaled approximately $1,864,000, $0, and $1,149,000, for Assistance Listing numbers 14.218, 14.228, and 14.239, respectively.