Finding 522407 (2022-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2025-02-07
Audit: 341682
Organization: City of Bloomington (IN)
Auditor: Crowe LLP

AI Summary

  • Core Issue: The City of Bloomington's quarterly reports for the CSLFRF program inaccurately combined subrecipient and vendor expenditures.
  • Impacted Requirements: Compliance with the US Department of Treasury's reporting guidelines, specifically the need for clear differentiation between subrecipients and vendors.
  • Recommended Follow-Up: Implement a multi-stage review process to improve data accuracy and ensure proper tracking of subrecipient activities and expenditures.

Finding Text

Information on the federal program: Federal Agency: Department of the Treasury Pass-Through Entity: N/A – Direct Grant Federal Program: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Assistance Listing Number: 21.027 Compliance Requirement: Reporting Audit Findings: Significant Deficiency Criteria: The US Department of Treasury’s Compliance and Reporting Guidance for State and Local Fiscal Recovery Funds requires quarterly project expenditure reports to be completed with the key line items: 1) Obligations and Expenditures 2) Subawards 3) Detailed information of any loans issued; contracts and grants awarded; transfers made to other government entities; and direct payments made by the recipient that are greater than $50,000. For amounts less than $50,000, the recipient must report in the aggregate for these same categories of loans issued; contracts and grants awarded; transfers made to other government entities; and direct payments made by the recipient. Condition: City of Bloomington completed quarterly reporting in a timely manner substantiated by the City’s expenditure detail. However, management could not differentiate between subrecipients and standard vendor expenditures. Cause: The City does not have an effective system of internal controls in place to effectively review CSLFRF reporting data prior to submission to the US Department of Treasury. Effect: Subrecipient expenditures and subawards on the quarterly data submissions were overstated. Questioned costs: There are no questioned costs. Context: During our testing procedures over CSLFRF reporting, we noted that segregation of duties is not present in the Federal reporting process. The City was not able to accurately identify and report subrecipient activity within CSLFRF quarterly reports. Identification as a repeat finding, if applicable: This is not a repeat finding. Recommendation: We recommend that the City implement a consistent multi-stage review process for federal data reports, which involves identifying and tracking subrecipient activity as well as expenditures by type. 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

Information on the federal program: Federal Agency: Department of the Treasury Pass-Through Entity: N/A – Direct Grant Federal Program: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Assistance Listing Number: 21.027 Compliance Requirement: Reporting Audit Findings: Significant Deficiency Condition: City of Bloomington completed quarterly reporting in a timely manner substantiated by the City’s expenditure detail. However, management could not differentiate between subrecipients and standard vendor expenditures. Context: During our testing procedures over CSLFRF reporting, we noted that segregation of duties is not present in the Federal reporting process resulting in overstatement of subrecipient activity within CSLFRF quarterly reports. Views of Responsible Officials and Planned Corrective Actions: Management will develop an internal controls process to ensure that there’s segregation of duties within the reporting process for federal programs. Responsible party and timeline for completion: The City’s Controller will oversee the implementation of the corrective action plan, which will be implemented starting during calendar year 2025.

Categories

Subrecipient Monitoring Internal Control / Segregation of Duties Reporting Significant Deficiency

Other Findings in this Audit

  • 522400 2022-005
    Significant Deficiency
  • 522401 2022-005
    Significant Deficiency
  • 522402 2022-005
    Significant Deficiency
  • 522403 2022-005
    Significant Deficiency
  • 522404 2022-005
    Significant Deficiency
  • 522405 2022-005
    Significant Deficiency
  • 522406 2022-002
    Material Weakness
  • 522408 2022-004
    Significant Deficiency
  • 1098842 2022-005
    Significant Deficiency
  • 1098843 2022-005
    Significant Deficiency
  • 1098844 2022-005
    Significant Deficiency
  • 1098845 2022-005
    Significant Deficiency
  • 1098846 2022-005
    Significant Deficiency
  • 1098847 2022-005
    Significant Deficiency
  • 1098848 2022-002
    Material Weakness
  • 1098849 2022-003
    Significant Deficiency
  • 1098850 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $5.00M
16.034 Coronavirus Emergency Supplemental Funding Program $107,955
20.205 Highway Planning and Construction $78,510
14.218 Community Development Block Grants/entitlement Grants $66,994
16.922 Equitable Sharing Program $57,371
14.239 Home Investment Partnerships Program $46,631
16.738 Edward Byrne Memorial Justice Assistance Grant Program $32,193
15.611 Wildlife Restoration and Basic Hunter Education and Safety $23,389
84.287 Twenty-First Century Community Learning Centers $19,117
20.600 State and Community Highway Safety $14,173
10.559 Summer Food Service Program for Children $7,270
93.994 Maternal and Child Health Services Block Grant to the States $6,941
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $3,228
14.469 United States Department of Housing and Urban Development $722