Finding 497041 (2023-003)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-09-17

AI Summary

  • Core Issue: There are discrepancies between the timekeeping system and the general ledger regarding salary allocations, indicating weak internal controls.
  • Impacted Requirements: Compliance with 2 CFR Section 200.430(i) is at risk, potentially leading to questioned or disallowed salary expenditures by federal donors.
  • Recommended Follow-Up: Management should improve data transfer procedures, ensure payroll registers are reviewed and approved promptly, and document any changes in payroll allocation methodology in the policies manual.

Finding Text

Finding 2023-003: Salaries and Wages (Allowable Costs) Federal Programs: All programs 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: The Center 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 one instance the allocation amount as per the timekeeping system with the applicable compensation amount paid to the employee was different from the amounts ultimately recorded within the Center's general ledger. While the difference was not significant, this discrepancy indicate a deficiency in the internal controls around recording of salary expenditures to projects. We also noted the Center changed the payroll allocation methodology during the year under audit but this change was not documented in the policies and procedures. We also did not obtain evidence for review and approval of several payroll registers. Cause: During 2023, the Center's finance department turned over significantly, resulting in oversight of some the salary and wages procedures. 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 the Center'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 projects in the general ledger reconcile to the amounts calculated by the timekeeping system and current wages and salaries.We also recommend the payroll registers be reviewed and approved by management immediately upon receipt; any discrepancies or issues must be addressed with the accounting department within a timely period following the close of the payroll period. We also recommend that any change in the payroll allocation methodology be formalized in writing and incorporated into the accounting policies and procedures manual.

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 497034 2023-003
    Significant Deficiency
  • 497035 2023-004
    Significant Deficiency
  • 497036 2023-002
    Significant Deficiency Repeat
  • 497037 2023-003
    Significant Deficiency
  • 497038 2023-004
    Significant Deficiency
  • 497039 2023-005
    Significant Deficiency
  • 497040 2023-006
    Significant Deficiency
  • 497042 2023-004
    Significant Deficiency
  • 497043 2023-003
    Significant Deficiency
  • 497044 2023-004
    Significant Deficiency
  • 497045 2023-003
    Significant Deficiency
  • 497046 2023-004
    Significant Deficiency
  • 497047 2023-003
    Significant Deficiency
  • 497048 2023-004
    Significant Deficiency
  • 497049 2023-003
    Significant Deficiency
  • 497050 2023-004
    Significant Deficiency
  • 1073476 2023-003
    Significant Deficiency
  • 1073477 2023-004
    Significant Deficiency
  • 1073478 2023-002
    Significant Deficiency Repeat
  • 1073479 2023-003
    Significant Deficiency
  • 1073480 2023-004
    Significant Deficiency
  • 1073481 2023-005
    Significant Deficiency
  • 1073482 2023-006
    Significant Deficiency
  • 1073483 2023-003
    Significant Deficiency
  • 1073484 2023-004
    Significant Deficiency
  • 1073485 2023-003
    Significant Deficiency
  • 1073486 2023-004
    Significant Deficiency
  • 1073487 2023-003
    Significant Deficiency
  • 1073488 2023-004
    Significant Deficiency
  • 1073489 2023-003
    Significant Deficiency
  • 1073490 2023-004
    Significant Deficiency
  • 1073491 2023-003
    Significant Deficiency
  • 1073492 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
19.124 East Asia and Pacific Grants Program $515,454
19.345 International Programs to Support Democracy, Human Rights and Labor $225,324
19.901 Export Control and Related Border Security $140,949
19.017 Environmental and Scientific Partnerships and Programs $137,024
98.001 Usaid Foreign Assistance for Programs Overseas $76,096
19.026 Global Peace Operations Initiative $47,952
19.040 Public Diplomacy Programs $10,151