Finding 1200766 (2025-004)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2025
Accepted
2026-03-30
Audit: 395765
Organization: Little Eagle Grant School (SD)
Auditor: BRADY MARTZ

AI Summary

  • Core Issue: Payroll costs were charged based on budgeted percentages instead of actual work performed, lacking necessary documentation and reconciliations.
  • Impacted Requirements: Compliance with federal regulations (2 CFR Part 200.430) regarding accurate payroll documentation and internal controls.
  • Recommended Follow-Up: Implement procedures for accurate payroll documentation, conduct periodic reconciliations, and adjust charges based on actual work performed.

Finding Text

AL 15.042: Indian School Equalization & AL 84.010: Title I – Activities Allowed or Unallowed – Significant Deficiency Criteria Per Uniform Guidance (2 CFR Part 200.430), 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 controls that ensures payroll costs charged to federal awards are reasonable, allocable, and properly documented. Budget estimates may be used for interim accounting purposes but must be reconciled to actual activity and adjusted as necessary. Condition During our testing of payroll expenditures, we noted that payroll costs for employees were charged based on budgeted percentage allocations rather than actual time worked on the program. The auditee did not perform periodic reconciliations of the budgeted percentages to employees’ actual activities. Additionally, budgeted payroll percentages were charged incorrectly as described below. Title I: One payroll transaction was not allocated in accordance with the budgeted percentage that was in the budget that is submitted to the grant. ISEP: One payroll transaction was not allocated in accordance with the budgeted percentage that was in the budget that is submitted to the grant. Another transaction was missing the supporting timesheet. Cause The auditee does not have adequate internal controls in place to ensure payroll costs charged to federal programs are periodically reviewed and adjusted to reflect actual work performed. Management indicated that payroll allocations were established at the beginning of the grant period and were not subsequently reconciled to actual staff activity. Effect As a result, payroll costs charged to the federal award may not accurately reflect the actual level of effort devoted to the program, resulting in a risk that costs charged to the federal program could be unallowable or not allocable under federal regulations. Questioned Costs None identified. However, due to the lack of documentation supporting actual time worked, we were unable to determine whether the payroll charges tested were fully supported. Repeat Finding This is a new finding in the current year. Recommendation We recommend that the auditee implement procedures to ensure payroll costs charged to federal awards are supported by records that accurately reflect the work performed. Such procedures should include: - Maintaining appropriate personnel activity or equivalent documentation reflecting actual work performed. - Performing periodic reconciliations between budgeted allocations and actual staff activity. - Adjusting payroll charges to federal programs when actual effort differs from budgeted percentages. View of Responsible Officials and Planned Corrective Actions Little Eagle Grant School acknowledges the finding regarding insufficient payroll documentation. To address this, the School will implement a standardized certification form to be submitted with each employee timesheet. This form will require employees to certify that their time and effort were performed in accordance with the approved budget and assigned funding source(s). This process will strengthen documentation and ensure compliance with federal requirements moving forward.

Corrective Action Plan

Contact Person – Rebecca Krein, Business Manager Little Eagle Grant School acknowledges the finding regarding insufficient payroll documentation. To address this, the School will implement a standardized certification form to be submitted with each employee timesheet. This form will require employees to certify that their time and effort were performed in accordance with the approved budget and assigned funding source(s). This process will strengthen documentation and ensure compliance with federal requirements moving forward. Completion Date – April 1, 2026

Categories

No categories assigned yet.

Other Findings in this Audit

  • 1200767 2025-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
15.042 INDIAN SCHOOL EQUALIZATION $677,809
84.027 SPECIAL EDUCATION GRANTS TO STATES $552,470
15.046 ADMINISTRATIVE COST GRANTS FOR INDIAN SCHOOLS $522,846
15.047 INDIAN EDUCATION FACILITIES, OPERATIONS, AND MAINTENANCE $297,941
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $238,640
15.044 INDIAN SCHOOLS STUDENT TRANSPORTATION $89,100
84.196 EDUCATION FOR HOMELESS CHILDREN AND YOUTH $80,000
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $45,070
10.555 NATIONAL SCHOOL LUNCH PROGRAM $34,545
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $22,790
10.553 SCHOOL BREAKFAST PROGRAM $19,974
15.151 EDUCATION ENHANCEMENTS $8,313
10.582 FRESH FRUIT AND VEGETABLE PROGRAM $5,325
84.358 RURAL EDUCATION $1,180