Finding 782468 (2022-001)

Significant Deficiency
Requirement
A
Questioned Costs
-
Year
2022
Accepted
2022-12-01
Audit: 174637
Organization: Refugeeone (IL)
Auditor: Porte Brown LLC

AI Summary

  • Core Issue: Cost allocations for salaries are not consistently backed by employee timesheets, leading to potential misallocation of employee time across programs.
  • Impacted Requirements: Internal controls for accurate cost allocation based on employee time are lacking, particularly for federal award programs.
  • Recommended Follow-Up: Implement time tracking for employees on cost reimbursement grants and ensure accounting reconciles these reports with payroll allocations.

Finding Text

Criteria: Internal controls should be in place that provide reasonable assurance that cost allocations of staff time accurately represent the correct allocation of employee-related costs based on the time spent by applicable employees. Condition: Cost allocations for salaries, including federal award programs, are not consistently supported by employee timesheets or other similar documentation. Effect : Because a reconciliation process is not in place to agree to personnel activity reports to cost allocations, it is possible that an employee's time may be inappropriately allocated amongst program and non program activities, including federal award programs. Cause : There are no procedures in place for tracking of employee time spent on federal programs on a cost reimbursement basis. Context : During our testing of current year expenditures, we sampled 31 payroll expenditures totaling $67,195 and identified 7 transactions totalling $13,975 in which the allocated amount was not supported by timecards maintained. Recommendation : We recommend that individuals who are written into a grant agreement as a cost reimbursement and who work in different program initiatives, track their time and submit timecards or time allocation summaries documenting their time spent on the various programs. We recommend then that the accounting department reconcile those reports and ensure that the pay period allocation is in agreement with the submitted reports. Views of Responsible Officials and Planned Corrective Actions : The Agency recognizes this finding and notes that this occurrence resulted from additional emergency additional funding provided by funders in a different payment structure than other grants received. Going forward with any new grants that are cost reimbursement based and where individuals are only partially allocated to the program, a staff allocation tracking will be implemented for said employees.

Categories

Allowable Costs / Cost Principles Cash Management Internal Control / Segregation of Duties

Other Findings in this Audit

  • 206026 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
19.510 U.s. Refugee Admissions Program $2.15M
93.566 Refugee and Entrant Assistance_state Administered Programs $1.01M
93.185 Immunization Research, Demonstration, Public Information and Education_training and Clinical Skills Improvement Projects $72,372
93.676 Unaccompanied Alien Children Program $41,796
93.576 Refugee and Entrant Assistance_discretionary Grants $29,377
93.567 Refugee and Entrant Assistance_voluntary Agency Programs $1,638