Day In the Life of a Fiscal Administrator (Reporting FAQ)

Day In the Life of a Fiscal Administrator (Reporting FAQ)

Our Reporting User Group worked with the Reporting & Analytics Team to produce this Day in the Life FAQ on reporting.  This guide matches up 1-2 reports with the most frequent daily questions that fiscal administrators and business officers need to address.  Our goal is to provide you with a slimmed-down digest of go-to reports selected by your peers.

Last Updated February 13, 2023


How are we doing against our fiscal year budget? 

 

  • Budget vs Actual by Cost Center
  • Expense Budget vs Actual (Simple "BBA")
  • Sources and Uses Budget vs Actual with Balances
  • Fund Balance with FDM 
  • Workday Budget vs Actuals (UBI)
What is the status of supplier invoice or payment?  Did that vendor/invoice get paid and did they cash the check? Has the invoice been processed?

Find Supplier Invoice (shows status)

What is our current or projected fund balance? How can I tell faculty how much money they have? (non-grants) 
  • Fund Balance by Cost Center 
  • Fund Balance with FDM 
  • Fund Balance by Assignee  
  • Expendable Fund Balance Summary 
  • Workday Fund Balance (UBI) 
I need to see all Grants for PI's in our school/Department/Cost Center 
  • Find my Awards for Grant Managers and PI 
  • Award and Grant Details Composite 
  • OSP Award Summary Report  
  • Workday FDM Reference (UBI)
  • Workday RAD (UBI)
How much funding is left on my grant? How can I tell PIs their grant balance?
  • Grant Balance Available
  • Workday RAD (UBI)
Did we receive our gift funds? 
  • Revenue Detail Report 
  • General Ledger Details 
  • Workday Journal Lines (UBI) 
What are the costing allocations for our employees - who/what is funding them?  Who is at risk of hitting suspense? 
  • Payroll Costing by Organization 
  • Worker Costing Allocation Information – Payroll  Positions without Costing Allocations 
  • Payroll Journal Line Details 
  • Workday Payroll Costing (UBI)  
How much F&A did we earn this month (by PI)?
  • Workday Journal Lines (UBI) 
  • F&A Recovery by Company and Cost Rate Type 
What expenses hit my cost center? Who has hit our suspense account? 
  • Spend Detail Report  Details for Account Certification 
  • Payroll Journal Detail Report 
  • Payroll Journal Line Details 
  • Workday Journal Lines (UBI) 
How do I look up a transaction when someone shares that they booked charges to "my" worktag?  Who initiated it if I have a question about the charge? 
  • Spend Detail Report 
  • Details for Account Certification 
  • Find Journal Line 
What has been spent/obligated on start-up projects? 
  • Spend Detail Report 
  • Non-payroll Commitments and Obligations 
  • Fund Balance with FDM 
  • Workday Journal Lines (UBI) 
What are the POs associated with my Cost Center? 

Track Purchase Orders 

What expenses are waiting approval? What Credit Card transactions have not been expensed? 
  • Find Credit Card Transactions 
  • Credit Card Transactions – Not Expensed or Approved 
How much have we earned on Sales & Service activity? 
  • Revenue Detail Report 
  • General Ledger Details 
  • Workday Journal Lines (UBI) 
How do I find details on stipends, fellowships, scholarships? 
  • IS FA Award Activity 
  • SIS FA SAFM 
Who has which roles? What roles do I need to backfill if someone changes jobs? 

Cost Center Role Assignments - Security  Workday Security Roles (UBI) 

What Account Certs are waiting on me?  What Account Certs are headed my way but aren't ready for me yet?  Where are all the Acct Certs for my Cost Center(s)?  What are the items that are waiting on me to correct? 
  • Combo of Account Certification Actions & Status of Account Certification address these questions  
  • COMING SOON: Workday Account Cert Dashboard (UBI) 
How much ETF Funding do I have? 

Workday Journal Lines (UBI)