Skip to main content

Net Worth Value Add: How Your Net Worth Report Is Built

How 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.

Last reviewed: September 2026.

The Net Worth Value Add is a one-page balance sheet for a household. It lists the household's assets and liabilities, splits them by owner, and prints an estimated net worth.

This article explains every section of the report, where each number comes from, and what you can change.


What Is the Net Worth Value Add?

Requires the Pro plan. The Net Worth Value Add is off by default for every firm.

To turn it on, go to Settings › Value Adds, switch on the toggle on the Net Worth card, and click Save Changes. Only admins can change these settings. On the Free plan the toggle switches back off and an upgrade window opens.

The report:

  • Lists household assets in three tables: Cash / Cash Equivalent, Investable Assets, and Other Assets.

  • Lists household liabilities in two tables: Liability Type (secured debt) and Other Liabilities (unsecured debt).

  • Prints the estimated net worth: total assets minus total liabilities.

  • Splits every row into a column per client plus a Joint column.

SurgeTK builds it from four sources: accounts, physical assets, life insurance cash values, and liabilities. It rebuilds the live report every time you open it.


1. Header and Branding

  • Pulled from the company logo saved under Settings › Firm Info.

  • If no logo is saved, the report prints without one.

Branding color

  • Uses the Firm Branding Color from Settings › Firm Info.

  • The default is a dark gray.

  • It colors a thin rule line on the report and the dots between the footer items.

Report title

  • Default title: "Net Worth Report".

  • Change it under Settings › Value Adds › Net Worth › Show Settings › Net Worth Title. The title applies to every household.

  • If you save the title blank, the report prints "Net Worth Summary".

  • Admins can also rename it in place: turn on Annotations on the report page and open the marker on the title.


2. Reported "As-Of" Date

  • The header prints "Reported as of" followed by a date in M/D/YYYY format, for example "2/4/2026".

  • It is the latest As Of Date found on any account in the household. Closed accounts count too.

  • If no account has an As Of Date, today's date is used.

  • You cannot type this date on the report. To change it, update the As Of Date on the accounts.


3. Client Name Line

  • Built from the clients in the household. Each client's age prints as a small superscript. A client with no date of birth shows "--".

  • One client: "Last, First".

  • Two clients with the same last name: "Last, First1 & First2".

  • Two clients with different last names: "Last1, First1 & Last2, First2".

  • Three or more clients: "Last, First +2 more".

  • Deceased clients are left out when at least one living client exists.


4. Report Layout

A light green box at the top shows the net worth amount above the label "ESTIMATED NET WORTH".

Left column: Assets

The heading "Assets" shows the total of all assets. Below it are three tables, from most liquid to least: Cash / Cash Equivalent, Investable Assets, and Other Assets.

Right column: Liabilities

The heading "Liabilities" shows the total of all debts. Below it are two tables. Liability Type holds secured debt. Other Liabilities holds unsecured debt. The headers do not say "Secured" or "Unsecured".

Owner columns

  • Two clients: each table has four columns. The item, the first client's first name, the second client's first name, and Joint.

  • One client: two columns only. The second client column and the Joint column are hidden.

  • No clients, or three or more clients: the headers read "Client1" and "Client2", plus Joint.

  • Every table ends with a bold Total row. An empty table still prints a Total row of $0.


5. The Net Worth Formula

Net Worth = Total Assets minus Total Liabilities

Total Assets is the sum of three parts:

  • Accounts: the Account Value of every included account.

  • Physical assets: the Asset Value of every physical asset owned by a client in the household.

  • Life insurance cash value: the cash value of every included policy.

Total Liabilities is the sum of the Outstanding Balance of every included liability.


6. Four Data Sources

Each source adds a different value and label to the report.

Source

Value used

Label on the report

Where to edit

Accounts

Account Value

The account type plus the last 4 digits of the account number, for example "Traditional IRA - 1234". Only digits count toward the last 4.

Household › Accounts tab › open the account › Details

Physical assets

Asset Value

The Asset Name. If blank, the Asset Type. If both are blank, "Physical Asset". Always in Other Assets.

Household › Physical Assets tab

Life insurance

Cash value, never the Face Amount

"Life Insurance - 1234" (the last 4 digits of the Policy Number), or "Life Insurance" when the policy number has no digits. Always in Other Assets.

Household › Insurance tab

Liabilities

Outstanding Balance

The Liability Name. If blank, the Liability Type. If blank, the Creditor Name. If all are blank, "Other Liability".

Household › Liabilities tab

Which life insurance policies are included

A policy is included only when all three are true:

  1. The Has Cash Value box is checked on the policy.

  2. The cash value is above $0.

  3. The policy Status is not Closed, Lapsed, Expired, Surrendered, or Terminated.

The Has Cash Value box is checked by default when the Policy Type is Permanent, and unchecked when it is Term. The box decides, not the policy type. A Term policy with the box checked is included. A Permanent policy with the box unchecked is left out.

