The Sanity Check feature in Cryptoworth acts as a health monitor for your financial data.
1. Understanding the Two Key Balances
The core of the Sanity Check is the comparison between two distinct data points. Understanding the difference is critical for troubleshooting.
Calculated Balance (Ledger Data): This is the "bottom line" number Cryptoworth calculates by adding up all your imported transactions. It follows the formula: Initial Balance + Deposits - Withdrawals = Calculated Balance. If a single transaction is missing or duplicated in your history, this number will be incorrect.
Reported Balance (Source of Truth): This is the actual balance sitting in your wallet or exchange account right now. Cryptoworth fetches this number directly from the blockchain (for wallets) or via API (for exchanges). It is the "real" balance that cannot be manipulated.
2. Navigating the Sanity Check Report
Go to Reconciliation > Reconciliation in the side panel.
Click the Data Sanity Check tab at the top.
Click Run Reconciliation (top right) to trigger a fresh scan.
The main table provides a line-by-line health status for every connected wallet and exchange:
Status Indicator | Meaning | Action Required |
Synced / Reconciled (Green) | The Calculated Balance matches the Reported Balance perfectly. Your data is complete and accurate. | None. You are audit-ready for this connection. |
Gaps Detected / Warning (Yellow) | The Calculated Balance does not match the Reported Balance. This means transactions are missing, duplicated, or incorrect in your ledger history. | Investigation required. You must review the ledger and the verify any transaction level issues causing the drift. |
3. Resolving "Gaps Detected"
If you see a yellow warning status (as shown for "ETH Wallet One" in the example image).
Click to Drill Down: Click directly on the row with the error. This opens a detailed view showing exactly which token (e.g., ETH, USDC) has the mismatch.
Compare the Numbers: Look at the difference between the "Calculated" and "Reported" columns.
Example: If Reported is 10 ETH but Calculated is 9 ETH, you are missing an inflow of 1 ETH in your transaction history.
Fix the Ledger:
Go to the Transactions page.
Filter for that specific wallet and asset.
Look for missing imports, ignored transactions, or incorrect manual entries.
Once fixed, return to the Sanity Check page and click Recalculate on that specific row to verify the fix.
Report Header Columns
Column | Description |
Connection Type | The category of connection (e.g., "Accounts" for wallets/exchanges, "DeFi" for protocol positions). |
Connection Name | The specific wallet or exchange account being reconciled (e.g., "Bank Account A," "Coinbase Account"). |
Status | Indicates whether discrepancies were found. "Gaps detected" means there are missing transactions or balance mismatches that need investigation. |
Asset-Level Reconciliation Columns
Each connection expands to show per-asset reconciliation details:
Column | Description |
Asset | The token or cryptocurrency being reconciled (e.g., Bitcoin (BTC), Solana (SOL), American Dollars (USD)). |
Calculated In | The total quantity of this asset that Cryptoworth has recorded as incoming (deposits, receives, buys) based on synced transaction data . |
Calculated Out | The total quantity of this asset that Cryptoworth has recorded as outgoing (withdrawals, sends, sells) based on synced transaction data . |
Calculated Fees | The total amount of this asset consumed as network or trading fees across all transactions . |
Calculated Balance | The net balance computed by Cryptoworth using the formula: Calculated In - Calculated Out - Calculated Fees. This represents what your balance should be based on the transaction history in your ledger . |
Reported Balance | The actual balance queried directly from the blockchain (for wallets) or exchange API (for custodial accounts) at the time of the sanity check . This is the "ground truth" balance. |
Difference | The variance between Calculated Balance and Reported Balance, expressed in token quantity (e.g., |
Difference Value ($) | The USD value of the Difference column, calculated using current market prices. This helps prioritize which discrepancies to investigate first (e.g., a $-165,000 difference is more urgent than a $-1.88 difference) . |
What "Gaps Detected" Means
When the Status column shows "Gaps detected," it means:
The Calculated Balance does not match the Reported Balance.
Transaction data is incomplete (missing deposits, withdrawals, or trades).
You should click Recalculate or review the connection's transaction history to resolve the gap.
This reconciliation workflow ensures your financial records are audit-ready and match on-chain reality before generating reports or journal entries.