To ensure clarity throughout the data onboarding process, let’s walk through exporting data from Workday.
Note: Some Workday clients may have different system functionalities. If these instructions do not apply to your system, Senior Data Advisors can collaborate with users to identify an alternative report that meets their needs.
G/L Account List (List of All Accounts with Descriptions)
Most organizations using Workday have a variety of custom reports, and a custom report may be necessary to display budget and actual data at the desired level of detail.
Typical reports that work for the upload include:
- Budget to Actuals – Detail by Cost Center or Project (Composite)
- ACFR Trial Balance
- Ledger Detail, or Ledger Summary.
If you do not have access to these reports or if they do not include the information listed below, please work with your Workday team to create a report that includes the following:
- Columns for all relevant ledger dimensions (Worktags), such as Fund, Cost Center, Business Unit, Reference ID, Project, Grant, and any other applicable fields
- The description associated with each account and worktag.
- The corresponding budget and actual amounts for each line item
- Data for the years you would like uploaded into the system (we typically recommend starting with four years of budget and actuals)
Provide the report in Excel or CSV format to the data team.
Have more questions or need assistance?
Submit a Request