TTU Finance Reports By Fund
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI002 Revenue Expense Budget Pools By FOP By Fund or Organization or Program or FOP or Fund Manager or Organization Manager by fiscal year and period Shows the FI004A report budget pools by FOP for the parameter selected. You see budget compared to actual revenues, expenses and transfers including encumbrances and shows under/over budget year to date as of the ending fiscal period.      
FI009 Statement of Changes in Fund Balance By Fund By Fund by fiscal year and period Shows the following for a fund: beginning fund balance, total actual revenues, total actual expenses, total actual transfers, ending fund balance. Also shows total encumbrances and total other reserves which are subtracted from ending fund balance to show ending uncommitted fund balance. The report is year to date as of the ending fiscal period. You can drill down on any of the blue links on the level 1 report and the drill down report will show you all the organization codes that have revenues, expenses or transfers. The drill down shows all blue links from the level 1 report so you will see all organization codes sorted by revenues, transfers and expenses for the fund. You can drill down on an organization blue link on the level 2 report to see the actual detail transactions.  
FI010 Balance Sheet By Fund By Fund by fiscal year and period Shows the balance sheet for a fund. Shows each balance sheet account code and the year to date balance of the ending fiscal period. Includes assets, liabilities and fund balance. The report also shows control accounts which show total revenues, expenses, net transfers, encumbrances and budgets year to date as of the ending fiscal period. You can drill down on any of the blue links on the level 1 report to see the transactions year to date for the fiscal period.    
FI025 Revenue Expense Budget By Fund List/Report By Fund and fiscal year and period and select "report" option Shows the FI004 report for one Fund which is by account type revenues, transfers and expenses and compares budgets to actuals including encumbrances and shows under/over budget year to date as of the ending fiscal period. This report also shows beginning fund balance and ending uncommitted fund balance for a fund. You can drill down on an account type (blue link revenues, transfers or expenses) on the Level 1 report and this drill down report shows budgets and actuals for each individual FOP for a fund for the account type you selected.    
FI033 Grant Information Worksheet By Fund or Fund Description or Grant ID or Grant ID Description Shows ALL funds for a grant. Shows Grant ID, Grant Description, PI, Sponsor #, Agency Name, Award Amount, Project Start and End Dates, Responsible Org, Fund, Default Org, Default Program, Fund Manager, Fund Indirect Cost Base, Fund Indirect Cost Rate      
 
TTU Finance Reports By Organization
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI002 Revenue Expense Budget Pools By FOP By Fund or Organization or Program or FOP or Fund Manager or Organization Manager by fiscal year and period Shows the FI004A report budget pools by FOP for the parameter selected. You see budget compared to actual revenues, expenses and transfers including encumbrances and shows under/over budget year to date as of the ending fiscal period.      
 
TTU Finance Reports By Account
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI034 Daily Balances By Account for All Funds By Balance Sheet Account and As of Transaction Date Shows the ending balance sheet balance for an account code by fund and is year to date as of the transaction ending date      
 
TTU Finance Reports By FOP
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI002 Revenue Expense Budget Pools By FOP By Fund or Organization or Program or FOP or Fund Manager or Organization Manager by fiscal year and period Shows the FI004A report budget pools by FOP for the parameter selected. You see budget compared to actual revenues, expenses and transfers including encumbrances and shows under/over budget year to date as of the ending fiscal period.      
FI004 Revenue Expense Budget By FOP By FOP for a fiscal year and period Shows total budget compared to actual revenues, expenses and transfers by account type (total revenues, transfers in, expenses and transfers out). Shows under/over budget year to date as of the ending fiscal period for each account type You drill down on a blue link account type on the level 1 report and you will see the budget pool codes for the account type. You drill down on a blue link budget pool code on the level 2 report and you will see all account codes for the budget pool code. You drill down on any of the blue link dollar amounts on the level 3 report and you will see the detailed transaction.
 
TTU Finance Reports By Fund Manager
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI002 Revenue Expense Budget Pools By FOP By Fund or Organization or Program or Fund Manager or Organization Manager by fiscal year and period Shows the FI004A report budget pools by FOP for the parameter selected. You see budget compared to actual revenues, expenses and transfers including encumbrances and shows under/over budget year to date as of the ending fiscal period.      
FI021 Revenue Expense Budget by Fund Manager List/Report By Fund Manager, by fund group optional, by fiscal year and period and select "report" option Shows the FI004 report for all Funds for the Fund Manager. Shows account types revenues, transfers and expenses including encumbrances and compares budgets to actuals and shows under/over budget year to date as of the ending fiscal period. You can drill down on an account type (blue link revenues, transfers or expenses) on the Level 1 report and this drill down report shows budgets and actuals for each individual fund for the account type you selected.    
 
TTU Finance Reports By Organization Manager
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI002 Revenue Expense Budget Pools By FOP By Fund or Organization or Program or Fund Manager or Organization Manager by fiscal year and period Shows the FI004A report budget pools by FOP for the parameter selected. You see budget compared to actual revenues, expenses and transfers including encumbrances and shows under/over budget year to date as of the ending fiscal period.      
FI022 Revenue Expense Budget By Org Manager List/Report By Organization Manager, by fund group optional, by fiscal year and period and select "report" option Shows the FI004 report for all FOPs for the Organization Manager. Shows account types revenues, transfers and expenses including encumbrances and compares budgets to actuals and shows under/over budget year to date as of the ending fiscal period. You can drill down on an account type (blue link revenues, transfers or expenses) on the Level 1 report and this drill down report shows budgets and actuals for each individual FOP for the account type you selected.    
 
