What does Cross-Border Settlement Friction and Conversion Batches conclude, in numbers, about “Offset Before You Transfer: Multilateral Netting and the Fewest Payments”?

Answer: Chapter 4 shows that direct multilateral netting costs only 0.363 of paying invoice by invoice.

Scope of the numbers: All fees, rates, volatilities, amounts and group structures are illustrative; all calculations are generated by the book's programs; the book is not individual legal, tax or financial advice. Marked boxes separate published evidence, runnable Python calculations (19 programs), classical sources and the author's hypotheses.

中文版

Data table

The numbers below are printed verbatim by the chapter's Python program and can be reproduced by running it. standard-library Python onlyprinted values that match the answer: 0.363

net position kUSD: CN +480 HK -40 US -355 DE +40 SG -40 UK -85
settlementpayskUSDcost USDbp
gross3012653137.524.80
bilateral136251537.524.60
hub via HK510001592.515.93
direct net45201140.021.92
direct-net cost / gross cost = 0.363; hub / gross = 0.508
fixed fees: gross 750 USD, direct net 100 USD
Show the full program
# Chapter 4. p41: gross, bilateral and multilateral settlement of one month.
# Six group entities owe each other for goods and services under real
# contracts (matrix in kUSD-equivalent, illustrative). Each entity keeps
# one functional currency. A payment costs a fixed 25 USD, 5 bp for the
# transfer and, when the two currencies differ, a 15 bp conversion.
# Gross: every invoice paid. Bilateral: each pair nets to one payment.
# Hub: a centre in HK (USD) receives or pays each entity's net position
# once. Direct: the same net positions settled payer to receiver,
# largest first, so money never passes through the centre. Netting is
# lawful only where the rules of every jurisdiction involved permit it
# and every underlying invoice is recorded and declared in full; the
# model does not decide that.
import math

ENT = ["CN", "HK", "US", "DE", "SG", "UK"]
CCY = {"CN": "CNY", "HK": "USD", "US": "USD", "DE": "EUR",
       "SG": "SGD", "UK": "GBP"}
PAY = [  # PAY[i][j]: what entity i owes entity j this month
    [0, 40, 25, 30, 10, 15],
    [120, 0, 35, 20, 15, 10],
    [260, 60, 0, 120, 20, 30],
    [60, 25, 40, 0, 10, 35],
    [70, 15, 10, 5, 0, 5],
    [90, 20, 25, 35, 10, 0]]
FIX, WIRE, FX = 25.0, 5, 15


def pay_cost(a, b, amount):
    bp = WIRE + (FX if CCY[a] != CCY[b] else 0)
    return FIX + bp * amount / 10.0


def report(name, payments):
    vol = math.fsum(p[2] for p in payments)
    cost = math.fsum(pay_cost(*p) for p in payments)
    print("%-13s %5d %9.0f %10.1f %8.2f"
          % (name, len(payments), vol, cost, cost / vol * 10.0
             if vol else 0.0))
    return cost


n = len(ENT)
gross = [(ENT[i], ENT[j], PAY[i][j]) for i in range(n) for j in range(n)
         if PAY[i][j]]
bilat = []
for i in range(n):
    for j in range(i + 1, n):
        d = PAY[i][j] - PAY[j][i]
        if d > 0:
            bilat.append((ENT[i], ENT[j], d))
        elif d < 0:
            bilat.append((ENT[j], ENT[i], -d))
net = {e: 0 for e in ENT}
for a, b, x in gross:
    net[a] -= x  # step
    net[b] += x  # step
hub = []
for e in ENT:
    if e != "HK" and net[e] < 0:
        hub.append((e, "HK", -net[e]))
    elif e != "HK" and net[e] > 0:
        hub.append(("HK", e, net[e]))
owe = {e: -v for e, v in net.items() if v < 0}
get = {e: v for e, v in net.items() if v > 0}
direct = []
while owe:
    a = max(sorted(owe), key=lambda e: owe[e])
    b = max(sorted(get), key=lambda e: get[e])
    x = min(owe[a], get[b])
    direct.append((a, b, x))
    for book, e in ((owe, a), (get, b)):
        book[e] -= x  # step
        if book[e] == 0:
            del book[e]
print("net position kUSD: " + "  ".join("%s %+d" % (e, net[e])
                                         for e in ENT))
print("%-13s %5s %9s %10s %8s"
      % ("settlement", "pays", "kUSD", "cost USD", "bp"))
g = report("gross", gross)
b = report("bilateral", bilat)
h = report("hub via HK", hub)
d = report("direct net", direct)
print("direct-net cost / gross cost = %.3f; hub / gross = %.3f"
      % (d / g, h / g))
print("fixed fees: gross %d USD, direct net %d USD"
      % (FIX * len(gross), FIX * len(direct)))

Single source and citation

Fan, Y. (2026). Cross-Border Settlement Frictions and Compliant Treasury Scheduling: Minimum-Loss Network Flows over Multi-Currency Channel Fees and Conversion Slippage (Version 1.0.0), Chapter 4: Offset Before You Transfer: Multilateral Netting and the Fewest Payments. 5D Library. DOI pending

DOI pending · monograph page goes live after publication · 5DL-B-280 · v1.0.0 · CC-BY-NC-ND-4.0

BibTeX
@book{fan2026280,
  author    = {Fan, Yafu},
  title     = {Cross-Border Settlement Frictions and Compliant Treasury Scheduling: Minimum-Loss Network Flows over Multi-Currency Channel Fees and Conversion Slippage},
  year      = {2026},
  publisher = {5D Library},
  edition   = {1.0.0},
  note      = {DOI pending}
}

Other chapter answers in this book