Finding 28099 (2022-001)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-01-25

AI Summary

  • Core Issue: Payroll expenses were incorrectly allocated due to an inaccurate percentage, leading to overcharges for October 2021.
  • Impacted Requirements: Actual time spent on the project must dictate payroll allocations; oversight and review processes were lacking.
  • Recommended Follow-Up: Establish checks and balances for calculations and implement a formal review process for payroll expense allocations.

Finding Text

SIGNIFICANT DEFICENCY Allowable Cost and Internal Control Criteria: Payroll expenses and related employee benefits should be allocated based on actual time spent on the project. Condition: Incorrect percentage was used to allocate payroll expenses and related personnel cost to the program. Cause: Lack of review or ineffective oversight of allocation expenses to the program. Based on October 2021 timesheet, 50% of one employee?s time was spent on the program and 70% was allocated to the program. Effect: Incorrect amount of payroll expenditures and related personnel cost were charged to the program for October 2021. Context: Employees track their time allocated to the program on their timecards correctly. However, the allocation percentage was incorrectly calculated and manually entered into the prepopulated template. Questioned Cost: $2,358. Correct payroll expenditure allocated to the program for October 2021 should be $24,312 (salary plus payroll tax) and the amount allocated to the program was $26,446, which creates a difference of $2,134. Correct related personnel cost including payroll admin fees, retirement benefit and health and dental insurance allocated to the program for October 2021 should be $2,547 and the amount allocated to the program was $2,771, which creates a difference of $224. The total difference is $2,358. Recommendation: The management should implement procedures of checks and balances for any numeric calculations. There should be a formal review process of verification of proper allocation of payroll expenses. Views of responsible officials and planned corrective actions: The management agree with this finding and will implement adequate checks and balances to ensure that this problem does not occur. Please refer to the corrective action plan on page 28.

Corrective Action Plan

Name of contract person: Amanda Bertran, Senior Finance Manager Corrective Action: Currently, the Finance Coordinator reviews the timesheets completed on time each pay period. Then, the Senior Finance Manager reviews the proper grants allocation in the journal entry. The management will strengthen the controls to review personnel allocations processes to ensure accuracy. The Finance Coordinator will generate payroll reports to review timesheet allocations to grants and complete the effort table accordingly to provide the outside accounting firm for the review and recording. The Senior Finance Manager will review the journal entry posted by the accounting firm to make sure there are no discrepancies between timesheets and payroll grant allocations. Proposed Completion Date: The Organization will implement the above procedure starting January 01, 2023.

Categories

Questioned Costs Internal Control / Segregation of Duties Allowable Costs / Cost Principles

Other Findings in this Audit

  • 604541 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
19.121 Conflict and Stabilization Operations $480,820
98.001 Usaid Foreign Assistance for Programs Overseas $296,760