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.
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 line chart is the trend; the bar chart 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|)