Rolling Reserve Monitoring — Report documentation

Purpose

This report helps finance and operations teams monitor rolling reserve by PSP and entity. It shows how much rolling reserve is held, deducted, returned, and adjusted for each PSP, together with recent successful volume and settlement dates. Use it to track rolling reserve exposure, see which PSPs have reached their cap, and review excluded or direct-settling PSPs in one place.

What data this report uses

The report is built from the Liability Report by Entity data source, which holds one row per organisation, PSP, and entity with successful deposit and payout amounts, settlement and rolling reserve movements, and related liability metrics—all in euros. For full field definitions and concepts (e.g. rolling reserve cap, remaining settlement, cash in transit), see Liability Report by Entity documentation.

Report-level filters

These filters apply to the whole report. Use them to narrow which entities, PSPs, and settlement types are included.

Filter	What it does	How to use it	When it's useful
Entity	Restricts the report to a chosen entity (e.g. a specific PSP account or legal entity).	Choose one or more entities from the dropdown.	When you want to focus on a single entity or a small set of entities.
PSP	Restricts the report to one or more payment service providers.	Choose one or more PSPs from the dropdown.	When you need rolling reserve and volume for specific PSPs only.
Include Direct Settling PSPs	Controls whether rows for PSPs that settle directly to the bank are included in the report.	Set to true to include them, false to exclude them (default is false).	When you want to exclude or include direct-settling PSPs from the main view.
is_bank_direct_settlement	Same idea as "Include Direct Settling PSPs": limits the report by whether the PSP uses bank direct settlement.	Set to true or false as needed (e.g. false to hide direct-settling PSPs).	When you need report-wide control over direct-settlement PSPs in addition to the "Include Direct Settling PSPs" control.

Resource-level filters

These filters apply only to a specific table or visual on the report.

Filter	Which part of the report it affects	What it does	How to use it
Exclude PSP	The main table titled Rolling Reserve Monitoring Report.	Excludes rows where the PSP matches a fixed list of PSP codes (e.g. NEONPAY, ZIMPLER, BANXA, and others used for manual exclusions).	Turn it on or set the pattern when you want the main rolling reserve table to hide those PSPs.
Exposure - PSP Manual exclusions	The table that shows Excluded PSPs, Manual Exclusion vs Direct Settlement, Successful Value (last 14 days), and Successful Value.	Restricts that table to rows where the PSP is in the manual-exclusion list or the PSP is a bank direct settlement PSP—so you see only "excluded" or direct-settling PSPs there.	Use when you want that table to list only PSPs that are manually excluded or direct-settling, for exposure review.

Rolling Reserve Monitoring Report (main table)

The main table is titled Rolling Reserve Monitoring Report. It shows one row per PSP (or per organisation–PSP–entity, depending on how the report is grouped), with rolling reserve and volume metrics. The Exclude PSP filter applies to this table only.

Column	What it shows
PSP	The payment service provider.
RR Capped	Whether the rolling reserve has reached its cap for that PSP (yes/no).
Latest Settlement Date	The most recent date a settlement was recorded for that PSP.
Successful Volume past 14 Days	Total successful deposit volume in the last 14 days for that PSP.
Actual RR Deducted	Total rolling reserve amount deducted by the PSP (from settlements).
RR Returned	Total rolling reserve amount returned by the PSP.
RR Adjustment	Manual or one-off rolling reserve adjustments.
Net RR	Net rolling reserve movement: deducted minus returned minus adjustment.
RR With Cap	The rolling reserve amount used in the report—capped when a cap exists, so you see how much is held up to the cap.

Use this table to see at a glance how much is in rolling reserve per PSP, whether the cap has been reached, when the last settlement was, and how recent volume and RR movements look.

Table with PSP and Record Count

The second table shows two columns: psp and Record Count. It lists each PSP in the filtered dataset and how many report rows (entity-level rows) exist for that PSP. Record Count is the number of rows per PSP—typically one per organisation–PSP–entity combination. Use it to see how many entities or combinations contribute to each PSP in the report.

Table with Excluded PSPs and Manual Exclusion vs Direct Settlement

The third table has the control Include Direct Settling PSPs (value false by default) and the columns Excluded PSPs, Manual Exclusion vs Direct Settlement, Successful Value (last 14 days), and Successful Value. The Exposure - PSP Manual exclusions filter applies to this table: it limits the rows to PSPs that are manually excluded (by the exclusion list) or that are bank direct settlement PSPs.

Column	What it shows
Excluded PSPs	The PSP (or PSPs) that are either manually excluded or direct-settling, depending on the filter.
Manual Exclusion vs Direct Settlement	Whether the row is treated as manually excluded or as direct settlement (for exposure and exclusion reporting).
Successful Value (last 14 days)	Successful deposit volume in the last 14 days for that PSP.
Successful Value	Total successful deposit volume (all time within the report’s date range) for that PSP.

This table is for teams that need to review which PSPs are excluded or direct-settling and what their successful volume is—useful for exposure checks and for understanding the impact of manual exclusions.