How to Automate Addepar

Addepar is where the whole balance sheet lines up

Addepar is the portfolio data and reporting platform that wealth management firms, banks, family offices and fund managers use to see everything a client owns in one place. Not one account. Everything.

That distinction is the product. A family's balance sheet is rarely tidy: an operating company, three trusts, a couple of brokerage accounts at different custodians, a dozen private fund commitments at various stages of being called, property held through an LLC, and a foreign bank account somebody set up in 2011. Each of those reports differently, on its own calendar, in its own format.

Addepar's job is to make those add up to a number a principal can be told, and then to explain that number: what performance came from where, what is illiquid, what is committed but not yet called, and what changed since the last conversation.

It is the system of record that the client meeting, the fee calculation and the tax package all trace back to.

The reporting cycle waits on PDFs from fund managers

The public side of the balance sheet mostly looks after itself. The private side is where the quarter goes.

Capital account statements arrive several weeks after quarter end, one fund at a time. Some are emailed. Most sit in the manager's own investor portal, behind a separate login with its own password rules, and somebody has to go and get them. An analyst downloads forty PDFs, opens each one, and copies out the ending capital balance, the contributions, the distributions and the remaining unfunded commitment.

Around that sits everything else with no feed. The property manager's monthly operating statement. A life policy's cash value on an insurer portal. A foreign bank whose only interface is a login screen. A capital call notice with a wire deadline, sitting in an inbox nobody opened on Friday afternoon.

And the whole time, a principal can ask a question that assumes all of it is current.

Addepar

Quarterly statements collected on time Each fund manager's investor portal opened the week after quarter end, the capital account statement downloaded and filed against the right entity.

Notices caught the day they appear Capital calls and distributions found while the wire deadline is still comfortably ahead, not after somebody scrolls back through an inbox.

Exceptions worked, not just flagged The positions Addepar marks as unreconciled, checked against the custodian's own screen so the queue arrives with a reason attached.

Custodian feeds cover the assets that have feeds

Addepar automates a great deal of this, and the parts it covers are genuinely handled rather than half handled.

Data aggregation pulls positions and transactions from hundreds of custodians and normalises them, so the daily book builds itself. Reconciliation runs against that feed and flags exceptions automatically, which turns a checking job into a queue of things that actually disagree. Report templates are built once and deployed across hundreds of portfolios, so a branded quarterly pack for every client takes minutes rather than weeks. A client portal gives the family a live view of net worth between meetings. Navigator models scenarios on top of the book, so a question about a large sale can be answered with a projection instead of a promise.

The pattern in all of that is a feed on the other end. Where a custodian exists and connects, the work disappears.

The private side has no custodian. There is a general partner, an investor portal, a PDF and a quarterly calendar, and no amount of configuration inside Addepar reaches through a login screen to get it.

The private side can be collected on a schedule

Statements post on the managers' calendar, not the analyst's, and that calendar is the same every quarter.

Each fund manager's investor portal checked from the day statements usually post, the capital account statement downloaded, named to one convention, filed against the right entity, and the figures put in front of the operations team to post. Capital call notices caught the day they appear, listed with the fund, the amount and the wire deadline, so nobody discovers one on the due date.

The comparisons matter as much as the collecting. Distributions announced by a manager checked against what actually landed in the bank. The property statement's monthly figure against what is booked. Exceptions the reconciliation already raised, opened against the custodian's own screen so the queue arrives with a reason next to each line instead of just a flag. Subscription documents and side letters with dates in them, tracked before the renewal window closes.

One boundary is absolute here, and it is not a policy setting. None of this trades, rebalances, changes an allocation, or moves a dollar of client money. It reads, downloads, compares and drafts. Every decision about a portfolio stays exactly where it is now.

Nothing here moves a dollar or an allocation

That boundary is worth putting first, because in this business it is the only one anybody asks about. The gathering is the job that is safe to hand over, and it is also the job eating the analyst's quarter.

WebRun is an agent that works a real Chrome browser, signed in as you. It opens each investor portal, the bank, the insurer or the property manager's site, takes the statement, reads the figures and puts them where your operations team works.

It runs on your schedule in your own private environment, and a workflow can be locked to an explicit list of domains so it only reaches the sites you named. You can watch a run and stop it. Anything reaching a client is drafted and waits.

The workflows below are already built, and each one names the portals it opens.