RU Revenue/Expense - 3 Selection Report
RU Revenue/Expense - 3 Selection Report
"35eda94d-2cbb-47eb-9aca-afca48b17e7a
Measures budgets against expenditures and encumbrances to determine funds availability. The report displays detailed as well as summary level information.
As detailed in the
submitting RU Rev/Exp 3 Selections Report
training session the following required paramerters are selected to run this report:
- 1st Segmnet Selection:
The critera you want the report organized by.
- Budget:
The fiscal year or project budget
- Period Name:
The period you want to analyze data for or up to.
- Report Type:
To indicate how you want the funds avaiable to be calculated and displayed:
YTDE
–
Year To Date Extended
– Provides financial information from May 1 of the selected Fiscal Year
to the account period selected in Period Name.
PTD
–
Period To Date
– Provides financial information for the month based on the Account Period
selected in the Period Name parameter.
QTDE
–
Quarter to Date Extended - P
rovides financial information for the quarter based on the
Account period selected in Period Name parameter.
- Encumbrance Type:
Select the type of encumbrances (Eg. Salaries, Commitments, or Obligations)
- Print Account Detial:
If you want to print account detail along with the summary info.
Report Header:
Indicates the Name of the report, the date you ran the report, and how many pages. It also displays the key parameters that were
selected to run this report.
In this example the folowing parameters were selected:
- 1st Segmnet Selection:
The critera you want the report organized by.
COST CENTER from XXXXX to XXXXX
- Budget:
The fiscal year or project budget.
Budget Name = FY 090 BUDGET
- Period Name:
The period you want to analyze data for or up to.
Account Period = FEB-10
- Report Type:
To indicate wheather you are dealing with Year to date, Period to date,
Project or Quarter to date.
Interval = Year-to-Date Extended (Indicating
that you want to view data from the begining of the Fiscal Year to the
period listed in Period Name.
- Encumbrance Type:
Select the type of encumbrances (Eg. Salaries, Commitments, or Obligations).
ALL
(1) Account Period:
Represents the period selected. E.g:
Feb-10
(2) Cost Centre Range:
Represents the cost centre selected and/or or a range of cost centres.
(3) Report Date:
The date that the report is run.
(4) Encumbrance Type:
When you select “
ALL
” for encumbrance type the report will include all encumbrances. You can also select specific encumbrances.
E.g. P.O encumbrance, etc.
(5) Budget Name:
For Fiscal Year funds the budget name will be the fiscal year you select. E.g. For
Fiscal 09-10
you will select “
FY 090 Budget
”
(6) Interval:
Represent the report period. For the
Fiscal Year
funds select:
YTDE – Year To Date Extended
– Provides financial information from
May 1
to the account period selected in #1 above.
PTD
–
Period To Date
– Provides financial information for the
month based
on the period date selected in #1 above.
QTDE – Quarter to Date Extended
-
Provides financial information for the
quarter based
on the period date selected in #1above.
(7)
Origianl Budget:
For the operating fund, this is the original budget as approved by the Board.
(8) Revised Budget:
The Revised Budget = The Original Budget + /- Base Budget Adjustment +/- Temporary Budget Adjustments (OTO).
(9) Encumbrance:
Obligations
for goods or services ordered but not yet received and not yet paid for.
E.g. Salary, PO, etc
…
(10) Actual:
Represents
revenue received
and
expenditures incurred
to date.
(11) Funds Available:
Original Budget + Revised Budget - Encumbrances - Net Expenses
(12) Account Codes:
Various revenue, and expense codes. E.g. Office Supplies, Travel Expenses, Lab Fees.
(13) Cost Centre Summary:
Total Revenue
– Summary of account codes in the 5000 – 5999 range
Total Salaries
- Summary of account codes in the 6000 – 6899 range
Total Benefits
- Summary of account codes in the 6900 – 6999 range
Total Non Salary
- Summary of account codes in the 7000 – 8999 range
Total Cost Centre
- The net revenue/expense per column and gives you the bottom line total for the cost centre.
The Funds Available column for the Total Cost Center summary line is where you find the
bottom line total
for the cost center.
This number determines if you are in a postive or negative state.
In this example you can see the department is in the negative $6,448.89
Original Budget Column:
For the
operating fund
, this displays the
original budget
as approved by the Board for a particular account or summary code.
Revised Budget:
The Revised Budget
= The Original Budget + /- Base Budget Adjustment +/- Temporary Budget Adjustments (OTO)
Base Budget Adjustments
are permininent adjustments to the budget. Eg. Choosing not to rehire and closing a position within the department.
Temporary Budgets Adjustments
are one time adjustments for specific reasons such as extra mony granted for renovations this Fiscal Year.
Encumbrance:
Commitment of Expenses. Monies which have been committed for a particular expenditure.
E.G.: A new computer has been ordered but not yet received.
The different types of encumbrances include:
Obligations (Purchase Orders)
- Goods ordered from suppliers but not yet received.
Commitments (Requisitions) -
Requests by departments for goods or services not yet ordered form supplier.
Salary -
Funds to be paid to employees for the remainder of the Fiscal Year
Invoice -
Encumbrance when an invoice has been entered into oracle but not yet transfered to the General Ledger.
Manual -
Funds manually sed assid by the department fo a specific use.
Actual:
Represents
revenue received
and
expenditures incurred
to date.
Funds Available:
Funds Available
=
Original Budget + Revised Budget - Encumbrances - Net expenses
Cost centre summary:
Total Revenue
- Summary of account codes in the 5000 – 5999 range
Total Salaries
-
Summary of account codes in the 6000 – 6899 range
Total Benefits
- Summary of account codes in the 6900 – 6999 range
Total Non Salary
-
Summary of account codes in the 7000 – 8999 range
Total Cost Centre
-
The total net revenue/expense per column
Account Codes:
Various
revenue
, and
expense codes
. E.g. Office Supplies, Travel Expenses, Lab Fees, etc.
Original Path