Portfolio Audit

Think of the Portfolio Audit app as Orion's brain. Each morning the various custodians send the previous day’s data files which are reconciled by Orion’s Reconciliation Teams. You can then review the data within the Portfolio Audit app. This app also allows you to update client and account information which will then feed over into Portfolio View, the Client Portal, reports, and more. Follow along with a walk through tutorial here.

App Features

Dashboard

When you first open Portfolio Audit, use the Dashboard to view quick audits at a glance. 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.

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.

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. Nest to each of these audit is a question mark that will explain what data is being pulled in and the recommended action you should take while making corrections

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.

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. For example: Name, Address, Account Type, Transaction Type, Price, etc.

To make an edit right-click on the entity you wish to edit in the main grid > select Edit to access the edit screen. Below is an example of the Household edit screen.

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. Keep in mind, some menu options vary depending on what entity level you are viewing.

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.

Filters, Columns, Groupings, & Custom Views

Use and customize filters, groupings, and columns in most grid views across most apps in Orion, including in the Portfolio Audit. Utilize filters to exclude or include specific data in the grid, making it easier to narrow the results down to remove information that is not needed. Groupings work like folders and are a way to organize your data to help you locate certain things. Enable, disable, or re-arrange columns to your desired location within the grid to view data that only pertains to your workflow. As a best practice, save your settings after applying your customized view. Review the article here that walks through how to customize, save your view, and maximize efficiency!

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.

Need more help? Join us in our monthly office hours or email us at Orion@xyplanningnetwork.com! Use the links below to register.

Start Tier - Second Thursday of every month at 10:30 CST: https://xypnsapphire.zoom.us/meeting/register/mbcXaPgMRuOpxd1uGEOUAg

Grow Tier - Third Thursday of every month at 10:30 CST: https://xypnsapphire.zoom.us/meeting/register/4eTEMF3URNWr6_wy1UVRmA