Operating Statement Menu Options

The Operating Statement menu provides access to detailed information about the operating funds or accounts in your system in a number of different formats.  

This is the baseline structure of the Operating Statement menu.  

Please note that at certain institutions, the adjusted structure and Menu Layout may be different.

Certain end users may also not have access to each of the reporting options listed; this is based on the roles assigned and the Menu Access established at the Administration level.

 

Operating Statement

 

Summary by Hierarchy >Summary by Hierarchy >This allows you to view operating funds summarized by the high level code hierarchical structure such as by Fund, Organization or Account.

Summary by G/L Code (FOAPAL) >Summary by G/L Code (FOAPAL) >This allows you to see operating funds summarized by the accounting code. (referred to as FOAPAL in Banner systems)  It presents a more detailed level than the Hierarchical view such as by account within an organization or fund.  This report uses a single filter to drill down into the data.

Summary by Account Detail >Summary by Account Detail >This allows you to see further levels of detail in your data. The data is displayed for each account code and uses two filters to drill down into the detail. (for example, filtered by fund code (FUND) and organization code (ORGN))

Operating Statement Formats

Current YearCurrent Year

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.

ComparativeComparative

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.

 

Date RangeDate Range

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.

 

Project To DateProject To Date

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.

Monthly TrendMonthly Trend

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.

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

 

Annual TrendAnnual Trend

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.

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

Annual VarianceAnnual Variance

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.

Rev & Exp VarianceRev & Exp Variance

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.

 

Budget StatusBudget Status

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.

 

Quarterly TrendQuarterly Trend

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.

 

User DefinedUser Defined

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.

ForecastForecast

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.

 

Transaction Detail >Transaction Detail >

Transaction Detail reports allow you to view the details of individual transactions and to drill down to the supporting journal vouchers, invoices and other supporting documentation.  Different formats of the Transaction Details can be opened from the FAST Finance menu.  They can also be viewed by drilling down from the Operating Statement summaries or the Balance Sheet. After you open the Transaction Detail, you can drill down further to the Document Details.

G/L Code (FOAPAL) Lookup >G/L Code (FOAPAL) Lookup >

Transaction details can be viewed for specific G/L codes (FOAPAL in Banner systems)

ActualsActuals

This format shows detailed transaction information of actual transactions for the selected G/L Code.    

  • Specific fields are the G/L Codes (or FOAPAL codes), transaction and activity dates when the transaction occurred, the authorizing User ID, the description of the transaction detail and link to accompanying documentation, the Purchase Order number (if one exists) and the link to the PO document, invoice or reference number, check number and the transaction amount.      

  • The specific filters are shown directly above the report.  The report must be filtered by at least two filter codes selected from Fund, Orgn (Dept ID), Acct, Prog (Project ID), Actv, Locn or Acct Type.

  • Data can be filtered by  by Chart, Index, Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Account type, and the fiscal period as defined by a start date and end date.

BudgetsBudgets

This format shows detailed transaction information of budgeted transactions for the selected G/L Code.    

  • Specific fields are the G/L Codes (or FOAPAL codes), transaction type and date, the document ID and link to accompanying documentation (journal voucher), the description of the transaction detail, and the transaction amount.   

  • The specific filters are shown directly above the report.  The report must be filtered by at least two filter codes selected from Fund, Orgn (Dept ID), Acct, Prog (Project ID), Actv, Locn or Acct Type.

  • Data can be filtered by  by Chart, Index, Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Account type, fiscal period and transaction type.

EncumbrancesEncumbrances

This format shows detailed transaction information of encumbrances (commitments to pay) for the selected G/L Code.    

  • Specific fields are the G/L Codes (or FOAPAL codes), the document number and link to supporting documentation, the Purchase Order number (if one exists) and the link to the PO document, invoice or reference number, check number and the transaction amount.      

  • The specific filters are shown directly above the report.  The report must be filtered by at least two filter codes selected from Fund, Orgn (Dept ID), Acct, Prog (Project ID), Actv, Locn or Acct Type.

  • Data can be filtered by  by Chart, Index, Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Account type, and the fiscal period as defined by a start date and end date.

Payroll EncumbrancesPayroll Encumbrances

This format shows detailed transaction information of payroll encumbrances for the selected G/L Code. Payroll encumbrances are the payroll obligations that are payable for the remainder of the fiscal year.

  • Specific fields are the G/L Codes (or FOAPAL codes), date, the employee ID, employee name, position code and suffix, the type of earnings, any comments and the payroll encumbrance amount.      

  • The specific filters are shown directly above the report.  The report must be filtered by at least two filter codes selected from Fund, Orgn (Dept ID), Acct, Prog (Project ID), Actv, Locn or Acct Type.

  • Data can be filtered by  by Chart, Index, Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Account type, and the Fiscal Period.

Total SpendTotal Spend

Use the Total Spend report to get a complete picture of the total spent with a vendor through direct pay, purchase orders, and purchasing card transactions (requires FAST PCard). You can select specific filter options including, Fiscal Year, Period, Chart, and Acct Type.

In order to integrate the purchasing card (PCard) data, the report will use any vendor and merchant mapping that has been made in the Vendor Mapping FAST PCard application.

Document LookupDocument Lookup

You can use the Document Lookup tool to display accounting information and solve accounting problems (for example, how many times a purchase order is referenced). After the list opens, you can drill down for detailed information about documents and encumbrance line items.

  • Specific fields are the document number with a link to the supporting documentation, fiscal year, period and date, the description of the transaction, the transaction type and document reference number, the encumbrance ID with a link to the supporting documentation, G/L Codes (or FOAPAL codes), the outstanding amount and the transaction amount.      

  • The specific filter criteria is shown directly above the report. You can search for a specific document number by entering it into the Document filter field. 

Invoice QueryInvoice Query

Use the Invoice Query to list transaction details for vendor invoices. You can select specific filter options including, fund, orgn, payee name, payee invoice, invoice number, range of dates, and the dollar value. After you submit your query, you can drill down to view the detailed line items. Some sites will use the term 'Department ID' in place of Orgn.    

  • Specific fields are the Chart, Fiscal Year, Vendor ID, Payee Name and the transaction amount.      

  • The specific filters are shown directly above the report.  The report must be filtered by the Fiscal Period From and Fiscal Period To.

  • Data can be filtered by  by Chart, Index, Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Payee Name, Payee Invoice, Invoice Number, Dollar Value, and the fiscal period as defined by a start date and end date.

Current Year Actuals by Positions (POSN)

 

Current Year Budget by Positions (POSN)

 

 

Related topics