Useful Queries

Below is a list of queries that we find useful and you may want to add to your favorites list.

General Information

ID 8272 As of Value by Account - Active Accounts Only - Returns the value for all accounts as of a specific date. Does not include zero value Accounts.
ID 5632 As of Value by Asset - Returns the value for all holdings as of a specific date.
ID 8070 As of Value by Client - Returns the value for all clients as of a specific date.
ID 5873 - Transaction Report - Shows all transactions within a given date range.
ID 7056 - Available Index Data - Show all available index information within Orion.
ID 7101 - Blended Indexes - Shows the underlying weightings for each blended benchmark.
ID 5872 - Contributions and Distributions - Shows client contributions, starting values, and distributions.

ID 11695 - Unrealized Gain Loss by Lot - Displays the unrealized, lot level, gain loss information.
ID 14999 - Unrealized Gain Loss by Account - Displays Unrealized, account level, gain loss information.
ID 18007 - Realized Gain Loss by Lot - Displays the realized, lot level, gain loss information.
ID 33648 - Realized Gain Loss by Account - Displays realized, account level, gain loss information.
ID 34868 - Missing Unrealized Cost Basis - Displays accounts that are missing cost basis information for a specific time period.

ID 15829 - Account Pays for Audit - Shows a accounts in pays by/for relationships.
ID 10395 - Average Daily Balance - All Accounts - Show the avg daily balance breakout by day for accounts.
ID 34934 - Cash Funding Query at Representative Level - Shows the billed value and current available cash along with a difference column.
ID XXXXX - XY Fee File - Available after live billing for you to download and submit to Schwab as your fee file.