Finding 508155 (2024-007)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2024-11-15
Audit: 328590
Organization: Yukon Flats School District (AK)

AI Summary

  • Core Issue: There is a significant deficiency in internal controls over payroll expenditures for federal programs, leading to unverified funding allocations.
  • Impacted Requirements: Management must maintain proper documentation and internal controls as per 2 CFR Part 200, specifically for time distribution records related to federal funding.
  • Recommended Follow-Up: Update employee personnel action forms to ensure correct fund allocations and implement tracking for time and effort related to federal grants.

Finding Text

Federal Agency: U.S. Department of Education passed through the State of Alaska, Department of Education and Early Development (DEED) Federal Program(s): COVID-19 CRRSA ACT: ESSER II / ARP ACT: ESSER III (ESSER) and Title I-A Assistance Listing Number(s):84.425 U and D and 84.010A Award Number(s): Federal award numbers: S425U210020, S425D210020 (ESSER), S010A230002, and S010A230002 (Title I-A), Pass through entity award numbers: ER 24.YFSD.01 (ESSER), IP 24.YFSD.01, and SI 24.YFSD.01 (Title I-A). Award Year(s): 2024 Type of Finding: Significant deficiency in internal control over compliance. Criteria: Management is responsible for designing, implementing and maintaining internal controls relevant to ensuring that transactions charged to programs follow proper internal control processes (2 CFR Part 200 Subpart E § 200.400 (d)). Further, Uniform Guidance Requirements, which also apply to expenditures of ESSER funds, dictate the funding recipient is required to follow document personnel costs in accordance with 2 CFR Section 200.430 (i). The District is required to maintain time distribution records for employees funded under Federal Programs. Condition and Context: We tested a sample of fifteen (15) payroll transactions for ESSER and seven (7) payroll transactions for Title I-A. We were unable to verify the funding allocation for eleven (11) transactions for the ESSER funding and four (4) transactions for the Title I-A funding. The payroll expenditures charged to these programs were recorded using journal entries and lacked documentation of time and effort. The employee positions were not considered unallowable under the programs. Cause: Lack of internal controls over payroll expenditure allocation.   Effect: The lack of supporting documentation indicating the payroll expenditure allocation allows for the potential of payroll expenditures to be incorrectly charge to unallowable funding sources. Repeat Finding: This is not a repeat finding, however, due to the number of exceptions identified, we believe this to be a systemic issue. Questioned Costs: None reported. Recommendation: We recommend that management ensures employee personnel action forms are updated to reflect the correct fund allocations for payroll costs to ensure employees time is appropriately coded. Additionally, if charged to federal grant sources that time and effort be adequately tracked and documented. Management Response: Management agrees with this finding, see Corrective Action Plan.

Corrective Action Plan

Name of Contact Person: Elena Begojevic, Business Manager Corrective Action Plan: Human resources manager will collaborate with both a business manager and a grant manager to ensure that employees’ time is being charged to the correct programs and grants in accordance with approved budgets. The human resource manager will prepare a payroll action form that will list available and applicable funding sources to cover the payroll expenses of an employee. The independent payroll contractor will maintain payroll action notices (PAN) for employees who are covered by multiple funding sources or funding sources other than general fund. In addition, she would update payroll distribution coding in the accounting software to match PAN. She would also match coding on timesheets with coding on PAN and in the accounting software. In case of a discrepancy, she would reach out to a business manager and/or a grant manager on how to resolve it. The Superintendent will review account coding each payroll while performing a review of the payroll check register. In addition, budgeted account codes will be compared to the actual codes being used in payroll on a periodic basis. Proposed Completion Date: Implemented July 1, 2024

Categories

Allowable Costs / Cost Principles Significant Deficiency

Other Findings in this Audit

  • 508147 2024-004
    Significant Deficiency Repeat
  • 508148 2024-004
    Significant Deficiency Repeat
  • 508149 2024-005
    Significant Deficiency Repeat
  • 508150 2024-005
    Significant Deficiency Repeat
  • 508151 2024-005
    Significant Deficiency Repeat
  • 508152 2024-006
    Significant Deficiency
  • 508153 2024-006
    Significant Deficiency
  • 508154 2024-006
    Significant Deficiency
  • 508156 2024-007
    Significant Deficiency
  • 508157 2024-007
    Significant Deficiency
  • 508158 2024-005
    Significant Deficiency Repeat
  • 508159 2024-006
    Significant Deficiency
  • 508160 2024-007
    Significant Deficiency
  • 1084589 2024-004
    Significant Deficiency Repeat
  • 1084590 2024-004
    Significant Deficiency Repeat
  • 1084591 2024-005
    Significant Deficiency Repeat
  • 1084592 2024-005
    Significant Deficiency Repeat
  • 1084593 2024-005
    Significant Deficiency Repeat
  • 1084594 2024-006
    Significant Deficiency
  • 1084595 2024-006
    Significant Deficiency
  • 1084596 2024-006
    Significant Deficiency
  • 1084597 2024-007
    Significant Deficiency
  • 1084598 2024-007
    Significant Deficiency
  • 1084599 2024-007
    Significant Deficiency
  • 1084600 2024-005
    Significant Deficiency Repeat
  • 1084601 2024-006
    Significant Deficiency
  • 1084602 2024-007
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.299 Indian Education -- Special Programs for Indian Children $1.46M
84.425 Education Stabilization Fund $919,769
84.041 Impact Aid $379,397
84.010 Title I Grants to Local Educational Agencies $100,000
84.060 Indian Education Grants to Local Educational Agencies $75,933
84.371 Comprehensive Literacy Development $65,773
84.424 Student Support and Academic Enrichment Program $54,552
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $47,368
10.553 School Breakfast Program $22,118
10.555 National School Lunch Program $10,321
84.358 Rural Education $7,082
84.173 Special Education Preschool Grants $4,044
84.027 Special Education Grants to States $2,093