Audit 316258

FY End
2021-04-30
Total Expended
$2.55M
Findings
8
Programs
5
Organization: City of Pekin (IL)
Year: 2021 Accepted: 2024-07-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
479701 2021-001 Material Weakness Yes P
479702 2021-002 Material Weakness - P
479703 2021-003 Material Weakness - P
479704 2021-004 Significant Deficiency Yes P
1056143 2021-001 Material Weakness Yes P
1056144 2021-002 Material Weakness - P
1056145 2021-003 Material Weakness - P
1056146 2021-004 Significant Deficiency Yes P

Programs

ALN Program Spent Major Findings
21.019 Coronavirus Relief Fund $735,100 Yes 0
14.218 Community Development Block Grants/entitlement Grants $208,943 - 0
20.205 Highway Planning and Construction $99,314 - 0
20.106 Airport Improvement Program $35,048 - 0
16.922 Equitable Sharing Program $908 - 0

Contacts

Name Title Type
ECBYN719GLG6 Bob Grogan Auditee
3094785369 Don Shaw Auditor
No contacts on file

Notes to SEFA

Title: NOTE 4 – SUBRECIPIENT RELATIONSHIPS Accounting Policies: NOTE 1 – BASIS OF PRESENTATION The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of the City under programs of the federal government for the year ended April 30, 2021. The information in this Schedule is presented in accordance with the requirements of Uniform Guidance, Audits of States, Local Governments, and Non-Profit Organizations. Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position, or cash flows of the City. NOTE 2 – SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Expenditures Expenditures reported on the Schedule are reported on the accrual basis of accounting. Pass-Through Entities Pass-through entity identifying numbers are presented on the Schedule where available. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10% de minimis indirect cost rate as permitted by 2 CFR Section 200.414. The City remitted $735,100 of CURES Business Initiative funding to 139 local business subrecipients. The disbursements ranged from $8,000 to $300 per subrecipient.

Finding Details

