Value Add Data & Calculations
A complete breakdown of how every Value Add is generated, calculated, and sourced.
9 articles
- Why a Client or Account Is Missing From a ReportA checklist for a missing household, client or account: advisor filter, archived households, CRM filters, the Exclusions tab, the automatic rules per report, and deceased clients.
- Tax Strategy Review (Roth Conversion Letter): How Your Letter Is BuiltHow the Tax Strategy Review letter is built: which 1040 lines feed each field, the bracket math, the default copy and data points, year selection, and firm settings.
- 1099 Value Add: How Your 1099 Report Is BuiltHow the 1099 Letter is built: tax year, salutation and variables, which accounts appear, how the Form column is decided, estimated tax payments, and the firm settings.
- Guardrails Value Add: How Your Guardrails Report Is BuiltHow SurgeTK builds the Guardrails report: as-of date, name line, Max Distribution Available, Current Distribution, the bar, the distribution table, account rules, settings and footer.
- Buckets Value Add: How Your Buckets Report Is BuiltHow SurgeTK builds the Buckets report: Total Assets, the four buckets, allocation tolerance, the six allocation sources, the distribution table, settings, footer and warnings.
- Beneficiary Value Add: How Your Beneficiary Report Is BuiltHow the Beneficiary report is built: summary tables, per-owner blocks, name formatting, the "Missing Beneficiaries" line, what is included, and the firm settings.
- Net Worth Value Add: How Your Net Worth Report Is BuiltHow the Net Worth report is built: the four data sources, how accounts and liabilities are categorized, owner columns, what is left out, and the firm settings.
- Meeting Worksheet (Homework): How Your Meeting Worksheet Is BuiltHow the Homework sheet is built: what is automatic, what you type, the RMD table rules, the meeting time zone, and the settings that control it.
- Where Monthly Income Comes From in Guardrails and BucketsWhy the Monthly Income and Current Distribution figures on Guardrails and Buckets are what they are: frequencies, $0 cases, which accounts count, and how to add or fix a withdrawal.