Finding 384378 (2022-010)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2024-03-25
Audit: 297486
Organization: The City of Frederick, Maryland (MD)
Auditor: Brown Plus

AI Summary

  • Core Issue: Lack of supporting documentation for key financial reports led to inaccuracies in federal reporting.
  • Impacted Requirements: Failure to maintain documentation violates federal program requirements for accurate reporting and internal controls.
  • Recommended Follow-Up: Ensure all supporting documents are kept, and staff should review reporting guidelines to improve accuracy in future submissions.

Finding Text

Federal Agency: Department of Health and Human Services Federal Program: 93.137 Community Programs to Improve Minority Health Grant Program Identification Number: 1 CPIMP211296-01-00 Requirement: Reporting Type of Finding: Material weakness in internal control over major program; Noncompliance Criteria: Supporting documentation must be maintained for all reports required to be filed for federal programs. Amounts reported on financial reports should be supported by the accounting records that support the audited financial statements and the schedule of expenditures of federal awards. Condition: Supporting documentation for key line items on the quarterly progress reports and monthly reports required to be filed in the first six months of the project was not maintained. Amounts reported as cash receipts did not match the underlying support and cash disbursements included accrued amounts. Cause: Review and approval of grant reporting did not take place at the level needed to support accurate federal reporting. Also, the minority health program 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 reports selected for testing (two quarterly financial and performance progress reports and three monthly special reports) did not have documentation maintained that supported the program data stated in the reports. As noted in the directions for the quarterly FFR, cash receipts and cash disbursements are only actual cash received. The amounts reported by the City included expenditures which were in accounts payable and Brown Plus could not trace the cash receipts to the general ledger detail. Recommendation: Program management should maintain any and all support utilized in the preparation of federal reports. Documentation of the methods utilized to extract activity from the general ledger for financial reporting should also be maintained. Minority health staff preparing reports should carefully review reporting instructions to ensure the correct amounts are reported. Views of Responsible Official(s) and Planned Corrective Actions: See corrective action plan.

Corrective Action Plan

A grants database has been developed for tracking and storing grant related information. Finance has assigned a grants manager to ensure the accuracy of financial reporting.

Categories

Reporting

Other Findings in this Audit

  • 384370 2022-002
    Significant Deficiency Repeat
  • 384371 2022-003
    Material Weakness
  • 384372 2022-004
    Significant Deficiency Repeat
  • 384373 2022-005
    Significant Deficiency Repeat
  • 384374 2022-006
    Significant Deficiency
  • 384375 2022-007
    Material Weakness
  • 384376 2022-008
    Material Weakness
  • 384377 2022-009
    Material Weakness
  • 384379 2022-011
    Significant Deficiency
  • 384380 2022-012
    Material Weakness
  • 384381 2022-013
    Significant Deficiency
  • 384382 2022-014
    Significant Deficiency
  • 384383 2022-015
    Material Weakness
  • 384384 2022-016
    Significant Deficiency
  • 384385 2022-017
    Significant Deficiency
  • 960812 2022-002
    Significant Deficiency Repeat
  • 960813 2022-003
    Material Weakness
  • 960814 2022-004
    Significant Deficiency Repeat
  • 960815 2022-005
    Significant Deficiency Repeat
  • 960816 2022-006
    Significant Deficiency
  • 960817 2022-007
    Material Weakness
  • 960818 2022-008
    Material Weakness
  • 960819 2022-009
    Material Weakness
  • 960820 2022-010
    Material Weakness
  • 960821 2022-011
    Significant Deficiency
  • 960822 2022-012
    Material Weakness
  • 960823 2022-013
    Significant Deficiency
  • 960824 2022-014
    Significant Deficiency
  • 960825 2022-015
    Material Weakness
  • 960826 2022-016
    Significant Deficiency
  • 960827 2022-017
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program $4.76M
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $1.39M
93.137 Community Programs to Improve Minority Health Grant Program $985,426
59.075 Shuttered Venue Operators Grant Program $807,851
10.558 Child and Adult Care Food Program $805,355
93.568 Low-Income Home Energy Assistance $780,504
14.231 Emergency Solutions Grant Program $660,699
21.027 Coronavirus State and Local Fiscal Recovery Funds $415,035
93.569 Community Services Block Grant $407,287
14.267 Continuum of Care Program $182,884
14.218 Community Development Block Grants/entitlement Grants $151,936
81.042 Weatherization Assistance for Low-Income Persons $133,099
93.150 Projects for Assistance in Transition From Homelessness (path) $74,103
16.738 Edward Byrne Memorial Justice Assistance Grant Program $70,867
95.001 High Intensity Drug Trafficking Areas Program $58,844
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $27,718
10.559 Summer Food Service Program for Children $16,751
93.499 Low Income Household Water Assistance Program $16,206
97.067 Homeland Security Grant Program $9,802
20.616 National Priority Safety Programs $9,148
21.026 Homeowner Assistance Fund $7,726
21.016 Equitable Sharing $6,000
20.600 State and Community Highway Safety $5,838
66.466 Chesapeake Bay Program $3,675