Finding 1162629 (2024-004)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-11-18

AI Summary

  • Core Issue: The County's Schedule of Expenditures of Federal Awards (SEFA) underreported expenditures by $1,184,214 for the Coronavirus State and Local Fiscal Recovery Funds.
  • Impacted Requirements: Compliance with 2 CFR 200.510(b) is at risk due to inadequate internal controls over SEFA preparation.
  • Recommended Follow-Up: Implement a robust internal control system, including reconciliation to accounting records and independent review for accuracy.

Finding Text

2024-004: Internal Control Over Schedule of Expenditures of Federal Awards Federal Grantor: U.S. Department of the Treasury Pass-Through Grantor: N/A Federal Assistance Listing Number: 21.027 Program Title: Coronavirus State and Local Fiscal Recovery Funds Pass-through Entity Identifying Number: N/A Award Year: 2024 Questioned Costs: None Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards (SEFA) which must report total federal awards expended during the audit period. At a minimum, the schedule must include: expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. Condition: The SEFA reported by the County in the 2024 annual budget document underreported expenditures of the Coronavirus State and Local Fiscal Recovery Funds program (ALN 21.027) by $1,184,214. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for the year ended December 31, 2024. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.

Corrective Action Plan

The SEFA information needed for this finding was from the 2025 budget. The 2025 budget can be amended up to 12/31/2025. Even though the ARPA funds in question were not reported on the SEFA page of the 2025 budget, it was reported within the budget within its own fund, which would show actual expenditures of the year ended December 31, 2024. Going forward the County Clerk will have the Treasurer review the SEFA report for accuracy.

Categories

Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 1162627 2024-004
    Material Weakness Repeat
  • 1162628 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $84,680
20.205 HIGHWAY PLANNING AND CONSTRUCTION $29,641
15.685 NATIONAL FISH PASSAGE $16,975
90.404 HAVA ELECTION SECURITY GRANTS $7,605
15.226 PAYMENTS IN LIEU OF TAXES $4,148
39.003 DONATION OF FEDERAL SURPLUS PERSONAL PROPERTY $2,000
15.659 NATIONAL WILDLIFE REFUGE FUND $792