Finding 1061443 (2023-008)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-08-23
Audit: 317793
Organization: Rio Arriba County (NM)
Auditor: Cordova CPAS LLC

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was incomplete and inaccurate, missing $405,297 in federal expenditures.
  • Impacted Requirements: Compliance with OMB Uniform Guidance, which mandates that SEFA must be complete and accurate, including necessary award identification details.
  • Recommended Follow-Up: Implement a system to ensure the SEFA is prepared accurately during the closing process, involving experienced Grants staff to prevent future issues.

Finding Text

Federal program information: Funding agency: All Programs Title: All Programs Federal Assistance Listing Number: All Programs Compliance Requirement: Reporting Award Period: July 1, 2022 to June 30, 2023 Condition: During our procedures over the Schedule of Expenditures of Federal Awards we noted the SEFA was given to the auditors and was not complete or accurate missing $405,297 of the total federal expenditures. Criteria: OMB Uniform Guidance requires award identification to include, as applicable, the Federal Assistance Number and title, the award number and years, the name of the federal agency, and the name of any applicable passthrough entities, and that the Schedule of Expenditures of Federal Awards is complete and accurate. Cause: The County experienced a lot of turnover towards the end of the fiscal year and with the positions that worked to fill out the of Schedule of Expenditures of Federal Awards in prior years so there were delays and unfamiliarity with all the programs that needed to be included. Effect: The County is in violation of the Uniform Guidance requirements. Auditor’s Recommendation: We recommend that the County implement a system to ensure items needed to prepare the Schedule of Expenditure and Federal Awards be done in the closing process so that when the audit starts the Schedule of Expenditure and Federal Awards is ready to be audited and is complete and accurate. Agency’s Response: Management is in agreement with this finding and with the Auditor’s notes. Staff preparing the SEFA was new, and in turn, unfamiliar with many awards. Rio Arriba intends to remedy this by involving the Grants staff in this process as they are directly involved and most familiar with the grant funding the County receives. The Finance Director and Deputy Finance Director will work with the staff designee (Grants) that will prepare the SEFA to ensure accurate information is reported for the Fiscal Year 2024 audit.

Categories

Reporting

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.11M
16.710 Public Safety Partnership and Community Policing Grants $610,504
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $488,905
14.850 Public and Indian Housing $255,696
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $231,815
16.838 Comprehensive Opioid Abuse Site-Based Program $181,075
14.871 Section 8 Housing Choice Vouchers $65,341
15.227 Distribution of Receipts to State and Local Governments $37,193
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $35,794
93.235 Affordable Care Act (aca) Abstinence Education Program $17,768
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $17,664
93.071 Medicare Enrollment Assistance Program $13,129
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $12,124
16.738 Edward Byrne Memorial Justice Assistance Grant Program $10,725
12.U01 Law Enforcement, Abiquiu Lake $8,636
93.241 State Rural Hospital Flexibility Program $6,500
10.666 Schools and Roads - Grants to Counties $6,111
93.136 Injury Prevention and Control Research and State and Community Based Programs $1,757
93.053 Nutrition Services Incentive Program $134