Reconcile portfolio transactions against custodian records and flag exceptions
Every morning, WebRun opens Addepar, compares the prior day's posted transactions against custodian feed data, identifies any reconciliation breaks or missing postings, logs them in a Google Sheets exception tracker, and posts a digest to the operations Slack channel.
- No credit card
- Under $0.01 per run
- Cancel anytime
How can I automatically reconcile Addepar transactions against custodian records and get a daily digest?
WebRun opens Addepar every morning, compares the prior day's transactions against custodian feed data, logs every break in a Google Sheets exception tracker, and posts a reconciliation digest to Slack with new breaks, total open items, and aged exceptions highlighted for your operations team.
- Reconciliation breaks surfaced every morning before the operations team arrives
- Aged breaks flagged automatically before month-end close
- Zero manual comparison between Addepar and custodian records
Built for family office operations teams · fund accountants · single family offices · multi-family office operations
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.addepar.comin a real browser with your saved login - no setup, no API keys. -
1
Addepar - compare transactions to custodian feed
addepar.com How to Automate Addepar
WebRun opens Addepar to compare transactions to custodian feed. - Open Addepar and navigate to the reconciliation view for the prior business day
- Compare each transaction posted in Addepar against the corresponding custodian data feed entry
- Identify any quantity, price, or settlement-date breaks
- Identify any transactions present in the custodian feed but not yet posted in Addepar
Done when All reconciliation breaks and missing postings for the prior day are identified.
-
2
Google Sheets - log exception breaks
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log exception breaks. - Open the daily reconciliation exception tracker sheet
- Append each break with date, account, security, expected value, posted value, and break type
- Update the rolling break count and flag any break older than 3 days as aged
Done when All breaks from the prior day are logged and aged items flagged in the tracker.
-
3
Slack - post daily reconciliation digest
slack.com How to Automate Slack
WebRun opens Slack to post daily reconciliation digest. - Post a reconciliation digest to the operations channel with a count of new breaks, total open breaks, and aged items
- List each new break with account, security, and break amount
- Include a link to the Google Sheets exception tracker for full details
Done when Operations team has the daily reconciliation digest in Slack with a link to the full tracker.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Which custodians can it reconcile against?
It works with any custodian whose data feed is connected to Addepar. Addepar aggregates data from a wide range of global custodians, so the run covers all accounts linked to your firm.
Does it auto-post or correct transactions in Addepar?
No. WebRun only reads and compares data. It never modifies, posts, or deletes transactions in Addepar. All corrections require a human to act on the exception list.
How does it handle aged breaks?
Any break outstanding for more than 3 days is flagged as aged in both the Google Sheets tracker and the Slack digest, so your team can prioritize resolution before month-end close.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.