Audit 31307

FY End
2022-08-31
Total Expended
$97.90M
Findings
0
Programs
77
Organization: City of Lincoln, Nebraska (NE)
Year: 2022 Accepted: 2023-05-15
Auditor: Forvis

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.023 Covid-19 Emergency Rental Assistance Program $26.09M Yes 0
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $15.62M Yes 0
14.218 Community Development Block Grants/entitlement Grants $14.15M - 0
14.239 Home Investment Partnerships Program $10.70M Yes 0
20.526 Bus and Facilities Program $4.26M Yes 0
20.507 Federal Transit_formula Grants $3.76M Yes 0
20.507 Covid-19 Urbanized Area Formula $3.33M Yes 0
20.205 Highway Planning and Construction $2.40M - 0
20.519 Section 5339 Low No - Electric Bus Replacement and Capital Purchases $2.39M - 0
97.025 National Urban Search and Rescue (us&r) Response System $2.00M - 0
21.016 Equitable Sharing $1.28M - 0
10.557 Special Supplemental Nutrition Program for Women, Infants & Children $1.19M - 0
14.231 Covid-19 Emergency Solutions Grant Program $1.06M - 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $990,224 - 0
93.137 Community Programs to Improve Minority Health Grant Program $707,269 - 0
14.218 Covid-19 Community Development Block Grants/entitlement Grants $651,990 - 0
93.268 Covid-19 Immunization Cooperative Agreements $586,637 - 0
97.083 Staffing for Adequate Fire and Emergency Response (safer) $474,445 - 0
17.259 Wioa Youth Activities $448,902 - 0
17.258 Wioa Adult Program $388,567 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $345,819 - 0
93.069 Public Health Emergency Preparedness $277,253 - 0
21.019 Covid-19 Coronavirus Relief Fund $256,927 - 0
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $252,544 - 0
14.231 Emergency Solutions Grant Program $225,947 - 0
93.658 Foster Care_title IV-E $207,884 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $207,031 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $196,467 - 0
14.905 Lead Hazard Reduction Demonstration Grant Program $182,772 - 0
17.278 Wioa Dislocated Workers Formula Grants $180,574 - 0
16.575 Crime Victim Assistance $180,438 - 0
45.310 Grants to States $177,580 - 0
20.507 Federal Transit: Formula Grants (transit Planning) $152,114 Yes 0
93.575 Covid-19 Child Care and Development Block Grant $151,146 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $150,354 - 0
14.267 Continuum of Care Program $147,515 - 0
93.323 Covid-19 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $142,387 - 0
14.401 Fair Housing Assistance Program_state and Local $134,300 - 0
17.260 Wioa National Dislocated Worker Grants/wia National Emergency Grants $132,849 - 0
66.605 Performance Partnership Grants $118,708 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $116,949 - 0
14.191 Multifamily Housing Service Coordinators $114,697 - 0
93.053 Nutrition Services Incentive Program $106,891 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit (lancaster County Rural Transit) $87,946 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $86,804 - 0
16.710 Public Safety Partnership and Community Policing Grants $81,958 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $79,502 - 0
20.600 State and Community Highway Safety $79,354 - 0
93.268 Immunization Cooperative Agreements $78,712 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $66,408 - 0
93.498 Provider Relief Fund $62,364 - 0
95.001 High Intensity Drug Trafficking Areas Program $50,375 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $42,341 - 0
93.991 Preventive Health and Health Services Block Grant $42,027 - 0
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated and State Partnership Marketplaces $40,806 - 0
16.034 Covid-19 Coronavirus Emergency Supplemental Funding Program $40,670 - 0
93.997 Assisted Outpatient Treatment $38,940 - 0
93.103 Food and Drug Administration_research $37,971 - 0
93.044 Covid-19 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $37,202 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $37,183 - 0
15.904 Historic Preservation Fund Grants-in-Aid $34,250 - 0
20.616 National Priority Safety Programs $34,055 - 0
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $26,540 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $24,409 - 0
16.922 Equitable Sharing Program $21,196 - 0
30.002 Employment Discrimination - State and Local Fair Employment Practices Agency Contracts $20,859 - 0
93.940 Hiv Prevention Activities_health Department Based $18,618 - 0
93.197 Childhood Lead Poisoning Prevention Projects_state and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children $15,883 - 0
16.609 Project Safe Neighborhoods $13,324 - 0
14.276 Youth Homelessness Demonstration Program $12,506 - 0
93.667 Social Services Block Grant $11,263 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $10,625 - 0
93.758 Preventive Health and Health Services Block Grant Funded Solely with Prevention and Public Health Funds (pphf) $10,467 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $10,423 - 0
93.575 Child Care and Development Block Grant $5,819 - 0
21.167 Hn Arp Grant $3,289 - 0
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $2,324 - 0

Contacts

Name Title Type
H6DFKBPHK6U6 Nghia Nguyen Auditee
4024417127 Chris Lindner Auditor
No contacts on file

Notes to SEFA

Title: Loan/loan guarantee outstanding balances 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, 2022. 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 Citys August 31, 2022, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2021. 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 auditee did not use the de minimis cost rate. COMMUNITY DEVELOPMENT BLOCK GRANT (14.218) - Balances outstanding at the end of the audit period were 11801204. HOME INVESTMENT PARTNERSHIPS PROGRAM (14.239) - Balances outstanding at the end of the audit period were 9777443. COMMUNITY DEVELOPMENT BLOCK GRANT (NEIGHBORHOOD STABILIZATION PROGRAM)(14.228) - Balances outstanding at the end of the audit period were 79502.
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, 2022. 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 Citys August 31, 2022, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2021. 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 auditee did not use the de minimis cost rate. 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, 2022. 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 Citys August 31, 2022, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2021. 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 auditee did not use the de minimis cost rate. 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, 2022. 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 Citys August 31, 2022, basic financial statements for LES are audited amounts as of and for the year ended December 31, 2021. 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 auditee did not use the de minimis cost rate. 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. New loans included in the Schedule totaled $1,294,000, $0, and $705,000, for Assistance Listing numbers 14.218, 14.228, and 14.239, respectively.