Settlement Calendar — Report documentation

Settlement Calendar

Purpose

The Settlement Calendar report helps finance and operations teams see net settlement amounts received in euros, broken down by payment service provider (PSP) and bank, day by day. It supports comparing the current week with the previous week and reviewing a wider rolling window in one place, so you can plan cash and reconciliation around when settlements land.

What data this report uses

The report is built on BH - Settlement Calendar: settlement records from the settlement system, with net amount received in EUR, settlement date, bank, and PSP (and organisation where mapped). For full field meanings, grain, and how amounts are stored, see the BH - Settlement Calendar user guide.

Report-level filters

Filter (as in Looker)	What it does	How to use it	When it’s useful
Date range	Limits which settlement dates are in scope for the report’s main date control. The default is This week (starts Monday)—the calendar week that contains the selected “current” view, with weeks beginning on Monday.	Open the date control and pick a preset (for example this week or last week) or a custom range.	Weekly operating rhythm, month-end slices, or ad hoc investigations.

Use Export when you need a file of the current view.

Resource-level filters

The BH - Settlement Calendar connector does not expose extra field filters on the data source itself. Each pivot on the page is a separate table with its own title and date window (see the sections below), so the Current week, Last week, and Last 30 days views can show different date spans at the same time. If numbers between blocks look different, check each block’s title and the date range that block is using—not only the page-level date control.

Current Week

The Current Week table is a pivot-style grid of net settlement in euros for the week in focus (aligned with the report’s weekly view and the page date control when that control drives this block).

What you see (label on the report)	What it means in plain language
PSP	The payment service provider for the settlement, shown as the main row grouping.
Bank	The bank (or custody / rail label from the data) under each PSP—nested under the PSP name.
Date	One column per settlement date in the week; column headers show the calendar day.
Net Settlement	The net amount received in EUR for that PSP, bank, and date. Values are added up across underlying rows for each cell.
Grand total (row and column)	Row total: sum of net settlement for that PSP and bank across the days shown. Column total: sum for that day across all PSPs and banks shown. The corner Grand total is the overall sum for the block.

A dash or empty cell means there was no settlement amount for that PSP, bank, and date in the data (not necessarily an error).

Last Week

The Last Week table again matches the PSP → Bank rows, Date columns, and Net Settlement values in EUR, but for the previous Monday-start week relative to the block’s configuration. Use it next to Current Week to compare this week vs last week settlement patterns by PSP, bank, and day.

What you see (label on the report)	What it means in plain language
PSP	Payment service provider.
Bank	Bank nested under each PSP.
Date	Weekdays (or all days present in data) for last week.
Net Settlement	Net EUR received for that PSP, bank, and date.
Grand total	Row, column, and overall totals for last week in this block.

Last 30 Days

The Last 30 Days table uses the same layout as Current Week (PSP and Bank on the rows, Date across the columns, Net Settlement in euros), but over a longer rolling period (about the last thirty days of settlement dates—exact span follows the block’s date setting in Looker). Use it for short-term trends and to see which days had activity for each PSP and bank without limiting to a single calendar week.

What you see (label on the report)	What it means in plain language
PSP	Payment service provider (main row grouping).
Bank	Bank (or related label) nested under each PSP.
Date	One column per settlement date in the rolling window.
Net Settlement	Net amount received in EUR for that cell, summed for that PSP, bank, and date.
Grand total	Same idea as in Current Week: row totals, column totals, and overall total for the block.

---