2023-003 – Equipment and real property management
Cluster: Research and Development
Sponsoring Agency: Various
Award Names: All awards for 3 campuses with federal equipment expenditures in the SEFA
Award Numbers: Various
Assistance Listing Titles: Various
Assistance Listing Numbers: All awards for...
2023-003 – Equipment and real property management
Cluster: Research and Development
Sponsoring Agency: Various
Award Names: All awards for 3 campuses with federal equipment expenditures in the SEFA
Award Numbers: Various
Assistance Listing Titles: Various
Assistance Listing Numbers: All awards for 3 campuses with equipment expenditures in the SEFA
Award Year: 2022-2023
Pass-through entity: All pass-through awards for 3 campuses with equipment expenditures in the SEFA
Campus One
Actions already taken:
• Controller’s Office-Capital Accounting had been aware of past due inventories throughout the pandemic caused by on-site restrictions departmental asset custodians faced in their accessibility to complete inventories. Once the federal state of emergency was lifted in May 2023, the Capital Accounting team presented a status update on outstanding inventory counts to UCSF’s Control Points Financial Officers (Control Points) to obtain Control Point’s assistance in bringing awareness of the need to bring inventory counts to current status, Capital Accounting began sending quarterly reports on overdue counts. Since this increased communication, there have been improvements in response rates and action taken by departmental custodians.
• In October 2023, Capital Accounting also conducted outreach to departmental asset custodians in the form of a feedback survey with the goal to seek information on how our custodians have returned to work, difficulties they have with the inventories they are assigned, and if they need clarifications on the training surrounding capital asset policy and procedures. As a result of our custodian outreach, Capital Accounting learned that most custodians are on-site and can perform their physical inventories, so the shelter in place restrictions are no longer a barrier in completing these physical inventories. We also identified the need for additional training for departmental asset custodians to ensure ongoing understanding of related policy and procedures, such as physical inventory counts.
• Additionally, additional metrics were added to the quarterly Controller’s Office Operational Metrics Report to now include outstanding inventories at a campus departmental level. This provides an opportunity for the Controller and other leaders within central finance administration to have better visibility on our efforts surrounding this key control.
Additional Actions to be taken:
• A deadline of June 30, 2024, will be communicated to all custodians to bring their inventories up to date.
• The Controller’s Office has been developing content and plans to begin hosting bi-monthly town halls in March 2024 with department custodians to provide hands on support in assisting with their counts. We also plan to update our training materials surrounding the tools (Peoplesoft) department custodians utilize for updating asset information with the goal for inventory results to be entered in a more timely manner. By June 2024, we will have completed our first series of live support sessions with our custodians. By September 2024, we will roll out refreshed training materials for departmental custodians. These will be training guides that will be hosted on the Controller’s Office website and will be mandatory during the onboarding of the custodians.
• The Controller’s Office will also partner with our Control Points in reviewing the custodian role at each of their departments. We will assess FTEs with the custodian role and evaluate the number of equipment assigned to each custodian. The goal of this custodian role review is to provide insight into the workload of each custodian as we have noted some custodians have up to 1,000 assets assigned, which is an obstacle in the inventory timeliness. In the upcoming months, we will work with each control point area with how the custodian role is assigned within their areas and make any changes if needed.
• The Controller’s Office will continue sending quarterly reports to our Control Points on physical inventory status for support in escalation and follow-up with their departments. The Controller’s Office will also continue to track the metrics of late inventories within quarterly reporting to central Finance leadership.
For inquiries regarding this finding, please contact Shannon Turner at Shannon.Turner@ucsf.edu who is responsible for the corrective action.
Campus Two
The University will implement changes to its biennial certification process that ensure adherence to the Uniform Guidance biennial equipment inventory requirements through the following changes:
• Update policy to require custodians to complete the Department Inventorial Equipment Certification Form within the first 18-months of the two-year measurement period.
• Implement a static measurement period (the beginning and end dates of the two-year period) for each custodian to ensure compliance with the established certification deadlines.
• Increase the number of notifications sent to custodians reminding them of their responsibility to complete the certification form to begin on the six-month anniversary of the beginning of the measurement period and will continue to send notifications every 90 days thereafter for the next 12-months (i.e. the 18-month anniversary of the beginning of the measurement period). On the 18-month anniversary, the notification frequency will increase to every 30 days until certification is completed.
• Enhance the existing monitoring procedures by providing compliance reports highlighting custodians who are out of compliance with the 18-month performance period and will send notifications to custodians, custodian supervisors, and department heads notifying them they are out of compliance with University policy.
A project plan has been developed and the system programmer engaged with an anticipated reprogramming start date of mid-March 2024 and an estimated completion date of June 2024. Biennial submissions will be closely monitored for those under the current two-year process until they are enrolled in the new process.
For inquiries regarding this finding, please contact Michael Riley at mriley5@berkeley.edu who is responsible for the corrective action.
Campus Three
Management has taken the following actions:
• Discussed directly with the specific asset custodians the need and requirement to update the equipment management system (AMS) with the last inventory date.
o It is to be noted that the two custodians who were part of the audit sample stated they had performed the physical inventory counts from downloaded excel sheet lists. However, they did not finish updating the last inventory date in AMS after completing the physical inventory.
o The custodians agreed to do a more thorough job of completing this step going forward in a timely manner, as required.
• As a part our normal annual process, we already cover the need to update these dates during the annual equipment management training done each Fall. Additionally, we will place stronger emphasis on this requirement and highlight the importance of this step at our next annual training in October/November 2024 for all custodians.
Actions to be taken:
We will follow up with e-mails to custodians and approvers who have not updated the last inventory date field. The two specific custodians are currently completing the updates to the last inventory date fields in AMS that they did not previously complete. Custodians will be asked to complete inventories by April 30, 2024.
It is to be noted that our current AMS system only facilitates updating the last inventory date in the system one at a time in individual asset screens. It is a manual process that is time consuming for custodians with a large volume of equipment under their custody (hundreds in some instances). Our future inventory system scheduled to go live next year is expected to address this issue and enable more efficient updates once the physical inventory has been completed.
For inquiries regarding this finding, please contact Selina Martin at selinamartin@finance.ucla.edu who is responsible for the corrective action.