Skip to the guide
IQ Booksby ReconcileIQ

Setup & configuration · Guide 04 of 53

Working in multiple currencies

IQ Books has one base currency per organisation but can record invoices, bills and bank accounts in any currency. Exchange rates capture the conversion at posting time; settlement and period-end revaluation handle FX differences.

Even single-country businesses end up with foreign-currency moments: a USD subscription, a EUR supplier, a customer paying from overseas. IQ Books treats currency as a first-class field on transactions while keeping the base ledger intact in your reporting currency.

Base currency vs. transaction currency

Your organisation has exactly one base currency, set during the setup wizard and surfaced as “Reporting currency” on every report. All journal entries are stored in minor units of the base currency — that is what your trial balance, P&L and balance sheet are denominated in.

A transaction (invoice, bill, bank movement) carries its own transaction currency plus the FX rate used to convert it. If your base is GBP and you raise an invoice in USD at 1.27, IQ Books stores both: USD 1,270 for the customer-facing document, GBP 1,000 for the journal.

The exchange rates table

Settings → Currencies houses the rates IQ Books will use when no explicit rate is supplied. Each row is a (base currency, foreign currency, effective date, rate) tuple. The most recent rate on or before the transaction date wins.

You can:

  • Add a rate manually (for example, if GBP is your base and EUR 1 equals GBP 0.8425, enter 0.8425 for EUR → GBP on that date).
  • Fetch the latest reference rates from Frankfurter’s free feed for the current 165-code currency set.
  • Override a rate at posting time for a specific transaction (the per-document override doesn’t change the table; it only affects that journal).
  • Archive a rate row that turned out to be wrong; archival hides it from future lookups but doesn’t alter posted journals.

FX-tagged invoices and bills

When you create a sales invoice or a purchase bill, the currency dropdown defaults to your base currency. Pick a different currency and the document gains an FX rate field. Either:

  • Leave it blank: IQ Books fills the field with the most-recent rate from your rates table on the issue date.
  • Type a rate: IQ Books uses that rate for the journal posted on issue.

The customer or supplier sees an invoice in their currency; your ledger sees the journal in your base currency.

Foreign-currency bank accounts

You can create a bank account in any currency from Banking → Bank accounts. The account’s ledger balance in IQ Books is held in that currency — meaning a USD bank account’s journal lines are denominated in USD, and the GBP equivalent is computed when the account’s balance hits a report.

This avoids the headache of revaluing every bank transaction at posting time. The conversion happens at report time using the latest applicable rate.

Transfers between foreign-currency bank accounts

A transfer between two of your own foreign-currency accounts is not income, not an expense and not a VAT event. Treat it as one movement with two bank legs: money out of the source account and money into the destination account.

  1. Import or enter both bank movements: for example, EUR 1,000 out of the EUR account and USD 1,085 into the USD account.
  2. Use one base-currency valuation for the transfer. Usually that comes from the source bank leg or the bank’s execution statement; the destination leg then carries the implied rate from the actual USD received.
  3. On either draft row, choose the transfer action and pick the matching draft from the other bank account. If CodeIQ has already detected the pair, use the one-click transfer confirmation instead.
  4. IQ Books keeps each bank leg in its own currency while using that single base value for the double-entry journal.
  5. If the bank shows an explicit fee, record that fee as a separate bank charge line. If the cost is hidden in the spread between EUR and USD, do not invent a fee; use the actual amounts received and paid.

If the amounts are in different currencies, they will not numerically match. That is expected. The transfer match is based on the two owned bank accounts, the dates, the descriptions and the shared base value, not on EUR and USD being the same number. Do not apply two unrelated reference rates to the two sides if that would create an artificial gain or loss.

FX gain and loss on settlement

When a foreign-currency invoice gets paid, the rate at the date of payment will almost certainly differ from the rate at the date of issue. The difference is recognised in your P&L as an FX gain or loss.

IQ Books posts this automatically: on settlement, the journal includes a line to the configured FX gain/loss account for the rate difference between issue and payment. This is true for both customer receipts (sales side) and supplier payments (purchase side).

If you don’t see an FX gain/loss account in your COA, the system will create one with the relevant role on first use. You can rename it via Accounting → Categories.

Period-end revaluation

Outstanding foreign-currency invoices, payables and bank balances need restating to the closing rate at month-end, quarter-end or year-end. IQ Books has a guided revaluation flow in Settings → Currencies: pick the as-at date, preview the balances, check the closing-rate value and post only when the result looks right.

The preview shows each foreign-currency balance, the current base value, the closing-rate base value and the unrealised gain or loss. If a rate is missing for the selected date, IQ Books tells you to add or fetch it before posting.

When you post, IQ Books writes the unrealised gain or loss to the configured FX gain/loss account and adjusts the relevant balance-sheet carrying value. The revaluation is carried forward: next month measures from it, posting the same date again finds nothing to do, and nothing reverses on the 1st (the result is the same as reversing and revaluing again). Revaluations go in date order.

The closing rate is the rate for that day. A rate more than five days older than the as-at date is not used, even one you typed in: the market rate for the day is used instead, and with neither, that balance is listed as having no rate and left out. Add the rate for the day under Settings → Currencies if you need to.

From the 2nd of each month, once that month end’s rates are in, What RiQ found proposes that month end’s revaluation with the balances it would restate and the gain or loss, and accepting posts exactly what this screen would. It asks first; under Settings → Automation you can let it post by itself, or set the smallest movement worth proposing. Skipping a month is harmless: the next revaluation catches up. To undo one, reverse its journal from View transactions (the latest first).

