Finding 478068 (2023-001)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-07-10

AI Summary

  • Core Issue: Discrepancies exist between timekeeping system allocations and general ledger records for salary expenditures.
  • Impacted Requirements: Compliance with 2 CFR Section 200.430(i) regarding accurate and allowable salary charges to Federal grants.
  • Recommended Follow-Up: Revise procedures for data transfer from the timekeeping system to the general ledger and strengthen internal controls to ensure accurate reconciliation.

Finding Text

Finding 2023-001: Salaries and Wages (Allowable Costs) Criteria: According to 2 CFR Section 200.430(i), charges to Federal grants for salaries and wages must be based on records that accurately reflect the work performed and the records must: i. Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; ii. Be incorporated into the official records of the non-Federal entity; iii. Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, not exceeding 100% of compensated activities; iv. Encompass Federally-assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity’s written policy; v. Comply with the established accounting policies and practices of the non-Federal entity; vi. [Reserved] vii. Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non- Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. viii. Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.” Condition: ASCB has a timekeeping system in place that provides for employees to record hours worked to specific cost objectives, including to US Government grants. However, we noted that in several cases the allocation amounts as per the timekeeping system were different from the amounts ultimately recorded within ASCB's general ledger. While the differences were not significant, these discrepancies indicate a deficiency in the internal controls around recording of salary expenditures to projects. Cause: The primary cause appears to be human error, and the result of manual recordkeeping. Effect or Potential Effect: Salary expenditures that are not charged in accordance with the standards referenced above may be questioned or disallowed by the donor. Questioned Costs: Undetermined Context: This is a condition identified per review of ASCB's compliance with the specified requirements using a statistically valid sample. Identification as a Repeat Finding: Not applicable. Recommendation: We recommend that management revisit its procedures for transferring data from the timekeeping system to the general ledger and implement proper internal controls to ensure that the amounts of salary expenditures charged to grants in the general ledger reconcile to the amounts calculated by the timekeeping system.

Corrective Action Plan

Views of Responsible Officials: Agreed that the differences were insignificant, however, ASCB understands how important it is to ensure the timesheet hours match the general ledger. So we have already created a new salary allocation worksheet that uses less complex formulas and calculations to streamline the process. The new worksheet also uses less manual input which reduces room for error.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 478069 2023-002
    Significant Deficiency
  • 478070 2023-001
    Significant Deficiency
  • 478071 2023-002
    Significant Deficiency
  • 1054510 2023-001
    Significant Deficiency
  • 1054511 2023-002
    Significant Deficiency
  • 1054512 2023-001
    Significant Deficiency
  • 1054513 2023-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.859 Biomedical Research and Research Training $838,432
47.074 Biological Sciences $434,650