Finding 1205763 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-04-02
Audit: 397500
Organization: Missoula County (MT)

AI Summary

  • Core Issue: The County's internal controls for accurate reporting of COVID-19 funds were ineffective, leading to discrepancies in expenditure reports.
  • Impacted Requirements: Quarterly reports must be accurate, include all relevant expenditures, and align with accounting records as per Treasury guidelines.
  • Recommended Follow-Up: Implement procedures to ensure accurate quarterly reports and verify expenditures against the general ledger and SEFA, including correcting past reports.

Finding Text

Finding 2024-02 – 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 2024 Project and Expenditure Report of $10,850,317 and total expenditures on the Quarter 2 2023 Project and Expenditure Report of $6,861,504 and therefore indicated 2024 fiscal year expenditures were $3,988,813 and reported expenditures on the 2024 SEFA of $5,535,797. 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: None. Identification as a Repeat Finding: This is a repeat finding of 2023-003 and 2022-003. 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 SEFA. 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

Corrective Action Plan In the audit schedule of findings for the year ended June 30, 2024, the auditors identified the following item in the financial statements. The County’s corrective action plan for this item is addressed below. Finding 2024-001 – Internal Control Over Financial Reporting and Account Adjustments including the Schedule of Expenditures of Federal Awards Missoula County will begin with FY25 year-end financial reporting to provide additional training to all staff related to Financial Statement reporting. Due to staffing issues, an accounting firm will continue to support Missoula County staff in meeting deadlines with accurate information. A thorough review of all practices, policies and procedures will continue over the next fiscal year to ensure key control activities are in place. Each staff person involved with Financial Reporting will be trained on the key control activities and their importance. This information has been used in implementing a new Financial Software application which allows for business process workflows to aid departments in completing financial transactions accurately. The business process workflows include appropriate internal controls and review steps to ensure accuracy of entries. In addition, a new process for tracking monthly, quarterly and year end adjustments will be implemented. This process includes a second individual to review the year end reports for completeness, adherence to GAAP and monitoring of information reported on the Schedule of Expenditures of Federal Awards. Contact Person Responsible for Corrective Action: Michelle Denman, Financial Services Director Anticipated Completion Date of the Corrective Action: June 30, 2026 Finding 2024-002 – 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. Prior to quarterly reporting, the accountant in finance will review all expenditures related to obligated ARPA programs and reconcile this activity with each department expenditures. At the end of the quarter, after all months have closed and prior to Treasury reporting, an additional review of prior quarter activity will occur to ensure any reclassification journals have been noted to ensure prior quarter reports can be updated. Contact Person Responsible for Corrective Action: Michelle Denman, Financial Services Director Anticipated Completion Date of the Corrective Action: June 30, 2026

Categories

Reporting

Other Findings in this Audit

  • 1205761 2024-002
    Material Weakness Repeat
  • 1205762 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.224 COMMUNITY HEALTH CENTERS $837,384
20.933 NATIONAL INFRASTRUCTURE INVESTMENTS $732,972
93.658 FOSTER CARE TITLE IV-E $687,191
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $368,185
97.039 HAZARD MITIGATION GRANT $362,707
16.589 RURAL DOMESTIC VIOLENCE, DATING VIOLENCE, SEXUAL ASSAULT, AND STALKING ASSISTANCE PROGRAM $328,805
21.027 COVID-19, CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $293,368
93.527 COVID-19, AFFORDABLE CARE ACT (ACA) GRANTS FOR NEW AND EXPANDED SERVICES UNDER THE HEALTH CENTER PROGRAM $241,718
66.818 BROWNFIELDS MULTIPURPOSE, ASSESSMENT, REVOLVING LOAN FUND, AND CLEANUP COOPERATIVE AGREEMENTS $238,835
16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $193,755
16.548 DELINQUENCY PREVENTION PROGRAM $166,862
14.228 COVID-19, COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $156,369
93.526 COVID-19, FIP VERIFICATION $155,061
15.933 PRESERVATION OF JAPANESE AMERICAN CONFINEMENT SITES $152,852
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $145,231
93.527 AFFORDABLE CARE ACT (ACA) GRANTS FOR NEW AND EXPANDED SERVICES UNDER THE HEALTH CENTER PROGRAM $138,370
66.001 AIR POLLUTION CONTROL PROGRAM SUPPORT $133,956
12.121 MONTANA, NEVADA, NEW MEXICO, UTAH, IDAHO, & WYOMING ENVIRONMENTAL INFRASTRUCTURE (SECTION 595) - ARRA $133,097
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $130,000
16.575 CRIME VICTIM ASSISTANCE $117,343
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $117,122
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $111,417
93.276 DRUG-FREE COMMUNITIES SUPPORT PROGRAM GRANTS $111,249
93.977 SEXUALLY TRANSMITTED DISEASES (STD) PREVENTION AND CONTROL GRANTS $94,484
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $86,547
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $78,378
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $70,814
16.590 GRANTS TO ENCOURAGE ARREST POLICIES AND ENFORCEMENT OF PROTECTION ORDERS PROGRAM $62,729
93.918 GRANTS TO PROVIDE OUTPATIENT EARLY INTERVENTION SERVICES WITH RESPECT TO HIV DISEASE $54,739
20.939 SAFE STREETS AND ROADS FOR ALL $54,507
10.680 FOREST HEALTH PROTECTION $45,709
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $44,704
93.898 CANCER PREVENTION AND CONTROL PROGRAMS FOR STATE, TERRITORIAL AND TRIBAL ORGANIZATIONS $44,229
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $44,211
20.219 RECREATIONAL TRAILS PROGRAM $41,029
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $38,094
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $30,856
10.025 PLANT AND ANIMAL DISEASE, PEST CONTROL, AND ANIMAL CARE $30,000
15.230 INVASIVE AND NOXIOUS PLANT MANAGEMENT $30,000
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $29,589
97.039 COVID-19, HAZARD MITIGATION GRANT $26,986
10.704 LAW ENFORCEMENT AGREEMENTS $21,000
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $16,207
81.041 STATE ENERGY PROGRAM $12,000
16.021 JUSTICE SYSTEMS RESPONSE TO FAMILIES $9,863
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $8,595
10.001 AGRICULTURAL RESEARCH BASIC AND APPLIED RESEARCH $8,500
10.697 STATE & PRIVATE FORESTRY HAZARDOUS FUEL REDUCTION PROGRAM $8,000
10.698 STATE & PRIVATE FORESTRY COOPERATIVE FIRE ASSISTANCE $8,000
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $7,108
10.572 WIC FARMERS' MARKET NUTRITION PROGRAM (FMNP) $565
97.067 HOMELAND SECURITY GRANT PROGRAM $370
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $284
93.870 MATERNAL, INFANT AND EARLY CHILDHOOD HOMEVISITING GRANT PROGRAM $158