Finding 401815 (2023-004)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-06-24

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) is not properly reconciled with the general ledger, risking material misstatements.
  • Impacted Requirements: SEFA must directly relate to underlying accounting records to ensure accuracy in financial reporting.
  • Recommended Follow-Up: Timely reconciliations of grant revenue accounts to actual expenditures should be established and maintained.

Finding Text

2023-004 Schedule of Expenditures of Federal Awards (Repeat Partially Resolved Prior Year Audit Finding 2022-005; Originally Reported as Finding 2020-006) Criteria: The information in the Schedule of Expenditures of Federal Awards (SEFA) should be derived from, and relate directly to, the underlying accounting and other records used to prepare the financial statements. Condition and Context: The grant expenditures on the SEFA were not reconciled to the general ledger accounting system or other records used to prepare the financial statements. Cause: Revenue accounts and internal funds by grant program have been created for each reimbursement grant program. However, grant receivables were not recorded and revenue accounts for each reimbursement grant program were not reconciled to the underlying expenditures in the accounting and other records used to prepare the financial statements and SEFA. Effect or Potential Effect: The SEFA could be materially misstated if grant expenditures reported on the SEFA are not reconciled to the underlying accounting and other records used to prepare the financial statements. Recommendation: Reimbursement grant revenue accounts should be reconciled to the underlying grant expenditures on the grant request and other reports on a timely basis. Responsible Official's Response: Frequent reconciliations, along with implementation of policy and procedures, has allowed data to be accurate in the accounting system while matching data information on government reports since the finding from prior year. The organizational staff has adequately added and maintained information in the accounting software as requested from previous finding on prior year, which should meet OMB requirements.

Corrective Action Plan

We concur. According to previous findings, daily expenditures have been recorded into the general ledger as they occur and reconciled in a timely manner monthly. Adjustments will be recorded into the general accounting system daily, after a review by the Executive Director on completion of entries by the Office Manager. In corrective action steps already in place from the previous year’s findings, adjustments have been recorded in the general accounting system and accounts have been reconciled in a timely manner.

Categories

Reporting Cash Management Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 401814 2023-003
    Material Weakness Repeat
  • 401816 2023-003
    Material Weakness Repeat
  • 401817 2023-004
    Material Weakness Repeat
  • 978256 2023-003
    Material Weakness Repeat
  • 978257 2023-004
    Material Weakness Repeat
  • 978258 2023-003
    Material Weakness Repeat
  • 978259 2023-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
17.264 National Farmworker Jobs Program $705,024
94.002 Retired and Senior Volunteer Program $87,609