Author: vitorcherulli

Modern finance teams are drowning in analytics. Revenue dashboards update in real time, marketing spend is attributed down to the click, and procurement can tell you the unit cost trend of every input going back five years. Data-driven decision making has conquered almost every corner of the business.

Almost. There is one line of spend that routinely escapes this scrutiny, despite touching every international transaction a company makes: the cost of exchanging and moving currency. For businesses with meaningful cross-border activity, foreign exchange is often one of the larger unexamined expenses on the books. It escapes analysis not because it is small, but because it is invisible by design.

Why FX Costs Evade Normal Analysis

Most costs announce themselves. A software subscription generates an invoice. A salary appears on the payroll run. FX costs do neither. They arrive embedded inside exchange rates, deducted before money ever lands, and split across intermediaries that never appear in the company’s records.

Consider what happens when a business receives a $100,000 payment from a US customer into a euro account. The bank converts it at its own rate, which might sit 1.5% away from the mid-market rate. Nothing on the statement says “fee: $1,500.” The statement simply shows a euro amount, and unless someone checks that amount against the interbank rate at the moment of conversion, the cost never becomes a data point at all.

Multiply that across every incoming payment, every supplier settlement, every intercompany transfer, and a mid-sized international business can easily be spending six figures a year on currency conversion without a single line item recording it. From an analytics perspective, this is the worst kind of cost: material, recurring, and generating no data exhaust.

Treating FX as a Data Problem

The fix is to treat currency costs the way an analyst would treat any other opaque process: instrument it, baseline it, then look for the variance. That is essentially what running an FX audit involves. The methodology is straightforward enough that most finance teams can execute a first pass internally, and the dataset it produces tends to justify the effort within the first afternoon.

The core procedure has three steps:

1. Reconstruct the transaction log. Pull every foreign currency transaction from the past six to twelve months: incoming payments, outgoing payments, and conversions between accounts. For each one, record the date, time where available, currency pair, amount sent and amount received.
2. Benchmark against mid-market. For each transaction, look up the interbank mid-market rate at the time of execution. Historical rate data at daily granularity is freely available and sufficient for a first analysis. The difference between the rate received and the mid-market rate, expressed as a percentage, is the effective spread paid on that transaction.
3. Aggregate and segment. Sum the spreads into a total annual cost, then segment the way you would any other dataset: by provider, by currency pair, by transaction size, by month. This is where the findings get interesting.

What the Data Typically Reveals

Companies that run this analysis for the first time tend to find the same patterns—consistent, quantifiable, and actionable.

• Effective spreads are far higher than anyone assumed. Businesses that believed they were paying “around half a percent” routinely discover blended costs of 1.5% to 3% once every embedded margin is counted.
• Inconsistency. The same provider often applies visibly different spreads to different transactions, with smaller payments and less common currency pairs carrying the widest margins. Plotting spread against transaction size usually produces an unmistakable downward curve, which is useful evidence when renegotiating terms.
• Concentration. A handful of currency corridors typically account for the large majority of total cost. That matters because it means the problem is tractable. Fixing pricing on two or three pairs captures most of the available saving.
• Unnecessary conversions. Money converted into the home currency and then converted back out again weeks later to pay suppliers in the original currency—with the business paying a spread in both directions for a round trip that served no purpose.

From One-Off Audit to Ongoing Metric

A single audit produces a snapshot and usually a round of savings. The larger opportunity is turning the exercise into a permanent metric, because currency costs have a habit of drifting back upward when nobody is watching.

The instrumentation is minimal. Log every conversion with its received rate and the concurrent mid-market rate, and compute the spread automatically. Feed it into whatever dashboard the finance team already uses. From there, effective FX cost becomes a KPI like any other: tracked monthly, reviewed quarterly, and flagged when it moves outside an agreed band.

Some teams go further and set a formal cost budget for FX, in the same way they budget cloud spend, then hold providers to it. Once the number is visible, that conversation becomes straightforward. Providers quote sharper rates to customers who demonstrably measure them.

The Broader Lesson

There is nothing exotic about any of this. It is the standard analytics playbook, applied to a cost category that has historically escaped it: capture the data, establish a benchmark, segment the variance, operationalize the metric. The only unusual feature of FX costs is how long they have managed to avoid the treatment.

For data-literate finance teams, that is less a problem than an opportunity. The tooling already exists, the data is recoverable from existing statements, and the savings—unlike most analytics projects—drop straight to the bottom line.