Finding 1073669 (2023-005)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-09-17
Audit: 319814
Organization: Platte County, Nebraska (NE)
Auditor: Mdt LLC

AI Summary

  • Core Issue: The County lacks a reliable internal control system for tracking federal expenditures, risking incomplete or inaccurate financial reporting.
  • Impacted Requirements: Management must establish controls to ensure the schedule of expenditures aligns with cash basis accounting and includes all relevant disclosures.
  • Recommended Follow-Up: The County should approve auditor adjustments, enhance tracking procedures for federal expenditures, and assign a dedicated individual for oversight.

Finding Text

INTERNAL CONTROL OVER SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS PREPARATION AND REVIEW Condition: The County does not have a system of internal control that would provide management with reasonable assurance that the County’s schedule of expenditures of federal awards and related disclosures are complete and presented in accordance with the cash basis of accounting. As such, management requested us to compile the trial balance from the general ledger and prepare a draft of the schedule of expenditure of federal awards, including the related note disclosures. Criteria: As described in our engagement letter, management is responsible for establishing and maintaining internal controls, including monitoring, and for the fair presentation of the schedule of expenditures of federal awards, in conformity with the cash basis of accounting. Context: The County does not have a way of tracking the federal expenditures and awards. Effect: The potential exists that a material misstatement of the schedule of expenditures of federal awards could occur and not be prevented or detected by the County’s internal control. Cause: Management does not prepare the schedule of expenditures of federal awards or track the federal expenditures to ensure all expenditures are included within the proper federal expenditure accounts. There were also some federal grant expenditures that had not been posted onto the County’s accounting program. Questioned Costs: None Repeat Finding: No Recommendation: We recommend that the County review and approve the proposed auditor adjusting entries and the adequacy of the schedule of the expenditures of federal awards disclosures prepared by the auditors among other procedures as considered necessary by management. We also recommend that the County designate an individual responsible for tracking the federal expenditures of the County. View of Officials: The County reviews the schedule of expenditures of federal awards and approves all adjustments. The County will implement procedures to track the federal expenditures of the County.

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 497226 2023-006
    Significant Deficiency
  • 497227 2023-005
    Material Weakness
  • 1073668 2023-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.55M
97.039 Hazard Mitigation Grant $507,289
97.067 Homeland Security Grant Program $504,764
93.563 Child Support Enforcement $183,675
16.575 Crime Victim Assistance $106,725
97.042 Emergency Management Performance Grants $42,277
20.616 National Priority Safety Programs $21,905
20.600 State and Community Highway Safety $17,149
90.404 2018 Hava Election Security Grants $6,289