Finding 52104 (2022-002)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-02-08
Audit: 43418
Organization: Dodge County, Nebraska (NE)

AI Summary

  • Core Issue: Federal grant costs were not properly reconciled to the general ledger, impacting compliance with federal cost principles.
  • Impacted Requirements: Costs must be necessary, reasonable, allocable, and adequately documented as per 2 CFR part 200.
  • Recommended Follow-Up: Management should implement a system to separately track federal expenditures from non-federal ones to ensure accurate reporting.

Finding Text

C. FINDINGS AND QUESTIONED COSTS ? FEDERAL AWARD PROGRAM AUDIT Reference Number Significant Deficiency 2022-002 Grant Costs not reconciled to detail general ledger Criteria Cost principles in 2 CFR part 200, Subpart E (Cost Principles), prescribe general cost principles to be followed to be considered allowable under federal awards. The criteria states costs must be necessary and reasonable for the performance of the federal award, be allocable and adequately documented. Condition While all costs tested were determined to be necessary and reasonable for the performance of the federal award, federal expenditures are not allocable and adequately documented within the detail general ledger. Cause The County went through their first single audit last year, but not in a timely manner, in order to take corrective action for the current audit. When the federal awards were initially received, they were not separately traced and monitored from non-federal awards. Due to the lack of being allocable between federal and non-federal, the County was unable to create a schedule of federal expenditures for fiscal year 2022 in a timely and accurate manner at the start of the audit. This was corrected, but not until significantly after the close of the fiscal year. Effect The lack of internal controls surrounding allocating costs could lead to potential funding issues in the future. Recommendation We recommend that management separately track and monitor federal expenditures from non-federal expenditures in their accounting system. Response Tracking is being handled in each department on a grant by grant basis, but no attempt has been made to make sure this tracks back into the detail general ledger at the Clerk?s office. Corrective action is being taken to add fields within the detail general ledger to track expenditures on a grant by grant basis where possible and to monitor these expenditures going forward.

Corrective Action Plan

Corrective Action Plan February 1, 2023 Contact Person: Micki Gilfry, Dodge County Clerk clerk@dodgecountyne.gov 402-727-2767 FINDING 2022-001: Lack of Segregation of Duties With Dodge County departments being relatively small in employee numbers, it is extremely difficult or nearly impossible to provide appropriate segregation of duties within all departments, except for County Clerk and County Treasurer offices. Dodge County will continue to work on ideas to correct this situation or at least reduce the exposure. Reasonable completion date: May 31, 2023 Responsible Party: Micki Gilfry, Dodge County Clerk and Dodge County Finance Committee FINDING 2022-001: Grant costs not reconciled to detail general ledger The flooding of 2019 created destruction like none seen before, and Federal awards began flowing into the County before they had time to understand the requirements on how to adequately document these federal expenditures from non-federal expenditure. The County over the last couple of years has been working on ideas within its accounts payable system to add fields to track expenditures on a grant by grant basis to ensure there is appropriate tracking and monitoring of these federal expenditures in our accounting system going forward. This tracking and monitoring will assist in complying with the single audit procedures required for Federal awards. Reasonable completion date: May 31, 2023 Responsible Party: Micki Gilfry, Dodge County Clerk and Dodge County Finance Committee

Categories

Allowable Costs / Cost Principles Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 52105 2022-002
    Significant Deficiency Repeat
  • 52106 2022-002
    Significant Deficiency Repeat
  • 52107 2022-002
    Significant Deficiency
  • 52108 2022-002
    Significant Deficiency
  • 52109 2022-002
    Significant Deficiency
  • 628546 2022-002
    Significant Deficiency
  • 628547 2022-002
    Significant Deficiency Repeat
  • 628548 2022-002
    Significant Deficiency Repeat
  • 628549 2022-002
    Significant Deficiency
  • 628550 2022-002
    Significant Deficiency
  • 628551 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
10.904 Watershed Protection and Flood Prevention $257,182
97.039 Hazard Mitigation Grant $222,358
20.616 National Priority Safety Programs $32,075
20.600 State and Community Highway Safety $26,441
21.027 Coronavirus State and Local Fiscal Recovery Funds $18,154
97.042 Emergency Management Performance Grants $5,602
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $3,006