DFL weekly update - February 5, 2021

Upcoming deadlines at a glance

  • Friday, 2/5 - Complete Q2 Key Controls (today)

  • Tuesday, 2/16 - Submit completed and approved org tree request forms

  • Friday, 2/26 - Submit Reserve Analysis template

  • Friday, 2/26 - Queue commitments for Q3

  • Tuesday, 3/2 - Complete external audit confirmation for Q3

Budget process

FY22 budget process update

Due to the continued impact of COVID-19, we will launch the FY22 budget process later than usual (likely in early March).  However, by implementing an abbreviated process similar to last year, we expect to complete the process by the beginning of FY22. We’ll share more details about the upcoming budget process, due dates, and timeline in the coming weeks. 

CalPlan and HCP available

The CalPlan planning application is available with the FY21 beginning balance and July through December Actuals (this data has been available in CalRptg). The FY2020-21 Forecast Working version has been updated with the beginning balance and July through December Actuals. Due to the continued uncertainty regarding COVID-19, the FY22 Operating Budget is currently blank and uneditable it will be pre-populated and available when we launch the budget process in March. Please review the release notes for more information. 

Form A coming soon

The Financial Planning & Analysis team is planning to distribute the Form A templates at the end of February. The purpose of Form A is to plan campus support for faculty appointments. 

Refreshed FY2020-21 Intersection Detail Reports available

We have refreshed the Intersection Detail Reports for FY21. These were published to your divisional folders. They are available in the "FY2020-21 Budget Process Folder", in a sub-folder called "Intersection Detail Reports", with the nomenclature "Q3 and Q4 FY21 Plan". The refreshed FY21 Intersection Detail Reports (IDRs) will help clarify what will be loaded to CalPlan in the FY21 Forecast for Q3 and Q4. Any changes to commitments made after the report run date (noted at the top right of the report) will not appear on the IDRs. If amounts change, the affected units will be emailed and the amounts will be updated manually in CalPlan. 

Action items

Complete Q2 Key Controls by Friday, February 5 (today)

Please complete and submit the financial reporting and system access reviews by Friday, February 5. Please visit the Controller's website for instructions and more information. The FY21 budget is now finalized in CalPlanning. Because the GL Summary Report for Q2 will have year-to-date information, please review the data for both Q1 and Q2. By submitting the GL Summary Report for Q2 you will effectively be signing off on both Q1 and Q2 numbers, and you will not need to submit the GL Summary Report for Q1 separately. Email questions about the financial reporting review controls to the Financial Accounting & Controls team at gao@berkeley.edu and questions about the system access review controls to the BFS System Access team at secbfs@berkeley.edu.

Submit completed and approved org tree change requests by Tuesday, February 16

If you would like to submit changes to the Org Tree, please submit your completed, FP&A approved request by Tuesday, February 16. As a reminder, the submission date is the last day that approved change requests can be submitted for entry to the January Master Org Tree. We recommend that you submit your change request form for review as soon as possible to allow time for the Financial Planning & Analysis team to review your request, follow-up with you for any necessary clarification, approve your request, and allow you time to obtain all required signatures before the submission date of February 16. The time needed to review change requests will vary, depending on the complexity of the request. For more information:

  • A high-level summary of the process to approve org tree changes is available on the DFL concierge webpage.

  • An overview of the org tree change submission deadlines is available in the Org Tree Submission and Processing Timeline. Please keep in mind the last opportunity to process Org Node and DeptID movements was in November. Org Node and DeptID movements will not resume until after fiscal close; however, you may submit requests for movements at any time for review and approval. Please review the Org Tree Calendar for the timeline of allowable org tree changes throughout the year.

  • Please submit questions and requests for changes to the Org Tree to dfl_concierge@berkeley.edu.

  • Note: If you plan to request an Org Node change or Entity Hierarchy redesign, please contact dfl_concierge@berkeley.edu and explain what you would like to change before completing the request form because these changes are typically more complex and involve longer consultations.

Reserve Analysis templates are due Friday, February 26

The reserve analysis templates are in your division folder, in a folder called "Reserve Analysis Template" under the FY2021-22 Budget Process folder. A copy of your completed template from last year is also included, for reference. We held two reserve analysis workshops on 1/25 and 1/27. Thank you to those who were able to attend. We will be offering office hours every week starting on February 1 to answer any additional questions you may have. Please sign-up for the office hours ahead of time. The dates and times have been modified slightly. More information, including template guidelines and the workshop slides, are available on the CFO website. Your completed reserve analysis template is due to the Financial Planning & Analysis team at dfl_concierge@berkeley.edu on Friday, February 26. 

Queue commitments for Q3 by Friday, February 26

