Finding 1078217 (2023-006)

Material Weakness Repeat Finding
Requirement
C
Questioned Costs
$1
Year
2023
Accepted
2024-10-04
Audit: 323864
Organization: Sangamon County, Illinois (IL)

AI Summary

  • Core Issue: There is a significant weakness in internal controls over cash management, leading to material noncompliance with federal requirements.
  • Impacted Requirements: The County failed to maintain necessary documentation for cash drawdown requests and did not minimize the time between receiving and disbursing federal funds.
  • Recommended Follow-Up: Implement controls to ensure accurate reconciliation of accounting records to reimbursement requests, and retain documentation of reviews and approvals by someone other than the preparer.

Finding Text

2023 – 006 Cash Management Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Low-Income Home Energy Assistance Program (LIHEAP) Assistance Listing Number: 93.568 Federal Award Identification Number and Year: G-2202ILLIEA 10/1/2021; G-2202ILLIEA 10/1/2021; G-2302ILLIEA 10/1/2022; 2102ILLWCS 5/28/2021 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 22-221038; 22-224038; 23-224038; 21-233038 Award Period: June 1, 2022 through September 30, 2023, October 1, 2021 through June 30, 2023, October 1, 2022 through June 30, 2024, and September 1, 2021 through August 31, 2023 Type of Finding: • Material Weakness in Internal Control over Compliance • Material Noncompliance (Modified Opinion) Criteria or specific requirement: Uniform Grant Guidance (2 CFR 200.303) requires non-federal entities receiving Federal awards establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Uniform Grant Guidance (2 CFR 200.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds. Effective internal controls should include ensuring the reimbursement request are supported by documentation of expenditures that been incurred. Additionally, the time between receiving and disbursing federal funds should be minimized and interest should be calculated on amounts of unearned revenue. Condition: Supporting documentation for the cash drawdown requests were not maintained. There were instances in which the accounting records did not agree to the grant reimbursement request. The time between receiving and disbursing federal funds was not minimized and interest on unearned revenue was not calculated. Documentation of review and approval of the reimbursement request by an individual other than the preparer was not retained. Questioned costs: $1,237,948 Context: 8 of 8 cash reimbursement requests tested did not have supporting documentation of the exact amount received maintained. Cause: Support for the reimbursement request could not be provided over the individual cash request as it was not retained. Adjustments made to the project accounting records after the cash reimbursement request were made caused the County to receive more funds than expenses incurred on specific grants. Effect: Lack of proper documentation for reported information can lead to an over or under reimbursement of grant funds. Repeat Finding: This is a repeat finding. Prior year finding number was 2022-006. Recommendation: We recommend the County design controls to ensure the accounting records reconcile to the reimbursement request and documentation be retained. Reconciliations should be reviewed and approved by an individual other than the preparer at the time of the request and this documentation should be retained. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Questioned Costs Cash Management

Other Findings in this Audit

  • 501770 2023-003
    Significant Deficiency Repeat
  • 501771 2023-004
    Significant Deficiency Repeat
  • 501772 2023-006
    Material Weakness Repeat
  • 501773 2023-007
    Material Weakness Repeat
  • 501774 2023-005
    Material Weakness Repeat
  • 501775 2023-006
    Material Weakness Repeat
  • 501776 2023-007
    Material Weakness Repeat
  • 501777 2023-005
    Material Weakness Repeat
  • 501778 2023-006
    Material Weakness Repeat
  • 501779 2023-007
    Material Weakness Repeat
  • 501780 2023-006
    Material Weakness Repeat
  • 501781 2023-007
    Material Weakness Repeat
  • 1078212 2023-003
    Significant Deficiency Repeat
  • 1078213 2023-004
    Significant Deficiency Repeat
  • 1078214 2023-006
    Material Weakness Repeat
  • 1078215 2023-007
    Material Weakness Repeat
  • 1078216 2023-005
    Material Weakness Repeat
  • 1078218 2023-007
    Material Weakness Repeat
  • 1078219 2023-005
    Material Weakness Repeat
  • 1078220 2023-006
    Material Weakness Repeat
  • 1078221 2023-007
    Material Weakness Repeat
  • 1078222 2023-006
    Material Weakness Repeat
  • 1078223 2023-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $8.67M
93.568 Low-Income Home Energy Assistance $1.88M
93.569 Community Services Block Grant $561,099
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $275,103
16.575 Crime Victim Assistance $233,299
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $214,084
17.258 Wioa Adult Program $209,362
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $200,707
17.278 Wioa Dislocated Worker Formula Grants $166,793
20.205 Highway Planning and Construction $132,436
93.788 Opioid Str $127,575
20.509 Formula Grants for Rural Areas and Tribal Transit Program $127,026
93.667 Social Services Block Grant $126,494
17.259 Wioa Youth Activities $102,440
21.032 Local Assistance and Tribal Consistency Fund $100,000
93.959 Block Grants for Prevention and Treatment of Substance Abuse $97,263
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $86,487
81.042 Weatherization Assistance for Low-Income Persons $85,023
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $68,972
16.922 Equitable Sharing Program $68,099
93.069 Public Health Emergency Preparedness $43,555
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $29,881
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $16,656
93.994 Maternal and Child Health Services Block Grant to the States $13,885
93.563 Child Support Services $13,672
97.042 Emergency Management Performance Grants $10,003
20.616 National Priority Safety Programs $2,132
10.553 School Breakfast Program $1,003
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000
66.605 Performance Partnership Grants $888
93.268 Immunization Cooperative Agreements $769