Portfolio Audit App

Portfolio Audit  is a core app on the Orion platform that holds all the data points for your accounts and is where you manage and maintain the structure of a client's portfolio. Think of this app as the backbone of any output from the Orion system. Portfolio Audit is where all data lives; any report or performance you run in Orion pulls the data from Portfolio Audit. Understanding this app is critical to understanding Orion as a whole and how everything ties together.


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


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.


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.


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. 


For further assistance on the available audits in the Portfolio Audit app, reach out to Orion's SME Data Reconciliation team.

 

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. 
  • Make sure you have the appropriate privileges enabled to have editing capabilities. Review the How to Update Manage User Privileges Support Article for more information.

Example of the household edit screen: 


TIP: Update fields en masse in Portfolio Audit to make the same change to the same field across multiple entities efficiently! Review How To Edit Fields En Masse to learn more.


 

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 Assets. 


Some menu options vary depending on what entity level you are viewing. 


Screen Shot 2022-05-11 at 11.12.19 AM.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

 Audit History

View changes made to the account

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

 Cancel Account

Cancel an account to make it inactive and bring the value to zero. Review How to Cancel an Account and Undo a Cancellation for step-by-step instructions. 

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

 New 

Create a new household/account/registration

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

 Edit 

Edit an existing household/account/registration

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

 Delete

Delete an existing household/account/registration

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

 Move

Move an existing registration/account

MicrosoftTeams-image.png

 View Instances

View instances in TOM for the selected account

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.