Management Dashboard — Report documentation
This guide follows the main dashboard layout: Cash Situation, then Exposure Overview, then Settlements Overview.
Purpose
The Management Dashboard is aimed at finance and leadership users who need a single workspace to see liquidity, exposure, settlements, and fee allocation without opening many separate reports.
Cash Situation answers how much came in and went out yesterday (successful deposits and withdrawals), how payout and bank/crypto balances stand, whether coverage (days of payout) looks healthy, what is waiting to pay out, which PSP-level rolling reserve intervals are active, and any low-balance alerts.
Exposure Overview answers how much is still in flow or held with PSPs (cash in transit and rolling reserve) and how successful payment volume is distributed across PSPs.
Settlements Overview answers what netted in euros over recent settlement dates by PSP and bank, which PSP accounts moved sharply in volume, how much rolling reserve was returned by PSP, and how buy-side fees split across countries and PSP accounts over a chosen period.
What data this report uses
Use these user guides when you need full field definitions or grain:
BH PIQ Table (flagged transactions) user guide — one row per PaymentIQ / flagged transaction (amounts, method, state, psp, pspAccount, dates).
Overall Balances user guide — balance records by bank, source, category; balance in original currency and balance in EUR; updated / balance_date.
BCX Wallet Balance user guide — crypto wallet balances; psp, amount_in_eur.
Low Balance user guide — accounts below configured thresholds.
Bank Balance Coverage user guide — average payout over 14 days and coverage (days of payout) for monitored balances.
RR Cal 2 user guide — rolling reserve by organisation and PSP (cap, hold, amounts, key dates).
Liability Report by Entity documentation — organisation–PSP–entity liability, settlements movements, rolling reserve, cash in transit (euros).
General all tx user guide — one row per payment transaction; client base amounts; txMethod (deposit / withdrawal) and outcome.
BH - Settlement Calendar user guide — settlement calendar rows: bank, PSP, settlement date, net settlement received in EUR.
Fees over markets — Buy Rates user guide — buy-rate fee allocated to country and PSP account by day using transaction-count weights.
Report-level filters
The Entity, Method, and Final PSP Mapped dropdowns that appear alongside the volume view do not apply to the liability scorecards or the Top 15 Liability PSPs / Top 10 Rolling Reserves tables. They only narrow the PSP Volume - Successful pie chart (see below).
If your workspace applies a global date range or other controls to the whole dashboard, those affect only the tiles that are wired to that same control. Different tiles can still use their own date settings (for example Settlements - Last 7 Days uses a fixed short window on the settlement date, while Fees over markets may follow a monthly range on the fee table’s created date).
The txMethod dropdown limits General all tx to the transaction methods you select (for example Deposit and Withdrawal together). It applies to visuals that share that filter in Looker—adjust it when you want deposits-only, withdrawals-only, or both for those tiles.
Within Cash Situation, many tiles use their own date field (createdDate, last updated, yesterday, or Auto) rather than a single page date. Within Exposure Overview, each liability visual uses the date field noted in the resource-level section; the exposure volume pie uses the transaction created date as its time basis.
Resource-level filters
Filter | Which part it affects | What it does | How to use it |
|---|---|---|---|
Only Deposit | Successful Deposit Amount - Yesterday (and any other tile using this filter). | Keeps rows where the transaction method is deposit. | Use with successful-only filters so the scorecard is deposit successes only. |
Only WD | Successful Withdrawal Amount - Yesterday, Total Withdrawals Pending scorecards, Withdrawals - Yesterday table (where configured). | Keeps rows where the transaction method is withdrawal. | Narrows PIQ data to payout / withdrawal activity only. |
Only Successful - Live | Deposit/withdrawal yesterday scorecards, Withdrawals - Yesterday table (where configured), PSPs with Massive Growth. | Keeps rows whose state is successful (live successes). | Ensures volumes are successful transactions, not failures or pending—except where another filter targets pending states. On the growth table, pairs with the tile’s date comparison for % Δ. |
Waiting approval | Total Withdrawals Pending FIAT and Total Withdrawals Pending Crypto. | Keeps rows whose state is waiting approval (payouts not yet approved). | Defines “pending” for these headline pending-withdrawal numbers. |
Excl. Crypto | Total Withdrawals Pending FIAT. | Removes rows whose PSP account code indicates crypto routing (internal naming convention). | FIAT pending queue excludes crypto-typed accounts. |
PSP Account - Crypto | Total Withdrawals Pending Crypto. | Keeps rows whose PSP account code indicates crypto. | Crypto pending queue only. |
Bank Balance - Cat Payout | Payout Balance FIAT (Overall Balances). | Keeps balance rows classified as payout in the balance category. | So the scorecard reflects payout-type bank balances, not every category. |
Crypto - payout | Payout Balance Crypto (bcx_wallet_balance). | Keeps crypto wallet balances tied to payout purpose (per wallet metadata). | Aligns the crypto payout scorecard with payout-labelled wallets. |
crypto 0 balance | Crypto Balances table. | Excludes zero-balance rows (name as in Looker). | Hides empty wallets so the table lists meaningful balances. |
Exposure - Excl. Direct | Total Cash in Transit, Total RR Exposure, and the liability ranking tables (see below). | Removes rows where the PSP settles directly to the bank, so totals focus on PSPs that follow the usual settlement path. | Leave on for the standard “exposure excluding direct settlement” view; your team’s policy defines when to change this. |
Exclude PSP | Top 15 Liability PSPs (and the same exclusion may be applied consistently on related liability tiles). | Hides PSPs that match a fixed internal exclusion list (for example certain wallets, test, or niche codes). | Normally keep enabled so the ranking matches finance-approved exposure lists. |
Successful | PSP Volume - Successful pie chart. | Keeps only rows whose outcome is Successful. | Chart-level; ensures the pie is successful volume only, not attempts or failures. |
Cash Situation
This block is the day-to-day liquidity view: yesterday’s successful flows, balances by bank and crypto wallet, pending payouts, low-balance monitoring, payout runway (coverage), and a rolling reserve calendar at PSP level.
Successful Deposit Amount - Yesterday
Scorecard from the BH PIQ Table. Shows the sum of successful deposit amounts for yesterday, using createdDate (or the date field configured on the tile) set to Yesterday. Typical filters: Only Deposit and Only Successful - Live, so only successful deposit rows count. Use it as a quick check of yesterday’s inbound success volume in the display currency.
Successful Withdrawal Amount - Yesterday
Scorecard from the BH PIQ Table. Shows successful withdrawal volume for the same yesterday window, often shown as a negative number because withdrawals are outflows. Typical filters: Only WD and Only Successful - Live. Together with the deposit scorecard, it frames yesterday’s net payment activity from the PIQ transaction feed.
Withdrawal Overview (pending and payout balances)
Four scorecards that mix BH PIQ Table and balance sources:
Total Withdrawals Pending FIAT — From BH PIQ Table: withdrawals that are waiting approval, with Excl. Crypto so crypto-style PSP accounts are not included. The total is typically negative (money scheduled to leave). Date range is often all available dates on createdDate so you see the full current pending queue; confirm in Looker if your copy differs.
Total Withdrawals Pending Crypto — From BH PIQ Table: same idea for crypto PSP accounts (PSP Account - Crypto), still waiting approval and Only WD.
Payout Balance FIAT — From Overall Balances: sum of payout-category bank balances in euros (Bank Balance - Cat Payout). Time is usually tied to updated (when the balance record was last refreshed).
Payout Balance Crypto — From bcx_wallet_balance: crypto balances in euros for wallets classified as payout (Crypto - payout filter).
Together, these four tiles show what is still waiting to go out versus what you hold for payouts in fiat and crypto.
Low Balance
Small table from the Low Balance data source. Lists PSP (or account label as shown) and Balance for accounts that are below their configured minimum threshold. The tile may use Yesterday or the latest run so you only see current under-threshold accounts. No data means no accounts were under threshold at last run—not that the monitor is off. For how thresholds work, see the Low Balance user guide.
Bank Balance Overview (totals and coverage)
Total Bank Balance — From Overall Balances: headline bank balance in euros (scope follows the metric and filters on the scorecard—typically all relevant bank balance rows for the dashboard).
Crypto Balance — From bcx_wallet_balance: total crypto holdings in euros (same idea: summed amount in EUR for the filtered set).
Bank Balance Coverage table — From Bank Balance Coverage (
balance_coverage_report). One horizontal summary row (or one row per organisation in the extract) with:
Label on the report (typical) | What it means |
|---|---|
AVG. Payout / Day (Last 14 Days) | Average amount paid out per day over the last 14 days, using successful withdrawals only. |
Bank Balance | Total payout-related bank balance in euros at snapshot time (filled for the organisation this report tracks—see user guide). |
Crypto Balance | Total crypto wallet balance in euros used for coverage (same scope as the user guide). |
Bank Coverage | Bank balance ÷ average daily payout → “days of payout” the bank balance could cover. |
Crypto Coverage | Same for crypto balance. |
Total Coverage (days) | Bank coverage + crypto coverage — combined runway in days at recent payout pace. |
Per the Bank Balance Coverage user guide, bank balance, crypto balance, and coverage are only populated for the organisation that this pipeline tracks in that table; other organisations may appear with payout averages only. If your tile is filtered to one organisation, you will most often see one meaningful row.
Bank/Payout Balances
Pivot-style table from Overall Balances. Rows: Bank and Currency. Values: Balance (original cy) and Balance in EUR (same balance in native currency and converted euros). Use it to reconcile where cash sits by institution and currency. The tile’s date control is usually updated (or balance_date) so you see current positions as of the latest refresh.
Crypto Balances
Table from bcx_wallet_balance: PSP and Balance (euros—typically amount_in_eur summed). A filter such as crypto 0 balance removes zero balances. Grand total should align with Crypto Balance in the overview when scopes match.
Withdrawals - Yesterday
Table from BH PIQ Table: PSP and Tx Amount — successful withdrawal amounts summed by PSP for yesterday (or the date range on the tile). Typical filters: Only Successful - Live and Only WD. The date dimension may be last updated or createdDate depending on configuration—use the tile settings if totals do not match the withdrawal scorecard.
RR Calendar
Table from RR Cal 2 (rolling_reserves_psp): rolling reserve by organisation and PSP (one row per reserve interval). Typical columns:
Column | What it shows |
|---|---|
PSP | Payment service provider. |
Capped? | Whether this interval uses a cap (yes/no). |
Held (or Hold) | Hold length in days for the rolling period. |
First Tx | First successful transaction date for that org–PSP (when available). |
Forecasted Release | For uncapped reserves, when the reserve is expected to release; empty for capped intervals (release follows the cap). |
Cap | Cap amount in euros for capped intervals. |
Rolling Reserves | The rolling reserve amount at PSP level (capped or total per interval, per the user guide). |
The tile’s date range dimension is often first_transaction_date; blended or extra fields may appear if the Looker resource combines sources.
Exposure Overview — Liability (Liability Report by Entity)
This block summarises cash in transit and rolling reserve (RR) exposure and shows which PSPs drive those totals.
Total Cash in Transit
Single number: the sum of cash in transit across the rows included after Exposure - Excl. Direct (and any date range applied to this scorecard). Cash in transit is the amount still moving in the liability model—successful deposit activity and top-ups, minus deductions such as rolling reserve taken, fees and settlement movements counted in that formula, and adjustments—so it is a headline “money on the way / not yet fully cleared” figure for PSPs in scope. The scorecard’s date control uses base settlement date as configured in Looker (often Auto over available data).
Total RR Exposure
Single number: the sum of rolling reserve (held amount, with cap logic as defined in the liability data) for the same filters and date scope as this scorecard. Use it as the total rolling reserve exposure across PSPs after direct-settlement exclusions. Like the cash-in-transit scorecard, it respects Exposure - Excl. Direct and uses base settlement date for time.
Top 15 Liability PSPs
Table titled Top 15 Liability PSPs: one row per PSP, ranked by Cash in Transit (highest first). Cash in Transit is the same concept as on the scorecard, but broken out by PSP so you can see which providers contribute most to liability. Exclude PSP and Exposure - Excl. Direct apply here. The table uses latest settlement date as its date dimension in Looker (default Auto). Conditional formatting may highlight the largest contributors.
Top 10 Rolling Reserves
Table titled Top 10 Rolling Reserves: one row per PSP, showing RR (rolling reserve amount in euros), typically sorted from highest to lowest. In Looker this may be configured as a Top N list (the on-screen title may say “Top 10” while the row limit is set higher—use the table as a ranked list, not a hard count). It uses the same liability source and usually the same latest settlement date basis as the Top 15 table. Use it to see which PSPs hold the largest rolling reserves after your filters.
Exposure Overview — Transaction volume (General all tx)
PSP Volume - Successful
Pie chart PSP Volume - Successful: each slice is a Final PSP Mapped value (the reporting label for “which PSP / outcome bucket” the transaction ended with); slice size is the sum of client base total amount for successful transactions only. Amounts are in client base currency as stored on the row—your report may display them with a euro symbol if conversion or display settings map them that way in Looker.
Interactive filters (this chart only):
Control | What it does |
|---|---|
Entity | Limits the chart to transactions for the selected organisation entities. |
Method | Limits to the chosen transaction methods (for example Deposit and Withdrawal together, or a subset). |
Final PSP Mapped | Lets you focus on one or more mapped PSP labels; useful when the legend is long. |
The chart applies the Successful filter so only Successful state rows are included. Time filtering is by transaction created date (created as a date), as set on the chart.
Use this chart to compare where successful volume concentrates by PSP, side by side with the liability tables, knowing that the liability side is euro entity exposure while the volume side is transaction-level successful amounts in client base currency unless your report normalises display.
Settlements Overview
This block combines settlement cash flows, short-term volume change by PSP account, rolling reserve returned, and fee-over-market views. Work through it when you care about money that landed by settlement date, unusual week-on-week swings, RR that came back, and which countries and accounts drive buy-rate fees.
Settlements - Last 7 Days
Pivot-style table backed by BH - Settlement Calendar.
Rows are nested by PSP, then Bank (the bank or custody label from the settlement data). Columns are settlement dates for a short rolling window (typically last seven days, excluding today, depending on how the tile is configured). The value in each cell is Net Settlement: the net amount received in euros for that PSP, bank, and date, summed from underlying settlement records.
Row, column, and grand totals add up those euro amounts for the window shown. An empty cell means there was no net settlement for that combination on that date.
This tile often has its own date logic and does not have to match a long monthly date range used elsewhere on the page—check the tile’s date settings in Looker if numbers look out of step with other blocks.
PSPs with Massive Growth
Table backed by the BH PIQ Table (flagged PaymentIQ-style transactions).
Column | What it shows |
|---|---|
PSP Account | The full PSP account string from the transaction data (method, currency, region, routing labels, and similar tokens combined as in PaymentIQ). |
Volume | Successful transaction volume in the current period for that account (the tile uses a filter that keeps only successful state rows—Only Successful - Live). The exact amount field behind “Volume” follows your Looker metric definition; interpret it as the period’s successful volume for that account. |
% Δ | Percentage change versus the comparison period (for example previous period), as configured on the chart—often last seven days excluding today compared to the previous seven days. Colour formatting may highlight large positive or negative moves. |
Use this table to spot PSP accounts whose successful volume jumped or dropped sharply week over week. Pagination may show many rows (for example the largest movers by absolute change—confirm sort order in Looker if needed).
RR Returned
Simple table backed by Liability Report by Entity.
One row per PSP, with Amount: rolling reserve returned in euros for the rows in scope (the settlement-side total of what was returned to you from rolling reserve, aligned to organisation–PSP–entity in the liability model). Values are summed by PSP for display. The tile uses latest settlement date as its date dimension (often Auto over available data) and may be limited to a Top N list (for example the top 10 PSPs by returned amount).
Use it to see who returned the most rolling reserve in the selected period, alongside settlement cash flows and volume growth.
Fees over markets - Buy Rates (pie chart and pivot)
These two visuals share the Fees over markets - Buy Rates data: daily fee allocated to country and PSP account from buy rates, using each country’s share of transactions for that org / account / day (only combinations where both counts and fees exist). Time filtering is on the table’s created date (the fee-allocation date). A page-level date range control may drive this block when the charts are linked to it—for example a calendar month.
Pie chart — Each slice is a country (typically ISO-style codes such as NLD, SWE, GBR). Slice size is the sum of fee for that country in the selected period (labels may show Total Fee or fee in Looker). The centre or subtitle may show the overall total of allocated fees.
Pivot table — Rows group Country, then PSP (technical PSP account codes as stored in the fee-over-market data). The measure is Total Fee (sum of allocated fee for each country–PSP combination). Use it to see which accounts sit under each country and how much fee each contributed.
Remember: the fee-over-market table only includes organisation × PSP account × date rows that have both transaction counts and buy-rate fees; gaps in source data mean some days or accounts may not appear.