Finding 1179770 (2023-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2026-03-16

AI Summary

  • Core Issue: The School Corporation failed to provide adequate documentation for payroll expenses charged to Title I grant funds, resulting in questioned costs of $149,870.
  • Impacted Requirements: Noncompliance with federal regulations regarding allowable costs and internal controls, as outlined in 2 CFR 200.303, 200.334, and 200.403.
  • Recommended Follow-Up: Implement formal procedures to maintain and verify payroll documentation, including approved contracts and salary records, to ensure compliance and accuracy in future audits.

Finding Text

FINDING 2023-004 Subject: Title I Grants to Local Educational Agencies - Allowable Costs/Cost Principles Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A200014, S010A210014, S010A220014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Other Matters Repeat Findings This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context Costs charged to grant funds must be adequately documented. To adequately document payroll expenses charged to the grant fund, contracts or other documentation supporting the employees' approved rates of pay are necessary. The School Corporation utilized a financial software system that has two different sides, an employee portal side and an administrator side. Employee contracts are approved by the employee, the Superintendent of Schools, and the President of the School Board within the system on the employee portal side. Once approved, the data in the employee portal side is fed into a process in the administrator side. The School Corporation could not provide contracts or approved payroll rates for 6 out of 24 employees tested. As such, we could not verify the employees were paid its correct rates for hours spent working on grant related activities. This resulted in known questioned costs of $149,870. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 24 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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). . . ." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 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: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles. (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items. . . . (g) Be adequately documented. . . ." 2 CFR 200.430(i) states in part: "Standards for documentation of Personnel Expenses (1) Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities (for IHE, this per the IHE's definition of IBS); . . . (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. . . ." INDIANA STATE BOARD OF ACCOUNTS 25 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not maintain or provide adequate documentation to support payroll expenses charged to the grant fund. While employee contracts are approved within the financial software system, the process lacked sufficient oversight and record retention practices to ensure that approved pay rates were accessible and verifiable. Effect Without access to approved contracts or documentation verifying payroll rates for 6 of the 24 employees tested, the School Corporation could not demonstrate that payroll costs charged to the grant were accurate and allowable. This lack of documentation resulted in known questioned costs totaling $149,870. Additionally, the absence of reliable records increases the risk of noncompliance with federal grant requirements and necessitates expanded audit procedures, which will likely lead to higher audit costs. Questioned Costs Questioned costs in the amount of $149,870 were identified as described in the Condition and Context. Recommendation The School Corporation should establish and enforce formal documentation procedures to verify payroll rates for all employees whose compensation is charged to federal grants. This includes maintaining approved contracts, salary schedules, and supporting records that clearly demonstrate the accuracy and allowability of payroll costs. A review and approval process by a second knowledgeable party should be implemented to ensure compliance prior to submission. Additionally, the School Corporation should provide necessary support and resources for staff involved in payroll and grant management to strengthen recordkeeping practices. These measures will reduce the risk of noncompliance, minimize questioned costs, and help control future audit expenses. 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 2023-004 Finding Subject: Title I Grants to Local Educational Agencies - Allowable Costs/Cost Principles Contact Person Responsible for Corrective Action: Ahnaf Tahmid & Marlaina Johns Contact Phone Number and Email Address: 574-393-6000, atahmid@sbcsc.k12.in.us, mjohns2@sbcsc.k12.in.us Views of Responsible Officials: We concur with the finding Description of Corrective Action Plan: Human Resources worked with Regional Data Services to identify the cause of the issue and made corrections to prevent the data being lost on the administrative side moving forward. This involved updates to software stores and archives. Corrected Date 06/30/2025

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1179769 2023-003
    Material Weakness Repeat
  • 1179771 2023-005
    Material Weakness Repeat
  • 1179772 2023-006
    Material Weakness Repeat
  • 1179773 2023-007
    Material Weakness Repeat
  • 1179774 2023-008
    Material Weakness Repeat
  • 1179775 2023-008
    Material Weakness Repeat
  • 1179776 2023-008
    Material Weakness Repeat
  • 1179777 2023-008
    Material Weakness Repeat
  • 1179778 2023-008
    Material Weakness Repeat
  • 1179779 2023-009
    Material Weakness Repeat
  • 1179780 2023-009
    Material Weakness Repeat
  • 1179781 2023-009
    Material Weakness Repeat
  • 1179782 2023-009
    Material Weakness Repeat
  • 1179783 2023-009
    Material Weakness Repeat
  • 1179784 2023-010
    Material Weakness Repeat
  • 1179785 2023-010
    Material Weakness Repeat
  • 1179786 2023-010
    Material Weakness Repeat
  • 1179787 2023-010
    Material Weakness Repeat
  • 1179788 2023-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $10.48M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $10.30M
84.374 TEACHER AND SCHOOL LEADER INCENTIVE GRANTS (FORMERLY THE TEACHER INCENTIVE FUND) $6.41M
10.553 SCHOOL BREAKFAST PROGRAM $2.98M
84.334 GAINING EARLY AWARENESS AND READINESS FOR UNDERGRADUATE PROGRAMS $2.10M
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $1.59M
84.184 SCHOOL SAFELY NATIONAL ACTIVITIES $1.48M
84.336 TEACHER QUALITY PARTNERSHIP GRANTS $1.22M
84.215 INNOVATIVE APPROACHES TO LITERACY; PROMISE NEIGHBORHOODS; FULL-SERVICE COMMUNITY SCHOOLS; AND CONGRESSIONALLY DIRECTED SPENDING FOR ELEMENTARY AND SECONDARY EDUCATION COMMUNITY PROJECTS $915,979
84.027 SPECIAL EDUCATION GRANTS TO STATES $814,830
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $590,995
84.011 MIGRANT EDUCATION STATE GRANT PROGRAM $546,900
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $414,594
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $335,896
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $278,710
10.582 FRESH FRUIT AND VEGETABLE PROGRAM $251,519
84.002 ADULT EDUCATION - BASIC GRANTS TO STATES $129,188
93.778 MEDICAL ASSISTANCE PROGRAM $126,204
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $56,622
10.558 CHILD AND ADULT CARE FOOD PROGRAM $47,827
84.425 EDUCATION STABILIZATION FUND $16,979
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $12,080
10.649 PANDEMIC EBT ADMINISTRATIVE COSTS $5,950
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $2,129
93.079 COOPERATIVE AGREEMENTS TO PROMOTE ADOLESCENT HEALTH THROUGH SCHOOL-BASED HIV/STD PREVENTION AND SCHOOL-BASED SURVEILLANCE $1,050