Private Wealth Management Asset Model Excel Template
đź’Ľ
Private Wealth Management Asset Model Excel Template
Improve your private wealth management with our comprehensive Excel template. Tailor investments, monitor portfolio performance, and align strategies to client's needs.
1
Establish engagement scope and ownership
2
Confirm privacy and records handling
3
Document client goals and time horizons
4
Capture financial profile and liquidity needs
5
Assess investment knowledge and risk profile
6
Inventory holdings accounts and exposures
7
Identify constraints conflicts and restrictions
8
Resolve material conflicts and exceptions
9
Analyze current portfolio and account fit
10
Evaluate reasonable alternatives and costs
11
Build target allocation and implementation plan
12
Document best interest recommendation rationale
13
Complete independent compliance review
14
Approval: Investment proposal
15
Record client informed decision
16
Implement authorized portfolio transactions
17
Verify outcome and schedule next review
Establish engagement scope and ownership
Confirm the exact service relationship, account scope, responsible adviser, and independent reviewer before collecting or evaluating client information. Use the firm's approved engagement and disclosure records; do not assume that advisory, brokerage, or family-office obligations are interchangeable. Resolve missing ownership or an unclear service model before proceeding.
1
Investment advisory relationship
2
Brokerage recommendation relationship
3
Dual advisory and brokerage relationship
4
Family office engagement
5
Other documented service model
Confirm privacy and records handling
Confirm that nonpublic personal information will be collected, shared, stored, and disposed of through approved systems. Record the privacy notice and authorization basis, apply least-access handling, and escalate suspected unauthorized access through the firm's incident-response procedure rather than placing sensitive identifiers in free-text fields.
1
Delivered and acknowledged
2
Delivered acknowledgment pending
3
Previously delivered and current
4
Not yet delivered
5
Exception documented by compliance
1
Secure client portal
2
Approved document management system
3
Custodian record system
4
Encrypted firm storage
5
Other compliance-approved repository
1
No concern identified
2
Potential issue under review
3
Confirmed incident escalated
4
Client notification in progress
5
Resolved under incident plan
Document client goals and time horizons
Translate the client's objectives into specific uses of capital, priorities, target dates, and success measures. Separate near-term liquidity needs from long-horizon growth or legacy objectives. Record conflicts between goals and identify which objectives may need revision before a recommendation is prepared.
1
Capital preservation
2
Current income
3
Long-term growth
4
Retirement funding
5
Education funding
6
Major purchase funding
7
Philanthropic giving
8
Intergenerational wealth transfer
1
Less than one year
2
One to three years
3
Three to seven years
4
Seven to fifteen years
5
More than fifteen years
Capture financial profile and liquidity needs
Build a current, evidence-supported profile using approved source documents. Capture income, investable assets, liabilities, taxes, cash-flow needs, and foreseeable withdrawals. Treat estimates as estimates, note material gaps, and pause recommendation work when incomplete information could change the outcome.
1
Taxable individual account
2
Tax-deferred retirement account
3
Tax-exempt account
4
Trust or estate structure
5
Entity or institutional account
6
Multiple account types
Assess investment knowledge and risk profile
Assess willingness to accept loss separately from financial capacity to bear loss. Consider experience, concentration exposure, horizon, liquidity, dependents, and the consequences of a drawdown. Reconcile inconsistent answers with the client and preserve the rationale for the final profile.
1
No prior investment experience
2
Limited basic product experience
3
Moderate diversified portfolio experience
4
Advanced complex product experience
5
Professional investment experience
1
Very low
2
Low
3
Moderate
4
High
5
Very high
1
Very limited
2
Limited
3
Moderate
4
Substantial
5
Very substantial
Inventory holdings accounts and exposures
Create a complete inventory across in-scope accounts, including cash, public securities, private assets, liabilities, restrictions, tax lots, and externally managed holdings. Reconcile totals to custodian or approved source records and flag stale valuations or assets that cannot be independently verified.
1
Fully reconciled
2
Reconciled with immaterial differences
3
Material difference under review
4
External holdings not verified
5
Source records incomplete
Identify constraints conflicts and restrictions
Identify client restrictions and every material conflict that could affect the recommendation, including compensation, proprietary products, affiliates, rollover incentives, account-type choices, illiquidity, tax limits, legal restrictions, and environmental or values preferences. Disclosure alone may not resolve a conflict; document avoidance or mitigation where required.
1
Liquidity reserve requirement
2
Tax realization limit
3
Legal or trust restriction
4
Restricted security or employer stock
5
Concentration reduction limit
6
Environmental or values preference
7
Currency or jurisdiction restriction
8
No additional constraint
1
Compensation or fee conflict
2
Proprietary product conflict
3
Affiliate or related-party conflict
4
Rollover or account-type incentive
5
Limited product menu conflict
6
Personal trading conflict
7
No material conflict identified
1
No material conflict
2
Disclosed and effectively mitigated
3
Escalation required
4
Recommendation prohibited
5
Review pending
Resolve material conflicts and exceptions
Route unresolved, prohibited, or pending conflicts to the designated compliance owner. Record the decision, required mitigation, affected recommendation, and evidence of completion. Do not advance a conflicted recommendation until the reviewer confirms that it may proceed under firm policy.
1
Approved with mitigation
2
Approved with enhanced disclosure
3
Recommendation redesigned
4
Recommendation withdrawn
5
Further legal review required
Analyze current portfolio and account fit
Evaluate whether the current accounts and holdings support the documented objectives, risk profile, liquidity, tax context, and restrictions. Assess diversification, concentration, costs, account type, cash drag, and implementation constraints. Distinguish observed facts from assumptions and cite the valuation date used.
1
Asset allocation mismatch
2
Excess concentration risk
3
Insufficient liquidity
4
Excessive cost or complexity
5
Tax inefficiency
6
Account type mismatch
7
Unmanaged external exposure
8
No material gap identified
Evaluate reasonable alternatives and costs
Compare the proposed strategy with reasonably available alternatives. Evaluate risks, expected role in the portfolio, liquidity, direct and indirect costs, tax effects, product complexity, and account-level consequences. Do not rely on past performance alone, and explain why a lower-cost or less complex alternative was or was not selected.
1
Retain current account structure
2
Open advisory account
3
Open brokerage account
4
Use coordinated account types
5
No account change recommended
Build target allocation and implementation plan
Define the target allocation, permitted ranges, funding sources, transaction sequence, tax-sensitive constraints, and rebalancing method. Ensure allocation percentages are internally consistent and that the implementation plan respects liquidity needs and client restrictions. Note any staged trades or dependencies.
1
Calendar based review
2
Tolerance band review
3
Cash-flow directed rebalancing
4
Tax-aware opportunistic review
5
Combined calendar and tolerance review
Document best interest recommendation rationale
Create the decision record connecting the recommendation to the verified client profile, risks, rewards, costs, alternatives, conflicts, and account choice. State material assumptions and disadvantages in plain language. The record should allow an independent reviewer to reconstruct why the recommendation was considered in the client's best interest.
Complete independent compliance review
Independently review the complete proposal for client-profile completeness, suitability or best-interest support, costs, alternatives, conflicts, disclosures, privacy handling, and policy exceptions. Return incomplete work with specific conditions. Record review evidence without substituting the review for the client's informed decision.
1
Approved for client presentation
2
Approved with documented conditions
3
Returned for adviser revision
4
Escalated for legal review
5
Not required under firm policy
Approval: Investment proposal
Will be submitted for approval:
Document client goals and time horizons
Will be submitted
Capture financial profile and liquidity needs
Will be submitted
Assess investment knowledge and risk profile
Will be submitted
Inventory holdings accounts and exposures
Will be submitted
Identify constraints conflicts and restrictions
Will be submitted
Analyze current portfolio and account fit
Will be submitted
Evaluate reasonable alternatives and costs
Will be submitted
Build target allocation and implementation plan
Will be submitted
Document best interest recommendation rationale
Will be submitted
Complete independent compliance review
Will be submitted
Record client informed decision
Present the recommendation, disclosures, costs, risks, alternatives, and conflicts in understandable language and allow the client to ask questions. Record the client's decision and any requested changes. Do not treat silence, an internal approval, or a preselected option as client authorization.
1
Accepted as presented
2
Accepted with documented changes
3
Deferred pending more information
4
Declined recommendation
5
No response recorded
Implement authorized portfolio transactions
Implement only the transactions and account actions the client authorized, following the approved sequence and firm controls. Seek best execution where applicable, record trade or transfer exceptions, and stop if prices, availability, taxes, restrictions, or client instructions materially change the approved plan.
1
Completed as authorized
2
Partially completed with exception
3
Pending settlement or transfer
4
Paused for client reconfirmation
5
Cancelled before execution
Verify outcome and schedule next review
Verify that the recorded outcome matches the client's decision: reconcile executed activity when authorized, or document non-implementation when deferred or declined. Confirm records are stored in the approved repository, note open exceptions, communicate the final status, and schedule the next review based on the relationship scope and material change triggers.
Optional cookies and similar technologies support analytics, advertising and visitor identification, and embedded content. Change or withdraw consent in Cookie settings. Cookie policy.
