January 2022 Release Notes

The CalPlanning FY22 Forecast and a preliminary version of the FY23 Operating Budget are now available for planning. We used data from CalPlanning FY22 Operating Budget Final as sources for FY22 Forecast and FY23 Operating Budget.  Note: the FY23 Operating Budget has not officially launched and therefore no budget assumptions have been built into the FY23 Operating Budget.  We are providing access to the budget in case you would like to get a head start on some internal budgeting work.   

Overview of FY22 Forecast and FY23 Operating Budget

1. Data Sources

We copied the FY22 Operating Budget Final version to both the FY22 Forecast and FY23 Operating Budget:

• FY22 Forecast and FY23 Operating Budget Initial are available for reporting

• FY22 Forecast and FY23 Operating Budget Working are available for editing and reporting

2. Differences between FY22 Operating Budget Final, FY22 Forecast Working, and FY23 Operating Budget Working

The FY22 Forecast Working and current FY23 Operating Budget Working versions are nearly identical to the FY22 Operating Budget Final version except for these differences:

• FY22 Forecast Working 

• Beginning Balance, July, August, September, October, and November periods are Actualized

• Central transfer accounts are updated with a combination of Actuals and the most recent planned data from the Campus Commitment Database

• FY23 Operating Budget Working 

• CalPlan*

• Beginning Balance equals FY22 Forecast Working Version Ending Balance and will be updated as changes are made to the Forecast

• Central transfer accounts are updated with the most recent planned data from the Campus Commitment Database

*Remember, this is just a preliminary version of the FY23 Operating Budget, the FY23 budget has not officially launched nor have assumptions been finalized.

• HCP*

• Monthly FY23 pay rates include a 3% increase over the FY22 June pay rate for individually-planned employee positions and to-be-hired positions** 

• FY23 Pooled Position amounts were increased by 3% over the prior year**

• Dept ID adjustments were not copied from FY22 to FY23.

**Note: FY23 merit increase amounts remain subject to change pending decision from UCOP.

3. HCP copy from FY22 to FY23

• HCP data for FY22 Forecast Working version includes the following:

• Actualized July through November periods

• Updated fee remission rates have been applied 

• GAEL remains at the planned value for the year 

• HCP data for FY23 Operating Budget Working version was created in the following manner:

• For individual and new/to-be-hired employees, the data in the month of June 2022 for monthly pay rate with a 3% increase and distributions were copied to all periods of FY23.

• For pooled positions, FY21 data was copied over to FY22 so it retains the same seasonality with a 3% increase. 

• Dept ID adjustments were not copied from FY22 to FY23

• Recommended action: Planners will need to check to make sure the copied data do not result in overplanned employees in the FY23 Operating Budget (for example, if an employee was meant to end employment in June 2021, they have been extended into the following budget year with this process.)

• Fee remission rates have been updated for FY22 and FY23 in CalPlanning. (The rates are listed below).  

• FY23 CBR rates have not been approved by the Federal Government, and thus no changes have been applied.  Once we have approved rates, we will update these in a future release.

The table below outlines what was seeded in the FY22 Forecast Working and FY23 Operating Budget.

FY22 Forecast Working 

*Compensation in this context includes fee remissions

FY23 Operating Budget Working

*Compensation in this context includes fee remissions

4. Central Transfer Accounts Update

Intersection Detail Reports have been updated with the most recent commitments data available for open periods in the FY22 Forecast (Q2 & Q3 & Q4).

Some faculty funding amounts that were based on the August 2021 Form A submissions that were in the September accounting period of FY22 Operating Budget Final were moved to February in FY22 Forecast Working. Specifically, the intersections were:

• FY21 Anticipated Separations in account 71420

• FY22 New Faculty Hires (7/1/2021 or 1/1/2022) plus FY21 New Faculty Hires in account 71314

• FY22 Benefits related to above two items in account 71304

5. Actualized Forecast

With the Actualized Forecast process at the close of each month, we overwrite the Forecast values with Actuals data from BFS for all accounts: non-compensation accounts in CalPlan and compensation accounts in HCP.

The closed months (July 2021 to November 2021) of the FY22 Forecast Working now reflect actual data. 

6. FY22 Beginning Balance Details

Beginning Balances reported in CalPlan and CalRptg contain data seeded from BFS FY22 period 0 Actuals.

For most funds, Beginning Balances do not contain period 0 TempBudg. Only a small number of Contract and Grant (C&G) funds, including Financial Aid and Federal Appropriation funds, have continued to use TempBudg in BFS since the C&G implementation, so their Beginning Balances continue to include Period 0 TempBudg and Actuals in CalPlanning.

These ranges are as follows:

• Financial Aid Funds (ranges 23513-23548, 23601-23603, and 33980-33990)

• Federal Appropriation Funds (ranges 21000-21099 and 33870-33899)

NOTE: Data for inactive Contract and Grant (C&G) funds are excluded from CalPlanning for FY22 Beginning Balances.

Known Issue

The HCP "Review HCM data to add to plan" task has been hidden for the time being. It will be made available again with fresh data when we formally open the FY23 Operating Budget.

Details for Reference

Composite Benefit Rates, Fee Remission, and GAEL

Composite Benefit Rates and GAEL have been updated for planning purposes. Fee remission rates were updated with newer rates in January. UCRP is calculated for Current Funds excluding Contracts & Grants.

The composite benefit rates (CBR) the FY2022-23 rates are for planning purposes only; we will not know the final rates until later this fiscal year.

As a reminder, since implementing UCPath we follow a standard process for calculating rates led by UCOP and will adopt their agreements with the federal government. More information about how the CBR rates are calculated is available on the Composite Benefit Rate webpage

See the Composite Benefit Rates (CBR), General, Automobile, and Employment Liability (GAEL), and UCRP Supplemental Interest Assessmentwebsites for more information.  Note the GAEL and UCRP rates are subject to change when we officially launch the FY23 Operating Budget.