Multi-currency accounting: transactions, FX rates and reporting

Keep source and reporting values separate

A multi-currency accounting system should retain the original currency and amount for every transaction. It can then calculate a functional- or base-currency amount using an approved exchange rate. Replacing the source amount with the converted value destroys evidence and makes later review harder.

Transaction date and closing rate

Transactions are generally recorded using a rate appropriate to the transaction date under the applicable accounting policy. At reporting dates, certain monetary balances may require retranslation using a closing rate, with exchange differences recognized appropriately. Requirements vary, so statutory treatment should be confirmed with a qualified professional.

What to store

• Original amount and currency.
• Converted amount and base currency.
• Exchange rate and effective date.
• Rate source, import or manual-entry status.
• Rate-version identifier and reviewer.
• Any realized or unrealized exchange difference.

Opening balances matter

When a workspace changes its base currency or begins using a new reporting system, opening balances must reconcile in both source and base-currency terms. Do not apply a current rate blindly to historical equity or settled transactions.

Forecasting across currencies

Model contractual receipts and payments in their expected currencies, then translate scenarios using documented rate assumptions. This separates operational performance from currency movement and lets users understand both exposures.

Review controls

Validate that document currency agrees with the selected currency, flag missing rates and prevent silent overwrites of approved rate versions. NanoFora retains original and converted values from upload through reporting, audit findings and AI financial forecasting.