Skip to main content

Saint Louis University Header Logo Center

Menu Search

Saint Louis University Financial Services

Saint Louis University's Financial Services is the central point in the controller's office for departmental inquiries regarding financial statements and Banner Finance screens.

Financial Services maintains and monitors Banner Finance access and security, the finance approval queues, and chart of accounts attributes; processes requests for new funds; and provides Banner Finance training for departmental users. 

Users who have Banner Finance reporting access may view a complete list of revenue and expenditure account codes by requesting the Cognos report "BUSFM120 Banner Account Code Hierarchy - Operating Ledger," located in the Fiscal Management folder.


Banner Finance

Employees at Saint Louis University can request access to Banner Finance for financial information to fulfill institutional management or operational responsibilities.

Database access is not a right, but rather a privilege based on University policies and procedures designed to protect the use, confidentiality, privacy, and security of institutional and personal information. Existence of a database does not imply access is generally available or that a request will be approved. Access is approved subject to specific institutional guidelines, need-to-know requirements, and data inquiry or update restrictions.

For security reasons, access to funds in Banner Finance is controlled by the hierarchical ownership of funds that permits authorized access to specific funds at various levels within the University's organization according to the executive level, school or division, department or sub-department linked to the fund. For example, access granted at the school or division level permits access to all funds assigned to the particular school or division. Access granted at the department level is more restrictive, permitting access only to those funds assigned to a particular department.

Training Sessions

Business and Finance hosts monthly Banner Finance training sessions at the Wool Center Computer Training Room.

Sessions begin with an overview of Banner Finance, including a description of the FOAPAL elements. Users then perform queries in Banner Self Service and Internet Native Banner, view an invoice document in Xtender, learn which reports are available in the WebFocus Dashboard and request reports via the Cognos reporting tool.   

The training is structured so that Banner Finance users who do not have access to the reporting tools (i.e, WebFocus Dashboard and Cognos) would stay for only the BSS, INB and Xtender sections.

Upcoming Training Dates

  • 1 to 3:45 p.m. Tuesday, Nov. 13
  • 1 to 3:45 p.m. Tuesday, Dec. 11

Requesting Access

To gain access to Banner Finance, changes to existing access or to terminate access, use the IT Service Request under the Tools tab in mySLU. Click Submit a Service Request, Accounts and Access, and then University Security Access Request.

Follow the steps below to complete the rest of the form:

  • SLU Net ID: Enter the employee's username.
  • Functional Areas: Check the Finance box.
  • Type of request: Check the appropriate box to indicate Change Access, Delete Access or New User.
  • Screen/Access Type: Check Prod, which is the production system.
  • Manager Approval: Enter the SLUNet ID (username) of the authorized approver and press Enter.
  • Finance: Check all boxes that are appropriate for the requestor's job responsibilities. In addition, list the organizations or funds that the user may access. 
  • Click Submit (located in upper right corner of form)

The Banner Finance security manager will be notified via email of the request and will obtain additional approvals, as necessary. After processing the request, the security manager notifies the authorized approver.

Reports and Statements

The Statement of Account and Report of Transactions are available via Cognos. The Statement of Account provides an overview of the financial status of each fund and includes revised budget, month and year-to-date actual, encumbrance, and available budget information. Reports for designated 2xxxxx and restricted 4xxxxx funds also display a beginning and ending fund balance. Reports for sponsored programs 3xxxxx funds include a project to date column.

The Report of Transactions provides a detailed listing of financial transactions.

Cognos "Month End" Reports

BUSFM001: Statement of Account (Fund Summary) Description

The Fund Summary provides a financial summary of the fund including budget, encumbrance and actual revenue and expenditure information for the current month and fiscal year.

View a sample Statement of Account

  • Fiscal Year and Period: The fiscal year and fiscal period for which information on the report is provided.
  • To: The fund Financial Manager or Principal Investigator; name of the individual who is responsible for the fund and authorized to approve expenditures against the fund. The Principal Investigator is always the responsible party on research grant and contract funds.
  • Fund Number/Title: The number and name of the fund for which information is provided.
  • Executive Code: The code which identifies the President, Provost, or Vice-President who is responsible for the fund.
  • School/Division Code: The code which identifies the school or division to which the fund is assigned.
  • Department Code: The code which identifies the department to which the fund is assigned.
  • Account Code/Description: The code identifies the specific type of revenue source or expenditure within a fund.
  • Revised Budget: The revised budget for the fiscal year (original budget plus or minus temporary and permanent budget revisions).

  • Actual Current Month: Actual revenue and expenditure totals for the current month.

  • Actual Fiscal Year: Actual revenue and expenditure totals for the fiscal year.

  • Commitments: Commitment of budget funds resulting from a personnel position, purchase order, eSeeIDO.

  • YTD Actual and Commitments: Actual revenue and expenditure totals for the fiscal year plus encumbrances (i.e., current commitment of budget funds). This total represents budget funds which have been utilized year-to-date.

  • Budget Variance: Revised budget less year-to-date actual revenues/expenditures and encumbrances (i.e., available budget funds). Positive items represent favorable variances; negative items represent unfavorable variances.

  • Percent Used: The portion of budget funds which have been utilized year-to-date (i.e., year-to-date actual and encumbrances divided by revised budget).

