Finding 1170586 (2024-008)

Material Weakness Repeat Finding
Requirement
G
Questioned Costs
-
Year
2024
Accepted
2026-01-26

AI Summary

  • Core Issue: The School Corporation lacks effective internal controls, leading to non-compliance with federal grant requirements related to earmarking and level of effort.
  • Impacted Requirements: Issues include failure to verify nonpublic expenditures, improper classification of funds, and lack of supporting documentation for disbursements.
  • Recommended Follow-Up: Establish a robust internal control system to ensure compliance, maintain proper documentation, and conduct regular audits to prevent future findings.

Finding Text

FINDING 2024-008 Subject: Special Education Cluster (IDEA) - Earmarking and Level of Effort Federal Agency: Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States, Special Education Preschool Grants Assistance Listings Numbers: 84.027, 84.027X, 84.173 Federal Award Numbers and Years (or Other Identifying Numbers): 21611-045-PN01, 22611-045-PN01, 22611-045-ARP, 22619-045-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-008. Condition and Context An effective internal control system was not in place at the School Corporation to ensure compliance with requirements related to the grant agreement and the earmarking requirements of the Matching, Level of Effort, Earmarking compliance requirement. INDIANA STATE BOARD OF ACCOUNTS 31 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Earmarking The nonpublic proportionate share of expenditures for the 21611-045-PN01, 22611-045-PN01, 22611-045-ARP, and 22619-045-PN01 grant awards could not be verified for proper classification and do not meet the proportionate share requirement. In addition, 22611-045-PN01, 22611-045-ARP, and 22619-045-PN01 could not be verified as having any nonpublic expenses. The funds associated with these grants were, in some cases, comingled and/or overspent with multiple grant years and not adjusted properly. These errors were not corrected during the audit period. The nonpublic proportionate share of expenditures was determined by applying a percentage to the nonpublic school budgeted expenditures. These were the amounts reported to the Indiana Department of Education (IDOE). As such, we were unable to identify if the minimum amount per grant award was expended and properly reported to the IDOE as required. Level of Effort - Maintenance of Effort Maintenance of effort is a district-level test that determines whether the School Corporation is providing a consistent level of financial support to public schools from year-to-year. This rule ensures that the School Corporation does not use Special Education funds to shore up reductions in state and local support for public education. The IDOE performs the maintenance of effort calculation utilizing Form 9 information provided by the School Corporation from the prior year. As such, the amounts submitted to the IDOE in the prior year to be used in the computation are tested to ensure they were recorded properly in the School Corporation's records as to the account and object code. In fiscal years 2021-2022 and 2022-2023, 60 transactions were tested each year to ensure the disbursements were posted to the proper account and object code. For 30 of the 60 transactions selected in 2021-2022, as well as 47 of the 60 transactions selected in 2022-2023, appropriate supporting documentation was not provided for audit. As a result, 77 disbursements could not be verified as to whether they were posted to the proper account or object code. In addition, 60 disbursement line items were sampled from the IDOE Form 9 for both 2021-2022 and 2022-2023, to ensure the amounts agreed to the ledger. A total of 21 of the 60 disbursement line items in 2021-2022 and 2 of the 60 disbursement line items in 2022-2023 could not be traced to the ledger. Therefore, we were unable to determine if the disbursements for 23 disbursement line items were posted to the proper account or object code. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 32 NORTH LAWRENCE COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: . . . (g) Be adequately documented. . . ." 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of the nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause Due to turnover of staffing in both the Special Education personnel and the School Corporation's administrative office and recordkeeping issues, the School Corporation's management had not developed a system of internal controls that would have ensured compliance, or that supporting documentation would have been maintained and made available for audit, as related to the Matching, Level of Effort, Earmarking compliance requirement. Effect Without the proper implementation of an effectively designed system of internal controls, the School Corporation cannot ensure compliance with the level of effort - maintenance of effort and earmarking requirements. As a result, amounts reported to the oversight agency were not accurately reported. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure nonpublic proportionate share funds are appropriately allocated to the individual school based on expenses charged directly on behalf of that school. Supporting documentation for these expenses should be retained for audit. In addition, proper recordkeeping should be maintained to ensure compliance with the level of effort - maintenance of effort and earmarking requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2024-008 Finding Subject: Special Education Cluster (IDEA) – Earmarking and Level of Effort Contact Person Responsible for Corrective Action: Susie Swango, Director of Special Education Contact Phone Number and Email Address: swangos@nlcs.k12.in.us (812) 277-3220 ext. 16243 Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Earmarking- The Non-Public Proportionate Share of expenditures The school district will document all non-public proportionate share expenditures to ensure that Earmarking compliance requirements are consistently met. Time and Effort Logs are kept for employees to document the proportionate share time paid for with Federal Special Education Grant Funds. Level of Effort – Maintenance of Effort- The school corporation will properly document all Special Education expenditures from accounts payable vouchers to payroll and fringe benefits. This documentation will ensure that we can calculate and substantiate our maintenance of effort required amounts. Anticipated Completion Date: June 30, 2026

