Finding 20681 (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.

Corrective Action Plan

Finding 2022-003 Allowable Costs, Allowable Activities, and Matching ? Significant Deficiency in Internal Control Over Compliance Federal/State Agency Name: Department of Justice and State of South Dakota Department of Public Safety Program Name: Crime Victim Assistance CFDA # 16.575, 2022-COMBO-00022, 2022-COMBO-00011 Finding Summary: Audit testing over expenditures noted the following items: -Three instances were noted where hours used to allocate payroll to the grant differed from the actual hours worked and paid resulting in deficiencies in allowable costs, allowable activities, and matching. -One instance was noted where the hours used to allocate payroll to the grant differed from the actual hours worked and paid resulting in deficiencies in allowable costs and allowable activities. -One instance was noted where a non-payroll expenditure where costs charged to the grant that were paid within the service period but related to services outside of the service period resulting in deficiencies in allowable costs, allowable activities and matching. Responsible Persons: Shannon Clark, Chief Financial Officer; Lynn Peterson, Controller; Amy Carter, Program Director; Janice Lee, Finance Administrator Corrective Action Plan: This has been an ongoing issue and we are revising how our draws are prepared and reviewed. We plan to have one person familiar with the process prepare all the draws then a detailed review by the Controller before the draw will be submitted. Anticipated Completion Date: June 30, 2023

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 20682 2022-004
    Significant Deficiency Repeat
  • 597123 2022-003
    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