Resources

The Job Aids and Demos folder on SharePoint has helpful information for Workday reports and tasks organized by topic.

Worktag reports:

• Extract fund
• Extract cost centers
• Extract custom organizations – auxiliary, financing source (still being tested) and function
• Extract projects
• Extract ledger accounts
• Extract revenue categories
• Extract spend categories
• Data validation – programs
• View Integration Worktag Mapping – shows mapping from Banner to Workday

Budget vs Actual reports:

• MSU – Budget vs. Actuals by Ledger Account – Revenue and Expense
• MSU – Budget vs. Actuals by Ledger Account – Expense Only
• MSU – Budget vs. Actuals Rollup – Auxiliary
• MSU – Budget vs. Actuals Rollup – Fund
• MSU – Budget vs. Actuals Rollup – Projects
• MSU – Budget vs. Actuals Rollup – Cost Center

Trial Balance – accounting report, ties to budget vs actual reports

Fund balance reports: (typically used for auxiliaries, projects, ICRs, Program Fees, Summer Revenue)

• MSU – Fund Balance Summary
• MSU – Fund Balance Summary with Cost Center

Transaction level reports:

• MSU Find Journal Lines – actuals
• MSU Find Plan Lines – overall budget loaded as initial and total current budget. May want to use filter options:

• • Filter for only total current budget
  • Exclude revenue
  • Exclude one-time budget
  • Filter by fund and/or other worktags

Other Helpful Reports

MSU – Payroll Distribution Detail – For Company, MSU All Workers Costing Allocation, Find Purchase Order, Find Supplier Contracts, MSU – Purchase Order Lines and Line Splits by Company, Ledger Account Hierarchy

Adaptive Insights is a system that is used by the Budget Office and campus for analysis and budget planning purposes. Every morning the system pulls current budget and actuals data from Workday to be available for analysis and reporting and for reference in identifying the budget for the coming fiscal year.

• Budget vs actual reports are available in Adaptive and mirror those in Workday, but with a slightly different look and feel. Please see the training video for further instruction on these reports. (The budget vs actual reports in Workday are better suited for drilling into numbers.)
• Personnel reports are also available to provide information by level (cost center) including position information, employee worktags, salary, FTE, and funding splits.

Office Connect is an Excel Add-In program that is available to Adaptive users to design their own reports with custom layouts. These reports can be refreshed on demand with current information as of that day. To request access to Office Connect, please submit a request permissions ticket by clicking that red box on the right-hand side of the ITS Enterprise Application Services webpage. Office connect training videos are available here.

Updates

August 20, 2024: FY25 Beginning Fund Balances

The Budget Office is in the process of compiling and loading beginning fund balance Rollfoward Budget for auxiliaries, ICRs, program fees, summer revenue, and capital projects. Until this budget entry is posted in the coming weeks, the MSU Trial Balance report can be run for the “Operating Book” to determine the actual beginning FY25 fund balance recorded in Workday.