Business Intelligence
The most powerful view in PlanTools. Broker-dealers, aggregators, RIAs, compliance, and auditors see an entire book of business: every plan, the recordkeeper and DCIO relationships behind them, the scorecard assessments, and every fund held.
An example book of business using our Business Intelligence Dashboards
Who it’s for
01
Every advisor’s plans under one firm: assets, plans, participants, and how the funds they recommend score.
02
Each member firm on its own, or several together. Choose the companies, and every figure on the Dashboard follows.
03
The whole practice at a glance: where the assets sit, which recordkeepers and fund families carry them, and what needs attention.
04
The scorecard criteria for each asset class, and every investment on Watch or Removal across the book, without opening a plan.
05
Every fund held, its score, rating, and action, and the assets behind it, ready to export for testing.
Everyone
The Dashboard reads the plans, scores, and holdings already in PlanTools. Nothing is re-keyed for the view.
The Dashboard
Overview, Investments, Recordkeepers, and Scorecard. Scroll through each, drawn from one firm’s Dashboard.
Total assets, plans, and users, with the fund families, categories, active and passive split, and score ranges behind them.
Dashboard
Overview
CompaniesYour firm
$24.26B across top fund families
$24.26B
$15.47B invested in target date funds
$15.47B
$28.45B invested in active funds
$28.45B
44% pass
44%
Every investment across the book with its score, rating, action, category, peer group, fund family, and assets, and the funds on Watch or Removal counted at the top.
Dashboard
Investments
CompaniesYour firm
Total expense versus revenue sharing
3,413 funds
| Score | Rating | Fund | Total assets | % | |
|---|---|---|---|---|---|
| – | – | BPAS PR Capital Preservation | Other Funds | $2,576,911,474 | 5.63 |
| 100 | Exceeds | Fidelity 500 IndexFXAIX | Large Blend | $1,697,264,774 | 3.71 |
| – | – | TIAA Traditional | Other Funds | $1,359,486,637 | 2.97 |
| – | – | CREF Total Global Stock Account R2QCSTPX | Global Large-Stock Blend | $1,105,746,697 | 2.42 |
Each recordkeeper with its plans, participants, investments, assets, and share of the book. The fund families on the Overview are the DCIO side of the same picture.
Dashboard
Recordkeepers
CompaniesYour firm
| Recordkeeper | Plans | Participants | Assets | % | |
|---|---|---|---|---|---|
| ADP | 16 | 3,090 | 472 | $153,451,352 | 0 |
| Alerus | 22 | 6,725 | 664 | $263,473,338 | 1 |
| AllianceBernstein Holding L.P. | 1 | 0 | 29 | $14,994,190 | 0 |
| American Funds | 27 | 1,055 | 710 | $155,864,908 | 0 |
| American Trust | 4 | 0 | 127 | $5,657,063 | 0 |
| Ascensus | 49 | 4,392 | 1,529 | $651,248,329 | 2 |
| Bank of America Merrill Lynch | 10 | 0 | 281 | $1,162,952,626 | 3 |
| BOK Financial | 1 | 0 | 21 | $13,263,508 | 0 |
| BPAS | 1 | 0 | 20 | $4,060,707,685 | 9 |
| Charles Schwab | 16 | 6,428 | 453 | $1,473,703,839 | 3 |
Choose a scorecard and see its metrics and thresholds for each asset class side by side, from allocation to money market. Modify it from the same screen.
Dashboard
Scorecard
CompaniesYour firm
ScorecardFirm scorecard
Modify| Metric | Value |
|---|---|
| Total Return 1Y | Top 50% |
| Total Return 3Y | Top 50% |
| Total Return 5Y | Top 50% |
| Total Return 10Y | Top 50% |
| Total Return 1Y Rank | 1 – 10 |
| Total Return 3Y Rank | 1 – 10 |
| Total Return 5Y Rank | 1 – 10 |
| Total Return 10Y Rank | 1 – 10 |
| Tracking Error 1Y | below 10 |
| Tracking Error 3Y | below 10 |
| Metric | Value |
|---|---|
| Total Return 1Y | Top 50% |
| Total Return 3Y | Top 50% |
| Total Return 5Y | Top 50% |
| Total Return 10Y | Top 50% |
| Total Return 1Y Rank | 1 – 10 |
| Total Return 3Y Rank | 1 – 10 |
| Total Return 5Y Rank | 1 – 10 |
| Total Return 10Y Rank | 1 – 10 |
| Tracking Error 1Y | below 10 |
| Tracking Error 3Y | below 10 |
| Metric | Value |
|---|---|
| Total Return 1Y | Top 50% |
| Total Return 3Y | Top 50% |
| Total Return 5Y | Top 50% |
| Total Return 10Y | Top 50% |
| Metric | Value |
|---|---|
| Total Return 1Y | Top 50% |
| Total Return 3Y | Top 50% |
| Total Return 5Y | Top 50% |
| Total Return 10Y | Top 50% |
| Total Return 1Y Rank | 1 – 10 |
| Total Return 3Y Rank | 1 – 10 |
| Total Return 5Y Rank | 1 – 10 |
| Total Return 10Y Rank | 1 – 10 |
| Tracking Error 1Y | below 10 |
| Tracking Error 3Y | below 10 |
| Metric | Value |
|---|---|
| Total Return 1Y | Top 50% |
| Total Return 3Y | Top 50% |
| Total Return 5Y | Top 50% |
| Total Return 10Y | Top 50% |
| Total Return 1Y Rank | 1 – 10 |
| Total Return 3Y Rank | 1 – 10 |
| Total Return 5Y Rank | 1 – 10 |
| Total Return 10Y Rank | 1 – 10 |
| Tracking Error 1Y | below 10 |
| Tracking Error 3Y | below 10 |
| Metric | Value |
|---|---|
| Total Return 3Y | Top 50% |
| Total Return 5Y | Top 50% |
| Total Return 10Y | Top 50% |
| Total Return 1Y Rank | 1 – 10 |
| Total Return 3Y Rank | 1 – 10 |
| Total Return 5Y Rank | 1 – 10 |
| Total Return 10Y Rank | 1 – 10 |
| Tracking Error 1Y | below 10 |
| Tracking Error 3Y | below 10 |
Dashboard
Overview
CompaniesYour firm
$24.26B across top fund families
$24.26B
$15.47B invested in target date funds
$15.47B
$28.45B invested in active funds
$28.45B
44% pass
44%
What it shows
01
The whole book on one page.
Total assets, plans, and users, with the fund families, categories, active and passive split, and score ranges behind them.
02
Every fund held, scored and accounted for.
Every investment across the book with its score, rating, action, category, peer group, fund family, and assets, and the funds on Watch or Removal counted at the top.
03
Every recordkeeper and fund family, by assets.
Each recordkeeper with its plans, participants, investments, assets, and share of the book. The fund families on the Overview are the DCIO side of the same picture.
04
The criteria every fund is held to.
Choose a scorecard and see its metrics and thresholds for each asset class side by side, from allocation to money market. Modify it from the same screen.
Working the data
Pick one firm or several, and every total, chart, and table on the Dashboard follows the selection.
Every table filters by column and pages up to 500 rows at a time, so a long list stays workable.
Drag a column into the grouping bar to group investments by category, peer group, fund family, or rating.
Export a table to a spreadsheet, or generate reports from the Dashboard without opening each plan.
Bring your firm to a walkthrough and see its plans, recordkeepers, fund families, scores, and funds on one Dashboard.
