Finding 501557 (2023-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-10-02
Audit: 323607
Organization: Adams County, Wisconsin (WI)

AI Summary

  • Core Issue: Lack of a review process for reports submitted to the federal government increases the risk of errors.
  • Impacted Requirements: Internal controls require that reports be reviewed by someone other than the preparer to ensure accuracy.
  • Recommended Follow-Up: Implement a review and approval process for all reports before submission to enhance data accuracy and compliance.

Finding Text

Federal Agency: US Department of the Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Fund Assistance Listing Number: 21.027 Federal Award Identification Number and Year: Unknown Pass-Through Agency: n/a Pass-Through Number(s): n/a Award Period: 3/3/2021-12/31/2026 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Review of reports and supporting documentation by someone other than the preparer prior to submitting the report is an internal control intended to prevent or decrease the occurrence of errors. Condition: The County Finance Director maintains a spreadsheet of all approved projects and costs to date and shares this file with the County Administration and Finance Committee on a monthly basis. The spreadsheet is used as the basis for the annual Project and Expenditure Report due in April. There was no review by someone other than the preparer of the report prior to its submission to the federal government. Accordingly, this does not allow for a proper segregation of duties for internal control purposes over reporting compliance requirements. Questioned Costs: None Context: While performing audit procedures, it was noted that no one reviewed the report prior to submitting the report to the federal government. The report was reviewed one month after submission by the County Manager /Administrative Coordinator. Cause: The County does not have a review process in place to catch errors in reporting, or to verify that the amounts reported match supporting documentation prior to the report being submitted to the federal government. Effect: The report submitted by the County may contain errors that would not be detected. Reported expenditures may not reconcile to County's general ledger and amounts may be over or under reported. Repeat Finding: No. Recommendation: We recommend the County develop and implement a process to require review and approval of all required reports prior to the submission of the report to the federal government to help ensure that the data reported are accurate and complete. View of Responsible Officials: There is no disagreement with the audit finding.

Corrective Action Plan

SLFRF Reporting Coronavirus State and Local Fiscal Recovery Funds – Assistance Listing No. 21.027 Recommendation: CLA recommends the County develop and implement a process to require review and approval of all required reports prior to the submission of the report to the federal government to help ensure that the data reported are accurate and complete. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: Management has reviewed this finding and will implement a more formal process for reviewing and approving of annual filings related to State and Local Fiscal Recovery Funds. Name(s) of the contact person(s) responsible for corrective action: Kyle Patterson Planned completion date for corrective action plan: 12/31/2024

Categories

Reporting Internal Control / Segregation of Duties Significant Deficiency

Other Findings in this Audit

  • 1077999 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $151,707
93.778 Medical Assistance Program $116,700
93.434 Every Student Succeeds Act/preschool Development Grants $75,000
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $70,005
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $39,561
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $33,383
93.556 Promoting Safe and Stable Families $32,973
93.069 Public Health Emergency Preparedness $32,008
84.181 Special Education-Grants for Infants and Families $24,784
93.268 Immunization Cooperative Agreements $17,249
20.616 National Priority Safety Programs $16,775
93.053 Nutrition Services Incentive Program $14,685
93.658 Foster Care_title IV-E $12,873
93.767 Children's Health Insurance Program $12,096
93.090 Guardianship Assistance $10,474
93.958 Block Grants for Community Mental Health Services $9,814
90.404 2018 Hava Election Security Grants $9,000
93.994 Maternal and Child Health Services Block Grant to the States $8,873
93.052 National Family Caregiver Support, Title Iii, Part E $6,177
20.106 Airport Improvement Program $5,681
97.042 Emergency Management Performance Grants $5,415
93.959 Block Grants for Prevention and Treatment of Substance Abuse $5,000
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $4,961
93.659 Adoption Assistance $4,800
93.324 State Health Insurance Assistance Program $3,500
20.600 State and Community Highway Safety $3,490
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $2,435
93.667 Social Services Block Grant $2,103
16.710 Public Safety Partnership and Community Policing Grants $1,966
93.558 Temporary Assistance for Needy Families $1,801
93.071 Medicare Enrollment Assistance Program $1,791
93.645 Stephanie Tubbs Jones Child Welfare Services Program $790
21.027 Coronavirus State and Local Fiscal Recovery Funds $736
93.991 Preventive Health and Health Services Block Grant $696
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $305
93.575 Child Care and Development Block Grant $160
93.563 Child Support Enforcement $-26,347