Finding 1174277 (2025-001)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2025
Accepted
2026-02-19

AI Summary

  • Core Issue: SWWF lacks adequate procedures for allocating salaries of employees working on multiple programs, leading to inaccuracies in payroll charges.
  • Impacted Requirements: Compliance with federal guidelines for allowable costs, specifically §200.430, is compromised due to insufficient internal controls and inconsistent use of timesheets.
  • Recommended Follow-Up: Develop and implement written policies for salary allocation and provide training to ensure adherence to federal requirements.

Finding Text

Finding #2025-001 – Significant Deficiency and Other Noncompliance. Applicable federal program: U. S. Department of Education, Passed through Texas Education Agency, Special Education Cluster (IDEA), Assistance Listing #: 84.027A, 84.173A, Contract Numbers: H027A230008, H027A240008, H027A250008, H173A240004, H173A250004, Contract Years: 08/07/23 – 09/30/24, 08/22/24 – 09/30/25, 07/17/25 – 09/30/26. Criteria: Allowable costs – The Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, §200.430 requires that charges to awards for salaries and wages be based on records that accurately reflect the work performed. These records must 1) be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable and properly allocated; 2) reasonably reflect the total activity for which the employee is compensated; 3) comply with the established accounting policies and practices of the agency; and 4) support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one activity. SWWF’s procedures for allocating salaries of employees who work in more than one program are not sufficient to ensure that costs are appropriately allocated amongst federal and state funding streams. Condition and context: Of the sample of 25 payroll transactions tested (pay amount for an employee for a pay period) for the Special Education Cluster (IDEA), seven transactions were under-charged to the grant as compared to the timesheet, for a total of $1,001, and two transactions were over-charged for a total of $1,559. The net amount over-charged to the grant of the sample tested was $558. Cause: There are no written policies and procedures related to the process of allocating salaries for employees who work in more than one program. Timesheets which indicate actual estimated time and effort are not consistently used to allocate payroll costs to federal programs, but instead the allocation amounts are dictated by the budget as compared to cumulative costs. Effect: Payroll costs may not be properly charged to the benefitting federal, state, and other funding streams, resulting in a misstatement of federal expenditures. Questioned costs: $558. Recommendation: SWWF should establish written policies and procedures and provide training to its employees on the policies and procedures for allocating salaries in accordance with Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, §200.430. Views of responsible officials and planned corrective actions: Management agrees with the finding. See Corrective Action Plan.

Corrective Action Plan

Finding #2025-001 – Significant Deficiency and Other Noncompliance. Condition and context: Of the sample of 25 payroll transactions tested (pay amount for an employee for a pay period) for the Special Education Cluster (IDEA), seven transactions were under-charged to the grant as compared to the timesheet, for a total of $1,001, and two transactions were over-charged for a total of $1,559. The net amount over-charged to the grant of the sample tested was $558. Recommendation: SWWF should establish written policies and procedures and provide training to its employees on the policies and procedures for allocating salaries in accordance with Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, §200.430. Planned corrective action: Policy and procedures for the allocation of payroll costs to the appropriate program in accordance with Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, §200.430 will be drafted within the next 15 days. Training of all employees affected will be completed within 15 days of that. Monthly monitoring will be conducted by the Associate Superintendent of Federal Programs, and quarterly by the Chief Financial Officer, to ensure the plan is effective. The Director of Human Resources will ensure all parties are notified of new hires. Our corrective action plan includes: 1) Coverage Plan: We currently have a policy and procedure in place, and have the Associate Superintendent of Federal Grants and the HR Director overseeing the submission of required documents. PARs are submitted semiannually by single-funded personnel and monthly by multi-funded personnel. Once the Associate Superintendent of Federal Programs reviews PARs, WebSmart should be notified, via the ticketing system, if there is a need to update allocations. Note: During the final months of the fiscal year, the Director of the SE Co-op resigned, resulting in a brief lapse in review while training was underway. During the fiscal year, we had a Desk Review where the allocations did not necessarily match what was paid out. The auditor said that so long as the program did not overcharge the federal fund (which it did not), we could allocate to the other non-federal fund. The issue was not to overcharge the federal fund, which we did not. 2) Process Improvement: The notification to Websmart to update allocations will be added to the SWWF procedures. Training is completed within 10 days of the procedure updates. Training will occur before their first payroll, for new employees, by the Associate Superintendent of Federal Programs. 3) Monitoring & Review: In addition to the Associate Superintendent of Federal Programs’ monthly review, the Chief Financial Officer will review allocations quarterly to ensure accuracy. 4) Communication Plan: All employees involved in Time and Effort reporting will be provided with the updated procedures by the Associate Superintendent of Federal Programs. The Director of Human Resources will ensure all appropriate personnel are notified when a new employee begins. Responsible officer: Judyjane Witte, Chief Financial Officer. Estimated completion date: January 31, 2026.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1174276 2025-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.027 SPECIAL EDUCATION GRANTS TO STATES $2.19M
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $582,379
10.555 NATIONAL SCHOOL LUNCH PROGRAM $251,435
10.553 SCHOOL BREAKFAST PROGRAM $60,534
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $45,023
84.425 EDUCATION STABILIZATION FUND $35,540
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $31,176
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $12,920
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $11,458
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $10,552
84.011 MIGRANT EDUCATION STATE GRANT PROGRAM $1,840
84.196 EDUCATION FOR HOMELESS CHILDREN AND YOUTH $490