Balances Overview — Report documentation

Purpose

The Balances Overview report gives finance and operations teams one place to see how much money is held across banks, payment partners (PSPs), and crypto wallets: a headline total in euros, balances by bank, a short-term trend for payout balances, and detailed rows for bank accounts and wallet holdings. It supports daily reconciliation, cash positioning, and checking that balances are updating as expected.

What data this report uses

This report combines three Looker data sources:

Overall Balances — Current snapshot of balance records: each row is a balance with amount in the original currency and in euros, bank, category (for example Funding or Payout), PSP, wallet purpose, crypto token (where relevant), company, and when it was retrieved. The summary scorecard, the Bank plus Balance summary, the detailed bank-side breakdown, and some blended tables use this source (often as a blended connector named along the lines of “Overall Balances”). For full field definitions and when columns can be empty, see the Overall Balances — User Guide.
Overall Balance History (bh_overall_balance_history) — Saved snapshots of balance data over time. The line chart Bank Payout Balances overview - Within 12 Hours uses this source so you can see how payout balances moved by hour. For snapshot time and how amounts work, see the Overall Balance History — User Guide.
Wallet balances (bcx_wallet_balance) — Wallet-level rows grouped by PSP, purpose, crypto, and company, with balance in euros. The PSP- and wallet-focused pivot uses this source. For wallet fields and nulls, see the BCX Wallet Balance — User Guide.

Report-level filters

These controls narrow the whole page (or most of it). They usually sit in the report header together with the page date range.

Filter or control	What it does	How to use it
Entity	Limits rows to the companies or entities you select.	Choose one or more entities, or leave open to see all that your access allows.
Bank/PSP	Limits rows to selected banks or PSP names (for example Vialet, Mifinity - Igloo, ISX).	Pick one or more, or leave open for all.
Bank Account	Limits to specific bank accounts when you need a narrow view.	Choose from the list when focusing on one account or a small set.
Currency	Limits to selected balance currencies (for example EUR, USDT, GBP).	Pick one or more currencies.
Crypto Provider	Limits wallet-balance views to the crypto providers you select.	Use when you care about a subset of on-chain or custodial providers.
Date range	Restricts data to the dates you choose for time-based fields on the report (shown with a calendar, for example “Mar 25, 2026 – Mar 26, 2026”).	Set the start and end dates to match the period you want; visuals that use “auto” or the page range will follow this unless a chart has its own fixed window.
Export	Downloads or exports the report view according to your Looker Studio export options.	Use when you need a file copy for sharing or offline review.

Resource-level filters

Some tiles do not rely only on the header filters. They have fixed filters inside the chart or table so the insight stays narrow and consistent.

Where it applies	What it does	How to use it
Bank Payout Balances overview - Within 12 Hours (line chart)	Within the last 12 hours — only snapshot rows from the last 12 hours (relative to when you view the report) are included, so the lines show very recent history. Payout only — only rows whose category is Payout are included, so funding and other categories do not appear on this chart.	You do not turn these off from the main filter bar; they are built into the chart so it always shows recent payout balance history. Change the page date range if you need a different reporting day; the 12-hour window still applies to snapshot time.
Overall Balances (optional tile)	If a table or chart is titled or scoped specifically to ISX, it may use a fixed filter that keeps only the ISX bank rows.	Use that tile when you only need ISX; other tiles may still show all banks unless you also filter Bank/PSP in the header.

Overall Bank Balance (scorecard)

The Overall Bank Balance scorecard is the headline number in euros: the total bank-side balance shown on the page after your filters (for example 11,265,235.29 €). Use it as the single “how much in total” figure for cash-on-hand before you drill into tables and the chart.

Bank summary table (Bank and Balance)

A compact table lists each Bank (or provider name) and its Balance in euros—for example Vialet, Mifinity - Igloo, Transfer World, ISX, Inpay, IBSettle, Monetum, Mifinity, and Bitpace. It answers “Which banks hold the most right now?” at a glance. The values respect the same overall filters as the scorecard (entity, bank/PSP, account, currency, and date range as configured on the page).

Under or beside this block, short notes explain how often different sources refresh (see Data freshness on the report below).

Bank Payout Balances overview - Within 12 Hours (line chart)

This time series line chart shows how payout balances in euros change by time of day, with one line per bank (breakdown by bank name). The horizontal axis is time by hour across about two days; the vertical axis is the balance amount (for example up to a few million euros). Lines are ordered so the largest balances are emphasized (typically sorted by balance).

Use this chart to confirm that payout balances are updating through the day and to spot sudden level changes or flatlines. It uses Overall Balance History and only Payout rows from roughly the last 12 hours of snapshots, which is why the title matches what you see.

Label (as on the chart)	Meaning
Time (hour)	The hour bucket for each point on the horizontal axis (balance snapshot time aggregated by hour).
Bank	Which bank or provider each colored line represents.
Balance	The payout balance in euros at that time for that bank (same currency basis as other EUR totals on the page).

Detailed bank breakdown (Overall Balances pivot)

The bank-side pivot table breaks balances down by institution and currency. Row groupings follow this order: Bank, category (for example Funding or Payout), Balance Retrieved (UTC) (when that row was last fetched), and Currency. The amounts shown are Balance in Base CCY (in the original currency) and Balance in EUR (converted to euros). A grand total row sums those two amount columns so you can reconcile to the headline total.

Use this table to see exactly which currencies sit under each bank and category and when each slice was last refreshed.

Column or row field	Meaning
Bank	Bank or PSP name.
category	Balance type such as Funding or Payout.
Balance Retrieved (UTC)	Timestamp when the balance was retrieved.
Currency	Currency code for that row (fiat or crypto).
Balance in Base CCY	Balance in the native currency.
Balance in EUR	Same economic amount expressed in euros.

PSP and wallet breakdown (Wallet balances pivot)

The wallet-side pivot summarizes crypto and PSP wallet positions in euros. Rows are grouped by PSP, Wallet Purpose (for example PSP Settlement or Payout), Crypto (for example USDC, USDT), Company, and often Wallet Address when expand/collapse is enabled in Looker—so you can open a company and see individual wallet addresses. The Balance column is the total in euros for each row (summed when rows combine). A grand total shows the sum of wallet balances in the pivot.

Use this table to align with internal wallet lists: who holds which token, for which PSP, and for settlement versus payout.

Row field	Meaning
PSP	Payment processor or partner name.
Wallet Purpose	Whether the wallet is for PSP settlement, customer payout, or another labeled purpose.
Crypto	Token or stablecoin code when the row is crypto.
Company	Legal entity holding the wallet.
Wallet Address	On-chain or custodial address when shown in the hierarchy (optional detail level).
Balance	Wallet balance in euros for that row.

Data freshness on the report

Callout text on the report explains typical update paths (actual schedules can change with operations):

Topic	What the report states
API banks	Bitpace, IBS, Mifinity, Monetum, TransferWorld, and Vialet balances are updated hourly via their API.
Crypto	Crypto balances are updated hourly via an API service.
Inpay	Inpay balances are updated once a day via email.
ISX	ISX balances are updated once a day via SFTP.

Use these notes when interpreting stale-looking rows: a bank that updates once per day may not move on the chart until the next file or email arrives.