Finding 504883 (2022-005)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
$1
Year
2022
Accepted
2024-11-07

AI Summary

  • Core Issue: The County lacks a centralized process for maintaining grant accounting records, leading to a material misstatement in the Schedule of Expenditures of Federal Awards (SEFA).
  • Impacted Requirements: Noncompliance with Uniform Guidance and the Grant Accountability and Transparency Act (GATA) due to inadequate record-keeping and oversight.
  • Recommended Follow-Up: Provide training for accounting staff or hire qualified personnel, and enforce the policy requiring all grant records to be submitted to the County Treasurer for accurate reporting.

Finding Text

Material Weakness in Internal Control Over Grant Reporting Assistance Listing Numbers 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Program Federal Agency U.S. Department of Treasury Passthrough Agency Not applicable Award Number/Year 2022 Criteria The County is required to maintain a system of controls over the preparation of its Schedule of Expenditures of Federal Awards (SEFA) per the Uniform Guidance at 2 CFR 200.510(b) and its Consolidated Year-End Financial Report (CYEFR) in compliance with the 30 ILCS 708/1 Grant Accountability and Transparency Act (GATA). Condition The County did not have a centralized process for maintaining its grant accounting records and related supporting documentation to ensure that all federal grants expenditures were included on its SEFA and to ensure that all state grant expenditures were included on its CYEFR for fiscal year 2022. The County’s expenditures totaling $499,973 for its CSLFRF program were not included in its original SEFA which resulted in the SEFA being materially misstated. Additionally, it appears that certain offices and departments are noncompliant with the County’s financial policy that requires that all financial accounting records and related supporting documentation be provided to the County Treasurer so that the County Treasurer can maintain a complete set of grant accounting records for the entire County. Cause The County does not have internal personnel or contracted personnel with the requisite knowledge and experience to prepare its SEFA and CYEFR. Additionally, offices and departments within the County that receive and administer grants maintain the grant accounting records and related supporting documentation independent of the County Treasurer. These offices and departments provide the grant expenditures that are included in the CYEFR but do not consistently provide the detailed grant accounting records for use to prepare the SEFA and CYEFR. Effect Allowing these conditions to persist puts the County, its management and the Board of Commissioners at risk of 1) material misstatements being included in the County’s SEFA and CYEFR without being detected and noncompliance with grant agreements. These conditions could also result in a suspension of funding from grant funding sources, investigations of potential abuse and/or misappropriation of grant funds, and orders to return grant funds. Recommendation We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County. Questioned Costs None noted. Repeat Finding Yes. This finding also occurred in 2020 (2020-003) and 2019 (2019-002). Views of Responsible Officials and Planned Corrective Actions See corrective action plan.

Corrective Action Plan

We recommend that management either 1) provide training for its key accounting personnel so that they will be able to prepare SEFA and CYEFR for the County and/or 2) contract with an accountant or firm that has the relevant skills, knowledge and experience to prepare the SEFA and CYEFR. We further recommend that the Board of Commissioners enforce the County’s policy of requiring that all accounting records and related supporting documentation be made available to the County Treasurer so that there is a process in which all of the County’s financial activity pertaining to grants is compiled, reconciled and included in a complete set of grant financial reports utilized to prepare the SEFA and CYEFR for the County.

Categories

Questioned Costs Reporting

Other Findings in this Audit

  • 504882 2022-004
    Material Weakness Repeat
  • 504884 2022-006
    Material Weakness
  • 504885 2022-004
    Material Weakness Repeat
  • 504886 2022-005
    Material Weakness Repeat
  • 504887 2022-006
    Material Weakness
  • 504888 2022-004
    Material Weakness Repeat
  • 504889 2022-005
    Material Weakness Repeat
  • 504890 2022-006
    Material Weakness
  • 504891 2022-004
    Material Weakness Repeat
  • 504892 2022-005
    Material Weakness Repeat
  • 504893 2022-006
    Material Weakness
  • 504894 2022-004
    Material Weakness Repeat
  • 504895 2022-005
    Material Weakness Repeat
  • 504896 2022-006
    Material Weakness
  • 504897 2022-004
    Material Weakness Repeat
  • 504898 2022-005
    Material Weakness Repeat
  • 504899 2022-006
    Material Weakness
  • 504900 2022-004
    Material Weakness Repeat
  • 504901 2022-005
    Material Weakness Repeat
  • 504902 2022-006
    Material Weakness
  • 504903 2022-004
    Material Weakness Repeat
  • 504904 2022-005
    Material Weakness Repeat
  • 504905 2022-006
    Material Weakness
  • 504906 2022-004
    Material Weakness Repeat
  • 504907 2022-005
    Material Weakness Repeat
  • 504908 2022-006
    Material Weakness
  • 504909 2022-004
    Material Weakness Repeat
  • 504910 2022-005
    Material Weakness Repeat
  • 504911 2022-006
    Material Weakness
  • 504912 2022-004
    Material Weakness Repeat
  • 504913 2022-005
    Material Weakness Repeat
  • 504914 2022-006
    Material Weakness
  • 504915 2022-004
    Material Weakness Repeat
  • 504916 2022-005
    Material Weakness Repeat
  • 504917 2022-006
    Material Weakness
  • 1081324 2022-004
    Material Weakness Repeat
  • 1081325 2022-005
    Material Weakness Repeat
  • 1081326 2022-006
    Material Weakness
  • 1081327 2022-004
    Material Weakness Repeat
  • 1081328 2022-005
    Material Weakness Repeat
  • 1081329 2022-006
    Material Weakness
  • 1081330 2022-004
    Material Weakness Repeat
  • 1081331 2022-005
    Material Weakness Repeat
  • 1081332 2022-006
    Material Weakness
  • 1081333 2022-004
    Material Weakness Repeat
  • 1081334 2022-005
    Material Weakness Repeat
  • 1081335 2022-006
    Material Weakness
  • 1081336 2022-004
    Material Weakness Repeat
  • 1081337 2022-005
    Material Weakness Repeat
  • 1081338 2022-006
    Material Weakness
  • 1081339 2022-004
    Material Weakness Repeat
  • 1081340 2022-005
    Material Weakness Repeat
  • 1081341 2022-006
    Material Weakness
  • 1081342 2022-004
    Material Weakness Repeat
  • 1081343 2022-005
    Material Weakness Repeat
  • 1081344 2022-006
    Material Weakness
  • 1081345 2022-004
    Material Weakness Repeat
  • 1081346 2022-005
    Material Weakness Repeat
  • 1081347 2022-006
    Material Weakness
  • 1081348 2022-004
    Material Weakness Repeat
  • 1081349 2022-005
    Material Weakness Repeat
  • 1081350 2022-006
    Material Weakness
  • 1081351 2022-004
    Material Weakness Repeat
  • 1081352 2022-005
    Material Weakness Repeat
  • 1081353 2022-006
    Material Weakness
  • 1081354 2022-004
    Material Weakness Repeat
  • 1081355 2022-005
    Material Weakness Repeat
  • 1081356 2022-006
    Material Weakness
  • 1081357 2022-004
    Material Weakness Repeat
  • 1081358 2022-005
    Material Weakness Repeat
  • 1081359 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $499,973
20.106 Airport Improvement Program $45,000
20.205 Highway Planning and Construction $8,410
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $7,282
66.032 State Indoor Radon Grants $6,065
93.268 Immunization Cooperative Agreements $3,000
20.509 Formula Grants for Rural Areas and Tribal Transit Program $371