Multi-currency is the feature that looks simple when you switch it on and becomes confusing about four months later, usually when a foreign currency bank account refuses to reconcile and there is a gain on the profit and loss that nobody recognises.
Most multi-currency problems come from four things: the exchange rate used at each stage, the difference between realised and unrealised gains, foreign currency bank accounts revalued at period end, and the fact that enabling multi-currency cannot be undone. None of them are bugs. They are the system doing what it is designed to do.
Foreign currency account that will not reconcile? WhatsApp us the currency and the platform and we will tell you where to look.
Quick Summary
| Symptom | Cause | Where to look |
| Gain or loss you did not create | Rate moved between invoice and payment | Realised exchange gain account |
| Balance changes with no transaction | Period-end revaluation | Unrealised gain or loss |
| FX account will not reconcile | Reconciling the converted figure, not the foreign one | Reconcile in the foreign currency |
| Two reports disagree | Different rates on different dates | Rate used on each transaction |
| Cannot switch it off | Multi-currency is permanent once enabled | Nothing to look at. It is permanent |
💡 TaxKitab Tip Reconcile a foreign currency bank account in its own currency, never in your home currency. The foreign balance is a fact — the bank says you hold 12,400 USD and either you do or you do not. The home currency figure is a translation that moves every time the rate moves, so trying to match it to anything is chasing a number that was never meant to be fixed. People spend days on this before realising the account reconciled perfectly in dollars all along.
Enabling It Is Permanent
Worth knowing before you switch it on rather than after.
In both QuickBooks Online and Xero, turning on multi-currency changes how the file handles every transaction and cannot be reversed. If you enabled it to raise one invoice in euros, you now have a multi-currency file forever.
Where a business has only occasional foreign transactions, it is often simpler to record them in the home currency at the rate actually received, and keep the file single-currency. That is a decision worth taking deliberately.
Realised Gains: The Rate Moved
The most common unexplained line on a profit and loss.
You invoice a customer 10,000 USD. At that date the rate gives one home currency figure. The customer pays six weeks later and the rate has moved, so the amount that actually reaches your bank differs.
Both figures are correct. The difference is a realised exchange gain or loss, and the software posts it automatically when the payment is matched.
It is not an error and it should not be adjusted away. It is the arithmetic consequence of invoicing in one currency and being paid later.
Unrealised Gains: Nothing Happened, the Balance Moved
Harder to accept, and equally correct.
At period end, foreign currency balances — bank accounts, outstanding invoices, outstanding bills — are revalued at the rate on that date. Your home currency figure changes even though no transaction occurred.
That is an unrealised gain or loss. It reverses when the underlying item settles and the realised amount is known.
The confusion is usually about which account it lands in and whether it is real. It is real for reporting purposes and provisional in substance — it reflects where rates stood on one day.
Which Rate the System Used
Most multi-currency disagreements come down to this.
Both platforms pull rates automatically and both allow overriding them per transaction. An invoice entered with a manual rate, a payment matched at the automatic rate, and a revaluation at a third rate will produce three different home currency figures for what feels like one transaction.
When something does not agree, check the rate on each individual transaction rather than the totals. The rate is visible on the transaction in both systems.
Where rates are overridden regularly, agree one policy — automatic for everything, or a specified source for manual entry — and apply it consistently. Mixed practice is where this becomes unauditable.
Reconciling a Foreign Currency Bank Account
Reconcile in the foreign currency. The statement is in USD or AED or EUR, the account in your software holds the same currency, and those two should agree exactly.
The home currency equivalent is a translation. It is not supposed to match anything and will change at every revaluation.
If the foreign currency balance agrees and the home currency figure looks wrong, nothing is wrong. If the foreign currency balance disagrees, you have an ordinary reconciliation problem that has nothing to do with currency.
For a Business With an India Connection
One practical point. Where an Indian entity invoices a foreign parent or customer, the export characterisation generally requires payment in convertible foreign exchange, and the realisation timeline matters.
That is a GST and FEMA question rather than a bookkeeping one, but it is decided by how the transaction is actually settled — see invoicing your parent and the LUT. Recording it correctly in the books is what lets the question be answered later.
Frequently Asked Questions
Can I turn multi-currency off? No. In both QuickBooks Online and Xero it is permanent once enabled.
Why is there a gain I did not create? The rate moved between invoicing and payment. The software posts the difference as a realised exchange gain or loss automatically.
My balance changed with no transaction. Why? Period-end revaluation of foreign currency balances at the current rate. That produces an unrealised gain or loss.
Should I reconcile in foreign or home currency? Foreign. The home currency figure is a translation that moves with rates and is not meant to match the statement.
Two reports show different figures for the same invoice. Check the rate on each transaction. Manual overrides and automatic rates on different dates produce different home currency amounts.
Do I need multi-currency for occasional foreign invoices? Often not. Recording them in your home currency at the rate received keeps the file simpler, and enabling multi-currency is irreversible.
References
- QuickBooks Online documentation on multi-currency, exchange rates and home currency adjustments
- Xero documentation on multi-currency, foreign currency gains and losses and revaluation
- Accounting standards on foreign currency translation and reporting
⚠️ Revaluation behaviour, rate sources and available settings differ by platform, plan and region, and change with releases. Check current guidance for your own file.
Call or WhatsApp: +91 7448200422 | Email: info@taxkitab.com
We keep multi-currency books for businesses in the United States, the United Kingdom and the UAE, working inside your own software. Get in touch.
