Data Integrity module: Balance Sanity Check (new updates)
The Balance Sanity Check helps you validate the completeness and accuracy of your crypto data by comparing Cryptio‑calculated balances with remote balances from nodes, exchanges, and custodians - at the same point in time. The latest release adds precision, flexibility, and scale so you can rely on it daily and at period‑end.
What’s new (and why it matters)
Snapshot‑perfect matching
We align to a remote snapshot (timestamp or block height) and compute Cryptio’s balance to that exact point - giving you like‑for‑like results across chains and sources.
Historical checks
Run the check for today or a prior date. Historical runs use the nearest stored snapshot, so you can investigate past periods with confidence.
Multi‑source wallet coverage
Reconcile wallets that combine on‑chain + CSV/API data. Each source is included in the calculation so you see one clear result.
Optional vault‑level comparison
For multi‑wallet vaults (e.g., Fireblocks), compare the vault total with the sum of underlying wallets - alongside standard wallet‑level results.
Flexible scheduling
Automate runs daily, on selected weekdays, specific month dates, or last day of month at a chosen time.
Built‑in freshness & provenance
Each result shows the snapshot time/block and flags any source that isn’t up‑to‑date.
Streamlined reporting
Export a concise report with summary and wallet/asset‑level detail, including units, USD values, and percentage variances.
Run a check
Manual (ad‑hoc)
Go to Data Integrity → Balance Sanity Check → Run.
Choose Most recent snapshot or Historical date.
Click Run. Status updates guide you while sources refresh and the comparison completes.
Scheduled (recurring)
Click Schedule → Enable.
Choose Daily, Selected weekdays, Selected dates, or Last day of month.
Set a time; the system uses the closest snapshot to that time automatically.
Read the results
Summary strip (top)
Run date, Snapshot date, Run type (Manual/Scheduled), Status
Wallets reconciled, Assets reconciled
Total discrepancy (amount and % of portfolio)
Wallet results table
Each row shows Wallet, Asset, Cryptio vs Remote, Diff ($, %), and Status:
Reconciled — amounts match
Unreconciled — amounts differ
Untestable — remote balance not available for that source/asset
Open any row for source details, timestamps/block heights, and asset breakdown. Add notes or re‑run a wallet after refreshing data.
Vault view (optional)
When enabled in Settings, see a vault table that compares:
Vault remote balance vs Sum of Cryptio wallet balances, and
Standard wallet‑level reconciliations for each component wallet.
Export a report
After a run completes, select Generate Report to download:
Summary: Company, Run time, Snapshot date
Detailed results (per wallet/asset): wallet & type, address, Remote/Cryptio time & block, asset identifiers, Cryptio vs Remote in units & USD, Diff in units & USD, Diff %
Best practices
Automate daily and add last‑day‑of‑month for close.
Keep connectors read‑only and healthy (key rotation, IP allowlists).
Use filters to focus on Unreconciled rows and sort by Diff ($).
In Settings, hide spam/non‑significant assets and set a materiality threshold to de‑noise small variances.
FAQ
Can I pinpoint an exact past block/time?
Select a date; the system uses the nearest stored snapshot available for each source.
Why do I see “Untestable”?
That source/asset doesn’t provide a remote balance snapshot. You can switch connectors or document and exclude.
Do fiat conversions affect matching?
Matching happens in units. USD values are applied after reconciliation for reporting.
Can I focus on one wallet or one asset?
Yes - filter the table to a wallet/asset and re‑run that scope if needed.
How do multi‑source wallets work?
The check includes each configured source (e.g., on‑chain + CSV/API) so your wallet shows a single consolidated result.