Finding 971375 (2023-002)

Material Weakness
Requirement
GL
Questioned Costs
-
Year
2023
Accepted
2024-04-26
Audit: 304784
Organization: Prince George's County, MD (MD)

AI Summary

  • Core Issue: Prince George’s County inaccurately calculated revenue loss, leading to incorrect reporting in Project and Expenditure reports.
  • Impacted Requirements: Noncompliance with Treasury’s Final Rule on revenue calculation and reporting, risking future funding.
  • Recommended Follow-Up: Revise the revenue loss calculation per U.S. Treasury guidance and submit corrected reports to the SLFRF portal.

Finding Text

Reference Number: 2023-002 Prior Year Finding: No Federal Agency: U.S. Department of Treasury Federal Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Number and Year: ARP17SL1 (5/23/2021 - 12/31/2026) Compliance Requirement: Earmarking and Reporting Type of Finding: Material Weakness in Internal Control Over Compliance, Material Noncompliance (Modified Opinion) Criteria or specific requirement: Compliance: Earmarking – Under Treasury’s Final Rule that became effective on April 1, 2022, recipients can calculate lost revenue for the years 2020, 2021, 2022, and 2023 based on the formula provided in the Final Rule to determine the amount of State and Local Fiscal Recovery Funds (SLFRF) that can be used for the “provision of government services.” To calculate revenue loss at each of these dates, recipients must follow a four-step process which includes: a. Calculate revenues collected in the most recent full fiscal year prior to the public health emergency (i.e., last full fiscal year before January 27, 2020), called the base year revenue. b. Estimate counterfactual revenue, which is equal to the following formula, where n is the number of months elapsed since the end of the base year to the calculation date: base year revenue x (1 + growth adjustment) n/12. The growth adjustment is the greater of either a standard growth rate—5.2 percent—or the recipient’s average annual revenue growth in the last full three fiscal years prior to the COVID-19 public health emergency. c. Identify actual revenue, which equals revenues collected over the twelve months immediately preceding the calculation date. d. Revenue loss for the calculation date is equal to counterfactual revenue minus actual revenue (adjusted for tax changes) for the twelve-month period. Further, the Final Rule defines the term general revenue to include revenues collected by a recipient and generated from its underlying economy and would capture a range of different types of tax revenues, as well as other types of revenue that are available to support government services. In calculating revenue, recipients should sum across all revenue streams covered as general revenue. Reporting – Per 2 CFR 200.328 and 31 CFR section 35.4(c), States, territories, metropolitan cities, counties, and Tribal governments were required to submit one interim report and quarterly Project and Expenditure reports thereafter. A Key Line Item containing critical information, as defined by Treasury, in these reports is the Revenue Replacement section. Control: Per 2 CFR section 200.303(a), a non-Federal entity must: Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should comply with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: Prince George’s County (the County) did not calculate their revenue loss in accordance with the Final Rule. As a result, amounts reported under the Revenue Replacement section of the Project and Expenditure reports were inaccurate for all quarters within the fiscal year ended June 30, 2023 Context: The County used incorrect base year revenues in their revenue loss calculation. Only general fund revenue was used in the calculation instead of summing across all revenue streams as defined by the Final Rule. Further, the County used an incorrect growth rate of 4.0% instead of 5.2% as required by the Final Rule. The Revenue Replacement section of the Project and Expenditure reports were inaccurate due to these errors. Cause: The County’s policies and procedures were not sufficient to ensure that their revenue loss calculation was in accordance with the Final Rule and that accurate information was reported in their Project and Expenditure reports under the Revenue Replacement section. Effect: The County was not in compliance with federal requirements, and failure to comply with those requirements could jeopardize future funding. Questioned costs: Undetermined. Recommendation: We recommend that the County revise the revenue loss calculation to be in accordance with the U.S. Treasury’s guidance as outlined by the Final Rule and submit a revised Project and Expenditure report to the U.S. Treasury’s SLFRF portal. Views of responsible officials: At the time that the Office of Management and Budget (OMB) calculated the revenue loss it was unclear whether it applied to only general funds or all funds. Guidance from the U.S. Treasury Department was updated frequently following enactment of the American Rescue Plan Act of 2021. Based on the finding of the audit that revenue loss calculation is not in accord with the Final Rule, OMB staff re-calculated the data using all funds.

Categories

Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 394928 2023-001
    Material Weakness Repeat
  • 394929 2023-001
    Material Weakness Repeat
  • 394930 2023-001
    Material Weakness Repeat
  • 394931 2023-001
    Material Weakness Repeat
  • 394932 2023-002
    Material Weakness
  • 394933 2023-002
    Material Weakness
  • 394934 2023-002
    Material Weakness
  • 394935 2023-003
    Material Weakness
  • 394936 2023-003
    Material Weakness
  • 394937 2023-003
    Material Weakness
  • 971370 2023-001
    Material Weakness Repeat
  • 971371 2023-001
    Material Weakness Repeat
  • 971372 2023-001
    Material Weakness Repeat
  • 971373 2023-001
    Material Weakness Repeat
  • 971374 2023-002
    Material Weakness
  • 971376 2023-002
    Material Weakness
  • 971377 2023-003
    Material Weakness
  • 971378 2023-003
    Material Weakness
  • 971379 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.239 Home Investment Partnerships Program $24.77M
