Finding 1092514 (2024-001)

-
Requirement
G
Questioned Costs
-
Year
2024
Accepted
2024-12-19

AI Summary

  • Core Issue: The revenue loss calculation for FY22 was overstated by about $1 million due to incorrect inputs from the ACFR.
  • Impacted Requirements: Revenue loss must be calculated based on FY19 figures and estimated growth, aligning with ACFR data for accuracy.
  • Recommended Follow-Up: Review calculations before finalization and ensure all supporting documentation is accurate and updated.

Finding Text

Coronavirus State and Local Fiscal Recovery Funds, ALN 21.027, Matching, Level of Effort, Earmarking - Matching Condition: The revenue loss calculation included inputs from fiscal year 2022 ACFR that were overstated by approximately $1 million. Criteria: The revenue loss should be calculated by determining the revenue reported in the base year (FY19) and using an estimated growth rate to determine the amount of revenue the locality would have earned had the pandemic not occurred. The revenues reported in subsequent years (FY20, FY21, FY22) should then be compared to the estimated revenue to determine the revenue loss. Both the revenue used in the base and subsequent years should agree to the corresponding year ACFR. Cause: The City’s review of the revenue loss calculation did not detect this error. Effect: The FY22 actual amount reported in the ACFR was approximately $1 million less than what was used in the calculation. There was no impact to the amount of funds claimed under revenue loss. Recommendation: We recommend a review of the calculation prior to finalization. Supporting documentation should be maintained to support all figures in the calculation. Views of Responsible Officials and Planned Corrective Action: We concur with this finding. This error was a result of one of the revenue lines used in the original FY22 estimate not being updated with actual values. There is no impact to the amount of funds claimed under revenue loss because correction of the error results in additional revenue loss, which is not needed in the calculation. The City of Staunton met the entire revenue loss needed by only using a portion of the FY22 calculated revenue loss. Staff will update supporting documentation with the correct figure.

Categories

Matching / Level of Effort / Earmarking

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program $1.12M
84.027 Special Education Grants to States $873,822
10.553 School Breakfast Program $561,042
14.218 Community Development Block Grants/entitlement Grants $398,004
97.067 Homeland Security Grant Program $240,000
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $157,946
84.013 Title I State Agency Program for Neglected and Delinquent Children and Youth $137,758
10.579 Child Nutrition Discretionary Grants Limited Availability $119,153
84.424 Student Support and Academic Enrichment Program $95,378
10.559 Summer Food Service Program for Children $78,683
84.048 Career and Technical Education -- Basic Grants to States $74,184
84.010 Title I Grants to Local Educational Agencies $72,482
16.575 Crime Victim Assistance $70,906
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $57,728
21.027 Coronavirus State and Local Fiscal Recovery Funds $35,000
84.425 Education Stabilization Fund $30,000
20.600 State and Community Highway Safety $19,484
84.173 Special Education Preschool Grants $10,913
84.365 English Language Acquisition State Grants $7,514
97.045 Cooperating Technical Partners $7,500
93.667 Social Services Block Grant $3,698
10.649 Pandemic Ebt Administrative Costs $3,256
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,520
84.184 School Safely National Activities $2,250
93.778 Medical Assistance Program $2,044
93.747 Elder Abuse Prevention Interventions Program $1,684
10.558 Child and Adult Care Food Program $1,666
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $1,341
93.658 Foster Care Title IV-E $1,336
84.196 Education for Homeless Children and Youth $1,285
10.574 Team Nutrition Grants $700
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $500
93.659 Adoption Assistance $187
93.558 Temporary Assistance for Needy Families $106
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $34
93.575 Child Care and Development Block Grant $-289