[email protected]

Workday@Yale

Change Network Reporting Sessions: Procurement & Expenses Demos Fin. Mgmt. & Fin. Acct. Demos [email protected] Course Objectives Welcome to the procure-to-pay/expense management and the financial management/financial accounting reporting information session. This session provides foundational knowledge of Workday reporting and an opportunity for you to preview many reports. After completing this session, you will be able to: Identify where to locate support materials for Workday reporting Explain the benefits of transitioning to Workday for reporting needs Describe the difference between current and future state reporting functionality Recall the steps to run and manipulate data in a Workday report 2 Workday Reporting

Overview [email protected] 3 One-Stop-Shop for Reporting Support The [email protected] Training website has a specific home for all things reporting. Whether looking for training, videos, and job aids, you can find it all at www.workday.training.yale.edu. Transition to a New Chart of Accounts Understanding Yales Workday Chart of Accounts is critical in order to record transactions correctly and to be able to interpret financial information in reports Company Funding (must select one) Grant (will default other segments) Gift (will default Fund) Yale Designated (will default Fund) Cost Center (will default Project)

Program Project Assignee (may be required by your unit) Spend Category or Revenue Category Ledger Account (required for Journal Entries Only) 5 What Data Can I See? Your Supervisory Org and assigned Cost Center(s) impact what you can see 1. Supervisory Orgs group employees into management hierarchy 2. Cost Center (formerly known as Org Unit) Identifies financial responsibility and management for officially acknowledged business units (e.g., departments, sections, etc.) Cost Center is used for both local and University-level management reporting 6 Roles Required to Run a Report A user must have one or more of the following three Workday roles with access to run reports in Workday. Only business offices can request roles, not managers. Cost Center Financial Analyst Includes access to all financial and procurementrelated reports, including the portfolio report (i.e., the new version of the

account holder report) and P&L reports. Cost Center Payroll Details Able to see payroll details instead of a summarized journal line. Role granted separately from Cost Center Financial Analyst. Cost Center P2P Inquiry Access to reports only related to procurement, expenses and suppliers. Does not provide access to any financial-related reports. 7 Translating from the BRIO Way to the Workday Way A robust How to Find the Report you Need job aid will be shared later in June with a crosswalk mapping from BRIO reports to Workday reports. It provides descriptions and mappings of each Workday report broken into business area categories: Functional Areas, Most Frequently Used, Foundational, and Monthly Financial Review reports. 8 Replacements for the Most Frequently Run DWH Reports The most frequently run reports prior to Workday Financials have been replaced. Reports do not have one-to-one mappings but enable greater analysis capabilities DWH Legacy Report Name

% of use Workday Report FINAH2 Account Holder by PTAO 40% TBD: Portfolio Reports FINAH1 Account Holder by Person 22% TBD: Portfolio Reports FINEM1 Expense Management Reports 7% Unexpensed Credit Card Transactions - Yale FINRT1 Review Tool 6% 'Find Cash Advances - Yale FINFB4 Fund Balance Activity Report

5% Account Balances Detail Yale; Account Balances Summary Yale; Grant Balance - Yale Total DWH Portal Top 5 Reports 80% 9 Replacements for the Most Frequently Run BUG Reports The most frequently run reports prior to Workday Financials have been replaced. Reports do not have one-to-one mappings but enable greater analysis capabilities. BUG Legacy Report Name % of use Workday Report BUG307a Sortable Detail Transactions 26% Detailed Transactions - Yale BUG300a Transactions by Category 15%

Detailed Transactions - Yale or Financial Transactions Yale (for less detail) BUG308a Transaction Detail by Month 11% Transactions Summary by Month Yale BUG214a Sponsored Award Cash Report 8% Sponsored Cash vs Expenses Yale BUG203a GC Financial Status Report 8% Sponsored Funding vs Expenses Yale BUG203a GC Financial Status Report Custom GCFA 7% Sponsored Funding vs Expenses - Yale

BUG101a Labor Distribution by Employee 6% Payroll Costing By Employee Yale BUG403a Calculated Source Balances 6% BUG310a Commitments 2% Account Balances Detail Yale; Account Balances Summary - Yale Portfolio Report - Commitments Yale; Financial Transactions - Yale BUG203a GC Financial Status Report 2% Sponsored Funding vs Expenses - Yale Total BUG Library Top 10 Reports 91%

10 Reporting Prior to Workday Financials Data is not real-time; its updated on a nightly basis Users log onto Oracle to make changes and then wait overnight for the DWH update before re-running the report Reports can be scheduled (for self or for others) or be run on demand; Workday deletes scheduled reports after 5 days unless otherwise designated Reports are distributed via email directly from the DWH scheduler or from one user to another Report Data Report Distribution Report Format & Design

