Skip to Content
ToolsData Sorting Worksheet

Sorting Your Data

Use this worksheet to sort what the firm holds into four tiers, sort the tools it uses by what they do with your input, and fill in the grid where the two meet. It is the companion to Sort Your Data, which explains why the sorting comes before the tool; this page is where you write it down.

What this measures

This worksheet gathers two lists and crosses them: the information the practice holds, and the tools it signs in to. It produces no score — each pairing has a plain answer, not a degree.

The result is a data matrix: one page saying whether a kind of information may go into a kind of tool, and on what condition, written down before anybody is in a hurry.

Before you start

Work from what the practice actually does, not the policy you intend to write. Open the places client information already lives — client files, the mailbox, the shared drive, your notes — and the tools you and your assistant use.

Two ground rules before you fill anything in:

  • Sort the information, not the job. A tier belongs to a piece of information, not to the errand it is attached to. “Meeting prep” is not a tier; the transcript it starts from is client-identifying whether the errand feels clerical or not.
  • Read the terms, not the reputation. What a tool does with your input is set out in its own terms-of-service and data-handling pages, and in any agreement the firm has signed — not in its marketing. Those change on the vendor’s schedule, so check them as you fill in the second list — the Vetting a Vendor checklist covers what to look for.

What the firm holds

List every kind of information the practice holds, then put each into one of the four tiers below. Use those four and no more.

TierWhat it coversSomething the practice holds
PublicAlready published, with no client in itA page of the firm’s own website
InternalThe firm’s own material, with no client information in itA meeting-agenda template
Client-identifyingAnything that identifies a client or ties back to oneA review-meeting transcript
RestrictedClient-identifying information the firm has promised, in writing or by rule, to handle a set wayA file received under another party’s confidentiality terms

Two things go wrong here. The firm’s own notes and drafts about a client are client-identifying, not internal, however much they feel like the firm’s work. And a summary naming nobody still carries ages, balances, and circumstances: anything identifying a client on its own or in combination belongs in that third tier — this guide’s own plain-language category, not a regulator’s scheme.

What each tool does with your input

Now list every tool the practice signs in to, sorted by what happens to what you type, paste, or upload.

Tool categoryWhat it typically does with your inputWhere you confirm it
Consumer tier of a general-purpose toolOften keeps inputs, and may use them to improve the service unless that is switched offIts own terms and data-handling pages
Business tier of the same toolUsually contracts not to train the model on inputs, with some control over retentionThe same pages, plus the plan’s terms
Tool under a signed agreement, the vendor acting as the firm’s service providerWhatever the agreement sets, including which subprocessors it namesThe signed agreement
Advisor-specific platformUsually builds these commitments into the product itselfThe vendor’s terms, confirmed for your plan

Count the paths, not the products. An uploaded file, a connected mailbox or drive, a browser extension reading the screen, a note-taker joining a client call, and an automation platform moving data between tools all put information into a tool exactly as typing does. Each is its own row: a mailbox left off is a gap even though nobody typed a client’s name into a prompt. A tool nobody signed up for on the firm’s behalf is shadow IT, and belongs here for that reason.

Do not copy retention windows or plan-level limits into the matrix: they change when the vendor decides. Record where you checked and when, not the number.

The result

Cross the two lists: four tiers against four tool categories — consumer tier, business tier, signed agreement, advisor-specific platform. That is sixteen pairings, each needing an answer.

Information tierTool categoryAnswer
PublicConsumer tierYes
PublicBusiness tierYes
PublicSigned agreementYes
PublicAdvisor-specific platformYes
InternalConsumer tierYes
InternalBusiness tierYes
InternalSigned agreementYes
InternalAdvisor-specific platformYes
Client-identifyingConsumer tierNo — de-identify first
Client-identifyingBusiness tierNo — de-identify first
Client-identifyingSigned agreementYes, where the agreement covers this use
Client-identifyingAdvisor-specific platformYes, where its agreement covers this use
RestrictedConsumer tierNo
RestrictedBusiness tierNo
RestrictedSigned agreementOnly if the promise behind the restriction allows it
RestrictedAdvisor-specific platformOnly if the promise behind the restriction allows it

These answers are the guide’s: copy the grid, then change any cell your own reading of the terms contradicts. The business-tier and signed-agreement rows differ on who signed what — a business plan runs on public terms the vendor can revise alone, and a public terms page alone does not qualify for client-identifying information.

Where a cell reads de-identify first, write down what that means for that pairing. What goes in is then a different piece of information, sorted on its own. Removing a name is not removing the person: age, town, employer, and approximate account size together can identify a client as surely as a name can, in a practice of eighty households. The test for success: could someone who knows the practice pick the client out of what is left? If so, it is still client-identifying. Where identity cannot be separated from the question, the honest answer is not de-identification but a tool already cleared for that tier.

What the matrix does and does not tell you

The matrix says what may go where, before the question is live.

It does not clear a tool. A cell reading yes means the tier and the category are compatible on the terms you read; whether a specific product is worth using is what Vet and Choose Tools asks. It does not clear a use either — that was settled before this worksheet, on the use-case list the first step builds. And it says nothing about what you owe the client: the advice is the firm’s whatever drafted it, and no cell moves that.

One further limit, the one that bites: the matrix is true only on the day you fill it in.

What to do with it

Date it and keep it where the person who needs it will look — beside the tools, not in a folder nobody opens.

Re-check it on a trigger rather than a calendar: a new tool, a changed plan, a vendor’s notice that its terms have moved, a new person joining the firm. Keep each dated version rather than overwriting the last, so the firm can show what the rule was at the time. Where the matrix is a record the firm has to keep, how long it keeps it is set by rule rather than preference — see Records and Documentation in this year’s figures — and a state-registered adviser checks what its own state requires.

At a larger firm

At a larger firm the first list usually exists already, as a classification scheme in the information-security policy written before anyone considered AI tools. Find it rather than starting a new one, and map these four tiers onto its names instead of running two schemes side by side. Where the mapping leaves a gap, raise it with whoever owns that policy rather than settling it here.