Audit 321886

FY End
2023-12-31
Total Expended
$7.74M
Findings
4
Programs
31
Organization: Chisago County (MN)
Year: 2023 Accepted: 2024-09-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
499092 2023-002 Material Weakness - AB
499093 2023-003 Material Weakness Yes I
1075534 2023-002 Material Weakness - AB
1075535 2023-003 Material Weakness Yes I

Programs

ALN Program Spent Major Findings
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $3.45M Yes 2
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $516,904 - 0
93.563 Child Support Enforcement $494,126 - 0
93.658 Foster Care_title IV-E $298,742 - 0
93.558 Temporary Assistance for Needy Families $279,108 - 0
93.667 Social Services Block Grant $243,670 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $213,604 - 0
93.323 Covid-19 - Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $99,844 - 0
97.012 Boating Safety Financial Assistance $76,970 - 0
16.575 Crime Victim Assistance $67,966 - 0
93.069 Public Health Emergency Preparedness $55,675 - 0
93.994 Maternal and Child Health Services Block Grant to the States $39,476 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $28,326 - 0
93.575 Child Care and Development Block Grant $26,357 - 0
20.600 State and Community Highway Safety $25,202 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $24,434 - 0
93.778 Medical Assistance Program $18,036 - 0
93.590 Community-Based Child Abuse Prevention Grants $15,403 - 0
84.181 Special Education-Grants for Infants and Families $12,901 - 0
20.616 National Priority Safety Programs $7,220 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $5,001 - 0
15.662 Great Lakes Restoration $4,426 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $4,259 - 0
93.747 Elder Abuse Prevention Interventions Program $4,184 - 0
93.556 Promoting Safe and Stable Families $3,155 - 0
93.767 Children's Health Insurance Program $2,108 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $1,705 - 0
93.674 Covid-19 - John H. Chafee Foster Care Program for Successful Transition to Adulthood $947 - 0
16.543 Missing Children's Assistance $936 - 0
93.268 Immunization Cooperative Agreements $604 - 0
10.572 Wic Farmers' Market Nutrition Program (fmnp) $600 - 0

Contacts

Name Title Type
GVHPL2BDV794 Bridgitte Konrad Auditee
6512138509 Julie Blaha Auditor
No contacts on file

Notes to SEFA

Title: Reconciliation to Schedule of Intergovernmental Revenue Accounting Policies: Summary of Significant Accounting Policies Reporting Entity The Schedule of Expenditures of Federal Awards presents the activities of federal award programs expended by Chisago County. The County’s reporting entity is defined in Note 1.A. to the financial statements. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Chisago 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 Chisago County, it is not intended to and does not present the financial position or changes in net position of Chisago County. Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: De Minimis Cost Rate Chisago County has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. See Notes to the SEFA for Charts/Tables

Finding Details

2023-002 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Prior Year Finding Number: N/A Year of Finding Origination: 2023 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Material Weakness and Modified Opinion Federal Agency: U.S. Department of Treasury Program: 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Award Number and Year: SLFRP2192; 2021 Pass-Through Agency: N/A – Direct Criteria: Title 2 U.S. Code of Federal Regulations § 200.303 states that the auditee must establish and maintain effective internal control over the federal award that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Title 2 U.S. Code of Federal Regulations §2 CFR 200.403(a) and §2 CFR 200.403(g) require costs to be necessary and reasonable, and be adequately documented. Condition: The County did not obtain itemized documentation for five out of 22 disbursements tested. The amount of disbursements that did not have supporting documentation totaled $818,036. Questioned Costs: $818,036 Context: The County disbursed funds to cities and towns as non-entitlement units of government (NEU), however; the NEU designation only applies to states providing funds to local governments. The sample size was originally based on guidance from Chapter 11 of the AICPA Audit Guide, Government Auditing and Single Audits, but was expanded to include four additional payments identified by the County as payments to NEUs. Effect: The County has insufficient documentation to demonstrate expenditures were for allowable activities and met the requirements of allowable costs. Cause: The County believed funds could be disbursed to cities and towns as NEUs. Because of this determination, the County did not obtain itemized support for expenditures incurred. Recommendation: We recommend Chisago County obtain itemized documentation related to grant expenditures to document expenditures were for allowable activities and met the requirements of allowable costs. View of Responsible Official: Acknowledge
2023-003 Suspension and Debarment Prior Year Finding Number: 2022-002 Year of Finding Origination: 2022 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Material Weakness and Modified Opinion Federal Agency: U.S. Department of Treasury Program: 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Award Number and Year: SLFRP2192; 2021 Pass-Through Agency: N/A – Direct Criteria: Title 2 U.S. Code of Federal Regulations § 200.303 states that the auditee must establish and maintain effective internal control over the federal award that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Federal requirements prohibit non-federal entities from contracting with or making subawards under covered transactions to parties that are suspended or debarred. Title 2 U.S. Code of Federal Regulations § 180.300 describes a required verification process. Prior to entering into the transaction, one of the following must be performed: (1) checking SAM.gov exclusions, (2) collecting a certification, or (3) adding a clause or condition to the covered transaction. Condition: For six of the eight covered transactions selected for testing, the County did not perform the verification for suspended or debarred vendors prior to entering into the covered transactions. Questioned Costs: None. Context: There were 24 covered transactions during the year. The County provided funds to various cities, townships, and vendors which have operated for many years and were familiar to the County. The sample size was based on guidance from Chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Effect: Failure to verify vendors are not suspended, debarred, or otherwise excluded prior to entering into a covered transaction may result in the County entering into a transaction with a vendor that is not authorized to provide goods and services under the grant. Cause: The County informed us there is a lack of staff available to check the covered transactions for suspension and debarment. Recommendation: We recommend the County maintain documentation to demonstrate that vendors were not debarred, suspended, or otherwise excluded from conducting business with the County; this documentation should be completed prior to entering into a covered transaction. View of Responsible Official: Acknowledge
2023-002 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Prior Year Finding Number: N/A Year of Finding Origination: 2023 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Material Weakness and Modified Opinion Federal Agency: U.S. Department of Treasury Program: 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Award Number and Year: SLFRP2192; 2021 Pass-Through Agency: N/A – Direct Criteria: Title 2 U.S. Code of Federal Regulations § 200.303 states that the auditee must establish and maintain effective internal control over the federal award that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Title 2 U.S. Code of Federal Regulations §2 CFR 200.403(a) and §2 CFR 200.403(g) require costs to be necessary and reasonable, and be adequately documented. Condition: The County did not obtain itemized documentation for five out of 22 disbursements tested. The amount of disbursements that did not have supporting documentation totaled $818,036. Questioned Costs: $818,036 Context: The County disbursed funds to cities and towns as non-entitlement units of government (NEU), however; the NEU designation only applies to states providing funds to local governments. The sample size was originally based on guidance from Chapter 11 of the AICPA Audit Guide, Government Auditing and Single Audits, but was expanded to include four additional payments identified by the County as payments to NEUs. Effect: The County has insufficient documentation to demonstrate expenditures were for allowable activities and met the requirements of allowable costs. Cause: The County believed funds could be disbursed to cities and towns as NEUs. Because of this determination, the County did not obtain itemized support for expenditures incurred. Recommendation: We recommend Chisago County obtain itemized documentation related to grant expenditures to document expenditures were for allowable activities and met the requirements of allowable costs. View of Responsible Official: Acknowledge
2023-003 Suspension and Debarment Prior Year Finding Number: 2022-002 Year of Finding Origination: 2022 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Material Weakness and Modified Opinion Federal Agency: U.S. Department of Treasury Program: 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Award Number and Year: SLFRP2192; 2021 Pass-Through Agency: N/A – Direct Criteria: Title 2 U.S. Code of Federal Regulations § 200.303 states that the auditee must establish and maintain effective internal control over the federal award that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Federal requirements prohibit non-federal entities from contracting with or making subawards under covered transactions to parties that are suspended or debarred. Title 2 U.S. Code of Federal Regulations § 180.300 describes a required verification process. Prior to entering into the transaction, one of the following must be performed: (1) checking SAM.gov exclusions, (2) collecting a certification, or (3) adding a clause or condition to the covered transaction. Condition: For six of the eight covered transactions selected for testing, the County did not perform the verification for suspended or debarred vendors prior to entering into the covered transactions. Questioned Costs: None. Context: There were 24 covered transactions during the year. The County provided funds to various cities, townships, and vendors which have operated for many years and were familiar to the County. The sample size was based on guidance from Chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Effect: Failure to verify vendors are not suspended, debarred, or otherwise excluded prior to entering into a covered transaction may result in the County entering into a transaction with a vendor that is not authorized to provide goods and services under the grant. Cause: The County informed us there is a lack of staff available to check the covered transactions for suspension and debarment. Recommendation: We recommend the County maintain documentation to demonstrate that vendors were not debarred, suspended, or otherwise excluded from conducting business with the County; this documentation should be completed prior to entering into a covered transaction. View of Responsible Official: Acknowledge