Multi-currency accounting and FX revaluation
A business that sells in one currency and pays its wages in another is running a trading position whether it intends to or not. This article sets out which rate belongs on which transaction, what revaluation is actually for, and why the difference between the invoice and the money that arrived is a number worth knowing every month rather than once a year.
IN SHORT
| Multi-currency accounting records every foreign transaction in both the original currency and the reporting currency, at the rate for the date it happened; revalues foreign balances at each month end; and separates exchange differences from trading result. Done monthly it is a control. Done once a year at audit it is a plug figure nobody can explain. |
SECTION 1
The pattern
Most businesses in the region hold foreign currency somewhere. A United States dollar bank account, a supplier invoiced in dollars, a hotel contract priced in dollars, a loan denominated in dollars. Very few of them account for it as a currency position. They account for it as a number somebody converted once.
The arrangement that produces this is almost always the same, and it has four parts.
The rate is a keystroke. A rate is typed in by hand. Somebody looks up a rate, or remembers one, or copies the rate from the last invoice, and types it into the entry. It is rarely the rate for the date of the transaction, because the entry is usually made days or weeks afterwards.
The original amount disappears. Once the conversion is made, the ledger holds only the converted amount. The original currency figure survives on the paper invoice and nowhere else, so the question “how many dollars do we actually have outstanding” cannot be answered from the accounts at all.
The balance is never remeasured. A foreign currency bank account sits in the ledger at whatever rate it was last converted at, sometimes for months. The account agrees in dollars and disagrees in local currency, and the difference is treated as a reconciling item rather than as what it is, which is a movement in value.
The difference is discovered at audit. At year end the auditor asks for the exchange differences, a schedule is built retrospectively, and a single figure is posted to make the accounts agree. Nobody in the business can say which month it arose in or which transactions caused it.
| THE TWO-DATE TEST — take the largest foreign currency invoice you issued or received last quarter. What rate was used when it was recorded, what rate applied when the money actually moved, and where in your accounts is the difference between the two? In most businesses the answer to the third question is that it is nowhere, because it was absorbed into revenue or into the expense without anybody noticing. |
This is the reframe the article rests on. Currency is not an administrative detail of the bookkeeping; it is a second set of results running alongside the trading results. A business can have an excellent month commercially and a poor month in total because the currency moved against it, or the reverse, and if the two are added together before anybody sees them, neither one has been managed. The purpose of multi-currency accounting is not tidier records. It is to keep the two apart so that each can be read.
SECTION 2
The Caribbean variant
Six regional conditions make this materially harder here than the textbook treatment suggests.
Functional currency is genuinely ambiguous. A hotel prices in dollars, collects in dollars, and pays wages, utilities and statutory deductions in local currency. A distributor buys in dollars and sells locally. Neither is obviously a single-currency business, and the determination of functional currency is a judgement made on the facts rather than a preference. It is frequently never documented at all, and the question arrives for the first time from an auditor, years into the trading history.
Access to foreign currency is not the same as owning it. Holding a receivable in dollars does not mean you can buy dollars when you need them. Where access is rationed or delayed, a business can be long on paper and short in practice, and the exposure that matters is not the accounting one but the timing of access. Accounts that cannot show the currency position by account and by date cannot support that conversation with a banker.
There is more than one rate, and they are not close together. There is the published central bank rate, there is the weighted average selling rate, and there is the rate your bank actually gave you on the day, which will be neither. The spread between the rate used in the books and the rate applied to the money is a real cost and it is usually unrecorded, because the entry was made at the published rate and the difference went to a reconciling line.
The drift runs one way. Where the local currency depreciates over time, conversion errors do not offset each other over a year. They accumulate in one direction. A stale rate used consistently for six months does not average out; it understates or overstates steadily and the correction, when it comes, is large.
The tax authority prescribes its own basis. The tax return is filed in local currency. Where an invoice is denominated in foreign currency, the conversion basis and the conversion date for consumption tax, withholding and income tax purposes are prescribed, and they are not always the same date the accounting standard uses. A convention adopted casually is assessed years later with interest attached.
Group balances are recorded twice, in two currencies. An intercompany balance recorded in dollars by one entity and in local currency by the other will not agree, and the difference will grow every month. Consolidation then begins with an argument about which side is right rather than with a set of numbers.
SECTION 3
What it costs
The figures below are indicative, drawn from advisory experience across the region rather than from survey, and the rates used are illustrative.
Margin is misstated in both directions. On a US$100,000 sale recorded at a rate of 158 and settled three months later at 161, the business receives J$300,000 more than it recorded. That is a gain, and it is welcome, but it is not trading performance and it should not sit inside gross margin. Where the movement runs the other way on a purchase, the same J$300,000 is a loss buried in cost of sales, and the margin reported to the board is wrong in both cases.
Pricing is set against a rate that has moved. In a distribution business running a net margin in the low single digits, a three per cent adverse movement between the purchase and the payment is the entire margin on the transaction. Businesses that price off the rate in an old quotation template are, in effect, quoting last quarter’s currency.
The year-end exercise is expensive twice. Building the retranslation schedule retrospectively at year end takes days of senior time, and it is then re-performed by the auditor, who bills for that. Late accounts and audit adjustments follow, and where covenant or lender reporting has already gone out on the pre-adjustment numbers, the correction has to be explained rather than simply posted.
The tax exposure compounds quietly. An incorrect conversion basis on returns is not usually discovered by the business. It is discovered on audit by the revenue authority, applied across every period it affected, with interest.
The bank spread is paid but not counted. The difference between the rate in the books and the rate the bank applied is a cost of doing business, and it is negotiable at the margin. A business that cannot measure it has no basis on which to discuss it with its bankers.
| A business with foreign currency revenue and local currency costs is running a trading position whether it intends to or not. The only question is whether it is measured. |
SECTION 4
What the capability actually does
Nine mechanisms, in the order they apply to a transaction, and then the limits. The treatment throughout is the one required by IAS 21, The Effects of Changes in Foreign Exchange Rates, which determines which rate applies to which item, when a balance must be remeasured, and where the resulting difference is reported.
Functional currency is determined and recorded. Which currency the business actually operates in is determined on the facts set out in IAS 21 — the currency that influences selling prices, the currency of the costs that determine those prices, the currency in which financing is denominated and receipts are retained — and the reasoning is written down once, so that it is available the next time it is asked for rather than reconstructed.
Every transaction is held in both currencies. The dollar invoice is held as a dollar invoice. The reporting currency figure is derived from it rather than replacing it, so the outstanding balance can be read in either currency at any time, and the conversion can be re-performed without anyone re-keying anything.
Rates arrive automatically and dated. Rates are loaded on a schedule from an agreed source rather than typed in by the person making the entry. Nobody has to know today’s rate, and nobody can accidentally use last month’s.
The rate applied is the rate for the transaction date. An invoice dated the third is converted at the rate for the third, whether it is entered on the third or on the twenty-eighth. This single behaviour removes the largest source of unexplained difference in most ledgers.
Monetary balances are revalued at each period end. At each month end, balances that will be settled in cash — foreign currency receivables, payables, bank accounts and loans — are remeasured at the closing rate and the difference is posted to a designated exchange account. Items that will not be settled in cash, such as fixed assets bought in dollars, stay at the rate that applied when they were acquired. That distinction — monetary against non-monetary, in the language of IAS 21 — is the whole of revaluation, and it is where most manual attempts go wrong.
Realised differences are calculated against the money, not the table. When the money actually moves, the difference between the amount recorded and the amount received or paid is calculated against the actual proceeds, not against a published rate. The bank’s spread therefore lands in the accounts as a measurable figure instead of vanishing into a reconciling item.
Foreign currency bank accounts reconcile in their own currency. The dollar account reconciles in dollars against the dollar statement. The reporting currency equivalent follows from the revaluation rather than being reconciled separately, which ends the familiar situation of an account that agrees in one currency and not in the other.
The management pack separates trading result from currency movement. Trading result and exchange difference are presented as two lines, not one. The question “was that a good month, and separately, what did the currency do to us” becomes answerable from the management pack without further analysis.
Intercompany balances follow a single stated policy. Group balances are held in one agreed currency with one agreed rate policy applied by both sides, so intercompany positions agree before consolidation begins rather than being reconciled afterwards.
What multi-currency handling does not do
- It does not hedge anything. Measuring an exposure is not managing it. Whether to forward-cover, price in a different currency or hold a natural offset is a commercial decision that stays with the business.
- It does not obtain foreign currency. Where access is rationed, better records make the case to the bank; they do not create the supply.
- It does not decide functional currency by itself. The determination is a judgement on the facts, taken by the business, and one an auditor is entitled to challenge.
- It does not repair a contract priced in the wrong currency. If the exposure was created at the point of sale, accounting for it correctly will report the loss accurately rather than prevent it.
- It does not remove the bank’s spread. It makes it visible, which is the precondition for negotiating it.
- It does not override the tax rules of each territory, which prescribe their own conversion basis and dates, and which the return must follow regardless of the accounting treatment.
The point that persuades most owners is the separation. Once the exchange difference has its own line, the argument about whether a month was good stops being an argument. The currency did what it did, the business did what it did, and the two are visible apart.
SECTION 5
How the Accounting Services BPO Division delivers it
The determination is made and documented at the start. The functional currency question is asked at onboarding, tested against the facts of the business, and documented with the reasoning on file so that it is available to the auditor rather than argued about at year end.
The rate policy is agreed in writing. Source, timing, and which rate applies to what — transactions, month end revaluation, tax returns, intercompany — are agreed with you in writing before anything is posted, and changes to that policy require your authority.
Rates are loaded and checked against reality. Rates are loaded daily from the agreed source, and the rates actually applied by your bank on settled transactions are compared against them, so the spread is reported rather than absorbed.
Revaluation runs monthly inside the close calendar. Revaluation is a step in the nine-day close, not a year-end project. The schedule produced is a working paper in the form the auditor expects, which shortens the audit rather than lengthening the close.
You get a currency exposure report every month. Each month you receive what you hold and what you owe in each currency, at the closing rate, with the movement since last month and the split between trading result and exchange difference. It is one page and it is the page most boards find they have never had.
Tax conversions follow the territory, not the ledger. Conversions for consumption tax, withholding and income tax are prepared on the basis each territory prescribes, which may differ from the accounting rate, and the return is presented to you for approval before filing.
SECTION 6
Where to start
In the next thirty days. List every balance you hold in a currency other than your reporting currency — bank accounts, receivables, payables, loans — and for each one establish whether your ledger still holds the original currency amount or only a converted figure. Then agree one rate source and write it down. Both steps cost nothing and the first one usually settles the argument about whether a change is needed.
In thirty to ninety days. Stop typing rates. Load them, apply the transaction-date rate, and run a revaluation of monetary balances at month end with the difference posted to its own account. Then split the management pack so that exchange differences sit outside trading margin.
Beyond ninety days. Document the functional currency determination. Agree an intercompany rate policy that both sides of every group balance apply. Add the exposure report to the monthly pack and review pricing against the current rate rather than the rate in the quotation template. Then check the conversion basis used on returns against what each territory actually requires.
| The test: can you say today, in one number per currency, what you hold, what you owe, and at what rate each was last measured? If not, the exposure is not badly managed. It is unknown. |
REFERENCE
Frequently asked questions
How does multi-currency accounting work?
Each transaction is recorded in its original currency and translated into the reporting currency at the rate for the transaction date. The original amount is retained, so balances can be read in either currency. At each month end, balances that will be settled in cash are remeasured at the closing rate and the difference is posted to an exchange account, keeping currency movement separate from trading result.
What is FX revaluation and how often should it be done?
Revaluation is the remeasurement of foreign currency monetary balances — bank accounts, receivables, payables and loans — at the closing rate, with the resulting difference taken to profit or loss. IAS 21 requires it at the end of each reporting period, and requires non-monetary items carried at historical cost to stay at the rate that applied when they were acquired. It should therefore be run at every reporting date, which for a business with a monthly management pack means monthly. Annual revaluation produces a figure nobody can attribute to a month or a transaction.
Which exchange rate should we use?
For recording a transaction, the rate for the date of the transaction. For period-end balances, the closing rate. For items that will not be settled in cash, such as an asset purchased in foreign currency, the rate that applied when it was acquired. The source — central bank published rate, weighted average selling rate, or your own bank’s rate — should be chosen once, stated in the accounting policy and applied consistently.
What is the difference between a realised and an unrealised exchange difference?
An unrealised difference arises when a balance still outstanding is remeasured at a new rate; the money has not moved. A realised difference arises on settlement, when the amount actually received or paid differs from the amount recorded. Both are reported in profit or loss, but only the realised one has affected cash, and a board reading a single combined figure cannot tell how much of it is which.
Most of our sales are in US dollars. Should our accounts be in US dollars?
Possibly, but it is not a preference. IAS 21 determines functional currency on the facts — principally the currency that influences your selling prices and the currency of the costs that determine them, together with financing and how receipts are retained. A hotel selling in dollars but paying wages, utilities and statutory deductions locally may reach a different conclusion from an exporter. The determination should be documented, and it is one an auditor may challenge.
How should consumption tax be handled on a foreign currency invoice?
On the basis the territory prescribes, which sets both the rate source and the date to be used and may not match the rate used in the ledger. The accounting entry and the return can legitimately use different figures. What matters is that the basis used on the return is the prescribed one, applied consistently, and capable of being demonstrated years later.
| NEXT STEP
Request the Finance Function Diagnostic A 45-minute scoping conversation covering volumes, systems, entities, close cycle and reporting needs; a written recommendation on tier, scope, division of labour and transition plan; and a fixed-scope service proposal priced by process, with service levels and exit terms stated. Dawgen Global · Accounting Services BPO Division [email protected] · dawgen.global/contact-us Caribbean 876-929-3670 | 876-665-5926 · United States 855-354-2447 |
Continue reading: “Do you need a ledger, or an operating system?” · “If your bank feed is not connected, you are paying someone to retype a statement.” · “Every territory has its own tax. The group should still read as one set of numbers.”
About Dawgen Global
Dawgen Global is an independent, integrated multidisciplinary professional services firm headquartered at 47 Trinidad Terrace, New Kingston, Jamaica, serving more than 15 territories across the Caribbean. Founded and led by Dr. Dawkins Brown, Executive Chairman, the firm is independent and not affiliated with any international network. It delivers a full suite of professional services under one roof: audit and assurance; tax advisory; IT and digital transformation; risk management; cybersecurity; actuarial and insurance regulatory advisory; HR advisory; mergers and acquisitions; corporate recovery; business advisory and strategy; accounting BPO and virtual CFO services; and legal process outsourcing.
The proposition is simple: big-firm capability without the big-firm price. Dawgen Global’s integrated approach is built for the specific complexities and opportunities of the Caribbean market, helping organizations make sharper, better-informed decisions that drive measurable progress.
To explore a partnership, reach out:
- Website: dawgen.global
- Email: [email protected]
- WhatsApp (Global): +1 555-795-9071
- Caribbean offices: +1 876-665-5926 | +1 876-929-3670 | +1 876-926-5210
