Target Allocations

Why Assign Target Allocations?

  • Target allocations allow you to compare a portfolio's current makeup against selected goals.


  • These target allocations are for reporting purposes only and are not related to trading or trading models.


How Do I Assign Target Allocations?

Assign target allocations in the Portfolio Audit app either individually or en masse using an import. After they are assigned, a great way to view these is using Portfolio View.

Assign Target Allocations Individually

If you need to assign target allocations to just a few households or accounts, assign them individually.


Navigate to the Portfolio Audit app and find the account or household you want to assign target allocations to.

  • Right-click and select Edit Account or Edit Household.
  • Click the Target Allocation tab.
  • Select the grouping you want using the Grouping Type dropdown.
  • Under Group Selection, click on an option, then click Add.
    • You can also shift-click or ctrl-click to select and add multiple options at once. 
  • Fill in the percentage for each target allocation entry.
    • Please Note: The percentages must total 100%, or else you will not be able to save your changes. 
  • Click Save. 

assign allocations individually




Assign Target Allocations En Masse

To assign target allocations en masse, start in the Portfolio Audit app 

  • Go to either the Households or Accounts tab depending on which level you want to assign target allocations at.
  • Click on Actions in the top right corner and select Import Target Allocations. 
  • Download the template in the format of your choosing and fill it out. Refer to the next section below for details on how to do so. 
  • Upload the template where you downloaded it from.
  • Review the information you are about to import.
  • Click Process Import. 
  • Click Finished.

assign allocations in mass

 

 

How to Fill Out the Template

After you download the template by following the first three steps from the section above, fill out the information for each account accordingly. 


Columns 

AccountId: The account ID for the account you are adding target allocations to. You will likely have multiple lines for each account because you need one row per target per account.

Please Note: If you downloaded the household template to add target allocations at the household level, this column is called Household ID. 

EntityEnum: Enter either the name OR the ID for the grouping you want to use for the target allocations. Only select one of the following options for each account or household: Asset Category, Asset Class, Risk Category, Product Type, Product Sub-Type, Asset Level Strategy, Business Line, Investment Objective, or Product.


To find the EntityEnum IDs, reference the following:


  • Management Style: 16
  • Asset Category: 90
  • Asset Class: 81
  • Risk Category: 91
  • Product Type: 104
  • Product Sub-Type: 105
  • Asset Level Strategy: 85
  • Business Line: 79
  • Investment Objective: 106
  • Product: 9
 

EntityId: The ID for the specific option you are assigning a target allocation to. For example, if you are assigning target allocations at the Asset Class level, navigate to the Products and Prices app > Asset Class tab under Exports > the Asset Class ID is in the PkProductClass column. 


Weight: The allocation percentage for the specific option. For example, if you want to assign a 20% allocation, enter 20 in this column.


Please Note: the total weight for each account or household must equal 100%. 
 

Example:

  • Account ID: In this example, target allocations are added to account ID 1705.
  • EntityEnum: The target allocations are for the Asset Category grouping.
  • EntityId: Asset Category IDs.
  • Weight: The target allocations are 20% in Asset Category ID 1, 30% in Asset Category ID 1021, and 50% in Asset Category ID 2. These total 100%. 

Screen Shot 2022-04-05 at 11.49.20 AM.jpg

Troubleshooting the Import

If you receive an error when trying to upload the import, double-check the following:


  • Look for any 0% weights and correct them. The import will not accept 0% weight target allocations. 


  • Ensure that all household and/or account IDs are entered correctly. The system must be able to match each ID on the import to an existing Household or Account ID.