Audit 29198

FY End
2022-06-30
Total Expended
$9.91M
Findings
4
Programs
34
Organization: City of Salem, Virginia (VA)
Year: 2022 Accepted: 2023-01-10

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
32749 2022-001 - - F
32750 2022-001 - - F
609191 2022-001 - - F
609192 2022-001 - - F

Programs

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

Contacts

Name Title Type
MKMPK1KLTWD5 Rosemarie B. Jordan Auditee
5403753061 Susan Chapman Auditor
No contacts on file

Notes to SEFA

Title: Nonmonetary Assistance Accounting Policies: This schedule was prepared on the modified accrual basis of accounting. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Nonmonetary assistance is reported in the Schedule of Expenditures of Federal Awards at the fair market value of the food commodities disbursed. As of June 30, 2022, the City of Salem School Division (School Division) had food commodities in inventory of $109,073.
Title: Outstanding Loan Balances Accounting Policies: This schedule was prepared on the modified accrual basis of accounting. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. At June 30, 2022, the City and School Division had no outstanding loan balances requiring continuing disclosure.

Finding Details

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.
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.
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.
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.