Finding 23221 (2022-001)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-09-28
Audit: 26237
Organization: City of Berwyn, Illinois (IL)

AI Summary

  • Core Issue: The City lacks detailed records linking invoices to specific federal projects, making it difficult to verify expenditures for the Clean Water and Drinking Water programs.
  • Impacted Requirements: Internal controls over allowable costs are not properly maintained, risking misallocation of funds between the two federal programs.
  • Recommended Follow-Up: The City should update its accounting system to ensure each award's expenditures are clearly supported by detailed invoice listings.

Finding Text

Finding 2022-001: Allowable Costs/Activities Allowed Federal Award and Specific Award Identification: U.S. Environmental Protection Agency Clean Water State Revolving Fund Cluster - Assistance Listing # 66.458 Drinking Water State Revolving Fund Cluster - Assistance Listing # 66.468 Criteria: Proper internal controls over allowable costs and allowable activities include the maintenance of detailed records that provide for easy reconciliation of supporting invoices to amounts reported as expenditures of federal awards for each federal program. Statement of Condition: The City received awards under two federal programs - the Clean Water State Revolving Fund Cluster and the Drinking Water State Revolving Fund Cluster ? both of which were passed through the Illinois Environmental Protection Agency (?IEPA?). The funds were to be used for two projects occurring simultaneously. One was the replacement of water mains and lead service lines in the City and the other was for sewer system improvements. While supporting invoices and other necessary documentation, which we examined, were provided to the IEPA who approved disbursement under the specific federal programs, the City was unable to provide us with a detailed listing of which invoices related to which project. Cause The recordkeeping issues were a result of the City not summarizing and organizing the detailed information provided to the State of Illinois for reimbursement purposes in a manner that was readily auditable by federal program. Effect The specific invoices comprising federal expenditures under each of the two federal programs could not be readily determined from the documentation maintained by the City. While invoices supported the total expenditures of the two federal programs, there is a risk that costs intended to be paid for by one federal program could be paid for by the other in error. Questioned Costs None identified. Recommendation We recommend that the City make the necessary changes with their existing accounting system and procedures to ensure that expenditures for each award are supported by a detailed listing of invoices that total the program expenditures reported on the schedule of expenditures of federal awards. Management Response See corrective action plan.

Corrective Action Plan

September 28, 2023 John Wysocki Partner GW & Associates PC 4415 West Harrison, Suite 434 Hillside, IL 60162 Re: Finding 2022-001: Controls of Financial Reporting- Illinois Environment Protection (IEPA) Loan Program Dear John, Please find our corrective action plan explained below related to finding 2022-001. Corrective Action Plan: The City will produce the reporting recommended in the finding which includes a detailed listing of invoices related to each Federal project. As noted in the finding, the City had organized and reported IEPA loan contractor expenditures in compliance with Illinois state regulations. However, the supporting documentation for these expenditures should also have been organized and prepared for review by Auditors in accordance with Federal guidelines. Going forward, the City will process and organize future IEPA contractor invoices and documentation according to both State and Federal grant requirements and provide the necessary reports needed for audit. Responsible Person: Finance Director, Ben Daish; Public Works Director, Robert Schiller Expected Completion Date: Fall 2023 through Spring 2023 Respectfully Submitted Ben Daish Finance Director

Categories

Allowable Costs / Cost Principles Cash Management Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 23222 2022-001
    Significant Deficiency
  • 599663 2022-001
    Significant Deficiency
  • 599664 2022-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
66.458 Capitalization Grants for Clean Water State Revolving Funds $5.30M
66.468 Capitalization Grants for Drinking Water State Revolving Funds $3.81M
14.218 Community Development Block Grants/entitlement Grants $1.73M
21.027 Coronavirus State and Local Fiscal Recovery Funds $563,709
20.600 State and Community Highway Safety $181,754
16.922 Equitable Sharing Program $179,089
20.616 National Priority Safety Programs $61,656
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $10,018