Condition: During audit fieldwork, our testing resulted in a restatement of fund balance in order to correct expenses in the correct internal service fund due between funds. Criteria: A good system of internal controls would provide for accurate representations of adjusted account balances for all City accounts prior to audit fieldwork. Cause: Year-end entries related to various accruals and other items were required in order to accurately present the City’s financial statements. Effect: The City’s financial statements were not fully adjusted prior to audit fieldwork. Recommendation: A vital process of effective internal controls is the review and subsequent adjustment of general ledger balances. This review and adjustment will aid in the appropriate budgeting and management of the City’s financial activities and resources.
Condition: During audit fieldwork, it was noted the City does not have a centralized reporting system for all grants obtained by the City. In addition, it was noted the City does not have a process for accurately identifying grant revenues and expenses recorded in the City’s general ledger. Criteria: Grant administration procedures should be performed to verify all payments are properly received, all expenditures are eligible under the grant, and the grant compliance occurs. Cause: Lack of oversight by the City and inadequate controls over reconciliation of grant revenues and expenditures. Effect: Inaccurate reporting of grant revenues and expenditures. Recommendation: We recommend all departments provide the original grant agreements to the finance department. In addition, we recommend that the City adopt a policy and process for reconciling grant revenues and expenditures to the general ledger, grant agreements and financial reports submitted to the granting agencies. Such reconciliation should be done on a regular basis to ensure proper identification of all grant revenues and expenditures and to prevent inaccurate reporting or duplicate requests for reimbursements.
Condition: During our current year-end audit procedures, we found that the bank reconciliations were not being performed timely. One of the most important internal control features over cash receipts and disbursements is the preparation of the monthly bank reconciliation. By not preparing monthly bank reconciliation’s, errors and omissions may occur and not be detected on a timely basis. Internal control is most effective when bank reconciliations are prepared immediately upon receipt of the monthly bank statement. The bank statement should be received unopened by an individual not responsible for writing checks or recording cash receipts and disbursement transactions. Internal control is stronger when someone not responsible for entries in the receipts and disbursements records prepares the bank reconciliation. Criteria: A good system of internal controls would reconcile all cash accounts on a monthly basis. Reconciliations should reconcile between bank and general ledger balances should be prepared to determine all cash transactions have been properly recorded. Cause: Lack of oversight by the City an inadequate controls over the bank reconciliation process. Effect: Misstated cash balances and an accumulation of unreconciled errors. Recommendation: We recommend as a means of better control, that bank reconciliations be performed each month and any variances be investigated and adjusted immediately.
Condition: Previously and during audit fieldwork, our testing resulted in audit adjustments in order to present materially accurate financial statements. Criteria: A good system of internal controls would provide for accurate representations of adjusted account balances for all City accounts prior to audit fieldwork. Cause: Year-end entries related to various accruals and other items were required in order to accurately present the City’s financial statements. Effect: The City’s financial statements were not fully adjusted prior to audit fieldwork. Recommendation: A vital process of effective internal controls is the review and subsequent adjustment of general ledger balances. This review and adjustment will aid in the appropriate budgeting and management of the City’s financial activities and resources.
Condition: During audit fieldwork, our testing resulted in a restatement of fund balance in order to correct expenses in the correct internal service fund due between funds. Criteria: A good system of internal controls would provide for accurate representations of adjusted account balances for all City accounts prior to audit fieldwork. Cause: Year-end entries related to various accruals and other items were required in order to accurately present the City’s financial statements. Effect: The City’s financial statements were not fully adjusted prior to audit fieldwork. Recommendation: A vital process of effective internal controls is the review and subsequent adjustment of general ledger balances. This review and adjustment will aid in the appropriate budgeting and management of the City’s financial activities and resources.
Condition: During audit fieldwork, it was noted the City does not have a centralized reporting system for all grants obtained by the City. In addition, it was noted the City does not have a process for accurately identifying grant revenues and expenses recorded in the City’s general ledger. Criteria: Grant administration procedures should be performed to verify all payments are properly received, all expenditures are eligible under the grant, and the grant compliance occurs. Cause: Lack of oversight by the City and inadequate controls over reconciliation of grant revenues and expenditures. Effect: Inaccurate reporting of grant revenues and expenditures. Recommendation: We recommend all departments provide the original grant agreements to the finance department. In addition, we recommend that the City adopt a policy and process for reconciling grant revenues and expenditures to the general ledger, grant agreements and financial reports submitted to the granting agencies. Such reconciliation should be done on a regular basis to ensure proper identification of all grant revenues and expenditures and to prevent inaccurate reporting or duplicate requests for reimbursements.
Condition: During our current year-end audit procedures, we found that the bank reconciliations were not being performed timely. One of the most important internal control features over cash receipts and disbursements is the preparation of the monthly bank reconciliation. By not preparing monthly bank reconciliation’s, errors and omissions may occur and not be detected on a timely basis. Internal control is most effective when bank reconciliations are prepared immediately upon receipt of the monthly bank statement. The bank statement should be received unopened by an individual not responsible for writing checks or recording cash receipts and disbursement transactions. Internal control is stronger when someone not responsible for entries in the receipts and disbursements records prepares the bank reconciliation. Criteria: A good system of internal controls would reconcile all cash accounts on a monthly basis. Reconciliations should reconcile between bank and general ledger balances should be prepared to determine all cash transactions have been properly recorded. Cause: Lack of oversight by the City an inadequate controls over the bank reconciliation process. Effect: Misstated cash balances and an accumulation of unreconciled errors. Recommendation: We recommend as a means of better control, that bank reconciliations be performed each month and any variances be investigated and adjusted immediately.
Condition: Previously and during audit fieldwork, our testing resulted in audit adjustments in order to present materially accurate financial statements. Criteria: A good system of internal controls would provide for accurate representations of adjusted account balances for all City accounts prior to audit fieldwork. Cause: Year-end entries related to various accruals and other items were required in order to accurately present the City’s financial statements. Effect: The City’s financial statements were not fully adjusted prior to audit fieldwork. Recommendation: A vital process of effective internal controls is the review and subsequent adjustment of general ledger balances. This review and adjustment will aid in the appropriate budgeting and management of the City’s financial activities and resources.