A downloadable year-end checklist for Finance and Supply Chain activities" is available under the "I want to..." heading found on the Business and Finance website's Controller page . The checklist includes important dates and action items for FY25 year-end.
Effective the week of Monday, February 24 , the "Payroll Accounting Adjustment Status" report will have some enhancements made to its prompt functionality. First, this report will include "Initiated By" as a prompt. Secondly, the prompt functionality for Current Expense Worktags and Proposed Expense Worktags will change to look at what is entered in either prompt.
Below is a brief example using two PAAs.
Current worktags are in CC12345 and the proposed worktags are in CC45678. Current worktags are in CC45678 and the proposed worktags are in CC12345.
In the "Payroll Accounting Adjustment Status" report prompts, you can now enter CC12345 in the Current Expense Worktags and CC12345 in the Proposed Expense Worktags and BOTH of the PAAs listed above return. Prior to this change, you would have needed to run two separate reports to get the intended data--one report run where CC12345 was in the Current Expense Worktags and a second report run where CC12345 was in the Proposed Expense Worktags.
Effective the week of Monday, February 24 , a prompt for "Prior Worktags" will be added to the "Accounting Adjustment Status - OSU" report. This particular prompt will use the "or" logic so that if a value is entered in another prompt, such as Proposed Organization, the results will return adjustments that have the proposed organization OR the prior worktags entered in the prompt. This is similar to the change being implemented for Current Expense Worktags and Proposed Expense Worktags on the Payroll Accounting Adjustment Status report.
The specifc reports listed in the full post will be updated during the week of Monday, February 24 to enhance user ability to analyze expenses. Current state, these reports have the ability to expand directly from the ledger account value into all Spend Category detail lines. This update will group the Spend Categories into groupings determined in the All Spend Categories hierarchy. Reports will populate level 5 of this hierarchy with the ability to further expand to detail line items if needed. The hierarchy groupings can be viewed in the “Spend Categories – FDM Values" report.
Spend category hierarchies (level 5) will be updated to create logical groupings of expenses. These groupings will help provide a level of visibility that is inbetween the high-level Supplies and Services view, and the granular spend category level. Below are a few examples of logical expense groupings the changes will create.
Computer, Audiovisual, and Copying Services Maintenance and Repair Services Financial, Accounting, and Legal Services HVAC, Electrical and Electronic Components
Once the hierarchy changes are made, the "Sources and Uses - Variance Analysis" report will be updated to bring in the level 5 spend category hierarchies. This will allow you to expand supplies and services and view spend associated with the updated hierarchies. You will still have the option to drill/expand to view at the individual spend category level if you have the need.
A new report group, Financial Transactions Awaiting Action, has been released. This report includes three different reports that provide a list and the status of journal, accounting adjustment, and asset transactions that are awaiting an approval or to-do step. To run this report group, users can go to the "Schedule a Report" task and search for "Financial Transactions Awaiting Action." Once the prompts are entered and the report group runs, all reports will be available in one Excel spreadsheet.
As of Friday, December 6 , Workday validations will be placed in various spend business processes to ensure the cost of sales expenditure treatment worktag can only be utilized by approved university earnings operations (Funds FD120, FD121, FD122 and FD200). In addition, users will no longer be able to add ET101 to costing allocations, one-time payments, or period activity pay.
As a reminder, use of the ET101 expenditure treatment drives the transaction accounting to the cost of sales ledger account (61020).
ET101 plus the appropriate earnings fund value and an eligible spend category value should be used to designate cost of sales. Eligible spend categories are those included in the services, supplies, or fuel and fuel additives hierarchies. Manual journals should use the cost of sales ledger account 61020 and an eligible spend category. Please refer to the university earnings operation policy for additional guidance and the full definition of cost of sales.
The Cost of Sales Spend Category (SC10258) will be inactivated for future use, as it does not meet the definition of spend category. ET101 plus the appropriate earnings fund value and an eligible spend category within the services, supplies, or fuel and fuel additives hierarchies should be used to designate cost of sales.
The "Financial Balances Summarization with flexible selectable columns" Tableau report has been enhanced with an additional tab for "Flexible columns Financial Balances Summary Yearly Trending."
In the new tab, users can view the actuals data by fiscal year. Users can now select columns and filters based on their needs and compare multiple years of financial data. The "Period" field is used to drive what month(s) populate the actuals results by fiscal year. A selection of a January period would compare yearly trends from the start of the fiscal year through January across fiscal years selected.
The Controller's Office recommends that units do a periodic review for worktags that are no longer being used and submit inactivation requests through an FDM Request in Workday. Prior to submitting worktag inactivation requests, please ensure that the Inactivation Checklist has been completed and the balances are clear.
Note that the checklist was recently updated to differentiate reports that should be run for FOD projects beginning with PJOSU. Contact CTL-FDMRequests@osu.edu with any questions.
