Back |
Home > Advisor Rebalancing > Rebalances and Trades > Rebalance Review > Reading the Rebalance Summary
|
Reading the Rebalance Summary
Sections on the Rebalance Summary |
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.
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.
Click next to the account or rebalancing group you want to view on any of the following pages to open the Rebalance Summary:
Rebalance
Rebalance Review
Trade Review
Trade List
Accounts
Account Settings
Rebalancing Groups
Rebalancing Group Settings
If the account has not yet been rebalanced, will appear instead.
You can also view the Rebalance Summary on the Reports menu:
On the Reports menu, click Rebalance Summary.
In the Search accounts field, type the name or account number of the account or rebalancing group you want to view.
Click View Rebalance Summary.
This option allows you to toggle between viewing the values for the account or rebalancing group as either Initial Account or Post Rebalance.
The following sections and details are available on the Rebalance Summary.
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 PracticeIf 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. NotesEven 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:
|
Total View |
Allows you to change how the totals at the bottom of the report are calculated, using these options:
|
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 PracticeSelect 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:
ExampleA 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:
|
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. |
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:
|
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:
|
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. |
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. |
The floating box on the right side of the Rebalance Summary shows you basic cash information as you scroll down the page.
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:
Information: Provides information about the results of the rebalance, as well as other account-specific details, like cash reserve notes and security restriction notes.
Warning: Informs you about a situation that may require action, such as warnings about securities with restrictions and messaging if a portfolio isn't able to trade to its min/max range. Warning messages will not prevent Advisor Rebalancing from rebalancing the account.
Error: Informs you about a situation that requires action before the rebalance can continue, such as "The account has a negative total value. Please check the cash reserve amounts on the account." Error messages prevent Advisor Rebalancing from rebalancing the account.
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.
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.
Reason for trade notes show in reconciliation bulk reports.
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. |
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. |
Submodels are listed in alphabetical order by default. However, if you set a custom sort order, the Rebalance Summary will respect the custom sort order you've set. For more information on setting a custom sort order, see Create, Edit, and Delete Allocation Models.
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.
You can also click the names of individual models or sleeves to expand and collapse the details of that model.
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:
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:
|
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.
NoteTo require approval for trades in non-discretionary accounts, select Approval required for non-discretionary accounts on the System Settings page.
|
Approve Trades |