Reports to Support Budget Forecasting
The following list of Banner and Millennium reports are useful for researching transactions reflected in Management Reports. To open the reports linked below you must be working on campus or using a VPN.
High-Level Views
| Report Title | Description | Location |
|---|---|---|
| Fund Balances | Fund balances by year with Revenue, Expense, Transfers, and Encumbrances. Can view multiple years at one time | Fast Finance |Op Ledger Reports & Trans Details menu |
| Fund Balance Listing | Fund balances by year with Revenue, Expense, Transfers, and Encumbrances. Can view multiple years at a time | Banner FQFB01 |
Mid-Level Views
| Report Title | Description | Location |
|---|---|---|
| Bdgt Local Funds - Status Summary | Transaction details summed by account code. Shows beginning and ending fund balance. | Banner FBBS02 |
| Summary By Account Detail | Transaction details summed by account code. Does not show the beginning or ending fund balance | Fast Finance |Op Ledger Reports & Trans Details menu |
| Changes to Fund Balance | Beginning and ending fund balance with all activity summed by account code | Fast Finance | Op Ledger Reports & Trans Details menu |
| Recurring Budget Summary | All recurring budget transactions summed by FOAPAL, Position, and Person | Fast Budget |Reporting |Custom Reports |
| Fiscal Year Budget Summary | Recurring and Non-Recurring budget transactions summed by FOAPAL, Position, and Person | Fast Budget |Reporting |Custom Reports |
| Actuals by Position | Salary and benefit expenses by position, employee, and month | Fast Finance |Budget & Position Reports |
| Budget by Position | Salary and benefits budget and expenses by position and employee based on the fiscal year/fiscal period | Fast Finance | Budget & Position Reports |
| Budget vs. Current Jobs | Compares Salary FOAPAL to budget FOAPAL | Fast Finance | Budget & Position Reports |
Transaction Detail Views
| Report Title | Description | Location |
|---|---|---|
| Current Month Trans Detail | Transactions by fiscal year and fiscal period | Banner FBTD02 |
| Transaction Detail - Expenses | Expense transactions by fiscal year and fiscal period. Also hyperlinked from the Summary by Acct report. Has individual document drill-down. | Fast Finance |Op Ledger Reports & Trans Details |Transaction Detail submenu |
| Transaction Detail - Encumbrances | Transactions information for encumbrances (commitments) that are recorded in Banner (usually from POs or Western Marketplace orders) | Fast Finance |Op Ledger Reports & Trans Details |Transaction Detail submenu |
| Transaction Detail - Payroll Encumbrances | Transactions information for payroll encumbrances (salary and benefits that are payroll for the remainder of the fiscal year). Payroll encumbrances are based on current jobs. | Fast Finance |Op Ledger Reports & Trans Details |Transaction Detail submenu |
| Transaction Detail - Budgets | Budget transactions by fiscal year and fiscal period | Fast Finance |Op Ledger Reports & Trans Details |Transaction Detail submenu |
Other Reports
| Report Title | Description | Location |
|---|---|---|
| Fast Index Listing | Find fast index FOAPAL elements | Fast Finance | Additional Reports |
| Fund Listing with Rollups | Find Fund information (date established, fund manager, etc.) | Fast Finance | Additional Reports |
| Current Jobs with Labor | Detailed employee information by FOAPAL - current employees | Fast HR | Jobs |
| All Positions | Position information - vacant, filled, and canceled positions by Posn Organization | Fast HR | Positions |
| Transaction Detail - Invoice Query | Invoice detail based on FOAPAL and fiscal year | Fast Finance > Lookup menu |