Standard reports are either pixel perfect PDFs, or downloadable Brio/Excel format Reports have different fields names, column sequences, layouts, etc. Workdays financial reporting and analysis capabilities enable more efficient information management. With the new Chart of Accounts and enhanced reporting capabilities, Workday enables more timely, consistent, and accurate reporting. 11 Workday Reporting Features Workday Reporting brings new features and benefits that address many of the gaps in the current state, but also provides additional controls on data access that will feel different. Real-Time Information All financial data is in Workday and approved transactions are available for reporting immediately Customizable Report Output Drillable Actionable

transactions Real-Time on Informati An Ca alyti pa ca bil l itie s Customizable Report Output Users are able to sort and filter data, remove columns, and download information to Excel Drillable Users can drill down from summary to detail without needing to generate a different report to get that detail Actionable Transactions Users can create new transactions directly from a report (such as creating a new transaction, or moving the old one), provided that they have the required role Analytical Capabilities Reduce need to export data with Workday 12

sorting, filtering, and pivoting What Behaviors Will Set People up for Reporting Success? With the implementation of Workday Financials, individuals who run reports will be able to complete work more easily by thinking of reports differently. Instead of using BRIO reports, users with reporting roles will want to: Create and apply saved filters to reports View information in reports at a summary level, then drill down for details when needed without having to generate another report Reports delivered to the W-Drive are in Excel or PDF and are not Workday actionable reports Take appropriate real-time action from a report, such as editing or approving an expense report Use the sorting, filtering, pivoting, and

show/hide columns in Workday to display desired data; review content directly in Workday instead of exporting reports. Understand Yales Workday Chart of Accounts to record transactions correctly and interpret financial information in reports Know that credits and debits may be shown as positive and/or negative numbers Understand that Workday secures data by Cost Center BUG Report Library and Data Warehouse Portal will continue to be available for historical transactional details. Only balances will convert to Workday from the fiscal years 2014 2017

Note that Workday limits the amount of data that can be exported 10,000 lines for PDFs 500,000 for Excel 1,000,000 for CSV files 13 Demonstration [email protected] 14 P2P and Expense Management Report Demos Report Description EMS View Unapproved Expense Identifies Expense Reports that Reports-Yale are not fully approved that require attention. Provides a list of Expense Reports matching the specified

Find Expense Reports by Cost parameters. Allows check of Center - Yale Expense Report statuses to inform related actions depending on the status of the report. Provides a list of requisitions to users to track the progress Find Requisitions by Cost Center allow of requisitions that they either - Yale prepared, requested or edited in-progress. Provides a list of both spend Find Spend Authorizations/Cash authorization and cash advance Advances - Yale details as well as the associated expense report. Legacy Report Name FINEM1 Expense Management Reports FINEM1 Expense Management Reports, FINRT2 EMS Monitoring Report Procurement Inquiry (Oracle

process, not a report) n/a - no current state Note: The reports demonstrated here may change with future updates. 15 P2P and Expense Management Report Demos Report Description Legacy Report Name a list of Supplier Find Supplier Requests Initiated Provides Requests that have been by Cost Center Yale submitted by a Unit. n/a - no current state Allows Units to look up Suppliers Procurement Inquiry (Oracle Find Suppliers by Cost Center - and determine if Suppliers have process, not a report) Yale completed background check. Supplier Invoices in Match Exception - Yale

Access Review Role Assignments Yale Provides a list of all invoices in Match Exception including those needing receiving or those overmatched to a PO. Provides a list of employees with their granted roles. This will be used on both a monthly and annual basis by Business Operations SBP/BP as well as centrally. Invoice Worklist PORTAL43 FINRT4 Access Review Report, BUG112a User Access Profile Report, BUG112b User Access Worksheet Report Note: The reports demonstrated here may change with future updates. 16 P2P and Expense Management Report Demos Report Description

Legacy Report Name Unexpensed Credit Card Transactions - Yale Provides a list of new P Card transactions that require attention. FINEM1 Expense Management Reports My Cash Advances My Expense Reports My Expense Transactions My Receipts My Spend Authorizations Note: The reports demonstrated here may change with future updates. 17 Financial Management Report Demos Report Description Provides a list of financial transactions based on selected

Financial Transactions Yale parameters. This report is optimized to be used in Workday. Provides a list of cash sale Find Cash Sales by Cost Center transactions with COA details to Yale allow Units to monitor their own cash sale activity. Provides a list of journal line Find Journals by Cost Center details for the Cost Center Yale selected. Provides a list of gifts with Gift Account Balances - Yale beginning balance, revenue, expense and ending balance. Legacy Report Name BUG308a Transaction Detail by Month FIN273 Departmental Deposit Report n/a - no current state BUG403a Calculated Source Balances Note: The reports demonstrated here may change with future updates.

