The purpose of this procedure is to provide navigation information for the Grants Balance Report (AFBR | My Funds) in WorkDay. It outlines how to view My Funds, expense details, and salary details.
Please note these reports are still in progress while we figure out how to get to details with one click rather than multiple clicks within the system. The WorkDay report writing team is grateful for your patience in advance.
Let’s dig in!
View My Funds
- Go to your left-hand Menu and click on the Financials Dashboard
- One report will be available for you at this time - Grants Balance Report (AFBR | My Funds)
Up and coming reports include:
- Operating: general fund operating
- Projects - Cash basis:
- Non-Cash Projects
- Phase 2 - Enhancements to launched reports
- Click on the link “RPT028_1 - Grants Balance Report (AFBR | My Funds)”
Below is an explanation of each Prompt and Report.
My Grant Funds: This is the Balance Report for Grants and Awards which includes all Awards and corresponding Worktags. The report identifies Budget to Actuals. If an expense has not occured on a Grant worktag, no data will populate.
The prompt page consists of 6 ways to run the report. You can search for multiple items under awards, worktags, cost centers as well as Principal Investigator. Required prompts are Period and Time period. Defaults are set to show all activity from start date to current date.
|
Prompt
|
Description
|
Selections
|
Default
|
|
Grant Worktag or Individual Award
|
Input a Grant Worktag to view all awards for a specific project, input an individual award (Such as participant support or cost share) to see the one award item.
|
Various and can select more than one
|
None
|
|
Period
|
The period is the starting point when the report is run.
|
Can select by Current and Prior Periods, Last Closed Period and a multitude of selections for Fiscal Period. Only one period is allowed to be selected
|
Current Month
|
|
Time Period*
|
This is the time frame you would like to report to run for.
|
Best selections are Award life to Date or Inception to date if the project is an "At-Risk"
|
Inception to Date (Fiscal Year)
|
|
Worktags
|
Additional prompt to filter by Cost Center, Function, Fund and/or Grant.
|
Various and can select more than one. Typically for Grants you can search Fund 12 or Function 1200.
|
None
|
|
Cost Center
|
Additional prompt to filter by Cost Center
|
Various and you can select more than one
|
None
|
|
Principal Investigator
|
Additional prompt to filter by the Lead Principal Investigator of the Grant
|
Various and you can select more than one
|
None
|
|
Time Period Selections are:
|
|
Fiscal Time Period
|
Budget to Date
|
This is not working properly for FY24
|
|
Current Period
|
Current Month
|
|
Current Period YTD
|
Current Monty Year to Date
|
|
Current Year
|
Current Fiscal Year
|
|
Inception to Date (Fiscal Year)
|
All Periods prior to the period selected
|
|
Last 12 periods
|
Last 12 Months
|
|
Last 36 periods
|
Last 3 Years
|
|
Last 4 periods
|
Last 4 months
|
|
Last 6 periods
|
Last 6 periods
|
|
Last year - Current Period
|
Last years current month (i.e. If it is 12/2023, this would give you the month of 12/2022)
|
|
Last year - Current Period YTD
|
Last Year current Month Year to Date (i.e. if it is 12/2023, this would give you 07/2022 - 12/2022)
|
|
Next 12 Periods
|
This is for forecasting
|
|
Next Year - Current Period
|
This is for forecasting
|
|
Period + 10
|
This is for forecasting
|
|
Period + 11
|
This is for forecasting
|
|
Period + 2
|
This is for forecasting
|
|
Period + 3
|
This is for forecasting
|
|
Period + 4
|
This is for forecasting
|
|
Period + 5
|
This is for forecasting
|
|
Period + 6
|
This is for forecasting
|
|
Period + 7
|
This is for forecasting
|
|
Period +8
|
This is for forecasting
|
|
Period + 9
|
This is for forecasting
|
|
Period +19
|
This is for forecasting
|
|
Prior Period YTD
|
Last month fiscal year to date
|
|
Project Life to Date (Fiscal Year)
|
This is used when you have a project that lasts multiple fiscal years.
|
|
Year from Current Period
|
This is for forecasting
|
|
Award Time Period
|
Award Life to Date
|
Award Schedule Start Date to current period
|
|
Award schedule for Grant (Based on Start and End Dates of the project)
|
This only comes up if you are searching for one grant, will auto populate Award Schedule Start and End Dates.
|
To view a list of awards by investigator (equivalent to AFBR-L1), enter name in Principal Investigator field
To view a high level summary of a specific award (equivalent of AFBR-L2), click the Expand arrow to the left of the Grant number (don’t click the blue grant number itself)
Click on the blue hyperlinks in the Budget, Commitments and Obligations, Actuals, or Available Balance columns to drill down to the details.
Please note, you have to dig further to get to your payroll results (details below). Easier drill down functionality will be released in a later version.
If you click on the hyperlink total for “Actuals,” a new window will open with just the detailed expenses. If you click on the total expenses at the top, the drill down will return all expenses (similar to AFBR-L4). If you click on an individual ledger accounts total, it will only return the detail for that ledger account (similar to AFBR -L3).
A sample drill down and field explanations are provided below:
