University Departmental Reports

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.

• Operating Budget-to-Actual Expense Organization Summary
• Operating Budget-to-Actual Expense Pool Summary 
• Operating Budget-to-Actual Expense Category Summary
• Operating Budget-to-Actual Expense Account Summary
• Operating Budget-to-Actual Expense Transaction Summary
• Operating Budget-to-Actual Expense Transaction Summary for Period
• Operating Budget-to-Actual Expense Year-to-Year Comparison Summary

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 Unbudgeted Fund Organization Summary
• Non-Operating Unbudgeted Revenue and Expense Category Summary
• Non-Operating Unbudgeted Revenue and Expense Account Summary
• Non-Operating Unbudgeted Revenue and Expense Transaction Summary
• Non-Operating Unbudgeted Revenue and Expense Transaction Summary for Period

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). 

• Non-Operating Budgeted Fund Organization Summary
• Non-Operating Budgeted Revenue and Expense Organization Summary
• Non-Operating Budgeted Revenue and Expense Category Summary
• Non-Operating Budgeted Revenue and Expense Account Summary
• Non-Operating Budgeted Revenue and Expense Transaction Summary
• Non-Operating Budgeted Revenue and Expense Transaction Summary for Period

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).

• Grants and Projects Revenue and Expense Organization Summary
• Grants and Projects Budget-to-Actual Expense Organization Summary
• Grants and Projects Budget-to-Actual Expense Category Summary
• Grants and Projects Budget-to-Actual Expense Account Summary
• Grants and Projects Budget-to-Actual Expense Transaction Summary
• Grants and Projects Budget-to-Actual Expense Transaction Summary for Period

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.

• Transaction History Detail Extract - CSV

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.

• Operating Budget-to-Actual Exp Transaction Summary with Activity

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 Income Account - Transaction Summary by Activity

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.

• Non-Operating Unbudgeted Funds - Rev and Exp Transaction Report with Activity
• Non-Operating Unbudgeted Funds - Rev and Exp Transaction with Activity for Period

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.

• Grants and Projects Budget-to-Actual Exp Transaction Summary with Activity
• Grants and Projects Budget-to-Actual Exp Transaction Summary with Activity for Period