Finding 964149 (2023-004)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-03-28

AI Summary

  • Core Issue: Internal controls for grant management were ineffective, preventing accurate tracking of Federal payroll expenditures.
  • Impacted Requirements: The lack of proper coding for payroll expenditures hindered compliance with Federal grant management standards.
  • Recommended Follow-Up: Review and enhance internal controls to ensure proper coding and reporting of expenditures, with a target resolution date of June 30, 2024.

Finding Text

Part III - FEDERAL AWARD FINDINGS AND QUESTIONED COSTS SECTION Federal Agency - United States Department of Education Federal Programs - Title I Grants to Local Educational Agencies - (84.010), COVID-19 Education Stabilization Fund - (84.425C/84.425D/84.425U/84.425W), Supporting Effective Instruction State Grants (84.367) Federal Award Years - 2021, 2022, 2023 State Agency - New York State Department of Education Reference - 2023-004 Payroll Reconciliation - Material Weakness Criteria - Proper functioning internal controls would result in the District having control procedures in place for grant management. Condition - The internal controls over the overall grant management were not operating properly. As a result, we were unable to obtain a complete population of the Federal expenditures that were claimed as part of the Federal programs. Cause - There were no controls in place to allow the proper coding of payroll expenditures to reflect the Federal funds that were incurred and therefore a complete population of payroll expenditures was unable to be determined. Effect of Condition - The District was unable to provide a complete listing of Federal payroll expenditures generated by their general ledger system to serve as the complete population to audit the Federal payroll expenditures being claimed under the the three funds above. Recommendation - The District's internal control system over grant management related to the Federal Awards should be reviewed and modified to allow for proper management of grants and coding of expenditures which will lead to accurate report generation. Questioned Costs - None. Perspective - It is likely that this issue is pervasive to other Federal programs as all three Federal programs tested had the issue. View of Responsible Officials and Planned Corrective Actions - (a) Comments on the finding and recommendation: The District agrees with the finding. The District also agrees with the recommendation. See below for actions taken. (b) Actions Taken: Management will create internal controls over grant management to allow for proper coding of expenditures in order to have accurate report generation. (c) Anticipated Completion Date: Management anticipates this finding will be resolved by June 30, 2024.

Categories

Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 387702 2023-004
    Material Weakness
  • 387703 2023-004
    Material Weakness
  • 387704 2023-004
    Material Weakness
  • 387705 2023-004
    Material Weakness
  • 387706 2023-004
    Material Weakness
  • 387707 2023-004
    Material Weakness
  • 387708 2023-004
    Material Weakness
  • 387709 2023-004
    Material Weakness
  • 387710 2023-004
    Material Weakness
  • 387711 2023-004
    Material Weakness
  • 387712 2023-004
    Material Weakness
  • 387713 2023-004
    Material Weakness
  • 387714 2023-004
    Material Weakness
  • 387715 2023-004
    Material Weakness
  • 964144 2023-004
    Material Weakness
  • 964145 2023-004
    Material Weakness
  • 964146 2023-004
    Material Weakness
  • 964147 2023-004
    Material Weakness
  • 964148 2023-004
    Material Weakness
  • 964150 2023-004
    Material Weakness
  • 964151 2023-004
    Material Weakness
  • 964152 2023-004
    Material Weakness
  • 964153 2023-004
    Material Weakness
  • 964154 2023-004
    Material Weakness
  • 964155 2023-004
    Material Weakness
  • 964156 2023-004
    Material Weakness
  • 964157 2023-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund - Coronavirus Response and Relief Supplemental Appropriations $32.60M
84.425 Education Stabilization Fund - American Rescue Plan $22.81M
84.027 Special Education_grants to States $7.34M
10.553 School Breakfast Program $2.08M
84.367 Improving Teacher Quality State Grants $1.94M
84.424 Student Support and Academic Enrichment Program $1.36M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.14M
84.425 Education Stabilization Fund - Covid-19 $828,899
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $734,362
32.009 Emergency Connectivity Fund Program $698,387
10.555 National School Lunch Program $451,091
10.559 Summer Food Service Program for Children $259,785
84.365 English Language Acquisition State Grants $228,653
84.173 Special Education_preschool Grants $176,608
84.196 Education for Homeless Children and Youth $37,016
84.027 Arp - Special Education_grants to States $16,920
84.010 Title I Grants to Local Educational Agencies $7,549