Finding 518870 (2023-003)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2023
Accepted
2025-01-13

AI Summary

  • Core Issue: Payroll allocations do not accurately reflect employee time worked or salary rates, indicating potential mischarges to federal programs.
  • Impacted Requirements: Compliance with Title 2 U.S. CFR Part 200, which mandates accurate records and internal controls for salary charges to federal awards.
  • Recommended Follow-Up: Finance should enhance the review process for monthly payroll allocations to ensure accuracy and prevent future errors.

Finding Text

Finding 2023-003: Time Tracking and Payroll Allocations (Material Weakness) Information on the Federal Programs: Assistance Listing Number 98.001 Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, paragraph 430 “Compensation – personal services” requires that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, and that these records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, these records must comply with established accounting policies and practices of the non-Federal entity. Condition: As part of our audit procedures around payroll, we noted instances of payroll allocations to programs which did not accurately represent the time worked and/or salary rate of the employee. While misallocations were not significant in their amounts, the errors themselves suggest the need for more detailed review of the payroll allocation approval and entry process. Cause: The review of the payroll allocation entry and process was not sufficient to catch the errors. Context: The misallocations identified represent 5% of the sampled employees (2 out of 40). Although the majority of payroll allocations were supported by appropriate documentation, these two exceptions suggest a need for improved controls over time and effort reporting to prevent isolated errors from becoming more systemic issues. Effect: Astraea could inadvertently mischarge salaries and wages to its various programs. Questioned Costs: Undetermined. Identification as a Repeat Finding, if Applicable: Finding 2022-003 Recommendation: We recommend that the finance department perform a more detailed review of the monthly program allocations to ensure complete and accurate entry of payroll allocations.

Corrective Action Plan

Views of Responsible Officials: All Astraea staff members are required to complete timesheets. Astraea’s internal processes were reviewed and overhauled in December 2021 (midway through FY2022) with department heads determining how their direct reports would spend time on various Astraea work streams and projects.This information is detailed in a level of effort (LOE) spreadsheet tracked against timesheets and budgets regularly. However, the processes for instituting regular updates to the LOE spreadsheet and timesheet allocations remained time-consuming and highly manual in FY2023 – which we believe resulted in misallocations. Astraea is currently reviewing internal processes to ensure, 1) that review and revision of the LOE spreadsheet and timesheet allocations can happen in a timely manner with less administrative burden, and 2) allowance of a more detailed review of the payroll allocation approval and entry process. As of November 2024, the Astraea Finance team was in the process of transitioning to a more sophisticated finance and accounting system. This system will allow for automation of the processes. Since this system is expected to be live starting in January of 2025, the anticipated completion date remains January 31, 2025.

Categories

Allowable Costs / Cost Principles Material Weakness Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 518871 2023-004
    Material Weakness Repeat
  • 518872 2023-005
    Material Weakness Repeat
  • 1095312 2023-003
    Material Weakness Repeat
  • 1095313 2023-004
    Material Weakness Repeat
  • 1095314 2023-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
98.001 Usaid Foreign Assistance for Programs Overseas $2.51M
19.345 International Programs to Support Democracy, Human Rights and Labor $128,615