Finding 949022 (2022-001)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2024-03-05
Audit: 293660
Organization: Think of US (DC)

AI Summary

  • Core Issue: The Organization's new timesheet process lacks a clear audit trail and proper documentation, risking 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: Improve time allocation verification by recording monthly allocations, reconciling pay periods to the general ledger, and ensuring timesheet approvals reflect actual hours worked.

Finding Text

Finding 2022-001: Payroll Information on the Federal Program: 93.471 Criteria or Specific Requirement: 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: Subsequent to the completion of the 2021 audit, the Organization modified its timesheet process for employees that work on the Federal pass-through grant. The new methodology was in effect for the last two months of 2022. The time allocated is now based on actual time, and we were able to tie the amount calculated based on hours reported to the invoice submitted to the pass-through entity for the month. However, there was no direct audit trail to the amount in the general ledger (the GL allocation was posted for the quarter in total). In addition, if employees work over the time allowed by the budget the amount is manually adjusted down before allocation. Also, the supervisory approval of the timesheets is over a month report that lists only the names of the employees (does not show the hours reported). Cause: An allocation methodology based on actual timesheets was implemented at the end of 2022, but we identified certain recommended improvements. Effect or Potential Effect: The Organization could inadvertently mischarge salaries and wages to its various programs. Questioned Costs: Undetermined. Context: This is deemed to be systemic in nature. Identification as a Repeat Finding, if Applicable: See prior year 2021-001 Recommendation: We recommend that the Organization revisit the procedures in the current year to ensure that the time allocation can be easily verified (i.e. record the allocations on a monthly basis at a minimum, and maintain a schedule to reconcile amount per pay period to total entered in the general ledger). The Organization should be careful to document that if time allocated to the Federal project is manually reduced that is does not result in overcharging a different program. The approval of the timesheets should be on a report that shows the actual time that is being reviewed/approved.

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 372580 2022-001
    Significant Deficiency Repeat
  • 372581 2022-002
    Significant Deficiency Repeat
  • 949023 2022-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.471 Title IV-E Kinship Navigator Program (a) $1.33M