Finding 404749 (2023-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-06-30

AI Summary

  • Core Issue: NDRN struggled to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA), leading to incomplete reporting.
  • Impacted Requirements: Compliance with 2 CFR 200.508 and 200.510, which mandate accurate financial statements and effective internal controls over Federal awards.
  • Recommended Follow-Up: Implement internal controls to ensure all Federal awards are properly identified and tracked to improve accuracy in reporting.

Finding Text

Finding 2023-003: Preparation of Schedule of Expenditures of Federal Awards (SEFA) Information on the Federal Programs: All Criteria: As noted in 2 CFR 200.508 “Auditee Responsibilities” indicates that the auditee must prepare appropriate financial statements, including the Schedule of Expenditures of Federal Awards (as specifically defined under 2 CFR 200.510 “Financial statements”). Title 2 CFR 200 Section 200.510 “Financial Statements” requires recipients of Federal funds to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements, which must include the total Federal awards expended. Additionally, in accordance with CFR 200.303, the non- Federal entity must: establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. Condition: NDRN experienced difficulty in preparing and ensuring that all Federal expenditures were identified, categorized, and included in the Schedule of Expenditures of Federal Awards. The preparation of NDRN's SEFA required manual adjustments of Federal costs. We noted that the manual adjustments were not completed prior to the start of the audit. Cause: The year-end close process did not provide for the preparation of a complete and accurate schedule of expenditures of Federal awards. Effect: Without periodic training and consistent application of NDRN’s internal policies and procedures, this could potentially result in unreliable and erroneous grant reporting, internal record keeping and decision making. Questioned Costs: None noted. Context: Our audit testwork consisted of substantive procedures over the SEFA. We determined that the issue was systemic in nature. Identification as a Repeat Finding: Not applicable. Recommendation: We recommend NDRN establish internal controls to correctly identify and track all Federal awards received either directly or indirectly.

Corrective Action Plan

Views of Responsible Officials: NDRN’s finance staff turnover, coupled with the staff’s lack of formal training with NDRN’s accounting system, resulted in a lack of knowledge on how to prepare the actual schedule. However, it did not affect the staff’s ability to properly identify and categorize expenditures for invoicing purposes to the Federal government. Moving forward, NDRN finance fiscal staff will conduct regular internal SEFA reporting as part of the monthly reporting indicated in Finding 2023-002 above.

Categories

Reporting

Other Findings in this Audit

  • 404750 2023-003
    Significant Deficiency
  • 404751 2023-003
    Significant Deficiency
  • 404752 2023-003
    Significant Deficiency
  • 404753 2023-003
    Significant Deficiency
  • 981191 2023-003
    Significant Deficiency
  • 981192 2023-003
    Significant Deficiency
  • 981193 2023-003
    Significant Deficiency
  • 981194 2023-003
    Significant Deficiency
  • 981195 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.000 Technical Assistance for Protection and Advocacy Agencies $2.62M
96.009 Social Security State Grants for Work Incentives Assistance to Disabled Beneficiaries $1.28M
84.246 Rehabilitation Short-Term Training $308,000
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $25,000
97.044 Assistance to Firefighters Grant $5,428