The SOM Finance team offers analytics and reporting resources to provide departments with clear visibility into their finances and financial trends. The reports and resources below can help you effectively monitor balances and make data-informed budgetary decisions throughout the fiscal year.
[Note: Should this still be a searchable report repository.]
Sources and Trends report
Three-year trend summary of a department's finances at a roll up and detail level categorized into their fund types.
Trend Summary by Ledger report
Three-year trend summary of a department's finances at a roll up and detail level categorized into by ledger.
Transaction Details Report
All transactional detail for a given department or index over the current fiscal year.
Trend Summary by Index report
Three-year trend summary of a specified index displayed at a roll up and detail level.
Budget to Actuals report
A report for a given department, subdepartment or index that compares the Anaplan budget to actuals for the current fiscal year.
Labor Drill Down Report
This report displays the current budgeted personnel details for a given department, sub department or index.
Effort Report
This report displays budgeted effort for all VCU personnel in a given department or subdepartment broken out into the following effort categories: research, teaching, admin, service and clinical. Then a display reports the funding sources of research effort broken out into intramural, extramural and department supported resources.
Effort Justification Report
This report displays all effort that exceeds centrally set thresholds and allows users to enter justifications to the effort exception
Total Compensation by Ledger
This report displays all personnel costs for a specified department or subdepartment in aggregate at the ledger level and at the person level.
Ending Labor Distributions Report
This report displays all personnel within a specified department or subdepartment who has labor budgeted to end before the end of the fiscal year.
Pooled Labor Report
This reports displays all keyed pooled labor within a specified department or subdepartment broken out by their department, pool description, e-class, funding index, budgeted personnel and fringe accounts, budgeted pool amount, benefit rate, calculated benefits, and total.
MCVF Current Funds Report
This report shows all MCVF current funds within a specified department, fund purpose, beginning balance, YTD revenue, YTD expense, YTD transfers and ending balance at a specified point in time.
MCVF Endowed Funds Report
This report shows all MCVF endowed funds within a specified department, fund purpose, current year payout, YTD expense, and current fiscal year balance at a specified point in time.
Departmental dashboards show an overview of a department's VCU finances by fund type and can be disaggregated by ledger, index, sub department, and index categories. Information is provided on a YTD basis (detail transactions are not available).
- [ADD LINKS TO DASHBOARDS]
VCU Reporting Center - Finance/Chart of Accounts
This is a comprehensive listing of all indexes, index name, subdepartments, fund type, assigned FA and FA# of a specified department or MBU.
VCU Reporting Center - Finance/Budget vs. Actual Summary
This report show revenues, personnel, expenditures, encumbrances, and transfers for all indexes within a specified MBU, department or sub department within a specified timeframe.
VCU Reporting Center - Finance/Current Budget Transactions
This report shows all budget transactions (current and permanent) for a given program (fund type), fiscal year, time period, MBU, department, sub department or index.
VCU Reporting Center - Finance/Non Grant Organization Deficit Report
This report shows all indexes with deficit balances within a specified timeframe within a specified MBU, department, sub department, or all indexes under a specific Finance Manager.
VCU Reporting Center - Finance/Open Encubrances
This report displays all open encumbrances for a specified MBU, department, sub department or index.
VCU Reporting Center - Finance/Revenues and Expenditures - Organizational Detail
This report shows all indexes within a specified fund type (or all funds), MBU, department, or sub department and their revenue budget, YTD revenue, expense budget, YTD expenses, and ending balance. This is an excellent report to use to determine an index's current balance or current balance of a fund type like E&G.
VCU Reporting Center - FYTD Data/Transaction Detail FYTD
This is a comprehensive list of all transactions within a given fiscal year for a specified MBU, department, sub department or index.
VCU Reporting Center - FYTD Data/Payroll to Finance FYTD
This is a comprehensive list of all personnel transactions within a given fiscal year for a specified MBU, department, sub department or index.