Audit 50052

FY End
2022-12-31
Total Expended
$19.94M
Findings
6
Programs
45
Organization: Scott County (MN)
Year: 2022 Accepted: 2023-07-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
47051 2022-001 Significant Deficiency - BL
47052 2022-002 Significant Deficiency - B
47053 2022-003 Significant Deficiency - E
623493 2022-001 Significant Deficiency - BL
623494 2022-002 Significant Deficiency - B
623495 2022-003 Significant Deficiency - E

Programs

ALN Program Spent Major Findings
93.778 Medical Assistance Program $3.42M Yes 3
93.563 Child Support Enforcement $1.46M - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $804,295 - 0
20.205 Highway Planning and Construction $775,373 - 0
93.558 Temporary Assistance for Needy Families $499,354 - 0
93.667 Social Services Block Grant $426,697 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $398,557 - 0
93.658 Foster Care_title IV-E $397,853 - 0
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $301,963 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $201,274 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $197,141 Yes 0
93.575 Child Care and Development Block Grant $182,682 - 0
93.268 Immunization Cooperative Agreements $125,483 - 0
93.069 Public Health Emergency Preparedness $115,409 - 0
93.276 Drug-Free Communities Support Program Grants $115,324 - 0
16.585 Drug Court Discretionary Grant Program $107,835 - 0
17.258 Wia Adult Program $83,141 - 0
93.994 Maternal and Child Health Services Block Grant to the States $72,192 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $70,840 - 0
97.042 Emergency Management Performance Grants $69,277 - 0
17.278 Wia Dislocated Worker Formula Grants $68,264 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $67,369 - 0
17.259 Wia Youth Activities $67,319 - 0
16.606 State Criminal Alien Assistance Program $63,097 - 0
66.460 Nonpoint Source Implementation Grants $58,033 - 0
97.067 Homeland Security Grant Program $55,647 - 0
17.235 Senior Community Service Employment Program $50,812 - 0
93.556 Promoting Safe and Stable Families $50,683 - 0
93.590 Community-Based Child Abuse Prevention Grants $34,650 - 0
93.958 Block Grants for Community Mental Health Services $25,000 - 0
93.747 Elder Abuse Prevention Interventions Program $24,500 - 0
93.669 Child Abuse and Neglect State Grants $22,070 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $17,076 - 0
16.710 Public Safety Partnership and Community Policing Grants $15,507 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $15,285 - 0
84.181 Special Education-Grants for Infants and Families $11,783 - 0
97.012 Boating Safety Financial Assistance $10,755 - 0
10.555 National School Lunch Program $10,551 - 0
93.439 State Physical Activity and Nutrition (span $6,366 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $5,945 - 0
10.553 School Breakfast Program $5,224 - 0
20.600 State and Community Highway Safety $3,715 - 0
20.616 National Priority Safety Programs $3,426 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $3,300 - 0
93.251 Early Hearing Detection and Intervention $2,500 - 0

Contacts

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

Notes to SEFA

Title: Note 1 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. Scott County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The schedule of expenditures of federal awards presents the activities of federal award programs expended by Scott County. Scott Countys financial statements include the operations of the Scott County Community Development Agency (CDA) component unit, which expended $5,551,192 in federal awards during the year ended December 31, 2022, which are not included in the Schedule of Expenditures of Federal Awards The CDA had a separate single audit. Scott Countys reporting entity is defined in Note 1 to the financial statements.
Title: Note 2 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. Scott County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The accompanying schedule of expenditures of federal awards includes the federal award activity of the Scott County under programs of the federal government for the year ended December 31, 2022. 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: Note 4 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. Scott County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Federal grant revenue per Schedule of Intergovernmental Revenue - $20,078,042Grants received more than 60 days after year-end unavailable in 2022-John H. Chafee Foster Care Program for Successful Transition to Adulthood - 2,491-Early Hearing Detection and Intervention - 925-Stephanie Tubbs Jones Child Welfare Services Program 7,053-Block Grants for Community Mental Health Services 25,000-Promoting Safe and Stable Families 3,956Unavailable in 2021, recognized as revenue in 2022-Special Supplemental Nutrition Program for Women, Infants, and Children (22,341)-Promoting Safe and Stable Families (1,782)-Temporary Assistance for Needy Families (141,854)-Stephanie Tubbs Jones Child Welfare Services Program (1,622) -Child Abuse and Neglect State Grant - (7,162)-Community-Based Child Abuse Prevention Grants (6,841)Expenditures Per Schedule of Expenditures of Federal Awards = $19,935,865

Finding Details

Finding 2022-001 Federal agency: U.S. Department of Health and Human Services Federal program name: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2205MN5ADM, 2022 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2205MN5ADM Award Period: Fiscal year 2022 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 fourth quarter time study report that terminated prior to the start of the fourth 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 fourth quarter. Cause: Controls were insufficient to ensure the County only reported active employees to the State on their random moment roster. Effect: The County reported employees previously terminated to the State of Minnesota which were subject to the random moment surveys The State Department of Health and Human Services conducts. Repeat Finding: No Recommendation: We recommend the County reviews its procedures for giving timely notice of an individual?s termination 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.
Finding 2022-002 Federal agency: U.S. Department of Health and Human Services Federal program name: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2205MN5ADM, 2022 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2205MN5ADM Award Period: Fiscal year 2022 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 allowable costs over payroll related to the County?s cost allocation plan we noted one of our selections did not have approval for their timesheet. Questioned Costs: None Context: The County?s cost allocation plan utilized the County?s expenditures and operations for the calendar year ending December 31, 2020. For one of the 32 timesheets selected for testing as part of the County?s cost allocation plan, the County was not able to provide support for a supervisor review. Cause: The timesheet was missed due to the timing of leaving offices at the start of the COVID-19 pandemic. Effect: The County was not in compliance with time and effort documentation requirements of the Uniform Guidance. Repeat Finding: No Recommendation: We recommend the County puts in place the proper procedures to document all approvals of timesheets coded to the grant. Views of responsible officials: There is no disagreement with the finding.
Finding 2022-003 Federal agency: U.S. Department of Health and Human Services Federal program name: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2205MN5ADM, 2022 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2205MN5ADM Award Period: Fiscal year 2022 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 casefile that had no documentation of the review. Questioned Costs: None Context: It was noted for one of forty case files selected for testing, there was no documentation of a review being performed. Cause: The County?s lead worker in-charge of reviews separated from the County during the year and County staff was not able to locate where the casefile review form was stored on the County?s network. Effect: The County was not in compliance with internal control over eligibility requirements of the Uniform Guidance. Repeat Finding: No Recommendation: We recommend the County reviews its procedures to ensure all casefile reviews are documented. Views of responsible officials: There is no disagreement with the finding.
Finding 2022-001 Federal agency: U.S. Department of Health and Human Services Federal program name: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2205MN5ADM, 2022 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2205MN5ADM Award Period: Fiscal year 2022 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 fourth quarter time study report that terminated prior to the start of the fourth 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 fourth quarter. Cause: Controls were insufficient to ensure the County only reported active employees to the State on their random moment roster. Effect: The County reported employees previously terminated to the State of Minnesota which were subject to the random moment surveys The State Department of Health and Human Services conducts. Repeat Finding: No Recommendation: We recommend the County reviews its procedures for giving timely notice of an individual?s termination 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.
Finding 2022-002 Federal agency: U.S. Department of Health and Human Services Federal program name: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2205MN5ADM, 2022 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2205MN5ADM Award Period: Fiscal year 2022 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 allowable costs over payroll related to the County?s cost allocation plan we noted one of our selections did not have approval for their timesheet. Questioned Costs: None Context: The County?s cost allocation plan utilized the County?s expenditures and operations for the calendar year ending December 31, 2020. For one of the 32 timesheets selected for testing as part of the County?s cost allocation plan, the County was not able to provide support for a supervisor review. Cause: The timesheet was missed due to the timing of leaving offices at the start of the COVID-19 pandemic. Effect: The County was not in compliance with time and effort documentation requirements of the Uniform Guidance. Repeat Finding: No Recommendation: We recommend the County puts in place the proper procedures to document all approvals of timesheets coded to the grant. Views of responsible officials: There is no disagreement with the finding.
Finding 2022-003 Federal agency: U.S. Department of Health and Human Services Federal program name: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2205MN5ADM, 2022 Pass-Through Agency: Minnesota Department of Human Services Pass-Through Number: 2205MN5ADM Award Period: Fiscal year 2022 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 casefile that had no documentation of the review. Questioned Costs: None Context: It was noted for one of forty case files selected for testing, there was no documentation of a review being performed. Cause: The County?s lead worker in-charge of reviews separated from the County during the year and County staff was not able to locate where the casefile review form was stored on the County?s network. Effect: The County was not in compliance with internal control over eligibility requirements of the Uniform Guidance. Repeat Finding: No Recommendation: We recommend the County reviews its procedures to ensure all casefile reviews are documented. Views of responsible officials: There is no disagreement with the finding.