Landing page — summarises each tab in this dashboard so readers know where to look first. No filters or visuals.
Executives Dashboard
Board-cadence view of the bank's transaction throughput, money movement, and account coverage. Scan for trends; click any row or bar to drill into the operational sheets for the underlying transactions.
Clickable cells
Cells rendered in the theme accent color are interactive:
Plain accent-coloured text — left-click drills to an operational sheet (Account Reconciliation's Transactions tab) filtered to the row's account / transfer type
Heads-up: drill-down filters stick after you switch tabs. Refresh the dashboard to clear them.
Program Health
Single-tile read on whether the bank's ledger is healthy. Counts L1 invariant violations open within the dashboard's 30-day window — green when zero, amber on any violation, red at the 20-violation systemic mark. Drill into the L1 Dashboard for per-row triage.
Source: <prefix>_l1_exceptions, narrowed by the dashboard date picker
Hyperlink to the L1 Dashboard for per-row drill
Account Coverage
How many accounts the bank has on its books and how many of them have actually moved money in the selected period. Counts split by account type so you can see the shape of the deposit base next to the GL control accounts that drive operations.
KPIs: total open accounts + active accounts in the period
Bar charts: open + active counts by account type
Detail table: per-account last activity date and count
Transaction Volume Over Time
Transaction throughput over time, sliced by rail_name so you can see which rails are growing or contracting. The stacked bar is the daily-rail trend; the clustered bar is the period total per type.
KPIs: total transactions + average daily volume
Daily transaction count, coloured by rail_name
Period total per rail_name
Money Moved
Dollar volume moving across the bank, by rail, over time. Net (signed sum — flows into the bank are positive) and gross (sum of absolute values — total handle, regardless of direction) live side by side; the per-rail bar shows where the volume is coming from.
KPIs: net money moved (Σ signed) + gross money moved (Σ |signed|)