Finding 1074976 (2023-002)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-09-26
Audit: 321277
Organization: Outagamie County (WI)

AI Summary

  • Core Issue: The County lacks a formal review process for quarterly project and expenditure reports, leading to potential inaccuracies in financial reporting.
  • Impacted Requirements: This finding violates 2 CFR 200.302, which mandates accurate identification and reconciliation of federal awards and expenditures.
  • Recommended Follow-Up: Implement a formal review process to ensure quarterly reports are accurately compared and reconciled with the general ledger.

Finding Text

SECTION III - FEDERAL AND STATE AWARD FINDINGS AND QUESTIONED COSTS 2023 – 002 Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: 2023 Pass-Through Agency: N/A Pass-Through Number(s): N/A Award Period: January 1, 2023 - December 31, 2023 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: 2 CFR 200.302 requires that "The financial management system of each non-Federal entity must provide for the following: (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the AL title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any." Grant claims filed by the County to the various granting agencies must be accurate, reconcile to the County general ledger system, and for cost-reimbursement grants, represent costs incurred. Internal controls should be designed and implemented to prevent and detect errors in the data reported on the grant claims. Segregation of duties is an internal control intended to prevent or decrease the occurrence of errors or intentional fraud. Segregation of duties ensures that no single employee has control over all phases of a transaction. Condition: There was no final formal review of the quarterly project & expenditure reports in comparison to the general ledger. Questioned costs: None Context: While performing audit procedures, it was noted that there was not a final formal review done of the quarterly project & expenditure reports in comparison to the general ledger. Cause: Due to the County not having a formal review process in place, the County under-reported 2023 expenditures to the U.S. Department of Treasury. Effect: The County could over- or under-report certain expenditures. Repeat Finding: No Recommendation: We recommend the County review its processes and implement controls to formally review these quarterly reports and that they are compared and reconciled to the general ledger. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Internal Control / Segregation of Duties Subrecipient Monitoring Cash Management HUD Housing Programs Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 498533 2023-002
    Significant Deficiency
  • 498534 2023-002
    Significant Deficiency
  • 1074975 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program, Covid-19 Airports Programs, and Infrastructure Investment and Jobs Act Programs $4.56M
93.778 Medical Assistance Program $687,994
21.027 Coronavirus State and Local Fiscal Recovery Funds $409,055
93.658 Foster Care Title IV-E $223,064
93.558 Temporary Assistance for Needy Families $196,353
20.600 State and Community Highway Safety $167,629
93.959 Block Grants for Prevention and Treatment of Substance Abuse $122,721
20.616 National Priority Safety Programs $121,493
93.563 Child Support Services $121,089
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $118,832
66.460 Nonpoint Source Implementation Grants $108,311
97.042 Emergency Management Performance Grants $100,540
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $100,073
93.069 Public Health Emergency Preparedness $79,724
93.090 Guardianship Assistance $73,085
93.767 Children's Health Insurance Program $68,527
93.556 Marylee Allen Promoting Safe and Stable Families Program $66,620
16.738 Edward Byrne Memorial Justice Assistance Grant Program $56,607
93.659 Adoption Assistance $55,782
66.469 Geographic Programs - Great Lakes Restoration Initiative $55,584
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $50,402
93.958 Block Grants for Community Mental Health Services $48,472
15.658 Natural Resource Damage Assessment and Restoration $38,427
93.053 Nutrition Services Incentive Program $35,955
16.606 State Criminal Alien Assistance Program $35,028
93.994 Maternal and Child Health Services Block Grant to the States $32,854
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $31,794
93.136 Injury Prevention and Control Research and State and Community Based Programs $31,358
97.047 Bric: Building Resilient Infrastructure and Communities $25,832
93.747 Elder Abuse Prevention Interventions Program $25,588
21.032 Local Assistance and Tribal Consistency Fund $24,041
93.052 National Family Caregiver Support, Title Iii, Part E $23,639
93.268 Immunization Cooperative Agreements $22,194
10.902 Soil and Water Conservation $20,979
93.667 Social Services Block Grant $16,260
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $14,203
93.991 Preventive Health and Health Services Block Grant $10,787
84.181 Special Education-Grants for Infants and Families $10,186
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $8,626
93.324 State Health Insurance Assistance Program $8,621
16.800 Internet Crimes Against Children Task Force Program $7,907
93.645 Stephanie Tubbs Jones Child Welfare Services Program $6,106
93.043 Special Programs for the Aging, Title Iii, Part D, Disease Prevention and Health Promotion Services $4,746
93.575 Child Care and Development Block Grant $4,160
16.710 Public Safety Partnership and Community Policing Grants $466