Finding 366752 (2022-003)

Material Weakness
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2024-02-09

AI Summary

  • Core Issue: The School Corporation failed to maintain proper documentation for payroll expenses charged to Title I grant funds, leading to questioned costs of $203,488.
  • Impacted Requirements: Noncompliance with federal regulations on allowable costs and internal controls, specifically 2 CFR 200.303 and 200.403, which require adequate documentation and effective internal controls.
  • Recommended Follow-Up: Management should implement a robust internal control system and establish clear policies and procedures to ensure all contracts and supporting documentation are properly archived and accessible.

Finding Text

FINDING 2022-003 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): S010A190014 FY2021, S010A200014 FY2021 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Allowable Costs/Cost Principles Audit Findings: Material Weakness, Modified Opinion 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 for 10 of 15 employees tested, as the contracts were not properly archived in the financial software used to electronically approve and archive employment contracts. As such, we could not verify the employees were paid their contracted rate for hours spent working on grant-related activities. This resulted in known questioned costs of $203,488. 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: (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 24 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 Federal awards that are renewed quarterly or annually, from the date of the 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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. INDIANA STATE BOARD OF ACCOUNTS 25 SOUTH BEND COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, not all employment contracts could be presented for audit nor could documentation be provided to support time charged to the grant. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. Questioned Costs There were known questioned costs of $203,488 as identified in Condition and Context. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure contracts and certifications, as appropriate, are retained to support the amounts paid from Title I program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. Auditor's Response The alternative documentation provided was a snapshot from the administrator side of the financial software system; however, the original source document, which was the contract that was approved by the employee, the Superintendent of Schools, and the President of the School Board, was not provided to substantiate the amounts in the administrator side of the financial software system. We reaffirm our finding and will review the status of the finding during our next audit.

Corrective Action Plan

FINDING 2022-003 Finding Subject: Title I Grants to Local Educational Agencies - Allowable Costs/Cost Principles Summary of Finding: Finding: Documentation for 10 employees was not available to verify the contract amounts. Recommendation: Documents be retained to support amounts paid. Contact Person Responsible for Corrective Action: Kareemah Fowler, Assistant Superintendent of Business and Finance Contact Phone Number and Email Address: (574) 393-6088; kfowler@sbcsc.k12.in.us Views of Responsible Officials: We disagree with the finding. Explanation and Reasons for Disagreement: While we agree that the single source document used by the State to validate a teacher’s contract was not available for 10 employees. We provided sufficient alternate documents that would allow the State to validate the contract's amount being paid, and whether the proper employees were paid from or should have been paid from the Title I funds. The documents provided sufficient data to support the questioned cost of $203,488 outlined in the finding. We will be working with our software vendor to rectify the glitch that prevented us from providing the documentation requested by the State for future audit. Description of Corrective Action Plan: We will be working with our software vendor to rectify the glitch that prevented us from providing the documentation requested by the State. Anticipated Completion Date: January 2024

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 366751 2022-002
    Material Weakness
  • 366753 2022-004
    Material Weakness
  • 366754 2022-005
    Material Weakness
  • 366755 2022-006
    Material Weakness
  • 366756 2022-007
    Material Weakness
  • 366757 2022-006
    Material Weakness
  • 366758 2022-007
    Material Weakness
  • 943193 2022-002
    Material Weakness
  • 943194 2022-003
    Material Weakness
  • 943195 2022-004
    Material Weakness
  • 943196 2022-005
    Material Weakness
  • 943197 2022-006
    Material Weakness
  • 943198 2022-007
    Material Weakness
  • 943199 2022-006
    Material Weakness
  • 943200 2022-007
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.374 Teacher Incentive Fund $6.11M
84.010 Title I Grants to Local Educational Agencies $4.13M
10.559 Summer Food Service Program for Children $2.27M
10.553 School Breakfast Program $2.00M
84.027 Special Education_grants to States $1.50M
84.336 Teacher Quality Partnership Grants $1.26M
84.011 Migrant Education_state Grant Program $1.14M
84.184 Safe and Drug-Free Schools and Communities_national Programs $712,692
93.778 Medical Assistance Program $543,084
84.367 Improving Teacher Quality State Grants $466,510
84.425 Education Stabilization Fund $404,291
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs $397,667
84.048 Career and Technical Education -- Basic Grants to States $336,025
84.424 Student Support and Academic Enrichment Program $316,382
10.555 National School Lunch Program $294,289
84.002 Adult Education - Basic Grants to States $247,225
84.173 Special Education_preschool Grants $205,310
10.582 Fresh Fruit and Vegetable Program $166,413
84.365 English Language Acquisition State Grants $124,736
84.377 School Improvement Grants $107,067
16.839 Stop School Violence $67,553
84.215 Fund for the Improvement of Education $45,750
21.019 Coronavirus Relief Fund $22,380
10.558 Child and Adult Care Food Program $6,253
10.649 Pandemic Ebt Administrative Costs $5,814
93.575 Child Care and Development Block Grant $1,252