Finding 1226240 (2023-009)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2026-08-11

AI Summary

  • Core Issue: The County's schedule of expenditures of federal awards (SEFA) contained significant errors, failing to report accurate federal expenditures and missing required program details.
  • Impacted Requirements: The SEFA did not include necessary information such as program clusters, pass-through entity details, or total subrecipient amounts, violating Title 2 U.S. Code of Federal Regulations Part 200.510(b).
  • Recommended Follow-Up: Implement robust internal controls for SEFA preparation, including reconciliations with accounting records and independent reviews for accuracy to ensure compliance in future reports.

Finding Text

Criteria: Title 2 U.S. Code of Federal Regulations Part 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include: expenditures by individual program, program title and assistance listing number, programs required to be identified as part of a cluster, name of the pass-through entity and identifying number assigned by the pass-through entity for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. Condition: The schedule of expenditures of federal awards (SEFA) reported by the County in the annual budget documents contained errors in amounts of federal expenditures reported. Additionally, the schedule did not include the identification of programs required to be part of a cluster, names of pass-through entities, identifying numbers assigned by the pass-through entities, or total amounts provided to subrecipients for the applicable programs. The County excluded federal funds expenditures from the following programs: 15.226 - Payments in Lieu of Taxes, 16.738 - Edward Byrne Memorial Justice Assistance Grant Program, 20.205 - Highway Planning and Construction, and 21.027 - COVID-19 Coronavirus State and Local Fiscal Recovery Funds. Additionally, the County reported the total amount of receipts for 93.563 - Child Support Services rather than expenditures. 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. Reasons for discrepancies varied. Effect: The SEFA presented for the audit did not accurately reflect the County's actual expenditures of federal awards for the year ended December 31, 2023. 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, such as performing a reconciliation between the SEFA and underlying accounting records. Federal reimbursement grants should be reported on the SEFA based on reimbursable expenditures made during the year. Management's Response: The Treasurer has reviewed the corrected SEFA and understands the errors. Funds will be reported accurately in the future.

Corrective Action Plan

The Treasurer has reviewed the corrected SEFA and understands the errors. Funds will be reported accurately in the future.

Categories

Subrecipient Monitoring Reporting Cash Management

Other Findings in this Audit

  • 1226241 2023-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $1.15M
16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $133,146
93.563 CHILD SUPPORT SERVICES $40,402
15.226 PAYMENTS IN LIEU OF TAXES $13,662
16.540 JUVENILE JUSTICE AND DELINQUENCY PREVENTION $12,900
20.205 HIGHWAY PLANNING AND CONSTRUCTION $9,952
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $4,292