Budget Enforcement Overview (v5.0)

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

  


Purpose of this document

 

Once a Budget is developed, Budget Enforcement allows a Food Bank to be able to enforce the available Budget on transactions.    Budget Enforcement applies to all transactions that affect the General Ledger, and use an Account, Fund, and/or Dimension that has been specified on a Budget.  Budget Enforcement provides two levels of calculations (warning level or error level) and over budget notifications via e-mail.

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


 

 

Table of Contents

 

Setup

 

The usage of Budget Enforcement functionality in Ceres requires the functionality to be activated, designating if elements (Account, Fund, and/or Dimensions) are subject to Budget Enforcement, and establishing Budget Notification Groups for over budget e-mail notification.  

General Ledger Setup

 

1. The General Ledger Setup can be accessed from Departments à Financial

    Management à Setup à Administration à General Ledger Setup.


2. From the General Ledger Setup page, General FastTab, check the Utilize Budget Enforcement to activate

    Budget Enforcement.



Budget Notification Groups

 

1. Budget Notification Groups can be accessed from Departments à Financial

    Management à Setup à Administration à Budget Notification Group.


2. Select  Home à New to create a new Budget Notification Group.   Enter a Code and a Description for each

    group.


 

3. To add members to an existing or new notification group, select Home à Process à Details.


4. The Budget Notification Group Details Page displays with the members assigned to that group.


  1. First, you must have an E-mail Address specified on the User Setup Page for each user. Then, you may select or add a User to a new or existing Budget Notification Group.
  2. A User ID cannot be added twice to the same Budget Notification Group
  3. A User ID can be added to two different Budget Notification Groups.  

Note: If a User ID is added to two different Budget Notification Groups, that User may receive two Budget Notifications for the same transaction.  

 

G/L Account

 

1. G/L Accounts can be accessed from Departments à Financial Management à General

    Ledger à Lists à Chart of Accounts.


2. Select an Account from Home à Manage à Edit to open the G/L Account Card.


 

3. On the Posting FastTab of the G/L Account Card, select Excl. from Budget Enforcement if you wish to exclude

    budget enforcement from being applied to any transaction posted to this account.


Note:  The default is not to exclude any transactions from Budget Enforcement.


4. If the Excl. from Budget Enforcement in not checked, you can specify a Budget Notification Group if you

    would like warning or failure budget notifications to be sent to a Budget Notification Group other than or in

    addition to the default Budget Notification Group specified on the budget.


Note:  Refer to  the Chart of Accounts Overview Procedure Document on how to setup a G/L Account.

Funds

 

1. Funds can be accessed from   Departments à Administration à Application

    Setup à General à Administration à Funds.



2. Select the Excl. from Budget Enforcement checkbox if you wish to exclude Budget Enforcement from being

    applied to any transaction posted to this Fund.   You can specify a Budget Notification Group if you would

    like warning or failure budget notifications to be sent to a Budget Notification Group other than or in

    addition to the default Budget Notification Group specified on the budget. 


Note:  The default is not to exclude any transactions from Budget Enforcement.

Note:  Refer to the Fund Overview Procedure Document for additional information on setting up Funds.

Dimensions

 

1. Dimension can be accessed from Departments à Financial Management à  Setup à 

    Administration à Dimensions.



2. Select a Dimension and then select Navigate à Dimension à Dimension Values to display the Dimension

    Values for the selected Dimension.


3. Select the Excl. from Budget Enforcement  checkbox if you wish to exclude Budget Enforcement from being

    applied to any transaction posted to this Dimension Value.   You can specify a Budget Notification Group if

    you would like warning or failure budget notifications to be sent to a Budget Notification Group other than

    or in addition to the default Budget Notification Group specified on the budget.


Note:  The default is not to exclude any transactions from Budget Enforcement.

Note:  Refer to the GL Dimensions and Dimension Values Procedure Document for additional information on setting up Dimensions.

 

 

G/L Budgets

 

1. G/L Budgets are created/managed from Departments à Financial Management à General

    Ledger à Lists à G/L Budgets.


 

2. Select Home à Manage à Edit List to make changes to the G/L Budget fields.  You cannot check any of the

    Include in Calculation fields on the G/L Budget until you provide a Start and End Date for the budget.


 

Start Date:  Enter the starting date of the budget.

End Date:  Enter the ending date of the budget.

Incl. G/L Account in Calculation:   Select this field to include G/L Account when calculating the available budget for this budget.

Require Fund:  Select this field to indicate that a Fund No. is required when entering budget transactions for this budget.

 

Incl. Fund in Calculation:   Select this field to include the Fund No. when calculating the available budget for this budget.

Require Global Dimension 1:   Select this field to indicate that Global Dimension 1 is required when entering budget transactions for this budget.

Incl. Global Dim. 1 in Calc.:   Select this field to include Global Dimension 1 when calculating the available budget for this budget. 

Require Global Dimension 2:   Select this field to indicate that Global Dimension 2 is required when entering budget transactions for this budget.

Incl. Global Dim. 2 in Calc.:   Select this field to include Global Dimension 2 when calculating the available budget for this budget.

Budget Dimension 1 Code:  Specify the Dimension Code Name to be utilized as Budget Dimension 1.

Require Budget Dimension 1:   Select this field to indicate that Budget Dimension 1 is required when entering budget transactions for this budget.

Incl. Budget Dim. 1 in Calc.:   Select this field to include Budget Dimension 1 when calculating the available budget for this budget.

