Finding 60324 (2022-002)

- Repeat Finding
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2023-03-30

AI Summary

  • Core Issue: A physical inventory of property and equipment was not conducted, leading to discrepancies with the general ledger.
  • Impacted Requirements: Missing details in the property records, such as serial numbers and acquisition dates, violate 2 CFR 200.313 (d) (1).
  • Recommended Follow-Up: Management should update the property report and conduct a physical inventory to ensure compliance with federal regulations.

Finding Text

Finding Number: 2022-002 Federal Program: CFDA 14.850 ? Public and Indian Housing Condition: A physical inventory of property and equipment was not performed in order to reconcile it with the general ledger control accounts. The property and equipment subsidiary did not include certain information that is required by the Federal Regulation, as follows: o Serial numbers o Identification and/or tag number o Percentage of federal participation on cost of units o In addition, certain acquisition dates for some of the assets needs to be revised Criteria: 2 CFR 200.313 (d) (1) establishes that property records must be maintained and should include a description of the property, a serial number or other identification number, the source of funding for the property, who holds the title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. Cause: The property and equipment subsidiary was not reviewed in order to ascertain that all required information is properly included. Effects or potential effect: Non inclusion of all applicable information as required by the Federal Regulation. Recommendation: We recommend that management update the property and equipment report with information required by federal government and performed a physical inventory observation to reconciliate the information with general ledger accounts.

Corrective Action Plan

Management response: Management agrees with the finding. We identified previously and working on a project to reconcile property and equipment schedule with physical inventory previously to record the data in the accounting system. Due to employee turnover in the finance department the project has been delayed. During the second quarter of this year the Organization engaged a third party company to perform an inventory count for property and equipment in all locations, excluding Head Start locations. Physical counts in these location will be performed during the 4th quarter of fiscal year 2023. During this process items numbers, serial numbers and other important information was updated. Management expects to have these assets reconciled by the fiscal year ended June 30, 2022. Corrective action plan: 1. Management will review the equipment inventory and subsidiary and reconcile them. 2. Management will proceed to use the tool provided by London Consulting to track equipment inventory. 3. Management will established a physical count every two years. Contact person: Manuel Joglar Team: Purchasing Officer, Operations Manager, Accounting Manager Anticipated completion date: Not later than June 30, 2023

Categories

Equipment & Real Property Management

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
14.850 Public and Indian Housing $2.14M
84.287 Twenty-First Century Community Learning Centers $519,604
14.218 Cdbg-Dr/entitlements Grants (workforce Training Program) $486,133
93.356 Head Start Disaster Recovery $391,075
93.600 Head Start $240,090
93.569 Community Services Block Grant $215,044
14.218 Community Development Block Grants/entitlement Grants $200,191
84.282 Charter Schools $191,692
84.010 Title I Grants to Local Educational Agencies $168,800
16.575 Crime Victim Assistance $88,668
10.555 National School Lunch Program $88,466
93.558 Temporary Assistance for Needy Families $70,067
94.006 Americorps $59,807
93.060 Competitive Abstinence Education (cae) $43,353
10.553 School Breakfast Program $38,125
84.367 Improving Teacher Quality State Grants $27,299
16.726 Juvenile Mentoring Program $1,412