Audit 317969

FY End
2023-12-31
Total Expended
$19.27M
Findings
4
Programs
47
Organization: Scott County (MN)
Year: 2023 Accepted: 2024-08-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
485158 2023-001 Significant Deficiency - E
485159 2023-002 Significant Deficiency Yes B
1061600 2023-001 Significant Deficiency - E
1061601 2023-002 Significant Deficiency Yes B

Programs

ALN Program Spent Major Findings
93.778 Medical Assistance Program $4.03M - 0
93.563 Child Support Enforcement $1.50M Yes 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $1.11M - 0
20.205 Highway Planning and Construction $955,408 - 0
93.658 Foster Care_title IV-E $882,199 Yes 2
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $468,320 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $464,511 - 0
93.667 Social Services Block Grant $426,907 - 0
93.558 Temporary Assistance for Needy Families $418,094 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $274,546 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $224,000 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $197,141 Yes 0
93.575 Child Care and Development Block Grant $194,757 - 0
93.276 Drug-Free Communities Support Program Grants $147,612 - 0
16.585 Drug Court Discretionary Grant Program $129,575 - 0
93.556 Promoting Safe and Stable Families $121,638 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $113,735 - 0
93.069 Public Health Emergency Preparedness $110,877 - 0
17.278 Wia Dislocated Worker Formula Grants $90,670 - 0
17.259 Wia Youth Activities $88,406 - 0
66.460 Nonpoint Source Implementation Grants $83,827 - 0
93.994 Maternal and Child Health Services Block Grant to the States $66,564 - 0
97.067 Homeland Security Grant Program $65,300 - 0
17.258 Wia Adult Program $59,749 - 0
97.012 Boating Safety Financial Assistance $56,191 - 0
16.606 State Criminal Alien Assistance Program $41,745 - 0
17.235 Senior Community Service Employment Program $33,292 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $31,149 - 0
93.590 Community-Based Child Abuse Prevention Grants $28,899 - 0
93.439 State Physical Activity and Nutrition (span $25,053 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $20,000 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $19,079 - 0
93.268 Immunization Cooperative Agreements $17,486 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $16,828 - 0
93.958 Block Grants for Community Mental Health Services $12,420 - 0
10.555 National School Lunch Program $10,255 - 0
93.008 Medical Reserve Corps Small Grant Program $10,000 - 0
20.600 State and Community Highway Safety $8,394 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $8,196 - 0
10.553 School Breakfast Program $5,515 - 0
84.181 Special Education-Grants for Infants and Families $4,200 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $3,957 - 0
93.251 Early Hearing Detection and Intervention $3,575 - 0
93.747 Elder Abuse Prevention Interventions Program $3,166 - 0
20.616 National Priority Safety Programs $2,869 - 0
93.967 Cdc's Collaboration with Academia to Strengthen Public Health $1,400 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $527 - 0

Contacts

Name Title Type
CDXWN3B8CKL5 Danny Lenz Auditee
9524968166 Christopher Knopik Auditor
No contacts on file

Notes to SEFA

Title: Reporting Entity Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Scott County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The schedule of expenditures of federal awards (the Schedule) presents the activities of federal award programs expended by Scott County. Scott County’s financial statements include the operations of the Scott County Community Development Agency (CDA) component unit, which expended $6,619,554 in federal awards during the year ended December 31, 2023, which are not included in the Schedule. The CDA had a separate single audit. Scott County’s reporting entity is defined in Note 1 to the financial statements.
Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Scott County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying Schedule includes the federal award activity of the Scott County under programs of the federal government for the year ended December 31, 2023. 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). Because the Schedule presents only a selected portion of the operations of the CDA, it is not intended to and does not present the financial position, changes in net position, or cash flows of Scott County.
Title: Reconciliation to Schedule of Intergovernmental Revenue Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts, if any, shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Scott County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. Federal Grant Revenue per Schedule of Intergovernmental Revenue $ 19,262,246 Grants Received More than 60 Days After Year-End Unavailable in 2023 Stephanie Tubbs Jones Child Welfare Services Program 3,008 Promoting Safe and Stable Families 2,994 Foster Care Title IV-E 43,804 Unavailable in 2022, Recognized as Revenue in 2023 John H. Chafee Foster Care Program for Successful Transition to (2,491) Early Hearing Detection and Intervention (925) Stephanie Tubbs Jones Child Welfare Services Program (3,956) Block Grants for Community Mental Health Services (25,000) Promoting Safe and Stable Families (7,053) Expenditures Per Schedule of Expenditures of Federal Awards $ 19,272,627

Finding Details

