Back

Reading the Rebalance Summary

Contents

Introduction

Locate the Rebalance Summary

Rebalance Summary Icon

Reports Menu

Sections on the Rebalance Summary

Customize Rebalance Summary Report

Rebalance Summary

Rebalance Status Messages

Reason for Trade

Underlying Accounts

Reporting

Trade Actions on the Rebalance Summary

 

Introduction

The Rebalance Summary report is the most frequently used report in Advisor Rebalancing. This report is a visual representation of trade recommendations in the context of an account's models and available cash. You can use this report to see recommended trades, cash information, and important warnings for individual accounts or rebalancing groups.

You can also take trading action on the Rebalance Summary including editing recommended trades, adding new trades, and putting trades on hold.  

To view similar information across all accounts, use the Rebalance Review.

Top of Page

Locate the Rebalance Summary

Because the Rebalance Summary is a useful tool, you can open the Rebalance Summary for your accounts and rebalancing groups in many places throughout Advisor Rebalancing.

Rebalance Summary Icon

Click next to the account or rebalancing group you want to view on any of the following pages to open the Rebalance Summary: 

Note

If the account has not yet been rebalanced, will appear instead.

Top of Page

Reports Menu

You can also view the Rebalance Summary on the Reports menu: 

  1. On the Reports menu, click Rebalance Summary.

  2. In the Search accounts field, type the name or account number of the account or rebalancing group you want to view.

  3. Click View Rebalance Summary.

Note

This option allows you to toggle between viewing the values for the account or rebalancing group as either Initial Account or Post Rebalance.

Top of Page

Sections on the Rebalance Summary

The following sections and details are available on the Rebalance Summary.

Customize Rebalance Summary Report

Expand the Customize Rebalance Summary Report section to change your view the Rebalance Summary and customize what you see and how you see it.

The following options are available: 

Field More Information

Grouping Level

By default, the Rebalance Summary is grouped by Model. However, if you are also an Advisor View user, you can group the page by categories you have set up in Advisor View. Example categories might include Asset Class, Sector, Security Type, and more.

Best Practice

If using Advisor View, Grouping Level is a useful tool to group by category, especially if you’re managing individual equities or have equities sleeves.

Display Tiers

Choose the number of tiers you'd like to show on the report details of the Rebalance Summary. The more tiers you show, the more detailed information you'll see.

Choose All to display all tiers of a model.

Notes

Even if showing only one tier, you can expand individual models or sections to see more detailed information.

Report View

Allows you to change which rows you see on the report, using these options: 

  • Choose Account to show the total picture of the account on the report.

  • Choose Buys and Sells Only to only show trading activity.

Total View

Allows you to change how the totals at the bottom of the report are calculated, using these options: 

  • If Report View is set to Account, this value will default to Account as well.

  • If Report View is set to Buys and Sells Only, you can choose to see totals as Buys and Sells Only, Account, or Both.

Highlight rows that are out of tolerance

Select to indicate rows where securities are out of tolerance with respect to the models in which they belong.

Best Practice

Select the Highlight rows that are out of tolerance option to visually find securities out of tolerance and save this as your default view by clicking Save Settings as Default.

Show net dollar differences

Select to change how the Difference ($) column of the is calculated:

  • When this is cleared, the Difference ($) column will show the absolute sum of all values.

  • When this is checked, the Difference ($) column will show the relative sum; this takes negative values into account.

Example

A client's rebalance summary shows the following when viewing in absolute dollars, the default setting. In this case, the amount shown is the absolute sum of the two Difference column amounts, regardless of negative or positive value: $350,000 + $1,000 = $351,000.

By checking the Show net dollar differences check box, the Rebalance Summary shows a calculation of the net dollar difference and considers the negative amount: ($350,000) + $1,000 = ($349,000).

Initial Account / Post Rebalance Pie Chart

Optional pie charts allow you to show data in two side-by-side pie charts, using these criteria:

  • You can show Target information, Initial Account information, and Post Rebalance information.

  • Changing the Grouping Level setting will also the data categories shown on the pie charts.

  • Choose None for all drop-down lists to remove the pie charts.

Save Settings as Default

Click the Save Settings as Default button to save any changes you've made to your view of the Rebalance Summary page so these are applied every time you visit a Rebalance Summary.

 

Top of Page

Rebalance Summary

The Rebalance Summary section gives you high-level information about your rebalance and the account settings for the account or rebalancing group you're viewing. It tells you the number of recommended trades and how close the model is to target after a rebalance.

