Finding 12575 (2022-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-09-27
Audit: 17290
Organization: Chisago County (MN)

AI Summary

  • Core Issue: Two quarterly reports were inaccurately reported, affecting compliance with federal requirements.
  • Impacted Requirements: Internal controls over federal awards must ensure accurate reporting as per Title 2 U.S. Code of Federal Regulations 200.303.
  • Recommended Follow-Up: The County should review and verify the accuracy of all quarterly Project and Expenditure Reports moving forward.

Finding Text

2022-003 Reporting Prior Year Finding Number: N/A Repeat Finding Since: N/A Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Significant Deficiency and Other Matter Federal Agency: U.S. Department of the Treasury Program: 21.027 COVID-19 ? Coronavirus State and Local Fiscal Recovery Funds Criteria: Title 2 U.S. Code of Federal Regulations ? 200.303 states that the auditee must establish and maintain effective internal control over the federal award that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: Of the four quarterly Project and Expenditure Reports, two reports were reported inaccurately. Questioned Costs: None. Context: The current period expenditures for the revenue replacement project in the third quarter report were underreported by $562,930. The current period expenditures for the broadband project in the fourth quarter report were overreported by $49,975. Effect: The U.S. Treasury Department did not receive accurate current period expenditures for the third and fourth quarter Project and Expenditure Reports for the revenue replacement and the broadband projects. Cause: When preparing the third and fourth quarter Project and Expenditure Reports, staff decided to reclassify expenditures from the revenue replacement project to the broadband project and simply inserted the wrong current period expenditures on the report. The cumulative expenditure amounts reported for each project were correctly reported. Only the current period expenditure amounts were incorrect. Recommendation: We recommend that the County review its quarterly Project and Expenditure Reports to ensure that the amounts reported are complete and accurate. View of Responsible Official: Concur

Corrective Action Plan

Finding Number: 2022-003 Finding Title: Reporting Program: 21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Name of Contact Person Responsible for Corrective Action: Kristin Waddell Corrective Action Planned: The County will have a second review done of the report before filing. Anticipated Completion Date: Immediately

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 12576 2022-002
    Material Weakness
  • 12577 2022-001
    Significant Deficiency
  • 589017 2022-003
    Significant Deficiency
  • 589018 2022-002
    Material Weakness
  • 589019 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.205 Highway Planning and Construction $1.82M
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $1.78M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $507,878
93.563 Child Support Enforcement $474,175
93.558 Temporary Assistance for Needy Families $288,904
93.667 Social Services Block Grant $267,084
93.658 Foster Care_title IV-E $240,083
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $181,162
93.069 Public Health Emergency Preparedness $78,373
16.575 Crime Victim Assistance $60,494
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $55,362
93.994 Maternal and Child Health Services Block Grant to the States $39,329
90.404 Covid-19 - 2018 Hava Election Security Grants $36,791
97.042 Emergency Management Performance Grants $30,672
93.575 Child Care and Development Block Grant $23,502
93.778 Medical Assistance Program $20,502
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $19,894
93.268 Immunization Cooperative Agreements $17,862
93.590 Community-Based Child Abuse Prevention Grants $16,161
20.600 State and Community Highway Safety $14,350
20.616 National Priority Safety Programs $13,955
84.181 Special Education-Grants for Infants and Families $11,410
93.669 Child Abuse and Neglect State Grants $10,532
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $10,264
97.012 Boating Safety Financial Assistance $7,500
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $6,990
93.556 Promoting Safe and Stable Families $5,293
93.645 Stephanie Tubbs Jones Child Welfare Services Program $4,460
93.767 Children's Health Insurance Program $2,592
93.251 Early Hearing Detection and Intervention $1,025
93.674 Covid-19 - John H. Chafee Foster Care Program for Successful Transition to Adulthood $947
93.566 Refugee and Entrant Assistance_state Administered Programs $824
10.572 Wic Farmers' Market Nutrition Program (fmnp) $509