Configuring Balance Sheet Allocation drivers

The Balance Sheet Allocation driver allows users to add new balance sheet allocation drivers to the database. This process spreads projected balances, interest, and FTP from a regional level to departmental levels.

Configuring Balance Sheet Allocation

To configure the Balance Sheet Allocation:

1. From the Command Center home page, click Financial Planning.
2. Open the budget, scenario, or forecast for which to edit the driver.
3. Click the Drivers & Assumptions tab.

4. Click the Balance Sheet Allocations Drivers link.

   NOTE: The driver opens in the Desktop Client and displays the BudXXXX Balance Sheet Allocation Drivers sheet by default.

5. Optionally double-click Add New Row(s) to open the Insert dialog box. Then enter the number of new rows to insert and click OK.

6. Enter the required inputs for each new allocation row. Allocations must be defined by source account and source department combination. The following inputs are required to define an allocation.

   Input	Definition
   Allocation ID	Automatically populated after both the Source account and Source department have been selected.
   Source account	Double-click the ellipses to select the source budget or forecast account.
   Source account description	Automatically populated after selecting the source account.
   Source account planning calc method	Automatically populated after selecting the source account.
   Factor CFF results into allocations	Only accounts planned using the Cash Flow calculation method are eligible for this option. Click the cell to display a drop-down arrow and select either Yes or No. When set to Yes, the Balance Sheet Budget Allocations utility performs a pro rata allocation of new volume balances, interest and FTP to target accounts. These allocated new volume amounts are added to the projected balances, interest and FTP generated from existing instruments by CFF to produce a budget that reflects the unique yield and FTP profile of each target department. When set to No, the Balance Sheet Budget Allocations utility allocates the total source balances, interest and FTP, resulting in an identical yield and FTP profile for each target department of the allocation.
   Source department	Double-click the ellipses to select the planning department account that holds the balance to be allocated.
   Source department description	Automatically populated after selecting the source department.
   Allocation basis	Balances, Interest and FTP will be spread pro rata, based on the last historical month’s balances. Users can choose to allocate pro rata using either the average (AVG) or end of month (EOM) balance.
   Target department filter	Right-click the cell and select Axiom Wizards to open the File Wizard dialog box. Then create a filter for the departments to which you want to allocate. If this setting is left blank, the Balance Sheet Budget Allocations utility allocates to all departments that have a historical balance for the given source account. You can instead use this setting to define a filtered list of departments that receive the allocation. For example, if the source planning unit is Commercial Loans Central Region, you may want to define a target department filter to include only those departments that roll up to the Central region.

7. Click Save in the File Options area of the Budget Administration task pane to save the allocation drivers to the database.

8. Close the Balance Sheet Budget Allocations file when input is complete.