Finding 1096608 (2023-003)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2025-01-24
Audit: 339747
Auditor: Aprio LLP

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was not prepared correctly, missing a federal subaward and miscalculating award balances.
  • Impacted Requirements: Compliance with 2 CFR 200.510(b) was not met, leading to inaccuracies in the SEFA for the year ending September 30, 2023.
  • Recommended Follow-Up: Review all agreements to classify them correctly, establish written policies for SEFA preparation, and ensure calculations are supervised and verified against expected balances.

Finding Text

2023-003: Significant deficiency over preparation of the Schedule of Expenditures of Federal Awards Assistance listing number(s): All Agency: All Program: All Grant Year: 2023 Criteria: According to 2 CFR 200.510(b), the audit is responsible for the preparation of the Schedule of Expenditures of Federal Awards (SEFA). The SEFA must include, at a minimum, the information required by 2 CFR 200.510(b). Condition: One award was initially excluded from the Schedule of Expenditures of Federal Awards (SEFA) despite being a federal subaward. In addition, certain award balances were not correctly calculated by improperly excluding amounts already expended that will be reimbursed under the federal award, or improperly including amounts advanced and not yet expended. Cause: Balances on the schedule were calculated in-line with internal budgets rather than actual expenditures. Effect: The SEFA was not properly prepared for the year ended September 30, 2023. Questioned costs: There were no questioned costs related to this finding. Repeat finding: This is not a repeat finding. Auditor’s recommendation: We recommend all agreements be reviewed to determine whether they are grants or contracts. Written policies and procedures should detail how the SEFA gets compiled to ensure proper and complete information. The calculations on the SEFA should be reviewed and approved by a supervisor and compared against expected balances. Views of Responsible Officials and Corrective Action Plan (unaudited): See corrective action plan.

Categories

Reporting Subrecipient Monitoring Significant Deficiency

Other Findings in this Audit

  • 520162 2023-003
    Significant Deficiency
  • 520163 2023-003
    Significant Deficiency
  • 520164 2023-003
    Significant Deficiency
  • 520165 2023-003
    Significant Deficiency
  • 520166 2023-003
    Significant Deficiency
  • 520167 2023-003
    Significant Deficiency
  • 520168 2023-004
    Significant Deficiency
  • 1096604 2023-003
    Significant Deficiency
  • 1096605 2023-003
    Significant Deficiency
  • 1096606 2023-003
    Significant Deficiency
  • 1096607 2023-003
    Significant Deficiency
  • 1096609 2023-003
    Significant Deficiency
  • 1096610 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
98.001 Usaid Foreign Assistance for Programs Overseas $320,746
97.132 Financial Assistance for Countering Violent Extremism $237,902
19.701 Global Counterterrorism Programs $168,273
19.222 Trans-Sahara Counterterrorism Partnership (tsctp) $116,877
19.121 Conflict and Stabilization Operations $87,600
19.415 Professional and Cultural Exchange Programs - Citizen Exchanges $52,273