Please complete the applicable form (linked below) to queue commitments by Friday, February 26 for commitments to be funded in the third quarter of FY2020-21. Please note that the following commitments do not need to be queued: Budget Decisions; EVCP TAS; STAR Awards; BEAR Grants; Productivity Suite assessment and now endowment payouts for rotating chairs. Commitments are processed on a quarterly basis.

Please note that while we're working remotely you must log in through VPN for these forms to work.

Please email dfl_concierge@berkeley.edu with questions.

  • To queue non-faculty commitments, complete the non-faculty commitments form on the DFL Knowledge and Resource Portal.

  • To queue faculty commitments, complete the faculty commitments form on the DFL Knowledge and Resource Portal. Faculty commitments are defined for this purpose as Start-up; Retention; ASMD; and Chancellor's Professorships. Chancellor’s Professorships are those that are offered via start-up or retention in lieu of an actual chair - until one can be found, and are funded by central resources. 

    • New this year: Please provide screenshots of UCPath entries for ASMD leave begin dates and ASMD end dates when you queue ASMD funding through the faculty queue.

Complete external audit confirmation for Q3 by Tuesday, March 2

To ensure the completeness and accuracy of the quarterly Controller’s report on the campus’ external audit activities, please help us identify campus’s external audit activities. The Controller’s Office is sending a separate email with additional information to DFLs with known external audit activity. By Tuesday, March 2, 2021, please submit the materials below to Yohei Azuma at yazuma@berkeley.edu:

  1. All DFLs: External Audit Confirmation Form (You must return the completed External Audit Confirmation Form even if you do not have any external audit activities so we can certify campus responses.)

  2. DFLs with external audit activities: External Audit Confirmation Template  (Include any related documentation with the template, i.e. notification of the commencement of the audit, audit report, etc.)

If you have questions, contact Yohei by email at yazuma@berkeley.edu.

Informational updates

Foundation Endowment Payout

In FY2020-21 the Foundation Endowment payout moved to a quarterly payout distribution model. Due to this transition we put a moratorium on charging negative STIP on Foundation Endowment and FFE funds. We are reviewing this process and will provide an update once we’ve completed the review. 

FY2021-22 Budgeted Composite Benefit Rates 

We are in the process of submitting the calculated FY22 CBR rates to the Federal Government for approval. Please visit the CBR webpage for additional information and the new projected CBR rates for FY22. Please keep in mind that these rates have not yet been approved by the Federal Government and are therefore subject to change. We anticipate approval of the FY22 CBR rates before the end of this fiscal year (FY21). Contact centralresourcemanagement@berkeley.edu if you have questions.

CADSmart estimated payout report update

The “Estimated Payout Report” located in CADSmart has been updated and renamed the "Future Payout Report". In addition to showing the total expected payout for the upcoming fiscal year, it now also shows forthcoming quarterly distributions for Foundation endowments. The quarterly distributions have added some complexity to the expected endowed chair payout, so a link has been added within the report which will access a breakdown of chair distributions based on the various models. We’ll update these figures each May as new payout figures become available. If you have any questions, please contact Fund Management at fundhelp@berkeley.edu.

Update on FedEx file transfer to BFS issue

We are working with FedEx to address an issue that has arisen with our campus FedEx account. Usually, the Controller’s Office receives a file from FedEx that represents the campus bill on a daily basis and we post the charges to BFS, which are then applied to each department’s budget. However, FedEx has an internal file transfer problem and so we are having issues receiving the billing file and processing the FedEx payments. The issue began in November and we are working with our representatives at FedEx to resolve it as quickly as possible. As of January 20, 2021, the outstanding amount campus-wide is approximately $204,500 and nearly 14,000 transactions/shipments, and growing. As soon as we have more information on this issue, we’ll share another update. We have been assured there will be no service interruption to campus.  If you have any questions, please contact Gloria Smith, Accounts Payable Banking Team Lead at glosmith@berkeley.edu.   

CalPlanning and Smart View Training

Do you need to learn or enhance your skills in CalPlanning or Smart View? Training classes are available through the end of February 2021. Visit the training page of the CalPlanning website to learn more and sign up. Our new blended learning model combines self-study work that you can do at your own pace with instructor-led group learning sessions where you can apply the material covered in the self-study.

Office Hours for CalPlanning and Smart View

Office hours are available so that you can ask specific questions about CalPlanning and Smart View. Sign up for a session and indicate the topic for which you are requesting support. Office hours are an opportunity to get individual support for a specific challenge your unit is facing; they are not a replacement for training.   

Changes to the DFL in your division?

If the DFL role in your division is changing, email fpa@berkeley.edu to ensure our website, communications, and training plans are updated. 

As a reminder, these updates are regularly posted to the DFL webpage so you can reference past updates at any time. 

Thank you,
Office of the Vice Chancellor of Finance