Assigning Costing Allocations in Workday


Purpose

This document explains how Human Resource Partners (HRPs), Academic HRPs, Lead HRPs, Budget Partners, Costing Allocation Partners, and Workday Payroll Expense Initiator – Cost Center roles can assign costing allocations in Workday as a standalone business process.

Assigning Costing Allocations is also a sub-process that automatically initiates during the Hire, Add Job, and Change Job processes in Workday.

Not what you are looking for? Use the button below to visit our Library and find the information you need!

Library of Workday Knowledge Base Articles

Keep in Mind

· Costing allocations are maintained for employees in Workday through the Assign Costing Allocations task. Costing allocations tell Workday how a worker’s position and/or earnings will be funded and for how long. Regardless of funding source or number of sources, all employees who receive compensation through Workday payroll are required to have costing allocations assigned. This ensures that fringe benefits are accurately generated and aligned with the designated costing allocations

· Costing Allocations are assigned using either a Chart of Accounts, otherwise known as COA, or a Project Cost Collection Segment, otherwise known as POET(AF). For more details, please see the following trainings in Workday:

· Chart of Accounts Building Blocks | FST Program

· Chart of Accounts (COA) vs POETAF and How They Relate

· For definitions of each COA and POET(AF) segment, please review the Oracle to Workday Terminology Differences for COA/POETAF Knowledge Base Article.

· When determining if a COA, POET, or POETAF segment is needed, consider the following:

· COA is used when the worker is not directly supporting a grant, project, or individual award and discretionary funds.

· POET is used when the worker is supporting non-sponsored, non-billable projects such as Capital Projects and Internal Projects.

· POET(AF) is used when the worker is supporting sponsored, billable projects such as University Research, Clinical Research, Grants, and Individual Awards and Discretionary Funds.

· To complete this task, you will need the following information:

· COA or POET(AF) information that will fund the position or earning.

· If you do not know the COA/POET(AF) segments to use, review the COA Hierarchies Orbit Report for a comprehensive view of each segment's hierarchy or contact your Organization Financial Manager.

· Applicable funding dates.

· If more than one COA or POET(AF) is being used to fund the worker’s salary, the distribution percentages.

· When entering COA/POET(AF) segments, custom validations and Oracle Cloud cross validation rules run, which may result in a warning or error. If a warning or error occurs, please work with your department’s finance team. Examples of validation rule errors you may receive include, but are not limited to:

· "Grants and Contracts Sponsored Projects Funds between 310000 and 332014 can only be used with Purpose values 200,210,302,431,535,700,860”

· “Purpose 700 can only be used with Accounts between 75400 and 75415 and Accounts between 75600 and 75620”

· “Purpose 110 can only be used with Grants and Contracts Sponsored Projects funds between 310000 and 332014”

· See the Chart of Accounts Cross-Validation Rules (as of 7/16/2024) Knowledge Base article for more information.

· When entering COA/POET(AF) segments and either the Entity, Cost Center, or Purpose differ from the worker’s default organization assignments, you must enter the new segment value to override the default value.

· When the Entity differs from the default, the Cost Center will also need to be overridden and come from the new/differing Entity.

· If the Purpose value differs from the default and the updated Purpose value causes a validation error with the Fund, then a new Fund value must be entered based on the error message received.

· Assigning Costing Allocations will override the default COA values listed on the Organization Assignments step. These default COA values are attached to the position when the position is first created. Costing Allocations should be assigned once a worker is moved into a position.

· POET(AF) is not allowed for use with default organization assignments and will not be available to select.

· Multiple COA/POET(AF) values may be entered to fund a position or an earning.

· For POET(AF), when entering distribution percentages for a sponsored project the distribution percentages should reflect the proportion of effort, or work, that the person dedicates to the project.

· Effort is the proportion of time spent on sponsored projects, expressed as a percentage of the total professional activity for which an individual is employed by the institution. Must be a reasonable estimate with total effort equaling 100%

· Payroll distributions and effort reports are not the same thing. Payroll distributions are the distribution of an individual's salary, while effort reports describe the allocation of an individual's actual time and effort spent for specific projects, whether or not reimbursed by the sponsor.

· Costing allocations can be assigned to a Worker, Position, and Earning (such as a housing allowance or vacation allowance) or costing allocations can be assigned to a Worker and Position only. If you are going to be funding a specific earning for the employee differently than the rest of their salary, you will need to ensure the Worker, Position, and Earning level of costing allocations are entered before proceeding.

· When assigning costing allocations at the earning level, you must set the earning costing allocations up first and then come back to do another costing allocation, which will need to be assigned at the worker and position level only so that the remainder of the salary has costing allocations assigned.

· Costing allocations must be set up at the position level at minimum. If the costing allocations set up at the position level expire, the COA listed on the default organizational assignments will be used to issue payment.

· Compensation will always be paid out at the Worker/Position/Earning level before the Worker/Position level. Consider the following example:

· An employee has Regular Pay and a housing allowance.

