Finding 393390 (2023-001)

Material Weakness
Requirement
A
Questioned Costs
-
Year
2023
Accepted
2024-04-16

AI Summary

  • Core Issue: The District lacks documentation for employee wages charged to Education Stabilization Fund grants, leading to a material weakness in internal control.
  • Impacted Requirements: Noncompliance with 2 CFR 200.430, which mandates accurate records for salary and wage charges to federal awards.
  • Recommended Follow-Up: Establish internal controls to ensure proper documentation and support for journal entries related to wage allocations.

Finding Text

Finding 2023-001 – ACTIVITIES ALLOWED OR UNALLOWED and ALLOWABLE COSTS/COST PRINCIPLES Type: Material Weakness in Internal Control / Noncompliance Program: COVID 19 Education Stabilization Fund (ALN 84.425D – ESSER II Formula, ESSER II Section 98c Learning Loss, ALN 84.425U – ESSER III Formula) Condition: The District was unable to provide documentation that identified wages, by employee, that were charged to Education Stabilization Fund grants. Criteria: As detailed in 2 CFR 200.430, charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must, “Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable and properly allocated.” Cause: Management failed to maintain adequate documentation of wages and related fringe benefit allocations. Effect: Approximately $1,340,000 of expenses charged to Education Stabilization Fund were not able to be tested/substantiated. Context: Wages and the related fringe benefits were allocated to Education Stabilization Fund grants through a series of journal entries rather than the typical process of allocating wages via the payroll system based on hours each employee spent in each function or cost center. Documentation of how the journal entries were prepared was not maintained. Consequently, wages and the related fringe benefits allocated via journal entries could not be reconciled to payroll records. Recommendation: We recommend that the District establish internal controls to ensure that appropriate support for journal entries is developed and maintained. Management’s Resp: We are in agreement with this finding.

Corrective Action Plan

Finding 2023-001 - Corrective Action Plan CHSD - 2022-2023 Audit Findings Finding 2023-001 - ACTIVITIES ALLOWED OR UNALLOWED / ALLOWABLE COSTS/COST PRINCIPLES Type: Material Weakness in Internal Control / Noncompliance Program: COVID 19 Education Stabilization Fund (ALN 84.425D – ESSER II Formula, ESSER II Section 98c Learning Loss, ALN 84.425U – ESSER III Formula) Condition: The District was unable to provide documentation that identified wages, by employee, that were charged to Education Stabilization Fund grants. Corrective action to be taken: Payroll transactions will be recorded at the most granular level to ensure accuracy and transparency in the resulting outcomes. The issue at hand was a result of an overarching labor transfer at the top level of the labor expense accounts. The errant transfer neglected to properly align the underlying transactions, at the employee weekly payroll level, with the correlating expense totals being transferred between grants (i.e. each individual employee expense of the same General Ledger expense code structure comprising the total expense of the given General Ledger) and resulted in the disparity noted in the finding. Adherence to this corrective action will ensure strengthened internal control(s) and future grant compliance. Corrective action timeline: The corrective action is effective immediately and applicable to all stakeholders with data entry access to the CHSD financial accounting software platform. District leader responsible for Corrective Action Plan: The Finance Director will be responsible for ensuring compliance with this corrective action and work product of the Finance Director will have a similarly robust check and balance via transaction review and verification by a knowledgeable second source, normally the Account Payable Administrator or the Superintendent. Respectfully submitted, Marc Forrest, Director of Finance

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 393379 2023-004
    Significant Deficiency Repeat
  • 393380 2023-004
    Significant Deficiency Repeat
  • 393381 2023-004
    Significant Deficiency Repeat
  • 393382 2023-004
    Significant Deficiency Repeat
  • 393383 2023-004
    Significant Deficiency Repeat
  • 393384 2023-004
    Significant Deficiency Repeat
  • 393385 2023-004
    Significant Deficiency Repeat
  • 393386 2023-004
    Significant Deficiency Repeat
  • 393387 2023-004
    Significant Deficiency Repeat
  • 393388 2023-004
    Significant Deficiency Repeat
  • 393389 2023-004
    Significant Deficiency Repeat
  • 393391 2023-002
    Material Weakness
  • 393392 2023-003
    Significant Deficiency
  • 393393 2023-001
    Material Weakness
  • 393394 2023-001
    Material Weakness
  • 393395 2023-003
    Significant Deficiency
  • 969821 2023-004
    Significant Deficiency Repeat
  • 969822 2023-004
    Significant Deficiency Repeat
  • 969823 2023-004
    Significant Deficiency Repeat
  • 969824 2023-004
    Significant Deficiency Repeat
  • 969825 2023-004
    Significant Deficiency Repeat
  • 969826 2023-004
    Significant Deficiency Repeat
  • 969827 2023-004
    Significant Deficiency Repeat
  • 969828 2023-004
    Significant Deficiency Repeat
  • 969829 2023-004
    Significant Deficiency Repeat
  • 969830 2023-004
    Significant Deficiency Repeat
  • 969831 2023-004
    Significant Deficiency Repeat
  • 969832 2023-001
    Material Weakness
  • 969833 2023-002
    Material Weakness
  • 969834 2023-003
    Significant Deficiency
  • 969835 2023-001
    Material Weakness
  • 969836 2023-001
    Material Weakness
  • 969837 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $747,194
84.425 Education Stabilization Fund $331,010
10.553 School Breakfast Program $241,984
84.367 Improving Teacher Quality State Grants $139,374
84.424 Student Support and Academic Enrichment Program $42,432
84.060 Indian Education_grants to Local Educational Agencies $34,356
10.555 National School Lunch Program $20,782
93.778 Medical Assistance Program $9,443
10.649 Pandemic Ebt Administrative Costs $3,135
10.559 Summer Food Service Program for Children $2,462
84.027 Special Education_grants to States $2,045