Audit 10194

FY End
2023-06-30
Total Expended
$25.12M
Findings
2
Programs
30
Organization: City of Henderson (NV)
Year: 2023 Accepted: 2024-01-08
Auditor: Eide Bailly

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
7846 2023-005 Significant Deficiency - L
584288 2023-005 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $13.34M Yes 1
14.218 Community Development Block Grants/entitlement Grants $3.09M Yes 0
21.023 Emergency Rental Assistance Program $1.35M Yes 0
97.067 Homeland Security Grant Program $1.14M Yes 0
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $1.08M Yes 0
14.231 Emergency Solutions Grant Program $601,965 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $529,335 - 0
15.235 Southern Nevada Public Land Management $375,677 - 0
93.575 Child Care and Development Block Grant $298,410 - 0
97.042 Emergency Management Performance Grants $288,013 - 0
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $266,964 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $162,606 - 0
21.016 Equitable Sharing $140,434 - 0
16.585 Drug Court Discretionary Grant Program $130,288 - 0
93.053 Nutrition Services Incentive Program $124,457 Yes 0
97.044 Assistance to Firefighters Grant $116,375 - 0
20.600 State and Community Highway Safety $110,058 - 0
16.838 Comprehensive Opioid Abuse Site-Based Program $88,973 - 0
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $85,832 - 0
16.543 Missing Children's Assistance $79,357 - 0
45.024 Promotion of the Arts_grants to Organizations and Individuals $66,155 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $54,444 - 0
93.738 Pphf: Racial and Ethnic Approaches to Community Health Program Financed Solely by Public Prevention and Health Funds $38,609 - 0
16.588 Violence Against Women Formula Grants $33,824 - 0
94.006 Americorps $29,306 - 0
10.575 Farm to School Grant Program $24,321 - 0
10.556 Special Milk Program for Children $13,134 - 0
16.710 Public Safety Partnership and Community Policing Grants $9,235 - 0
14.239 Home Investment Partnerships Program $8,476 - 0
20.205 Highway Planning and Construction $5,285 - 0

Contacts

Name Title Type
D4QQSLNCP9Z8 David Lasic Auditee
7022671776 Kurt Schlicker Auditor
No contacts on file

Notes to SEFA

Title: Note 1 - Basis of Presentation Accounting Policies: Expenditures reported on the SEFA are reported on the 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. Federal financial assistance provided to a subrecipient is treated as an expenditure when it is paid to the subrecipient. Negative amounts shown on the SEFA represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: Y Rate Explanation: The City has elected to use the 10-percent de minimis indirect cost rate for federal programs that allow those costs to be charged, as allowed under the Uniform Guidance, where applicable. The accompanying schedule of expenditures of federal awards (the “SEFA”) includes the federal award activity of the City of Henderson (the “City”) under programs of the federal government for the year ended June 30, 2023. The information in this SEFA 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”). Because the SEFA 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 financial position, or cash flows of the City.
Title: Note 2 - Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the SEFA are reported on the 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. Federal financial assistance provided to a subrecipient is treated as an expenditure when it is paid to the subrecipient. Negative amounts shown on the SEFA represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: Y Rate Explanation: The City has elected to use the 10-percent de minimis indirect cost rate for federal programs that allow those costs to be charged, as allowed under the Uniform Guidance, where applicable. Expenditures reported on the SEFA are reported on the 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. Federal financial assistance provided to a subrecipient is treated as an expenditure when it is paid to the subrecipient. Negative amounts shown on the SEFA represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years.
Title: Note 3 - Indirect Cost Rate Accounting Policies: Expenditures reported on the SEFA are reported on the 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. Federal financial assistance provided to a subrecipient is treated as an expenditure when it is paid to the subrecipient. Negative amounts shown on the SEFA represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: Y Rate Explanation: The City has elected to use the 10-percent de minimis indirect cost rate for federal programs that allow those costs to be charged, as allowed under the Uniform Guidance, where applicable. The City has elected to use the 10-percent de minimis indirect cost rate for federal programs that allow those costs to be charged, as allowed under the Uniform Guidance, where applicable.
Title: Note 4 - Loan Programs Accounting Policies: Expenditures reported on the SEFA are reported on the 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. Federal financial assistance provided to a subrecipient is treated as an expenditure when it is paid to the subrecipient. Negative amounts shown on the SEFA represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: Y Rate Explanation: The City has elected to use the 10-percent de minimis indirect cost rate for federal programs that allow those costs to be charged, as allowed under the Uniform Guidance, where applicable. The City participates in Revolving Loan Funds and Section 108 Loan Guarantee programs sponsored by the Department of Housing and Urban Development - Community Development Block Grants (CDBG) and the HOME Investment Partnerships Program. Under these programs, the City issues loans to program participants which may be forgiven over time, or are repaid into the program for the issuance of new loans. Only current year loan drawdowns (new loans issued) are reported on the SEFA; there are no contingencies noted. At June 30, 2023, the City had the following loan activities:

