Finding 602688 (2022-003)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2023-09-24
Audit: 17812
Organization: Sumner County Kansas (KS)

AI Summary

  • Core Issue: The County's equipment inventory lacks essential details like acquisition date and funding source, making it non-compliant with federal requirements.
  • Impacted Requirements: The inventory does not meet the standards set in the Compliance Supplement and 2 CFR 200.313, risking denial of sharing requests and potential exclusion from the program.
  • Recommended Follow-Up: Update the inventory system to include all required data and retain supporting documents; consider using specialized software for better compliance.

Finding Text

Finding 2022-003: Equipment and Real Property Management Identification of the federal program: Federal Equitable Sharing, ALN 16.922 Criteria: Compliance Requirement F Equipment /Real Property Management in in Part 4 of the 2022 Compliance Supplement for this program states that, ?Although 2 CFR Sections 200.311 and 313 are not applicable, the Guide, Section VI, details requirements for tangible property. Property purchased with equitable sharing funds, or obtained for official use, is subject to inventory control, log maintenance, and disposal requirements.? The Guide states the local law enforcement agency must ?maintain and follow written policies for accounting, bookkeeping and inventory control?? The requirement for inventory control in 2 CFR 200.313 (d)((1) states procedures for managing equipment include, ?Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and the cost percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sales price of the property.? Condition: The County maintains an inventory of equipment, however that inventory does not include the acquisition date, the source of funding, the cost percentage of Federal participation or federal award data. Disposed assets are deleted from the inventory and disposition data is not maintained. The inventory record is not complete enough to determine compliance with the Guide. Source documents supporting entries in the inventory record have not been retained. Cause: The county had an existing asset management software but developed its own inventory system exclusively using an Excel spreadsheet in 2022. The compliance requirements were not adequately considered when developing the spreadsheet and there was no effective internal control over its development and use. Effect: Denial or extinguishment of sharing requests; temporary or permanent exclusion from the Program; freeze on receipt and/or expenditure of shared funds; return of funds or offsets from future sharing. Questioned Costs: Not applicable Context: The inventory record does identify the equipment, its serial or other number and its location. Assets purchased using federal funds from other programs would also be subject to the same condition. Recommendation: The existing system should be modified be compliant with the Uniform Guidance requirements, or a specifically designed software should be used. Source documents supporting inventory records should be retained. Disposition data should be maintained. Views of Responsible Officials: Management concurs with this finding and recommendation.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 26245 2022-002
    Material Weakness
  • 26246 2022-003
    Material Weakness
  • 26247 2022-004
    Material Weakness
  • 602687 2022-002
    Material Weakness
  • 602689 2022-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $383,556
81.086 Conservation Research and Development $229,654
16.922 Equitable Sharing Program $134,167
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $79,723
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $65,327
93.268 Immunization Cooperative Agreements $21,935
93.994 Maternal and Child Health Services Block Grant to the States $18,592
93.069 Public Health Emergency Preparedness $12,123
93.217 Family Planning_services $2,944