Back in September we replaced the structure of this existing spreadsheet with a new layout. This crosswalk spreadsheet now has two tabs to represent Integrations that flow through Workday (January 1, 2015) and the Converted Balances that we are migrating to Workday (July 1 – December 31 2014). Note that 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.
Visit the Tools page and scroll down to the FRS Subcode to Workday Worktags Crosswalk section to access this crosswalk. Once opened, use this spreadsheet to look up favorite FRS subcodes to 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 from Cognos as of November 7, 2014 (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.