Categories

Matching / Level of Effort / Earmarking Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1170559 2024-003
    Material Weakness Repeat
  • 1170560 2024-003
    Material Weakness Repeat
  • 1170561 2024-003
    Material Weakness Repeat
  • 1170562 2024-003
    Material Weakness Repeat
  • 1170563 2024-003
    Material Weakness Repeat
  • 1170564 2024-004
    Material Weakness Repeat
  • 1170565 2024-004
    Material Weakness Repeat
  • 1170566 2024-004
    Material Weakness Repeat
  • 1170567 2024-004
    Material Weakness Repeat
  • 1170568 2024-004
    Material Weakness Repeat
  • 1170569 2024-005
    Material Weakness Repeat
  • 1170570 2024-005
    Material Weakness Repeat
  • 1170571 2024-006
    Material Weakness Repeat
  • 1170572 2024-006
    Material Weakness Repeat
  • 1170573 2024-006
    Material Weakness Repeat
  • 1170574 2024-006
    Material Weakness Repeat
  • 1170575 2024-006
    Material Weakness Repeat
  • 1170576 2024-006
    Material Weakness Repeat
  • 1170577 2024-007
    Material Weakness Repeat
  • 1170578 2024-007
    Material Weakness Repeat
  • 1170579 2024-007
    Material Weakness Repeat
  • 1170580 2024-007
    Material Weakness Repeat
  • 1170581 2024-007
    Material Weakness Repeat
  • 1170582 2024-007
    Material Weakness Repeat
  • 1170583 2024-008
    Material Weakness Repeat
  • 1170584 2024-008
    Material Weakness Repeat
  • 1170585 2024-008
    Material Weakness Repeat
  • 1170587 2024-009
    Material Weakness Repeat
  • 1170588 2024-009
    Material Weakness Repeat
  • 1170589 2024-009
    Material Weakness Repeat
  • 1170590 2024-009
    Material Weakness Repeat
  • 1170591 2024-009
    Material Weakness Repeat
  • 1170592 2024-009
    Material Weakness Repeat
  • 1170593 2024-010
    Material Weakness Repeat
  • 1170594 2024-010
    Material Weakness Repeat
  • 1170595 2024-010
    Material Weakness Repeat
  • 1170596 2024-010
    Material Weakness Repeat
  • 1170597 2024-010
    Material Weakness Repeat
  • 1170598 2024-010
    Material Weakness Repeat
  • 1170599 2024-011
    Material Weakness Repeat
  • 1170600 2024-011
    Material Weakness Repeat
  • 1170601 2024-012
    Material Weakness Repeat
  • 1170602 2024-012
    Material Weakness Repeat
  • 1170603 2024-013
    Material Weakness Repeat
  • 1170604 2024-013
    Material Weakness Repeat
  • 1170605 2024-014
    Material Weakness Repeat
  • 1170606 2024-014
    Material Weakness Repeat
  • 1170607 2024-015
    Material Weakness Repeat
  • 1170608 2024-015
    Material Weakness Repeat
  • 1170609 2024-016
    Material Weakness Repeat
  • 1170610 2024-016
    Material Weakness Repeat
  • 1170611 2024-017
    Material Weakness Repeat
  • 1170612 2024-017
    Material Weakness Repeat
  • 1170613 2024-016
    Material Weakness Repeat
  • 1170614 2024-017
    Material Weakness Repeat
  • 1170615 2024-015
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 EDUCATION STABILIZATION FUND 2024 $2.13M
10.555 NATIONAL SCHOOL LUNCH PROGRAM 2024 $1.57M
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES 2023 $1.56M
10.555 NATIONAL SCHOOL LUNCH PROGRAM 2023 $1.54M
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES 2024 $773,796
10.553 SCHOOL BREAKFAST PROGRAM 2024 $431,115
10.553 SCHOOL BREAKFAST PROGRAM 2023 $308,526
84.027 SPECIAL EDUCATION GRANTS TO STATES 2024 $251,992
84.027 SPECIAL EDUCATION GRANTS TO STATES 2023 $224,792
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) 2023 $216,855
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES 2023 $211,066
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES 2024 $150,912
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM 2023 $79,990
93.778 MEDICAL ASSISTANCE PROGRAM 2023 $77,387
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN 2024 $59,430
93.778 MEDICAL ASSISTANCE PROGRAM 2024 $59,225
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM 2024 $50,168
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) 2024 $28,088
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS 2024 $18,810
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS 2023 $12,965
84.425 EDUCATION STABILIZATION FUND 2023 $8,676
10.649 PANDEMIC EBT ADMINISTRATIVE COSTS 2023 $3,135