F&A Helpful Reports

Here is a list of helpful Finance and Operation reports that may not be recognized as frequently used reports. These reports may require permissions to view them. Please consult with your supervisor to request access.

Category Accounts Receivable Budgeting and Planning Business Assets Business Process Clinical / YNHH COA Directory Financial Analysis Gifts HR Payroll Procurement Sponsored	Report Name	Source Workday YBT Pinnacle (hyperlink) Power BI/Finance Data Mart	Description
Accounts Receivable	Non-Sponsored Billing Details - Yale	Workday	Provides a list of all non-sponsored customer invoices and their status based on parameters selected.
Budgeting and Planning	YBT 02-University Reports / F15 Account Balances Detail	YBT	Provides fund balance activity and deficit balance details at a detailed worktag level for any time period
Business Assets	Find Assets by Cost Center – Yale	Workday	Provides a list of Assets filtered by various COA segments and secured by Cost Center access.
Business Process	Business Process Transactions Awaiting Action By Role – Yale	Workday	This report enables users to access all business process steps that are awaiting by role.
Business Process	Business process transactions completed-Yale	Workday	This report provides a list of all completed business processes based on the criteria selected, and provides the business process type, reason, date initiated and completed, who initiated and approved, and days it took to complete. It also includes information regarding any steps that may have been completed by a delegate.
Clinical / YNHH	YBT 04-YSM / YSM60 Clinical P&L	YBT	Provides a profit & loss statement with categories important to the clinical mission for any time period
COA	Ledger Accounts with Spend/Revenue Categories – Yale reports	Workday	Provides a list of Revenue and Spend Categories and thederived Ledger Accounts based on the Account PostingRules.
COA	Trend Analysis by Ledger Account – Yale	Workday	Provides a monthly trend of activity in the SOA format with ledger account level detail for twelve months based on selected parameters.
Directory	Lead Administrator and Operations Manager by Cost Center - Yale	Workday	This report lists the Lead Administrator, Operations Manager and Senior Director by Cost Center. Filter the report results by employee by clicking on the appropriate column heading. Notes: To see the details for Cost Center Hierarchy, please run the following report “Cost Center Hierarchy Details – Yale” and click into the individual Cost Center Hierarchy item, as applicable. To see a hierarchy view of Cost Centers, please run the following report: “Cost Center in Hierarchy View - Yale”.
Financial Analysis	ITS Charges on Pinnacle	Pinnacle (hyperlink)	Detailed report of ITS charges based on entered criteria
Financial Analysis	Detailed Transactions Trend	Power BI/Finance Data Mart	This monthly trend report provides quick access to transaction details of interest defaulted at the Ledger Account Summary with the ability to drill through to the transaction level. (from Power BI / Finance Data Mart: Finance > Interactive Reports)
Gifts	Gift Contributions - Yale	Workday	Provides a list of contributions and journal activity for the selected gift.
HR	Academic QA – Expired Current Appointments – Yale	Workday	This report lists those Academic Appointees having a current appointment with an Appointment End Date in the past. Includes all Academic Affiliates and Academic Appointees (even if inactive)
HR	Contingent Workers with Expiring Contracts – Yale	Workday	Displays information on contingent workers whose contracts are expiring before a selected date, including contingent worker name, position, latest contract end date, manager, supervisory organization, home organization, …
Payroll	YBT 02 University -> L60 Labor Commitments vs YBT	YBT	Model for labor allocations by cost center
Payroll	IBS	Workday	To view IBS in Workday – go under Actions for this person in WD, then go to Compensation, then go to View Compensation Basis Details. Click OK then scroll to bottom where it will show the IBS clearly.
Procurement	Expense Item Trend – Yale	Workday	Provides expense item trend by calendar quarter based on accounting date of the expense line.
Procurement	Non PO Invoice Activity – Yale	Workday	This report assists with the monitoring of non-PO invoice activity and recommending best practice for initiating purchases based on the spend category used.
Sponsored	Effort Certification Statement Review by Worktag – Yale	Workday	Provides a list any effort reports with suspense and thereport status (combination notification and report) brokendown by Effort Certification Period and cost Center.
Sponsored	Sponsored Budget to Actuals with Commitments – Yale	Workday	Provides budget, actuals, commitments, obligations and a calculated balance for the awards selected. Provides cost sharing if applicable. Allows drilling from award to individual grant.

View full list of Helpful ReportsSo many helpful reports for payroll, financial analysis, gifts, budgets, and business processes. You'll look like a genius in no time!