Reports across currencies

  • Trial balance, P&L, balance sheet: denominated in base currency. Foreign-currency activity is converted using the rate that applied at the time of posting.
  • Aged debtors / aged creditors: show outstanding amounts in both the document currency and the GBP equivalent at the most recent rate — you see the customer’s bill in their terms and your exposure in yours.
  • Statements emailed to customers: rendered in the customer’s currency.

Related guides

Settling A Foreign-Currency Bill Step By Step

When you enter a bill in a foreign currency, IQ Books records its sterling value at that day’s rate. By the time you pay it the rate has usually moved, so the pounds that actually leave your account rarely match the pounds the bill was booked at. That gap is a realised foreign-exchange gain or loss, and IQ Books captures it as you settle.

  1. Open the bill and choose Record payment. Start from the bill itself, the supplier record, or Purchases → Payments — all three reach the same screen.
  2. Pick the bank account the money left from. Usually your foreign-currency account for the same currency as the bill.
  3. Set the payment currency and enter the cash amount. For a €1,200 bill you would choose euros and enter 1,200 — the amount that genuinely left the account.
  4. Allocate it to the outstanding bill. Tie the cash to the specific bill (or split it across several); anything you don’t allocate simply sits on account as a prepayment.
  5. Confirm the exchange difference. IQ Books works this out from the rate movement between the bill date and the payment date. Check it, and adjust it if your bank actually gave you a different rate.
  6. Save. The bill moves to part-paid or paid automatically, and the exchange difference lands on your profit and loss.

Worked example: a €1,200 bill was booked at £1,000 when you received it. On payment day that €1,200 costs you £1,050. IQ Books clears the £1,000 sitting in payables, records the £1,050 that left your euro account, and posts the £50 shortfall as a realised loss. Had the euro weakened instead so the €1,200 cost only £970, the £30 difference would be a realised gain.

If you later change the amount or date of a foreign-currency payment, IQ Books asks you to confirm the exchange difference again — moving the date moves the rate, so the gain or loss has to be reworked.

Cross-Currency Settlement: Paying In A Different Currency From The Invoice

Sometimes the money and the document aren’t in the same currency: you settle a euro bill out of your sterling account, or a customer pays a dollar invoice straight into your pounds account. IQ Books copes with this. It translates both sides to your base currency and books the difference as a realised gain or loss, just as it would for a same-currency foreign settlement.

There is one limit worth knowing. When you match a bank payment to an invoice or bill across currencies, IQ Books treats it as a full settlement of that document — the match closes it. So:

  • You can part-pay a foreign invoice in its own currency as many times as you like.
  • You cannot part-settle it from a different currency; a cross-currency match settles the whole thing.

If you need to pay a foreign bill in instalments, settle it in the bill’s own currency — typically from a matching foreign-currency bank account — and leave cross-currency matching for one-off, pay-it-in-full settlements.

Moving Money Between Accounts In Different Currencies

Transferring your own money between two accounts — say from a sterling account into a euro account — is not a sale or a purchase, so treat it as a transfer rather than categorising each line. Enter both sides (one line on each account) and confirm them as a transfer. IQ Books then posts a single linked entry: money out of the sending account, money into the receiving account, with nothing hitting income or expenses.

For a cross-currency transfer, both legs are recorded at the base-currency value of the leg you confirm from, so the transfer itself never invents an artificial gain or loss — the two sides always agree in pounds. To confirm a pair this way, IQ Books first needs to have matched the two lines as a transfer pair (its automatic coding does this when it spots an equal-and-opposite movement across two accounts). If the pair hasn’t been matched, confirm each side normally by choosing a category instead.

VAT On Overseas Purchases: Reverse Charge And Import VAT

When you buy from abroad, the VAT treatment often matters more than the currency. IQ Books ships with the reverse-charge codes you need for cross-border purchases:

  • Services bought from an overseas supplier — use the reverse-charge code so you account for the VAT here rather than the supplier charging it.
  • Goods imported into the UK — use the postponed import VAT code, which lets you account for import VAT on the return instead of paying it up front at the border.

With these codes the bill carries the net amount only — there is no VAT sitting on the supplier’s bill for you to pay them. Instead IQ Books accounts for the VAT on both sides of your return at once: it adds the same figure to the VAT you owe and to the VAT you reclaim, so for a fully-reclaimable business it nets to no cash while still recording the net cost against the correct boxes. Tag the line with the right code as you enter the bill; the amount stays in whatever currency you bought in and is translated to pounds like any other foreign line.

Multi-Currency: Common Questions

Can I change my base currency later? No. Once you have posted a single transaction, the base currency is locked, so choose it deliberately in the setup wizard. If you genuinely need a different base currency, that means starting a fresh organisation.

What currency is my VAT return in? Always your base currency — pounds for a UK organisation. Foreign invoices and bills are already converted to pounds when they post, and the nine boxes are recomputed from those pound figures every time, so you never enter VAT in a foreign currency.

IQ Books won’t let me enter an exchange difference on this receipt — why? Because both the invoice and the money received are already in your base currency. There is no currency movement to record, so no gain or loss can arise; the exchange-difference field only appears when a foreign currency is actually involved.

Where does a foreign-exchange gain or loss show up? In the foreign-exchange gains and losses account on your profit and loss. Gains lift your profit for the period; losses reduce it.

What rate should I use if I don’t know the exact one? Record the rate you actually got from your bank or payment provider wherever you can; otherwise the day’s published rate is fine. Any small difference is squared up as a realised gain or loss when the invoice or bill is finally settled, so you are never locked out of a sensible starting figure.

IQ Books by ReconcileIQ

Your books, kept by themselves.

IQ Books is the AI-native UK ledger that does the bookkeeping for you. Bank transactions arrive coded, receipts and bills file themselves from a photo or an email, and the books are reconciled to the statement. RiQ does it, you sign it off. The ledger is free.