Finding 634319 (2022-004)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-02-10

AI Summary

  • Core Issue: Payroll costs were not accurately allocated to federal grants, leading to potential overcharges.
  • Impacted Requirements: Federal awards must only cover allowable costs as per grant guidelines.
  • Recommended Follow-Up: Implement a review process for payroll allocations and ensure the new contract accountant adheres to proper recording practices.

Finding Text

2022-004: Lack of Controls Surrounding Allocation of Payroll Costs to Programs Federal Departments: Department of Health and Human Services Assistance Listing #: 93.612 Internal Controls Significant Deficiency Category of Finding ? Allowable Costs/ Cost Principles Criteria ? Federal awards must be expended for activities allowed under the grant and costs charged to the federal grants must be allowable and in accordance with applicable cost principles. Condition ? IPTF staff use timecards to track which programs they work on to ensure that costs are properly allocated to each grant. The timecards are provided to the Finance Director/contract accountant for input into the accounting software, which is used to prepare grant reimbursement requests. During testing, after the transition to a contract accountant, we noticed multiple payroll transactions where the amounts noted as worked on this grant during the period tested did not match the payroll that was allocated to the grant in the accounting software. Cause ? The contract accountant did not record payroll costs in the accounting software consistent with the timecards provided by staff. Effect ? Grants have been overcharged for payroll allocated to the wrong grant or over-recorded payroll costs. Recommendation ? We recommend that management design and implement a review process to ensure payroll allocated to grants is calculated and recorded properly. Auditee?s comments and response ? IPTF has hired a new contract accountant, who will be responsible for ensuring proper payroll allocation calculation and recording. Responsible party for corrective action: Sharon Day, Executive Director

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 57858 2022-001
    Material Weakness
  • 57859 2022-002
    Material Weakness
  • 57860 2022-001
    Material Weakness
  • 57861 2022-002
    Material Weakness
  • 57862 2022-001
    Material Weakness
  • 57863 2022-002
    Material Weakness
  • 57864 2022-001
    Material Weakness
  • 57865 2022-002
    Material Weakness
  • 57866 2022-001
    Material Weakness
  • 57867 2022-002
    Material Weakness
  • 57868 2022-001
    Material Weakness
  • 57869 2022-002
    Material Weakness
  • 57870 2022-001
    Material Weakness
  • 57871 2022-002
    Material Weakness
  • 57872 2022-003
    Significant Deficiency
  • 57873 2022-004
    Significant Deficiency
  • 57874 2022-001
    Material Weakness
  • 57875 2022-002
    Material Weakness
  • 57876 2022-003
    Significant Deficiency
  • 57877 2022-004
    Significant Deficiency
  • 57878 2022-001
    Material Weakness
  • 57879 2022-002
    Material Weakness
  • 57880 2022-001
    Material Weakness
  • 57881 2022-002
    Material Weakness
  • 57882 2022-001
    Material Weakness
  • 57883 2022-002
    Material Weakness
  • 634300 2022-001
    Material Weakness
  • 634301 2022-002
    Material Weakness
  • 634302 2022-001
    Material Weakness
  • 634303 2022-002
    Material Weakness
  • 634304 2022-001
    Material Weakness
  • 634305 2022-002
    Material Weakness
  • 634306 2022-001
    Material Weakness
  • 634307 2022-002
    Material Weakness
  • 634308 2022-001
    Material Weakness
  • 634309 2022-002
    Material Weakness
  • 634310 2022-001
    Material Weakness
  • 634311 2022-002
    Material Weakness
  • 634312 2022-001
    Material Weakness
  • 634313 2022-002
    Material Weakness
  • 634314 2022-003
    Significant Deficiency
  • 634315 2022-004
    Significant Deficiency
  • 634316 2022-001
    Material Weakness
  • 634317 2022-002
    Material Weakness
  • 634318 2022-003
    Significant Deficiency
  • 634320 2022-001
    Material Weakness
  • 634321 2022-002
    Material Weakness
  • 634322 2022-001
    Material Weakness
  • 634323 2022-002
    Material Weakness
  • 634324 2022-001
    Material Weakness
  • 634325 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.939 Hiv Prevention Activities_non-Governmental Organization Based $341,456
93.612 Native American Programs $188,774
93.959 Block Grants for Prevention and Treatment of Substance Abuse $138,758
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $64,936
93.917 Hiv Care Formula Grants $42,076
10.170 Specialty Crop Block Grant Program - Farm Bill $27,024
93.788 Opioid Str $24,762
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $3,202