Workday Reporting

The following reports are now available in Workday:

  1. Sponsored Financial Reporting – Payroll Detail
  2. Sponsored Financial Report – Direct Cost Detail
  3. Award Expenditure Total Report

Even though these new reports were designed to assist AMT with sponsor financial reporting, they are accessible to the entire RA community. Below is a list of current reports available in Workday to view expenditure detail for grants (including payroll):

RA Department Grant Reporting – Payroll Detail. Provides payroll detail for grants.

Budget to Actuals – Grant. This report is used for summary and ledger details of budget/expenses/encumbrances for grants.

Quick Tips – Remember to drill down from the main page of the report to get summary by Ledger Account.

Detailed Revenue Expense and Ledger Accounts. Replacement for 611E/611R for all accounts (not just grants)

Quick Tips – Workday records expenses posted to grants as revenue. When using this report, make sure to check the Include Expenses Only box:

This report includes Spend Category information. Be aware that Workday records F&A to the direct cost Spend Category of the corresponding expense. For example, F&A for out-of-state travel will post to the Travel – Out-of-State Spend Category. When using this report, you can reference the Ledger Account to determine the type of expense.

Sponsored Financial Reporting – Payroll Detail Provides payroll detail backup documentation in a printable format for sponsors. Quick Tips Similar to Department Grant Reporting – Payroll Detail. Differences: this report includes the employee’s position number instead of Employee ID and this report includes the transaction number.

Sponsored Financial Report – Direct Cost Detail Provides summary 611E backup documentation in a printable format for sponsors.

Award Expenditure Total Report Provides summary backup documentation for AMT prepared financial reports.