Finance -- PI Project Balances

This app summarizes budget, expense, budget balance, and direct budget balance data for Principal Investigators that have had a project in a Financial Shared Services department. These include 5311 Cell and Regenerative Biology, 5312 Biostatistics & Medical Informatics, 5348 Medical Physics/Medical Biotech, 5362 Department of Neuroscience, and 5377 Biomolecular Chemistry.

Internal

Melissa Chan

The SMPH Fiscal Affairs Accountant pulls data from the app for Department Administrators, Financial Specialists, and PIs. Those with access to the Finance Stream can view the app.

FINANCE_QVDs_WISDM and FINANCE_QVDs_AADW:
PERIOD_SUMMARY_STAR_FACT.QVD, ACCOUNT_DIMENSION, ACCOUNTING_PERIOD_DIMENSION, PROJECTS_DIMENSION, WAWR_SFS_PROJECTS_TB

Daily

Available Directs Balance: Equals the grant/contract direct cost budget estimated at the time of the grant award minus actual direct expenses. Does not include indirect budget or expenses. This will be different than the Balance amount if an award has both a direct and indirect budget. WISER can show the calculation details to support this amount.
Budget: Equals total budget loaded into Wiser for grants. The timing a budget is loaded is when the grant award notification is received by the Research and Programs Office. The amount may be different to the total expected award due to timing differences and contingencies that need to be met (IRB approval, etc.).
Budgets for fund 136 and 150 projects include beginning fund balance, current revenue, and sales credits.
Budgets for fund 233 projects include revenue and sales credits.
Budget Directs: Equals the Transaction Amount for Accounts beginning with the letter Z except ZFA and ZOVRHD where it appears as 0. It appears negative in the following scenarios: revenue in funds 136, 161, 233, fund balance in funds 136, 161, and revenue or fund balance in fund 150. It appears as 0 for fund balances in fund 233, budgets in funds 150, 233, and all other scenarios.
Calculated Balance Using F&A Rate: Equals the Balance divided by 1 plus the F&A Rate. This number may not reflect specific terms and conditions of the award.
Direct Expenses: Expenses for all accounts except overhead in 3930 and fringe accounts.
Expenses: Equals total transactions posted to the periods selected.

Results intended for Departmental level. Reselect month after selecting individual projects or PIs due to potential lack of activity in the month initially selected.
Data may lag behind WISER by 1 or 2 days depending on refresh times.
Projects highlighted dark red end within 30 days or have already passed the end date. Projects highlighted pink end within 90 days.

This app includes the following data:
- Cumulative data for the current fiscal year starting with Period 0-Beginning Balance.
- Data where Project Status is 1-Open or 2-Ended - Past Official End Date.
- Budget, revenue, and expense data for the current fiscal year.

This app excludes the following:
- Fringe Pool Clearing Funds
- Reserves for encumbrances Account 8120
- Asset and liability accounts
- SMPH Medical School Development Funds (defined as Fund 233 in the SFS.WAWR_SFS_PROJECTS_TB table)
- Budget, Encumbrance, and Revenue transactions