Finding 31292 (2022-006)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-04-24

AI Summary

  • Core Issue: Payroll expenses lacked necessary time and effort documentation, risking disallowance of funds.
  • Impacted Requirements: Non-compliance with 2 CFR 200.430(i)(1)(vii) regarding documentation for salaries charged to federal awards.
  • Recommended Follow-Up: Implement a monthly process for maintaining time and effort documentation for all payroll expenditures related to federal awards.

Finding Text

2022-006 Federal Agency: U.S. Department of Education Pass Thru Entity: Oklahoma State Department of Education Program: COVID-19 Education Stabilization Fund Assistance Listing: COVID-19- 84.425D & 84.425U Grant Period: Year ending June 30, 2022 Condition: Payroll expenditures did not have time and effort documentation. Criteria: 2 CFR ?200.430(i)(1)(vii) Standards for Documentation of Personnel Expenses (1) Charges to Federal Awards for salaries and wages must be based on records that accurately reflect the work performed. (vii) 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. Cause: Employees charged to program left before the semi-annual time and effort was completed according to District policy. Effect: The expenditures may be disallowed. Context: A sample of 28 expenditures totaling $378,391 was selected for audit from a population of $11,846,116. The test found 2 items that were not in compliance with questioned costs totaling $9,549. Questioned Costs: $9,549 Recommendation Time and effort documentation needs to be maintained for payroll expenditures charged to federal awards. The District needs to time and effort documentation to a monthly process if hourly employees. Repeat Finding from Prior Year: Yes; 2021-004 Views of Responsible Officials And Planned Corrective Action: This is a repeat finding from FY2021 (2021-004). The finding was identified during our 2021 audit and corrected in March of 2022. It is important to note that, the United States Department of Education?s ?Frequently Asked Questions Elementary and Secondary School Emergency Relief Programs Governor?s Emergency Education Relief Programs? dated May 26, 2021 stated on page 19 that ?An LEA must maintain time distribution records (sometimes called ?time and effort? reporting) only if an individual employee is splitting his or her time between activities that may be funded under ESSER or GEER and activities that are not allowable under the applicable program.? After the 2021 was complete and 2022 was significantly underway, the auditor indicated that time-and-effort was required and the auditor stated that SDE agreed. Therefore, the district began obtaining time-and-effort for employees paid with federal funds in March of 2022, regardless of SDE and USDE guidance stating otherwise.

Corrective Action Plan

This is a repeat finding from FY2021 (2021-004). The finding was identified during our 2021 audit and corrected in March of 2022. It is important to note that, the United States Department of Education?s ?Frequently Asked Questions Elementary and Secondary School Emergency Relief Programs Governor?s Emergency Education Relief Programs? dated May 26, 2021 stated on page 19 that ?An LEA must maintain time distribution records (sometimes called ?time and effort? reporting) only if an individual employee is splitting his or her time between activities that may be funded under ESSER or GEER and activities that are not allowable under the applicable program.? After the 2021 was complete and 2022 was significantly underway, the auditor indicated that time-and-effort was required and the auditor stated that SDE agreed. Therefore, the district began obtaining time-and-effort for employees paid with federal funds in March of 2022, regardless of SDE and USDE guidance stating otherwise.

Categories

Questioned Costs Reporting

Other Findings in this Audit

  • 31289 2022-009
    Material Weakness
  • 31290 2022-005
    Material Weakness
  • 31291 2022-007
    Material Weakness Repeat
  • 31293 2022-008
    Material Weakness Repeat
  • 31294 2022-009
    Material Weakness
  • 31295 2022-005
    Material Weakness
  • 31296 2022-007
    Material Weakness Repeat
  • 31297 2022-006
    Material Weakness Repeat
  • 31298 2022-008
    Material Weakness Repeat
  • 31299 2022-009
    Material Weakness
  • 31300 2022-005
    Material Weakness
  • 31301 2022-007
    Material Weakness Repeat
  • 31302 2022-006
    Material Weakness Repeat
  • 31303 2022-008
    Material Weakness Repeat
  • 31304 2022-009
    Material Weakness
  • 31305 2022-005
    Material Weakness
  • 31306 2022-007
    Material Weakness Repeat
  • 31307 2022-006
    Material Weakness Repeat
  • 31308 2022-008
    Material Weakness Repeat
  • 31309 2022-009
    Material Weakness
  • 31310 2022-005
    Material Weakness
  • 31311 2022-007
    Material Weakness Repeat
  • 31312 2022-006
    Material Weakness Repeat
  • 31313 2022-008
    Material Weakness Repeat
  • 31314 2022-010
    Material Weakness
  • 607731 2022-009
    Material Weakness
  • 607732 2022-005
    Material Weakness
  • 607733 2022-007
    Material Weakness Repeat
  • 607734 2022-006
    Material Weakness Repeat
  • 607735 2022-008
    Material Weakness Repeat
  • 607736 2022-009
    Material Weakness
  • 607737 2022-005
    Material Weakness
  • 607738 2022-007
    Material Weakness Repeat
  • 607739 2022-006
    Material Weakness Repeat
  • 607740 2022-008
    Material Weakness Repeat
  • 607741 2022-009
    Material Weakness
  • 607742 2022-005
    Material Weakness
  • 607743 2022-007
    Material Weakness Repeat
  • 607744 2022-006
    Material Weakness Repeat
  • 607745 2022-008
    Material Weakness Repeat
  • 607746 2022-009
    Material Weakness
  • 607747 2022-005
    Material Weakness
  • 607748 2022-007
    Material Weakness Repeat
  • 607749 2022-006
    Material Weakness Repeat
  • 607750 2022-008
    Material Weakness Repeat
  • 607751 2022-009
    Material Weakness
  • 607752 2022-005
    Material Weakness
  • 607753 2022-007
    Material Weakness Repeat
  • 607754 2022-006
    Material Weakness Repeat
  • 607755 2022-008
    Material Weakness Repeat
  • 607756 2022-010
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.041 Impact Aid $5.72M
84.010 Title I Grants to Local Educational Agencies $3.56M
10.553 School Breakfast Program $3.19M
32.009 Emergency Connectivity Fund Program $1.33M
10.555 National School Lunch Program $559,652
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $500,000
84.060 Indian Education_grants to Local Educational Agencies $246,275
15.130 Indian Education_assistance to Schools $125,996
84.048 Career and Technical Education -- Basic Grants to States $103,689
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $97,596
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $96,209
12.556 Competitive Grants: Promoting K-12 Student Achievement at Military-Connected Schools $87,453
84.173 Special Education_preschool Grants $78,167
84.196 Education for Homeless Children and Youth $77,676
84.425 Education Stabilization Fund $65,399
84.365 English Language Acquisition State Grants $55,522
84.027 Special Education_grants to States $38,881
10.559 Summer Food Service Program for Children $37,480
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $18,750
10.558 Child and Adult Care Food Program $8,929
10.649 Pandemic Ebt Administrative Costs $5,814
84.184 Safe and Drug-Free Schools and Communities_national Programs $29