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

Corrective Action Plan

The Council will move to the Time & Effort method of reporting to allow employees to sign off on their time allocation for each pay period which will subsequently be approved by the supervisor and Executive Director. Expected completion date: May 2024

Categories

Allowable Costs / Cost Principles Material Weakness

Other Findings in this Audit

  • 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
  • 399940 2023-006
    Material Weakness Repeat
  • 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