Finding 1157454 (2024-004)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-09-30

AI Summary

  • Issue: A grant of $79,194 was missing from the SEFA, leading to a necessary restatement.
  • Requirements Impacted: The SEFA must accurately list all Federal programs and expenditures as per 2 CFR §200.510(b).
  • Recommended Follow-Up: Implement procedures for accurate SEFA preparation, including reconciliations and management reviews before audit submission.

Finding Text

Condition: On the original SEFA provided for the audit, one grant was inaccurately omitted from the schedule, resulting in a restatement of the SEFA. The SEFA provided for the audit did not include a grant passed through the Hawaii Community Foundation, AL Number 66.203 totaling $79,194. Criteria: Per 2 CFR §200.510(b), the auditee must prepare a SEFA for the period covered by the auditee’s financial statements. The schedule must list individual Federal programs by Federal agency and Assistance Listing number, provide the total Federal awards expended, be accurate and complete, and include notes describing the significant accounting policies used in preparing the schedule. Cause: The Organization did not have adequate procedures in place to ensure that all Federal expenditures were identified and included in the SEFA, nor was a comprehensive reconciliation to the general ledger performed prior to submission for audit. Effect: The SEFA as prepared by management was incomplete. This increases the risk that users of the SEFA (including Federal agencies and pass-through entities) could be misled as to the level of Federal funding expended. It also impairs transparency and accountability in Federal award reporting and could result in questioned costs or findings by oversight agencies. Questioned Costs: None Recommendation: We recommend that the Organization implement procedures to ensure that the SEFA is prepared accurately and completely. These procedures should include reconciling the SEFA to the general ledger and grant revenue accounts, confirming completeness by reviewing all grant agreements and funding sources, and establishing a management review process to validate accuracy prior to submission for audit. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding; see corrective action plan.

Corrective Action Plan

The Organization acknowledges that one Federal grant was omitted from the original SEFA submitted for audit, requiring a restatement. To correct this issue, management will implement a reconciliation process that compares all grant revenue accounts and funding agreements to the draft SEFA prior to submission. The Organization will also designate a member of the finance team to perform an independent review of the SEFA for completeness and accuracy. These procedures will help ensure that all Federal awards are properly identified, included, and reported in the SEFA in future reporting periods.

Categories

Reporting

Other Findings in this Audit

  • 1157453 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.727 Inflation Reduction Act Urban & Community Forestry Program $2.36M
66.615 Environmental Justice Thriving Communities Grantmaking Program (ej Tcgm) $118,030
66.309 Surveys, Studies, Investigations, Training and Special Purpose Activities Relating to Environmental Justice $89,813
66.203 Environmental Finance Center Grants $79,194
81.117 Energy Efficiency and Renewable Energy Information Dissemination, Outreach, Training and Technical Analysis/assistance $39,213
21.027 Coronavirus State and Local Fiscal Recovery Funds $7,347