Finding 46000 (2022-005)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-08-07
Audit: 41070
Organization: County of Nevada (CA)

AI Summary

  • Core Issue: The County lacks effective internal controls, leading to inaccurate and incomplete reporting of federal funds.
  • Impacted Requirements: Compliance with 2 CFR Part 200, specifically regarding financial management systems and internal controls.
  • Recommended Follow-Up: Implement controls for report review and approval, ensuring all reports match supporting documentation.

Finding Text

2022 ? 005 Reporting Federal Agency: U.S. Department of Treasury Federal Program Name: COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Assistance Listing Number: 21.027 Federal Award Identification Number and Year: 1505-0271 - 2021 Award Period: May 26, 2021 - December 31, 2026 Type of Finding: ? Significant Deficiency in Internal Control over Compliance ? Other Matters Criteria or specific requirement: According to ? 200.302 Financial management of 2 CFR Part 200, the nonfederal entity's financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. Further, the financial management system of each nonfederal entity must provide accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements. According to ? 200.303 Internal controls of 2 CFR Part 200, the nonfederal entity must establish and maintain effective internal control over the federal award that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: During our testing, it was noted that the County did not have effective internal controls in place to ensure accurate and complete reporting. Questioned costs: None Context: During our testing, we noted the following matters related to reporting. ? For the interim report, no evidence of review and approval of the report. ? For the Project and Expenditure Report 1, total obligations reported of approximately $907,400. However, the documentation used to prepare the report has an obligated amount of approximately $3,600,000. Thus, a variance of approximately $2,700,000. ? For the Project and Expenditure Report 2, total obligations reported of approximately $3,500,000. However, the documentation used to prepare the report has an obligated amount of approximately $2,800,000. Thus, a variance of approximately $711.900. ? For the Project and Expenditure Report 1 and 2, Subaward No: SBC_01 Period of Performance Start of August 13, 2021. However, the professional services contract has a contract start date of July 13, 2021. Cause: Management oversight. Effect: The auditor noted instances of noncompliance. Noncompliance results in inaccurate reporting. Recommendation: We recommend the County design controls to ensure review and approval of reports are maintained in the County's grant files. Also, we recommend the County design controls to ensure reports agree to the documentation used to prepare them. Views of responsible officials: There is no disagreement from responsible officials.

Corrective Action Plan

DEPARTMENT OF TREASURY 2022-005 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) ? Assistance Listing No. 21.027 Recommendation: We recommend the County design controls to ensure review and approval of reports are maintained in the County's grant files. Also, we recommend the County design controls to ensure reports agree to the documentation used to prepare them. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The County has revised internal controls to ensure reports are prepared accurately and consistently with the back-up used to prepare them. Within these internal control procedures, an appropriate review and approval process will be utilized and documented to ensure report is accurate with underlying support documentation and clearly documents this review and approval control. As a primary function of this review and approval control process, the reviewer/approver will provide assurance that the federal award is reasonably being managed and complies with all applicable statues, regulations, and terms and conditions. Evidence of review and approval will be maintained within the grant file support documentation for future reference and to be provided in a timely manner. Name(s) of the contact person(s) responsible for corrective action: Barry Anderson Planned completion date for corrective action plan: June 30, 2023

Categories

Period of Performance Reporting Internal Control / Segregation of Duties Subrecipient Monitoring Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 45998 2022-003
    Significant Deficiency
  • 45999 2022-004
    Material Weakness
  • 46001 2022-003
    Significant Deficiency
  • 46002 2022-004
    Material Weakness
  • 46003 2022-003
    Significant Deficiency
  • 622440 2022-003
    Significant Deficiency
  • 622441 2022-004
    Material Weakness
  • 622442 2022-005
    Significant Deficiency
  • 622443 2022-003
    Significant Deficiency
  • 622444 2022-004
    Material Weakness
  • 622445 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.84M
93.563 Child Support Enforcement $1.61M
93.778 Medical Assistance Program $1.52M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $1.44M
93.558 Temporary Assistance for Needy Families $1.40M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $710,453
93.959 Block Grants for Prevention and Treatment of Substance Abuse $704,083
93.505 Affordable Care Act (aca) Maternal, Infant, and Early Childhood Home Visiting Program $693,474
93.667 Social Services Block Grant $447,008
21.019 Coronavirus Relief Fund $389,775
93.268 Immunization Cooperative Agreements $299,713
16.034 Coronavirus Emergency Supplemental Funding Program $186,318
93.994 Maternal and Child Health Services Block Grant to the States $184,003
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $182,998
93.069 Public Health Emergency Preparedness $146,246
10.665 Schools and Roads - Grants to States $139,708
14.239 Home Investment Partnerships Program $131,842
16.835 Body Worn Camera Policy and Implementation $123,000
93.889 National Bioterrorism Hospital Preparedness Program $111,810
14.267 Continuum of Care Program $105,398
16.575 Crime Victim Assistance $100,000
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $83,904
93.958 Block Grants for Community Mental Health Services $83,773
14.241 Housing Opportunities for Persons with Aids $70,858
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $58,579
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $46,525
93.556 Promoting Safe and Stable Families $44,474
93.917 Hiv Care Formula Grants $44,041
20.205 Highway Planning and Construction $42,633
93.658 Foster Care_title IV-E $40,765
93.569 Community Services Block Grant $39,864
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $36,544
93.590 Community-Based Child Abuse Prevention Grants $30,000
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $28,117
93.645 Stephanie Tubbs Jones Child Welfare Services Program $27,901
93.217 Family Planning_services $27,617
93.603 Adoption Incentive Payments $25,172
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $22,508
16.001 Law Enforcement Assistance_narcotics and Dangerous Drugs_laboratory Analysis $19,973
93.747 Elder Abuse Prevention Interventions Program $18,785
93.276 Drug-Free Communities Support Program Grants $16,371
93.150 Projects for Assistance in Transition From Homelessness (path) $16,333
93.197 Childhood Lead Poisoning Prevention Projects_state and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children $12,000
15.433 Flood Control Act Lands $4,565
10.025 Plant and Animal Disease, Pest Control, and Animal Care $4,416
10.664 Cooperative Forestry Assistance $3,044
93.090 Guardianship Assistance $2,501
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $2,401
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $2,372
93.659 Adoption Assistance $605
10.433 Rural Housing Preservation Grants $395