Finding 478711 (2023-002)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-07-17
Audit: 315378
Organization: Douglas County Government (CO)

AI Summary

  • Core Issue: The County misreported $1.5 million in 2022 expenses on the 2023 federal expenditure report due to inadequate internal controls.
  • Impacted Requirements: Compliance with 2 CFR Part 200.303, which mandates effective internal controls and accurate reporting of federal awards.
  • Recommended Follow-Up: Revise processes to ensure all grant agreements are submitted to Finance upon signing and implement monthly reconciliations for grants by the Engineering Department.

Finding Text

Finding: Allowable Costs and Allowable Activities Federal Assistance Listing Number 20.205 - Highway Planning and Construction Department of Transportation, Passed-through Colorado Department of Transportation Award Number - SHO-105A-016, Award Year 2022Award Number - 22-HA1-XC-00228, Award Year 2022 Criteria: According to 2 CFR Part 200.303 - The non-Federal entity must (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). (b) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal awards. (c) Evaluate and monitor the non-Federal entity's compliance with statutes, regulations and the terms and conditions of Federal awards. Condition: During testing, we noted that two transactions totaling $1,501,269 related to 2022 activities and was included as an expenditure on the fiscal year 2023 Schedule of Expenditures of Federal Awards. The period of performance for the project began in 2022 and extended through 2023. Questioned Costs: None. Context: We tested 4 of the 15 nonpayroll transactions for the grants identified above and noted two instance in which 2022 activities were included as expenditures on the fiscal year 2023 Schedule of Expenditures of Federal Awards. The tested population covered expenditures of $7.0 million and the total population of expenditures were approximately $32.2 million. A non-statistical sampling methodology was used to select the sample. Effect: The County did not have adequate internal controls in place over the Highway Planning and Construction program, which resulted in a 2022 expense being reported in 2023. Cause: Grant management at the County is decentralized and thus departments are responsible for providing the required information to the County's Department of Finance to facilitate the preparation of the SEFA. The Engineering Department did not provide the Department of Finance all business units being used for grant activity or pending journal entries to record grant activity. Identification as a repeat finding: Not Applicable Recommendation: We recommend the County revise their internal process to require all grant agreements be provided to the Department of Finance at the time the agreement is signed. In addition, we recommend the Engineering Department complete monthly reconciliations over all grants which should then be subsequently provided to the Department of Finance for final review. Views of responsible officials and planned corrective actions: Agree. See separate report for planned corrective actions.

Categories

Reporting Allowable Costs / Cost Principles Period of Performance Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 478710 2023-002
    Significant Deficiency
  • 478712 2023-002
    Significant Deficiency
  • 1055152 2023-002
    Significant Deficiency
  • 1055153 2023-002
    Significant Deficiency
  • 1055154 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus Local Fiscal Recovery Funds (arpa) $8.81M
93.575 Child Care and Development Block Grant $2.81M
95.001 High Intensity Drug Trafficking Areas Program $2.57M
93.658 Foster Care_title IV-E $2.18M
93.778 Medical Assistance Program $2.06M
93.558 Temporary Assistance for Needy Families $1.78M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $1.50M
21.023 Covid-19 Emergency Rental Assistance $1.32M
93.563 Child Support Enforcement $1.23M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $946,769
93.667 Social Services Block Grant $831,913
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $714,702
93.323 Covid 19 - Epidemiology and Laboratory Capacity for Infectious Diseases $546,066
93.659 Adoption Assistance $541,899
97.067 2022 State Homeland Security Program $435,100
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $383,042
21.027 Covid-19 American Rescue Plan Act $349,587
20.205 Highway Planning and Construction $292,000
21.027 Covid-19 County Behavioral Health $160,353
93.569 Community Services Block Grant $153,425
93.645 Stephanie Tubbs Jones Child Welfare Services Program $138,252
93.268 Immunization and Vaccines for Children $131,125
93.994 Maternal and Child Health Services Block Grant to the States $121,775
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Ph Crisis Response $70,649
21.027 Covid-19 American Rescue Plan Act-County Behavioral Health $70,498
16.922 Equitable Sharing Program $64,862
93.575 Early Childhood Development Grant - Ccdf Discretionary $55,497
93.575 Child Care and Development Block Grant -Early Childhood Development - Health Dept $42,969
10.551 Supplemental Nutrition Assistance Program (snap) $32,814
21.027 Covid-19 Hb 22-1281 Children, Youth and Family Services $20,310
20.616 National Priority Safety Programs $15,963
93.940 Hiv Prevention Activities_health Department Based $15,230
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $13,276
93.317 Emerging Infections Programs $12,958
93.090 Guardianship Assistance $12,715
21.027 Covid-19 Emerging and Expanding Child Care $9,468
93.069 Public Health Emergency Preparedness $7,907
97.067 2020 State Homeland Security Program $6,995
16.741 Dna Backlog Reduction Program $6,659
93.747 Covid 19-Elder Abuse Prevention Intervention Program (crf) $6,335
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $5,594
10.551 Supplemental Nutrition Assistance Program (snap) Outreach $3,055
14.231 Emergency Solutions Grant (esg) $79
93.472 Title IV-E Prevention Program $23