Audit 48921

FY End
2022-12-31
Total Expended
$2.60M
Findings
6
Programs
24
Organization: Reno County, Kansas (KS)
Year: 2022 Accepted: 2023-07-17
Auditor: Adamsbrown LLC

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
52099 2022-001 Significant Deficiency - AB
52100 2022-002 Significant Deficiency - AB
52101 2022-001 Significant Deficiency - AB
628541 2022-001 Significant Deficiency - AB
628542 2022-002 Significant Deficiency - AB
628543 2022-001 Significant Deficiency - AB

Programs

ALN Program Spent Major Findings
20.509 Formula Grants for Rural Areas and Tribal Transit Program $703,423 Yes 0
16.838 Comprehensive Opioid Abuse Site-Based Program $284,097 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $105,837 Yes 0
93.268 Immunization Cooperative Agreements $85,640 - 0
10.555 National School Lunch Program $44,975 - 0
93.778 Medical Assistance Program $40,000 - 0
93.217 Family Planning_services $26,688 - 0
93.994 Maternal and Child Health Services Block Grant to the States $24,299 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $21,958 - 0
93.069 Public Health Emergency Preparedness $20,676 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $15,744 - 0
93.991 Preventive Health and Health Services Block Grant $9,628 - 0
93.575 Child Care and Development Block Grant $6,847 - 0
20.616 National Priority Safety Programs $6,071 - 0
93.052 National Family Caregiver Support, Title Iii, Part E $4,900 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $4,670 - 0
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $3,176 Yes 0
10.664 Cooperative Forestry Assistance $2,927 - 0
16.607 Bulletproof Vest Partnership Program $2,308 - 0
10.559 Summer Food Service Program for Children $2,119 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $1,120 - 0
93.945 Assistance Programs for Chronic Disease Prevention and Control $1,044 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $950 - 0
20.600 State and Community Highway Safety $333 - 0

Contacts

Name Title Type
ST1HDTZ4F6C1 Randy Partington Auditee
6206942929 Melissa Romme Auditor
No contacts on file

Notes to SEFA

Title: OTHER EXPENDITURES Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal grant activity of Reno County, Kansas, and is presented on the basis of accounting that demonstrates compliance with the regulatory basis of accounting of the State of Kansas, which is a comprehensive basis of accounting other than generally accepted accounting principles. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The County did not receive any federal awards in the form of noncash assistance, insurance, loans, or loan guarantees and incurred no expenditures in relation thereof for the year ended December 31, 2022.

