Foreign-currency reconciliation becomes unreliable when a single converted number replaces the evidence behind it. This study treats each transaction as a pair of amounts connected by a rate, date, source, and accounting purpose. It distinguishes an open balance at period end from a settled balance and distinguishes remeasurement from realized settlement difference.
Cash & Treasury
Foreign-currency bookkeeping: evidence for rate, date, and settlement differences
A bounded research framework for reconciling foreign-currency transactions, remeasurement entries, and realized settlement differences.
Published · 10 listed sourcesKey takeaways
- Currency amount, functional-currency amount, and rate date are separate fields.
- Unrealized and realized differences need different evidence.
- Rate policy is an owner decision, not an unexplained spreadsheet choice.
Research question
Record structure
For each material transaction, retain transaction currency, functional currency, original amount, recorded rate, rate date, source, settlement amount, settlement date, and resulting difference. The rate source should be named rather than described as “spot” without evidence. A system-generated rate can be acceptable when its configuration and extraction date are retained.
Reconcile by currency and account before combining totals. A functional-currency balance can agree while a currency subledger is incomplete. Compare opening balance, new transactions, settlements, remeasurement, and closing balance. The reconciliation difference should be shown in both currencies when practical, with rounding rules documented.
Findings
The strongest review signal is a rate-date exception: transactions using a rate that does not match the approved convention, open items with no rate evidence, or settlements whose realized difference was posted to an unapproved account. These are not proof of error, but they identify where the owner should look. Report exception count and amount for the month and the prior comparable period.
Do not use a manual rate adjustment to force a bank reconciliation to zero. A bank fee, timing difference, or settlement spread may be real. Preserve the bank advice, source-system record, and calculation. The bookkeeper can prepare the bridge; the owner decides the accounting classification and policy interpretation.
Handoff and limitations
Remote support can extract transactions, document the conversion evidence, reconcile bank and subledger balances, and queue exceptions. The owner retains responsibility for functional currency, presentation, tax treatment, and unusual instruments. This framework does not prescribe rates or settle differences under a particular reporting standard.
The conclusion is that foreign-currency evidence is reviewable when amounts, rates, sources, dates, and settlement status remain visible. Aggregating too early removes the very dimensions needed to explain the close.
Source notes
The linked standards and control authorities provide context; the entity’s approved accounting policy remains decisive.