UR Financials Project

Company Level Reporting SIG March 18, 2014

Agenda

1.

Review meeting topics from the first three meetings (~ 15 mins)

– Housekeeping Items & Review – FDM Type Reports – Financial Statement Functionality – How to find Reports in Workday – Summary / Pivot-like Reports (examples – Trial Balance / Ledger Detail / FAO Activity) – Detailed / Spreadsheet-like Reports (more on this today)

2.

Summary / Pivot-Like Reports (~ 30 mins)

– FAO Activity – Free play !

3.

Detailed Transaction Reports (~ 30 mins)

– Transaction Details – Find Journal Lines – Free play !

4.

Journal Source and Large Detailed Transaction Reports (~ 15 mins)

UR Financials – Company Level Reporting SIG March 18, 2014 2

Non-Disclosure Statement

•

If you have not already signed a Non-Disclosure Statement for other SIG groups, please sign the Non Disclosure Statement before you leave !

3 UR Financials – Company Level Reporting SIG March 18, 2014

Updated Meeting Schedule

Feb

2

Informal Training Mar

3 WD 22

Apr

TBD

Reviewing Reports May June



Formal Training

• • •

March: Tuesday March 4: 3 Tuesday, March 18: 3 Friday, March 21: 2

–

– 5 pm in Saunders Room 1301 – 5 pm in Saunders Room 1301 – 5 pm in Genesee Room at Scottsville Road (limited space) WebEx and “Open House” format. Limited Demos, but will answer questions and demo based on questions.

• •

April & May: TBD as of now, but will develop a plan by next week. First April meeting will most likely not occur until mid-April.

Need to confirm calendar with testing and other project deliverables.

UR Financials – Company Level Reporting SIG March 18, 2014 4

Questions after meeting

Please send !

• • Please feel free to send questions after the meeting.

We will try and incorporate them into the next meeting or in future meetings (once we get to that topic) •

No questions – but requested topic related to 4 th with Integrations.

topic of Agenda – reports that help

– –

Journal Source Activity Large Detailed Transaction Reports

•

As a reminder , please send questions – especially for this Friday.

5 UR Financials – Company Level Reporting SIG March 18, 2014

Review: Overview of Key Features And Workday Report Types

1. Key Features

– Saving your prompt answers (Workday calls this “Saving your Filters”) • This feature allows you to save and recall your prompts very quickly.

• Most reports, but not all reports have this feature • One report can answer many questions (recall: View By’s and Drilling) – Required prompts – almost every report has the following prompts • Company • Year • Ledger Accounts / Ledger Account Summary

2. Overview of Report Types Financial Statement Functionality

 Formatted, drillable, many answers, fast reports based on financial definitions

Summary / Pivot-Like Reports Detailed / Spreadsheet-like Report

 Less-formatted, drillable, many answers, flexible reports  Unformatted, detailed, flexible reports UR Financials – Company Level Reporting SIG March 18, 2014 6

Review: Early training - FDM Type Reports

1. Ledger Account Lookup Reports

– View Ledger Accounts Hierarchy Outlined – View Ledger Accounts Hierarchy – View Ledger Account Summary

2. Spend Category / Revenue Lookup Reports

– View Spend Categories Outlined (separate version for Rev) – View Spend Categories (separate version for Rev) – View Trackable Spend Categories

3. FAO Lookup Reports

– View FAO by Company (5 Custom Orgs) – View FAO by Company (Grant Only) – View FAO by Custom Org Attributes (5 Custom Orgs) – View FAO by Grant Attributes (Grant Only) UR Financials – Company Level Reporting SIG March 18, 2014 7

Review: Financial Statement Functionality

Four Sections

:  (1) Report Definition & Display Bys – 2/18 all but Worktag Filter – 2/25 Worktag Filter  (2) Report Content & Time Periods – 2/18  (3) Comparative Content & Time Periods – 2/25  (4) Report Options – 2/18 UR Financials – Company Level Reporting SIG March 18, 2014 1 2 4 3 8

Review: Financial Statement Functionality Recap

Financial Statement Functionality

: • This reporting function generates formatted, printable, and drillable financial statement “type” reports. Runs fast and is flexible. • The function produces reports based on Workday Ledger Accounts and pre-defined “Financial Statement Definitions”. • The content of the report depends on the options selected at run time. • One “report” can answer many questions • You’ve seen almost all of it, but there’s still some more to see in future meetings • This functionality will be used to create the top line Financial Statements, the Monthly Ledger Report (this will be showed in future meetings), and some Ledger reports.

UR Financials – Company Level Reporting SIG March 18, 2014 9

Review: How to find Reports in Workday

Worklets

• • Various Worklets Favorites • Helps find “Delivered” reports by Reporting Category

Sitemap Run a report

• • Run “View Custom Reports I Can Run” Note: only includes “custom reports” • Search for it

Search Outside WD

• Use the excel that we sent out on 2/3 UR Financials – Company Level Reporting SIG March 18, 2014 10

Review: Summary of the Reports so far

• Why were these showed first? – FDM Reports – show you how to find FDM elements that you need for basically every report in Workday – Financial Statement Functionality – shows the power of formatted definitions, flexibility in prompting, and powerful drilling capabilities.

– Trail Balance and Ledger Detail – shows how Workday views Ledger Account details and provided additional practice with prompting.

• And Overall: – These really help with practice and learning “the cadence” of Workday.

– Practice with prompting, drilling, “viewing by”, and Saving Filters.

– You can answer many questions using one report.

– Helps to review reports in a “broader approach”.

– And, keeps you on the screen in Workday (which will be incorporated into the Broader Approach and the Decision Tree) UR Financials – Company Level Reporting SIG March 18, 2014 11

