🎓 CoursesMarkets & internationalAdvanced⏱ 60 min

Managing interchange and merchant fees. 6 chapters and a final quiz.

The job of a payments manager who negotiates acquiring, step by step. Build a usable cost base, unpack an interchange++ statement line, trace the gap between the gross submitted and the net settled, identify the regime that applies to each transaction, set up least-cost routing without losing approvals, and decide on a compliant surcharge where surcharging is allowed. Then run an RFP priced on your own data and write the clauses that make the agreement enforceable.

Chapter 1. Building your cost base.

The cost base is the transaction dataset a merchant uses to negotiate acquiring, plus the handful of metrics derived from it. The payments manager assembles it before the first meeting, from an extract supplied by the incumbent acquirer. A rolling 12 months is the minimum, and both parties must be able to verify every line. A negotiation built on a headline rate and a hunch ends in a cosmetic discount, calculated on a card mix nobody has measured. You build the cost base once, then refresh it every quarter, because a card mix shifts faster than a contract.

What to ask your acquirer for, and in what format

  • A transaction-level extract, not a summary report: a monthly aggregate blends together exactly the dimensions you are trying to see
  • A rolling 12 months at minimum, to absorb seasonality and promotional campaigns
  • A machine-readable format: CSV or a standard settlement file, never a 30-page PDF
  • The unique transaction identifier (ARN or its local equivalent), the only way to reconcile the statement, the batch log, and the remittance advice
  • The card’s country of issue, derived from the BIN by the acquirer: this is what moves a line inside or outside a cap
  • The exact card product (consumer debit, consumer credit, commercial, prepaid), not just the brand
  • The authorization result, declines included: a declined transaction still costs money and shows up in no fee rate
  • The interchange program code applied by the network, when the acquirer reports it: it names the rate schedule actually used
Working template: three queries that produce the cost base
-- Minimum columns expected in the extract:
--   arn, processing_date, gross_amount, currency, brand, card_product,
--   issuer_country, channel, auth_result,
--   interchange, scheme_fees, margin, ancillary_fees

-- 1. Overall effective MDR, in basis points
SELECT ROUND(10000.0 * SUM(interchange + scheme_fees + margin + ancillary_fees)
             / SUM(gross_amount), 1) AS effective_mdr_bp
FROM transactions
WHERE auth_result = 'CAPTURED';

-- 2. The same calculation by segment: this is the table you bring to the negotiation
SELECT card_product, issuer_country, channel,
       COUNT(*)          AS txn_count,
       SUM(gross_amount) AS gross,
       ROUND(10000.0 * SUM(interchange)  / SUM(gross_amount), 1) AS interchange_bp,
       ROUND(10000.0 * SUM(scheme_fees)  / SUM(gross_amount), 1) AS scheme_bp,
       ROUND(10000.0 * SUM(margin)       / SUM(gross_amount), 1) AS margin_bp
FROM transactions
WHERE auth_result = 'CAPTURED'
GROUP BY card_product, issuer_country, channel
ORDER BY gross DESC;

-- 3. The cost nobody counts: declined attempts
SELECT COUNT(*)            AS declines,
       SUM(ancillary_fees) AS fees_billed_on_declines
FROM transactions
WHERE auth_result = 'DECLINED';

The effective MDR is total payment-related fees divided by gross volume collected over the same period. It is the only figure that compares across offers, provided both calculations use the same scope in the numerator. Acquirers calculate it differently. Dispute fees belong in the numerator, and so do monthly minimums. Express the result in basis points, never as a percentage rounded to two decimal places, because rounding erases the very order of magnitude you are trying to measure. A 10-basis-point gap on 50 million collected is worth 50,000 currency units a year, and that calculation alone tells you how much effort the negotiation deserves.

IndicatorWhat it measuresWhere to find itWhat it decides
Effective MDRTotal payment cost divided by gross volume collectedTransaction-level extract and monthly invoiceThe size of the ask, in basis points
Mix by card productShare of volume on commercial, premium, and prepaid cardsCard product column in the extractWhat falls outside the caps, and so cannot be negotiated through the rate
Inter-regional shareVolume on cards issued outside the acquiring regionCountry of issue derived from the BINExposure to the highest rate schedules and to inbound tourism
Unit authorization costFixed fee billed per attempt, declines includedPricing appendix, cross-checked against the decline countThe real price of a high decline rate and of subscription retries
Dispute costsFee per case opened, regardless of outcomeDedicated line on the monthly statementWhat an investment in deflection or fraud prevention is worth
Five metrics to produce before any RFP
⚠️
Four calculation errors that undermine the whole case
Four calculation errors keep coming up when merchants build their effective MDR. Dividing by the net amount settled instead of the gross amount submitted lowers the rate artificially, by exactly the amount of the fee, and picking a slow month flatters the result further. Ignoring declined authorizations wipes out an entire cost line, one that grows with every subscription retry and every automatic reattempt. Counting authorized volume rather than captured volume inflates the denominator. Each of the four shows up in the extract file if you check the denominator used, the period chosen, and how declined attempts were treated. A sales brochure shows none of these three.
🎯 Quick question
Why insist on a transaction-level extract rather than a monthly summary report?