Audit 43619

FY End
2022-12-31
Total Expended
$15.12M
Findings
2
Programs
39
Organization: Carver County (MN)
Year: 2022 Accepted: 2023-07-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
50966 2022-001 Significant Deficiency - L
627408 2022-001 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
20.205 Highway Planning and Construction $6.97M - 0
93.658 Foster Care_title IV-E $550,933 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $500,000 Yes 0
93.268 Immunization Cooperative Agreements $412,493 - 0
93.558 Temporary Assistance for Needy Families $403,945 - 0
93.667 Social Services Block Grant $301,918 - 0
93.563 Child Support Enforcement $188,678 - 0
16.585 Drug Court Discretionary Grant Program $152,933 - 0
93.069 Public Health Emergency Preparedness $109,038 - 0
17.259 Wia Youth Activities $92,936 - 0
16.575 Crime Victim Assistance $75,908 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $60,541 - 0
90.404 2018 Hava Election Security Grants $46,641 - 0
17.258 Wia Adult Program $44,767 - 0
93.994 Maternal and Child Health Services Block Grant to the States $41,208 - 0
17.278 Wia Dislocated Worker Formula Grants $35,203 - 0
93.590 Community-Based Child Abuse Prevention Grants $30,445 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $29,797 - 0
97.042 Emergency Management Performance Grants $26,049 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $25,878 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $23,612 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $22,668 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $17,340 - 0
93.669 Child Abuse and Neglect State Grants $10,768 - 0
93.778 Medical Assistance Program $10,565 Yes 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $8,311 - 0
93.556 Promoting Safe and Stable Families $7,290 - 0
20.600 State and Community Highway Safety $7,225 - 0
97.012 Boating Safety Financial Assistance $7,000 - 0
84.181 Special Education-Grants for Infants and Families $3,743 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $3,661 - 0
93.767 Children's Health Insurance Program $3,361 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $3,350 - 0
20.616 National Priority Safety Programs $3,337 - 0
10.558 Child and Adult Care Food Program $1,526 - 0
15.662 Great Lakes Restoration $1,295 - 0
93.251 Early Hearing Detection and Intervention $1,100 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $997 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $358 - 0

Contacts

Name Title Type
YHGENJ4C3VZ4 Mary Kaye Wahl Auditee
9523611511 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 modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Carver County has elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The Schedule of Expenditures of Federal Awards presents the activities of federal award programs expended by Carver County. Carver County's financial statements include the operations of the Carver County Community Development Agency (the CDA) component unit, which expended $1,785,899 in federal awards during the year ended December 31, 2022,which are not included in the Schedule of Expenditures of Federal Awards. The CDA has its own single audit. The County's 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 modified accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles contained in OMB Circular A-87, Cost Principles for State, Local and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Carver County has elected to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Carver 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 Carver County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Carver County.

Finding Details

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; Other Matter Criteria or specific requirement: Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal awards based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: During our testing of random moment studies, we identified an individual reported on the second quarter time study report was terminated on March 11th, 2022, the report was certified March 30th, 2022. The Health and Human Services department was not notified of the individual?s termination until April 1st, 2022. Questioned Costs: None Context: Out of the individuals selected for time study testing it was noted that one was incorrectly included on the random moment study report for quarter two. Cause: The Health and Human Services department was unaware of the individual?s termination until after the certification of the report. 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 reviews its procedures for giving timely notice of an individual?s termination to other departments. Views of responsible officials: There is no disagreement with the finding.
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; Other Matter Criteria or specific requirement: Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must: (i) Be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; (ii) Be incorporated into the official records of the non-Federal entity; (iii) Reasonably reflect the total activity for which the employee is compensated by the non-Federal entity, (iv) Encompass both federally assisted and all other activities compensated by the non-Federal entity on an integrated basis, but may include the use of subsidiary records as defined in the non-Federal entity's written policy; (v) Comply with the established accounting policies and practices of the non-Federal entity (See paragraph (h)(1)(ii) above for treatment of incidental work for IHEs.); and (vii) Support the distribution of the employee's salary or wages among specific activities or cost objectives if the employee works on more than one Federal award; a Federal award and non-Federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. (viii) Budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that: (A) The system for establishing the estimates produces reasonable approximations of the activity actually performed; (B) Significant changes in the corresponding work activity (as defined by the non-Federal entity's written policies) are identified and entered into the records in a timely manner. Short term (such as one or two months) fluctuation between workload categories need not be considered as long as the distribution of salaries and wages is reasonable over the longer term; and (C) The non-Federal entity's system of internal controls includes processes to review after-the-fact interim charges made to a Federal awards based on budget estimates. All necessary adjustment must be made such that the final amount charged to the Federal award is accurate, allowable, and properly allocated. Condition: During our testing of random moment studies, we identified an individual reported on the second quarter time study report was terminated on March 11th, 2022, the report was certified March 30th, 2022. The Health and Human Services department was not notified of the individual?s termination until April 1st, 2022. Questioned Costs: None Context: Out of the individuals selected for time study testing it was noted that one was incorrectly included on the random moment study report for quarter two. Cause: The Health and Human Services department was unaware of the individual?s termination until after the certification of the report. 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 reviews its procedures for giving timely notice of an individual?s termination to other departments. Views of responsible officials: There is no disagreement with the finding.