Finding 1155298 (2023-004)

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 material weakness in internal controls, leading to discrepancies between reported amounts and supporting documentation for federal program reports.
  • Impacted Requirements: All supporting documentation must match the amounts reported on the Uniform Data System (UDS) and Federal Financial Report (FFR).
  • Recommended Follow-Up: Ensure proper training for staff on data software and maintain all supporting documentation for federal reports to prevent future discrepancies.

Finding Text

Federal Agency: Department of Health and Human Services Federal Program: 93.224 Health Center Program Identification Numbers: H80CS29007 H8DCS36329 H8ECS38904 H8FCS41132-01-00 Requirement: Reporting Type of Finding: Material weakness in internal control over major program; Noncompliance Criteria: Supporting documentation should match the amounts reported on all reports required to be filed for federal programs. Condition: Supporting documentation for key line items on the Uniform Data System (UDS) report and Federal Financial Report (FFR) did not match the reported amounts. Cause: Review and approval of grant reporting did not take place at the level needed to support accurate federal reporting. Also, the Health Center experienced a high volume of employee turnover. Effect: Misinformation presented to the federal government may lead to federal inquiries of those charged with governance. Context: The supporting documentation for the reports selected for testing (six FFRs and one UDS report) did not tie into the amounts reported on the FFRs and UDS. The information used to prepare the reports could not be recreated by Health Center staff. For two key line items in the UDS, Health Center staff could not provide supporting information to support the amounts reported. Amounts in the general ledger did not support the financial data for the varying reporting periods utilized in preparation of the reports. Repeat Finding: This finding was reported for the year ended June 30, 2022 as 2022-003. Recommendation: The Health Center should maintain any and all support utilized in the preparation of federal reports. We also recommend that Health Center staff receive proper training on the patient data software so that they are able to run reports that are necessary for the UDS reports. Documentation of the methods utilized to extract activity from the general ledger for financial reporting should also be maintained. Views of Responsible Official(s) and Planned Corrective Actions: See corrective action plan.

Corrective Action Plan

The Department has instituted a policy to maintain electronic back-ups of all documentation utilized in the submission of both the UDS and FFR. The electronic copies are backed up on a SharePoint service. Additionally, the Finance Staff will review the FFR prior to submission. Furthermore, the Health Center has recently adopted a new EHR with UDS functionality built into the system allowing us to streamline submission.

Categories

Reporting

Other Findings in this Audit

  • 1155297 2023-003
    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