Finding 478410 (2023-002)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-07-15

AI Summary

  • Core Issue: The Club lacks effective internal controls over federal award expenditures, leading to potential errors in allowable costs.
  • Impacted Requirements: Compliance with 2 CFR 200.430(i) for documentation of personnel expenses and 2 CFR 200.303(a) for maintaining internal controls.
  • Recommended Follow-Up: Management should enhance payroll tracking processes and consider implementing a secondary review or direct allocation within the payroll system.

Finding Text

Department of Education and Passed through State of South Dakota Department of Education FFAL #84.287C, S287C220042 Twenty-First Century Community Learning Centers Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: The Club is required to have procedures in place to ensure that federal awards are expended only for allowable costs in accordance with Subpart E – Cost Principles of the Uniform Guidance. Allowable costs are supported by appropriate documentation and correctly charged as to account, amount, and period. 2 CFR 200.430(i) establishes requirements for documentation of personnel expenses. 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition: Our testing over expenditures noted the following items: - Two instances where timesheets or bi-weekly activity reports were unable to be provided. - Three instances where the employee’s paid time off and holiday pay was not allocated nor submitted for reimbursement under the federal program, which was inconsistent with other pay periods. - One instance where support did not agree to the amount and time allocated. Cause: Tracking of grant-related payroll is a manual process which increases the likelihood of error. Effect: The Club’s controls did not detect or correct the errors identified, which results in a reasonable possibility that the Club could submit disallowed costs under the federal awards. Questioned Costs: No questioned costs over $25,000. Context/Sampling: A nonstatistical sample of 60 transactions out of approximately 830 total transactions were selected testing, of which 51 of those transactions were payroll transactions and accounted for $45,055 out of $272,463 of total payroll transactions. Repeat Finding from Prior Year: No Recommendation: We recommend management continue to review the process over tracking payroll related to federal programs and consider incorporating a secondary review of any manual spreadsheets or consider if the payroll can be allocated directly within the payroll system. Views of Responsible Officials: Management is in agreement.

Corrective Action Plan

Federal Agency Name: Department of Education and Passed through State of South Dakota Department of Education Program Name: Twenty-First Century Community Learning Centers Federal Financial Assistance Listing #84.287C Finding Summary: Our auditors identified two instances where timesheets or bi-weekly activity reports were unable to be provided, three instances where the employee’s paid time off and holiday pay was not allocated nor submitted for reimbursement under the Federal program which was inconsistent with other pay periods, and one instance where support did not agree to the amount and time allocated. The Club’s controls did not detect or correct the errors identified. Responsible Individuals: Jody Hernandez, Chief Executive Officer; Darcie Bien, Chief Financial Officer Corrective Action Plan: For all grant-funded payroll, all time allocated through the payroll software will be compared to the bi-weekly activity reports for consistency and accuracy prior to submitting for reimbursement. In addition, a second review of the reimbursement requests by a member of the management team, other than the CFO who prepares the reimbursements, will be done. Anticipated Completion Date: July 2024

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1054852 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.287 Twenty-First Century Community Learning Centers $330,317
84.425 Education Stabilization Fund $234,822
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $90,943
16.726 Juvenile Mentoring Program $84,824
10.559 Summer Food Service Program for Children $14,397
93.235 Affordable Care Act (aca) Abstinence Education Program $2,603