Finding 597123 (2022-003)

Significant Deficiency Repeat Finding
Requirement
ABG
Questioned Costs
-
Year
2022
Accepted
2023-01-11

AI Summary

  • Core Issue: The organization lacks effective internal controls over federal awards, leading to discrepancies in payroll allocation and non-payroll expenditures.
  • Impacted Requirements: Compliance with federal cost principles and documentation standards is not being met, risking submission of disallowed costs.
  • Recommended Follow-Up: Management should enhance payroll tracking processes and implement a secondary review for manual entries to reduce errors.

Finding Text

2022-003 Department of Justice and State of South Dakota Department of Public Safety CFDA #16.575, 2022-COMBO-00022, 2022-COMBO-00011 Crime Victim Assistance Allowable Costs, Allowable Activities, and Matching Significant Deficiency in Internal Control over Compliance Criteria: The Organization 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: - Three instances in which hours used to allocate payroll to the grant differed from actual hours worked and paid, resulting in deficiencies in allowable costs, allowable activities, and matching. - One instance in which hours used to allocate payroll to the grant differed from actual hours worked and paid, resulting in deficiencies in allowable costs and allowable activities only. - One instance identified over non-payroll expenditures in which costs were charged to the grant at the time paid rather than period of service, resulting in in deficiencies in allowable costs, allowable activities, and matching. Cause: Tracking of grant-related payroll is a manual process which increases the likelihood of error. Additionally, costs were charged to the program at the time the expenditure was paid rather than over the period of service. Effect: The Organization?s controls did not detect nor correct the errors identified, which results in a reasonable possibility that the Organization could submit disallowed costs under the federal awards. Questioned Costs: No questioned costs over $25,000. Context/Sampling: A nonstatistical sample of 60 payroll transactions were selected for allowable costs and allowable activities testing, which accounted for $45,235 out of $789,604 of payroll transactions. Of those payroll transactions 18 were also tested for matching which accounted for $2,360 out of $36,064 match payroll transactions. A nonstatistical sample of 16 non-payroll transactions out of 59 total transactions for allowable costs and allowable activities were selected for testing, which accounted for $8,680 of $24,213 of non-payroll transactions. One of those items was selected for matching testing which accounted for $139 of $159 of match expenditures. Repeat Finding from Prior Year(s): Yes, Finding 2021-002 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.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 20681 2022-003
    Significant Deficiency Repeat
  • 20682 2022-004
    Significant Deficiency Repeat
  • 597124 2022-004
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $813,322
93.558 Temporary Assistance for Needy Families $427,054
10.553 School Breakfast Program $93,497
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $33,000
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $28,103
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $7,392
10.558 Child and Adult Care Food Program $3,449
10.555 National School Lunch Program $37