Finding 1225547 (2024-005)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2026-08-03
Audit: 408441
Organization: The Simple Foundation (NE)

AI Summary

  • Core Issue: Expenditures were incorrectly coded in the general ledger due to new accounting software implementation.
  • Impacted Requirements: This violates 2 CFR §200.303, which mandates effective internal controls over federal awards.
  • Recommended Follow-Up: Enhance training on the accounting system, establish a review process for coding, and conduct regular reconciliations to prevent misclassifications.

Finding Text

Criteria: In accordance with 2 CFR §200.303, the auditee must establish and maintain effective internal control over federal awards to provide reasonable assurance that expenditures are properly recorded and reported in compliance with applicable laws, regulations, and the terms and conditions of the award. Condition: During testing of allowability, we identified instances in which expenditures were coded to incorrect accounts within the general ledger. Cause: Based on inquiry with management, the errors occurred due to the implementation of new accounting software during the year under audit, which resulted in inconsistencies in account mapping and user understanding of the updated chart of accounts. Effect: Improper coding of expenditures increases the risk that costs may be misclassified or reported incorrectly on financial reports and federal schedules, including the SEFA. This could lead to noncompliance with federal reporting requirements and reduce the reliability of financial information used for decision-making. Recommendation: We recommend that management strengthen internal controls over financial reporting by (1) providing additional training to personnel on the updated accounting system and chart of accounts, (2) implementing a review process to verify proper coding of expenditures, particularly following system changes, and (3) performing periodic reconciliations and monitoring procedures to detect and correct misclassifications in a timely manner. Foundation Response: Management agrees with the finding.

Corrective Action Plan

1. Provide additional training to accounting personnel on the updated accounting system (Aplos) and the current chart of accounts. Target: August 31, 2026. 2. Implement a review process to verify proper coding of expenditures, particularly following system changes or chart-of-account updates, with sign-off by the Finance Director. Target: September 31, 2026. 3. Perform periodic (at least quarterly) reconciliations and monitoring procedures between the Aplos general ledger and the grant financial reporting system (Airtable/Euna) to detect and correct misclassifications in a timely manner, beginning Q3 2026.

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 1225546 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $1.97M