Operating Statement formats

This format show financial operating information for the selected period and compares the YTD total activity to the selected budget and identifies if budgetary performance is favorable or unfavorable.  

• Specific fields are the month and YTD actuals, encumbrances, YTD activity, budget, budget available and the budget favorable/unfavorable indicator.  

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

This format shows the comparison of the chosen fiscal period to the same period 1 year prior.  

• Specific fields are the $ amounts budgeted, actual, committed and Budget Balance for each of the selected period and previous year.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Date Range format allows you to see the operating expenses for a selected range of dates.  

• Specific fields are the actual spending, the commitments and the total activity incurred in the specified period.

• The beginning and ending period can be selected using the drop down boxes at the top of the report.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Project to Date format allows you to see the operating expenses for the selected hierarchy / GL Code since it's inception.  

• Specific fields are the total budget, Actual for the month, YTD actual, project actual, commitments, budget balance and favorable/unfavorable rating incurred in the life of the project.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Monthly Trend format allows you to see the operating expenses on a monthly basis over the past year so that you can more easily spot trends.  It also will show the total actual spent over the year, the budget and variance from budget.  

• Specific fields are the actual spending per month, actual, budget and variance over the 12 month period.

• The monthly period can be selected using the drop down box at the top of the report.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Annuall Trend format allows you to see the operating expenses on an annual basis over the past five years so that you can more easily spot yearly trends.

• Specific fields are the YTD actual spending for each of the selected and previous 4 years.

• The period can be selected using the drop down box at the top of the report.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Annual Variance format shows the operating budget, actuals, commitments and variance from budget for the selected YTD period and the previous 4 years so that you can easily spot annual trends.  

• Specific fields are the budget, actual spending, the commitments and the Net Variance incurred in the specified period and previous 4 years, based on Year to Date (YTD) data.

• The period can be selected using the drop down box at the top of the report.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Rev & Exp Variance format shows the variance between budget and actual for Revenue, Contributions and Expenses during the selected period.  

• Specific fields are the budget, actual activity, and resulting variance in the Revenue and Contributions, and the Expense budget, activity, available and % variance.(favorable/unfavorable)

• The period can be selected using the drop down box at the top of the report.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Budget Status format allows you to see the comparison of the budget, actual and variance for the selected month and YTD period.

• Specific fields are the budget, actual and variance for the selected Month and YTD.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The Quarterly Trend format allows you to see the operating actuals on a quarterly basis over the past four quarters (YTD) so that you can more easily spot trends.  It also will show the total actual spent over the year, the budget and variance from budget.  

• Specific fields are the actual per quarter, ending with the selected quarter and the YTD total over the 4 quarter period.

• The quarterly period can be selected using the drop down box at the top of the report.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.

The User Defined format allows you to define the data that you wish to report on.  

• Columns and the Column sort order can be changed on the Advanced Options tab.

The Forecast format shows the annual budget and YTD activity (actual and commitments) and provides an estimated forecast variance for the year of the selected period.

• Specific fields are the annual budget, YTD actual, YTD Commitments and YTD Activity for the selected Month and the Forcast annual variance.

• Budget options are Annual Adjusted or Original Budget or the YTD Adjusted or YTD Original Budget for the selected period.

• Data can be presented broken out by Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Fund Financial Manager, or Organization Financial Manager.