Finding 1238638 (2025-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-09-30
Audit: 413554
Organization: City of Bloomington (IN)
Auditor: CROWE LLP

AI Summary

  • Core Issue: The City lacks effective internal controls for timely and accurate reporting of Economic Development Cluster grants, leading to potential inaccuracies in submissions.
  • Impacted Requirements: Compliance with the Department of Commerce's semi-annual reporting and expenditure requirements is not being met, resulting in a late submission and overclaimed costs of $109,233.
  • Recommended Follow-Up: Implement formal review procedures and segregation of duties for grant reporting, and establish a tracking system for deadlines to ensure timely and accurate submissions.

Finding Text

Information on the federal program: Federal Agency: Department of Commerce Pass-Through Entity: N/A – Direct Grant Federal Program: Economic Development Cluster (EDC) Assistance Listing Number: 11.307 Compliance Requirement: Reporting Audit Findings: Material Weakness, Noncompliance Criteria: The Department of Commerce requires semi-annual reporting and project expenditure reports to be completed. The SF-425 Federal Financial Report tracks expenditures and must be submitted semi-annually. Reports for the period ending March 31 are due by April 30, and reports for the period ending September 30 are due by October 31. Condition: An effective internal control system was not in place at the City to ensure compliance with requirements related to the reporting requirements for the Economic Development Cluster grants. Cause: The City does not have an effective system of internal controls in place to effectively review Economic Development Cluster semi-annual reporting data prior to submission to the Department of Commerce and to ensure the reports are accurate and submitted timely. Effect: The absence of formal review and approval controls over grant reporting and reimbursement requests increases the risk that inaccurate or untimely information may be submitted to the grantor and that federal funds may be requested in excess of allowable amounts. Questioned costs: There are questioned costs of $109,233. Context: The City is responsible for establishing and maintaining internal controls over compliance with federal grant requirements, including controls designed to ensure required financial reports are submitted timely and accurately and reimbursement requests include only eligible expenditures applicable to the reporting period. During our testing, Crowe noted that the City did not have formal segregation of duties or documented review and approval controls over the preparation and submission of semi-annual financial reports and project expense reimbursement requests. Specifically, the process did not include an independent review to verify the accuracy, completeness, and appropriate reporting period of amounts submitted prior to submission to the grantor. As a result, we identified one semi-annual Federal Financial Report (SF-425) that was submitted approximately three months after the required due date. Additionally, we identified that the city overclaimed $109,233 in federal reimbursement over the course of the grant. The overclaim occurred because the City included the cumulative project cost in a reimbursement request rather than only the portion of project costs applicable to the current reimbursement period, resulting in previously claimed expenditures being included in the reimbursement calculation. Identification as a repeat finding, if applicable: No. Not a repeat finding. Recommendation: We recommend the City strengthen its internal controls over federal grant reporting and reimbursement requests by establishing formal, documented review procedures for the preparation, review, approval, and submission of required reports and reimbursement requests. These procedures should clearly assign responsibilities among appropriate personnel and incorporate segregation of duties, where practicable, between he preparation and approval functions. Additionally, the City should establish a process to track applicable grant reporting deadlines and reimbursement activity throughout the grant period to promote timely submissions and prevent duplicate or excess reimbursement requests. Views of responsible officials and planned corrective actions: Management acknowledges the finding. See management’s corrective action plan attached to this audit report.

Corrective Action Plan

Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and will implement a policy to ensure a documented review process and reconciliation of costs to the report. The City will strengthen its internal controls over federal grant reporting and reimbursement requests by implementing formal, documented procedures for the preparation, review, approval, and submission of required grant reports and reimbursement requests. Responsibilities will be clearly assigned to appropriate personnel, with segregation of preparation and approval duties where practicable. The City will also implement a centralized tracking process to monitor grant reporting deadlines, reimbursement requests, and amounts received throughout the grant period. Supporting documentation and evidence of review and approval will be maintained to promote timely and accurate reporting and reduce the risk of duplicate or excess reimbursement requests. Responsible party and timeline for completion: The Controller will be responsible for implementation of the corrective action, which will be implemented immediately.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1238637 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
11.307 ECONOMIC ADJUSTMENT ASSISTANCE $3.53M
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.38M
16.922 EQUITABLE SHARING PROGRAM $52,149
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $50,533
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $46,218
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $28,595
20.205 HIGHWAY PLANNING AND CONSTRUCTION $27,568
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $18,323
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $17,852
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $14,638
81.041 STATE ENERGY PROGRAM $13,423
15.904 HISTORIC PRESERVATION FUND GRANTS-IN-AID $11,145
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $6,869
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $68