Finding 1155297 (2023-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-09-25
Audit: 367551
Organization: The City of Frederick, Maryland (MD)
Auditor: Brown Plus

AI Summary

  • Core Issue: There is a significant deficiency in internal controls over the reporting of federal expenditures, leading to inaccurate financial reports.
  • Impacted Requirements: The Form SF-425 must accurately reflect federal revenue and expenditures for the correct reporting period.
  • Recommended Follow-Up: The finance department should ensure accounting records align with the reporting period and adjust for any accruals to maintain consistency in future reports.

Finding Text

Federal Agency: Department of Transportation Federal Program: 20.106 Airport Improvement Program, COVID-19 Airports Programs, and Infrastructure Investment and Jobs Act Programs Identification Number: 3-24-0017-049-2021 Requirement: Reporting Type of Finding: Significant deficiency in internal control over major program Criteria: Federal revenue, federal expenditures and the recipient share are to be reported for the period Form SF-425 is being filed. Condition: Forms SF-425, Federal Financial Report (FFR), were completed using amounts from a varying reporting period. Cause: There was no management oversight of the preparation of Form SF-425. Effect: The Department of Transportation will not have accurate information to assess the status of each project. Context: FFR for Grant 49 was filed with period-end date September 30, 2022 noting $1,488,124 of expenditures when actual expenditures were $1,802,530. The difference was due to a request which was marked as paid on June 30, 2022 and was included in the June 30, 2022 FFR. The request was payable as of June 30, 2022 and was paid in July 2022. Repeat Finding: This finding was reported for the year ended June 30, 2022 as 2022-002 as a significant deficiency in internal control. For the years ended June 30, 2021 and 2020 the finding was reported as 2021-002 and 2020-004, respectively, as a material weakness and noncompliance. Recommendation: The finance department should provide accounting records to the airport that are for the reporting period the Form SF-425 is being prepared. Also, since reports are filed on the cash basis of accounting, any accruals should be reversed so reporting is consistent from period to period. This will provide the Department of Transportation with an accurate accounting of where the project stands. Views of Responsible Official(s) and Planned Corrective Actions: See corrective action plan.

Corrective Action Plan

The finance department will review Form SF-425 compared to financial reports prior to submittals. Quarterly reminders have been initiated to ensure timely reporting moving forward.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1155298 2023-004
    Material Weakness Repeat
  • 1155299 2023-005
    Material Weakness Repeat
  • 1155300 2023-006
    Material Weakness Repeat
  • 1155301 2023-007
    Material Weakness Repeat
  • 1155302 2023-008
    Material Weakness Repeat
  • 1155303 2023-009
    Material Weakness Repeat
  • 1155304 2023-010
    Material Weakness Repeat
  • 1155305 2023-011
    Material Weakness Repeat
  • 1155306 2023-012
    Material Weakness Repeat
  • 1155307 2023-013
    Material Weakness Repeat
  • 1155308 2023-014
    Material Weakness Repeat
  • 1155309 2023-015
    Material Weakness Repeat
  • 1155310 2023-016
    Material Weakness Repeat
  • 1155311 2023-017
    Material Weakness Repeat
  • 1155312 2023-018
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $4.30M
93.224 Health Center Program (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $2.21M
93.137 Community Programs to Improve Minority Health $2.07M
14.231 Emergency Solutions Grant Program $1.03M
10.558 Child and Adult Care Food Program $996,154
93.568 Low-Income Home Energy Assistance $960,360
21.027 Coronavirus State and Local Fiscal Recovery Funds $786,960
93.569 Community Services Block Grant $452,538
14.218 Community Development Block Grants/entitlement Grants $271,995
14.267 Continuum of Care Program $184,808
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $94,827
21.026 Homeowner Assistance Fund $85,771
93.150 Projects for Assistance in Transition From Homelessness (path) $74,103
81.042 Weatherization Assistance for Low-Income Persons $62,520
16.753 Congressionally Recommended Awards $41,550
16.738 Edward Byrne Memorial Justice Assistance Grant Program $26,732
10.559 Summer Food Service Program for Children $26,497
93.499 Low Income Household Water Assistance Program $18,086
97.067 Homeland Security Grant Program $14,280
20.600 State and Community Highway Safety $14,003
95.001 High Intensity Drug Trafficking Areas Program $13,275
66.466 Geographic Programs - Chesapeake Bay Program $11,325
20.616 National Priority Safety Programs $8,554
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $2,487