Finding Details

2023-005: U.S. Department of the Treasury COVID-19: Coronavirus State and Local Fiscal Recovery Funds, Assistance Listing #21.027 Reporting Significant Deficiency in Internal Control over Compliance Grant Award Number: Affects all grant awards included under Assistance Listing 21.027 on the Schedule of Expenditures of Federal Awards. Criteria: The OMB Compliance Supplement requires that reports submitted to the federal awarding agency include all activity of the reporting period, are supported by applicable accounting or performance records, and are fairly presented in accordance with governing requirements. The City of Henderson (the City) must submit quarterly Project and Expenditure Reports that contain costs incurred during the covered period. Certain critical information includes: o Obligations and Expenditures  Current period obligation  Cumulative obligation  Current period expenditure  Cumulative expenditure Condition: Obligation information was reported inaccurately. Cause: The City of Henderson did not have adequate internal controls to ensure Project and Expenditure Reports were prepared in accordance with governing requirements as estimated obligations, rather than actual, were reported. Effect: Inaccurate information was reported to the federal awarding agency. Questioned Costs: None Context/Sampling: A nonstatistical sample of two out of a population of four Project and Expenditure Reports submitted during the year was selected for testing. The cumulative impact is as follows: Period Ended September 30, 2022 Originally Reported Actual Obligations and Expenditures: Cumulative obligation $25,414,500 $25,021,569 Period Ended March 31, 2023 Originally Reported Actual Obligations and Expenditures: Cumulative obligation $26,664,517 $26,563,907 Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure Project and Expenditure Reports are prepared in accordance with governing requirements through using actual obligations, rather than estimated. Views of Responsible Officials: The City of Henderson agrees with this finding.
2023-005: U.S. Department of the Treasury COVID-19: Coronavirus State and Local Fiscal Recovery Funds, Assistance Listing #21.027 Reporting Significant Deficiency in Internal Control over Compliance Grant Award Number: Affects all grant awards included under Assistance Listing 21.027 on the Schedule of Expenditures of Federal Awards. Criteria: The OMB Compliance Supplement requires that reports submitted to the federal awarding agency include all activity of the reporting period, are supported by applicable accounting or performance records, and are fairly presented in accordance with governing requirements. The City of Henderson (the City) must submit quarterly Project and Expenditure Reports that contain costs incurred during the covered period. Certain critical information includes: o Obligations and Expenditures  Current period obligation  Cumulative obligation  Current period expenditure  Cumulative expenditure Condition: Obligation information was reported inaccurately. Cause: The City of Henderson did not have adequate internal controls to ensure Project and Expenditure Reports were prepared in accordance with governing requirements as estimated obligations, rather than actual, were reported. Effect: Inaccurate information was reported to the federal awarding agency. Questioned Costs: None Context/Sampling: A nonstatistical sample of two out of a population of four Project and Expenditure Reports submitted during the year was selected for testing. The cumulative impact is as follows: Period Ended September 30, 2022 Originally Reported Actual Obligations and Expenditures: Cumulative obligation $25,414,500 $25,021,569 Period Ended March 31, 2023 Originally Reported Actual Obligations and Expenditures: Cumulative obligation $26,664,517 $26,563,907 Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure Project and Expenditure Reports are prepared in accordance with governing requirements through using actual obligations, rather than estimated. Views of Responsible Officials: The City of Henderson agrees with this finding.