The purpose of this procedure is to provide navigation information for the Operating Account Balance Report (AFBR | My Funds) in Workday. It outlines how to view My Funds, expense details, and salary details. This report identifies your worktags that begin with “2”.
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 – Operating Account Balance Report (AFBR | My Funds)
Up and coming reports include:
- Projects – Cash basis:
- Non-Cash Projects
- Phase 2 – Enhancements to launched reports.
- Click on the link “RPT028_4 – Operating Account Balance Report (AFBR | My Funds)”
Below is an explanation of each Prompt and Report.
My Operating Account Funds: This is the Balance Report for corresponding Operating Account Worktags. This includes Funds 11 and 12. The report identifies Budget to Actuals. If an expense has not occurred on a Operating Account worktag, no data will populate.
The prompt page consists of 6 ways to run the report. You can search for multiple items under worktags, cost centers as well as Spend Category as Worktag. Required prompts are Period and Time period. Defaults are set to show all activity from Fiscal Year XX - July to current date.
|
Prompt
|
Description
|
Selections
|
Default
|
|
Budget Name
|
Input a FY Operating Budget Worktag to view all accounts for a specific fiscal year.
|
Current and Prior Fiscal Years
|
FY2024 Operating Budget
|
|
Time Period*
|
This is the time frame you would like to report to run for.
|
Best selections are Fiscal Year Current Period YTD. This selections provides the current fiscal year, July through the period in the next prompt.
|
Current Period YTD
|
|
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
|
|
Worktags
|
Filter by Operating Account, Operating Account Manager last name or cost center.
|
Various and can select more than one.
|
None
|
|
Cost Center
|
Additional prompt to filter by Cost Center
|
Various and you can select more than one
|
None
|
|
Spend category as a Worktag
|
Additional prompt to filter down to a specific spend category in conjunction with the worktag indicated above.
|
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 – Do Not use for Operating Account data
|
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.
|
*Period and Time period examples:
Current Period Year to Date:
Prior Month:
OR
To view a high-level summary of a specific operating accounts (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.
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 details for that ledger account (similar to AFBR -L3).
A sample drill down and field explanations are provided below:
|
Column Name
|
Description
|
|
Operating Account Number
|
The operating account worktag
|
|
Title
|
The title or name of the operating account worktag
|
|
Employee as a Worktag
|
The employee who was paid on the Journal Line or Operational Summary; this is only populated on WorkDay transactions. Legacy Data does not have this indicated.
|
|
Journal
|
The Workday Accounting entry details. Includes debits and credits
|
|
Operational Transaction
|
This is the Workday source document for the transaction. If the expense came in from a travel authorization, supplier invoice, or other journal source, this field would lead you back to the source.
|
|
Memo
|
Legacy data will be identified in Workday with this field by the use of the letters “LTD.” Workday data will depend on what is put in the expense report
|
|
Line Memo
|
Legacy data will populate with this field with the Banner description, including the Banner document number and/or Chrome River report number. Workday data will depend on what is put in the expense report.
|
|
Transaction Description
|
Legacy data will populate with this field with the Banner description, including the Banner document number and/or Chrome River report number. Workday data will depend on what is put in the expense report
|
|
Supplier (If provided)
|
If there is a Supplier associated with the expense (i.e., an invoice payment), it will display here
|
|
Ledger Account Number
|
Ledger Account Numeric Value
|
|
Ledger Account
|
Ledger Account Name
|
|
Spend Category Number
|
Spend Category Numeric Value
|
|
Spend Category
|
Spend category Name
|
|
Accounting Date
|
Date expense actually posted to the system. This date may be outside of period of performance
|
|
Budget Date
|
Date used to place expenses into award budget periods. For legacy data, this is where the Banner transaction date was uploaded.
|
|
Transaction Date
|
Date used to post expenses into a certain fiscal period.
|
|
Amount
|
Amount of transaction. Expenses show as a positive amount and refunds/credits show as a negative value.
|
|
Costing Worktags
|
Displays all worktags associated with the expense
|