Purpose
The following guide is intended for Operating Entity and Org Planners who are looking to view or complete any of the following actions:
Actions:
· Enter Enrollment and Financial Aid Discount
· Forecast Submission Snapshot
· Accessing and Reviewing Forecasting Reports
Terminology
Revenue and Operating Expense Budgets
· Seeding Forecasts: The Unit Forecast will be prepopulated with the latest Monthly Forecast data for all accounts excluding:
· Tuition, Fees, Financial Aid, Endowments, Compensation and Transfers
· Tuition, Fees, and Financial Aid will be calculated based on enrollment drivers for the below accounts:
· Tuition
· Tuition-Undergrad-Autumn – 50006, Tuition-Undergrad-Winter – 50021, Tuition-Undergrad-Spring - 50036
· Tuition-Precollegiate-Autumn – 50121, Tuition-Precollegiate-Winter – 50141, Tuition-Precollegiate-Spring - 50161
· Tuition-Grad Master -Autumn – 50206, Tuition-Grad Master -Winter – 50211, Tuition-Grad Master -Spring – 50216
· Tuition-Grad Doctoral -Autumn – 50236, Tuition-Grad Doctoral -Winter – 50241, Tuition-Grad Doctoral -Spring - 50246
· Tuition-CPE/Other-Autumn – 50311, Tuition-CPE/Other-Winter – 50321, Tuition-CPE/Other-Spring - 50331
· Fees
· Fees-Undergrad Fee - 50401
· Fees-Seminary Fees - 50431
· Financial Aid
· Undergrad Fin Aid – 75400
· M&P Fin Aid – 75500
· PhD Financial Aid – 75600
· Endowments will be loaded by the Budget Office in preparation of the budgeting process that Users will be able to view.
· Compensation will be calculated in the Position plan type and the data will be pushed to the Financial plan type.
· Forecast Review Forms: Forecast review forms consist of both web forms and reports that will allow the user to view the data entry results and calculations performed during the forecasting process.
Prerequisite
· Recording Financial Transaction in Oracle Cloud: Introduction to the Chart of Accounts and POETAF.
· Oracle Planning 101 & Budget Development Overview.
Operating Forecast
Enter Enrollment and Financial Aid Discount
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Revenue Entry.
4. Select Vertical 1.
5. Ensure the correct Organization is selected.
6. In the Update Enrollment Tab, Enter # of Autumn Tuition Enrollment, Winter Tuition Enrollment, and Spring Tuition Enrollment.
NOTE: Only future periods will be available to make changes. Cells related to prior months will be locked.
7. Scroll to the right of the page, enter a dollar amount in Financial Aid Discount Rate under General Operating.
NOTE: This dollar amount is multiplied by the # of enrollment.
8. If applicable enter a dollar amount under Fund type categories.
9. Under Autumn Aided Students, Winter Aided Students, and Spring Aided Students, enter the number of aided students, even if different from that of Steps 7 and 8.
10. Select Save.
NOTE: Ensure the Tuition, Fees, and Financial Aid accounts have been populated for each of the remaining periods of Autumn, Winter, and Spring after selecting Save.
11. If you need to enter data in the Non-Enrollment Fee accounts, select the Enter Non-Enrollment Fees tab to the right.
12. Enter the data in the FY Forecast columns.
13. Select Save.
14. To View the total Net Tuition and Fees data, select the Review Tuition, Fees, and Financial Aid tab at the bottom.
15. Review the data.
You have now completed the process of Entering Enrollment and Financial Aid Discount (Forecast).
Enter Summer Tuition
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Revenue Entry.
4. Select Vertical 2.
5. Ensure the correct Organization is selected.
6. Ensure the grayed-out months are populated with Actuals, if applicable.
7. Enter a dollar amount for each month in the upcoming Fiscal Year under Forecast.
8. Select Save.
9. Ensure the Year Total has been populated.
10. If you need to enter data for an account combination that is not visible on the form, please left-click on the dimension closest to the data, right-click on the dimension, and select Add New Revenue Account.
11. This action will open a new form: FIN - Add new REV Account FCST. Please select the desired members for dimensions: Account, Organization, Fund, Program, Site, and Purpose.
12. Select the arrow icon once all selections have been made.
13. Enter the amount.
14. Select Save.
15. Select X icon to return to the Enter Summer Tuition tab to the left.
You have now completed the process of Entering Enrollment and Financial Aid Discount (Forecast).
Enter Stipends
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Revenue Entry.
4. Select Vertical 3.
5. Ensure the correct Organization is selected on the top left-hand side, highlighted in blue. Data should be populated accordingly.
6. Enter a dollar amount for each month in the upcoming Fiscal Year under Forecast.
7. Select Save.
8. Ensure the Year Total has been populated.
9. If you need to enter data for an account combination that is not visible on the form, please left-click on the dimension closest to the data, right-click on the dimension, and select Add New Revenue Account.
10. This action will open a new form, FIN - Add new REV Account FCST. Please Select the desired members for dimensions: Account, Organization, Fund, Program, Site, and Purpose.
11. Select the arrow icon once all selections have been made.
12. Enter the amount.
13. Select Save.
14. Select the X icon to return to the Enter Stipends tab.
You have now completed the process of Entering Stipends (Forecast).
Enter Gifts
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Revenue Entry.
4. Select Vertical 4.
5. Ensure the correct Organization is selected on the top left-hand side, highlighted in blue. Data should be populated accordingly.
6. Enter a dollar amount for each month in the upcoming Fiscal Year under Forecast.
7. Select Save.
8. Ensure the Year Total has been populated.
9. If you need to enter data for an account combination that is not visible on the form, please left-click on the dimension closest to the data, right-click on the dimension, and select Add New Revenue Account.
10. This action will open a new form: FIN - Add new REV Account. Please select the desired members for dimensions: Account, Organization, Fund, Program, Site, and Purpose.
11. Select the arrow icon once all selections have been made.\
12. Enter the amount.
13. Select Save.
14. Select the X icon to return to the Enter Gift tab to the left.
You have now completed the process of Enter Gifts.
Enter Endowment Revenue
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Revenue Entry.
4. Select Vertical 5.
5. Ensure correct Organization is selected on the top left-hand side, highlighted in blue. Data should be populated accordingly.
6. Enter a dollar amount for each month in the upcoming Fiscal Year under Forecast.
7. Select Save.
8. Ensure the Year Total has been populated.
9. If you need to enter data for an account combination that is not visible on the form, please left-click on the dimension closest to the data, right-click on the dimension, and select Add New Revenue Account.
10. This action will open a new form: FIN - Add new REV Account. Please Select the desired members for dimensions: Account, Organization, Fund, Program, Site, and Purpose.
11. Select arrow icon once all selections have been made.
12. Enter the amount.
13. Select Save.
14. Select the X icon to return to the Update existing endowment tab.
You have now completed the process of Entering Endowment Revenue.
Enter Other Revenue
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Revenue Entry.
4. Select Vertical 6.
5. Ensure correct Organization is selected on the top left-hand side, highlighted in blue. Data should be populated accordingly.
6. Enter a dollar amount for each month in the upcoming Fiscal Year under Forecast.
7. Select Save.
8. Ensure the Year Total has been populated.
9. If you need to enter data for an account combination that is not visible on the form, please left-click on the dimension closest to the data, right-click on the dimension, and select Add New Revenue Account.
10. This action will open a new form, FIN - Add new REV Account. Please select the desired members for dimensions: Account, Organization, Fund, Program, Site, and Purpose.
11. Select the arrow icon once all selections have been made.
12. Enter the amount.
13. Select Save.
14. Select the X icon to return to the FIN Other Revenue tab to the left.
15. Ensure correct Organization is selected on the top left-hand side, highlighted in blue.
16. Data should be populated accordingly.
You have now completed the process of Entering Other Revenue.
Revenue Forecasted Review
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Revenue Entry.
4. Select Vertical 7.
5. Ensure the correct Organization is selected on the top left-hand side, highlighted in blue.
6. Review the Total Revenue Forecasted.
You have now completed the process of Revenue Forecasted Review.
Revenue Review
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Expense Entry.
4. Select a Vertical on the left-hand side of the page.
a. Vertical 1: By COA Order – FCST
b. Vertical 2: By Program – FCST
c. Vertical 3: By Activity – FCST
d. Vertical 4: By Site – FCST
e. Vertical 5: By Account – FCST
5. Make desired changes to each vertical.
6. Select Save.
7. If you need to enter data for an account combination that is not visible on the form, please left-click on the dimension closest to the data, right-click on the selected account, and select Add New Expense Account Forecast.
8. This action will open a new form: FIN - Add new Expense Account Forecast. Please select the desired members for dimensions: Account, Organization, Fund, Program, Site, and Purpose.
9. Select the arrow icon once all selections have been made.
10. Enter an amount.
11. Select Save.
12. Select the X icon to return to the previous tab.
You have now completed the process of Revenue Review.
Forecast Review
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Review.
4. Ensure the correct Organization is selected on the top left-hand side highlighted in blue. Data should be populated accordingly.
5. Select Vertical 1 on the left-hand side of the page to Review Forecast by Fund Category and Account.
6. Select Vertical 2 on the left-hand side of the page to Review Forecast by Organization.
NOTE: Change the Org under Org-User to view different Organizations.
7. Select Vertical 3 on the left-hand side of the page to Review Forecast By Fund.
8. Select Vertical 4 on the left-hand side of the page to Review Forecast by Purpose.
9. Select Vertical 5 on the left-hand side of the page to review Annual Forecast By Month.
10. Select the cog wheel icon.
11. Select Download as PDF or Download as Excel.
You have now completed the process of Reviewing Forecast.
Forecast Submission Snapshot
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select Operating Forecast.
3. Select Forecast Submissions.
4. Select Actions.
5. Select Business Rules - FIN_DATACOPY_Submission_BudUnit_FCST.
6. Select the rule to execute.
7. Data will now be present in the Submission column on the form.
You have now completed the process of Completing Forecast Snapshots.
Forecast Reporting
Accessing and Reviewing Forecast Reporting
1. Select the OKTA Single-Sign On button and then complete the steps to sign in.
2. Select the Reports card.
3. Expand the 99. Reports folder.
4. Expand the Operating Budget Reports folder.
5. Expand the Budget and Forecast Tracking Reports folder.
6. Select the report that you wish to use.
7. Select the cogwheel icon.
8. Select Download as PDF or Download as Excel.
You have now completed the process of Accessing and Reviewing Forecasting Reports.