Excel Sheet Download 30767

Partial file snippet.

Sheet 1: Table of Contents

	
	
	
		Table of Contents
		

	
	
		Tab name:
		Description of Content:
	
	
		Key Concepts
		Provides the key changes between the legacy chart of accounts and the Workday FDM structure.
	
	
		Debit/Credit Summary & 
Common Combinations
		Debit/Credit Summary provides a summary on how to increase or decrease ledger account types. 
Common Combinations provides a template to document the translation of your most used legacy chartfield strings to Workday worktags.
	
	
		FDM Worktag Reference
		Provides a listing of each worktag, ID format, short description, additional functionality and usage within Workday.
	
	
		Funds Reference
		Provides a list of available Workday funds and associated definitions.
	
	
		All Ledger Accounts
		Provides a list of all Company Ledger Accounts, grouped by UNIV Consolidated Ledger Account Summary.
	
	
		University Ledger Accounts
		Provides a list of UNIV Ledger Accounts, grouped by the Managerial Ledger Account Summary.
	
	
		Account Posting Rules
		Provides instructions on how to read the report that displays which categories drive which ledger accounts.
	
	
		Fund Transfer Journal Entries
		Provides the list of Ledger Accounts and associated Spend/Revenue Categories that should be used on transfer journal entries.
	
	
		Custom Validations Reference
		Provides the error message you will receive for rules built in the system to prevent invalid worktag combinations.
	
	
		Journal Sources Reference
		Provides the origin of each journal.
	
	
		

		

	
	
		

		

	
	
		Other Resources
		

	
	
		Training Resources - Administrative Resource Center
		https://admin.resources.osu.edu/
	
	
		Crosswalk to Workday Reports
		https://admin.resources.osu.edu/reporting-and-data-tools/workday-reporting/available-reports-and-reporting-crosswalk
	
	
		Translation Tool 
		https://fintranslator.osu.edu
	



Sheet 2: Key Concepts

	
	
	
	
		Key Concepts:
		This tab provides information about the key changes between the legacy chart of accounts and the Workday FDM structure.
		
	
		

		
	
		Key Concepts
		System
		Description
	
	
		Accounts/Ledger Accounts and Categories
		PeopleSoft
		 - Requires segment on all PS transaction lines
- Detailed revenue and expense accounts to meet both management and external reporting needs
	
	
		Workday
		Ledger Account: 
- Required on all transaction lines but only selectable on journal entries
- Revenue and expense ledger accounts at F/S line level of detail
Revenue Category:
- Used in combination with revenue ledger accounts to get management reporting level detail
- Drives the ledger account that will be used on operational transactions
Spend Category:
 - Used in combination with expense ledger accounts to get management reporting level detail
- Drives the ledger account that will be used on operational transactions
	
	
		Balance Sheets
		PeopleSoft
		Funds
	
	
		Workday
		Unique Combinations of: 
Company, Fund, Balancing Unit, Project, Gift, and Grant
	
	
		Budgets/Plans
		PeopleSoft
		Two types of Budgets:
- General Funds Spending Authority (allocations of unrestricted cash/equity)
- Plan and Earnings Budgets (projections of revenues, expenses and transfers)
- Two answers to the question ‘How Much Money Do I Have?’
      General Funds = GFSA budget, less expenditures
      All Other Funds = Equity balance in the fund
	
	
		Workday
		 - Budgets (plan structures) in all fund groups are plans – not an allocation of funds.
- For general funds, units will receive their annual funding as fund transfers.  
- Equity balances will carry forward at very granular level (unique combinations of balancing unit, fund, cost center, program, assignee and activities and events). 
- Clearer distinction between a unit’s annual allocation of general funds cash/equity and its spending plan for the year.
- How much money do I have = equity balances in all fund groups
	
	
		Business Units/Companies
		PeopleSoft
		University, OSURF (Sponsored Programs), OSUMC (Health System)
	
	
		Workday
		The Ohio State University, OSU Health System, OSU Physicians, Inc., The Ohio State University Health Plan, Inc., Mount Carmel - OSUP Physician Alliance, LLC
	
	
		Income Statements
		PeopleSoft
		Unique Combinations of:
Organization, Fund, Project, and Program
	
	
		Workday
		Unique Combinations of:
All FDM Worktags
	
	
		Multi-Book Accounting
		PeopleSoft
		N/A
	
	
		Workday
		Provides multi-book functionality to segregate certain types of accounting entries, including those related to asset capitalization and period-end adjustments to bring the financial statements to a full GAAP basis.
	
	
		Orgs/Cost Centers
		PeopleSoft
		 - Requires segment on all PS transaction lines
 - Workflow roles and routings based on organization
	
	
		Workday
		 - Required on income statement lines only
 - Workflow roles and routings primarily based on Cost Center
 - Balance Sheet transactions will be routed based on initiators Cost Center
	
	
		Owner Orgs/Balancing Units
		PeopleSoft
		 - Behind the scenes attribute for each fund
 - Does not appear on transaction lines
 - Used for "61" reports, lift-out financials and segment reporting
 - Owner Orgs use same IDs as PS Orgs and use same org tree
	
	
		Workday
		 - Required on all transaction lines
 - Used for future balance sheet management reporting, lift-out financials and segment reporting
 - Balancing Unit IDs will have different IDs from Cost Centers and separate hierarchies
	
	
		Smart Numbering/Hierarchies
		PeopleSoft
		Owner Org, Organization, Fund, and Account
	
	
		Workday
		Fund and Ledger Account
