Finding 977120 (2023-007)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-06-12

AI Summary

  • Core Issue: The District failed to maintain proper time certifications for employees charged to federal programs, specifically for 2 out of 60 tested under the ESEA (ESSA) program.
  • Impacted Requirements: This finding violates federal requirements for accurate time and effort reporting, leading to non-compliance with cost principles.
  • Recommended Follow-Up: Implement a system for semi-annual time certifications for single-funded employees and monthly for multi-funded employees to ensure compliance.

Finding Text

FINDING #2023-007: ALLOWABLE COSTS/COST PRINCIPLES – TIME AND EFFORT REPORTING (50000) Assistance Listing Number and Title: 84.010 ‐ ESEA (ESSA): Schoolwide Programs (SWP) Federal Grantor Name: U.S. Department of Education; Passed through California Department of Education Criteria: Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, requires an accounting for personnel time on multi‐funded positions by the time spent on each program and to semi‐annually certify positions charged 100% to federal programs. Standards for Documentation of Personnel Expenses Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: • Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; • Be incorporated into the official records of the non‐Federal entity • Reasonably reflect the total activity for which the employee is compensated by the non‐Federal entity, not exceeding 100% of compensated activities • Encompass both federally assisted and all other activities compensated by the non‐Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non‐Federal entity’s written policy; • Comply with the established accounting policies and practices of the non‐Federal entity. • 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. • Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards but may be used for interim accounting purposes. Condition: Auditor selected employees with salaries coded to the federal programs noted above. The following deficiencies were noted: • ESEA (ESSA): Schoolwide Programs (SWP) (Resource 3150): 2/60 employees tested with salaries coded to the program during the fiscal year did not have time certifications on file for the 2022-23 year. Cause: The District has not been following its policy for proper time accounting. Effect: The District is not in compliance. Questioned Costs: Although the District was not in compliance, we were able to review alternative documentation to determine that employees charged to the program were allowable. Repeat Finding: This is a repeat finding, see prior year finding #2022-008. Recommendation: We recommend that the District prepares time certification semi‐annually for single funded employees and monthly for multi-funded employees. Views of Responsible Officials: See Corrective Action Plan on following page.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 400674 2023-007
    Significant Deficiency Repeat
  • 400675 2023-007
    Significant Deficiency Repeat
  • 400676 2023-007
    Significant Deficiency Repeat
  • 400677 2023-007
    Significant Deficiency Repeat
  • 400678 2023-007
    Significant Deficiency Repeat
  • 977116 2023-007
    Significant Deficiency Repeat
  • 977117 2023-007
    Significant Deficiency Repeat
  • 977118 2023-007
    Significant Deficiency Repeat
  • 977119 2023-007
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
10.558 Child and Adult Care Food Program $6.20M
32.009 Emergency Connectivity Fund Program $5.91M
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $4.97M
10.553 School Breakfast Program $2.47M
84.365 English Language Acquisition State Grants $1.90M
84.367 Improving Teacher Quality State Grants $1.89M
84.027 Special Education_grants to States $1.65M
84.425 Education Stabilization Fund $1.62M
84.287 Twenty-First Century Community Learning Centers $1.61M
10.555 National School Lunch Program $1.18M
12.357 Rotc Language and Culture Training Grants $1.01M
84.424 Student Support and Academic Enrichment Program $666,352
84.411 Investing in Innovation (i3) Fund $637,752
84.048 Career and Technical Education -- Basic Grants to States $435,565
10.559 Summer Food Service Program for Children $359,907
93.079 Cooperative Agreements to Promote Adolescent Health Through School-Based Hiv/std Prevention and School-Based Surveillance $274,694
84.181 Special Education-Grants for Infants and Families $162,626
84.010 Title I Grants to Local Educational Agencies $161,409
93.U01 Cdc - Covid 19 Supplement $125,626
94.U02 Americorps Student Success Coach $84,836
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $76,731
47.070 Computer and Information Science and Engineering $42,718
84.011 Migrant Education_state Grant Program $37,852
84.060 Indian Education_grants to Local Educational Agencies $18,920
84.173 Special Education_preschool Grants $18,582