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 | ||||
| settlement | pays | kUSD | cost USD | bp |
| gross | 30 | 1265 | 3137.5 | 24.80 |
| bilateral | 13 | 625 | 1537.5 | 24.60 |
| hub via HK | 5 | 1000 | 1592.5 | 15.93 |
| direct net | 4 | 520 | 1140.0 | 21.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
- Chapter 1 · Each Receipt or in Batches: One Month's Ledger of Conversion Friction
- Chapter 2 · The Price of Waiting: How Exchange-Rate Risk Pushes the Square Root towards a Cube Root
- Chapter 3 · A Network of Currency Channels: Minimum-Loss Flows and the Shadow Price of Money
- Chapter 5 · A Month's Conversion Calendar: Dynamic Programming, Minimum Charges and Volume Tiers
- Chapter 6 · Robustness: Wrong Parameters, Fat-Tailed Rates and a Written Loss Budget
- Chapter 7 · Eastern and Western Sources Examined: the Quanfu Office Gathers and Releases, Fibonacci Chains the Rates
- Chapter 8 · Closing the Loop: the Monthly Batch Table, the Conversion Batch Calculator and a Pre-Registered Test