Welcome! This guide walks you through every part of the Wealth Management & Advisory OS — what each database does, how they connect, and the day-to-day workflows for running an advisory practice. Read it once top to bottom, then keep it as a reference.

</aside>

1. What's inside

The system is built on 9 interconnected databases. Every record links to related records, so you can navigate from a household to its accounts, from an account to its holdings, and from a client to their fees and meetings — without duplicate data entry.

Database	What it holds	Key connections
Households & Clients	Your CRM: every client and prospect household, risk profile, tier, review cadence	Accounts, Financial Plans, Fees, Meetings
Accounts	The hub: each managed account (brokerage, IRA, trust, 529…) with custodian and strategy	Household, Holdings, Model Portfolio, Fees
Holdings	Line-item positions with quantity, cost basis, and current price	Account
‣	Retirement, education, estate, tax, and comprehensive plans with funding progress	Household, Funding Accounts, Meetings
Fees & Payments	Every money movement in AND out: AUM fees, retainers, deposits, withdrawals	Household, Account
Meetings & Reviews	Discovery calls, onboarding, annual and quarterly reviews with follow-ups	Household, Financial Plan, Tasks
Documents	IPS, advisory agreements, KYC/AML, quarterly reports, meeting notes	Household, Account, Plan, Meeting
‣	Firm-wide to-dos with priority, assignee, and due-date alerts	Household, Account, Plan, Meeting
Model Portfolios	Reference library of target allocations by risk level, with a 100% balance check	Accounts

<aside> 💡

No manual math. Total AUM, Current Value, Net Contributions, Funding Progress, and Unrealized G/L are all computed automatically from linked records. Keep the relations filled in and the numbers stay correct.

</aside>

2. Getting started (15 minutes)

Review the Model Portfolios. Open Model Portfolios and adjust the four sample strategies (or add your own). The Allocation Check formula confirms each one totals 100%.
Add your first household. In Households & Clients, create a new entry — the Household Template loads automatically with linked views for accounts, plans, fees, meetings, documents, and tasks.
Open their accounts. Add each managed account in Accounts, link it to the household, and pick its model strategy.
Load holdings. Add positions in Holdings with quantity, cost basis, and current price. Account values and household AUM update instantly.
Log the money. Every fee, deposit, and withdrawal is one row in Fees & Payments — set Direction (In/Out), link the household, and the dashboards take care of the rest.
Delete the sample data. The template ships with a realistic sample practice (the Whitfields, Harrington Trust, and friends) so you can see everything working. Once you've explored, delete the sample rows in each database.

3. Core workflows

Onboard a new client

Add the household at Status Prospect, then move them through the Client Pipeline board: Prospect → Onboarding → Active.
File their Risk Questionnaire, Advisory Agreement, and KYC / AML in Documents — anything awaiting a signature shows in the Awaiting Signature view.
Create their Financial Plan, link the funding accounts, and track Funding Progress toward the target amount.
Open their accounts (Status: Opening → Active when funded) and set a Next Review Date — the Review Alert counts down automatically.

Bill clients & track money

Quarterly AUM fees: one row per household per quarter (Type: AUM Fee, Direction: In, Status: Scheduled). When collected, set Status to Paid and fill Paid Date.