Finding 1155634 (2024-005)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-09-26

AI Summary

  • Core Issue: Personnel activity reports and periodic certifications were not completed for employees charged to federal awards, violating federal cost principles.
  • Impacted Requirements: Lack of documentation increases the risk of improper reimbursement requests, as required by 2 CFR 200.430.
  • Recommended Follow-Up: Ensure timely completion of semi-annual certifications for 100% federal award allocations and monthly reports for multiple allocations to maintain compliance.

Finding Text

Criteria: Federal cost principles, as identified in 2 CFR 200.430, require salaries allocated to more than one federal award activity or cost objective to be supported by records which accurately reflect the distribution of salary or wages. Budget estimates determined before the services are performed do not qualify as support for charges to the federal awards. Personnel activity reports are required when time is allocated between federal awards and cost objectives. Periodic certifications are required when an individual’s salary is charged solely to one federal award or cost objective. Condition: During our testing of compliance with the federal program, we noted that personnel activity reports to document time and effort were not completed for individuals whose salaries were allocated to one single federal award activity and the District’s General Fund. Additionally, individuals charged solely to one federal award activity and cost objective did not complete periodic certifications. Questioned costs: None. Context: Of the District’s payroll charges related to the major programs during fiscal year 2024, we haphazardly selected 31 individual charges from the bi-weekly payroll periods. All employees charged to the grants were selected for testing at least once with the sample representing $91,454 of $547,102 in payroll related charges. During the examination of charges, we noted two instances where an individual who is charged 30% to the Special Education Cluster (IDEA and Preschool) and 70% to the District’s General Fund, did not have a monthly personnel activity report completed and one instance where an individual was charged 100% to the IDEA federal program did not have a semi-annual certification completed. Effect or potential effect: Failure to adequately document personnel activity in accordance with the requirements of the Code of Federal Regulations increases the risk that the District will request reimbursement for expenditures which were not related to employee time spent on the federal awards. Cause: For periodic certifications of time and effort, the District’s grant manager prepared the periodic certification forms for distribution to the employees. The certifications were not returned by the employees in the instances noted above. Recommendation: We recommend whenever an employee’s salary is allocated 100% to a federal award and single cost objective the District prepare, at a minimum, semi-annual certifications of time and effort. Additionally, when an employee’s salary is allocated to multiple federal awards or cost objectives the District should complete, at a minimum, monthly personnel activity reports showing the distribution of the employee’s time and effort. Any changes from the initial budgeted amounts written into the federal awards and actual time and effort as documented in the personnel activity reports must be adjusted such that the final amount charged to the federal award is accurate, allowable, and properly allocated. Views of responsible officials: The Business Office is providing continued training to cost center managers. Throughout the summer we have had the Finance Manager training the Community Education administrative team and responsible grant managers to ensure compliance with the time and effort requirements.

Categories

Allowable Costs / Cost Principles Cash Management HUD Housing Programs

Other Findings in this Audit

  • 1155635 2024-005
    Material Weakness Repeat
  • 1155636 2024-005
    Material Weakness Repeat
  • 1155637 2024-005
    Material Weakness Repeat
  • 1155638 2024-005
    Material Weakness Repeat
  • 1155639 2024-004
    Material Weakness Repeat
  • 1155640 2024-004
    Material Weakness Repeat
  • 1155641 2024-004
    Material Weakness Repeat
  • 1155642 2024-004
    Material Weakness Repeat
  • 1155643 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.027 Special Education Grants to States $674,185
84.010 Title I Grants to Local Educational Agencies $623,452
10.553 School Breakfast Program $224,846
10.582 Fresh Fruit and Vegetable Program $84,606
84.358 Rural Education $52,645
84.048 Career and Technical Education -- Basic Grants to States $48,892
10.555 National School Lunch Program $37,003
84.173 Special Education Preschool Grants $15,229
84.425 Education Stabilization Fund $9,763
84.424 Student Support and Academic Enrichment Program $9,595
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $8,828
84.002 Adult Education - Basic Grants to States $195