Hierarchies Used for: Cost Center and Balancing Unit
	
	
		Trees/Hierarchies
		PeopleSoft
		Used to summarize information for reporting
One or more trees exist for each segment of the chartfield (except user defined)
Relatively limited visibility to end users
Currently rely on a mix of PS trees, fund attributes (owner org) and account attributes (FS line) to meet external reporting requirements
	
	
		

		Workday
		Used to summarize information for reporting and to define user roles/security
One or more hierarchies will be built for most worktags
Expected to be more visible and widely used (for example, as saved filter criteria in Workday reports)
Primary hierarchies for external financial reporting will include those for the balancing unit, fund and ledger account
	
	
		Supervisory Orgs
		PeopleSoft
		Reports To
	
	
		Workday
		Supervisory Organizations in Workday illustrate managerial reporting relationships, i.e. who reports to whom. Think org chart. All employees are hired into a Supervisory Organization which provides structure for employee management, business process routing, and represents Ohio State reporting structure. In addition, supervisory organizations will be used to route time entry and leave requests for approval. (View Supervisory Organization)
	
	
		Academic Structure
		PeopleSoft
		Information to be completed (Student-specific)
	
	
		Workday
		Information to be completed (Student-specific)
	



Sheet 3: Common Combinations

	
	
	
	
	
	
	
	
	
	
	
	
	
	
		This tab includes two sections: A) Debit/Credit summary, and, B) Common Combinations of legacy chartfields converted to Workday worktags
		
	
		

		
	
		A) Debit/Credit Summary - provides a summary of how to increase or decrease ledger accounts
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Balance Sheet
		Income Statement
		

		

		

		

		

		

		

		

		

		

		

	
	
		Account Range
		(1xxx)
Assets
		(2xxxx)
Liabilities
		(3xxxx)
Equity or Fund Balance
		(4xxxx)
Revenues
		(5xxxx)
(6xxxx)
Expenses
		

		

		

		

		

		

		

		

		

		

		

	
	
		To INCREASE or Show a Positive Amount
		Debit
		Credit
		Credit
		Credit
		Debit
		

		

		

		

		

		

		

		

		

		

		

	
	
		To DECREASE or Show a Negative Amount
		Credit
		Debit
		Debit
		Debit
		Credit
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		B) Common Combinations - provides a template to document the translation of your most used legacy chartfield strings to Workday worktags.
		

		

		

		

		

		

	
	
		Use the Translation Tool to determine Workday values
		https://fintranslator.osu.edu/
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Translation Tool Job Aid
		https://admin.resources.osu.edu/workday/workday-for-core-users-finance/financial-translation-tool
		

		

		

		

		

		

		

		

	
	
		Account
		Org
		Fund
		Project
		Program
		User Defined
		

		Ledger
Account
		Spend/Revenue
Categories
		Cost Center
		Balancing Unit
		Fund
		Project
		Program
		Gift
		Grant
		Other Worktags
	
	
		61203
		29760
		13000
		29-A-MARSH
		10388
		

		

		62000
		

		CC10589
		BL1044
		FD100
		

		PG100125
		

		

		AS101073

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet table of contents tab name description content key concepts provides the changes between legacy chart accounts and workday fdm structure debitcredit summary amp common combinations a on how to increase or decrease ledger account types template document translation your most used chartfield strings worktags worktag reference listing each id format short additional functionality usage within funds list available associated definitions all company grouped by univ consolidated university managerial posting rules instructions read report that displays which categories drive fund transfer journal entries spendrevenue should be custom validations error message you will receive for built in system prevent invalid sources origin other resources training administrative resource center httpsadminresourcesosuedu crosswalk reports httpsadminresourcesosuedureportinganddatatoolsworkdayreportingavailablereportsandreportingcrosswalk tool httpsfintranslatorosuedu this information about accountsled...

Related files

Share

Help

Table of Contents
Tab name:	Description of Content:
Key Concepts	Provides the key changes between the legacy chart of accounts and the Workday FDM structure.
Debit/Credit Summary & Common Combinations	Debit/Credit Summary provides a summary on how to increase or decrease ledger account types. Common Combinations provides a template to document the translation of your most used legacy chartfield strings to Workday worktags.
FDM Worktag Reference	Provides a listing of each worktag, ID format, short description, additional functionality and usage within Workday.
Funds Reference	Provides a list of available Workday funds and associated definitions.
All Ledger Accounts	Provides a list of all Company Ledger Accounts, grouped by UNIV Consolidated Ledger Account Summary.
University Ledger Accounts	Provides a list of UNIV Ledger Accounts, grouped by the Managerial Ledger Account Summary.
Account Posting Rules	Provides instructions on how to read the report that displays which categories drive which ledger accounts.
Fund Transfer Journal Entries	Provides the list of Ledger Accounts and associated Spend/Revenue Categories that should be used on transfer journal entries.
Custom Validations Reference	Provides the error message you will receive for rules built in the system to prevent invalid worktag combinations.
Journal Sources Reference	Provides the origin of each journal.


