9.2 Defining the Average Daily Balance

Purpose:  Use this document as a reference for defining the average daily balance in ctcLink.

Audience:  Finance staff.

You must have at least one of these local college managed security roles:

  • <there are no college-assignable roles>

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Defining the Average Daily Balance

Navigation:  NavBar > Navigator > General Ledger > Average Daily Balance > ADB Definition

  1. The ADB Definition search page displays.
  2. Select the Add a New Value tab.
  3. Enter SetID.
  4. Enter Average Daily Balances.
  5. Select Add.
A D B Definition Add a New Value tab
  1. The Definition tab displays.  Use it to identify the ledgers and their associated amount fields to be used in the definition.
  2. Enter Description.
  3. Enter Comments.
  4. Select Ledger.
  5. Select Date Code to specify how the average daily balance is calculated:
    1. "ADB Date": Calculates ADB from the daily balances posted from the ADB date.  
    2. "Trade Date": Calculates ADB from the daily balances posted from the journal date.  
    3. "Settlement Date": Calculates ADB from the daily balances posted from the settlement date.
  6. Select Adjustment Period Option:
    1. "As First Day of Report Period": The system treats adjustment period balances as the first day of the report period transaction based on period type and includes the balances in the ADB calculation.  
    2. "As Last Day of Report Period": The system treats adjustment period balances as the last day of the report period transaction based on period type and includes the balances in the ADB calculation.  
    3. "No Adjustment Period": The ADB calculation does not include period 998 balances.
  7. Select Target Ledger.
  8. Select Period Type.
  9. Select Work Record.
  10. Select the Default button to populate the Map Amount Fields section automatically. The system returns default values for the Posted Transaction Amount, Posted Total Amount and Posted Base Currency Amount fields. You can map no more than three fields.      
  11. The Map Amount Fields section connects the Amount field of the ADB ledger to the target ADB ledger amount, ending balance, and aggregate amount fields.
  12. Select the Rounding Adjustment tab.
Definition tab
  1. The Rounding Adjustment tab displays.  Use it to identify the ChartFields where the average daily balance rounding adjustment will be stored.
  2. Select the Balanced ADB option to have the system automatically verify that the selected ledger amounts are in balance and to adjust average balance calculations for rounding discrepancies.  The system records related adjustments to the value of the rounding adjustment entry ChartField that you specify. To record average balances without automatic rounding adjustments, deselect the Balanced ADB option.  If the Balanced ADB option is selected and the ADB Calculation process determines that the ADB is not balanced based on the ChartFields specified in the ADB Definition setup, then the ADB Calculation process issues the following message and the target ledger is not updated:   “Ledger amounts for CHARTKEYS specified in the ADB (target ledger) are not balanced. Important! You must check the Batch Message Log to view this message.”
  3. Select the ChartFields tab.
Rounding Adjustment tab
  1. The ChartFields tab displays.  Use it to identify the ChartField values from the source ledger. You must include these values in average balance calculations.      
  2. Select the Refresh button to retrieve all the ChartFields defined for the ADB source ledger.
ChartFields tab
  1. Use the Source ChartField field to specify the ChartField of the target ADB ledger associated with the ChartField of the ADB ledger.      
  2. Use the How Specified section to specify how the ChartField values will be summarized for use in the ADB Calculation process.
  3. Use the Selection drop-down list to include all detail values of the selected ChartField.
  4. Select the Selection list.  The Selection drop-down list values include:
    1. All Nodes at Selected Levels -  to activate the Tree and Level fields, where you can select a tree name and level name for trees with levels. Selecting this value summarizes every node at the specified level.
    2. Children at a Level - to activate the Tree and Level fields, where you can select a tree name and level name for trees with levels. Selecting this value summarizes every node at the specified level that is a child of the parent node that you select in the Specify Values/Range of Values/Tree Node group box.
    3. Range of Values - to summarize the range of values that you select in the Value and To Value fields in the Specify Values/Range of Values/Tree Node group box.
    4. Selected Detail Values - to summarize the detail ChartField values that you select in the Value field in the Specify Values/Range of Values/Tree Node group box.
    5. Selected Tree Nodes - to activate the Tree and Level fields, where you can select a tree name and level name for trees with levels.  Selecting this value summarizes the values rolled up by the tree node that you select in Value in the Specify Values/Range of  Values/Tree Node group box.
    6. Detail - Selected Parents value to activate the Tree and Level fields, where you can select a tree name and level name for trees with levels.  Selecting this option summarizes the values rolled up by the parent node that you select in the Specify Values/Range of Values/Tree Node group box.      
  5. Use the Tree field to enter a tree name if you are using trees to select your ChartField values for ADB processing.
  6. Use the Value field to enter the tree node or ChartField value to use for ADB processing.
  7. Select Save.
Chart Fields tab
  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.