Finding 51770 (2022-003)

Material Weakness
Requirement
C
Questioned Costs
-
Year
2022
Accepted
2023-01-03

AI Summary

  • Core Issue: The District over-reported expenditures by $54,010 due to a lack of proper internal controls in the reimbursement process.
  • Impacted Requirements: Reimbursement requests must be supported by cumulative general ledger reports to ensure accuracy.
  • Recommended Follow-Up: The CFO should review all grant reimbursements against the general ledger and ensure necessary accruals or deferrals are made during year-end closing.

Finding Text

Criteria - The District's internal control over financial reporting should ensure that reimbursement requests are supported by cumulative general ledger reports. Condition - The District's reporting process duplicated certain costs and over-reported expenditures by $54,010 on the final claim request made for the year ended August 31, 2022. Cause - The District had staff turnover within the business office that affected the reporting process. A cumulative general ledger report was not utilized to match up to the claim reimbursement request. Effect - The reimbursement grant reported an excess of revenues over expenditures of $34,059 after deduction of an additional $19,951 of expenditures incurred subsequent to the last expenditure reimbursement request for the year. A net audit adjustment of $34,059 was proposed to balance revenues with expenditures for the fiscal year ended August 31, 2022. Recommendation - We recommend that the CFO review all grant reimbursements and compare to cumulative general ledger reports. Furthermore, as part of the year end close out process, the CFO should ensure that any accruals, or deferrals, of revenue necessary to balance revenues with expenditures are posted. Views of Responsible Officials and Planned Corrective Actions - Refer to the Corrective Action Plan prepared by District's management.

Corrective Action Plan

Millsap ISD will implement a system of internal controls to mitigate the possibility of claim duplication for all federal funding sources. The following are the steps Millsap ISD will implement. ? The CFO will keep track of expenses in all federal funds and will submit for reimbursement every quarter. ? Prior to requesting reimbursement, the CFO will print a year-to-date report from Ascender demonstrating quarterly expenses minus prior reimbursements. ? The total expense report, utilized to verify request for reimbursement, will be confirmed by the CFO and Assistant Superintendent with signatures, dates, and times. ? Upon verification, the CFO will request federal reimbursement. ? After receiving and posting requested funds, the CFO will compare expense and income on the as of date to confirm that more income than expenses have not been submitted for reimbursement.

Categories

Cash Management Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 51766 2022-002
    Material Weakness
  • 51767 2022-002
    Material Weakness
  • 51768 2022-002
    Material Weakness
  • 51769 2022-002
    Material Weakness
  • 51771 2022-003
    Material Weakness
  • 628208 2022-002
    Material Weakness
  • 628209 2022-002
    Material Weakness
  • 628210 2022-002
    Material Weakness
  • 628211 2022-002
    Material Weakness
  • 628212 2022-003
    Material Weakness
  • 628213 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program $585,426
10.553 School Breakfast Program $119,727
84.010 Title I Grants to Local Educational Agencies $116,883
84.425 Education Stabilization Fund $101,173
84.367 Improving Teacher Quality State Grants $11,261
93.778 Medical Assistance Program $2,768
10.649 Pandemic Ebt Administrative Costs $614