Finding 1161745 (2024-003)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2025-11-03

AI Summary

  • Core Issue: Inadequate records for payroll costs led to improper charges to federal grants, with 42 out of 80 transactions lacking formal timesheets.
  • Impacted Requirements: Compliance with federal regulations on documentation of personnel expenses was not met, risking inaccurate payroll allocations.
  • Recommended Follow-Up: Establish a review process for payroll expenditures to ensure they reflect actual work performed and maintain proper documentation for all transactions.

Finding Text

Finding 2024-003 – Activities Allowed/Allowable Costs Type of Finding: Material weakness over controls over compliance and noncompliance Federal Agency: U.S. Department of Treasury & U.S. Department of Health and Human Services Federal Program: Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 and Refugee and Entrant Assistance State/Replacement Designee Administered Program – ALN 93.566 Criteria: An organization should have a strong system of internal control that includes review of general disbursements and payroll transactions for proper classification and allowability in accordance with the terms and conditions of the award agreements and federal regulations. Uniform Guidance section 200.430, paragraph (i) standards for documentation of personnel expenses requires that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These 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 percent of compensated activities; (iv) encompass both federally assisted and all other activities compensated by the nonfederal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-federal entity’s written policy; (vi) comply with the established accounting policies and practices of the non-federal entity; (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; and (viii) budget estimates alone do not qualify as support for charges to federal awards but may be used for interim accounting purposes. Condition and Context: Salaries and wages of employees charged or allocated to the grant were not all supported by formal records that accurately reflected the work performed. During our testing of eighty payroll transactions, we noted forty-two transactions had no formal timesheets and the Organization recorded amounts based on budgeted estimates rather than actual amounts. Questioned Costs: The payroll transactions selected for testing but were without timesheets amounted to $122,990. $32,370 was charged to ALN 93.566 and $90,620 was charged to ALN 21.027. Cause: For certain employees and periods payroll costs charged to the grants were approximated for budgetary purposes which was utilized for reporting; however, a subsequent review of time and effort for the individuals allocated to the grant and evaluation of allowability of costs incurred was not performed, which resulted in inaccurate amounts charged to the grant. Effect or Potential Effect: Because the actual time spent by certain employees was not appropriately charged to the grant, the amounts charged to the grant could be under or overcharged and unallowable. Identification as a Repeat Finding: 2023-001 Recommendation: We recommend the Organization implement a process and related controls related to review and approval of payroll expenditures for allowability in accordance with the terms of the grant award and federal regulations. Payroll amounts charged to the grant should be based on actual time and effort reported by the employee working on the grant and related documentation maintained by the Organization to support those amounts. The Organization should implement a review process over recording time and effort for payroll transactions, for proper classification and allowability.

Corrective Action Plan

The organization acknowledges that time and effort procedures were not consistently followed throughout FY24. The organization has implemented a new system of reporting designed to capture time and effort of all employees charged to government grant and contracts, as well as other grants and contracts awarded to the agency from the philanthropic community. Additionally, along with the timesheet, the agency now requires that an attestation statement is prepared quarterly by Program Managers and Directors for all employees charged to grants to attest to the actual amount of time spent and allocated to the grants. The organization has expanded administrative oversite of the finance department and financial data and has hired a Finance Director who has spent a considerable amount of time training staff and managers regarding their allocations and their obligations to track their time. The Finance Director has trained our expanded finance team on ensuring that accounting policies and procedures are strictly adhered to and that GAAP is uniformly applied to all financial data of the agency.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1161734 2024-002
    Material Weakness Repeat
  • 1161735 2024-002
    Material Weakness Repeat
  • 1161736 2024-002
    Material Weakness Repeat
  • 1161737 2024-002
    Material Weakness Repeat
  • 1161738 2024-002
    Material Weakness Repeat
  • 1161739 2024-002
    Material Weakness Repeat
  • 1161740 2024-003
    Material Weakness Repeat
  • 1161741 2024-003
    Material Weakness Repeat
  • 1161742 2024-003
    Material Weakness Repeat
  • 1161743 2024-003
    Material Weakness Repeat
  • 1161744 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
19.510 U.S. REFUGEE ADMISSIONS PROGRAM $734,297
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $730,873
93.567 REFUGEE AND ENTRANT ASSISTANCE_VOLUNTARY AGENCY PROGRAMS $618,815
16.575 CRIME VICTIM ASSISTANCE $559,756
17.258 WIA ADULT PROGRAM $220,139
17.278 WIA DISLOCATED WORKER FORMULA GRANTS $220,139
97.010 CITIZENSHIP EDUCATION AND TRAINING $208,348
93.566 REFUGEE AND ENTRANT ASSISTANCE_STATE ADMINISTERED PROGRAMS $165,580
93.576 REFUGEE AND ENTRANT ASSISTANCE_DISCRETIONARY GRANTS $80,000
16.524 LEGAL ASSISTANCE FOR VICTIMS $69,301
97.024 EMERGENCY FOOD AND SHELTER NATIONAL BOARD PROGRAM $46,120