21.023 Emergency Rental Assistance Program $12.10M
21.019 Coronavirus Relief Fund $7.33M
20.507 Federal Transit_formula Grants $4.78M
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $2.78M
93.495 Community Health Workers for Public Health Response and Resilient $2.49M
93.435 Innovative State and Local Public Health Strategies to Prevent and Manage Diabetes and Heart Disease and Stroke- $2.40M
97.091 Homeland Security Biowatch Program $2.27M
16.606 State Criminal Alien Assistance Program $1.71M
93.493 Congressional Directives $1.46M
93.137 Community Programs to Improve Minority Health Grant Program $1.38M
93.940 Hiv Prevention Activities_health Department Based $1.24M
93.568 Low-Income Home Energy Assistance $1.20M
93.917 Hiv Care Formula Grants $963,203
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $935,174
14.218 Community Development Block Grants/entitlement Grants $903,428
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $787,699
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $762,199
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $586,663
93.958 Block Grants for Community Mental Health Services $512,457
16.609 Project Safe Neighborhoods $475,191
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $424,820
12.003 Community Economic Adjustment Assistance for Responding to Threats to the Resilience of A Military Installation (b) $420,800
93.788 Opioid Str $395,635
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $361,184
97.057 Intercity Bus Security Grants $340,881
93.563 Child Support Enforcement $337,224
93.069 Public Health Emergency Preparedness $329,615
16.585 Drug Court Discretionary Grant Program $302,338
17.235 Senior Community Service Employment Program $285,902
16.741 Dna Backlog Reduction Program $260,000
94.011 Foster Grandparent Program $240,620
93.959 Block Grants for Prevention and Treatment of Substance Abuse $226,175
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $195,082
14.248 Community Development Block Grants_section 108 Loan Guarantees $173,203
97.067 Homeland Security Grant Program $166,292
14.267 Continuum of Care Program $164,276
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $161,505
93.778 Medical Assistance Program $156,920
20.509 Formula Grants for Rural Areas and Tribal Transit Program $156,226
93.197 Childhood Lead Poisoning Prevention Projects_state and Local Childhood Lead Poisoning Prevention and Surveillance of Blood Lead Levels in Children $152,291
93.505 Affordable Care Act (aca) Maternal, Infant, and Early Childhood Home Visiting Program $120,573
93.052 National Family Caregiver Support, Title Iii, Part E $117,546
97.042 Emergency Management Performance Grants $111,477
93.150 Projects for Assistance in Transition From Homelessness (path) $106,652
93.136 Injury Prevention and Control Research and State and Community Based Programs $100,650
93.994 Maternal and Child Health Services Block Grant to the States $83,499
16.575 Crime Victim Assistance $81,181
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $79,323
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $70,964
16.710 Public Safety Partnership and Community Policing Grants $63,166
93.268 Immunization Cooperative Agreements $62,759
16.746 Capital Case Litigation Initiative $49,536
97.049 Presidential Declared Disaster Assistance - Disaster Housing Operations for Individuals and Households $48,827
16.758 Improving the Investigation and Prosecution of Child Abuse and the Regional and Local Children's Advocacy Centers $46,308
16.738 Edward Byrne Memorial Justice Assistance Grant Program $44,190
93.324 State Health Insurance Assistance Program $40,921
16.588 Violence Against Women Formula Grants $39,381
93.470 Alzheimer's Disease Program Initiative (adpi) $34,287
93.053 Nutrition Services Incentive Program $30,944
16.593 Residential Substance Abuse Treatment for State Prisoners $29,153
21.027 Coronavirus State and Local Fiscal Recovery Funds $24,989
16.036 Prosecuting Cold Cases Using Dna $23,945
20.205 Highway Planning and Construction $23,701
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $22,365
20.505 Highway Planning and Construction $16,156
16.034 Coronavirus Emergency Supplemental Funding Program $11,816
15.622 Sportfishing and Boating Safety Act $11,523
20.600 State and Community Highway Safety $9,500
16.737 Gang Resistance Education and Training $8,153
97.083 Staffing for Adequate Fire and Emergency Response (safer) $5,000
94.002 Retired and Senior Volunteer Program $4,218
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $2,957
97.024 Emergency Food and Shelter National Board Program $563
93.770 Medicare_prescription Drug Coverage $-39
93.558 Temporary Assistance for Needy Families $-482
93.767 Children's Health Insurance Program $-78,542
14.231 Emergency Solutions Grant Program $-191,161