Finding 396673 (2023-001)

-
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-05-14
Audit: 306283
Organization: City of Taunton (MA)

AI Summary

  • Core Issue: The City submitted timely reports to the U.S. Treasury and Bristol County, but the reported expenditures did not match the City’s accounting records.
  • Impacted Requirements: Compliance with federal and county reporting requirements is compromised due to discrepancies between reported and actual expenditures.
  • Recommended Follow-Up: Management should establish better controls to reconcile expenditures before submission and ensure any missed expenditures are included in future reports.

Finding Text

U.S. DEPARTMENT OF TREASURY COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Assistance Listing Number 21.027 2023-001: Reporting to the Federal Government Compliance Requirement: Reporting Type of Finding: Compliance and Internal Control over Compliance – Other Matter Criteria or Specific Requirement: Grantees must comply with reporting requirements established by the U.S. Treasury that includes reporting the total grant expenditures incurred for the reporting period. Since the City is a Metropolitan City with a population below 250,000 residents that was allocated more than $10.0 million in funding, the City is required to submit, to the U.S. Department of Treasury, a project and expenditure report 30 days after the end of each quarter. The City is also required to submit quarterly reports to Bristol County no later than 15 days following the end of each fiscal quarter. Condition: The City submitted the quarterly project and expenditure report timely, however the expenditures reported as of June 30, 2023, did not reconcile with the City’s accounting ledger. Similarly, while the City submitted quarterly reports to the County timely, expenditures reported as of June 30, 2023, did not reconcile with the City’s accounting ledger. Questioned Costs: None Reported. Context: The City filed the required project and expenditure report in a timely manner, however the report submitted to the U.S. Treasury’s Portal did not reconcile with City’s accounting ledger. Similarly, the City filed the required quarterly reports to Bristol County in a timely manner, however the report submitted did not reconcile with the City’s ledger. Effect: The expenditures reported on the City’s project and expenditure report and County report were not accurate. Cause: The City did not have adequate controls in place to reconcile expenditures submitted on the project and expenditure and County reports with the City’s ledger. Recommendation: Management should implement procedures to ensure that all expenditures that are incurred in a particular reporting period are included on the applicable project and expenditure report. Additionally, the City should ensure that the omitted expenditures are reported in the next reporting submission. Views of Responsible Officials and Planned Corrective Actions: Management made a good faith effort to correctly report its expenditures to the U.S. Treasury Department and Bristol County on an accurate and timely basis. Reconciliation between the reporting and accounting ledger must be completed to ensure expenditures reported are accurate. Management expects to correct this on the subsequent period’s reporting in fiscal 2024.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program $3.97M
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $2.72M
14.239 Home Investment Partnerships Program $1.50M
10.553 School Breakfast Program $1.28M
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $864,639
84.027 Special Education_grants to States $824,490
97.083 Staffing for Adequate Fire and Emergency Response (safer) $623,567
14.218 Community Development Block Grants/entitlement Grants $602,458
93.778 Medical Assistance Program $501,455
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $418,491
10.555 Covid-19 National School Lunch Program $218,714
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $166,507
84.367 Supporting Effective Instruction State Grants $156,977
10.559 Summer Food Service Program for Children $126,605
84.173 Special Education_preschool Grants $93,114
84.010 Title I Grants to Local Educational Agencies $82,546
12.000 Coronavirus State and Local Fiscal Recovery Funds $78,723
14.218 Covid-19 Community Development Block Grants/entitlement Grants $54,328
21.027 Coronavirus State and Local Fiscal Recovery Funds $44,004
84.365 English Language Acquisition State Grants $38,294
84.048 Career and Technical Education -- Basic Grants to States $29,610
20.106 Airport Improvement Program $26,025
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $20,834
16.738 Edward Byrne Memorial Justice Assistance Grant Program $16,722
84.424 Student Support and Academic Enrichment Program $12,130
84.425 Covid-19 Education Stabilization Fund $8,565
20.600 State and Community Highway Safety $7,931
20.616 National Priority Safety Programs $456
16.607 Bulletproof Vest Partnership Program $410