Account Network Visualizer

A scorecard tells you something is wrong. The Account Network shows you what wrong looks like.

Three financial systems. One canonical account. Three identifiers, three price sources, three market values — mapped as a navigable 3D graph.


The Problem It Visualizes

Reconciliation failures are easy to miss in a table. In a force-directed graph, they appear as structure — a hub node for one canonical account, three spokes to its source system representations, each reporting a different value for the same underlying holdings.

Same account. Three systems. Three market values. Zero shared key.


What You Can See

Navigate the full Gemstone Financial portfolio — 100 accounts, 300 source records, 25 clients — in 3D:

  • Two layouts: Hub-Spoke (one canonical account → three source spokes) and Client Hierarchy (25 clients → 100 accounts → 300 source records)
  • Five label modes: Market Value · Unrealized G/L · Cost Basis · Account ID · Position Count
  • Hover any node to see the per-source value and the delta

Node.js · Express · SQLite · 3d-force-graph v1.79.1 · D3 v5


Account Network client hierarchy view showing Topaz, Emerald, and Ruby market value rollup with variance across hub-and-spoke nodes

Built on the synthetic GSF dataset — 100 canonical accounts, 300 source records, 25 clients. Part of the GSF Semantic Pipeline project.