Finding Details

Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ? 93.323 and Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) ? 10.557 Criteria or specific requirement Internal controls should be in place to ensure that expenditures are correctly charged as to account, amount, and period. Condition During testing, it was discovered that errors were made while allocating expenditures between grants. In addition, errors were made when summarizing mileage data that was then used in the allocation process. Cause A sufficient review process was not in place to catch and correct errors in a timely manner. Effect Additional errors may have been made that were not caught and corrected. In addition, indirect costs may be calculated using an incorrect cost pool. Context Payroll in the amount of $144 was improperly allocated amongst budget items within the WIC grant, and estimated total allocation errors are $4,995. Due to a data entry error during the allocation process, ELC payroll was understated in the amount of $13, and estimated total errors are $25. Actual mileage logs for December were less than the total calculated by 6 miles. Actual mileage logs for November were higher than the total calculated by 138 total miles. Actual mileage logs for October were higher than the total calculated by 114 total miles, and no logs were scanned for two vehicles for the month. Actual mileage logs for September were higher than the total calculated by 61 total miles. Actual mileage logs for July were higher than the allocation calculation by 114 total miles. Due to these errors, WIC expenses allocated according to these amounts were overstated by $2, and estimated total allocation errors are $57. An invoice that included the purchase of items for multiple grant programs did not allocate the shipping costs accordingly ? the full $5 cost was charged to the ELC grant. The estimated total allocation errors are $9. Recommendation We recommend that the County review its procedures and implement controls to ensure that expenditures are properly calculated and booked. Views of responsible officials and planned corrective actions See corrective action plan.
Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ? 93.323 Criteria or specific requirement Expenditures should be consistent with allowable activities, as identified by federal statute, regulations, and the terms and conditions of the federal award. Condition During testing, it was discovered that food and beverage expenditures were reimbursed under the program. Cause There was some confusion as to the allowability of the expenditures, and a clear approval from the awarding agency, or other documentation in support of the expenditure, was not obtained. Effect Unallowable expenditures were charged to and reimbursed by the program. Context Three sample items tested were for the purchase of food and beverages, and the known questioned costs are $88. Total estimated questioned costs are $176. Recommendation We recommend that the County review its procedures and implement controls to ensure that expenditure allowability is properly determined. Views of responsible officials and planned corrective actions See corrective action plan.
Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ? 93.323 and Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) ? 10.557 Criteria or specific requirement Internal controls should be in place to ensure that expenditures are correctly charged as to account, amount, and period. Condition During testing, it was discovered that errors were made while allocating expenditures between grants. In addition, errors were made when summarizing mileage data that was then used in the allocation process. Cause A sufficient review process was not in place to catch and correct errors in a timely manner. Effect Additional errors may have been made that were not caught and corrected. In addition, indirect costs may be calculated using an incorrect cost pool. Context Payroll in the amount of $144 was improperly allocated amongst budget items within the WIC grant, and estimated total allocation errors are $4,995. Due to a data entry error during the allocation process, ELC payroll was understated in the amount of $13, and estimated total errors are $25. Actual mileage logs for December were less than the total calculated by 6 miles. Actual mileage logs for November were higher than the total calculated by 138 total miles. Actual mileage logs for October were higher than the total calculated by 114 total miles, and no logs were scanned for two vehicles for the month. Actual mileage logs for September were higher than the total calculated by 61 total miles. Actual mileage logs for July were higher than the allocation calculation by 114 total miles. Due to these errors, WIC expenses allocated according to these amounts were overstated by $2, and estimated total allocation errors are $57. An invoice that included the purchase of items for multiple grant programs did not allocate the shipping costs accordingly ? the full $5 cost was charged to the ELC grant. The estimated total allocation errors are $9. Recommendation We recommend that the County review its procedures and implement controls to ensure that expenditures are properly calculated and booked. Views of responsible officials and planned corrective actions See corrective action plan.
Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ? 93.323 and Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) ? 10.557 Criteria or specific requirement Internal controls should be in place to ensure that expenditures are correctly charged as to account, amount, and period. Condition During testing, it was discovered that errors were made while allocating expenditures between grants. In addition, errors were made when summarizing mileage data that was then used in the allocation process. Cause A sufficient review process was not in place to catch and correct errors in a timely manner. Effect Additional errors may have been made that were not caught and corrected. In addition, indirect costs may be calculated using an incorrect cost pool. Context Payroll in the amount of $144 was improperly allocated amongst budget items within the WIC grant, and estimated total allocation errors are $4,995. Due to a data entry error during the allocation process, ELC payroll was understated in the amount of $13, and estimated total errors are $25. Actual mileage logs for December were less than the total calculated by 6 miles. Actual mileage logs for November were higher than the total calculated by 138 total miles. Actual mileage logs for October were higher than the total calculated by 114 total miles, and no logs were scanned for two vehicles for the month. Actual mileage logs for September were higher than the total calculated by 61 total miles. Actual mileage logs for July were higher than the allocation calculation by 114 total miles. Due to these errors, WIC expenses allocated according to these amounts were overstated by $2, and estimated total allocation errors are $57. An invoice that included the purchase of items for multiple grant programs did not allocate the shipping costs accordingly ? the full $5 cost was charged to the ELC grant. The estimated total allocation errors are $9. Recommendation We recommend that the County review its procedures and implement controls to ensure that expenditures are properly calculated and booked. Views of responsible officials and planned corrective actions See corrective action plan.
Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ? 93.323 Criteria or specific requirement Expenditures should be consistent with allowable activities, as identified by federal statute, regulations, and the terms and conditions of the federal award. Condition During testing, it was discovered that food and beverage expenditures were reimbursed under the program. Cause There was some confusion as to the allowability of the expenditures, and a clear approval from the awarding agency, or other documentation in support of the expenditure, was not obtained. Effect Unallowable expenditures were charged to and reimbursed by the program. Context Three sample items tested were for the purchase of food and beverages, and the known questioned costs are $88. Total estimated questioned costs are $176. Recommendation We recommend that the County review its procedures and implement controls to ensure that expenditure allowability is properly determined. Views of responsible officials and planned corrective actions See corrective action plan.
Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) ? 93.323 and Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) ? 10.557 Criteria or specific requirement Internal controls should be in place to ensure that expenditures are correctly charged as to account, amount, and period. Condition During testing, it was discovered that errors were made while allocating expenditures between grants. In addition, errors were made when summarizing mileage data that was then used in the allocation process. Cause A sufficient review process was not in place to catch and correct errors in a timely manner. Effect Additional errors may have been made that were not caught and corrected. In addition, indirect costs may be calculated using an incorrect cost pool. Context Payroll in the amount of $144 was improperly allocated amongst budget items within the WIC grant, and estimated total allocation errors are $4,995. Due to a data entry error during the allocation process, ELC payroll was understated in the amount of $13, and estimated total errors are $25. Actual mileage logs for December were less than the total calculated by 6 miles. Actual mileage logs for November were higher than the total calculated by 138 total miles. Actual mileage logs for October were higher than the total calculated by 114 total miles, and no logs were scanned for two vehicles for the month. Actual mileage logs for September were higher than the total calculated by 61 total miles. Actual mileage logs for July were higher than the allocation calculation by 114 total miles. Due to these errors, WIC expenses allocated according to these amounts were overstated by $2, and estimated total allocation errors are $57. An invoice that included the purchase of items for multiple grant programs did not allocate the shipping costs accordingly ? the full $5 cost was charged to the ELC grant. The estimated total allocation errors are $9. Recommendation We recommend that the County review its procedures and implement controls to ensure that expenditures are properly calculated and booked. Views of responsible officials and planned corrective actions See corrective action plan.