· They have costing allocations assigned at the Worker/Position level and at the Worker/Position/Earning level for the earning “Housing Allowance.”

· When Workday processes the employee’s paycheck, it will first check for Worker/Position/Earning costing allocations. Accordingly, the employee’s housing allowance will pay out based on the distribution specified by the Worker/Position/Earning costing allocation.

· Because no other earnings are specified, the rest of the employee’s compensation will pay out based on the distribution specified by the Worker/Position costing allocation.

· An employee has Regular Pay only.

· Assigning a costing allocation at the Worker/Position/Earning level for Regular Pay earnings is functionally the same as assigning a costing allocation at the Worker/Position level. In this scenario, Workday will pay the employee only according to the Worker/Position costing allocation.

· Costing allocations must be finalized by noon of the bi-weekly or monthly payroll close.

· All employees, excluding staff and tenured faculty, must have end dates assigned to their costing allocations.

· There cannot be a gap in costing allocations. For example, if one costing allocation ends on 12/31/2025, the new costing allocation must start on 01/01/2026.

· If an update needs to be made to a worker’s costing allocations, end the current costing allocations by entering a date in the End Date field. Add a new costing allocation and use the start date of the new costing allocation in the Start Date field.

· Contract and award funds (grants) may not be allocated in Workday past the account’s end date. If costing allocations contain a project and/or grant that has ended, the default COA string from the organization assignments of the supervisory organization in which the position sits will be charged, not the expired project/grant.

· NOTE: Account end dates are not tracked within Workday therefore careful coordination with fiscal teams is required to proactively monitor and identify workers who are funded from grants that may end during a pay period.

· Salary Over the Cap is tracked in Workday. If a worker’s costing exceeds the federal salary cap amount for that month, the amount over the cap should be placed into the COA worktag combination specified in the Salary Over the Cap Default Costing Allocations section located above the Costing Allocations section. Salary Over the Cap must be charged to a COA; POET(AF) cannot be used.

· Within the Costing Allocation Details table, after adding an award number containing a salary cap, a badge icon (represented by a circle with a number in it) will appear under the Salary Over the Cap column. If desired, select this badge to make overrides to the Salary Over the Cap Default Costing Allocations values.

· IMPORTANT: If a new salary cap needs to be added into Workday, please submit an Ask a Payroll Question with the new salary cap information.

· For more information regarding costing allocations for employees assigned to a 9 Over 12 Academic Job Family, see the last section of this document.

· When applying a retroactive COA/POET(AF) change or correcting a payroll expense cost error, you need to:

· Update costing allocations in Workday, AND,

· Initiate a Payroll Expense Cost Correction in Workday, if payroll has already run.

· To review a history of costing allocations that have been changed on a worker, navigate to the worker profile, select Job, and then choose Worker History. If you select the View Worker History by Category option and then choose the Payroll tab, all costing allocation assignments that have been completed for this worker will be listed. Select further into an event to display who carried out the task. See the Viewing Worker History in Workday Knowledge Base Article for more information.

· If Payroll must override costing allocations for invalid combinations (i.e. past a project end date), they will override and remove any invalid combination and replace with the default organization assignments for the worker.

· There are other warnings that may result due to the use of inactive worktags. While inactive worktags can be used, caution should be exercised on if the use of an inactive worktag is appropriate. (i.e. The use of an inactive worktag in an ended costing allocation is ok but the use of an inactive worktag in a future-dated allocation is typically not ok.)

· Access the Top Reports for Campus Users dashboard in Workday for a list of helpful reports categorized by security role.

Assigning Costing Allocation Steps

1. Log into Workday using your CNetID and password.

2. Navigate to the Employee’s Profile by typing their name or another unique identifier (Chicago ID, SSN, Employee ID, etc.) in the search bar at the top of the screen. Select the appropriate suggested record that appears below the search box, or press Enter to run the complete search, and find the right employee.

a. Use the prefixes worker: or id: to refine the search results. For details on how to use prefixes, review the Workday Search Prefixes Knowledge Base Article.

3. From the Employee Profile, select the Actions button, hover over Payroll, and choose Assign Costing Allocation.

4. Under Include Existing Allocations, the From field will auto-fill with today’s date. Enter an end date for the costing allocation within the To field, if applicable.

5. Under Worker Costing, the Worker field will auto-fill and the Position may auto-fill. If the Position does not auto-fill, use the Hamburger Menu (the icon with three dots and three dashes) to select the appropriate position. If you are assigning allocations to both the position and earnings, then you must also select the applicable Earning.

6. Select OK to be brought to the next Assign Costing Allocation page.

7. Costing allocations are divided into two tabs: Proposed Costing Allocations and Existing Costing Allocations. The Existing Costing Allocations tab displays a read-only table of current costing allocations, if any have been set up. Conversely, the Proposed Costing Allocations tab allows users to add new costing allocations and view previous ones.

8. In the Proposed Costing Allocations tab, on the right-side of the page the Default Organizational Assignments (As of Start Date) information is listed, for reference.

