Import Budget Execution To Planning

Overview

The Import Budget Execution to Planning enables Budget Managers to copy Budget Execution details to a Budget Version. This can avoid significant data entry by automatically creating Budget Plans based on Budget Execution data. Execution data can be used to either create new records or modify existing ones by either using Actual Expenditures (AE), AE with Commitments or AE with Obligations, Current Amount or Original.

 

Navigation

Budget Planning ► Interfaces ► Import Budget Execution to Planning

 

Import Budget Execution To Planning screen Fields

Field

Description

Budget Control Type

A drop down menu displaying the list of Budget Control Type from Budget Distribution Control.

Fiscal Year

A drop down menu displaying the list of Fiscal Years.

Type Definition

Users could modify the default selection (all coding blocks) to select one or more Coding Block Expression.

Budget Plan Modification or Creation Option

Possible values are “Modification of an Existing Budget Plan(s)”, “Creation of a new Budget Plan within an existing Budget Version”, and “Creation of a new Budget Version”. Default is “Modification of Existing Budget Plan(s)”.

Budget Execution Data to Import

Possible Values are “YTD Actuals”, “YTD Actuals + Obligations” or “YTD Actuals + Commitments”, or "Current Amount", or "Original Amount".

Override Budget Lines Amount

Default is checked meaning that the Budget Line Amount of the Budget Lines with the same coding block as the source Budget Control will be overwritten. This parameter should only be visible if Budget Plan Modification or Creation Option is set to “Modification of an Existing Budget Plan”.

Budget Planning Scenario

The Scenario to which the Budget Execution information is imported.

Destination Scenario COA Group

Users should select one Destination COA Group, from the list of Scenario COA groups.

Budget Version ID

The Budget Version ID to which the Budget Execution information will be copied, selected from a drop­down menu displaying the Budget Version(s) with Status “In Budget Planning” of the Destination Scenario, if Budget Plan Modification or Creation Option is set to “Modification of existing Budget Plan” or “Creation of a new Budget Plan within an Existing Budget Version”.  The Budget Version ID is entered manually if Budget Plan Modification or Creation Option is set to “Creation of a new Budget Version”, if system parameter “Generate Budget Version ID is set to “False”.

Budget Version Name

The Budget Version Name associated to the selected Destination Budget Version ID or entered manually, if Budget Plan Modification or Creation Option is set to “Creation of a new Budget Version”.

Institution Tab

Users should select one or more Institutions from the list of Institutions from the Budget Plan Structure(s) of the Destination Scenario.

Budget Plan Tab

The Budget Plan to which the Budget Execution information will be copied, selected from a drop­down menu displaying the Budget Plan(s) with Status “Open”, and with the same COA group as the Destination Scenario COA Group, of the Destination Budget Version. This Tab is only required if Budget Plan Modification or Creation Option is set to “Modify an Existing Budget Plan”.

 

Budget Plan

Overview

The Budget Plan to which the Budget Execution information will be copied, selected from a drop­down menu displaying the Budget Plan(s) with Status.

 

Budget Plan Tab screen Fields

Field

Description

Code

Unique identification code representing the Budget Plan.

Status

Possible values are Open (by default), Completed, Under Analysis, Closed, Partially Sent for Execution, Fully Sent for Execution.

 

Institution

Overview

Users should select one or more Institutions from the list of Institutions from the Budget Plan Structure of the Destination Scenario.   This Tab is only required if Budget Plan Modification or Creation Option is set to “Creation of a New Budget Version” or “Creation of a new Budget Plan within an Existing Budget Version”.

 

Institution Tab screen Fields

Field

Description

Code

Unique identification code representing the Institution.

Description

Description of the Institution.