Finding 33500 (2022-002)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-06-07
Audit: 31709
Organization: City of Calexico (CA)
Auditor: The Pun Group

AI Summary

  • Core Issue: The City failed to submit four financial reports for the Airport Improvement Program by the required deadlines.
  • Impacted Requirements: Noncompliance with federal reporting timelines as outlined in the Uniform Guidance, specifically for SF-425 and SF-271 reports.
  • Recommended Follow-Up: Strengthen report submission processes, ensure timely reviews and approvals, and request extensions when necessary, keeping records of approvals.

Finding Text

Finding 2022-002 Reporting ? Internal Control and Compliance over Reporting (Significant Deficiency) Information on the Federal Program: Assistance Listing Number: 20.106 Federal Program Name: Airport Improvement Program Federal Agency: Department of Transportation Pass-Through Entity: N/A Federal Award Number and Award Year: 3-06-0034-018-2020 ? FY20-21 3-06-0034-021-2021 ? FY21-22 Criteria: CODE OF FEDERAL REGULATIONS, Title 49 ? TRANSPORTATION, Part 18 ? UNIFORM ADMINISTRATIVE REQUIREMENTS FOR GRANTS AND COOPERATIVE AGREEMENTS TO STATE AND LOCAL GOVERNMENTS, Subpart C ? Post-Award Requirements: 18.41 Financial Report (a) General (4), Due date. When reports are required on a quarterly or semiannual basis, they will be due 30 days after the reporting period. When required on an annual basis, they will be due 90 days after the grant year. Final reports will be due 90 days after the expiration or termination of grant support. 18.58 (a) General. The Federal agency will close out the award when it determines that all applicable administrative actions and all required work of the grant has been completed. 18.50 (b) Reports. Within 90 days after the expiration or termination of the grant, the grantee must submit all financial, performance, and other reports required as a condition of the grant. Upon request by the grantee, Federal agencies may extend this time frame. These may include but are not limited to: (1) Final performance or progress report, (2) Financial Status Report (SF 269) or Outlay Report and Request for Reimbursement for Construction Programs (SF-271) (as applicable), (3) Final request for payment (SF-270) (if applicable), and (4) Invention disclosure (if applicable). U.S. OFFICE OF MANAGEMENT AND BUDGET CIRCULAR A-133?AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS (OMB Circular A-133), Subpart C? Auditees, Section .300?Auditee Responsibilities (b) Maintain internal control over federal programs that provides reasonable assurance that the auditee is managing federal awards in compliance with laws, regulations, and the provisions of contracts or grant agreements that could have a material effect on each of its federal programs. Condition and Context: For the Airport Improvement Program (AIP), the City did not submit the reports within the required deadline: Report Type Award Number Period Date Due Date Submitted SF-425 Financial 3-06-0034-018-2020 10/1/20 ? 9/30/21 12/31/2021 Not submitted SF-271 Financial 3-06-0034-018-2020 10/1/20 ? 9/30/21 12/31/2021 Not submitted SF-425 Financial 3-06-0034-021-2021 6/1/21 ? 9/30/21 12/31/2021 Not submitted SF-271 Financial 3-06-0034-021-2021 6/1/21 ? 9/30/21 12/31/2021 Not submitted Four (4) financial reports were tested and all reports were not submitted by the required deadline. Cause: Due to the effects of COVID-19 and staff turnover, the City?s procedures did not consistently ensure that the reports were submitted timely in accordance with the timelines in the Uniform Guidance, or properly reviewed and approved prior to submission. Effect: Failure to submit the SF-425 and SF-271 financial reports timely results in noncompliance with the reporting requirements in the grant agreement. Questioned Costs: None noted. Identification as a Repeat Finding, If Applicable: No. Recommendation: We recommend that the City strengthen their report submission process and procedures to ensure all required reports are properly reviewed and approved and submitted timely. When a report cannot be submitted by the due date, the City should request an extension from the funding agency and maintain a record of the approval. Management?s View and Corrective Action Plan: The City concurs with the auditor?s finding. The City will take steps to improve identification and monitoring of required grantor reporting deadlines.

