Budgeting > Import Components 

Enables importing budget component lines to account(s) from .xls files. The Component Import Guide providing step-by-step instructions for completing the process may be accessed from the light blue menu bar.

Selections:

Budget Format: The budget format applied to the accounts for which information is being imported.

Budget Type: The budget type into which information is being imported. Only Budget Types for which the selected Budget Format is applicable are available for selection. If only one Budget Type is applicable it will be selected by default.

Budget Year: The budget year into which information is being imported.

Source File: The selected source .xls file containing the component data to be imported.

Sheet Name: The sheet within the source .xls file from which data will be extracted for the import.

Data Mapping: A cross-reference identifying the source .xls file columns and to which budget format columns their data should be mapped. 

Actions:

Append Components: Initiates the component import process to add the budget components from the source .xls file to the existing budget components for the selected Budget Type and Year.

Replace Components: Initiates the component import process to replace the existing budget components for the selected Budget Type and Year with those from the source .xls file.

Running the process:

From the Budgets menu click Import Components and the Component Import screen will be displayed.

First, select the Budget Format applied to the accounts for which component data is being imported. All imported data must be related to the selected format.

Next, select the Budget Type and Year into which data will be imported, the source .xls file containing the component data for the import, and the source .xls file sheet from which data will be extracted. 
 

Next, map the source .xls file columns to their corresponding Budget Format data columns. 
 

• If the source .xls file contains a header row, when the Sheet Name is selected, if any column headers match those from the selected Budget Format they will be added to the grid and mapped automatically. 
• Individual source .xls file columns may be added by clicking  , or all columns may be added by accessing the sub-menu  and clicking “Add all excel file columns”. 
  • The Budget Format Account column must be mapped for the import process to be completed.
  • For Monthly budget formats, if component data is to be imported to specific months the month names must be spelled out entirely (i.e. January, February, March, etc.). If no months are specified all component lines will be imported into the first Budget month.
  • Source .xls file columns may be referenced multiple times as needed, however Budget Format columns may be selected only once. If Budget Format columns are referenced more than once an error message will be presented.
  • Read-only Budget Format columns are not available for selection.

Once all desired source .xls file columns have been mapped to their corresponding Budget Format columns the import process may be initiated by clicking either Append Components or Replace Components.

• Append Components will add the imported component lines to the existing budget components for the selected Budget Type and Year.
• Replace Components will remove the existing budget components for the selected Budget Type and Year and replace them with those from the source .xls file.

When a selection is made the system will evaluate the source .xls file and present a preliminary message indicating the number of accounts into which data will be imported should the process be completed, and will request confirmation to proceed.
 
 

Upon proceeding the system will validate the imported component data and present the draft results to the user for acceptance prior to finalizing the import.
 
 
 
 

The draft imported components may be accessed by double clicking the desired account line or highlighting the desired account line and clicking 'Components'

To finalize the import process click Accept. As changes cannot be reverted once completed, the system will present a confirmation request prior to completing the process to add the imported components to the selected Budget Type and Year.
 
 

To stop the import process click Cancel Import to return to the Budget Component Import setup screen. Any required import setup changes may be made on the Import tab, and the process may then be re-initiated by clicking Append Components or Replace Components.

Follow these steps until the desired results are achieved.