Finding 42104 (2022-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-10-01
Audit: 39049

AI Summary

  • Core Issue: The County's ARPA reports do not match the trial balance expenditures, leading to compliance concerns.
  • Impacted Requirements: Federal guidelines require accurate reporting of expenditures and a clear choice between standard allowance and calculated revenue loss.
  • Recommended Follow-Up: The County should enhance its review processes to ensure all reports are accurate and compliant with grant requirements.

Finding Text

Finding 2022-001 ? Reporting US Department of the Treasury ? COVID-19 Coronavirus State and Local Fiscal Recovery Funds (ARPA) (ALN 21.027) Condition: The County?s submitted reports for ARPA do not materially agree to the expenditures reported in the trial balance. For the revenue loss, the County?s report shows that they are using the standard allowance, however, they originally elected to calculate their revenue loss. Criteria: In accordance with the federal compliance requirements for ARPA, current reporting period expenditures and cumulative expenditures must be entered for each project. The County must elect whether to use the standard revenue loss amount or to calculate the revenue loss according to the formula and enter the information on the reports accordingly. Cause: There was not a review and a reconciliation of the amounts being submitted on the reports to the amounts recorded in the trial balance. Effect: The County is not in compliance with reporting requirements, and failure to comply with grant award requirements could jeopardize future funding and does not allow the funder to adequately oversee the use of their funding. Recommendation: We recommend that the County continue its efforts in evaluating its procedures to ensure that all required reports are accurately submitted. View of Responsible Official: See the corrective action plan.

Corrective Action Plan

Finding 2022-001 - Reporting US Department of the Treasury- COVID-19 Coronavirus State and Local Fiscal Recovery Funds (ARPA) (ALN 21.027) Condition: The County's submitted reports for ARPA do not materially agree to the expenditures reported in the trial balance. For the revenue loss, the County's report shows that they are using the standard allowance, however, they originally elected to calculate their revenue loss. Criteria: In accordance with the federal compliance requirements for ARPA, current reporting period expenditures and cumulative expenditures must be entered for each project. The County must elect whether to use the standard revenue loss amount or to calculate the revenue loss according to the formula and enter the information on the reports accordingly. Cause: There was not a review and a reconciliation of the amounts being submitted on the reports to the amounts recorded in the trial balance. Effect: The County is not in compliance with reporting requirements, and failure to comply with grant award requirements could jeopardize future funding and does not allow the funder to adequately oversee the use of their funding. Recommendation: We recommend that the County continue its efforts in evaluating its procedures to ensure that all required reports are accurately submitted. Corrective Action: The County will continue to work with the internal auditors and the treasury department to clear up the reporting issues so that trial balances more readily tie out to the reports available in the treasury portal. This will include working to amend the reports submitted currently in the reporting portal. Initial contact with the treasury has been made at this time of this report and the treasury has responded and is working to open reports so they can be amended.

Categories

Reporting

Other Findings in this Audit

  • 618546 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19, Coronavirus State and Local Fiscal Recovery Funds $12.42M
21.023 Covid-19, Emergency Rental Assistance Program $3.62M
93.563 Child Support Enforcement $2.58M
93.558 Temporary Assistance for Needy Families $904,696
14.231 Emergency Solutions Grant Program $569,800
14.218 Covid-19, Community Development Block Grants/entitlement Grants $562,597
14.218 Community Development Block Grants/entitlement Grants $385,037
10.569 Emergency Food Assistance Program (food Commodities) $356,924
93.659 Covid-19, Adoption Assistance $230,659
97.042 Emergency Management Performance Grants $141,223
84.181 Special Education-Grants for Infants and Families $115,838
93.959 Block Grants for Prevention and Treatment of Substance Abuse $115,375
93.667 Social Services Block Grant $114,964
20.205 Highway Planning and Construction $108,244
93.645 Stephanie Tubbs Jones Child Welfare Services Program $107,512
93.053 Nutrition Services Incentive Program $106,032
10.568 Emergency Food Assistance Program (administrative Costs) $86,930
93.052 National Family Caregiver Support, Title Iii, Part E $78,157
93.788 Opioid Str $73,062
16.575 Crime Victim Assistance $70,998
93.958 Block Grants for Community Mental Health Services $66,115
93.658 Covid-19, Foster Care_title IV-E $61,589
14.905 Lead Hazard Reduction Demonstration Grant Program $59,056
93.658 Foster Care_title IV-E $55,689
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $52,679
10.555 National School Lunch Program $45,382
10.912 Environmental Quality Incentives Program $43,500
16.606 State Criminal Alien Assistance Program $40,401
93.044 Covid-19, Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $37,573
93.090 Covid-19, Guardianship Assistance $32,484
16.034 Covid-19, Coronavirus Emergency Supplemental Funding Program $29,416
10.553 School Breakfast Program $26,560
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $22,530
20.710 Technical Assistance Grants $17,825
10.555 Covid-19, National School Lunch Program $17,081
97.067 Homeland Security Grant Program $16,696
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $16,534
93.556 Promoting Safe and Stable Families $15,702
93.045 Covid-19, Special Programs for the Aging_title Iii, Part C_nutrition Services $15,153
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $13,214
10.025 Plant and Animal Disease, Pest Control, and Animal Care $10,424
93.778 Medical Assistance Program $10,096
93.136 Injury Prevention and Control Research and State and Community Based Programs $10,000
93.324 State Health Insurance Assistance Program $10,000
93.991 Preventive Health and Health Services Block Grant $10,000
93.042 Covid-19, Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $8,840
93.779 Centers for Medicare and Medicaid Services (cms) Research, Demonstrations and Evaluations $7,864
93.071 Medicare Enrollment Assistance Program $7,257
15.226 Payments in Lieu of Taxes $5,058
93.041 Special Programs for the Aging_title Vii, Chapter 3_programs for Prevention of Elder Abuse, Neglect, and Exploitation $4,455
93.674 Covid-19, John H. Chafee Foster Care Program for Successful Transition to Adulthood $3,904
93.659 Adoption Assistance $2,368
93.090 Guardianship Assistance $61