The following information is available in the Rebalance Summary section: 

Field More Information

Account

Shows the name associated with the account or rebalancing group you're viewing.

Model

Shows the model associated with the account or rebalancing group. For more information on the individual account model setting, see Model Setting. For the rebalancing group model setting, see Rebalancing Group Settings.

Tax Status

Shows the taxable status of the account. See Tax Deferred/Exempt Setting for more information on this account-level setting.

If you're viewing the Rebalance Summary for a rebalancing group, this will say N/A because the various accounts can have different tax statuses.

Strategy

Shows the status of the account in the information being shown on the Rebalance Summary: 

  • Initial Account. Information shown reflects the account where no rebalance has been run and no custom strategies have been created.

  • Post Rebalance. Information shown reflects the account where a rebalance or directed trade has been run on the account.

  • Custom Strategy. Information shown reflects the account where a custom strategy has been added to the account.

Rebalance Type

Shows the default rebalance setting for the account you're viewing. See Default Rebalance Setting for more information on this account-level setting.

If you're viewing the Rebalance Summary for a rebalancing group, this will say N/A because the various accounts can have different rebalance types.

Rebalance Status

Shows the overall status of the rebalance. One of the following statuses will appear in this field:

  • Success. The rebalance was successful.

  • Warning. The rebalance issued warnings. Warnings do not prevent the account from rebalancing successfully.

  • Unable to Rebalance. The previous rebalance issued errors that must be corrected. Errors prevent the account from rebalancing successfully.

  • No Trades Recommended. The account was not rebalanced because there were no trades recommended.

  • Custom Rebalance. Custom rebalance strategy was used to rebalance this account.

  • N/A. A rebalance has not been performed on the account.

Model Deviation

Shows the percentage the account is deviated from the model prior to rebalancing, in absolute terms.

Number of Buys

Shows the total number of buy recommendations.

Number of Sells

Shows the total number of sell recommendations.

 

Top of Page

Cash

The Cash section gives you high-level information about the cash and account values for the account or rebalancing group you're viewing.

Information about commissions and fees in the Cash section can also help you make decisions about the cost of trading.

The following fields show in this section: 

Field More Information

Total Cash

The total value of cash in the account, including any cash reserves.

Cash Available for Trading

The amount of cash that exceeds the cash reserve goal, in addition to any cash above the total cash reserve upper threshold. This amount will be negative if the account needs to raise cash to meet its cash goals and is below the total cash reserve lower threshold.

Cash Reserve Goal

The target amount of cash reserves. This amount reflects the total cash reserves amount set at the account level.

Cash Reserve Actual

The amount of cash held in reserves. This can be different from Cash Reserve Goal because of upper and lower thresholds set on any cash reserves.

Cash to Raise

The amount of cash the account needs to raise for cash reserves. This amount doesn't consider model cash, if any. This total can also be seen on the Cash Management Settings tab on the Account Settings page.

Rebalancing Account Value

The value of the account, excluding any cash reserves.

Total Account Value

The total value of the account, including all positions in the account and any cash reserves.

T+1 Cash

The T+1 cash available after a rebalance. This is calculated as (Initial Cash + Value of Sells settling T+1) – Value of Buys, excluding fees.

Commission

The total amount which will be paid to the broker for trades in equities and ETFs. These commissions are set at the account level using Equity Per Trade Commission Setting and Equity Per Share Commission Setting.

Total Redemption Fee

The total amount that will be charged upon the sale of funds.

Custodian Transaction Fee

The total amount of fees which will be charged by the custodian. This is set up on the Fee Schedules page under the Setup menu.

 

Notes

The floating box on the right side of the Rebalance Summary shows you basic cash information as you scroll down the page.

Top of Page

Rebalance Status Messages

The Rebalance Status Messages section shows basic information, warnings, and errors associated with the rebalance. If your model deviation is off and you aren't producing expected trades, information in the Rebalance Status Messages section can tell you why.

This section contains three types of messages: 

Notes

The Expand All button at the top right allows you to expand all collapsed messages with a single click, including any messages at the rebalancing group level as well as at the individual account level.

Top of Page

Reason for Trade

Expand this section to add a reason for trade by clicking the Add Reason for Trade link. This opens a dialog box where you can enter notes.

For more information on reason for trade notes, see Overview of Notes in Advisor Rebalancing.

Notes

Reason for trade notes show in reconciliation bulk reports.

Top of Page

