Finding 498087 (2023-001)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-09-24

AI Summary

  • Core Issue: NWICA failed to reconcile grant revenue by December 31, 2023, leading to necessary audit adjustments.
  • Impacted Requirements: This situation violates Uniform Guidance 200.302(b)(4), which mandates effective control over funds and assets.
  • Recommended Follow-Up: Management should establish procedures for timely reconciliation and accurate recording of revenue.

Finding Text

Revenue recognition Criteria or Specific Requirement: Uniform Guidance 200.302(b)(4) states each non-federal entity must provide for “effective control over, and accountability for, all funds, property, and other assets.” Condition: Northwest Indiana Community Action Corporation (NWICA), did not reconcile its grant revenue as of December 31, 2023, which resulted in audit adjustments to revenue and receivable accounts. Effect: A significant deficiency in internal control over financial reporting exists due to audit adjustments posted during the audit to grant revenue and receivables. Cause: Historical revenue recognition practices were not carried through at year end due to a change in fiscal personnel. Auditor's Recommendation: Management should implement procedures to ensure revenue is properly reconciled and recorded in a timely manner. Audit finding 2023-001 represents a significant deficiency in internal control over compliance for Northwest Indiana Community Action Corporation's major federal programs. Questioned Costs: None Federal Program Information: Funding agency:Department of Health and Human Services Passed through:Indiana State Department of Health Title:Special Supplemental Nutrition Program for Women, Infants, and Children AL number:10.557 Award number:65247 and 77352 Funding agency:Department of Health and Human Services Passed through:Indiana Housing & Community Development Authority Title:Low-Income Home Energy Assistance AL number:93.568 Award number:WL-023-018, LI-023-018, LI-ES-023-018,and LI-024-018 Funding agency:Department of Health and Human Services Passed through:Indiana Family and Social Services Administration Title:Social Services Block Grant AL number:93.667 Award number:69746 and 59326

Corrective Action Plan

Synopsis of Finding: Northwest Indiana Community Action Corporation (NWICA) DBA - CoAction, did not reconcile all grant revenue as of December 31, 2023, which resulted in audit adjustments to revenue and receivable accounts identified during the audit. Effect: A significant deficiency in internal control over financial reporting exists due to audit adjustments posted during the audit to grant revenue and receivables. Management’s Response: Northwest Indiana Community Action Corporation (NWICA) DBA - CoAction concurs with the 2023-001: Revenue Recognition finding. NWICA/CoAction has taken the steps to address this finding by implementing processes to ensure all revenue is recorded and reconciled monthly by hiring new leadership and staff within the Finance department. The finance department is taking specific action to monitor grant revenue and expense activity monthly, reconcile quarterly, and clos out activity at each grant’s year end. The organization also continues to work on improving the timeliness of grant claim submissions. Contact Person Responsible for Corrective Action: Jonathan Edwards Anticipated Completion Date: December 31, 2024

Categories

Reporting Significant Deficiency Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 498088 2023-001
    Significant Deficiency
  • 498089 2023-001
    Significant Deficiency
  • 1074529 2023-001
    Significant Deficiency
  • 1074530 2023-001
    Significant Deficiency
  • 1074531 2023-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.568 Low-Income Home Energy Assistance $10.79M
14.871 Section 8 Housing Choice Vouchers $6.85M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $3.59M
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $2.26M
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $1.60M
93.667 Social Services Block Grant $1.06M
93.052 National Family Caregiver Support, Title Iii, Part E $781,692
93.569 Community Services Block Grant $781,451
93.778 Medical Assistance Program $714,448
94.016 Senior Companion Program $195,000
93.044 Covid-19 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $178,565
81.042 Weatherization Assistance for Low-Income Persons $123,239
21.009 Volunteer Income Tax Assistance (vita) Matching Grant Program $108,475
93.053 Nutrition Services Incentive Program $90,192
94.011 Foster Grandparent Program $77,713
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $68,706
93.045 Covid-19 Special Programs for the Aging_title Iii, Part C_nutrition Services $62,334
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $25,961
93.958 Block Grants for Community Mental Health Services $23,392
93.043 Covid-19 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $1,030