Finding 403100 (2023-002)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2023
Accepted
2024-06-26

AI Summary

  • Core Issue: The District lacks effective internal controls over payroll for federal grants, leading to potential unallowable costs.
  • Impacted Requirements: Noncompliance with federal regulations regarding allowable costs and activities, specifically 2 CFR Part 200.303.
  • Recommended Follow-Up: Implement strict payroll procedures to ensure documentation supports federal program costs, including maintaining approved wage agreements and conducting regular pay rate reviews.

Finding Text

Repeat Finding: No Program Names/Assistance Listing Titles: Title I Grants to Local Educational Agencies; Special Education Cluster; COVID‐19 Education Stabilization Fund Assistance Listing Numbers: 84.010; 84.027; 84.027X; 84.425U Federal Award Numbers: S010A220003; H027A220007; H027X210007; S425U210038 Questioned Costs: 13,548; 22,644; 30,704 Federal Agency: U.S. Department of Education Pass‐Through Agency: Arizona Department of Education Type of Finding: Noncompliance, Material Weakness Compliance Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Criteria In accordance with 2 CFR Part 200.303, the District is responsible for establishing and maintaining 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. Condition The District did not maintain effective internal control over activities allowed or unallowed and allowable costs/cost principles for several grants. Cause The District did not establish adequate controls over the preparation and/or retention of employee pay agreements. Effect The District did not have sufficient documentation to support the rate of pay for 13 employees paid from federal funds, and may have charged unallowable costs to the programs. Context During our review of payroll records, we noted the following: - For two of ten Title I employees reviewed, the rates of pay established in the payroll software were in excess of the approved contracts on file. The questioned cost of $13,548 represents the total excess amount paid to the two employees for the entire fiscal year. - For three of ten Special Education employees reviewed, the rates of pay established in the payroll software were in excess of the approved contracts on file. Additionally, for one of ten Special Education employees reviewed, the District could not locate an approved contract. The questioned cost of $22,644 represents the total excess amount paid to the four employees for the entire fiscal year. - For five of 20 Education Stabilization employees reviewed, the rates of pay established in the payroll software were in excess of the approved contracts on file. Additionally, for two of 20 Education Stabilization employees reviewed, the District could not locate approved contracts. The questioned cost of $30,704 represents the total excess amount paid to the seven employees for the entire fiscal year. The projected questioned costs for the Special Education Cluster could be in excess of $25,000. The sample was not intended to be, and was not, a statistically valid sample. Recommendation The District should implement and enforce payroll procedures that ensure documentation is maintained which supports costs charged to federal programs. These procedures should include maintaining official, Board‐approved wage agreements for all employees, and implementing additional reviews of pay rates entered into the payroll software. Views of Responsible Officials See Corrective Action Plan.

Corrective Action Plan

Finding Number: 2023‐002 Assistance Listing Numbers: 84.010; 84.027; 84.027X; 84.425U Program Names/Assistance Listing Titles: Title I Grants to Local Educational Agencies; Special Education Cluster; COVID‐19 Education Stabilization Fund Contact Person: Glenda Cole, Human Resources Director Anticipated Completion Date: May 30, 2025 Planned Corrective Action: It has been noted that several of the concerns associated with lack of appropriate payroll procedures occurred due to lack of clear communication with HR regarding rates of pay for new and continuing employees. Therefore, procedures have been put in place to address these issues to ensure an effective, transparent process. The following procedures are in place (or are being implemented) to improve performance in the HR/Payroll Department: I. Position Changes for Employees During the School Year: Position Changes for an employee during the school year will be addressed in the following manner: a. The governing board will continue to receive a personnel recommendation form that includes: i. Employee name ii. Position details (such as rate of pay, position title, control code‐if the position is a replacement.) iii. Site relocation (if applicable) iv. Reason for the position change v. Effective date of the change b. Agreements/Contracts will be issued to staff members for their signature. c. Payroll receives the personnel document after board approval. If the position change for the employee is a replacement, payroll uses the control assigned by HR. If the position change is a new position, Finance assigns the control code and sends to HR. II. Agreements/Contracts for Staff Members: a. Agreements/contracts will be created for each staff member to obtain staff member signature after board approval. b. Agreements will be placed in the staff members’ files. c. Agreements will include: i. Employee name ii. New position/title iii. Site relocation (if applicable), iv. Rate of pay v. Effective date. vi. Employee signature and date d. Tracking of these agreements will occur using onboarding and transfer agreement spreadsheets. III. Communications a. Payroll and HR staff will meet weekly to clarify hiring/payroll issues as they arise. b. A documented flow of information; forms initiated by HR will be shared with payroll to ensure clarity of intent. IV. Flexibility and Amendments: a. As the process continues, certain points will be amended or adjusted to improve the efficiency of tracking employee status changes. V. Training a. HR and Payroll Staff received training last year regarding the use of HR and payroll software and will receive updated training in the 2024‐2025 school year. The District will reimplement (it had been used prior to 2022, but was discontinued) a more thorough use of payroll software in spring of 2025 to increase efficiency and accuracy. b. We will hire a consultant to work with staff for the 2024‐25 school year to ensure more transparent and efficient practice of tracking employee status changes in the District.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 403098 2023-001
    Significant Deficiency
  • 403099 2023-001
    Significant Deficiency
  • 403101 2023-002
    Material Weakness
  • 403102 2023-002
    Material Weakness
  • 403103 2023-002
    Material Weakness
  • 979540 2023-001
    Significant Deficiency
  • 979541 2023-001
    Significant Deficiency
  • 979542 2023-002
    Material Weakness
  • 979543 2023-002
    Material Weakness
  • 979544 2023-002
    Material Weakness
  • 979545 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 Education Stabilization Fund $1.90M
84.010 Title I Grants to Local Educational Agencies $1.08M
84.027 Special Education_grants to States $837,974
10.555 National School Lunch Program $812,163
10.559 Summer Food Service Program for Children $655,880
84.048 Career and Technical Education -- Basic Grants to States $359,018
84.041 Impact Aid $153,426
84.367 Supporting Effective Instruction State Grants $142,324
12.U01 Rotc $138,318
84.027 Covid-19 Special Education_grants to States $117,854
10.553 School Breakfast Program $103,454
84.424 Student Support and Academic Enrichment Program $45,982
84.365 English Language Acquisition State Grants $27,249
84.060 Indian Education_grants to Local Educational Agencies $24,800
93.778 Medical Assistance Program $12,525
10.665 Schools and Roads - Grants to States $441
84.011 Migrant Education_state Grant Program $250