Zoho Books Multi-Currency: Setup, Exchange Rates and FX Gains

How does multi-currency work in Zoho Books?

Every Zoho Books organization has one base currency, set by the business location you choose at signup. A US organization gets USD, a UAE organization gets AED and an Indian organization gets INR. All reports, including the balance sheet and profit and loss, are stated in the base currency.

You then add other currencies and assign one to each customer or vendor. Their invoices, bills, credit notes and payments are recorded in that currency and converted at the exchange rate on the transaction date. A currency can only be deleted if it is not the base currency and has no transactions.

Invoicing in multiple currencies is only available on certain Zoho Books plans. Advanced Multi-Currency Handling, which lets one contact transact in several currencies without duplicate contacts, is available on the Elite and Ultimate plans according to Zoho. Check the official Zoho pricing page for your region.

How do you set up currencies and exchange rates?

Set this up before you import open invoices or opening balances, because those records need the right currency from day one.

1. 1Go to Settings, Currencies, and confirm the currency tagged Base Currency.
2. 2Click to add a new currency, choose the currency code, and check the symbol, decimal places and format.
3. 3Leave exchange rate feeds on if you want rates updated automatically from Open Exchange Rates.
4. 4If your policy uses a bank or central bank rate, turn feeds off and enter manual rates with a start date.
5. 5Assign the currency to each foreign customer and vendor in their contact record.
6. 6Add bank accounts in each currency you actually hold.

A manual rate applies from its start date until you add a newer one. Deleting a manual rate does not change past transactions, which keep the rate used when they were created.

How do foreign currency invoices, bills and payments work?

When you create an invoice for a customer billed in euros, Zoho Books shows the amount in euros and stores the base currency value at that day's rate. Bills from foreign vendors work the same way. You can change the rate on an individual transaction if your finance team uses an agreed rate.

When payment arrives, it is recorded at the rate on the payment date. Any difference between the invoice value and the payment value in base currency is a realized gain or loss, shown in the Realized Gain or Loss report under Reports, Currency.

Test how payments map to bank accounts in your own organization before go-live. A request on Zoho's community forum reports that a payment against a USD invoice can only be recorded into a USD bank account, so businesses that receive foreign payments into a base currency account often need a clearing process agreed with their accountant.

How are unrealized gains and Base Currency Adjustments handled?

Open foreign balances change value in your base currency as rates move, even before payment. The Unrealized Gain or Loss report shows this potential gain or loss as of a date you choose, using rates you enter. It covers open transactions and can include bank accounts with matched statement transactions.

To book the revaluation, use Accountant, Currency Adjustments, then Make an Adjustment. Choose the currency, set the date, enter the new rate and a mandatory note, review each account's revalued balance and gain or loss, then confirm. The entry appears in account transactions and the journal report as a Base Currency Adjustment. Zoho recommends that your accountant confirms adjustment dates, and month-end is the usual point.

What do multi-currency examples look like in the Gulf, UK and USA?

The setup is the same everywhere, but the exposure differs by market.

For example, a UK agency invoices an EU client in EUR. The invoice is stored in GBP at that day's rate. If sterling strengthens before payment, the GBP value received is lower, and Zoho Books posts a realized loss when payment is recorded.

In Dubai, a trading company with an AED base currency buys from a European supplier in EUR. The bill sits in AED at the bill date rate. At month-end, a Base Currency Adjustment revalues the open EUR balance. When the bill is paid, the Realized Gain or Loss report shows the difference between the bill value and the payment value.

What mistakes should you avoid with multi-currency in Zoho Books?

Currency errors are hard to unwind once months of transactions exist.

• Choosing the wrong business location at signup, which sets the wrong base currency
• Creating duplicate contacts per currency when Advanced Multi-Currency on a higher plan would handle it
• Importing open foreign invoices at today's rate instead of the original transaction rate
• Mixing automatic feeds and manual rates without a written policy
• Skipping month-end revaluation, so the balance sheet overstates or understates receivables
• Recording foreign receipts into the wrong bank account and fixing them with journals

Flowpeak configures multi-currency Zoho Books organizations remotely for clients in the Gulf, UK, USA, Canada and India, including opening balance migration in foreign currencies. A free scoping call is a good place to check your current setup.

Frequently asked questions