9. In the Proposed Costing Allocations tab, on the left-side of the page select the (+) Add option to insert a new tab into the left-side navigation menu to assign costing allocations. Each tab displays the Start and End Date, if applicable, for the corresponding allocations.

a. Enter the Start and End Date for the allocations.

i. All employees, excluding staff and tenured faculty, must have end dates assigned to their costing allocations.

ii. REMINDER: There cannot be a gap in costing allocations. For example, if a costing allocation’s End Date is 12/31/2025, then the new costing allocations Start Date must be 01/01/2026.

b. Under the Costing Allocations section, insert rows as needed by selecting the Plus (+) icon.

i. Enter the appropriate COA and/or POETAF segments.

1. Multiple COA and/or POETAF values may be entered to fund a position or an earning.

2. Data entry must occur from left to right using the Hamburger Menu to the right of the appropriate prompt boxes.

3. For COA segments, fill out the Entity, Cost Center, Fund and Purpose columns. Within the Additional Worktags column, enter the remaining segments, if required: Program, Activity and Site.

4. For POETAF segments, leave the Entity, Cost Center, Fund and Purpose columns blank (unless these fields require updating). Within the Additional Worktags column select the appropriate options for Funding Source, Grant, PPM Projects and Task.

a. In the rare case when a worker is paid out of a project that has an Entity different from the worker’s default organizational assignments, this field requires completion.

b. When the Entity differs from the worker's default Entity, you will also need to enter a Cost Center that belongs to the newly entered Entity.

c. In the rare case when a worker is paid out of a project that has a Cost Center different from the worker’s default organizational assignments, this field requires completion.

d. When the Cost Center does not fall under the worker's default Entity, then you must first enter the new Entity and then select a new Cost Center under the newly entered Entity.

e. If a Purpose value is entered that causes a validation error against the worker's default Fund, a new Fund value must be entered.

f. In the rare case when a worker is paid out of a project that has a Purpose different from the worker’s default organizational assignments, this field requires completion.

i. When the newly entered Purpose causes a validation error against the worker's default Fund, which is listed under the Default (As of Start Date) column, then enter a new Fund value.

1. Please see the Chart of Accounts Cross-Validation Rules and Chart of Accounts Purpose Values and Definitions Knowledge Base Articles for more information.

g. Salary Over the Cap is tracked in Workday. If a worker’s costing exceeds the federal salary cap amount for that month, the amount over the cap should be placed into the COA worktag combination specified in the Salary Over the Cap Default Costing Allocations section located above the Costing Allocations section. Salary Over the Cap must be charged to a COA; POET(AF) cannot be used.

i. Within the Costing Allocation Details table, after adding an award number containing a salary cap, a badge icon (represented by a circle with a number in it) will appear under the Salary Over the Cap column. If desired, select this badge to make overrides to the Salary Over the Cap Default Costing Allocations values.

5. Under the Distribution Percent column, type in the percentage of the salary or earning that will be paid from the specified account and sub account. The total must equal 100%. For sponsored projects, the distribution percentages should reflect the proportion of effort, or work, that the person dedicates to the project.

10. To add additional costing allocations, repeat step 9 and make sure the Start Date is correct and add an End Date, if applicable. Fill in all presented columns.

a. To automatically add a new costing allocation table that mirrors the previous, checkmark the Copy Costing Allocation box. This will display the same funding distribution and COA/POET(AF) values as the previous allocations.

i. This saves time, especially when maintaining multiple funding COA/POET(AF) values for one individual that experiences slight changes in funding allocations from month to month.

11. To remove costing allocations, select the Remove icon, as represented by a black circle with a white minus icon in the middle, located in the top-right corner or each costing allocation tab.

12. Once costing allocations are finalized select Submit to complete this process.

a. Once submitted, custom validations occur which may result in warnings such as using an inactive worktag. Also, based on Oracle Cloud cross validation rules, critical errors related to combinations of COA segments may trigger. If a warning or error occurs, please work with your department’s finance team.

Employees Assigned to “9 Over 12” Academic Job Family

· Salaries posted to the REGULAR – 912 and MINISTERIAL HOUSING 912 earn codes should generate an accrual entry to account for the 9 months of effort paid to individuals over 12 months.

· The accrual entry charges a COA/POET(AF) for the individual’s effort and credits another COA/POET(AF) for the same amount. The net effect on all COA/POET(AF) is that the employee receives 1/12 of their salary each month of their appointment.

· In Workday, a costing allocation needs to be created for the REGULAR 9/12 ADJUSTMENT (ADJ) earning (which is the accrual entry) to direct the credit entry to a unit’s appropriate COA combination. Note that every individual who has a costing allocation for a position in a ‘9 over 12’ job family needs to have a corresponding costing allocation created for the accrual entry credit, ADJ.

· When entering costing allocations for employees assigned to a 9 over 12 Academic Job Family, ensure that there is a separate costing allocation entered on the REGULAR 9/12 ADJUSTMENT earning level.

· The start date of the costing allocation should always align with the costing allocation start date on the position level.

Back to Top