Budget Dimension 2 Code:   Specify the Dimension Code Name to be utilized as Budget Dimension 2.

Require Budget Dimension 2:   Select this field to indicate that Budget Dimension 2 is required when entering budget transactions for this budget.

Incl. Budget Dim. 2 in Calc.:   Select this field to include Budget Dimension 2 when calculating the available budget for this budget.

Budget Dimension 3 Code:   Specify the Dimension Code Name to be utilized as Budget Dimension 3. 

Require Budget Dimension 3:    Select this field to indicate that Budget Dimension 3 is required when entering budget transactions for this budget.

Incl. Budget Dim. 3 in Calc.   Select this field to include Budget Dimension 3 when calculating the available budget for this budget.

Budget Dimension 4 Code:   Specify the Dimension Code Name to be utilized as Budget Dimension 4. 

Require Budget Dimension 4:   Select this field to indicate that Budget Dimension 4 is required when entering budget transactions for this budget.

Incl. Budget Dim. 4 in Calc.:  Select this field to include Budget Dimension 4 when calculating the available budget for this budget.

Blocked:  Select to block this budget and no longer utilize it for Budget Enforcement.

Failure if No Budget Record:   Select this option to trigger a budget failure if there is not a G/L Budget entry for the combination of the Include in Calculation fields for this G/L Budget.  Without this option selected if a G/L Budget entry is not found for the combination of the Include in Calculation fields, a budget failure will not be triggered.

Def. Budget Notification Group:   Specify the Default Budget Notification Group for failure and warning e-mails for this budget.

Note: If Budget Notification Groups are also specified on the G/L Account, Fund, and/or Dimension, an over budget notification will be sent to the users included on those Budget Notification Groups as well as the default Budget Notification Group.

 

Failure %:  Specify the percentage of the budget to be used to trigger a budget failure.   This can be set to more than 100%.   Set to 0% for no failure.

Note: If a Budget Failure is triggered, the transaction will not post until the budget failure condition has been rectified.

Warning %:  Specify the percentage of the budget to be used to trigger a budget warning.   This can be set to more than 100%. Set to 0% for no warning.

Note: If a budget failure is triggered, the budget warning will be suppressed.

Bud. Notification Date Formula:   Specify the notification date formula (i.e. 1d= 1 day, 1w= 1 week, 1m = 1 month) to control how many times members of a Budget Notification Group are notified of budget failures and warnings.   A blank indicates that a notification will be generated for each attempted transaction posting.

 

Budget Entry Processing

 

1. When a budget has the Require Fund, Require Global Dimension and/or Require Budget Dimension 1, 2,

    3,or 4 selected, a Fund and/or Dimension values are required to import or enter budget transactions for the

    G/L Budget. 

 

2. For a budget that has Require Fund and Require Global Dimension 1 selected, if a Global Dimension 1 filter

    (in this example Department is Global Dimension 1) is not provided (but the Fund filter is) the user will

    receive the following error upon entering a budget transaction (this also applies to G/L Budget transactions

    created via the budget import process). 

 

 

 

3. In order to successfully enter a budget transaction, the user will need to provide filters for all of the Require

    .. fields selected for the budget. 

 

 

Budget Calculation

 

1. When Budget Enforcement applies to a transaction the budget is calculated using the following.

 

a. Based upon the posting date of the transaction, determine which budgets have a Start Date and End

    Date that are between the posting dates of the transaction.  This may select more than one budget.  If

    multiple budgets are selected each budget is calculated independently. 

 

b. Retrieve the Budget Calculation controls (i.e. the Include XXX in Calc. fields) for the budgets applicable

    to the transaction (determined in step 1).

 

c. Calculate the G/L Budget Amount by summing the budget amounts for the calculation controls

    indicated on the budgets using values from the transaction.

 

d. Calculate the prior Transaction Amounts by summing the general ledger amounts for the transaction

    values based upon the calculation controls indicated on the budgets.

 

e. Check for G/L Budget Failure by taking the G/L Budget Amount calculated in step 3 times the failure %

    to derive the Available Budget and subtract the prior Transaction Amount and the current Transaction

    Amount.  If insufficient budget is calculated, generate an error message and e-mail notification and do

    not allow the transaction to post.

 

f. Check for G/L Budget Warning by taking the G/L Budget Amount calculated in step 3 times the

    Warning % to derive the Available Budget and subtract the prior Transaction Amount and the current

    Transaction Amount.  If insufficient budget is calculated, generate a warning message and e-mail

    notification and allow the transaction to post.

 

Note: If the budget for the calculation controls, indicates an insufficient budget and the current transaction will reduce that insufficient budget, then the transaction will post without generating a budget warning or error.


Budget Enforcement Processing

 

1. When configured, Budget Enforcement applies to all transaction where.

 

a. The transaction.

b. The transaction uses an Account, Fund, and/or Dimension that is included on a budget.

c. The transaction does not contain an Account, Fund, and/or Dimension that has Exclude from Budget

    Enforcement is selected.

d. The transaction has a posting date that is between the Start Date and End Date specified on a budget.

  

 

2. Based up a G/L Account, Fund, and Department Code that has a total budget of $10,000, the following error

    message (and associated e-mail notification) is generated when trying to post a General Journal Entry for

    $5,000.

 

Related Topics

  1. Budget Overview
  2. Budget Import by Dimension
  3. Budget Import by Dimension Template
  4. Fund Overview
  5. G/L Dimensions and Values
  6. Chart of Accounts Overview

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