/
Master Reconciliation Checklist

Master Reconciliation Checklist

A non-zero Difference is the "Check Engine" light of a crypto balance sheet. Because NODE40 uses double-entry accounting principles, every outbound movement must have a corresponding inbound "home," and every ending balance must be mathematically justifiable by the activity that preceded it.

Here is a step-by-step checklist to troubleshoot and zero out that Difference.

NODE40 Master Reconciliation Checklist

1. Macro-Level Audit (Finding the Culprit)

  • [ ] Analyze Column AP (Difference): In the Balance Sheet (Long Form) tab, scroll to Column AP. This is your primary indicator. Any non-zero value here identifies a specific Source (Exchange or Blockchain) that is out of balance.

  • [ ] Verify Snapshot Integrity: On the About tab, confirm the Snapshot Date. If this is a "Roll Forward" from a prior year, ensure the previous year was finalized and the opening balances are locked.

2. Micro-Level Audit (Pinpointing the Ledger)

  • [ ] Analyze Column BI (Recon Diff): Navigate to the specific source tab (e.g., Solana (USD)) and scroll to Column BI. This narrows the discrepancy down to the individual Ledger (the specific token or wallet address) causing the imbalance.

  • [ ] Identify Negative Ledgers: Check the User Interface for any negative Ledgers. A ledger should never be negative; this is a mathematical signal of missing inbound data.

3. Transaction-Level Resolution

  • [ ] Resolve Flagged Transactions (Manual Balancing): Identify transactions flagged as "Unbalanced" (orphaned legs). This occurs when one side of a trade or transfer is missing a corresponding value or counter-asset.

    • Action: Within the NODE40 interface, expand the flagged transaction to reveal the "Related transactions:" section. Identify any missing legs and add a valuation to the missing components to balance the entry.

  • [ ] Link Internal Transfers: Scan the Transactions tab for large withdrawals or deposits. Ensure that transfers between your own wallets/exchanges are linked so they don't appear as "orphaned" flows.

  • [ ] Check "Sourceless" Tabs: Look for data in the Sourceless tabs that may belong to your imbalanced source. Re-assigning these can often zero out the Recon Diff (BI).

4. Primary Fixes & Overrides

  • [ ] Trigger a Source Rebuild: If a ledger is negative or has many unbalanced flags, perform a Source Rebuild in the NODE40 interface. This forces the system to re-sync the full history and often fixes API "skips" automatically. Keep in mind this does wipe out any other manual adjustments or tags added to the source.

  • [ ] Enter Manual Adjustments: For defunct exchanges or missing historical data, enter a Manual Transaction (Inbound) or a Balance Adjustment to provide the necessary cost basis and sync the ledger to the known physical balance.

5. Final Validation

  • [ ] Confirm Zeroes: The goal is achieved when Column AP (Balance Sheet Long Form) and Column BI (Source Tabs) are both $0.00.

  • [ ] Verify Difference Field: On the main Balance Sheet tab, ensure the Difference field in the Reconciliation Section is $0.00.