Finding 372139 (2023-001)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2023
Accepted
2024-03-04
Audit: 293447
Auditor: Nigro & Nigro PC

AI Summary

  • Core Issue: The LEA did not provide adequate time and effort documentation to support salaries charged to federal funds, totaling $510,311.76.
  • Impacted Requirements: LEA failed to maintain records that meet federal criteria for accuracy, allocation, and integration of employee activities.
  • Recommended Follow-Up: No further action is needed as the County has resolved the issue with CDE and updated their time and effort policy.

Finding Text

Finding 2023-001: Time and Effort Requirements (50000) Assistance Listing No. 84.425 – Education Stabilization Funds (ESSER) U.S. Department of Treasury Passed through California Department of Education Criteria: To support salaries and wages for employees that work on federal programs, local educational agencies (LEAs) are required to maintain time and effort records that accurately reflect the work performed. These time and effort 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) be incorporated into the official records of the LEA; (3) reasonably reflect the total activity for which the employee is compensated by the LEA, not exceeding 100% of compensated activities; (4) encompass both federally assisted and all other activities compensated by the LEA on an integrated basis, but may include the use of subsidiary records as defined in the LEA’s written policy; (5) comply with the established accounting policies and practices of the LEA; and (6) 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 or percentages determined before the services are performed alone do not qualify as support for charges to Federal awards. Condition: The LEA failed to provide all the time and effort documentation that the California Department of Education (CDE) requested to support salaries and benefits charged to the Federal Stimulus funds. Cause: The LEA did not have sufficient time and effort procedures to ensure that their records were supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Specifically, the LEA’s procedures did not include controls to ensure that time and effort records include cost objectives, and account for the total activity for which the employee is compensated by the LEA as required by federal regulations. Effect: The LEA must upload into the CDE Monitoring Tool (CMT) documentation to support the $510,311.76 in salaries and benefits charged to ESSER II and ESSER III funds. Questioned Costs: The LEA did not provide documentation for $510,311.76 charged to ESSER programs. Specifically, the LEA failed to provide sufficient documentation to support $164,012.89 in salaries charged to ESSER II - Resource 3212 as well as $301,103.34 in salaries charged to ESSER III – Resource 3213. Context: The finding was the result of Federal Program Monitoring (FPM) procedures performed by the CDE. Auditors sampled 21 employees during the FPM audit. Recommendation: The County has already cleared this finding with CDE. No further action is needed. Views of Responsible Officials: The County has already cleared this finding with CDE. In addition, we have updated the new time and effort policy and offered training to agency-wide members.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Subrecipient Monitoring

Other Findings in this Audit

  • 372135 2023-001
    Material Weakness
  • 372136 2023-001
    Material Weakness
  • 372137 2023-001
    Material Weakness
  • 372138 2023-001
    Material Weakness
  • 372140 2023-001
    Material Weakness
  • 372141 2023-001
    Material Weakness
  • 372142 2023-001
    Material Weakness
  • 372143 2023-001
    Material Weakness
  • 372144 2023-001
    Material Weakness
  • 372145 2023-002
    Significant Deficiency
  • 372146 2023-002
    Significant Deficiency
  • 372147 2023-002
    Significant Deficiency
  • 372148 2023-002
    Significant Deficiency
  • 372149 2023-002
    Significant Deficiency
  • 372150 2023-002
    Significant Deficiency
  • 372151 2023-002
    Significant Deficiency
  • 372152 2023-002
    Significant Deficiency
  • 372153 2023-002
    Significant Deficiency
  • 372154 2023-002
    Significant Deficiency
  • 372155 2023-003
    Significant Deficiency
  • 372156 2023-003
    Significant Deficiency
  • 372157 2023-003
    Significant Deficiency
  • 372158 2023-003
    Significant Deficiency
  • 372159 2023-003
    Significant Deficiency
  • 372160 2023-003
    Significant Deficiency
  • 372161 2023-003
    Significant Deficiency
  • 372162 2023-003
    Significant Deficiency
  • 372163 2023-003
    Significant Deficiency
  • 372164 2023-003
    Significant Deficiency
  • 372165 2023-001
    Material Weakness
  • 372166 2023-002
    Significant Deficiency
  • 372167 2023-003
    Significant Deficiency
  • 948577 2023-001
    Material Weakness
  • 948578 2023-001
    Material Weakness
  • 948579 2023-001
    Material Weakness
  • 948580 2023-001
    Material Weakness
  • 948581 2023-001
    Material Weakness
  • 948582 2023-001
    Material Weakness
  • 948583 2023-001
    Material Weakness
  • 948584 2023-001
    Material Weakness
  • 948585 2023-001
    Material Weakness
  • 948586 2023-001
    Material Weakness
  • 948587 2023-002
    Significant Deficiency
  • 948588 2023-002
    Significant Deficiency
  • 948589 2023-002
    Significant Deficiency
  • 948590 2023-002
    Significant Deficiency
  • 948591 2023-002
    Significant Deficiency
  • 948592 2023-002
    Significant Deficiency
  • 948593 2023-002
    Significant Deficiency
  • 948594 2023-002
    Significant Deficiency
  • 948595 2023-002
    Significant Deficiency
  • 948596 2023-002
    Significant Deficiency
  • 948597 2023-003
    Significant Deficiency
  • 948598 2023-003
    Significant Deficiency
  • 948599 2023-003
    Significant Deficiency
  • 948600 2023-003
    Significant Deficiency
  • 948601 2023-003
    Significant Deficiency
  • 948602 2023-003
    Significant Deficiency
  • 948603 2023-003
    Significant Deficiency
  • 948604 2023-003
    Significant Deficiency
  • 948605 2023-003
    Significant Deficiency
  • 948606 2023-003
    Significant Deficiency
  • 948607 2023-001
    Material Weakness
  • 948608 2023-002
    Significant Deficiency
  • 948609 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $573,372
93.575 Child Care and Development Block Grant $503,520
84.196 Education for Homeless Children and Youth $177,109
84.287 Twenty-First Century Community Learning Centers $128,827
84.181 Special Education-Grants for Infants and Families $63,290
84.424 Student Support and Academic Enrichment Program $54,412
84.425 Education Stabilization Fund $21,690
84.027 Special Education_grants to States $8,418
84.367 Improving Teacher Quality State Grants $3,413