Finding 44830 (2022-004)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-03-30
Audit: 47922
Organization: Lee County (IA)

AI Summary

  • Core Issue: The County Secondary Roads Department lacks proper segregation of duties over federal revenue handling, increasing the risk of errors or fraud.
  • Impacted Requirements: Management must ensure internal controls are in place to separate authorization, custody, and recording of transactions to maintain accurate financial statements.
  • Recommended Follow-Up: Officials should review and enhance control activities, including independent reviews of bank accounts and monthly reports of voided receipts, to strengthen oversight.

Finding Text

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.

Corrective Action Plan

2022-004 Segregation of Duties over Federal Revenues Each official will review office procedures and attempt to maximize the best internal control. With limited staff, we will attempt to segregate duties as much as possible. We will consider using other officials as necessary. We will explore having state reimbursements directly deposited at the County Treasurer. Cindy Renstrom Budget Director (319) 372-3705 June 30, 2023

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 621272 2022-004
    Material Weakness

Programs in Audit

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