Exposure Overview v3 — Report documentation

Purpose

This report gives finance and operations teams a PSP-level view of exposure: how much successful volume you have, what has been settled, held in rolling reserve, lost to chargebacks and refunds, and what remains as total remaining exposure and cash in transit. Use it to monitor liability by PSP, spot unusual balances, and align on which PSPs are included or excluded from the main exposure picture.

What data this report uses

The report is built from the Liability Report by Entity data source. That source holds one row per organisation, PSP, and entity with deposit and payout volume, fees, settlement movements, rolling reserve, and derived exposure figures—all in euros. For full field definitions and concepts (for example cash in transit versus total remaining exposure), see Liability Report by Entity documentation.

Report-level filters

These filters apply to the whole report. Use them to narrow which entities and PSPs you see and whether direct-settling PSPs are included.

Filter	What it does	How to use it	When it's useful
Entity	Limits the report to the organisation entities you choose.	Pick one or more entities from the dropdown.	When you want exposure for a specific entity or a small set of entities.
Include Direct Settling PSPs	Controls whether PSPs that settle directly to the bank appear in the main exposure view.	Set to true to include them, false to leave them out (common default is false).	When you want the main table to match “normal” settlement PSPs only, or when you need direct-settling PSPs included for a full picture.
PSP	Limits the report to selected payment service providers.	Pick one or more PSPs from the dropdown.	When you are reviewing a subset of PSPs or drilling into one provider.

Use Export (or Exposure Export) when you need a file copy of the current filtered view for sharing or offline analysis.

Resource-level filters

These filters apply only to specific tables, not necessarily every visual on the page.

Filter	Which part of the report it affects	What it does	How to use it
Exclude PSP	The wide Exposure table (PSP breakdown with settlement and exposure columns).	Hides rows where the PSP matches a fixed list of codes used for manual exclusions (for example certain wallets, test, or niche PSP codes defined for finance).	Leave enabled when you want the main exposure table to exclude those PSPs by default; adjust only if your process allows showing them.
Exposure - PSP Manual exclusions	The table that lists Excluded PSPs with Manual Exclusion vs Direct Settlement and successful value.	Keeps rows that are either in that manual-exclusion list or marked as bank direct settlement—so the table focuses on PSPs that are treated differently for exposure.	Use this table to see who is excluded or direct-settling and how much successful volume they still have, without cluttering the main PSP grid.

Exposure (main table)

The main table is the Exposure view: one row per PSP (with underlying data summed or grouped from organisation–PSP–entity rows). It answers “for this PSP, what moved in settlements and what is left exposed?” Conditional formatting in Looker may highlight some rows (for example higher exposure) so they stand out—your team’s thresholds drive that styling.

The Exclude PSP filter applies here. The date range for this report is based on latest settlement date (most recent settlement date on the row); the default range is often “auto” over available data—check the date control if your report uses one.

Column	What it shows
PSP	The payment service provider.
Actual Latest Settlement Date	The latest date a settlement was recorded for this PSP (in the rolled-up rows).
Successful Value (last 14 days)	Successful deposit volume in the last 14 days.
Successful Value	Total successful deposit volume in scope for this PSP.
Successful Payouts	Total successful payout (withdrawal) volume.
Top Ups	Top-up amounts credited in euros.
CALC Total Fee	The total fee for this PSP—transaction and settlement-related fees added up (the “CALC” label in Looker marks it as a computed total).
Actual RR Deducted	Rolling reserve the PSP deducted from settlement.
RR Returned	Rolling reserve returned to you.
RR Adjustment	One-off or manual rolling reserve adjustments.
Extra Adjustment	Other extra adjustments from settlement (separate from the RR adjustment line).
Actual Settled	Net amount received from the PSP in settlement (euros)—what actually landed after settlement movements.
Actual CB Deducted	Chargeback amounts deducted.
Actual CB Fee	Fees tied to chargebacks.
Actual Refund	Refund amounts.
Actual Refund Fee	Fees tied to refunds.
FX Loss on Deposit	Foreign exchange loss booked on the deposit side.
FX Loss Settlement	Foreign exchange loss booked on settlement.
Discount	Amounts that act as fee or settlement credits (for example tiered fee adjustments shown under a short “Discount” label).
Settlement Stuck	Amount described as stuck in settlement—not yet cleared through the normal settlement path.
Total Remaining Exposure	Overall remaining exposure for this PSP: successful deposits and top-ups, minus the main settlement and fee deductions and with rolling reserve returns and adjustments applied in line with your liability model—this is the headline “how much is still at risk” style number.
Cash in Transit	Cash in transit—money still moving between successful volume, top-ups, deductions, fees, and adjustments according to the liability rules behind this report (distinct from total remaining exposure; both are explained in the Liability Report user guide under cash in transit and exposure).

Use the two rightmost columns first when you need a single view of risk and flow; use the movement columns when you need to explain why exposure looks high or low.

Table with PSP and Record Count

This small table lists psp and Record Count. Record Count is how many underlying rows (typically organisation–PSP–entity rows) are included for each PSP after your filters. Use it to see whether a PSP’s main-table figures come from many entities or a single one, and to sanity-check duplicates or missing splits.

Table with Excluded PSPs, Manual Exclusion vs Direct Settlement, and successful value

This table works with the Exposure - PSP Manual exclusions filter. It lists Excluded PSPs, whether each row is Manual Exclusion or tied to Direct Settlement, Successful Value (last 14 days) (recent deposit volume where present), and Successful Value (broader successful deposit volume in scope). Successful Value (last 14 days) may be empty for some excluded PSPs when there is no activity in that window—treat blank as no recent volume, not necessarily zero in all systems.

Use it alongside Include Direct Settling PSPs and the main Exposure table: the main table shows the core PSP grid with exclusions applied; this table makes manual exclusions and direct-settling PSPs visible with their volumes for governance and reconciliation.