Blog · Finance metrics and formulas · Finance and FP&A teams
Compare receivables, inventory and payables across currencies using supplied exchange rates. Separate operating changes from currency effects and test cross-border collection and transit assumptions.
International working capital compares the cash tied up in trade receivables and inventory, less supplier payables, across currencies. Align the source balances, convert them with supplied rates and separate the currency effect before interpreting an increase as slower operations.
Use a defined trade measure for each entity:
Trade working capital = Trade receivables + Inventory - Trade payables
The existing working-capital guide covers the broader balance-sheet measure. Here, the job is comparing operating balances for a US multinational, with a common management reporting currency of USD.
Choose one cutoff date, one receivables basis and consistent inventory classifications. Preserve the original entity, currency, account, document reference and local amount. Keep a separate rate table identifying the source, rate date and quotation convention. Treasury or finance supplies and approves those rates.
This is an analytical comparison. Keep reported ledger amounts alongside it and reconcile differences to the controller's reporting policies. Inventory and monetary balances can require different accounting treatments; applying one management rate here does not establish a financial reporting policy.
The fictional US company below prepares a management snapshot on September 30, 2026. All rates are assumptions expressed as USD per one unit of local currency, rather than live market quotations. Intercompany trade balances have already been excluded from this external-trade view.
| Entity | Currency | Receivables (local units) | Inventory (local units) | Payables (local units) | USD per local unit | Net trade balance (local units) | Trade working capital (USD) |
|---|---|---|---|---|---|---|---|
| US operation | USD | 180,000 | 120,000 | 90,000 | 1.00 | 210,000 | 210,000 |
| European operation | EUR | 150,000 | 100,000 | 80,000 | 1.10 | 170,000 | 187,000 |
| Canadian operation | CAD | 120,000 | 80,000 | 50,000 | 0.75 | 150,000 | 112,500 |
| Total in USD | 509,500 |
With columns A:H matching the table, calculate the local trade balance in G2:
=C2+D2-E2
Convert it to USD in H2:
=G2*F2
Fill both down, then total USD balances in H5:
=SUM(H2:H4)
Do not total column G: its rows use different currencies. If the supplied quotation is local units per USD, divide by that rate instead. Labeling the convention avoids an inverted conversion.
Cross-check the USD total by converting the components separately:
| Check | Converted amount (USD) |
|---|---|
| Receivables: 180,000 + 165,000 + 90,000 | 435,000 |
| Inventory: 120,000 + 110,000 + 60,000 | 290,000 |
| Payables: 90,000 + 88,000 + 37,500 | 215,500 |
| Receivables + inventory - payables | 509,500 |
The component check must equal the sum of the entity results. Dollar results are shown to whole dollars; the arithmetic in this example needs no rounding.
Exchange rates can change between agreeing a transaction and receiving payment, as the International Trade Administration explains. A management snapshot can also change in USD while its local balances remain unchanged.
Hold every local balance above fixed. Use a comparison EUR rate of 1.00 USD per EUR, leaving the other rates unchanged:
| Entity | Net trade balance (local units) | Comparison rate | Snapshot rate | Comparison value (USD) | Snapshot value (USD) | Currency effect (USD) |
|---|---|---|---|---|---|---|
| US operation | 210,000 | 1.00 | 1.00 | 210,000 | 210,000 | 0 |
| European operation | 170,000 | 1.00 | 1.10 | 170,000 | 187,000 | 17,000 |
| Canadian operation | 150,000 | 0.75 | 0.75 | 112,500 | 112,500 | 0 |
| Total in USD | 492,500 | 509,500 | 17,000 |
For this table in A:G, the currency effect in G2 is:
=B2*(D2-C2)
The $17,000 increase is entirely a rate effect. It is not evidence of longer collection times, and it is not automatically a realized currency gain or loss. A period-to-period operating bridge also needs the previous period's local balances restated at the same comparison rates.
Currency normalization leaves the operating questions visible. The International Trade Administration's payment-method overview describes open-account sales as shipments delivered before payment is due. Use the actual agreed terms and expected bank receipt date for each customer rather than assuming invoice date equals available cash.
Suppose the European operation's credit sales are EUR 150,000 over a 30-day planning period, spread evenly. Extending collection time by 10 days gives:
| Timing assumption | Calculation | Result |
|---|---|---|
| Daily credit sales (EUR) | 150,000 / 30 | 5,000 |
| Additional receivables (EUR) | 5,000 × 10 | 50,000 |
| Additional funding (USD) | 50,000 × 1.10 | 55,000 |
In a spreadsheet, the last calculation is =150000/30*10*1.10. This is a sensitivity under flat sales, not a prediction of collections. Keep all other assumptions fixed and the company's trade balance rises to $564,500: $509,500 + $55,000.
Tag inventory in transit within the owned inventory balance and inspect its expected availability date. A longer route can tie up cash before goods can be sold even when customer terms are unchanged. Use working-capital days for the resulting operating-cycle comparison and initial working capital when establishing a new overseas operation.
Upload prepared entity exports and your supplied exchange-rate assumptions: Covirage maps the columns, and its tools compute and check the comparable balances and currency bridge. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See Covirage for finance teams for the supporting context.
Keep original currency amounts, then convert them to one reporting currency before adding them. Label the rate convention and date. Adding euros, Canadian dollars and US dollars directly creates a total with no useful unit and can disguise the largest exposures.
Not necessarily. A stronger foreign currency can increase the dollar equivalent of unchanged local balances. Compare the same balances at fixed rates to separate that effect, then examine inventory and collection timing using consistent operating measures.
Use the controller's ownership and inventory policies to establish which entity carries the goods at the reporting date. Tag the transit portion separately within that balance. Do not add a shipment again merely because a logistics file also lists it.
No. A management comparison may normalize balances at explicitly chosen rates to isolate operating changes. The controller's financial reporting translation and remeasurement policies remain a separate requirement. Preserve the reported balances and label the analytical conversion so readers can reconcile the two views.