Why cash value and not face amount? Net Worth shows what the household could access today. The cash value is what the policyholder could receive by surrendering the policy now. The Beneficiary report uses the face amount instead, because it shows what beneficiaries would receive.

Which physical assets are included

  • A physical asset appears when at least one of its owners is a client in the household.

  • Choosing Joint as the Owner saves every client in the household as an owner.

  • An asset with no owner does not appear.

Which liabilities are included

  • A liability appears when its Owner is a client in the household, or Joint.

  • A liability with no owner is left off the report.


7. How Accounts Are Categorized

SurgeTK reads the account's Account Type. If that is blank or "Other", it reads the raw type that came from your import or CRM. If both are blank or "Other", the type is "Other".

It then tests the type against the patterns below, in this order. The first match wins. Words must match as whole words. Upper and lower case do not matter.

Step

Category

Account types that match

1

Investable Assets (tested first)

QCD IRA, DASCG, HSBA, LTC, CRA; Retirement Plan; Health Savings or HSA; Brokerage; Individual; Joint or Joint Tenants; Tenants in Common; Community Property; Transfer on Death or TOD; Custodial, UTMA, or UGMA; Corporate, Partnership, LLC, or Sole Proprietorship; 401(a), 401(k), 403(b), 457(b); TSP or Thrift Savings Plan; Pension; Profit Sharing; Keogh; Inherited IRA; Roth IRA; SEP IRA; SIMPLE IRA; Rollover IRA; Beneficiary IRA; Traditional IRA; any other type containing the word IRA; 529; Coverdell or ESA; Trust; Donor-Advised Fund; Charitable Remainder Trust or Charitable Lead Trust; Endowment, Foundation, or Municipal; Annuity or RILA

2

Cash / Cash Equivalent (tested only when no investable pattern matched)

Checking; Savings; Money Market; Certificate of Deposit or CD; Cash

3

Other Assets

Everything else. Examples: "Mutual Fund", "Retirement Account", "Other"

HSAs and "QCD IRA"

  • A Health Savings Account goes to Investable Assets, not Cash. The HSA pattern is tested before the Savings pattern.

  • "QCD IRA" goes to Investable Assets. It is tested first, so the "CD" cash pattern never catches it.

Note: 529, Coverdell, ESA, Custodial, UTMA, and UGMA accounts are removed from the report before this step (see section 10). They reach this step only when you include them from the account's Exclusions tab.


8. How Liabilities Are Categorized

Each liability goes to the Liability Type table (secured) or the Other Liabilities table (unsecured) based on keywords.

Category

Keywords

Secured (prints in Liability Type)

mortgage, home equity, HELOC, auto, car, vehicle, truck, motorcycle, RV, boat, yacht, equipment, tractor, property, real estate, land, home loan, construction, secured, collateral

Unsecured (prints in Other Liabilities)

credit card, card, charge card, store card, personal loan, signature, unsecured, student, education, medical, collections, collection, tax, IRS, utility, payday, line of credit

Keywords match as whole words. Upper and lower case do not matter. Extra spaces inside a keyword are fine.

Which fields are checked

  1. The Liability Type is checked first. HELOC and home equity always count as secured. Then the secured keywords are tested, then the unsecured keywords.

  2. The Liability Name and Creditor Name are checked only when the type is blank or generic. A generic type contains the word "other", "loan", "debt", or "liability", for example "Business Loan".

  3. A specific type with no keyword, for example "Legal Settlement", goes straight to Other Liabilities. The name and creditor are not checked.

Default

When no keyword matches, the liability is unsecured and prints in Other Liabilities. Unrecognized items stay visible for review instead of being placed with secured debt.

HELOC

A Home Equity Line of Credit is secured, even though it contains "line of credit". The HELOC and home equity check runs before every other keyword.


9. Ownership Columns

Every account, physical asset, insurance policy, and liability is placed in one column by its owners.

Owners

Column

Exactly one owner, and it is the first client

The first client's column

Exactly one owner, and it is the second client

The second client's column

Exactly one owner, and it is a third client in the household

Joint

Two owners

Joint

No owners, or three or more owners

Joint

  • The first and second client are the first two client records in the household, in the order they were added. They are not sorted by name.

  • A deceased client still gets a column.

  • For insurance, the policy's Owner field decides the column.


10. Account Inclusion and Exclusion

Net Worth has its own rules. They differ from Guardrails, Buckets, and Beneficiary.

Accounts that are included

  • Cash accounts. Checking, savings, money market, CD, and cash accounts print in Cash / Cash Equivalent. Guardrails and Buckets leave them out, but a balance sheet needs them.

  • Inherited IRAs and beneficiary IRAs. They print in Investable Assets.

  • Accounts typed "Other". They print in Other Assets.

  • Accounts with no value entered. A blank value is not the same as $0. The account stays on the report and adds $0.

Accounts that are excluded

  • Closed accounts. An account is closed when its Date Closed is set, or its Account Status is Closed, Transferred, or Inactive.

  • Open accounts with exactly $0.

  • Education, custodial, and court-supervised types: 529, Coverdell, Educational Savings, ESA, Custodial, UTMA, UGMA, Guardianship, and Conservatorship. Any type containing one of these words is excluded, so "Custodial Roth IRA" is excluded too.

  • Accounts with no account type. See below.

