Budget Import by Dimension (v5.0)

Modified on Wed, 20 Sep 2023 at 09:33 AM

 

 

 

Purpose of this document

 

This document illustrates how to use the Budget Journal by Dimension to import budget entries in Ceres based on a standard import template.   This template can be used regardless of how the Chart of Accounts, Branches, Funds, and Dimensions are defined by each food bank.

 

Ceres Object release 5.00.00 is required for the functionality described in this document.


 

 

Table of Contents

 

Overview

 

Some food banks use external budget tools, such as Power Plan or Planning Maestro, to create and maintain their budgets.  Once the budgets are finalized, they are exported using the Chart Export built into the tools, so the budgets can then be imported into Ceres for budget to actual tracking and reporting purposes.

 

The Budget Import by Dimension functionality meets this need in that the file layout is flexible to allow food banks to use the import, without further modification, regardless of how their Chart of Accounts, Branches, Funds, and Dimensions are defined.   The Budget Import by Dimension is designed so that:

 

1. Each food bank will create a file (xls) in Excel based on the standard Budget Journal Import Template

    outlined below.

 

2. Each food bank may define their Global and Shortcut Dimension differently any reference to Dimension will

    be by the true field name (Global Dimension 1, Global Dimension 2, Shortcut Dimension 3, etc.) vs. the

    caption name (Department, Project, Function, etc.).

 

3. The data will be imported as is from the data file unless otherwise noted below. It will not be cleaned or

    assessed upon import.

 

4. The import process will delete all G/L Budget Entry records by Name, G/L Account No., Date, Global

    Dimension 1, Global Dimension 2, Shortcut Dimension 3, and Shortcut Dimension 4. when running it with

    the replace entries option.


Standard Budget Import File Layout

 

To import budgets using the Budget Import by Dimension function, the Import Template is defined as follows.

 

Row 1 = Column Headers.   If the Headers are deleted, the data in Row 1 will not be imported.

Column A:  G/L Account No.  Import from data file.

Column B:  G/L Account Name.  Information only; do not import.

Column C : Branch Code (Responsibility Center).  Import from data file.

Column D:  Fund.  Import from data file.

Column E:  Global Dimension 1 Code.  Import from data file.

Column F :  Global Dimension 2 Code.  Import from data file.

Column G:  Shortcut Dimension 3 Code.  Import from data file.

Column H: Shortcut Dimension 4 Codes.  Import from data file.

Columns I – T:  Amounts for each calendar month.  Amounts will be imported with a date that is based on the value (date) that is inputted in Row A for each corresponding column.

Column U: Budget Total for each line.   Information only; does not import.

 

Importing Budgets Using the G/L Budget Import

 

1. G/L Budgets are imported from Departments à Financial Management à General Ledger à Lists à G/L

    Budgets.


2. To create a new G/L Budget Name, select New from the Home Tab of the Ribbon.


 

3. In the Budget Name field, enter a unique identifier for this budget and a short description in the Description

    field.  As defined in the General Ledger Setup, input your Global Dimension 1 and Global Dimension 2 Codes

    in the Global Dimension 1 Code and Global Dimension 2 Code fields, and your Shortcut Dimension 3 and

    Shortcut Dimension 4 Codes in the Budget Dimension 1 Code 1, and Budget Dimension 2 Code fields.


Note:  Even if you do not budget by dimension, the Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, and Budget Dimension 2 Code fields must be filled in for each Budget Name use when importing.

       In the example below, the Dimensions as defined in the General Ledger Setup as.

a. Global Dimension 1 Code = DEPARTMENT

b. Global Dimension 2 Code – PROJECT

c. Shortcut Dimension 3 Code = GL BRANCH

d. Shortcut Dimension 4 Code = GRANT


Note: Additional fields will display which are related to the Budget Enforcement functionality.   See Budget Enforcement Overview for details on the purpose and use of the additional fields.

4. To import the budget file, highlight the budget you use.  Click on Edit Budget on the Home Tab of the

    Ribbon.  From Edit Budget Page, click on the Actions Tab on the Ribbon and the select Import from

    Excel à By Dimension.


 

5. From the Budget Import By Dimension Page, fill in the fields on the Import From FastTab.


 

Workbook File Name:  Click on the AssistButton to browse to where you saved your data file.

 

Worksheet Name:  Click on AssistButton and select the Worksheet you want to import. If your data file has multiple Worksheets you want to import, you will need to run the import for each Worksheet.


 Worksheet Name:  Click on AssistButton to select the worksheet from the file.


 Budget Name:  Select the Budget Name to want to use when importing your budget entries.


 Option:  Select how you would like to import your budget entries.   The options are:

 

Replace entries - Your prior budget entries will be deleted and replaced by the entries you are importing.

Add entries -   The budget entries you are importing will be added to the existing budget entires.  Generally you would use this option if you have different budget files or Worksheets for different Dimensions, such a department, or Use this option will insert new budget entries line that you are importing at different times.


 Description: User-defined Description.

 

6. Click OK to start the import process.  A message will display asking you if you are sure you would like to add

    or replace the entries.  If Yes is selected, the import will continue processing and the valid data will import.  

    If No is selected, the import will stop processing and no data will be imported.


7. A message will display indicating % complete.   Once the data has been imported an Import Complete

    message will display.


   

8. If invalid data is encountered during import the below message will display.  Click OK to abort the process. 

    Update the data file to match the Budget Name setup or vice versa and then re-run the import.


9.  Alternatively, if the one the Dimension Code fields associated with the Budget Name is blank the below

    message will display.  In this example the Shortcut Dimension 3 Code field if blank fo BUDFY20.   Update the

    blank Dimension Code field and then re-run the import.


10  Once the import is complete, the Budget will be updated with the data that was imported. Open the Buget

        Card to review and update the entries.


Editing a Budget

 

1. To edit a budget, select the budget you want to edit and and then click on the Home Tab in the Ribbon and

    then select Edit Budget.  An Edit – Budget Page will display.

 

 

 

2. On the General FastTab and Filter FastTab, select or input values in the various fields based on how you

    want to view your budget.

 

Note: If your Work Date is after the starting date of your fiscal year, you will need to set a date filter for the entire fiscal year before all dates (accounting periods) will display.

 

 

 

3. Open the Budget Matrix FastTab to view the entries.

 

 

 

4. Find the G/L Account you want to update, and click on the elypssis button to the right of the amount field of

    any amount.  You can also right click on the amount field and then select Drilldown.  The  View – G/L Budget

    Entries Page with display.


  

5. Click on the Home Tab of the Ribbon and select Edit List.  You are now in edit mode and will be able to

    update the Dimension and Amount fields.  You can also insert new lines by selcecting New from the Home

    Tab of the Ribbon. Once you have made your updates, click OK to save the changes.  In the below example,

    G/L Account 401000, Department 1000 for July  was changed from $1,000 to $1,500 and the Description

    was changed on the original entry to designate it was imported.


Related Topics

  1. Chart of Accounts Overview
  2. Budget Overview
  3. Budget Import Template
  4. Budget Enforcement Overview
  5. Fund Overview
  6. GL Dimensions and Dimension Values

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article