These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Multi-currency Accounting
- Features
- Currencies and rates
Currencies and rates
A converted amount needs a clear explanation: the currencies involved, the rate used, its effective date and why it was selected. This module keeps that evidence with the transaction and carries the same discipline into revaluation, tax reporting and consolidation.
OverviewToday's Rates×
Multi-currency Accounting · Currencies and rates
New
Today's Rates
Exchange rates
| From currency | To currency | Rate type | Effective date | Rate | Source | |
|---|---|---|---|---|---|---|
| Canadian dollar (CAD) | US dollar (USD) | Spot | 17 Oct | 390 | ECB | |
| Mexican peso (MXN) | US dollar (USD) | Average | 30 Oct | 90 | OANDA | |
| Canadian dollar (CAD) | Euro (EUR) | Closing | 11 Oct | 40 | Central bank | |
| Pound sterling (GBP) | Pound sterling (GBP) | Budget | 02 Nov | 580 | Manual | |
| Australian dollar (AUD) | Australian dollar (AUD) | Spot | 28 Oct | 40 | Integration |
6 of 6 records
Canadian dollar (CAD)Exchange rates · ER-63499
SpotTo currencyUS dollar (USD)
Effective date17 Oct
Rate390
SourceECB
Entered byClaire Dubois
What you can do
Currencies and conversion
Currencies define each currency’s code, display and decimal precision. Rounding follows the configured transaction and functional-currency rules. Differences go to the designated accounts; tax conversion differences follow the reviewed tax configuration.
A rate states how many units of the to-currency equal one unit of the from-currency. Direct and derived cross rates retain their source and calculation. A document-currency amount, receipt-currency amount and functional value are separate quantities. A cross-currency settlement stores the conversion between document and cash currencies as well as its functional carrying amounts.
Rate types
| Rate type | Purpose | Review basis |
|---|---|---|
| Spot | Routine document and cash conversion | Approved source and applicable date |
| Closing | Period-end monetary revaluation and configured balance-sheet translation | Period’s closing rate date |
| Average | Configured income-statement translation | Reporting period and calculation method |
| Budget | Group budget translation | Approved budget version and rate date |
| Historical | Equity, investment and other supported historical balances | Entity, account, originating amount and date |
| Contract | Documents covered by an agreed fixed rate | Contract evidence and permitted scope |
The accounting policy determines where each type applies. Configuring these records does not itself establish that a group’s reporting treatment or jurisdiction-specific tax rule is correct.
Rate feeds and missing rates
Treasury Analyst configures the approved feed or import with Admin and reviews Today’s Rates. Rate exceptions identify missing pairs, dates or rate types and the affected source. Draft work can be prepared while the exception is reviewed, but an absent rate must not become an unrecorded fallback at posting.
Any permitted substitute needs its source, reason and required approval recorded. Resolution refreshes the affected calculation and decision evidence. Loading a new daily rate does not silently rewrite a posted invoice, an approved settlement or a closed run. Failed imports and stale rates remain operational exceptions to resolve.
Overrides and used-rate history
Rate overrides retain the proposed and replacement rates, source document, reason, requester and approval. Treasury Analyst proposes permitted document-rate changes; Controller authorises closing-rate overrides and other changes requiring approval. Clerks can inspect the rate applied without gaining permission to change it.
A rate override is part of the calculation’s revision. If it changes the amount being approved, the old decision cannot authorise the new amount. Posted revaluation and locked consolidation retain their used-rate versions. Corrections follow a linked reversal or replacement run, preserving the earlier evidence.
Tax and authority currency
An authority may require a different conversion basis from the accounting document. Tax lines retain the accounting-rate functional value used in the GL and the separate authority reporting value and conversion difference. A prescribed reporting rate does not silently change the document journal. The filing states its reporting currency and conversion. Tax Specialist reviews the configured rule and source; filing after period close does not reopen that period for posting.
Approval limits across currencies
Approval decisions converts the source amount into the authorised person’s limit currency and freezes the amount, rate, limit and source revision used. Comparing a functional-currency total directly with a limit in another currency is refused unless a documented conversion makes them comparable.
Approval delegations record the authorised person, delegate, scope and effective dates. The actual actor remains visible. A valid limit or delegation never permits the preparer to approve their own bill, payment run or another action that requires separation.
What the Treasury Analyst sees
- Today’s Rates shows loaded pairs, rate types, sources and locked status.
- Open Foreign-Currency Invoices identifies outstanding exposure with booked-rate context.
- Pay Run Queue supports planning cash by payment currency and account.
What it keeps track of
Data model- Currencies
- ISO currency codes used anywhere in the platform, with the precision each one rounds to.
- Exchange rates
- Dated rates by type. Spot converts documents on the day, Closing revalues and translates the balance sheet, Average translates the income statement only when the average reasonably approximates the transaction-date rates; otherwise transaction-date translation is retained. Budget translates plans. Equity translates at the per-entity historical rates held in historical rates.
- Historical rates
- The rate at which an equity or investment balance was originally translated, held per entity per account, so share capital, reserves and investment in subsidiary carry the rate of the date they arose.
- Rate exceptions
- A missing or unusable conversion blocks the affected business event until an approved rate is available; it never silently falls back to 1 or a stale rate.
- Rate overrides
- Reviewed deviation from an applicable rate. The effective record and original source remain immutable; every affected posting references the approved override.
- Approval delegations
- Dated, entity-scoped substitution for an absent approver. It does not grant the delegate new permissions, bypass conflicts, or increase either person’s monetary authority.
- Approval decisions
- Immutable decision evidence tied to the exact source revision. Both the actual actor and the represented approver remain visible. Monetary limits are compared only after explicit conversion to the approver’s limit currency.
- Entities
- Legal entities consolidated under a reporting parent, plus the group consolidation unit that holds translation and elimination entries. Each legal entity owns its own trial balance, its functional currency and the accounts to which its exchange differences post.
- Bank accounts
- Bank accounts per entity and currency, each mapped to its GL account. Functional balance is the posted ledger carrying value, including unreversed revaluation; a live-rate exposure value is separate.
- Employees
- Finance users: Controller, GL accountants, Treasury Analyst, AP and AR clerks, FP&A, tax and auditors.
Who uses it
Permissions- Treasury Analyst
- Maintains currencies, rates and exceptions.
- Controller
- Approves required overrides and authority decisions.
- AP Clerk
- And AR Clerk inspect document rates.
- Tax Specialist
- Reviews prescribed tax conversion.
- FP&A Analyst
- Maintains budget-rate context.
- Admin
- Configures feeds and access.
Set up Multi-currency Accounting your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.