Underlying Accounts

Expand this section to view information about the various accounts within the rebalancing group. If you are viewing a single account rather than a rebalancing group, this section will not be shown.

The following fields show in this section: 

Field More Information

Account ID

Shows the name and account number for each of the accounts within the rebalancing group you are viewing.

Asset Location Preference

Shows any Asset Location Preference setting you've assigned to the account. This setting allows you to customize asset location for your various account types within a rebalancing group. For more information, see Learn More About Asset Location and Priorities.

Account Type

Shows the account-level account type you've set.

Tax Status

Shows the taxable status of the account. See Tax Deferred/Exempt Setting for more information on this account-level setting.

Account Value

Shows the total value of the individual account, including all positions in the account and any cash reserves.

 

Top of Page

Reporting

The Rebalance Summary report information is where you'll find trades, informational messages, values, and allocations information, all grouped in the context of models within the account or rebalancing group you're viewing.

You can collapse your view to see a high-level view of your models and the results of any recommended trades. You can also expand to see more model-level detail, down to the security level. If you're viewing the Rebalance Summary for a rebalancing group, you can expand your view to show trades on a per-account basis.

The following is a summary of the information and calculations used on the Rebalance Summary: 

Field More Information

Description

Displays the long name for the security. Description also shows the price used to generate the rebalance strategy shows in parentheses after the description. If the price is a custom price, it is marked with an asterisk (*).

Initial Account ($)

Shows the initial dollar value and percent of account for the row listed. If expanded, this column can show values at the individual security level. If collapsed, this column can show values at the model level.

Model (adjusted)

Shows adjusted model allocation based off the current holdings in the account if using rank-based models.

Difference ($)

Shows the dollar amount of how underweight or overweight the security or model is to the adjusted model goal. This is calculated as Initial Account ($)Model (adjusted).

Post Rebalance ($)

Shows the dollar amount held in a security or model after the rebalance/custom strategy. This is calculated as Initial Account ($) + Buy ($) for a buy or Initial Account ($)Sell ($) for a sell.

Buy ($) / Sell ($)

Shows the proposed dollar amount of the buy or sell.

Action (Shares)

When expanded, shows the recommended trade in dollars or number of shares, if any, and also allows you to edit the trade, place it on hold, or add an order note.

Realized Gain/Loss ($)

Shows any resulting realized gains or losses from the trades. If the account is tax-exempt, this column will show N/A for that trade.

Comment

When expanded, this row shows the reasoning behind the results of the rebalance for that security, as well as any restrictions or comments about that security.

UNASSIGNED

Unassigned securities, those securities not assigned to any client models, appear at the end of the Rebalance Summary under the heading UNASSIGNED. Allocations in these securities won't contribute to the Rebalancing Account Value amount. For more information, see Legacy Positions.

 

Notes

Top of Page

Trade Actions on the Rebalance Summary

In addition to seeing recommended trades and cash information for the account or rebalancing group, the Rebalance Summary also allows you to take some actions related to trading.

Trade Action How to Use More Information
Edit Trades / Create a Custom Strategy

After a rebalance, the Rebalance Summary lists the ideal recommended trades for the account or rebalancing group. However, there are cases where you'll want to change the recommended trades.

On the Rebalance Summary, you can edit details about a trade: 

  • Change the amount of the trade in Dollars, Shares, or % of Account Value.

  • Change the trade action to None to remove the recommended buy or sell.

You can also use Symbol Lookup to add one-off trades for any securities not in the account.

Manual Trades
Clear Trades / Remove Trades

The Clear All Trades option allows you to remove all recommended trades from the account or rebalancing group.

N/A
Approve Trades

The Approve Trades option allows you to approve all trades on the Rebalance Summary.

Approve Trades
Place Trades on Hold

You can select individual trades and place them on hold for future execution.

Trades on Hold
Add a Trading Note or Account Note

Trading notes and account notes allow you to add useful information about a trade, and you can add a note to the account or rebalancing group you're viewing by choosing the notes icon: 

Icon Meaning
This account has account notes
This account has no notes
This account has trading or order notes
Add, Edit, and Delete Notes
Approve Trades in Non-Discretionary Accounts

When you approve trades for non-discretionary accounts, you may see a warning message appear. This will require you to add a note before approving the non-discretionary trade and sending it to the Trade List.

Note

To require approval for trades in non-discretionary accounts, select Approval required for non-discretionary accounts on the System Settings page.

Approve Trades

 

Top of Page