Cherry Blossoms

Reports

There are a large number of tools available for pulling metrics and financial reports at University of Washington depending on your role and data needs. The data source determines what can be provided and how the user access is managed.

Worker Security Access & Roles

Back to Top

For the platforms above as well as ECC, the new effort reporting tool, use this table to gain access:

Platform Access Notes
BI Portal Managed via EDW in ASTRA. Reach out to your administrator or, if necessary, the CAS Research Office. Look up your roles and authorizors from the ASTRA main page. Find out how to check your access via UW-IT's Reporting and Analytics Wiki page.
Workday Email Josh Eikren (jeikren@uw.edu) for access.
Award Portal Anyone with a UW NetID can access this tool.
ECC Email effortreporting@uw.edu for access.

Proposals

Back to Top

Sponsored Project Proposals are any request submitted to a potential sponsor (like a government agency, foundation, or corporation) requesting funding for a specific project or activity, outlining the project’s goals, methods, budget, and expected outcomes. Sponsored projects come with terms and conditions and are not gifts or service projects.

  • BI Portal “Proposals” show data before 7/1/23. All proposals are submitted via a SAGE eGC1.
  • ORIS SharePoint reports show data after 7/1/23. Proposals are submitted via SAGE eGC1 and subsequently by SAGE MOD for the out years. This tool will move to the BI Portal in spring or summer 2025.

Budget Monitoring — Payroll

Back to Top

Payroll is the largest expenditure on grant and contract awards. To manage this complex expenditure category, run Earnings & Actuals reports each month before payroll closes to confirm that the right people are paid the right amount from the right source. Fix problems before payroll cut-off and re-run the report to confirm accuracy. Bonus benefit – it will help make tuition expenditures correct at the end of each quarter.

R0101.1 Earnings & Actuals Payroll – prompt for organization

Gifts Reporting

Back to Top

Gifts are distinct from grants or contracts, and must be managed individually. We recommend the following used in tandem:

Report Number Report Title
R1252  Expendable Gift Activity Summary with Balance
R1300.5  Actuals with Encumbrance Balance for Unit Reporting

For more information, our colleagues in Advancement have more guidance about managing gifts on their webpage.