Portfolio Audit Overview

Portfolio Audit Map

Review the sections throughout this article to learn more details about each area included in the map below. 

Screen Shot 2022-05-11 at 12.29.47 PM.jpg

App Features

Dashboard

When you first open Portfolio Audit, use the Dashboard to view quick audits at a glance.


To create custom dashboards that pull in specific criteria, first determine the subsets of data you would like to view. For example, group all accounts by a particular custodian, account type, bill method, and so on. Next, create a case in the Support app, provide a brief description of how the audit should function, and the fields you would like to include in your dashboard. We will submit your request and update you on the project status as it is developed.


Use the Portfolio section in the top part of the gray panel on the left side of the page to access a particular portfolio level. Alternatively, search for a household or account using the search boxes on the right side of the Dashboard page.

image.png

Back to Top



Portfolio Tree

The Portfolio Tree is an excellent tool for navigating within a particular entity, providing easy access to view the entities associated with this client.


To access the Portfolio Tree:

  • Click on the desired entity in the grid to highlight it yellow.
  • Select the grey bar at the top of the grid.
  • The list expands to display all registrations, accounts, and their values.
  • Click on an entity's name or one of the portfolio icons to the right of the entity to view the corresponding level. 

image.png





Audits

The gray panel on the left-hand side of the Portfolio Audit homepage also contains audits that are critical to your month/quarter-end processes. Next to each of these audits is a question mark that explains what results that particular audit returns and the recommended action to correct that data.


image.png



Many audits are available for your review, but these are some of the most crucial:

Active with Zero Balance: Displays a list of accounts in your database with an "Active" status and a zero balance. These accounts often need canceling in Orion but reach out to the custodian immediately if they should hold a value on the Orion platform. If the account should be canceled please fill out this form.


Inactive Not Zero: Displays accounts with an "Inactive" status that has a positive or negative balance. If the accounts should be $0.00, they likely need canceling. Inversely, they likely need to be un-canceled if the accounts should have a balance.


With Mult Acct Num Per ID: Returns a list of Account IDs with two or more account numbers within the same Account ID. To view all the account numbers within the Account ID, navigate to the asset level and enable the Account Number column. Having multiple account numbers in one Account ID causes incorrect reporting. It is best practice to have one account number per Account ID. 


Acct Number in Mult Account: Lists account numbers that are in multiple Orion Account IDs. Having duplicate account numbers in the Orion system causes grave errors that impact billing and reconciliation. 


Editing Capabilities

  • Portfolio Audit is the central location where you make edits to core portfolio data points. Each level within the portfolio hierarchy has its own edit screen and holds unique fields applicable to that entity level.
    • Example: Name, Address, Account Type, Transaction Type, Price, etc.
  • Right-click on the entity you wish to edit in the main grid > select Edit to access the edit screen. 

Example of the household edit screen: 

 

Right-Click Menu

Right-click on any entity in the grid to open up the navigation menu. This tool provides quick access to specific actions for that particular entity and allows navigation to related entities. For example, to see all the assets within a household, select the household, right-click, and select Asset

Actions Menu

Actions in the dropdown menu change based on the portfolio level you are viewing. Some of the same actions listed are available when right-clicking on the entity in the main grid. Use the Actions dropdown to complete certain actions for multiple entities simultaneously.


image.png


Common Menu Action

Use Case

Screen Shot 2022-05-11 at 11.23.01 AM.png

Run Report 

Opens the Run Report Prompt to run any custom or standard report

Screen Shot 2022-05-11 at 11.23.01 AM.png

Export to Excel

Exports the highlighted entities into excel

Screen Shot 2022-05-23 at 12.20.09 PM.png

New Portfolio

Opens the New Account Wizard to create a new account in the New Accounts Center app 

image.png


Screen Shot 2022-05-23 at 12.20.09 PM.png

Mass Cancel Accounts

Cancel highlighted accounts en masse

Screen Shot 2022-05-23 at 12.20.09 PM.png

Import 

Import Target Allocations, Stored Performance, SLOAs, and Tax Schedules

Screen Shot 2022-05-23 at 11.13.51 AM.png

Move

Move accounts/registrations

Screen Shot 2022-05-11 at 11.31.57 AM.png

New

Create new household/registration/account

Screen Shot 2022-05-23 at 12.20.09 PM.png

Refresh Grid

Refresh the grid to populate any potential changes

Links Menu

Select an entity in the grid to enable the Links option. The Links dropdown menu provides shortcuts to various integrations and tools on the Orion platform.


image.png



Common Menu Action

Use Case

Screen Shot 2022-05-23 at 2.10.24 PM.png

Portfolio View

Opens the selected entity in Portfolio View

performance-viewer.png

Performance Viewer

Opens the selected entity in Performance Viewer

tax-center.png

Tax Center

Opens the selected entity in Tax Center

Client Portal.png

Client Portal

Opens the selected entity in the Client Portal

MicrosoftTeams-image.png

Rebalance

Opens the selected entity in the Rebalancer tool in TOM

MicrosoftTeams-image.png

Tactical

Opens the selected entity in the Tactical Tool in TOM

MicrosoftTeams-image.png

View Instances

Opens the selected entity in the Instances tab in TOM

MicrosoftTeams-image.png

View Orders

Opens the Orders tab in TOM for the selected entity

MicrosoftTeams-image.png

View Closed Orders

Opens the Closed tab in TOM for the selected entity

Filters, Columns, Groupings, & Custom Views

image.png

  • Filters - Add a filter by clicking the Filters dropdown and selecting "add filters"; this allows you to see a specific set of information. For example, if you are looking to only see accounts for a specific Household ID or with a Current Value, create a custom view by creating and adding filters. 


  • Columns - Add or remove columns to the grid by checking and unchecking the box in the dropdown. Rearrange the order by dragging and dropping the columns in the grid or the Columns dropdown.


  • Groupings - The Groupings section organizes your data and groups in a certain order. For example, group by Representative Name or Transaction Type, choose the order (ascending or descending), and add some aggregators.


  • Custom Views - To save a custom view with filters, columns, or groupings, select the pencil icon to the right of "Standard View", click on "Save as a New View", and assign it a name. A default view means that every time you access Portfolio Audit, it becomes the landing page.