Running Budget Reports: Tips and Tricks

Tags workday

Add USM Budget Reporting Dashboard to Your Apps

Click on the Menu button in the upper left-hand corner of Workday.

Menu Button Icon

Next, click on Add Apps.

Add Apps Button Icon

In the Add Apps menu, search USM Budget Reporting Dashboard and click the Plus Symbol.

Example of Add Apps menu window

 

Running Reports

When Running Reports:

Example of the Run Reports window

  • Everything with an * is a Required Field.
  • Under Company, enter "UBALT" or "UM28".
  • Under Organization, use a text search to find your Worktag Name. “USH28”, “GFH28”, or “CCH28” are the prefixes for summarized data at the hierarchy (tree) level.  The crosswalk is located here.
  • Under Plan Structure, use “All Institutions Child Plan Structure”.
  • Under Plan Name, select the plan name.
  • Under Period, select the period type.
    • Current and Prior Periods will pull the fiscal year to date as of the month you select.
    • Latest Closed Period shows closed months and will pull the fiscal year to date as of the month you select.
    • Fiscal Period shows the fiscal year to date as of the month you select.
  • Under Worktags, the results can be filtered further. For example, selecting only one Fund (FD) or picking only one NACUBO function (NF).

 

Tips and Tricks

  • Ctrl+A selects all of the items in the drop-down list.
  • If Book is a selection criteria, always use the “Common Book” unless you are in the Comptroller’s Office.
  • You can save the values that you selected as a Filter. Type a name in the box and save. The next time you come back, click “Saved Filters” and it will be pulled up.
    • Note that the Date Selection you picked will also be saved.
  • How the Filters work:
    • If you select more than one value in a box, the report will return everything where one of those values is true. For example, in the Organization drop-down, you pick FD4010 (state support fund) and NF0101 (Education during the regular term). The report will include FD4020 and NF0101 since NF0101 is true.
    • The Worktags filter is smarter than the Organization filter. It can differentaite between worktag types. If you enter FD4010, FD4020, and NF0101, the report will pull all NACUBO function NF0101 where the fund is either 4010 or 4020.
  • Budgets were loaded by Object. Reports also display data at these summarized levels. Budgets include the sum of budget amounts for all People Soft account codes by Object.
  • Anything in the report in blue text is Drillable, allowing you to see the detailed transactions that make up the value.
  • Money from the Foundation is loaded into Gifts worktags. To see the remaining budget for your gifts, you can run the same reports you run for your Usources.
  • Grants and Capital Projects use different budget to actuals reports.
  • RPT360 is similar to the PeopleSoft 1PAY queries.
  • RPT097 is similar to the PeopleSoft 1EXP queries.
Print Article