Finding 609191 (2022-001)

-
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2023-01-10
Audit: 29198
Organization: City of Salem, Virginia (VA)

AI Summary

  • Core Issue: There are discrepancies in the inventory listing for the ECF program, including a user listed twice and an extra asset not purchased with program funds.
  • Impacted Requirements: The Schools must maintain an accurate record of all devices and their assigned users to comply with program requirements.
  • Recommended Follow-Up: Regularly reconcile inventory listings to ensure accuracy and completeness, addressing potential data entry errors or omissions.

Finding Text

Condition: In our testing of the City Schools' inventory of devices for the ECF program, we noted one instance of a user appearing twice on the listing giving the appearance they could have two devices issued to them. We also noted that the listing appeared to contain one more additional asset than that purchased with the program funds. Criteria: The Schools should strive to maintain an accurate listing of all devices and all users that have devices assigned to them. A key requirement of the program is to maintain an accurate listing of all devices and who they are assigned to. Cause: The inventory listings of devices appear to be maintained in Excel for the program, which means that errors could result from simple data entry errors, failure to catch all changes or updates that should be recorded, or other Effect: Errors in the listing could result in devices being unaccounted for accidentally as they could be reported as assigned when they are not, may be on the listing when they should no longer be, or may not be recorded when they should be. Questioned costs: Not applicable Perspective information: Not applicable Repeat Finding: Not applicable Recommendation: The Schools should work to maintain accurate listings that provide all the required information for the program. Given the nature of the equipment for the ECF program, it is important that these listings are reconciled periodically to ensure their accuracy and completeness.

Categories

Equipment & Real Property Management Procurement, Suspension & Debarment

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
32.009 Emergency Connectivity Fund Program $648,725
59.075 Shuttered Venue Operators Grant Program $593,541
84.010 Title I Grants to Local Educational Agencies $482,365
84.002 Adult Education - Basic Grants to States $333,833
10.553 School Breakfast Program $248,754
10.559 Summer Food Service Program for Children $140,836
84.367 Improving Teacher Quality State Grants $88,979
84.027 Special Education_grants to States $74,138
16.575 Crime Victim Assistance $66,126
10.555 National School Lunch Program $63,378
84.048 Career and Technical Education -- Basic Grants to States $56,852
21.027 Coronavirus State and Local Fiscal Recovery Funds $50,080
20.205 Highway Planning and Construction $45,661
97.067 Homeland Security Grant Program $39,085
84.424 Student Support and Academic Enrichment Program $37,993
93.667 Social Services Block Grant $33,492
66.039 National Clean Diesel Emissions Reduction Program $20,000
45.310 Grants to States $18,007
84.173 Special Education_preschool Grants $16,241
84.365 English Language Acquisition State Grants $16,000
10.579 Child Nutrition Discretionary Grants Limited Availability $14,790
93.991 Preventive Health and Health Services Block Grant $11,578
20.607 Alcohol Open Container Requirements $9,780
84.425 Education Stabilization Fund $8,345
16.922 Equitable Sharing Program $6,630
16.034 Coronavirus Emergency Supplemental Funding Program $5,000
10.551 Supplemental Nutrition Assistance Program $4,063
10.649 Pandemic Ebt Administrative Costs $3,063
10.331 Food Insecurity Nutrition Incentive Grants Program $2,843
17.274 Youthbuild $2,260
20.600 State and Community Highway Safety $1,498
16.738 Edward Byrne Memorial Justice Assistance Grant Program $1,118
93.093 Affordable Care Act (aca) Health Profession Opportunity Grants $296
16.607 Bulletproof Vest Partnership Program $295