TTU Finance Reports By Organization Area
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI023 Revenue Expense Budget By Org Area List/Report By Organization Area code (drop down list showing code and description), by fund group optional, by fiscal year and period and select "report" option Shows the FI004 report for all FOPs for the Organization Area. Shows account types revenues, transfers and expenses including encumbrances and compares budgets to actuals and shows under/over budget year to date as of the ending fiscal period. You can drill down on an account type (blue link revenues, transfers or expenses) on the Level 1 report and this drill down report shows budgets and actuals for each individual Organization Department assigned to the Organization Area for the account type you selected.    
FI038 HUB Expenditures By Area and Department Fiscal Year, Begin and End Fiscal Period, Select Area from drop down list Shows by each department under the Area. Shows Expenditure totals by Total Dollars, HUB Dollars and HUB Percent You can drill down on the blue area link and see the expenditures by department by HUB category which shows total dollars, HUB dollars and HUB percentage    
 
TTU Finance Reports By Organization Department
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI024 Revenue Expense Budget By Org Dept List/Report By Organization Department code (drop down list showing code and description), by fund group optional, by fiscal year and period and select "report" option Shows the FI004 report for all FOPs for the Organization Department. Shows account types revenues, transfers and expenses including encumbrances and compares budgets to actuals and shows under/over budget year to date as of the ending fiscal period. You can drill down on an account type (blue link revenues, transfers or expenses) on the Level 1 report and this drill down report shows budgets and actuals for each FOP assigned to the Organization department for the account type you selected.    
 
TTU Finance Reports - Detailed Transactions
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI026 Operating Ledger Transaction Report Fiscal Year is required, optional parameters are posting period, document id, document reference #, fund, org, account, program ‐ select one or many of the optional parameters. You have sort options and report display options. Detailed transaction report shows the transactions for the parameters selected. Columns shown are posting period, rule class, rule class description, transaction date, document id, transaction amount, transaction description, document reference #, fund, organization, account, program, vendor id and bank      
FI027 Balance Sheet Transaction Report Fiscal Year is required, optionalparameters are posting period, document id,fund, and account ‐ select one or many of the optional parameters. You have sort options and report display options. Detailed transaction report shows the transactions for the parameters selected. Columns shown are posting period, rule class, rule class description, transaction date, document id, transaction amount, transaction description, fund, account, vendor id and bank      
FI030 Encumbrance Ledger Transaction Report Optional parameters include fiscal year, encumbrance #, fund, org, program, vendor ID,vendor name The report is in 2 sections. Section 1 Encumbrance Detail shows remaining balance for each encumbrance # showing encumbrance #, encumbrance item #, requisition line item #, vendor invoice #, closed, transaction date, document id, transaction amount, transaction description, FOAP, vendor ID, vendor name, bank. Section 2 Check Information shows the check # with the encumbrance #, encumbrance item #, requisition line item #, banner invoice #, transaction date, transaction amount, FOAP, vendor id, vendor name and bank      
FI040 Operating Ledger Transaction Report by FOP Fiscal Year is required, optional parameters are posting period, document id, document reference #, fund, org, account, program ‐ select one or many of the optional parameters, select by Fund Manager or Organization Manager. Detailed transaction report shows the transactions BY FOP for the parameters selected. Columns shown are posting period, rule class, rule class description, transaction date, document id, transaction amount, transaction description, document reference #, account, vendor id and bank      
 
TTU Finance Reports - List Reports
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI021 Revenue Expense Budget by Fund Manager List/Report By Fund Manager, by fund group optional, by fiscal year and period, select "list" report Shows a list of Funds assigned to the fund manager and shows the under/over budget year to date as of the ending fiscal period for the fund      
FI022 Revenue Expense Budget By Org Manager List/Report By Organization Manager, by fund group optional, by fiscal year and period, select "list" report Shows a list of FOPs assigned to the organization manager and shows the under/over budget year to date as of the ending fiscal period for the FOP      
FI023 Revenue Expense Budget By Org Area List/Report By Organization Area code (drop down list showing area three digit code and description), by fund group optional, by fiscal year and period and select "list" option Shows a list of Departments and department managers assigned to the organization area and shows the under/over budget year to date as of the ending fiscal period for the FOP      
FI024 Revenue Expense Budget By Org Dept List/Report By Organization Department code (drop down list showing department five digit code and description), by fund group optional, by fiscal year and period and select "list" option Shows a list of FOPs assigned to the Organization Department and organization managers and shows the under/over budget year to date as of the ending fiscal period for the FOP      
FI025 Revenue Expense Budget By Fund List/Report By Fund and fiscal year and period and select "list" option Shows a list of FOPs assigned to the Organization Department and organization managers and shows the under/over budget year to date as of the ending fiscal period for the FOP      
FI035 List of Funds By Financial Manager By Eraider ID Shows a list of Funds assigned to the eraider ID as Fund Manager. List by Chart code.      
FI036 List of Funds By Organization Manager By Chart and Eraider ID Shows a list of Organization codes assigned to the eraider ID as Org Manager.      
 
TTU Finance Reports - Chart Hierarchy Searches
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI028 Organization Hierarchy Report Select from a drop down box for either Level 2 Org Division, Level 4 Org Area, Level 5 Org Dept, or Level 6 Org Section OR enter level 7 Org Unit Shows a list organization codes and levels and the associated financial manager for each org level within the hierarchy of the org structure      
 
TTU Finance Reports - Other
Report ID Report Name Report Parameters Level 1 Report Level 2 Drill Down Report Level 3 Drill Down Report Level 4 Drill Down Report
FI041 Gateway Suspended Document Detail Document ID or Fiscal Year and Fiscal Period Lists service center and revenue JV transactions that have processed through the Gateway but have not posted in Banner yet