Finding 1179620 (2023-003)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2026-03-16

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) has errors, failing to accurately reflect the County's federal award expenditures.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations Part 200 is compromised due to insufficient internal controls over SEFA reporting.
  • Recommended Follow-Up: Implement stronger internal controls, including reconciliation with accounting records and a review process for accuracy in SEFA preparation.

Finding Text

Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires auditees to prepare an accurate Schedule of Expenditures of Federal Awards containing awards expended, assistance listing title and number, award number, name of the Federal agency, name of pass-through entity, and awards paid to subrecipients. Condition: During our audit, we noted that the Schedule of Expenditures of Federal Awards contained errors. The County's current internal controls over Schedule of Expenditures of Federal Awards reporting are not sufficient enough to ensure correct reporting. This finding is a repeat finding and was reported in the most recent audit for the years ended December 31, 2022 and 2021. Discrepancies in amounts reported on the SEFA and amounts supported by underlying accounting records are summarized as follows: [ see chart ]. 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: Improvements in SEFA preparation have been implemented in order to ensure accuracy.

Corrective Action Plan

Improvements in SEFA preparation have been implemented in order to ensure accuracy.

Categories

Reporting Subrecipient Monitoring

Programs in Audit

ALN Program Name Expenditures
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $1.20M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $311,132
21.032 LOCAL ASSISTANCE AND TRIBAL CONSISTENCY FUND $269,493
20.205 HIGHWAY PLANNING AND CONSTRUCTION $235,007
15.226 PAYMENTS IN LIEU OF TAXES $202,558
15.438 NATIONAL FOREST ACQUIRED LANDS $131,676
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $130,686
10.766 COMMUNITY FACILITIES LOANS AND GRANTS $78,550
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $9,169
90.404 HAVA ELECTION SECURITY GRANTS $7,862
16.575 CRIME VICTIM ASSISTANCE $7,590
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $4,165
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $3,675
20.607 ALCOHOL OPEN CONTAINER REQUIREMENTS $2,376
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $1,875
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $969