Translate foreign-currency cash flows

A foreign subsidiary's customer receipt remains operating; its equipment purchase remains investing; its borrowing remains financing. Translation does not create a fourth transaction nature. It adds a separate reconciliation problem because activity may be translated at transaction-date or supported average rates while ending cash is translated at the closing rate.

Preserve native-currency evidence

Keep entity, functional currency, transaction currency, cash account, native amount, date, activity classification, applied rate, rate source, and translated amount on each row. Use actual transaction-date rates when required and available. A supported average is an approximation for qualifying activity, not a default applied without testing volatility, seasonality, or material transactions.

Do not translate all cash flows at the closing rate merely because closing cash uses it. Doing so can make the endpoint appear to reconcile while distorting activity sections.

Derive the exchange-rate effect

After translating classified cash flows on the supported basis, reconcile:

translated beginning cash population
+ translated operating, investing, and financing cash flows
+ exchange-rate effect on the cash population
= translated ending cash population

The exchange-rate effect is the amount needed to explain how rates changed the translated cash population. It is not a receipt from or payment to a counterparty and does not belong in operating, investing, or financing.

Consider a foreign account that opens at FC 100 when the rate is 1.00. It receives FC 20 at 1.05 and closes at FC 120 when the rate is 1.10:

beginning translated cash   FC 100 × 1.00 = 100
translated operating receipt FC 20 × 1.05 =  21
ending translated cash      FC 120 × 1.10 = 132
exchange-rate effect              132 - 100 - 21 = 11

The 11 difference is the exchange-rate effect on this bounded population, not additional operating cash.

Consolidate without losing lineage

Eliminate intercompany cash flows consistently and retain the currency and entity source of each elimination. Reconcile foreign bank statements in native currency before translation, then reconcile translated entity statements to the consolidated ledger. Investigate changes in functional currency, hyperinflationary conditions, acquisitions, disposals, restrictions, and account transfers as separate issues.

The calculator can recompute a supplied exchange-effect residual. It cannot choose the functional currency, approve an average rate, classify a cash flow, or establish that a bank population is complete. Those conclusions require their respective evidence and reviewers.