Finding 560791 (2024-002)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2024
Accepted
2025-05-19

AI Summary

  • Core Issue: Payroll allocations do not accurately reflect actual time worked or salary rates, indicating a need for better oversight.
  • Impacted Requirements: Compliance with federal regulations (2 CFR 200.430) regarding accurate record-keeping and internal controls for payroll.
  • Recommended Follow-Up: Finance should enhance the review process for monthly payroll allocations to ensure accuracy and prevent future errors.

Finding Text

Finding 2024-002: Time Tracking and Payroll Allocations (Material Weakness) See Section III - Federal Award Findings and Questioned Costs (2 CFR 200.516(a)) 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 10% of the sampled employees (4 out of 40). Although the majority of payroll allocations were supported by appropriate documentation, these four 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 2023-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 January 1, 2025, a new finance system was implemented allowing for greater sophistication, consistency and automation of these processes. We do not expect to see this finding upon completion of our FY25 audit.

Categories

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

Other Findings in this Audit

  • 560792 2024-003
    Material Weakness Repeat
  • 560793 2024-004
    Material Weakness Repeat
  • 1137233 2024-002
    Material Weakness Repeat
  • 1137234 2024-003
    Material Weakness Repeat
  • 1137235 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
98.001 Usaid Foreign Assistance for Programs Overseas $2.77M
19.345 International Programs to Support Democracy, Human Rights and Labor $244,741