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!
Click here for FY End Procedures
View My Funds
- Go to your left-hand Menu and click on the Financials Dashboard
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=20e69e7a-1d78-420a-98f8-f891b742ec67.png&beidInt=299)
- All four AFBR reports are live. For the purpose of this guide, the following project hierarchies are included in this report. You must indicate a grant/award worktag, cost center, fund and/or a principal investigator in the prompts. Running without these will cause the report not to expand due to data limitations.
- Click on the link “RPT028_1 - Grants Balance Report (AFBR | My Funds)”
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=7e2c5c90-9c21-416c-b5c5-fe986190ac8a.png&beidInt=299)
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 occurred 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.
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=21d48047-7cb4-4f90-8dbc-0a75603af467.png&beidInt=299)
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=e5689b0a-4780-46f3-a498-3085f4b3c588.png&beidInt=299)
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=4623eb73-189a-4e16-81f0-f4cc83c49215.png&beidInt=299)
*Period and Time Period Examples:
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=dc64a6d2-e127-4836-aa1f-48dc5a72c782.png&beidInt=299)
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 your payroll results (details below). Easier drill down functionality will be released in a later version.
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=4b06106a-eeab-496f-a0d5-6e6516008305.png&beidInt=299)
If you click on the hyperlink total for “Expenses,” 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 details for that ledger account (similar to AFBR - L3).
A sample drill down and field explanations are provided below:
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=94781f8a-6e2e-47a0-a8ba-587569a5ce64.png&beidInt=299)
During FY close, the prepopulated prompts will change. Just as we did with My Funds in Cognos and Trailhead, we will hard code these in to end 06/30 of that year. You can change the prompts to current year however, budget may not be loaded and ending balances may change slightly.
![](https://helpcenter.mines.edu/TDPortal/Images/Viewer?fileName=fc802f0e-52dd-4c3b-8868-90b0d13f5c76.png&beidInt=299)
Click here to go to the top of the procedure