Audit 314617

FY End
2023-12-31
Total Expended
$14.25M
Findings
2
Programs
27
Organization: County of Calhoun (MI)
Year: 2023 Accepted: 2024-07-09

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
477914 2023-001 Significant Deficiency - G
1054356 2023-001 Significant Deficiency - G

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $7.36M Yes 1
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $812,640 Yes 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $621,419 - 0
93.563 Child Support Enforcement $263,409 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $210,178 - 0
93.994 Maternal and Child Health Services Block Grant to the States $126,965 - 0
93.268 Immunization Cooperative Agreements $117,801 - 0
93.788 Opioid Str $90,000 - 0
16.753 Congressionally Recommended Awards $85,550 - 0
97.048 Federal Disaster Assistance to Individuals and Households in Presidential Declared Disaster Areas $73,631 - 0
93.778 Medical Assistance Program $58,365 - 0
93.658 Foster Care_title IV-E $49,495 - 0
10.555 National School Lunch Program $36,718 - 0
93.889 National Bioterrorism Hospital Preparedness Program $24,761 - 0
20.600 State and Community Highway Safety $19,765 - 0
93.217 Family Planning_services $19,739 - 0
93.991 Preventive Health and Health Services Block Grant $19,508 - 0
10.553 School Breakfast Program $14,815 - 0
97.042 Emergency Management Performance Grants $11,057 - 0
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $10,000 - 0
90.404 2018 Hava Election Security Grants $7,101 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $6,500 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $4,040 - 0
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $1,260 - 0
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $1,223 - 0
93.940 Hiv Prevention Activities_health Department Based $960 - 0
93.071 Medicare Enrollment Assistance Program $400 - 0

Contacts

Name Title Type
D3QNNDAGFUK6 Megan Banning Auditee
2697810974 Nathan C. Baldermann, Cpa, Cgfm Auditor
No contacts on file

Notes to SEFA

Title: FISCAL REPORTING Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of the County of Calhoun, Michigan (the “County”) under programs of the federal government for the year ended December 31, 2023, except as discussed below in Note 3. 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 County, it is not intended to and does not present the financial position, changes in net position or cash flows of the County. The County’s reporting entity is defined in Note 1 of the County’s Annual Comprehensive Financial Report. The County’s financial statements include the operations of the Calhoun County Medical Care Facility enterprise fund, Calhoun County Delinquent Tax Revolving enterprise fund and the Calhoun County Land Bank Authority discretely presented component unit, which received federal awards that are not included in the Schedule for the year ended December 31, 2023, as these entities were separately audited. Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the County's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule, if any, represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the County has not elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance. Certain departments report on a different fiscal year than the County. Grants accounted for and reported on year-ends other than December 31, 2023 are denoted as such in the Schedule with an asterisk (*) for September 30 year ends.
Title: PASS-THROUGH AGENCIES Accounting Policies: The accompanying schedule of expenditures of federal awards (the “Schedule”) includes the federal grant activity of the County of Calhoun, Michigan (the “County”) under programs of the federal government for the year ended December 31, 2023, except as discussed below in Note 3. 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 County, it is not intended to and does not present the financial position, changes in net position or cash flows of the County. The County’s reporting entity is defined in Note 1 of the County’s Annual Comprehensive Financial Report. The County’s financial statements include the operations of the Calhoun County Medical Care Facility enterprise fund, Calhoun County Delinquent Tax Revolving enterprise fund and the Calhoun County Land Bank Authority discretely presented component unit, which received federal awards that are not included in the Schedule for the year ended December 31, 2023, as these entities were separately audited. Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the County's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule, if any, represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the County has not elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance. The County receives certain federal grants as subawards from non-federal entities. Pass-through entities, where applicable, have been identified in the Schedule with an abbreviation, defined as follows: See the Notes to the SEFA for chart/table.

Finding Details

2023-001 - Revenue Loss Calculation (Earmarking) 2023-001 - Revenue Loss Calculation (Earmarking) Finding Type. Immaterial Noncompliance; Significant Deficiency in Internal Controls over Compliance. Federal program(s) U.S. Department of Treasury COVID-19 - State and Local Fiscal Recovery Fund (CSLFRF) - American Rescue Plan Act (ALN 21.027); Direct award Criteria. In accordance with the Uniform Guidance, recipients of Coronavirus State & Local Fiscal Recovery Funds may use payments from CSLFRF to replace lost public sector revenue to provide government services. Recipients may use this funding to provide government services to the extent of the reduction in revenue experience due to the pandemic. Under the Final Rule, recipients can elect a one-time “standard allowance” or they can calculate lost revenue based on the formula provide in the Final Rule to determine the amount of funds that can be used for the provision of government services. Condition. The County calculated lost revenue for fiscal years 2020-2023; however, certain items included in the calculation are not allowed per the Final Rule. Cause. The County included accounts and account classifications that should have been excluded from the calculation. Effect. As a result, the amount of revenue loss reported on the SLFRF compliance/P&E reports was incorrect. Recommendation. Management has revised its internal revenue loss calculation. We recommend the County update the amount on the current quarterly report and ensure that any future calculations are correct. Questioned Costs. None. View of Responsible Official. The County agrees that management has already taken appropriate action and will continue to provide correct calculations of revenue loss for future quarterly reports. The amount of the County’s revenue loss far exceeds the amount of ARPA funds spent within that category, and so this item did not and will not impact the accuracy of the County’s ARPA expenditure reports. Responsible Official. Finance Director
2023-001 - Revenue Loss Calculation (Earmarking) 2023-001 - Revenue Loss Calculation (Earmarking) Finding Type. Immaterial Noncompliance; Significant Deficiency in Internal Controls over Compliance. Federal program(s) U.S. Department of Treasury COVID-19 - State and Local Fiscal Recovery Fund (CSLFRF) - American Rescue Plan Act (ALN 21.027); Direct award Criteria. In accordance with the Uniform Guidance, recipients of Coronavirus State & Local Fiscal Recovery Funds may use payments from CSLFRF to replace lost public sector revenue to provide government services. Recipients may use this funding to provide government services to the extent of the reduction in revenue experience due to the pandemic. Under the Final Rule, recipients can elect a one-time “standard allowance” or they can calculate lost revenue based on the formula provide in the Final Rule to determine the amount of funds that can be used for the provision of government services. Condition. The County calculated lost revenue for fiscal years 2020-2023; however, certain items included in the calculation are not allowed per the Final Rule. Cause. The County included accounts and account classifications that should have been excluded from the calculation. Effect. As a result, the amount of revenue loss reported on the SLFRF compliance/P&E reports was incorrect. Recommendation. Management has revised its internal revenue loss calculation. We recommend the County update the amount on the current quarterly report and ensure that any future calculations are correct. Questioned Costs. None. View of Responsible Official. The County agrees that management has already taken appropriate action and will continue to provide correct calculations of revenue loss for future quarterly reports. The amount of the County’s revenue loss far exceeds the amount of ARPA funds spent within that category, and so this item did not and will not impact the accuracy of the County’s ARPA expenditure reports. Responsible Official. Finance Director