Agenda

1.

Review meeting topics from the first three meetings (~ 15 mins)

– Housekeeping Items & Review – FDM Type Reports – Financial Statement Functionality – How to find Reports in Workday – Summary / Pivot-like Reports (examples – Trial Balance / Ledger Detail / FAO Activity) – Detailed / Spreadsheet-like Reports (more on this today)

2.

Summary / Pivot-Like Reports (~ 30 mins)

– FAO Activity – Free play !

3.

Detailed Transaction Reports (~ 30 mins)

– Transaction Details – Find Journal Lines – Free play !

4.

Journal Source and Large Detailed Transaction Reports (~ 15 mins)

UR Financials – Company Level Reporting SIG March 18, 2014 12

Early training – FAO Activity Reports

See Excel file on UR Financials site (and in email) 1. FAO Activity Reports • Use this report to view activity by FAO’s by Ledger Accounts, Spend or Revenue Category, and by months. • Note: New prompt of “Book” • Note: There are few different versions of this report.

• Drill and use “View Bys”

Tip

• Search on the word “Activity” to view similar reports UR Financials – Company Level Reporting SIG March 18, 2014 13

Early training – FAO Activity Reports

View Bys Drill

• Remember to use “View By’s” • Remember to Drill !

• Drilling into the Totals will actually bring up the “Detailed Transaction Report” that will be Demo’d next.

• Remember you can then export the Details to Excel.

UR Financials – Company Level Reporting SIG March 18, 2014 14

Free Play

•

Please run the FAO Activity Report. Keep in mind the amount of data – recommendation is to filter by a month.

–

Performance is being actively addressed by Workday and Project Team.

•

More detailed reports next.

15 UR Financials – Company Level Reporting SIG March 18, 2014

Early training – Find Journals – with Saved Filter

See Excel file on UR Financials site (and in email) 1. Find Journals – with Saved Filters • Use this report to view the details of a Journal. • Note: Use a Journal Number from the previous example.

• Note: There are few different versions of this report.

• Example: 3-18 Find Journal UR Financials – Company Level Reporting SIG March 18, 2014 16

Early training – Journal Transaction Details (o Small Version)

NOTE: This report will be different at Go-Live. The purpose of the demo is to highlight the differences between a Journal Report and a Journal Lines Report See Excel file on UR Financials site (and in email) 1. Journal Transaction Details (o Small Version) • Use this report to view the detail lines of a Journal. • Note: Use a Journal Number from the previous example.

• Note: There are few different versions of this report.

• Example: 3-18 Journal Transactions 17 UR Financials – Company Level Reporting SIG March 18, 2014

Early training – Transaction Details by Month

See Excel file on UR Financials site (and in email) 1. Transaction Details by Months [Retest Version of Journal Transaction Details (o Small Version)] • Use this report to review details of a journal.

Tip

• To find Journal Transaction Detail Reports – search on “Transaction” or “Details” or “Journal” UR Financials – Company Level Reporting SIG March 18, 2014 18

Free Play

•

Tie the transactions together –

–

View the details from the “FAO Activity Summary by Months”

–

Find an OP by using the “View Bys”

–

Find a Journal Number by drilling into the data

–

Enter the Journal Number in the “Find Journals – with Saved Filters”

–

Enter the Journal Number in the “Journal Transactions Details (o Small Version)

UR Financials – Company Level Reporting SIG March 18, 2014 19

Agenda

1.

Review meeting topics from the first three meetings (~ 15 mins)

– Housekeeping Items & Review – FDM Type Reports – Financial Statement Functionality – How to find Reports in Workday – Summary / Pivot-like Reports (examples – Trial Balance / Ledger Detail / FAO Activity) – Detailed / Spreadsheet-like Reports (more on this today)

2.

Summary / Pivot-Like Reports (~ 30 mins)

– FAO Activity – Free play !

3.

Detailed Transaction Reports (~ 30 mins)

– Transaction Details – Find Journal Lines – Free play !

4.

Journal Source and Large Detailed Transaction Reports (~ 20 mins)

UR Financials – Company Level Reporting SIG March 18, 2014 20

Early training – More detailed Transaction Reports

These reports can be used when reviewing Integration feeds (or the Transaction reports reviewed earlier) Note: There is not a direct replacement of the FBD010 or “Daily Diagnostic Report” The replacement can be achieved in two ways: 1) Run a Transaction Detail report and then extract and Pivot in Excel.

2) Run a Summary Report and then drill into the transactions.

Recommended Reports are the following:

1.

** Journal Transaction Details (ooo Large Version)  [Note: this will be renamed shortly and an announcement will be made to the users] 2.

** Count of Journal Lines by Created Date and Journal Sources  [Note: this will be renamed shortly and an announcement will be made to the users] 3.

Journal Source Activity by Months 4.

Ledger Account and Journal Source Activity by Months 5.

Find Journals – with Saved Filters UR Financials – Company Level Reporting SIG March 18, 2014 21

Next Meeting Friday 3/21, 2 – 5 pm Webex

•

Friday, March 21: 2 – 5 pm in Genesee Room at Scottsville Road (limited space)

–

WebEx and “Open House” format. Limited Demos, but will answer questions and demo based on questions.

–

Please send or bring questions

•

In April / May, we will discuss the following;

–

Additional Activity Reports

– –

Broader Approach to finding reports Budget to Actual reports

– – –

Scheduling reports Supplier Invoice reporting Non-Company Level reporting – including the Monthly Ledger approach for Go-Live.

UR Financials – Company Level Reporting SIG March 18, 2014 22