Corrective Action Plan

Finding 2022-002 Reporting ? Internal Control and Compliance over Reporting (Significant Deficiency) Criteria: CODE OF FEDERAL REGULATIONS, Title 49 ? TRANSPORTATION, Part 18 ? UNIFORM ADMINISTRATIVE REQUIREMENTS FOR GRANTS AND COOPERATIVE AGREEMENTS TO STATE AND LOCAL GOVERNMENTS, Subpart C ? Post-Award Requirements: 18.41 Financial Report (a) General (4), Due date. When reports are required on a quarterly or semiannual basis, they will be due 30 days after the reporting period. When required on an annual basis, they will be due 90 days after the grant year. Final reports will be due 90 days after the expiration or termination of grant support. 18.58 (a) General. The Federal agency will close out the award when it determines that all applicable administrative actions and all required work of the grant has been completed. 18.50 (b) Reports. Within 90 days after the expiration or termination of the grant, the grantee must submit all financial, performance, and other reports required as a condition of the grant. Upon request by the grantee, Federal agencies may extend this time frame. These may include but are not limited to: (1) Final performance or progress report, (2) Financial Status Report (SF 269) or Outlay Report and Request for Reimbursement for Construction Programs (SF-271) (as applicable), (3) Final request for payment (SF-270) (if applicable), and (4) Invention disclosure (if applicable). U.S. OFFICE OF MANAGEMENT AND BUDGET CIRCULAR A-133?AUDITS OF STATES, LOCAL GOVERNMENTS, AND NON-PROFIT ORGANIZATIONS (OMB Circular A-133), Subpart C? Auditees, Section .300?Auditee Responsibilities (b) Maintain internal control over federal programs that provides reasonable assurance that the auditee is managing federal awards in compliance with laws, regulations, and the provisions of contracts or grant agreements that could have a material effect on each of its federal programs. Condition: For the Airport Improvement Program (AIP), the City did not submit the reports within the required deadline: Report Type Award Number Period Date Due Date Submitted SF-425 Financial 3-06-0034-018-2020 10/1/20 ? 9/30/21 12/31/2021 Not submitted SF-271 Financial 3-06-0034-018-2020 10/1/20 ? 9/30/21 12/31/2021 Not submitted SF-425 Financial 3-06-0034-021-2021 6/1/21 ? 9/30/21 12/31/2021 Not submitted SF-271 Financial 3-06-0034-021-2021 6/1/21 ? 9/30/21 12/31/2021 Not submitted Four (4) financial reports were tested and all reports were not submitted by the required deadline. City?s Corrective Action Plan: Finding Auditor Recommendation Action Plan Finding 2022-002: Internal Control and Compliance over Reporting (Grant Reports) ? We recommend that the City strengthen their report submission process and procedures to ensure all required (Grant) reports are properly review and approved and submitted timely. By August 1, 2023 ? The Finance Director will prepare an annual calendar with assembly and submission dates for each required monthly, quarterly, and annual grantee reports ? Staff members in both Program and Finance Departments will be assigned to prepare and cross-check required grant reports Contact person responsible for corrective action: Sandra Fonseca, Interim Finance Director Anticipated completion date: August 1, 2023

Categories

Subrecipient Monitoring Reporting Cash Management Significant Deficiency

Other Findings in this Audit

  • 33501 2022-002
    Significant Deficiency
  • 609942 2022-002
    Significant Deficiency
  • 609943 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 State and Local Fiscal Recovery Fund $4.76M
20.205 New River Bike Path $1.45M
20.106 Airport Improvement Program $1.07M
21.019 Coronavirus Relief Fund $83,528
21.027 California Water and Wastewater Arrearage Payment Program $30,826
20.106 Covid-19 - Crrsa - Airport Rescue Grant Program $22,000
95.001 High Intensity Drug Trafficking Areas (hidta) $13,286
20.205 Weakley Road Improvements $12,312
14.239 Home Investment Partnerships Program $5,432
14.218 Home and Ownership Section $5,354
97.067 Operation Stonegarden $3,814