18 Financial Management Report Demos Report Description Verifies payroll a few days before goes to the bank for those Payroll Results Verification with it people in the supervisory Costing Yale orgs/home cost center that you support Provides end user with the ability to view fund balance Portfolio Account Summary activity and deficit balance Fund Balance View Yale details. This report includes worktags that should not carry deficit balances. Provides a detailed list of journal Fund Transfer Review Yale lines classified as fund transfers. Statement of Activities Report comparing budget SOA YTD Variances by Plan

variances(Corporation Budget Structure - Yale and Actuals for last closed month and YTD including dollar variances). Legacy Report Name BUG403a Calculated Source Balances (PTAEO) PORTAL Activity Review Report PORTAL44 FINPP1 Position Plan, By Total Budget or Fund Balance Only, AUD-02 Statement of Activities Note: The reports demonstrated here may change with future updates. 19 Financial Management Report Demos Report Payroll Costing Allocation Preview Yale Access Review Role Assignments Yale Find Posted Journals by Cost

Center - Yale Description Provides a preview of the payroll costing for workers for the upcoming monthly or weekly payroll cycle Provides a list of employees with their granted roles. This will be used on both a monthly and annual basis by Business Operations SBP/BP as well as centrally. Provides a list of journals for the Cost Center selected. Legacy Report Name Portal20 HR2 Monthly Payroll Preview Report, Portal26 HR8 Weekly Payroll Preview Report* PORTAL43 FINRT4 Access Review Report, BUG112a User Access Profile Report, BUG112b User Access Worksheet Report n/a - no current state Note: The reports demonstrated here may change with future updates.

20 DEMO 21 Wrap-Up [email protected] Additional Support Quick Guide (QG) Training Guide Auditorium Session Instructor-Led Training (ILT) Web Simulation Post Go-Live Clinic Session

Web-Based Training Also, dont forget about your local Workday Gurus who can help with any questions or coaching! 23 Any Final Questions? ? 24

Recently Viewed Presentations

  • Increasing your happiness The essentials from SASSPA 2019

    Increasing your happiness The essentials from SASSPA 2019

    According to Hebb's Law, "neurons that wire together, fire together," so focusing on breaking the old habit may actually strengthen it. Focusing on creating a new habit forms new neural networks in the brain and gives you the best chance...
  • The Road Not Taken Robert Frost - Reyeseng

    The Road Not Taken Robert Frost - Reyeseng

    "The Road Not Taken" By Robert Frost Publication Information From the collection of Mountain Interval, a collection of poetry written exclusively by Robert Frost Published in 1916, by Harcourt Brace Custom Books The poem shows the importance of decision-making It...
  • Click on each picture in order to read

    Click on each picture in order to read

    In winter, an Arctic fox's fur turns white to blend in with the snow. Arctic foxes CAMOUFLAGE. Keep Going In winter, an Arctic wolf's fur turns white to blend in with the snow. Arctic wolves CAMOUFLAGE. Keep Going In winter,...
  • Thermal Analysis Sightseller V3.00 - 2006

    Thermal Analysis Sightseller V3.00 - 2006

    Materials Support Service Software options Software F&B Software packages CFR Evaluation window Experiment window Method window Routine window Module window Install window FlexCal Report LIMS Main menu bar Network Languages Software windows DSC basics DSC results DSC F&B DSC sensors...
  • The Subsidy for Adopting Conservation Tillage: Estimation from

    The Subsidy for Adopting Conservation Tillage: Estimation from

    The Subsidy for Adopting Conservation Tillage: Estimation from Observed Behavior Lyubov Kurkalova, Catherine Kling, and Jinhua Zhao CARD, Department of Economics Iowa State University Paper presented at the AAEA Annual Meeting, Chicago, IL, August 2001 Introduction and Objectives What does...
  • Part II: Preparation/Process - Suffolk County Community College

    Part II: Preparation/Process - Suffolk County Community College

    How does the changing meaning of words affect a public relations professional's ability to interpret messages to key publics? Figure 3-3 (Photo : Snapper Media/Splash News/
  • Smart Phones, Dumb LawyersLegal Ethics of Social Media and ...

    Smart Phones, Dumb LawyersLegal Ethics of Social Media and ...

    SCR 20:1.18 Duties to prospective clients: Duty of confidentiality not to use or reveal information learned in the consultation. Duty not to represent someone with interests materially adverse to the PC without PC's informed consent and screening, if the PC...
  • Advance Care Planning: Learning Opportunities for Primary Care

    Advance Care Planning: Learning Opportunities for Primary Care

    Medicare Part B ACP Reimbursement—Jan 1, 2016. The News. Advance care planning for patients. Medicare reimbursements for eligible practitioners. What does that mean? Codes 99497 and 99498 are now . ACTIVE. on the 2016 fee schedule. Eligible practitioners are physicians,...