Finding 1075110 (2023-002)

Material Weakness Repeat Finding
Requirement
ABL
Questioned Costs
$1
Year
2023
Accepted
2024-09-26
Audit: 321383
Organization: Mahnomen County (MN)

AI Summary

  • Core Issue: The County reported expenditures based on budgeted amounts instead of actual costs, leading to inaccuracies.
  • Impacted Requirements: Federal reporting mandates that expenditures reflect actual incurred costs, and internal controls must be in place to prevent errors.
  • Recommended Follow-Up: The County should establish procedures to ensure actual expenditures are reported and implement a review process for all financial reports.

Finding Text

Federal Program Coronavirus State and Local Fiscal Recovery Funds (AL 21.027) Activities Allowed or Unallowed, Allowable Costs, Reporting Criteria Federal reporting requirements require expenditures to be based on actual expenditures incurred. In addition, internal controls should be implemented over reporting to prevent errors on reports. Condition The County charged expenditures to the program based on budgeted expenditures, not actual expenditures. Questioned Costs $23,567 Context The program consisted of 121 transactions, of which 13 haphazard transactions were tested. There was only one (1) transaction of its type with this issue. This transaction is roughly 45% of the overall program expenditures. Cause The County created a budget spreadsheet of what they would charge to the program. The budgeted amount calculated was charged to the program. It was determined that these budgeted items did not agree to actual expenditures incurred. Effect Expenditures charged to the program were overstated. These budgeted expenditures were included in the financial reports submitted causing the financial report to be incorrect. Repeat Finding The County received a finding related to reporting in the prior year. Recommendation The County should implement procedures to ensure that expenditures charged to federal programs are based on actual expenditures. The County should also ensure that all reports submitted should be reviewed by someone other than the preparer and this review should be documented. Views of Responsible Officials and Planned Corrective Actions The County agrees with the recommendation and will review its procedures.

Categories

Questioned Costs Allowable Costs / Cost Principles HUD Housing Programs Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 498666 2023-003
    Significant Deficiency
  • 498667 2023-003
    Significant Deficiency
  • 498668 2023-002
    Material Weakness Repeat
  • 1075108 2023-003
    Significant Deficiency
  • 1075109 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $408,042
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $160,724
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $135,594
21.032 Local Assistance and Tribal Consistency Fund $100,000
93.563 Child Support Services $99,191
93.667 Social Services Block Grant $68,652
93.658 Foster Care Title IV-E $56,966
16.575 Crime Victim Assistance $46,148
93.558 Temporary Assistance for Needy Families $45,245
20.106 Airport Improvement Program, Covid-19 Airports Programs, and Infrastructure Investment and Jobs Act Programs $45,000
20.219 Recreational Trails Program $22,500
97.042 Emergency Management Performance Grants $9,417
16.710 Public Safety Partnership and Community Policing Grants $6,503
90.404 Hava Election Security Grants $4,287
93.590 Community-Based Child Abuse Prevention Grants $2,094
93.645 Stephanie Tubbs Jones Child Welfare Services Program $1,230
97.012 Boating Safety Financial Assistance $880
16.607 Bulletproof Vest Partnership Program $847
93.556 Marylee Allen Promoting Safe and Stable Families Program $691
93.767 Children's Health Insurance Program $572
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $470
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $395
93.575 Child Care and Development Block Grant $328
93.778 Medical Assistance Program $325