To continue to improve the end user experience the data points listed below have been added to the "[CERTIFIED Workday] – Payroll Journal Line" data source in Tableau.
- Job Family - Job Family Group - Fringe Basis
We are also working to add these attributes into our flexible and standard payroll reports in Tableau over the course of the next two weeks. This post is available via NewsLink online.
An additional date prompt will be added to this report called "Commitment as of Date" as another option to run the report.
To view encumbrances over a range of time you will continue to use the "Commitment End Date On or After" and "Commitment End Date On or Before" Prompts. This prompt looks at the end of the pay period for which the commitment spans. Selecting a range allows you to search for any encumbrances where the pay period end date falls within the range you selected.
Alternatively, we now have a new search option titled, "Commitment as of Date" which allows you to find encumbrances where the pay period falls within the date you specify in the prompt. This is useful to see what encumbrances exist as of the date specified in the prompt.
Effective Friday, January 20 , Position Restriction costing allocations can use grants. Any new positions that are grant funded can now be set up at the Create Position step. Cost Center Managers are not required to update the previously recorded costing allocations to accommodate the new functionality.
The Workday issue with payroll encumbrance adjustments has been resolved and the Controller's Office ran the process successfully on February 18. Payroll encumbrance balances now represent approved activity through that date.
Original post:
The Controller's Office is currently unable to run payroll encumbrance adjustments due to an issue within Workday. Workday plans to deliver a fix the weekend of February 10, and it will require testing before going into production . All payroll encumbrance balances represent approved activity through January 3 . Any changes to hires, terminations, funding, FTE, or pay rates after January 3 will not be reflected in the General Ledger or in the "Positions for Plan" reporting until the issue is resolved. We apologize for any inconvenience. The payroll encumbrances will be updated as soon as possible.
For the month of August, departments are charged for one half of the nine-month rate for their nine-month faculty. To properly expense August salary, best practice is to use the costing dates of 08/15/2022 to 08/31/2022. This will ensure that costing prorates properly for the half month of pay. Please refer to the Advanced Costing Allocations for 9/12 Faculty job aid in the Administrative Resource Center (ARC) for additional details.
Encumbrance updates for 9-month faculty (the adjustment to convert encumbrances from 12 months to 9 months) are still being calculated. Updates are anticipated to be finalized by mid-July.
As mentioned in the previous post from November 12 , Workday recently delivered a fix which will correctly exclude the earnings from salary over the cap in most scenarios for actuals and encumbrances.
Recently, earnings paid via any method other than period activity pay, that are excluded from salary over the cap and funded by a grant, were inappropriately treated as salary over the cap.
This issue required a payroll accounting adjustment to move the expense from the department to the grant.
Workday has delivered a fix which will correctly exclude the earnings from salary over the cap in most scenarios for actuals and encumbrances. More information is forthcoming and will be discussed during the portion of the November Finance Office Hours session, regarding how to identify affected payments from prior pay periods.
