University Departmental Reports

You must have BOTH accesses below before you can run any Bear Finance Reports.
  • You must have fund/organization access to some budgets.
  • You must have Argos access (under finance folder) before you can run any of the reports below.

Argos access is granted separately from Fund‐Org access and controlled by the Information Security Office. When a user is granted Fund/Organization (Budget) access (Approver, Originator or View), that does not give them access to run Argos finance report. To request for Argos Finance access, user MUST send an email to InformationSecurity@MissouriState.edu to request access.

All reports below use ODSPROD database connection, so you must use your ODSPROD password to connect and run the report.

If you cannot remember your database password, you can change it by changing your database password. If you cannot remember the username for your Database Account, contact the Help Desk and they can provide it to you. Your database user name is the same for both PROD & ODSPROD and usually your first initial followed by your last name (example BBEAR for Boomer Bear). If your database account displays an error message that the account is locked, please contact Information Security Office for assistance with unlocking at informationsecurity@MissouriState.edu

BearFinance Argos Reports Guide

If you run into any issues or questions when running the reports, please email us at BannerFinance@missouristate.edu.

University Departmental Reports are designed to reflect departmental budget and actual activity based on the type of fund category being reported. Each report may be requested at the organization, account category, account, or transactional detail level. Fund and Organization selections may be made for either an individual Fund or Organization code, or for one of the hierarchical "roll-up" Cost Center, Division, or Department group codes. If a group code is selected, all areas within that group will be reported individually with totals for each division. Any information returned will always be based on authorized Fund/Organization access.

Operating Fund Reports include Budget-to-Actual comparison reports for the General Operating fund (A02000 or A92000 based on Campus). Budget information is provided by Departmental Organization. An Organization code, Fiscal Year, Month and Campus (Springfield or West Plains) must be specified. Reports include Adopted Budget, Permanent and Temporary Budget Adjustments, YTD Activity, Encumbrances and Remaining Balance Available. The Organization and Expense Category Summary reports also include prior year activity totals and the percent of permanent budget expended. The Transaction Summary report will also include Budget Pool totals for reference as well as a Current column to easily identify transactions occurring within the reported period. The Year to Year comparison report includes activity between two fiscal years. The comparison report includes prior year activity within the reported period and provides a difference in balances between the two fiscal years by Account Category.

Non-Operating Unbudgeted Fund Reports include Revenue and Expense reports for Non-Operating revenue generating funds (such as Income and most Designated funds) that do not receive an annual budget. Activity and balance amounts are provided by Departmental Organization for each Fund reported. A Fund and Organization code must be specified, along with the Fiscal Year and Month. Reports include Net Asset Carryover, YTD Activity, Balance Encumbered, and resulting Projected Remaining Net Assets for each fund. The Transactions Summary report will also include a Current column to easily identify transactions occurring within the reported period. Non-Operating Unbudgeted funds include fund types B (Income), some E (Designated) and F (Research).

Non-Operating Budgeted Fund Reports include Budget-to-Actual comparison reports for Non-Operating revenue generating funds (such as Auxiliaries and some Designated funds) that do receive an annual budget. Both budgeted and actual revenue and expense information is provided by Departmental Organization for each Fund reported. A Fund and Organization code must be specified, along with the Fiscal Year and Month. Reports include Adopted Budget, Permanent and Temporary Budget Adjustments, YTD Activity, Encumbrances and Remaining Balance Available. Budgeted and Actual Revenue Over/Under Expenses and Transfers and the resulting Projected Change to Net Assets after Encumbrances is also provided for each Fund. The Revenue and Expense Category Summary report also include prior year activity totals and the percent of permanent budget expended. The Transaction Summary report also includes a Current column to easily identify transactions occurring within the reported period. Non-Operating Budgeted funds include fund types D (Service Center), H (Auxiliary), P (Program Income) and some E (Designated).

Grant and Project Fund Reports include Budget-to-Actual comparison reports for Grant and Project funds that require cumulative balances over the life of the Grant/Project and may span fiscal years. Budget information is provided by Departmental Organization for each fund reported, and may include all funds associated with a grant/project or optionally a single fund or group of funds. Either a Grant/Project ID - OR - a Fund and Organization code must be specified, along with the Fiscal Year and Month. Reports include Adopted Budget, Permanent and Temporary Budget Adjustments, "Inception-to-Date" Activity, Encumbrances and Remaining Balance Available. If requested by Grant/Project ID, a total for the Grant/Project will be included. For Fund/Organization reports, totals by Cost Center - Division will be included. The Transaction Summary report also includes a Current column to easily identify transactions occurring within the reported period. Grant and Project funds includes fund types I (Federal), K (state), M (local), O (Private) and X (Project).

Transaction History Extract Report Includes detail transactions in a spreadsheet format. The extract report can be run for a single month or year to date activity. Any information returned will be based on authorized Fund/Org access. Both a Fund and Organization code must be specified. The desired Fiscal Year and Month must also be specified.

Activity report

University Operating Fund Budget-to-Actual with Activity include Budget-to-Actual comparison reports for the General Operating fund (A02000 or A92000) based on Campus). Reports includes budgets, expenditures, and encumbrances. Information is returned at the transaction detail level and transactions with Activity Code listed first. The organization code must be specified. The desired Fiscal Year and Month must also be specified. Any information reported will be based on authorized Fund/Org access.

University Income Account Transaction Summary by Activity includes the transactions for selected activity code(s). Transactions are sorted by Activity code, Revenue/Expense category and account category. Activity code must be specified. The desired Fiscal Year and Month must also be specified. Fund code is optional. Any information reported will be based on authorized Fund/Org access.

University Non-Operating Funds Rev & Exp Transaction with Activity includes Revenue and Expense Category Transactions and Summary Information for Non-Operating Funds. Information is returned at the transaction detail level and transactions with Activity Code listed first. The resulting change to net assets is also reported for each fund along with the projected net asset carryover after encumbrances. Both a fund and organization code must be specified. The desired Fiscal Year and Month must also be specified.

University Grants & Projects Transaction Summary with Activity includes Inception to Date Expense Transactions for Grants and Projects. Information is returned at the transaction detail level and transactions with Activity Code listed first. The Budgeted, Actual, Encumbrances and Balance Remaining is reported. Either a Grant ID or a Fund and Organization code combination must be specified. Any information reported will be based on authorized Fund/Org access.