Summary totals are provided for the following categories of expenses:

  • Beginning Fund Balance:
      • Fund Balance as of July 1 of the Current Fiscal Year
  • Revenues and Additions:
      • Revenues: Account Codes 5xxxxx
  • Expenditures and Deductions:
      • Personnel Services: Account Codes 6xxxxx
      • General Expenses: Account Codes 7xxxxx to 78xxxx
      • Capital Expenses: Account Codes 799xxx
      • Transfers: Account Codes 8xxxxx
      • Recoveries: Account Codes 9xxxxx
      • Total Expenses: Account Codes 6xxxxx to 9xxxxx 
  • Net Expenses: Revenue Less Total Expenses
  • Ending Fund Balance: Beginning Fund Balance Plus Net Expenses
BUSFM003: Report of Transactions Description

The Report of Transactions provides a detailed listing of all transactions processed against a fund.

View a sample Report of Transactions

  • Fiscal Year and Fiscal Period: The month for which information on the report is provided.
  • To: The fund Financial Manager or Principal Investigator who is responsible for the fund and authorized to approve expenditures against the fund. The Principal Investigator is always the responsible party on research grant and contract accounts.
  • Fund Number/Title: The number and name of the fund for which information is provided.
  • Executive Code: The code which identifies the President, Provost or Vice President who is responsible for the fund.
  • School/Division Code: The code which identifies the school or division to which the fund is assigned.
  • Department Code: The code which identifies the department to which the fund is assigned.
  • Fund: The fund number associated with the transaction.
  • Account Code: The code which identifies the specific type of revenue source or expenditure within a fund. Transaction totals are provided for each account code.
  • Activity Code: The optional code which identifies a certain event or activity within the fund and/or organization.
  • Trans Description: The description of the transaction or the name of the vendor to which the payment was made.
  • Trans Date: The date the transaction was posted to Banner.
  • Document Code/Reference/Encumbrance No.: The identifying reference numbers for the transactions (i.e., purchase order number, journal entry number, check number, IDO number, etc.).
  • Amount: The actual amount of the transaction categorized as either a budget, actual revenue/expenditure, or commitment transaction.
  • Fund Total: Transaction totals for the identified fund.
BUSFM801: UMG Revenue/Expense Category

Report providing a financial summary by UMG account code roll up category.

BUSFM801: UMG Revenue/Expense Category Detail

Report providing detail for each line of the UMG Revenue/Expense Category report, i.e., each FOAPAL that comprises the UMG revenue and expense roll up categories of Clinical Services Revenue, Deductions from Patient Fees, Contract Revenue, etc.

BUSFM802: UMG Revenue/Expense Category Internal Medicine and Detail

Report providing UMG account code category roll up and detail specifically for the Internal Medicine department.

BUSFM803: UMG Responsibility Summary by Dept, Sub-Dept, Fund

Report providing Month Budget, Month Actual, Month Variance, Month Percent, Account Code and Description in UMG reporting order, YTD Budget, YTD Actual, YTD Variance, and YTD Percent.

BUSFM804: Account Codes Sorted by UMG Category Code

List of account codes sorted by UMG revenue/expense category code.

LBD001: Labor Distribution by Month

Report listing payroll data by fund number, account code, and employee.

LBD002: Labor Distribution by Pay Period:

Report listing payroll data by fund number, account code, and employee.


Cognos Supplemental Reports

BUSFM003a: Report of Transactions - General Ledger Roll Forward (FGR211)
Report providing general ledger (balance sheet) transaction detail, with Previous Balance, Current Month, and Current Balance subtotals by account code.
BUSFM003v: Report of Transactions by Vendor (FGR214)

Report providing transaction detail sorted by vendor, with unclassified transactions appearing at the top of the report.

BUSFM005: Trial Balance Audit (FGR310)

Report providing Revised Budget, Current Month Actual, YTD Actual, Open Commitments, Budget Available, % Used, for each account code, with sort by fund.

BUSFM009: Account Code Summary - Plus One Level Down

Report providing budget and actual by account code; with tabs for one level down Executive Level to Division, Division to Department, Department to Sub Department.

BUSFM009: Account Code/Trial Balance Summary (FGR322)

Report providing budget and actual by account code.

BUSFM010: Account Code/Activity Code Audit (FGR323)

Report providing budget and actual by account code, with detail by fund number; or by actvity code, with fund/account detail.

BUSFM013: Banner Fund Listing (FGR300/FBR001)

