Resolution to General Ledger Discrepancy Impacting Leave Expense Transactions

In October 2021, we identified a UCPath defect resulting in missing leave expense transactions in the Distribution of Payroll Expense (DPE) reports and the General Ledger (GL). The defect was the result of the UCPath GL process marking leave expense lines and the offsetting reversing regular earning expense lines as “do not post” when the net impact of the lines summed to zero at the chartstring level.

Example: Leave expense and regular pay offsetting lines summing to zero at the chartstring level
Bus Unit Fund Dept ID Project Function UCOP Account Earn Begin Date Earn End Date ERN Description Hours Amount
SFCMP 5014 138321 2015454 45 1100 6/1/21 6/30/21 REG Regular Pay -5.28 -332.35
SFCMP 5014 138321 2015454 45 1100 6/1/21 6/30/21 VAC Vacation Leave-Used Salaried 5.28 332.35

As a result of this defect, users most commonly observed a discrepancy between the total vacation salary expense and total vacation relief credits being reported in an earnings period. The root cause of this issue is related to the UCOP Account Code recorded on the UCPath Labor Ledger (note that UCOP Account codes are not visible in UCPath or in MyReports). Salary Account codes 1100 and 1000 were applied incorrectly for vacation expense lines used, in place of the vacation expense Account code 1950.

A solution was implemented in November 2021 to prevent this error on the posting of future vacation expense lines. To resolve missing historical transactions, the UCPath Center will post the missing vacation expense and corresponding regular earning offset transactions back to January 2021 to the January 2022 accounting period. The historical transactions will have a net zero impact to the GL; however, users are advised to run their DPE by Earning Period to view all earnings distribution lines for each Earnings End Date, as postings will occur in different accounting periods.

If you need assistance, contact the Controller’s Office Solution Center.