Finding 399940 (2023-006)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-06-05
Audit: 308093

AI Summary

  • Core Issue: Payroll costs were not properly documented, leading to discrepancies between timesheets and allocated amounts for grant funding.
  • Impacted Requirements: The Council failed to meet financial management standards outlined in 2 CFR section 200.302, which mandates accurate record-keeping for federal grants.
  • Recommended Follow-Up: Strengthen payroll procedures to ensure timesheets are submitted before payroll processing, aligning allocations with actual employee hours worked.

Finding Text

Finding 2023-006 – Allowable Costs - Payroll costs (Material Weakness and Noncompliance) Information on the federal program: U.S. Department of Veterans Affairs, Assistance Listing #64.055 Staff Sergeant Parker Gordon Fox Suicide Prevention Grant Program; U.S. Department of Health and Human Services, Assistance Listing #93.137 Community Programs to Improve Minority Health Grant Program; and U.S. Department of Health and Human Services, Assistance Listing #93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance. Criteria: 2 CFR section 200.302 establishes the requirements for sufficient financial management over grant funding to ensure records adequately identify the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. Condition: We tested 78 payroll disbursements over 3 grant programs. Of those 78, 9 exceptions were noted. The amount of time and corresponding amounts allocated to the grant did not agree to the percentage documented on the employee’s timesheet. Cause: Employee timesheets are turned in after payroll is processed and allocations made, timesheets in these exceptions did not agree to the amount allocated. Effect: The Council did not comply with financial management requirements. Questioned Costs: None Recommendation: We recommend the Council strengthen procedures surrounding payroll so that the source documentation properly supports the amounts being allocated to the grant based on actual employee time. Views of Responsible Officials: See Management’s View and Corrective Action Plan at the end of the report.

Categories

Allowable Costs / Cost Principles Material Weakness

Other Findings in this Audit

  • 399934 2023-006
    Material Weakness Repeat
  • 399935 2023-006
    Material Weakness Repeat
  • 399936 2023-006
    Material Weakness Repeat
  • 399937 2023-006
    Material Weakness Repeat
  • 399938 2023-006
    Material Weakness Repeat
  • 399939 2023-007
    Significant Deficiency
  • 399941 2023-008
    Significant Deficiency
  • 976376 2023-006
    Material Weakness Repeat
  • 976377 2023-006
    Material Weakness Repeat
  • 976378 2023-006
    Material Weakness Repeat
  • 976379 2023-006
    Material Weakness Repeat
  • 976380 2023-006
    Material Weakness Repeat
  • 976381 2023-007
    Significant Deficiency
  • 976382 2023-006
    Material Weakness Repeat
  • 976383 2023-008
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.959 Block Grants for Prevention and Treatment of Substance Abuse $902,559
64.055 Ssg Fox Suicide Prevention $343,190
93.137 Community Programs to Improve Minority Health Grant Program $300,369
93.136 Injury Prevention and Control Research and State and Community Based Programs $89,936
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $54,981
17.278 Wia Dislocated Worker Formula Grants $47,800
93.788 Opioid Str $35,947