Finding 1173304 (2023-006)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2026-02-11

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 due to inadequate internal controls and lack of training on SEFA reporting.
  • Recommended Follow-Up: Enhance training on SEFA requirements, implement a review process for compliance, and ensure accurate reconciliation of federal expenditures.

Finding Text

Finding 2023 – 006: Reporting - Preparation of the Schedule of Expenditures of Federal Awards (SEFA) (Repeat Finding: 2021-007 and 2022-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 2023, 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

2023 – 006: Reporting - Preparation of the Schedule of Expenditures of Federal Awards (SEFA) (Repeat Finding: 2021-007 and 2022-006) Condition: During fiscal year 2023, 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. Corrective Action Plan: As of October 1, 2024, the start of FY25 QuickBooks has been the only software used, and Revenue and Disbursements are being classed by Fund. General ledgers are now reconciled monthly. Each grant will have its own folder and required information to assure an accurate SEFA can be completed will be included. Management will reconcile SEFA amounts to the general ledger and review federal agency names and assistance listing numbers against grant documentation.

Categories

Reporting

Other Findings in this Audit

  • 1173297 2023-003
    Material Weakness Repeat
  • 1173298 2023-003
    Material Weakness Repeat
  • 1173299 2023-004
    Material Weakness Repeat
  • 1173300 2023-004
    Material Weakness Repeat
  • 1173301 2023-005
    Material Weakness Repeat
  • 1173302 2023-005
    Material Weakness Repeat
  • 1173303 2023-006
    Material Weakness Repeat
  • 1173305 2023-007
    Material Weakness Repeat
  • 1173306 2023-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.U01 TITLE V, URBAN INDIAN HEALTH SERVICES $4.83M
93.237 SPECIAL DIABETES PROGRAM FOR INDIANS DIABETES PREVENTION AND TREATMENT PROJECTS $639,675
93.933 DEMONSTRATION PROJECTS FOR INDIAN HEALTH $491,571
93.391 ACTIVITIES TO SUPPORT STATE, TRIBAL, LOCAL AND TERRITORIAL (STLT) HEALTH DEPARTMENT RESPONSE TO PUBLIC HEALTH OR HEALTHCARE CRISES $20,308
93.800 ORGANIZED APPROACHES TO INCREASE COLORECTAL CANCER SCREENING $13,837
93.217 FAMILY PLANNING SERVICES $541