Finance-Admin and Departmental -- Trust Balances

This app provides Trust Fund data (funds 161 and 162) for the current and prior 10 fiscal years.

Internal

Melissa Chan

SMPH Fiscal Affairs Accountant. This app is available to SMPH division administrators, SMPH directors, department and administrative employees, SMPH finance jobs, and SMPH research and sponsored groups.

Data comes from WISDM, ADW, and an Excel doc
Excel doc: Trust Rev Acct Rollups
FINANCE_QVDs_WISDM/PERIOD_SUMMARY_STAR_FACT.QVD
FINANCE_QVDs_WISDM/PROJECTS_DIMENSION.QVD
FINANCE_QVDs_WISDM/FUND_DIMENSION.QVD
FINANCE_QVDs_WISDM/ACCOUNT_DIMENSION.QVD
FINANCE_QVDs_WISDM/ACCOUNTING_PERIOD_DIMENSION.QVD
FINANCE_QVDs_AADW/trust_erc.QVD

Fourth business day after each quarter:
       July 7, 2022
October 6, 2022
 January 6, 2023
      April 6, 2023
       July 7, 2023
October 5, 2023
 January 5, 2024

Estimated Annual Income - Equals 4.0% of the Fund Balance in Fund 162.
See WISER Glossary

Descriptions of each sheet:

Trust Balances: Raw data export
Net Assets for SMPH AFQ: Used by Fiscal Affairs for Annual AFQ Survey
Trust Balances and Availability: Trust projects balances by endowment type and cash available. Permanently restricted endowments cannot be spent, Temporary Endowments could be spent and Available is cash that can be spent.
Project Funds: Fund balances by Project.
Estimated Annual Income: 4.0% estimated annual income in Fund 162.

App dependent on adding new Trust projects to ADW
Includes funds 161 Endowment Trust Fund Income and 162 Endowment Trust Fund Operation for Division 53
Excludes reserves for encumbrances (account 8120)
Be mindful of the Fiscal Year filter which resets to the most current FY when navigating to the Trust Balances sheet
Data may lag behind WISDM by 1-2 days depending on database refresh times