Finding 1226471 (2024-006)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2026-08-13

AI Summary

  • Core Issue: The Organization failed to prepare an accurate Schedule of Expenditures of Federal Awards (SEFA), leading to discrepancies with grant agreements.
  • Impacted Requirements: Noncompliance with Uniform Guidance 2 CFR § 200.510, which mandates accurate reporting of federal awards and internal controls.
  • Recommended Follow-Up: Improve training on SEFA requirements, implement a review process for compliance, and ensure accurate reconciliation of federal expenditures.

Finding Text

Finding 2024 – 006: Reporting - Preparation of the Schedule of Expenditures of Federal Awards (SEFA) (Repeat Finding: 2021-007, 2022-006, and 2023-006) Criteria: Uniform Guidance 2 CFR § 200.510 requires an auditee to "prepare a schedule of expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements [that]… at a minimum shall… list individual Federal programs by Federal agency... [and] provide total Federal awards expenditures for each individual Federal program and the Assistance Listing number or other identifying number when the ALN information is not available." In accordance with Uniform Guidance, the auditee is required to maintain a structure of internal controls to ensure compliance with applicable reporting requirements. Condition: During fiscal year 2024, the Organization did not have adequate controls in place to ensure the SEFA accurately reflected each award's federal agency and assistance listing number. There were differences between the SEFA and the grant agreements/compliance supplements, requiring adjustments to the SEFA. Questioned Costs: None. Cause: A lack of sufficient training or understanding of Uniform Guidance requirements, particularly related to SEFA reporting elements, contributed to this finding. Effect: The Organization was unable to produce an accurate and timely SEFA, requiring additional effort and resources from both the Organization and the auditor to correct reporting errors during the audit process. Failure to produce an accurate SEFA resulted in noncompliance with requirements of Uniform Guidance which could lead to sanctions by funding agencies and curtailment of future funding. Recommendation: We recommend the Organization enhance its understanding of SEFA reporting requirements under Uniform Guidance, develop and implement a structured review process to ensure compliance with those reporting requirements, reconcile federal expenditures reported on the SEFA to the amounts recorded in the general ledger, and review federal agency names and assistance listing numbers against grant documentation to ensure accuracy. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.

Corrective Action Plan

Finding 2024-006: Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Repeat Finding (2021-007, 2022-006, 2023-006) Condition: Controls were not adequate to ensure the SEFA accurately reflected each award's federal agency and Assistance Listing Number; differences existed between the SEFA and the underlying grant agreements/compliance supplements, requiring adjustment. Corrective Action: • Develop a standard SEFA preparation workpaper, to be used jointly with the Organization's outsourced accounting firm, that reconciles each federal award line to the general ledger and to the executed grant agreement/Notice of Award. • Establish a defined handoff process with the outsourced accounting firm sothe CFO receives the draft SEFA with sufficient lead time to review it internally before submission to the auditor. • Verify federal agency name and Assistance Listing Number for each award directly against grant documentation before submission. • Require a documented second-level review of the SEFA by the CFO, in addition to the outsourced firm's preparation, prior to issuance to the auditor. • Provide trainingto both the outsourced firm's preparer and internalfinance staff on Uniform Guidance §200.510 SEFA requirements. Responsible Party: Chief Financial Officer (in coordination with the Organization's outsourced accounting firm) Anticipated Completion Date: SEFA preparation workpaper and CFO review process adopted by December 1, 2026; in effect for the FY25 SEFA

Categories

Reporting

Other Findings in this Audit

  • 1226464 2024-003
    Material Weakness Repeat
  • 1226465 2024-003
    Material Weakness Repeat
  • 1226466 2024-004
    Material Weakness Repeat
  • 1226467 2024-004
    Material Weakness Repeat
  • 1226468 2024-005
    Material Weakness Repeat
  • 1226469 2024-005
    Material Weakness Repeat
  • 1226470 2024-006
    Material Weakness Repeat
  • 1226472 2024-007
    Material Weakness Repeat
  • 1226473 2024-007
    Material Weakness Repeat
  • 1226474 2024-008
    Material Weakness Repeat
  • 1226475 2024-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.U01 TITLE V, URBAN INDIAN HEALTH SERVICES $3.17M
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $431,850
93.653 INDIAN HEALTH SERVICE DOMESTIC VIOLENCE PREVENTION PROGRAMS $240,383
93.933 DEMONSTRATION PROJECTS FOR INDIAN HEALTH $208,333
93.391 ACTIVITIES TO SUPPORT STATE, TRIBAL, LOCAL AND TERRITORIAL (STLT) HEALTH DEPARTMENT RESPONSE TO PUBLIC HEALTH OR HEALTHCARE CRISES $150,078
93.332 COOPERATIVE AGREEMENT TO SUPPORT NAVIGATORS IN FEDERALLY-FACILITATED EXCHANGES $87,942
93.318 PROTECTING AND IMPROVING HEALTH GLOBALLY: BUILDING AND STRENGTHENING PUBLIC HEALTH IMPACT, SYSTEMS, CAPACITY AND SECURITY $30,465
93.800 ORGANIZED APPROACHES TO INCREASE COLORECTAL CANCER SCREENING $20,000
93.217 FAMILY PLANNING SERVICES $5,694