Report providing list of funds that the user has access to in Banner Finance; the report lists active funds first and then inactive funds; principal investigator and/or financial manager, and fund hierarchy.

BUSFM018: Designated & Restricted Funds by Executive / Div and Exp Code (FGR315)

Report providing Designated and Restriced fund balances, one fund per row, with columns for fund status, beginning fund balance, revenues, expenditures, transfers, ending fund balance, financial manager, encumbrances, available balance.

BUSFM018: Designated & Restricted Funds by Executive / Div and Exp Code (FGR325) - Excel

Report providing Designated and Restricted fund balances; one fund per row; with columns for fund status, beginning fund balance, revenues, expenditures, transfers, ending fund balance, financial manager, encumbrances, available balance. The Excel version has an option for fund purpose.

BUSFM019: Fund Balances - by Dept or Sub-Dept (FGR316 FGR317)

Report providing fund balances (Designated, Restricted, Construction, Agency); one fund per row; with columns for fund status, beginning fund balance, total revenues, total expenditures, transfers in, transfers out, net transfers, net YTD activity, ending fund balance, encumbrances, available balance.

BUSFM019: Fund Balances - by Dept or Sup-Dept (FGR326 FGR327) - Excel

Report providing fund balances (Designated, Restricted, Construction, Agency); one fund per row; with columns for fund status, beginning fund balance, total revenues, total expenditures, transfers in, transfers out, net transfers, net YTD activity, ending fund balance, encumbrances, available balance. Fund hierarchy appears in far right columns.

BUSFM025: Revenue/Expense Code Summary (FGR320)

Report providing summary by NACUBO revenue/expense code (e.g., tuition & fees, government grants and contracts, private gifts/grants/contracts, endowment income sales/service of education departments, other sources; instruction, research, public service, academic support, student services, scholarships and fellowships), with columns for original budget, revised, budget, actual current month, actual fiscal year, open commitments, budget available, percent used.

BUSFM026: Revenue/Expense Code Audit (FGR321)

Report providing budget and actual by NACUBO revenue/expense code, (e.g., tuition & fees, government grants and contracts, private gifts/grants/contracts, endowment income sales/service of education departments, other sources; instruction, research, public service, academic support, student services, scholarships and fellowships); with columns for original budget, revised, budget, actual current month, actual fiscal year, open commitments, budget available, percent used; and detail by fund number.

BUSFM031: Fund Balance - Deficit Balance/Overhead Assessment/Term Date (FWF0044/2716)

Report providing list of fund balance funds in deficit status, one fund per row, with columns for fund status, department, beginning balance, total revenues, total expenditures, transfers in, transfers out, net activity, ending fund balance, encumbrances, available balance, financial manager, and any notes regarding plan for resolution.

BUSFM034: Sponsored Program Fund Activity Project to Date (FGR324)

Report providing summary information for 3xxxxx sponsored programs funds; one fund per row; with columns for start/end date, months left, personnel, general expense, equipment, total, revised budget, balance available, actual indirect cost, and revised budget indirect cost.


WebFocus Dashboard Reports

These reports can be found on the WebFocus Dashboard in the Finance Budget Development domain Standard Reports folder.

Open Encumbrance Summary Report

Click on the Central Processing Center folder. This report provides a list of open purchase orders for the selected org.

Travel Expense Report

Click on the Travel Trip ID folder. This report is used to view expenses sorted by trip ID number.

Travel Trip ID Report

Click on the Travel Trip ID folder. This report is used to view trip number, traveler, travel dates, and destination for a selected org unit.

Active Web Deposit Detail Codes

Click on the Web Deposits folder. This report displays a list of active "Q" detail codes and the corresponding fund/account/activity code.


Finance Transaction Correction

Corrections to non-payroll transactions posted to Banner Finance in error must be requested on a Finance Transaction Correction Form to ensure adequate documentation and prompt correction of the error. Corrections to payroll transactions should be made on a Labor Expense Redistribution Form.

Banner Finance users have the option of submitting their transactions corrections via Internet Native Banner screen FGAJVCM. Contact Lisa Zoia at lisa.zoia@slu.edu for more information.

Standardized processes are in place for fund administrators to deposit funds, request disbursements, and record interdepartmental transactions. Record of all forms and documents submitted for processing should be retained by fund administrators. Reference numbers are provided for all documents to assist in the identification and tracking of transactions.

It's the fund administrator's responsibility to monitor funds to ensure that all transactions posted to the funds are accurate and appropriate. Banner Finance inquiry screens and the monthly statement of account are available to facilitate this verification process.

Transaction corrections must be submitted to the Medical Center Finance Office or Controller's Office-Accounting and Financial Reporting within 60 days of the original transaction date or sooner, as required by fiscal year end.

Submitted transaction corrections must be supported by a copy of the monthly Report of Transactions or the Banner Finance inquiry screen.

Transaction corrections may only be submitted for postings of actual revenues or expenses and may not be used to correct an encumbrance within a fund.