Finance Reports

Report Description

5 Year Trend Activity by Fund

Displays a five year expense trend for each fund.

5 Year Trend Activity by Index

Displays a five year expense trend for each index by account type.

5 Year Trend Budget by Fund

Displays a five year budget trend for each fund.

5 Year Trend Budget by Index

Displays a five year budget trend for each index by account type.

Base Budget to Proposed Budget Report

Comparison report of Base Budget amounts and Proposed Budget amounts by FOAPAL elements with the variance (titled ‘Cumm Change’) calculated. This data is being pulled directly from Budget Development tool tables.

Budget Status Organization Drill-Through

Displays the following for each organization and fund: carry forward, budget, YTD activity, current period activity, encumbrances, available balance and % available, for all funds by index or FOAP.

Once the first page is displayed, the user can then drill through organization values to subordinate organizations until budget status is presented by index. Then drill through index values to budget status presented by account type. Then drill through budget, YTD, or current period activity values to the transaction details.

Budget Status

Presents the following for each index or FOAPAL: carry forward, YTD budget, YTD activity, YTD committed, YTD balance, and current period activity, first by account, then by summary account level 2, then by summary account level 1.

Budget vs. Actual 4 Year Expense Comparison

This report compares total expenditure budget to actual activity over a four year period for all fund types except for fund types 31, 32, 33, 34, and 35. The expenditure budget includes permanent budget, carryforward, and temporary budget. This report excludes level 1 account type 50 (revenue) for both the expenditure budget and actual activity.

Budget vs. Actual 4 Year Revenue Comparison This report compares total revenue budget to actual activity over a four year period for all fund types except for fund types 31, 32, 33, 34, and 35. The expenditure budget includes permanent and temporary budget. This report is providing level 1 account type 50 (revenue) data for both the revenue budget and actual activity.

Faculty Funding and Grants

Displays all transactions for the fiscal year up through the selected fiscal period, grouped and totaled by index.

The second page displays total inception-to-date grant activity.

Fund Status

Provides a short summary of fund status, ideal for organizations with some revenue driven funds.

Income and Expense All Funds

For organizations with several revenue driven funds interested in seeing net income across all funding sources at a point in time.

Income Statement 3 Year Period over Period with YTD

Presents an income statement (revenues, expenses and net income) for three years showing selected period activity first then YTD activity second. This report only includes activity, not commitments and encumbrances.

Income Statement All Funds by Organization

Presents an income statement (revenues, expenses and net income) with each subordinate organization in its own column. This report only includes activity, not commitments and encumbrances. The budget for general, ICC and other budgeted funds are displayed as income. This income includes both permanent and temporary budget (no carry forward). The carry forward for general, ICC and other budgeted funds is included at the bottom of the report.

Income Statement Trailing 12 Month Trend

Presents an income statement (revenues, expenses and net income) for the selected period and the prior 12 months. This report only includes activity, not commitments and encumbrances. The Total column represents a full years worth of activity. The budget for general, ICC and other budgeted funds, are displayed as income. This income includes both permanent and temporary budget (no carry forward). Carry forward is not included in this report.

Index Detail by Fund by Index

For each organization this report displays by fund and index; YTD Budget, YTD Activity, YTD Committed, YTD Balance, Current Period activity and percent available for all funds by index.

Index Summary by Fund

For each organization this report displays by fund and index; YTD Budget, YTD Activity, YTD Committed, YTD Balance, Current Period activity and percent available for all funds by index.

Labor Budget by Position

This report replaces the pivot table BRP had to manually update every few hours during the budget season for units to see what positions/dollars were hitting their labor account codes in budget development from salary planner. This will allow units who may share a positions cost by LBD to see which units are posting budget dollars to their org and for what positions. ex. CAS has budget authority over position B98625, but splits the budgeted labor distribution between CAS and AAA. AAA can’t see this position in Salary Planner because they do not have budget authority over that position (based on budget org in NBAPBUD), so AAA could run this report to see why their labor dollars in budget development do not match what they see in Salary Planner.

Service Center - Auxiliary Revenue and Expense

This report shows revenue, expense, labor and transfer activity and the changes and percent change for each line for the current year to date compared to the prior year to date for the same ending period. It also shows the current period activity compared to the same period one year ago.

Startup Funding with Index Subtotals Level 5 Organizations (Departments) with Subtotals by Index.

Transaction Detail

For each index or FOAPAL it presents detail about each transaction sorted by account.

Vendor Payments

Lists invoices sorted by transaction date, invoice number and accounting sequence.