Automated Bakkt Custody Balance Reconciliation
Every morning, WebRun opens Bakkt, reads custody balances by asset, compares each against your internal Airtable ledger, and logs any mismatch to a Notion reconciliation log so your ops team has a clear, dated record to investigate.
How do I reconcile Bakkt custody balances against my internal records automatically?
WebRun compares your Bakkt custody balances against your internal Airtable ledger every morning, asset by asset, accounting for anything still pending settlement. Any mismatch gets logged to Notion with both balances and the difference, so your ops team has a clear, dated record to investigate, and clean days are noted just as clearly.
- Balance mismatches surface the same morning they appear, not at month end
- Ops gets a dated Notion record of every check, clean or not
- The internal ledger and Bakkt stay comparable without a manual daily pull
Built for crypto ops teams · finance teams · Bakkt institutional clients · custody 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
www.bakkt.comin a real browser with your saved login - no setup, no API keys. -
1
Bakkt - read custody balances
bakkt.com
WebRun opens Bakkt to read custody balances. - Open Bakkt and review custody account balances by asset
- Capture each asset's balance as of this morning
- Note any pending settlements not yet reflected in the balance
Done when This morning's custody balance for every asset is captured.
-
2
Airtable - compare against the internal ledger
airtable.com
WebRun opens Airtable to compare against the internal ledger. - Open the internal custody ledger base
- Compare each Bakkt balance against the corresponding ledger record
- Flag any asset where the two do not match
Done when Every asset has been compared, and any mismatch is flagged in the base.
-
3
Notion - log any mismatch for ops
notion.so
WebRun opens Notion to log any mismatch for ops. - Open the ops reconciliation log
- Add an entry for any mismatch, with the asset, both balances, and the difference
- Leave a clear note for the ops team to investigate and resolve
Done when Ops has a Notion entry for every mismatch found this morning, or a clean run noted.
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
Does WebRun move assets to fix a mismatch?
No. WebRun only reads balances and reports differences. It never transfers, deposits, or withdraws assets in Bakkt, and it never edits your ledger source records. Every mismatch is left for your ops team to investigate and resolve.
What counts as a mismatch?
Any asset where the balance Bakkt reports does not match what your internal Airtable ledger expects, after accounting for balances still pending settlement.
How far back does it check?
Each run compares the current balance as of that morning. It is a daily point in time check, not a full historical replay, so it is meant to catch drift early rather than reconstruct the past.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.