Below are several FAO tools to support UR Financials work.
[Note: The Electronic Invoice Listing and Integration Contacts have moved to a separate page under the Resource tab]
- Data Field Definition crosswalk (Supplier Invoice)
- Spend_and_Revenue_Category_Definitions_09-11-2020
- FRS Department to Workday Cost Center Crosswalk
- FRS Account to UR Financials FAO Crosswalk
- UR Financials Ledger Accounts, Spend & Revenue Category Listing
- FRS Subcode to Workday Worktags Crosswalk
- Enterprise Interface Builder (EIB)
- Data Cookbook
- Allocations-and-recurring-Entry-contacts-2020.03.03
- Job-Aid-for-SIG-Meeting-of-Ledger-accounts-SC-RC-list_03-20-2020
Spend and Revenue Category Definitions
This definition list is a living document and requires collaboration to maintain. Use this to view current Spend_and_Revenue_Category_Definitions_09-11-2020 This spreadsheet contains 3 tabs; Request to Add/Change, View Spend Categories and View Revenue Categories. Updated as of January 21, 2020
FRS Department to Workday Cost Center Crosswalk
This crosswalk shows the Cost Centers mapped to each FRS Department. In Workday, Cost Centers are not directly attached to companies (divisions) and can be aligned to multiple companies. FAOs are attached to both the Cost Center and Company using worktags. Data represented as of September 1, 2015 date.
FRS Account to UR Financials FAO Crosswalk
The cross reference between FRS accounts and Financial Activity Objects (FAOs) is available for use. The excel spreadsheet allows users to look up their FRS accounts and determine the corresponding Workday Grant, Project, Operating Program, Gift, Loan Program, or Debt Service FAO. As additional accounts are added, the UR Financials project team will update the cross reference to reflect the changes.
FRS and FAO Accounts as of September 1, 2015 — Does not include Net Investment in Plant (NIP) FRS accounts.
Some FRS accounts have been consolidated under one Financial Activity Object (FAO). This is by design as we move to the new Chart of Accounts in Workday.
UR Financials Ledger Accounts, Spend & Revenue Category Listing
A job aid is available that shows ledger accounts and their associated spend or revenue categories, if applicable. This excel spreadsheet Job-Aid-for-SIG-Meeting-of-Ledger-accounts-SC-RC-list_03-20-2020 allows users to look up ledger accounts and categories based on the nature of the transaction. As additional ledger accounts and categories are created, the UR Financials project team will update this job aid to reflect those changes.
Data represented from Workday as of February 8, 2019..
FRS Subcode to Workday Worktags Crosswalk
This crosswalk spreadsheet has two tabs to represent Integrations that flow through Workday (January 1, 2015) and the Converted Balances that are migrated to Workday (July 1 – December 31 2014). Each tab includes both SL & GL subcodes. Utilize filtering to perform searches.
Converted Data will be translated from FRS to Workday terms using the “Balance Conversions” tab for July 1 thru Dec 31 2014 balances. Starting in January 1, 2015, all transactions will use the “Integrations” tab for the second half of FY2015 and ongoing. The major differences with these two tabs are how Property, Plant & Equipment are handled.
This excel spreadsheet allows users to look up their favorite FRS subcodes and determine the corresponding Workday Spend Category, Revenue Category and Ledger account. As additional subcodes are added to FRS, the UR Financials project team will update the cross reference to reflect these changes.
Data represented as of September 1, 2015 (FY2014 and FY2015 with New subcode description or attribute change).
Some FRS subcodes have been consolidated under one Spend or Revenue Category. There are also new Spend and Revenue Categories that don’t currently exist in FRS as subcodes. This is by design as we move to the new Chart of Accounts in UR Financials.
Enterprise Interface Builder (EIB)
Workday’s EIB Tool is designed to upload financial transactions in batches. This tool will only work for certain Workday roles assigned to use it.
- E301_Import_Accounting_Journal_v31.1updated 1/29/19 – delete all other templates
*Editing journal step now completed in the Inbox > Archive area only- Import Accounting Journal Quick Reference Guide *updated 06/21/16
- Import Accounting Journal EIB Example
- Video Training is available for the Import Accounting Journal file
- Budget EIB Tool (zipped file) updated 8/4/17– delete all other templates STARTING FOR FY2020, BUDGET AMENDMENTS ARE NOW TO BE ENTERED ONLY IN UR BUDGET (AXIOM) SYSTEM. QUESTIONS, PLEASE CONTACT LIBBY DEIBLER.
*Editing journal step now completed in the Inbox > Archive area only
- Import Budget Amendment Quick Reference Guide *updated 6/21/16
- Budget ID sheet for reference.
- E302_Put_Recurring_Journal_Template_28.0.xml Updated 7/16/18 – delete all other templates
- E307_Update_Related_Worktags_28.0 – Use this EIB after an FAO changes cost centers or companies to move the GL balances from the old organization worktags to the new organization worktags.
When using updated EIB forms, delete any previous versions you may have on your hard drive and use versions found here.
Data Cookbook
The UR Financials Glossary found on the main page of each navigation tab is powered by the Data Cookbook. This business glossary defines words used in UR Financials’ reports delivered via Workday, or the Finance Data Warehouse. With this tool, you can search for Workday terms and general finance terms as well as translate UR Financials’ terms with comparable FRS terms.
For feedback or questions, please use the Contact Us link on the UR Financials website.