University of Southern Indiana

Monthly Reports

The Business Office has developed a series of Reports to be used to review financial information. These new reports replace the monthly reports for budget status and accounting transactions that were previously printed and sent to financial managers through campus mail. 

These reports offer a number of features that will benefit financial managers, department contacts, and other individuals authorized to view University financial information, and include additional information such as: budget transactions, three year historical analysis, and month-to-month comparisons. 

These Excel reports will be available from MyUSI in Finance Self Service, and Banner Finance users will receive an email notification when reports for the month are available after each accounting period is closed.

Month End Report Information

M001 - Month End Budget Status

This report shows budget availability as of the end of the fiscal period. The purpose of this report is to compare budget versus actual accounting activity to aid in planning and decision making. In addition, the percent of budget used (or available) can be compared to the percent of the fiscal year completed (or remaining) to help plan for the remaining months of the fiscal year The following information is presented:

  • Adjusted budget: Adopted budget plus or minus any budget adjustments
  • Year to date actual: Accounting activity from the beginning of the fiscal year (July 1) to the end of month reported
  • Commitments: Encumbrances and budget reservations (purchase orders and requisitions)
  • Available balance: Remaining budget available (adjusted budget less year to date actual and commitments)
  • Percent of the budget used
  • Percent of the budget available

M002 - Month End Transaction Detail

This report provides a detailed list of actual revenue and expense transactions since the beginning of the fiscal year (July 1). The purpose of this report allows for the review transactions to ensure that they are posted to the correct fund/org, listed at the correct amount, and classified correctly. Questions about transactions appearing on this report should be directed to the accounting contact listed for the fund/org.

M003 - Month End Budget Transactions

This report is a detailed list of budget transactions since the beginning of the fiscal year (July 1).  It includes the adopted budget, budget dollars carried forward from the previous fiscal year, and any current-year budget adjustments. This report should be used to review budget transactions for information and accuracy. Questions about transactions appearing on this report should be directed to the budget contact listed for the fund/org.

M004 - Month End 3 Year Average Comparison

This report shows revenue and expenses at the end of the fiscal period.  It also shows revenue and expenses at the same point in time for the previous three fiscal years. This report can be used to gauge how current year financial activity compares to the previous three fiscal years. By understanding how current financial position compares to financial position at the same point in previous fiscal years, it may also be used to help estimate fiscal year end balances.

M005 - Month End Fiscal Period Comparison

This report shows cumulative financial activity for the fiscal year by each month completed. The values to compare for each month appear side by side along with a total. The total column equals the fiscal year to date amount as of the end of the fiscal period. This report can be used to compare accounting activity for each month of the current fiscal year. It can be used to identify exceptions which might indicate an error or illustrate trends to prompt reconsideration of plans for the remainder of the year. 

M008 - Year to Date Organizational Spending Report

This report shows the current balance in the agency funds and a detailed list of actual revenue and expense transactions since the beginning of the fiscal year (July 1). This report should be used to review transactions to ensure they are posted to the correct fund/org, listed at the correct amount, and classified correctly. This report should also be used to ensure fund balances are correct at the end of each month. Questions about the current balance or transactions appearing on this report should be directed to the accounting contact listed for the fund/org.

P001 - Inception to Date Budget Status

This report shows budget availability as of the end of the fiscal period based on the inception of the grant.  The following information is presented:

  • Adjusted budget: Adopted budget plus or minus any budget adjustments
  • Inception to date: Accounting activity from the beginning of the grant to the end of month reported 
  • Commitments: Encumbrances and budget reservations (purchase orders and requisitions)
  • Available balance: Remaining budget available (adjusted budget less year to date actual and  commitments)

This report compares budget versus actual accounting activity from the beginning of the grant to current month to aid in planning and decision making. 

P002 - Grant Monthly Transaction History

This report is a detailed list of actual revenue and expense transactions for each month. This report should be used to review transactions to ensure they are posted to the correct fund/org, listed at the correct amount, and classified correctly. Questions about transactions appearing on this report should be directed to the accounting contact listed for the fund/org.

Contact Mike Murphy

×

Send Email to

×