Accounts with no account type

An account with no type in any type field is left off the report. The report prints a footnote above the footer, for example: "*1 account totaling $12,000 is not included above — no account type is set." SurgeTK also records a warning on the Value Add. It names the account by its last 4 digits and says to set the account type, or include the account from its Exclusions tab.

An account typed "Other" is not blank. It prints in Other Assets.

Manual override: the Exclusions tab

Open the account and go to the Exclusions tab. Under Value Adds, each Value Add has a dropdown with Automatic, Always include, and Always exclude. There is also a switch, Exclude from all value adds — including ones added in the future. A per-Value-Add setting always wins over Exclude from all.

  • A manual choice wins over every rule above. Always include pulls a closed, $0, blank-type, or education account back onto the report.

  • The tab shows the reason for the current decision, for example "Counted in net worth", "Closed account", "$0 account value", "No account type set", "Education/custodial account type", "Manually included", or "Manually excluded".


11. Common Questions

Why doesn't the net worth match what I expect?

Check these first:

  • Closed and $0 accounts are left out. Reopen the account or enter a value if that is wrong.

  • Education and custodial accounts are left out. 529, Coverdell, ESA, UTMA, UGMA, guardianship, and conservatorship accounts do not appear. This includes "Custodial Roth IRA".

  • An account has no type. Look for the footnote above the footer. Set the Account Type.

  • Life insurance uses cash value. Only policies with Has Cash Value checked, a cash value above $0, and an open status appear. The face amount is never counted.

  • A liability or physical asset has no owner. It is left off. Set the Owner.

  • A liability is in the wrong table. Secured or unsecured is decided by keywords. See section 8.

  • The household page shows a different total. The household page's Total Investable Assets figure follows the assets-under-management rule, which leaves out cash accounts. Net Worth includes them. The two figures are not meant to match.

Why is a liability showing as unsecured when it should be secured?

The Liability Type had no secured keyword. If the type is specific, the name and creditor are not checked at all. Change the Liability Type to one that contains a secured keyword, such as "Mortgage" or "Auto Loan".

Why don't I see a life insurance policy on the report?

One of three reasons: the Has Cash Value box is not checked, the cash value is $0 or blank, or the policy status is Closed, Lapsed, Expired, Surrendered, or Terminated. Term policies appear only when the box is checked and a cash value is entered.

Why are there only two columns instead of four?

The household has one client. The second client column and the Joint column are hidden.

Why do the headers say "Client1" and "Client2"?

The household has no clients, or it has three or more. With three or more clients, the first two get columns. Anything owned only by a third client prints in Joint.

Why is a single-owner item in the Joint column?

The owner is not the first or second client, or the item has no owner, or it has three or more owners. An account with no owner prints in Joint.


12. Firm-Level Configuration

All settings live under Settings › Value Adds › Net Worth. Click Show Settings to open the fields, then Save Changes. Only admins can save.

Setting

What it does

Default

The toggle on the card

Turns the Net Worth Value Add on or off for the whole firm. Requires the Pro plan.

Off

Net Worth Title

The title printed at the top of every Net Worth report.

"Net Worth Report". A blank title prints "Net Worth Summary".

Net Worth Disclaimer

Custom text placed inside the footer disclaimer.

"THIS NET WORTH REPORT IS NOT COMPLETE WITHOUT ALL THE ACCOMPANYING DISCLAIMERS!..."

There are no rate settings. The report is built only from account values, asset values, insurance cash values, and liability balances.

Blank disclaimer: if you clear the disclaimer and save, the report prints only the standard sentences. The settings page then shows "Default disclaimer for Net Worth Value Add..." in the field. The next Save Changes stores that text and prints it.

Admins can also edit the title and disclaimer in place from the report page with Annotations. Those edits are firm-wide too.


13. Footer and Disclaimer

The footer prints the firm Address, Phone Number, and Firm Website URL from Settings › Firm Info. Blank fields are skipped. A small dot in the branding color separates the items.

Disclaimer

  • The disclaimer has three parts, all printed in upper case: "Generated for the clients of" followed by the household's lead advisor names, then your Net Worth Disclaimer text, then "Value Add copyright SurgeTK, All rights reserved."

  • Two or more advisors are joined with "and".

  • If the household has no lead advisor, the disclaimer prints "NO ADVISORS ASSIGNED" in red.


In Summary

  • A complete balance sheet. Accounts, physical assets, life insurance cash value, and liabilities in one view.

  • Owner-aware. Every row lands in a client column or Joint.

  • Automatic categories. Assets go to Cash, Investable, or Other. Liabilities go to secured or unsecured. Both use type keywords.

  • Firm-customizable. Title and disclaimer are set in Settings.

If a number looks wrong, check for closed or $0 accounts, education and custodial types, blank account types, insurance without cash value, and liabilities or assets with no owner.


Related articles

Did this answer your question?