Finding 1205009 (2024-004)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-03-30

AI Summary

  • Core Issue: There is a significant deficiency in reconciling contract expenditures for the Schedule of Expenditures of Federal Awards (SEFA).
  • Impacted Requirements: Income statements must fully comply with GAAP, including all necessary components like prepaid expenses and program income, to ensure accurate SEFA disclosure.
  • Recommended Follow-Up: Implement a monthly grand bridging report to track differences between contract revenues and expenses, ensuring expenditures align with contract income statements.

Finding Text

SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS – significant dificiency. The books and records support the preparation of the Schedule of Expenditures of Federal Awards. A separate income statement is maintained for each cost reimbursement Federal award; however, contract expenditures require significant reconciliation in order to determine the expenditures required to be disclosed in the SEFA. Reconciliation of the respective income statements for each Federal award is required for SEFA disclosure, with unreconciled differences. The income statements should include full GAAP accounting including prepaid expenses, accrued expenses, unbilled receivables, additional indirect costs, program income, and other differences. The surplus and deficit should be nearly zero for each cost reimbursement contract. It is a best practice to utilize a grand bridging report monthly (based on the contract income statements) to understand any differences between contract revenues and expenses (for cost reimbursement contracts) as well as progress against grant budgets. Expenditures of federal awards should agree to each contract income statement.

Corrective Action Plan

Finding 2024-04 Schedule of Expenditures of Federal Awards. Management concurs with the finding. IHS will be working with the new outside CPA firm to develop a grant bridging report beginning FY2025/26.

Categories

Reporting Cash Management Program Income

Other Findings in this Audit

  • 1205006 2024-001
    Material Weakness Repeat
  • 1205007 2024-002
    Material Weakness Repeat
  • 1205008 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $682,939
93.778 GRANT TO STATE FOR MEDICAID $141,972
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $107,966
93.043 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART D, DISEASE PREVENTION AND HEALTH PROMOTION SERVICES $95,745
93.391 ACTIVITIES TO SUPPORT STATE, TRIBAL, LOCAL AND TERRITORIAL (STLT) HEALTH DEPARTMENT RESPONSE TO PUBLIC HEALTH OR HEALTHCARE CRISES $91,971
93.045 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART C, NUTRITION SERVICES $61,865
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $33,271
93.052 NATIONAL FAMILY CAREGIVER SUPPORT, TITLE III, PART E $25,242