The University of Wisconsin School of Medicine and Public Health Office of Fiscal Affairs provides tools and resources for faculty and staff.
Accounting Data Warehouse (ADW)
The UW School of Medicine and Public Health ADW provides access to accounting data from the University of Wisconsin and the University of Wisconsin Foundation through standard web reports or with query tools. For example, you can produce financial statements for individual grants or your whole department.
Track School Funds or MAMA tracking expenditures and commitments
Department’s share in a project or grant (example, the fund 150 exercise)
Semi-detailed information for any project or fund/department
Other reports
Clinical Department Funds Flow Transition
Clinical Department Mission Coding Guidance
Funds Flow Transition Phase 2 Workgroup Membership May 2019
Other Tools and Resources
- Financial/Accounting Snapshot Tool
- E-Reimbursement
- UW Foundation
- Tools for Lab Personnel
- Mission Aligned and Management Allocation (MAMA)
- Query Library/Hyperion Server
- Research and Sponsored Programs
- Shared Financial System (SFS)
FAST provides projections of how much is left to spend on grants.
- SMPH e-Reimbursement Refresher Training Session Materials – Dec. 14, 2016
- Approving Expenses in e-Reimbursement (pdf)
- Billing Expenses to UW Foundation in e-Reimbursement (pdf)
- Monitoring and Reporting in e-Reimbursement (pdf)
The UW Foundation website includes campus database access.
- Look at grant balances or search for details.
- See how a person is being paid (payroll detail query)
- Use the Finance/Accounting Snapshot Tool (FAST). It provides projections of how much you have left to spend on grants
MAMA is used to track school funds, expenditures and commitments (formerly known as Where are We Reports). The MAMA reports are now stored on uwmadison.box.com. For access, email Darlene Wood at dwood2@wisc.edu.
The Interactive Reporting Query Library/Hyperion Server can produce monthly or other accounting reports including:
- HRS Queries
- SMPH Query Library
- School Funds Queries
- Trust Office Queries
- Other Accounting Queries
Research and Sponsored Programs supports and administers extramurally sponsored programs.