Audit 43418

FY End
2022-06-30
Total Expended
$1.03M
Findings
12
Programs
7
Organization: Dodge County, Nebraska (NE)
Year: 2022 Accepted: 2023-02-08

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
52104 2022-002 Significant Deficiency - P
52105 2022-002 Significant Deficiency Yes P
52106 2022-002 Significant Deficiency Yes P
52107 2022-002 Significant Deficiency - P
52108 2022-002 Significant Deficiency - P
52109 2022-002 Significant Deficiency - P
628546 2022-002 Significant Deficiency - P
628547 2022-002 Significant Deficiency Yes P
628548 2022-002 Significant Deficiency Yes P
628549 2022-002 Significant Deficiency - P
628550 2022-002 Significant Deficiency - P
628551 2022-002 Significant Deficiency - P

Contacts

Name Title Type
SEVKMM9Q25D7 Micki Gilgry Auditee
4027272767 Kent Speicher Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1 - Basis of Presentation The accompanying schedule of expenditures of federal and state awards includes the federal grant activity of Dodge County, Nebraska and is presented on the cash basis of accounting. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations, Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in or used in the preparation of financial statements. The entity has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. Note 2 - Basis of Accounting The Schedule of Expenditures of Federal Awards is prepared on the cash basis of accounting. Most federal grants received by the County are funded on a cost-reimbursement basis whereby expenditures are subject to audit by various government agencies prior to submitting reimbursement. Under such circumstances and in a manner consistent with the basis of accounting described, expenditure balances for these grants represent the disbursement of funds during the course of the year. This treatment results in timing differences, which are resolved over the term of the grant. Note 3 - Pass-Through Awards The County receives certain federal awards in the form of pass-through awards from the State of Nebraska and other various agencies. Such amounts received as pass-through awards are specifically identified on the Schedule of Expenditures of Federal Awards. Note 4 - Contingencies The County receives funds under various federal grant programs and such assistance is to be expended in accordance with the provisions of the various grants. Compliance with the grants is subject to audit by various government agencies which may impose sanctions in the event of noncompliance. Management believes that they have complied with all aspects of the various grant provisions and the results of adjustments, if any, relating to such audits would not have a material financial impact. Note 5 - Indirect Costs The County has elected not to use the 10% de minimus cost rate allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.