Finding 479524 (2022-003)

Material Weakness
Requirement
L
Questioned Costs
$1
Year
2022
Accepted
2024-07-26
Audit: 316057
Organization: Missoula County (MT)

AI Summary

  • Core Issue: The County's internal controls for ensuring accurate quarterly reports to the Treasury are ineffective, leading to discrepancies in reported expenditures.
  • Impacted Requirements: Quarterly reports must accurately reflect all activities and expenditures, supported by accounting records, as per Treasury guidelines.
  • Recommended Follow-Up: Implement procedures to ensure accurate reporting and verify expenditures against the general ledger; correct any previously submitted reports as needed.

Finding Text

Finding 2022-003 – Reporting U.S. Department of Treasury COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) – ALN 21.027 Reporting Condition: The internal control system to ensure that the Project and Expenditure Report submitted to Treasury was accurate was not operating effectively. The County reported total expenditures on the Quarter 2 2022 Project and Expenditure Report of $4,196,958 and reported expenditures on the schedule of expenditures of federal awards of $4,909,868. Criteria: Quarterly reports are required to be accurate and include all activity of the reporting period, supported by the applicable accounting records, and fairly presented in accordance with Treasury requirements. The reports are to include the current period expenditures, as well as the cumulative expenditures related to the projects. Cause: Internal controls in place to ensure that the quarterly reports were completed accurately were not adequate. Effect: The quarterly reports submitted to Treasury do not contain information supported by the accounting records of the County. Questioned Costs: Unknown. Identification as a Repeat Finding: This is not a repeat finding from the prior audit. Recommendation: We recommend the County implement a procedure to ensure that all required quarterly reports are completed accurately, and verify that the expenditures agree to the amounts reported in the general ledger and schedule of expenditures of federal awards. In addition, we recommend that the County ensure proper correction of previously submitted reports. Views of Responsible Officials and Planned Corrective Actions: Management agrees with this finding. See separate Corrective Action Plan.

Corrective Action Plan

Finding 2022-003 – Reporting U.S. Department of Treasury COVID-19 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF)- ALN 21.027 Reporting – Missoula County has implemented a dual control process over CSLFRF reporting. As part of the month end process the accountant in finance will review all expenditures related to obligated ARPA programs and reconcile this activity with each department. At the end of the quarter after all months have closed and prior to Treasury reporting an additional review of quarter will occur by the Senior Accountant in finance. This documentation will be reconciled to the Treasury quarterly reports to ensure accurate reporting. Contact Person Responsible for the Corrective Action: Michelle Denman, Deputy Financial Services Director Anticipated Completion Date of the Corrective Action: June 30, 2023

Categories

Questioned Costs Reporting

Other Findings in this Audit

  • 479523 2022-004
    Material Weakness
  • 1055965 2022-004
    Material Weakness
  • 1055966 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $4.91M
93.527 Grants for New and Expanded Services Under the Health Center Program $3.68M
93.224 Health Center Program (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $1.87M
20.933 National Infrastructure Investments $1.75M
93.268 Immunization Cooperative Agreements $1.16M
21.019 Covid-19 Coronavirus Relief Fund $1.15M
97.047 Bric: Building Resilent Infrastructure and Communities $832,156
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $732,320
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $315,719
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $313,795
93.658 Foster Care_title IV-E $203,449
10.665 Schools and Roads - Grants to States $195,754
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $194,356
93.665 Covid-19 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $165,652
93.958 Block Grants for Community Mental Health Services $160,000
97.042 Emergency Management Performance Grants $146,000
16.575 Crime Victim Assistance $140,017
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $135,490
16.589 Rural Domestic Violence, Dating Violence, Sexual Assault, and Stalking Assistance Program $129,152
90.404 Hava Election Security Grants $100,315
97.067 Homeland Security Grant Program $85,322
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $85,088
93.276 Drug-Free Communities Support Program Grants $84,503
93.994 Maternal and Child Health Services Block Grant to the States $68,120
66.001 Air Pollution Control Program Support $63,332
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $62,317
20.600 State and Community Highway Safety $62,129
14.267 Continuum of Care Program $60,114
16.034 Covid-19 Coronavirus Emergency Supplemental Funding Program $50,000
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $36,212
95.001 High Intensity Drug Trafficking Areas Program $33,771
16.588 Violence Against Women Formula Grants $30,542
16.582 Crime Victim Assistance/discretionary Grants $27,584
10.558 Child and Adult Care Food Program $27,557
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $24,280
10.664 Cooperative Forestry Assistance $22,927
20.616 National Priority Safety Programs $22,167
16.585 Treatment Court Discretionary Grant Program $19,413
12.121 Montana, Nevada, New Mexico, Utah, Idaho, & Wyoming Environmental Infrastructure (section 595) - Arra $19,000
93.576 Refugee and Entrant Assistance_discretionary Grants $18,677
16.548 Delinquency Prevention Program $15,196
16.738 Edward Byrne Memorial Justice Assistance Grant Program $14,676
93.136 Injury Prevention and Control Research and State and Community Based Programs $10,000
16.838 Comprehensive Opioid, Stimulant, and Other Substances Use Program $7,436
14.218 Covid-19 Community Development Block Grants/entitlement Grants $5,736
14.228 Covid-19 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $4,285
93.426 The National Cardiovascular Health Program $3,748
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $1,300
10.572 Wic Farmers' Market Nutrition Program (fmnp) $607
93.435 The Innovative Cardiovascular Health Program $330