Finding 569433 (2024-001)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-06-30

AI Summary

  • Core Issue: Supporting documentation for the SEFA was inaccurate due to unresolved errors in the general ledger from a prior year’s software change.
  • Impacted Requirements: Internal controls over the preparation of SEFA support were found to be deficient, as management failed to correct known errors.
  • Recommended Follow-Up: Management should prioritize correcting the general ledger errors and enhance internal controls to prevent future discrepancies in SEFA documentation.

Finding Text

Portions of the supporting documentation provided by management for the Schedule of Expenditures of Federal Awards (SEFA) did not appear to be accurate. Upon further investigation we learned that this support was pulled directly from the general ledger’s grant coding, which had errors that management had noted during the prior year as a result of an accounting software change, but never corrected in the general ledger, even though they properly reported the correct allowable expenditures by grant in their Federal grant funding draw requests. Therefore, the supporting documentation related to the SEFA which was provided for the audit had to be corrected to accurately reflect the total allowable expenditures per each Federal grant. Even though management identified the coding errors in the general ledger during the prior year’s audit, they did not fully correct these errors in the general ledger, which was used to provide support for the SEFA. Therefore, we deem this to only be a significant deficiency in internal control over the preparation of the support of the SEFA, since this was a carryover of the issues noted in the prior year due to the software upgrade and the fact that the prior audit was not completed until June 2024, nine months into the Organization’s current fiscal year. It should be noted that the total expenditures actually reported by Federal grant on the SEFA were accurate.

Corrective Action Plan

NASWA has implemented the following procedures to ensure that the general ledger accurately reflects the approved federal grant expense and revenue activity: 1) Generation of monthly grant profit and loss statements, which are run per grant, to validate incurred expenses and revenue recognized in monthly invoice/drawdown. 2) Detailed review and creation of general ledger adjustments to expenses and/or revenue as grant funds are exhausted, or as other miscellaneous miscoding is discovered. 3) Final review and confirmation of monthly grant profit and loss statements before signing off on final invoicing or federal fund draw down.

Categories

Reporting Significant Deficiency

Other Findings in this Audit

  • 569434 2024-001
    Significant Deficiency Repeat
  • 569435 2024-001
    Significant Deficiency Repeat
  • 569436 2024-002
    Significant Deficiency
  • 569437 2024-002
    Significant Deficiency
  • 569438 2024-002
    Significant Deficiency
  • 1145875 2024-001
    Significant Deficiency Repeat
  • 1145876 2024-001
    Significant Deficiency Repeat
  • 1145877 2024-001
    Significant Deficiency Repeat
  • 1145878 2024-002
    Significant Deficiency
  • 1145879 2024-002
    Significant Deficiency
  • 1145880 2024-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
17.225 Unemployment Insurance $1.10M
17.207 Employment Service/wagner-Peyser Funded Activities $494,054
17.281 Wioa Dislocated Worker National Reserve Technical Assistance and Training $149,105