Sell Rate - Overview — Report documentation

Purpose

This report gives finance and commercial teams a single view of sell-side fees and volume by client, brand, PSP, account, and method. Use it to see what you charge (client fees), how much volume and how many transactions each combination represents, and to spot combinations where volume exists but no fees are recorded (missing fees). It supports pricing reviews, fee reconciliation, and identifying zero-fee, volume-only rows that may need attention.

What data this report uses

The report is built from the Country sell rates 2 data source, which provides sell-side rates and volume at the level of organization, PSP, PSP account, method, date, card scheme, merchant, and merchant user country. For full field definitions and how the numbers are built, see Country sell rates 2 — User Guide.

Report-level filters

These filters apply to the whole report. Use them to narrow the data by client, provider, account, product, entity, or time.

Filter	What it does	How to use it	When it's useful
Merchant ID	Restricts the report to one or more merchants.	Select one or more merchant IDs from the dropdown.	Focusing on specific merchants or sites.
Entity	Restricts the report to selected entities (e.g. legal or reporting entities).	Choose one or more entities from the dropdown.	Entity-level reporting or compliance.
Brand	Restricts the report to selected brands (client-facing brand labels).	Select one or more brands from the dropdown.	Analysing or comparing specific brands.
Method	Restricts the report to selected product types (e.g. All, Withdrawals, FTD, Trusted, DEPOSIT, WITHDRAWAL).	Choose one or more methods from the dropdown.	Comparing deposits vs withdrawals or other product types.
PSP	Restricts the report to selected payment service providers.	Choose one or more PSPs from the dropdown.	Reviewing a subset of providers or a single PSP.
PSP Account	Restricts the report to selected PSP accounts (e.g. MIDs).	Choose one or more accounts from the dropdown.	Analysing specific accounts or contracts.
Customer	Restricts the report to selected customers (clients).	Select one or more customers from the dropdown.	Client-level analysis or reporting.
Date range	Restricts the report to a chosen period (e.g. Feb 1–Feb 28, 2026).	Pick a start and end date.	Focusing on a specific period for fee or volume review.

Resource-level filters

These filters apply only to a specific part of the report.

Filter	Which resource it affects	What it does	How to use it
Sell Rates - 0 fees and volume	The Missing Fees table	Shows only rows where total fee is zero (zero-fee, volume-only).	It is applied to the Missing Fees table so that table lists only combinations that have volume but no fees recorded. Use it to find rows that may need fee configuration or review.

Client Fees section

This section summarises sell-side volume and fees for the selected filters. It uses the date dimension full_date (shown in the report as the chosen date range).

Scorecards

Three scorecards give headline numbers for the filtered period:

Successful Tx — Total number of successful transactions in the period.
Successful Value — Total amount of successful transaction volume (in the report currency).
Total Fee — Total of all sell-side fees (success and failed transaction fees, settlement, FX, chargeback, monthly, and other fees) for the period.

Use these to see overall scale and total fees at a glance before drilling into the detail table.

Client Fees table

The main table has the same title as the section: Client Fees. Each row is one combination of Month, Customer, Brand, PSP, PSP Account, PSP Friendly Name, Entity, and Method—so you see volume and fees for that combination in one place.

Column	Meaning
Month	The month the row refers to (e.g. February).
Customer	The customer (client) identifier.
Brand	The brand label for the merchant (from mapping, or a fallback when no mapping exists).
PSP	The payment service provider code.
PSP Account	The specific PSP account (e.g. MID).
PSP Friendly Name	A display name for the PSP.
Entity	The entity the PSP account is mapped to for reporting.
Method	The product type (e.g. DEPOSIT, WITHDRAWAL).
Success Tx	Number of successful transactions for that combination in that month.
Success Value	Total successful transaction amount (volume) for that combination in that month. It can be negative for withdrawals.
Failed Tx	Number of failed transactions.
CB Value	Chargeback amount (value of chargebacks).
Success Tx Fee	Fee you charge per successful transaction (fixed component).
Success Value Fee	Fee you charge on successful transaction value (percentage component).
Failed Tx Fee	Fee you charge per failed transaction.
CB Fee	Fee you charge for chargebacks.
Settlement Fee	Settlement-related fees (percentage and/or fixed).
Monthly Fee	Monthly fixed fee.
FX Fee	FX fee (in the report currency, e.g. EUR).
Total Fee	Sum of all sell-side fees for that row.
Operator Fee	Operator-related fee (e.g. PaymentIQ user fee or similar).
Actual Payment Cost	Total sell-side fee minus the PaymentIQ user fee; interpreted as the cost to you after that user fee. Helps compare what you charge with the net cost you bear.

Use the table to see which customers, brands, PSPs, and methods generate the most volume and fees, and to reconcile totals with the scorecards. Empty (null) values in fee columns mean no fee was recorded for that component for that row.

Missing Fees table

The Missing Fees table lists combinations that have volume and transaction counts but no fees (total fee is zero). It has the resource-level filter Sell Rates - 0 fees and volume applied, so only zero-fee, volume-only rows are shown.

Column	Meaning
Month	The month the row refers to.
Customer	The customer (client) identifier.
Brand	The brand label for the merchant.
PSP	The payment service provider code.
psp_account	The specific PSP account (e.g. MID).
psp_friendly_name	A display name for the PSP.
merchant_id	The merchant identifier.
Success Tx	Number of successful transactions for that combination.
Success Value	Total successful transaction amount (volume).
Success Tx Fee	Fee you charge per successful transaction (fixed component).
Success Value Fee	Fee you charge on successful transaction value (percentage component).
Failed Tx	Number of failed transactions.
Failed Tx Fee	Fee you charge per failed transaction.
CB Value	Chargeback amount (value of chargebacks).
Settlement Fee	Settlement-related fees.
Monthly Fee	Monthly fixed fee.
FX Fee	FX fee (in the report currency).
Total Fee	Sum of all sell-side fees for that row (zero in this table).
Operator Fee	Operator-related fee (e.g. PaymentIQ user fee or similar).

Same concepts as in the Client Fees table; here they highlight rows where Total Fee is 0 despite having transactions and volume.

Use this table to:

Find PSP–account–merchant combinations where fees might be missing or misconfigured.
Review zero-fee volume for pricing or contract follow-up.
Reconcile with fee setup (e.g. rates not yet applied for that combination).

The table can be narrowed further with Merchant ID and Brand filters that apply to this resource. Use the table’s pagination to move through all zero-fee rows.