A new report is now available for end users to view journal line detail on income statement reporting. The report "Find Journal Lines - OSU - Posted Journals by Amount Type" can be used to find the journal line details behind the data columns in reporting such as Equity Balances by Balancing/Carry Forward Worktags and Sources and Uses.
The Tableau "Financial Balances Summarization" report has been updated on "Project" field. Now, project and project phase code amount will be added in "Project" field.
Starting the week of January 29 , the “Find Supplier Invoice Details – OSU” report will be enhanced with a new "Line Memo" field in the output of the report. The line memo field includes details associated with a purchase for the line. Some internal billing teams are leveraging this field to provide additional clarity in the invoicing for their customers (e.g. tag number, date order was placed, order number, etc.) to verify the customer is billed for the correct record.
The university check run during the December holiday week will remain as normal. The check run will be on Thursday, December 28 with pick-up between 1:00 p.m and 4:00 p.m. Please ensure appropriate approvals are in place for expected checks.
Customer deposit transactions created and submitted on or after Friday, December 1 will have a transaction ID generated called "Customer Deposit ID." The Customer Deposit ID will be like other transaction IDs within Workday and will uniquely identify the deposit. The Customer Deposit ID will be preceded by "CD" and it will be followed by 8 numeric digits. The new Customer Deposit ID will be displayed on various deposit-related reports. Multiple cash sales can continue to be tied to a single customer deposit transaction. In such a scenario, the Customer Deposit ID will appear on all of the associated cash sale transactions under “Deposit Detail” section.
Currently, purchase requisitions and spend authorizations are reported on the weekly confirmation email sent out to Principal Investigators (PI) on their relevant Grants. Additionally, non-PO Invoices and Expense Reports without Spend Authorizations will start to be included during the month of October. This is to ensure that our PIs can review additional non-personnel charges against their Grants via this weekly reporting.
Customer Deposit functionality has been updated to enable users to add attachments for supporting documentation. Customer Deposits now has a new tab to include attachments when creating, editing, or revising the deposit. Anyone who has access to create and/or edit Customer Deposits will also have access to add/change attachments on Customer Deposit transactions.
Earnings units subject to sales tax must ensure a cost center journal is recorded monthly for sales tax payable to Debit 42000 Revenue and Credit 20500 accrued sales tax. This has been added to the Monthly Unit Reconciliation Checklist .
Please enter the journal ID on the sales tax form and submit your sales tax information monthly to salestax@osu.edu .
The Controller’s Office centrally relieves this payable monthly to reflect that sales tax has been remitted to the state.
Cost Center Managers and Service Centers have a responsibility to ensure the appropriate spend category is used on all transactions.
Pay special care to non-catalog requests with items with a useful life of one or more years that are over the greater than $5,000 threshold and ensure an appropriate trackable spend category is used; otherwise, the transaction will not route for registration. The "Spend Categories – FDM Values" report can be run with a filter on "Spend Category is Trackable" to identify trackable spend categories.
It is recommended to run "Find Supplier Invoice Details – OSU" monthly for your CC/CCH with a Line Spend Category Hierarchy of "Non-Trackable" to review for any greater than $5,000 missed items that need to be manually registered.
It is also recommended to run "Find Expense Report Details – OSU" monthly for your CC/CCH to review for any greater than $5,000 missed items that need to be manually registered.
The Workday report "OSU Plan vs Actuals by Cost Center" will be decommissioned on October 9.
Individuals should utilize the report "Plan vs Actuals by Plan Worktag" as the alternative. If you have saved filters for "OSU Plan vs Actuals by Cost Center" they should be moved to the replacement report prior to October 9.
