SQL Compliance Review by Account

Compliance Review by Account is an account level compliance report that displays system wide accounts with multiple fields related to compliance issues. This report is very similar to Compliance Review Account Specific, but also includes account inception date and market value on a specific date. Information on the report includes account number and type, account inception date, taxable / nontaxable, Broker/Dealer affiliation, trading discretion, type of fee arrangement, familial tie to firm and market value on a specific date.

SQL Discretionary vs Non-Discretionary

Discretionary vs. Non-Discretionary is a compliance report that groups accounts according to the firms discretionary (or non-discretionary) authority on the account. Other information on this report includes account number and type, inception date and market value on a specified date.

SQL Asset Summary

Asset Summary is a holdings / management report that lists all accounts, relative market values, and the account's weighted percentage as compared to all assets held system wide on a specific date. Information on the report also includes account type, account number and account performance start date.

SQL Security Analysis by Position with Income

Security Analysis by Position w/ Income is a holdings report that lists all assets held on a specific date. Information on this report includes weight %, security description, symbol/cusip, quantity held, tax cost, market value, annual income, cumulative income, and current yield.

SQL Statement of Asset Detail

Statement of Assets, Detail is a holdings report that lists all assets held on a specific date, by trade lot. Information on the report includes asset weighting, symbol/cusip, acquisition date, quantity held, cost basis per share & total amount, tax cost per share, and total amount and market value per share and total amount.

SQL Statement of Asset Summary

Statement of Assets, Summary is a holdings report that lists all assets held on a specific date. Information on the report includes asset weighting, symbol/cusip, quantity held, cost basis, tax cost and market value. The report also contains a 3-D graphical representation of the allocation of assets.

SQL Statement of Assets w/Commentary

Statement of Assets w/ Commentary is a holdings report that lists all assets held on a specific date with associated commentary on each holding. Information on the report includes symbol/cusip, asset weighting, market value and advisor commentary.

SQL Unrealized Gains & Losses

Unrealized Gains & Losses is a holdings report that provides a list of all assets held on a specific date with an accounting of gains and/or losses not yet realized on all positions. The report displays tax lots with current market value by lot. Information on the report includes symbol/cusip, acquisition date, quantity, cost basis, tax cost, market value, gain/loss and percent of gain/loss.

SQL Asset Performance Analysis

Asset Performance Analysis is a performance report that lists all assets held within a specific date range. Information on the report includes asset weighting, symbol/cusip, beginning and ending period value, inflows and outflows, unrealized and realized gains/loss, income/expenses and total gain/loss as expressed in dollars and as a percentage.

SQL Benchmark Comparison

Benchmark Comparison is a performance report that is run for either groups or clients. Each account within a group or client appears with a one line performance summarization for multiple time periods with an index comparison that is assigned at the account level. Information on the report includes account weighting as compared to the total of all accounts within the group/client, current market value, performance start date and 4 periods of returns for the portfolio and indexes.

SQL Category Performance Summary

Category Performance Summary is a performance report that groups assets together into major categories such as security type and asset class to provide activity and performance details for a specified date range. Information on the report includes category weighting, beginning and ending values, flows, gains/loss, income/expense and total gain/loss in terms of dollars and percentage.

SQL Executive Summary

Executive Summary is a performance report that provides an overview of account performance, asset allocation and portfolio vs. index performance comparisons on a single page report. The performance section provides detailing on 3 date ranges: from performance start date, last year and current year to date. The current asset allocation by major category is displayed in a 3-D pie chart and a line chart displays portfolio growth over time vs. relative indexes.

SQL Market Value vs. Net Invested

Market Value vs. Net Invested is a performance report that graphically represents account growth over time vs. net amount invested for a specified date range. Information on the report includes net flows, cumulative net invested, market value and cumulative gain/loss.

SQL Multi-Managed Performance Comparison

Multi-Managed Performance Comparison is a performance report that provides bottom line summary of individual account performance for multiple accounts within a specific date range. Information on the report includes account weight as compared to the total grouping of accounts, beginning and ending account values, flows (cash and securities), gains/loss, income/expense and total gains/loss both in dollars and percent change.

SQL Performance Summary

Performance Summary is a performance report that lists all accounts with actual and annualized TWR returns within a specified date range. Information on the report includes beginning and ending market values, net flows (cash and securities) and both actual and annualized TWR.

SQL Portfolio Performance
Portfolio Performance offers multiple time periods and summary information on portfolio activity and performance. Information for each time period includes beginning and ending market values, net flows, capital appreciation, income received, change in accrued interest, expenses paid, and investment gain (in dollars). This report also displays the client name, account number, account type, and date range for the reporting period, and can also include index returns for comparative purposes.

SQL Return Detail

Return Detail is a performance report that summarizes activity and performance with index comparisons for (up to) eight time periods. Information on the report includes beginning and ending values, net flows, appreciation, income, expenses, investment gain and both actual and annualized TWR.

SQL Returns vs. Benchmarks

Returns vs. Benchmarks is a performance report that graphically represents portfolio returns vs. index returns for a specified date range. Information on the report includes a dual representation of portfolio returns in terms of growth based on an initial investment of $100 and on a percentage basis, index returns based on growth of $100 and both cumulative and annualized returns for the portfolio and indexes.

SQL Buys & Sells

Buys & Sells is a transaction report that lists transaction detail for these activities within a specified date range. Information on the report includes trade and settlement dates, quantity, symbol/cusip, unit price, gross proceeds and net amount.

SQL Realized Gains & Losses

Realized Gains & Losses is a transaction report that lists assets sold and associated details within a specified date range. The report separates short term from long term gain/loss with subtotals and totals all gain/loss for a bottom line. Information on the report includes symbol/cusip, quanity sold, acquisition and sale dates, tax cost and net proceeds.

SQL Transaction Activity

Transaction Activity is a transaction report that lists all account activity within a specific date range. Information on the report includes trade date and activity type, symbol/cusip, quantity, principal and net amounts, accrued interest paid or received and any fees associated with the transaction such as brokerage costs.

Cover Letter - Portrait

Cover Pages are other reports can be run in portrait formats. The report displays the date range for the reporting period, client name/account information and advisory firm name and address.

Cover Letter - Landscape

Cover Pages are other reports can be run in portrait formats. The report displays the date range for the reporting period, client name/account information and advisory firm name and address.

Position Reconciliation

Position Reconciliation is an other / management report that is used for a specified date. The report lists all discrepancies between custodial electronic position files and account holdings within the system on a specified date.