Federal agency: U.S. Department of Health and Human Services Federal program name: Foster Care Title IV-E Assistance Listing Number: 93.658 Federal Award Identification Number and Year: 2301MNFOST, 2023 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2301MNFOST Award Period: Fiscal year 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: A nonfederal entity must: (i) Establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal Award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO); (ii) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal award; (iii) Evaluate and monitor the non-Federal entity’s compliance with statutes, regulations, and the terms and conditions of Federal awards; (iv) Take prompt action when instances of noncompliance are identified including noncompliance identified in audit findings; and (v) Take reasonable measures to safeguard protected personally identifiable information and other information the Federal awarding agency or pass-through entity designates as sensitive or the non-Federal entity considers sensitive consistent with applicable Federal, State, local, and tribal laws regarding privacy and responsibility of confidentiality. Condition: During our testing of casefile review, we identified one participant that did not have appropriate action taken to resolve issues noted during the initial stage of review. Questioned Costs: Unknown Context: The reviewer of the casefile was informed that correction action was taken and in the following quarter there was no exception reported for this same issue. Cause: Controls were insufficient to ensure this process occurred. Effect: The County has a review process to catch errors in casefiles, however, if the County does not remedy errors fully, there can still be compliance issues outstanding after review. Repeat Finding: No Recommendation: We recommend the County reviews its procedures to ensure all casefile reviews are documented and all issues in the casefiles are followed up on and remedied properly. Views of responsible officials: There is no disagreement with the finding.
Federal agency: U.S. Department of Health and Human Services Federal program name: Foster Care Title IV-E Assistance Listing Number: 93.658 Federal Award Identification Number and Year: 2301MNFOST, 2023 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2301MNFOST Award Period: Fiscal year 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: A nonfederal entity must: (i) Establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal Award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO); (ii) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal award; (iii) Evaluate and monitor the non-Federal entity’s compliance with statutes, regulations, and the terms and conditions of Federal awards; (iv) Take prompt action when instances of noncompliance are identified including noncompliance identified in audit findings; and (v) Take reasonable measures to safeguard protected personally identifiable information and other information the Federal awarding agency or pass-through entity designates as sensitive or the non-Federal entity considers sensitive consistent with applicable Federal, State, local, and tribal laws regarding privacy and responsibility of confidentiality. Condition: During our testing of random moment studies, we identified three individuals reported on the first quarter time study report that were terminated or resigned prior to the start of the first quarter. Questioned Costs: Unknown Context: Out of the individuals selected for time study testing, it was noted that three individuals were incorrectly included on the random moment study roster that was submitted to the State for the first quarter. Cause: Controls were insufficient to ensure the County only reported active employees to the State on their random moment study roster. Effect: The County reported employees previously terminated or resigned to the State of Minnesota which were subject to the random moment surveys The State Department of Health and Human Services conducts. Repeat Finding: Yes - 2022-003 Recommendation: We recommend the County reviews its procedures for giving timely notice of an individual’s termination or resignation to other departments as well as ensuring departments are reviewing the information provided to granting agencies. Views of responsible officials: There is no disagreement with the finding.
Federal agency: U.S. Department of Health and Human Services Federal program name: Foster Care Title IV-E Assistance Listing Number: 93.658 Federal Award Identification Number and Year: 2301MNFOST, 2023 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2301MNFOST Award Period: Fiscal year 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: A nonfederal entity must: (i) Establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal Award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO); (ii) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal award; (iii) Evaluate and monitor the non-Federal entity’s compliance with statutes, regulations, and the terms and conditions of Federal awards; (iv) Take prompt action when instances of noncompliance are identified including noncompliance identified in audit findings; and (v) Take reasonable measures to safeguard protected personally identifiable information and other information the Federal awarding agency or pass-through entity designates as sensitive or the non-Federal entity considers sensitive consistent with applicable Federal, State, local, and tribal laws regarding privacy and responsibility of confidentiality. Condition: During our testing of casefile review, we identified one participant that did not have appropriate action taken to resolve issues noted during the initial stage of review. Questioned Costs: Unknown Context: The reviewer of the casefile was informed that correction action was taken and in the following quarter there was no exception reported for this same issue. Cause: Controls were insufficient to ensure this process occurred. Effect: The County has a review process to catch errors in casefiles, however, if the County does not remedy errors fully, there can still be compliance issues outstanding after review. Repeat Finding: No Recommendation: We recommend the County reviews its procedures to ensure all casefile reviews are documented and all issues in the casefiles are followed up on and remedied properly. Views of responsible officials: There is no disagreement with the finding.
Federal agency: U.S. Department of Health and Human Services Federal program name: Foster Care Title IV-E Assistance Listing Number: 93.658 Federal Award Identification Number and Year: 2301MNFOST, 2023 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2301MNFOST Award Period: Fiscal year 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or specific requirement: A nonfederal entity must: (i) Establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal Award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO); (ii) Comply with the U.S. Constitution, Federal statutes, regulations, and the terms and conditions of the Federal award; (iii) Evaluate and monitor the non-Federal entity’s compliance with statutes, regulations, and the terms and conditions of Federal awards; (iv) Take prompt action when instances of noncompliance are identified including noncompliance identified in audit findings; and (v) Take reasonable measures to safeguard protected personally identifiable information and other information the Federal awarding agency or pass-through entity designates as sensitive or the non-Federal entity considers sensitive consistent with applicable Federal, State, local, and tribal laws regarding privacy and responsibility of confidentiality. Condition: During our testing of random moment studies, we identified three individuals reported on the first quarter time study report that were terminated or resigned prior to the start of the first quarter. Questioned Costs: Unknown Context: Out of the individuals selected for time study testing, it was noted that three individuals were incorrectly included on the random moment study roster that was submitted to the State for the first quarter. Cause: Controls were insufficient to ensure the County only reported active employees to the State on their random moment study roster. Effect: The County reported employees previously terminated or resigned to the State of Minnesota which were subject to the random moment surveys The State Department of Health and Human Services conducts. Repeat Finding: Yes - 2022-003 Recommendation: We recommend the County reviews its procedures for giving timely notice of an individual’s termination or resignation to other departments as well as ensuring departments are reviewing the information provided to granting agencies. Views of responsible officials: There is no disagreement with the finding.