Finding 1077462 (2023-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2023
Accepted
2024-09-30

AI Summary

  • Core Issue: Payroll expenses charged to the grant lack adequate documentation, with 3 out of 7 employees tested not providing necessary time sheets.
  • Impacted Requirements: This finding violates 2 CFR 200.430(i), which requires accurate records and internal controls for allowable costs.
  • Recommended Follow-Up: Implement procedures for detailed timecards or time studies for all employees on federal programs, with supervisor review for accuracy.

Finding Text

Criteria: 2 CFR 200.430(i) indicates costs must be based on records that accurately reflect the work performed to be considered allowable. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition and Context: We selected 4 months of payroll expense charged to the grant for testing during the audit and noted that each month had at least one employee who did not have detailed time sheets or time studies to adequately support the hours charged to the grant. Our sample covered 7 employees over these 4 months and 3 of the employees tested did not have adequate support for the time charged. We tested a total of $33,351 of claimed payroll cost and identified known questioned costs of $3,770 which resulted in likely questioned costs of $5,308 using an error rate of 11% over total payroll claimed for 2023 of $46,955. Our sample was not considered to be a statistically valid sample. This finding is a repeat finding of 2022-002. Cause and Effect: The lack of adequate documentation to support time charged to the federal award combined with the finding 2023-003 resulted in material noncompliance to the referenced compliance requirements and to the program as a whole. Recommendation: We recommend the Association implement procedures for all employees who have payroll claimed under federal programs to prepare detailed timecards or time studies to support the distribution of each employee's compensation among specific activities, including the allocation of compensation to federal awards. These records should be reviewed by the employee's supervisor for accuracy. Views of Responsible Officials and Planned Corrective Actions: The Association agrees with the finding and plans to implement their corrective action during October 2024.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 501020 2023-002
    Material Weakness Repeat
  • 501021 2023-003
    Material Weakness
  • 501022 2023-004
    Material Weakness
  • 501023 2023-005
    Material Weakness
  • 1077463 2023-003
    Material Weakness
  • 1077464 2023-004
    Material Weakness
  • 1077465 2023-005
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.231 Emergency Solutions Grant Program $222,343
14.267 Continuum of Care Program $170,148
16.575 Crime Victim Assistance $48,561
16.017 Sexual Assault Services Formula Program $45,008
97.024 Emergency Food and Shelter National Board Program $22,619
14.218 Community Development Block Grants/entitlement Grants $21,515
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $17,113
93.667 Social Services Block Grant $16,100
93.569 Community Services Block Grant $798