Organize Custodian Statements When Clients Hold Accounts in Three Places
One household holds a joint account at one custodian, two IRAs at another and a trust account at a third. Every statement cycle produces three files named three different ways, none of which contain the family's name.
The short answer
Custodian downloads are named for the custodian's convenience, not yours — an account number, a date, sometimes a batch identifier. The household never appears. A workflow uses the Read Details from File step to pull the account number, the registration and the statement period off the first page, the Rename step to write the household, account and period into the filename, and the Move step to file it under that household. The result is that three custodians produce one client folder rather than three parallel filing systems.
Steps this uses
Before and after
What actually changes
As they arrive
- 20260930_4471.pdf
- stmt_sep26.pdf
- eDoc_0099231.pdf
- statement (3).pdf
After the workflow
- Okafor Household/Joint ...4471/2026-09-statement.pdf
- Okafor Household/IRA D Okafor ...9902/2026-09-statement.pdf
- Okafor Household/IRA M Okafor ...9903/2026-09-statement.pdf
- Reyes Household/Trust ...3310/2026-09-statement.pdf
Four downloads from three custodians, resolved into two households by the account numbers printed inside them.
Setting it up
Described once, then it runs
This is the sentence. Send it to the builder and the steps below appear on a canvas, wired and named, for you to change before anything runs.
When a custodian statement arrives, read the account number, the registration and the statement period off the first page, rename it with the household, account and period, and file it under that household.
Household, then account
Advice is given to a household and reporting happens per account, so both levels are needed. Filing by account alone means reassembling a family every review; filing by household alone means hunting inside it.
Map account numbers to households once
This is the piece that does the work. The statement carries the account number reliably; connecting that number to a household is a mapping you supply, after which every future statement files itself.
Name by statement period
Not the download date. The period is what a review or a reconciliation is done against, and putting it first in ISO form turns an account folder into a timeline.
Notice a missing cycle
Statements arrive on a schedule, so a gap is a fact rather than a possibility. Once every statement is named by its period an account folder reads as an unbroken run, and a missing cycle stands out in the listing — usually a sign a custodian feed or a delivery preference changed.
The account number is the only reliable identifier
Client names on statements are registration names, and they vary — "OKAFOR DANIEL J" on one custodian, "Daniel Okafor TTEE" on another, "Okafor Family Trust U/A DTD" on a third. Matching on names produces near-misses and duplicate folders. The account number does not vary, which is why the mapping from account to household is worth building once and why everything after it is reliable.
A household is not a person
The unit an advisor actually serves is a family: two people, joint and individual accounts, a trust, maybe a business. Filing per individual splits that relationship in a way that shows up at every review meeting, because the conversation is about the household and the folders are about people. Making household the top level costs nothing and matches the work.
What it does not do
It files and finds statements. It does not aggregate positions, calculate performance, reconcile against a portfolio system, or satisfy regulatory recordkeeping obligations — those carry specific storage and retention requirements and belong to a dedicated archiving vendor. This is the working paperwork of the practice.
FAQ
Common questions
How should advisors organize client statements?
Household first, then account, with each statement named by its period in ISO form. The household is the unit advice is given to and the account is the unit reporting happens in, so both levels are needed — and keeping the household on top is what stops one family being split across several folders.
How do you handle clients with multiple custodians?
By reading the account number off the statement rather than trusting the filename, and mapping account numbers to households once. Every custodian names downloads differently and none of them include the client, so the filename is the one thing that cannot be used.
Why not match on the client name?
Because registration names vary between custodians — an individual name at one, a trustee designation at another, a full trust title at a third. Matching on names creates near-duplicates that silently split a household. Account numbers do not vary.
Is this a regulatory recordkeeping system?
No. Regulatory retention obligations carry specific requirements around non-rewriteable storage and furnishing records, and a dedicated archiving vendor handles those. This organizes the practice's working documents so they can be found, which is a different job.
Three custodians, one household.
Resolved by the account number printed inside, not the name on the download.
5 GB free · No credit card required