Audit 47922

FY End
2022-06-30
Total Expended
$2.36M
Findings
2
Programs
27
Organization: Lee County (IA)
Year: 2022 Accepted: 2023-03-30

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
44830 2022-004 Material Weakness - P
621272 2022-004 Material Weakness - P

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $920,483 Yes 0
20.205 Highway Planning and Construction $263,931 Yes 1
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $200,986 - 0
10.766 Community Facilities Loans and Grants $165,000 - 0
93.268 Immunization Cooperative Agreements $148,568 - 0
93.556 Promoting Safe and Stable Families $76,000 - 0
93.236 Grants to States to Support Oral Health Workforce Activities $51,507 - 0
93.994 Maternal and Child Health Services Block Grant to the States $48,896 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $34,000 - 0
93.778 Medical Assistance Program $27,445 - 0
16.575 Crime Victim Assistance $25,479 - 0
16.609 Project Safe Neighborhoods $7,189 - 0
93.667 Social Services Block Grant $6,333 - 0
93.658 Foster Care_title IV-E $6,205 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $6,064 - 0
93.366 State Actions to Improve Oral Health Outcomes and Partner Actions to Improve Oral Health Outcomes $5,000 - 0
20.600 State and Community Highway Safety $3,814 - 0
93.659 Adoption Assistance $3,393 - 0
16.710 Public Safety Partnership and Community Policing Grants $3,032 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $2,827 - 0
93.575 Child Care and Development Block Grant $2,140 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $2,009 - 0
20.616 National Priority Safety Programs $1,856 - 0
93.472 Title IV-E Prevention and Family Services and Programs (a) $830 - 0
93.767 Children's Health Insurance Program $480 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $466 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $27 - 0

Contacts

Name Title Type
G1ANNAB4MKD3 Denise Fraise Auditee
3193723705 Suzanne Dahlstrom Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of Lee County under programs of the federal government for the year ended June 30, 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 Lee County, it is not intended to and does not present the financial position, changes in financial position or cash flows of Lee County.Summary of Significant Accounting Policies Expenditures reported in the Schedule are reported on the modified 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. Indirect Cost Rate Lee County has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

INTERNAL CONTROL DEFICIENCY: Assistance Listing Number 20.205: Highway Planning and Construction Pass-through Entity Identifying Number: 56(107)-NC-56 Federal Award Year: 2022 Prior Year Finding Number: N/A U.S. Department of Transportation Passed through the Iowa Department of Transportation. Segregation of Duties over Federal Revenues ? The County Secondary Roads Department did not properly segregate custody, record-keeping and reconciling functions for revenues, including those related to federal programs. Criteria ? Management is responsible for establishing and maintaining internal control. A good system of internal control provides for adequate segregation of duties so no one individual handles a transaction from its inception to completion. In order to maintain proper internal control, duties should be segregated so the authorization, custody and recording of transactions are not under the control of the same employee. This segregation of duties helps prevent losses from employee error or dishonesty and maximizes the accuracy of the County?s financial statements. An effective internal control system also provides for internal controls related to ensuring proper accounting for all funds by reviewing reconciliations of bank and book balances. Condition ? Generally, one or two individuals in the offices identified may have control over the following areas for which no compensating controls exist:(1) Incoming mail is opened by an employee who is authorized to make entries to the accounting records.(2) Generally, one individual may have control over collecting, depositing, posting and daily reconciling of receipts for which no compensating controls exist. Cause ? The County offices noted above have a limited number of employees and procedures have not been designed to adequately segregate duties or provide compensating controls through additional oversight of transactions, processes and reports. Effect ? Inadequate segregation of duties and inadequate policies could adversely affect each County office?s ability to prevent or detect and correct misstatements, errors or misappropriation on a timely basis by employees in the normal course of performing their assigned functions. Recommendation ? Each official should review the control activities of their office to obtain the maximum internal control possible under the circumstances. The official should utilize current personnel, including elected officials, to provide additional control through review of financial transactions, reconciliations and reports. In addition, all bank accounts should be reviewed by an independent person, and a monthly report of voided receipts should be maintained. Secondary Roads Response and Corrective Action Planned ? With limited staff, we will attempt to segregate duties as much as possible. We will explore having state reimbursements directly deposited at the County Treasurer. Conclusions ? Response acknowledged. All offices should continue to review current operating procedures for the areas noted to obtain the maximum internal control possible. The officials should utilize current personnel to provide additional control through review of financial transactions, reconciliations and reports.
INTERNAL CONTROL DEFICIENCY: Assistance Listing Number 20.205: Highway Planning and Construction Pass-through Entity Identifying Number: 56(107)-NC-56 Federal Award Year: 2022 Prior Year Finding Number: N/A U.S. Department of Transportation Passed through the Iowa Department of Transportation. Segregation of Duties over Federal Revenues ? The County Secondary Roads Department did not properly segregate custody, record-keeping and reconciling functions for revenues, including those related to federal programs. Criteria ? Management is responsible for establishing and maintaining internal control. A good system of internal control provides for adequate segregation of duties so no one individual handles a transaction from its inception to completion. In order to maintain proper internal control, duties should be segregated so the authorization, custody and recording of transactions are not under the control of the same employee. This segregation of duties helps prevent losses from employee error or dishonesty and maximizes the accuracy of the County?s financial statements. An effective internal control system also provides for internal controls related to ensuring proper accounting for all funds by reviewing reconciliations of bank and book balances. Condition ? Generally, one or two individuals in the offices identified may have control over the following areas for which no compensating controls exist:(1) Incoming mail is opened by an employee who is authorized to make entries to the accounting records.(2) Generally, one individual may have control over collecting, depositing, posting and daily reconciling of receipts for which no compensating controls exist. Cause ? The County offices noted above have a limited number of employees and procedures have not been designed to adequately segregate duties or provide compensating controls through additional oversight of transactions, processes and reports. Effect ? Inadequate segregation of duties and inadequate policies could adversely affect each County office?s ability to prevent or detect and correct misstatements, errors or misappropriation on a timely basis by employees in the normal course of performing their assigned functions. Recommendation ? Each official should review the control activities of their office to obtain the maximum internal control possible under the circumstances. The official should utilize current personnel, including elected officials, to provide additional control through review of financial transactions, reconciliations and reports. In addition, all bank accounts should be reviewed by an independent person, and a monthly report of voided receipts should be maintained. Secondary Roads Response and Corrective Action Planned ? With limited staff, we will attempt to segregate duties as much as possible. We will explore having state reimbursements directly deposited at the County Treasurer. Conclusions ? Response acknowledged. All offices should continue to review current operating procedures for the areas noted to obtain the maximum internal control possible. The officials should utilize current personnel to provide additional control through review of financial transactions, reconciliations and reports.