Skip navigation, view page content

OSU masthead and toolbar

The Ohio State University
www.osu.edu
  1. Help
  2. Campus map
  3. Find people
  4. Webmail

Ohio State University logo

Resource Planning

Earnings Budget Process


main menu

sublinks

Earnings Budget Process Overview

Resource Planning requires electronic submission of budget materials. There are two options available for submitting budget materials. The first option is using the Earnings Budget On-line Panels. The second option is using the web-based spreadsheet templates. Only one option should be chosen by a College or Office.

The following describes the Earnings Budget Process:

Process Step

On-line Process

Web-based Spreadsheet Template Process

1. Review this document

Same for both processes.

Same for both processes.

2. Determine Chartfield combinations that need to be budgeted.

Run "RAB ChartFields Available" report in eReports, (Financials, Earnings Funds Budget Reports).

Download RAB Spreadsheet Templates from RP Web Reporting Server. Access to the RP Web Reporting Server requires an active OSU username ID and password.

3. Enter Projected Actuals and Budget information.

Use "Release of Appr. Budget" panels to enter information.

Enter information into RAB Spreadsheet Templates.

4. If required, enter Customer Type, Earning Rates, and complete the Cashflow Statement.

Use "Customer Type", "Rate Description", and "Cashflow Adjustments" panels to enter this information.

Download and complete the Projected Annual Operating & Cash Flow Statement and the Fee & Charges templates from the RP Web Site. These forms are provided in one Excel, Lotus, or Adobe Acrobat file. Each form is placed on a separate worksheet or page.

5. Review Budgets

Use the On-line Panels or run the Earnings Budget Reports in eReports to review budgets as entered.

Review completed spreadsheet templates in Excel or output to printer for review.

6. Submit Budgets

Using the "Earnings Freeze" panel, freeze the budget using the "FO Freeze" and "FO Submit" check boxes.

Submit the completed RAB Spreadsheet Template to RP via e-mail. RP will then load this information into the budget development tables. When this data is loaded, it will be frozen at the "FO Submit" level.

7. Approved Budgets are loaded to the Earnings Ledger as the original budget via batch process performed by RP.

Same for both processes.

Same for both processes.

8. Revise an Earnings Budget or Entering a Budget for New Earnings Operation during the fiscal year.

The "RAB Maintenance" panels will be used for all earnings budget activity after the original budgets are loaded to the Earnings Ledger.

Functionality not supported by web-template process

Other Information:
  1. Also available on the RP Web Site is an On-line Cost of Sales Request Form. This form is completed on-line and your request is forwarded to Debbie Pelley for review. Once a determination on your request has been made you will be notified. If a ChartField combination has previously been approved for Cost of Sales consideration, it is not necessary to re-submit this form. A complete listing of approved Cost of Sales ChartField combinations may be found in the Resource Document area on the RP Web Site. If your operation has approved cost of sales but does not appear on the approved list, please contact Debbie Pelley via e-mail at pelley.4@osu.edu.
  2. The web-based Release of Approved Budget Form spreadsheet template can be generated by College/VP level node or D-level node on the organization tree for all active earnings ChartField combinations. This selection is based on fund owner not the unit using the fund. This assures that all the information for a particular fund appears in only one spreadsheet template.

    Note: If you have currently existing templates that produce Release of Approved Budget Forms, it is suggested that you use the RP template by cutting and pasting the budget data into the RP template. Other alternatives will be evaluated on a case-by-case basis. Please contact your budget analyst for more information.

  3. The table below identifies the forms that are required based on the type of earnings operation.

    4. Type of Earnings Operation

    Forms
     

    Release of Approved Budget

    Customer Type

    Fees and Charges

    Projected Annual Operating and Cash Flow Statement

    Departmental Earnings

    X

    X

    X

    		  

    Conferences

    X

    		      

    Service Operations

    X

    X

    X

    X

    Auxiliary Operations

    X

    X

    X

    X

    Student Health Services

    X

    X

    X

    X

    Dentistry Instrument Kit

    X

    X

    X

    X

    Optometry Equipment Usage

    X

    X

    X

    X

    Engineering Computer Fee

    X

    X

    X

    X

    Business Computer Fee

    X

    X

    X

    X