Other Resources
Training Resources - Administrative Resource Center	https://admin.resources.osu.edu/
Crosswalk to Workday Reports	https://admin.resources.osu.edu/reporting-and-data-tools/workday-reporting/available-reports-and-reporting-crosswalk
Translation Tool	https://fintranslator.osu.edu

Key Concepts:	This tab provides information about the key changes between the legacy chart of accounts and the Workday FDM structure.

Key Concepts	System	Description
Accounts/Ledger Accounts and Categories	PeopleSoft	- Requires segment on all PS transaction lines - Detailed revenue and expense accounts to meet both management and external reporting needs
Accounts/Ledger Accounts and Categories	Workday	Ledger Account: - Required on all transaction lines but only selectable on journal entries - Revenue and expense ledger accounts at F/S line level of detail Revenue Category: - Used in combination with revenue ledger accounts to get management reporting level detail - Drives the ledger account that will be used on operational transactions Spend Category: - Used in combination with expense ledger accounts to get management reporting level detail - Drives the ledger account that will be used on operational transactions
Balance Sheets	PeopleSoft	Funds
Balance Sheets	Workday	Unique Combinations of: Company, Fund, Balancing Unit, Project, Gift, and Grant
Budgets/Plans	PeopleSoft	Two types of Budgets: - General Funds Spending Authority (allocations of unrestricted cash/equity) - Plan and Earnings Budgets (projections of revenues, expenses and transfers) - Two answers to the question ‘How Much Money Do I Have?’ General Funds = GFSA budget, less expenditures All Other Funds = Equity balance in the fund
Budgets/Plans	Workday	- Budgets (plan structures) in all fund groups are plans – not an allocation of funds. - For general funds, units will receive their annual funding as fund transfers. - Equity balances will carry forward at very granular level (unique combinations of balancing unit, fund, cost center, program, assignee and activities and events). - Clearer distinction between a unit’s annual allocation of general funds cash/equity and its spending plan for the year. - How much money do I have = equity balances in all fund groups
Business Units/Companies	PeopleSoft	University, OSURF (Sponsored Programs), OSUMC (Health System)
Business Units/Companies	Workday	The Ohio State University, OSU Health System, OSU Physicians, Inc., The Ohio State University Health Plan, Inc., Mount Carmel - OSUP Physician Alliance, LLC
Income Statements	PeopleSoft	Unique Combinations of: Organization, Fund, Project, and Program
Income Statements	Workday	Unique Combinations of: All FDM Worktags
Multi-Book Accounting	PeopleSoft	N/A
Multi-Book Accounting	Workday	Provides multi-book functionality to segregate certain types of accounting entries, including those related to asset capitalization and period-end adjustments to bring the financial statements to a full GAAP basis.
Orgs/Cost Centers	PeopleSoft	- Requires segment on all PS transaction lines - Workflow roles and routings based on organization
Orgs/Cost Centers	Workday	- Required on income statement lines only - Workflow roles and routings primarily based on Cost Center - Balance Sheet transactions will be routed based on initiators Cost Center
Owner Orgs/Balancing Units	PeopleSoft	- Behind the scenes attribute for each fund - Does not appear on transaction lines - Used for "61" reports, lift-out financials and segment reporting - Owner Orgs use same IDs as PS Orgs and use same org tree
Owner Orgs/Balancing Units	Workday	- Required on all transaction lines - Used for future balance sheet management reporting, lift-out financials and segment reporting - Balancing Unit IDs will have different IDs from Cost Centers and separate hierarchies
Smart Numbering/Hierarchies	PeopleSoft	Owner Org, Organization, Fund, and Account
Smart Numbering/Hierarchies	Workday	Fund and Ledger Account Hierarchies Used for: Cost Center and Balancing Unit
Trees/Hierarchies	PeopleSoft	Used to summarize information for reporting One or more trees exist for each segment of the chartfield (except user defined) Relatively limited visibility to end users Currently rely on a mix of PS trees, fund attributes (owner org) and account attributes (FS line) to meet external reporting requirements
	Workday	Used to summarize information for reporting and to define user roles/security One or more hierarchies will be built for most worktags Expected to be more visible and widely used (for example, as saved filter criteria in Workday reports) Primary hierarchies for external financial reporting will include those for the balancing unit, fund and ledger account
Supervisory Orgs	PeopleSoft	Reports To
Supervisory Orgs	Workday	Supervisory Organizations in Workday illustrate managerial reporting relationships, i.e. who reports to whom. Think org chart. All employees are hired into a Supervisory Organization which provides structure for employee management, business process routing, and represents Ohio State reporting structure. In addition, supervisory organizations will be used to route time entry and leave requests for approval. (View Supervisory Organization)
Academic Structure	PeopleSoft	Information to be completed (Student-specific)
Academic Structure	Workday	Information to be completed (Student-specific)

Related files

Share

Share to social media

Help

Login Area