Finding 42114 (2022-001)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-03-27
Audit: 39575
Auditor: Rsm US LLP

AI Summary

  • Core Issue: The Federation improperly allocated staff salaries to a federal program based solely on budget estimates, violating federal documentation standards.
  • Impacted Requirements: Compliance with 2 CFR 200.430(i) is necessary, as charges must reflect actual work performed, supported by a reliable internal control system.
  • Recommended Follow-Up: Implement processes to ensure only staff working 100% on the grant are charged to the program, to avoid future noncompliance and potential funding loss.

Finding Text

Finding 2022-001 Budget Based Salary Allocation (Compliance and Control Finding) Repeat Finding No Federal Program Title U.S. Department of Health and Human Services 93.566 Refugee and Entrant Assistance State / Replacement Designee Administered Programs Contract Number FCSAK05984 Award Year 2021 ? 2022 Finding The Jewish Federation of Metropolitan Chicago (the Federation) allocated staff salaries to the federal program based on budget estimates, which alone does not qualify as support for charges to federal awards. Criteria 2 CFR 200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to federal awards, but may be used for interim accounting purposes, provided that the non-federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the federal award is accurate, allowable, and properly allocated. Condition The Federation allocated one employees? salary to the program based on a budgeted rate. Out of the 13 payments made to employees tested (five employees), two payments were based on an allocation of less than 100% (related to one employee during the grant year) to the program. All other employees tested have 100% of their salaries allocated to the program. Cause Per the Federation, the refugee program staff are the only government grant-funded staff within the organization making it infeasible to change the electronic time and attendance system which does not have a provision that allows time to be tracked by funding source. Beginning in FY23, the Federation only charges salaries to the program for staff that work 100% on this grant. Effect Noncompliance with federal regulations could result in the loss of future federal funding. Context We tested five employees whose salaries were applied to the federal program. For each employee selected, selected payroll related samples as a portion of our testing during the fiscal year. This finding was found during the review of the supporting documentation provided. Section III. Federal Awards Findings and Questioned Costs (Continued) Questioned Costs Total questioned costs were approximately $10,000 (allocated portion of the selected employee?s salary). Recommendation As the Federation does not have processes and controls in place for federal program time tracking, we recommend that only staff that allocate 100% of their time to the program be charged to the program. Views of Responsible Officials Management is in agreement with this finding. See corrective action plan.

Corrective Action Plan

FY 2022 Corrective Action Plan Audit Firm: RSM US LLP 30 South Wacker Drive, Suite 3300 Chicago, IL 60606 Audit Period: 07/01/2021 ? 06/30/2022 Contract Number: FCSAK05984 Award Year: 2021 ? 2022 Comments on Findings and Recommendations: Finding 2022-001?Budget Based Salary Allocation (Compliance and Control Finding)? The Jewish Federation of Metropolitan Chicago (the Federation) allocated staff salaries to the federal program based on budget estimates, which alone does not qualify as support for charges to federal awards. The Federation allocated one employees? salary to the program based on a budgeted rate. All other employees have 100% of their salaries allocated to the program. 2 CFR 200.430(i) Standards for Documentation of Personnel Expenses (1) Charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to federal awards, but may be used for interim accounting purposes, provided that the non-federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a federal award based on budget estimates. All necessary adjustment must be made such that the final amount charged to the federal award is accurate, allowable, and properly allocated. Action Taken?As the Federation does not have processes and controls in place for federal program time tracking, the Federation will only allocate staff to the program that spend 100% of their time on the program starting July 1, 2022. The required corrective action for Finding 2022-001 for the period 07/01/2021 ? 06/30/2022 was completed on July 1, 2022. The person responsible for completion of the corrective action plan was James Pinkston, Vice President, Accounting. James Pinkston Date Vice President, Accounting Jewish Federation of Metropolitan Chicago 30 South Wells Street, Chicago, IL 60606 Email: jamespinkston@juf.org

Categories

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

Other Findings in this Audit

  • 618556 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $2.50M
93.566 Refugee and Entrant Assistance State/ Replacement Designee Administered Programs $916,982
93.566 Refugee and Entrant Assistance_state Administered Programs $474,625
97.024 Emergency Food and Shelter National Board Program $122,741
97.008 Non-Profit Security Program $3,485