Finding 480132 (2023-002)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-08-01

AI Summary

  • Core Issue: The District's general ledger for FY 2023 did not match the financial reports submitted to the Commonwealth, leading to an understatement of expenditures by about $263,000.
  • Impacted Requirements: The lack of reconciliation and timely reporting violates Uniform Guidance requirements for maintaining internal controls over federal grants.
  • Recommended Follow-Up: Implement regular reconciliations between grant administration and accounting records, and review grants management policies to enhance accuracy and compliance.

Finding Text

Criteria:Current Uniform Guidance (and financial reporting) highlights the importance and requirements for grantees to maintain a system of internal controls surrounding the administration of federal grants which ensure all compliance requirements and the financial reporting related thereto are achieved for each federal program. Condition:The District’s general ledger for fiscal year 2023 did not reconcile with subsequent reporting for the fiscal year 2023 activity reported to the Commonwealth of Massachusetts. Moreover, the Final Reporting associated with the program has not been filed. As a result of our audit procedures, we noted the District understated fiscal year 2023 expenditures reported as expended in the grant by approximately $263,000. We also noted an additional $208,000 of subsequent year expenditures (FY2024) not posted to the grant within the ledger. Cause: The District’s general ledger and underlying grants and associated reporting were not reconciled. Potential Effect: The District’s reporting associated with the program is late. Additionally, the lack of reconciliation and monitoring of the grants with the general ledger allow for material misstatements within the District’s general ledger (financial statements and schedule of expenditures of federal awards) to occur. Misstatements could have an effect upon the decisions made by the users of the financial information. Based upon our procedures and discussion with current personnel, adjusting entries were proposed to correct the identified misclassified. Repeat Finding: This is a new finding in the current year. Auditor’s Recommendation: While the aforementioned program did not have a supplanting restriction, in our opinion, the District should post all financial activity as intended as part of the overall monitoring and grants administration. At minimum, routine reconciliation with grant administration personnel should be performed with the underlying accounting records to ensure adjusting/reclassifying entries (if needed) are posted timely, ensuring the accuracy of the general ledger and financial reports filed with pass-through entities. In our professional opinion, the District should evaluate established grants management policies and procedures and refined as deemed appropriate. Evaluation of established procedures should be incorporated as part of a routine risk assessment program.

Corrective Action Plan

We have received the audit findings regarding the material weakness identified in the reconciliation of the general ledger with the fiscal year 2023 reporting to the Commonwealth of Massachusetts. We appreciate the thorough review and the recommendations provided to enhance our financial management processes. We acknowledge the seriousness of the discrepancies identified, including the understatement of fiscal year 2023 expenditures by approximately $263,000 and the additional $208,000 of fiscal year 2024 expenditures not posted to the grant within the ledger. We are committed to addressing this material weakness promptly and effectively. In response to your recommendations, we propose the following actions: Posting Financial Activity: We will ensure all financial activity is posted as intended, as part of our overall monitoring and grants administration processes. This will involve enhanced oversight and verification procedures to confirm the accuracy of entries. Consistent Reconciliation: Biweekly/monthly reconciliation meetings will be conducted between the finance team and grants administration personnel. This will ensure that adjusting entries are posted in a timely manner, maintaining the accuracy of the general ledger and financial reports filed with pass-through entities. We will develop a reconciliation checklist/agenda to guide these meetings and ensure all discrepancies are identified and addressed promptly. Evaluation of Grants Management Policies and Procedures: We will conduct a thorough evaluation of our current grants management policies and procedures. This review will focus on identifying areas for improvement and refining our practices to enhance accuracy and compliance. As part of our routine risk assessment program, we will incorporate regular evaluations of our grants management processes to identify and mitigate risks proactively. Staff Training and Development: We will provide targeted training for our finance and grants administration staff to ensure they are well-versed in the updated procedures and reconciliation processes. This will help in maintaining the accuracy and integrity of our financial records. Cross-training programs will be implemented to ensure continuity and coverage during staff absences or turnover. Monitoring and Continuous Improvement: A robust monitoring system will be established to continuously assess the performance of our internal controls and reconciliation processes. Regular internal reviews will be conducted to ensure compliance and identify areas for further improvement. We will establish clear timelines and reporting methodologies to facilitate ongoing monitoring and timely detection and correction of errors and misstatements. We are confident that these actions will address the material weakness and significantly enhance our financial reporting processes.

Categories

Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 480133 2023-003
    Material Weakness
  • 480134 2023-002
    Material Weakness
  • 480135 2023-003
    Material Weakness
  • 480136 2023-002
    Material Weakness
  • 480137 2023-003
    Material Weakness
  • 1056574 2023-002
    Material Weakness
  • 1056575 2023-003
    Material Weakness
  • 1056576 2023-002
    Material Weakness
  • 1056577 2023-003
    Material Weakness
  • 1056578 2023-002
    Material Weakness
  • 1056579 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $209,553
84.367 Improving Teacher Quality State Grants $73,020
10.555 National School Lunch Program $66,400
10.553 School Breakfast Program $55,919
84.424 Student Support and Academic Enrichment Program $39,495
84.425 Education Stabilization Fund $1,586
84.027 Special Education_grants to States $712
84.173 Special Education_preschool Grants $93