Working with Clients

Financials

Track the assets, debts, income, and net worth that make up a client's financial picture.

Introduction

The Financials page is where you record a client's money picture: what they earn, what they own, and what they owe. Every entry you make here flows into the financial health score on the overview. It also feeds the needs analysis and the forward projections DNA draws for that client.

What the page shows

The Financials page is a single scrolling layout with four sections, top to bottom.

Income and employment details

The top section captures each client's earned income, passive income, employment type, retirement age, pension status, and CPP or QPP contributions. For group clients, each member has their own block. An empty block shows No financial details with an Add button. A filled block shows the data and an Edit button.

Summary cards

Three cards sit below the income section:

  • Total Assets: the sum of every asset's current value. A green sparkline projects the next 10 years.

  • Total Debts: the sum of every debt's balance. A red sparkline projects remaining debt, drawing it down at each debt's expected payoff pace.

  • Net Worth: Total Assets minus Total Debts. A blue sparkline projects net worth forward using asset growth rates and debt paydown combined.

Assets

Below the summary cards is the assets table. It supports search by name, filtering by asset type, sorting by any column, and pagination at 10 per page. Each row shows the asset's name, type, current value, and a menu to view, edit, or delete it.

Debts

The debts table sits at the bottom with the same layout and controls. Each row shows the debt's name, type, balance, and the same row-level menu.

Adding and managing assets

Click Add Asset to open the asset form. Pick an asset type first, since some fields only appear for specific types.

Asset types

Type

Typical use

Cash

Chequing, savings, and money-market balances. Marked liquid by default.

Business

An equity interest in a privately held business.

Registered accounts

RRSPs, TFSAs, RESPs, pensions, and other registered Canadian accounts.

Non-registered investments

Brokerage holdings outside a registered account.

Real estate

Primary residence, rental, or commercial property.

Other

Anything that does not fit the categories above.

Fields on an asset

Every asset needs a name and a current value. Current value must be greater than zero. The rest of the fields are optional:

  • Adjusted cost base: used on non-registered investments for capital gains tracking.

  • Growth rate: annual growth applied to the current value in the 10-year projection. Accepts negative numbers when the asset is expected to lose value.

  • Acquisition year: when the client first acquired the asset.

  • Year and month to be sold: when a sale is planned, the projection stops at that point.

  • Gross annual revenue: for business and real-estate assets that generate income.

  • Annual contribution amount: for registered accounts that receive ongoing contributions.

  • Is taxable and Is liquid: flags that influence the health score and needs analysis.

  • Linked debts: any debts secured by this asset, like a mortgage tied to a property.

Editing and deleting

Use the row-level menu on the assets table to view, edit, or delete an asset. Viewing opens the asset detail page, where you also see any linked debts and notes attached to the asset.

Adding and managing debts

Click Add Debt to open the debt form. The fields follow the same pattern as assets: required basics plus optional detail.

Debt types

Type

Typical use

Mortgage

A loan secured by real estate.

Credit card debt

Revolving balances on credit cards.

Line of credit

Secured or unsecured lines of credit.

Loan

Personal, student, auto, or other installment loans.

Lease

Vehicle or equipment leases.

Unpaid income tax

Balances owed to the CRA.

Other

Anything that does not fit the categories above.

Fields on a debt

  • Name, debt type, and balance: all three are required. Balance must be greater than zero.

  • Monthly payment: optional. Used in the liquidity factor of the health score.

  • Interest rate: optional.

  • Acquired date and Payoff date: optional. Used in the 10-year projection to draw down the debt at the right pace.

  • Linked asset: the asset this debt is secured by, if any.

Link debts to the assets they secure. A mortgage linked to a property helps the needs analysis understand what is protected and what is exposed.

Ownership on group clients

For group clients (couples, business partnerships, households), each asset and debt can be split across members. Ownership is recorded as percentages that add up to exactly 100% across the owners. You can also flag an owner as external, meaning someone outside the group holds a share. The summary cards, sparklines, and health score aggregate across every member.

How Financials feeds the rest of DNA

Data entered on Financials drives several other parts of the product:

  • Financial health score: on the client overview. All four factors (debt-to-asset, liquidity, coverage, diversification) pull from what you enter here.

  • Net worth projections: the 10-year sparklines on the summary cards use growth rates, acquisition years, and payoff dates to look forward.

  • Needs analysis: the report builder pulls income, assets, debts, and linked coverage when it calculates how much coverage a client needs.

On this page