Skip to content

Daily ECB midpointFrankfurter / ECBFree to use

CurrencyCentral

SMB FX Playbook

Accounting Integrations for Multi-Currency Books

8 min read · Updated October 2026

An accounting integration for multi-currency books posts each foreign movement in its own currency, with the rate and the home-currency amount your ledger needs. The point is to reconcile the euro account to the euro statement, not to retype a converted total at month end.

QuickBooks Online and Xero can both keep foreign bank accounts and foreign invoices when multi-currency is available on your file. How the bank or payments firm connects is a separate choice: a direct feed, a statement file, or a CSV you map. Treasury basics for multi-currency SMBs is the weekly cash routine this page assumes. CurrencyCentral does not connect ledgers or post exchange differences for you.

Key takeaways

  • Give every currency balance its own account in the books. A single home-currency "FX" balance hides which statement to match.
  • Turn on multi-currency only after you confirm the plan, the currencies, and whether your product treats the switch as permanent.
  • Match the foreign amount first. Post the invoice-date rate and the settlement-date rate so the difference can land in exchange gain or loss.
  • A feed that drops fees or collapses a conversion into one number will put you back on manual fixes.
  • Test one currency for a week before you trust the connection with the rest of the file.

What should the books show before you connect anything?

The books should already know the home currency, the list of foreign currencies you will hold, and which real-world balance each ledger account represents.

Create one bank or payments account per currency balance. A euro wallet and a pound wallet are two accounts even if one login shows both. Name them so the statement and the ledger use the same currency. Put customer deposits you already owe, and tax you collected, where the treasury routine can see they are not free cash.

Invoices and bills should stay in the currency you agreed. The guide to invoicing in the client's currency covers why you might bill that way. The reconciliation guide covers how an open foreign invoice meets the cash later. An integration does not choose the invoice currency for you.

Set a written rate source for month-end revaluation. Many firms use a published reference rate and save the date. The connector does not make that policy. Your accountant should name the source before software starts posting unrealized gains and losses.

How do QuickBooks and Xero handle this differently in practice?

Both products can store a foreign invoice, a foreign bank account, a rate, and an exchange difference when multi-currency is on. The clicks and the plan limits are not the same, and they change. Confirm them in the current help for your country.

In QuickBooks Online, multi-currency is a file-level setting. In many regions Intuit has treated that switch as one you do not turn off later. Read the current QuickBooks help before you enable it. Assign the home currency with care. Add only the currencies you will actually post. A demo currency left on will clutter the list.

In Xero, foreign bank accounts and foreign invoices depend on multi-currency being included in the subscription you have. Plan names change. Check that the currencies you need are available on your plan before you design the file around them. Add the foreign bank account in that currency, not as a home-currency account you edit by hand.

Neither product knows your commercial rate until a transaction, a feed, or a person supplies it. If the feed sends only a home-currency amount, the ledger will look reconciled in home currency and still be wrong in euros. That is the failure this project is meant to stop.

A payroll tool, a card, and a second bank can each feed the same file. Decide which system is allowed to create the bank line, or you will import duplicates.

What connection methods are worth asking for?

Ask the bank or payments firm which of these it can actually do for your entity and your currencies. A marketing line that says "integrates with accounting" is not yet a method.

A direct bank feed pulls statements into QuickBooks or Xero on a schedule. You still review and match. A feed can break, lag, or map a fee to the wrong account. It is still the option that removes the most retyping when it stays healthy.

A statement file is the middle path. You export from the payments account and import into the ledger. CSV is common. Some banks offer a bank-statement file in the OFX format. That file format is not the payments company that uses the same three letters. Open a sample file before you commit. Check that each row has the date, the foreign amount, the currency, a payee or reference, and a fee if one was charged.

A third-party connector sits between the account and the ledger. Use one when neither side offers a native feed you can test. Ask who stores the login, whether a payment can be created from that connection, and how you disconnect a former bookkeeper.

Manual entry remains valid for a handful of transfers a month. It stops being valid when the month-end queue is a pile of PDF statements and guessed rates. If you stay manual, use a single spreadsheet layout: date, currency, foreign amount, rate, home amount, fee, and invoice number. Paste from the statement. Do not recompute the foreign amount from memory.

An API belongs in the conversation when your own system creates invoices or payments and should push them without a person retyping. For many SMBs a feed or a file is enough. Volume, not fashion, decides.

How do you reconcile once the lines arrive?

Reconcile in the currency of the account. The euro statement and the euro ledger account should explain each other. A difference is timing, a fee, or a booking error. Find which one before you force the balance.

Match a customer receipt to the open invoice in that same currency. The invoice carries the rate from the invoice date. The cash carries the rate on the day it cleared, or the rate the feed supplied. The difference is a realized exchange gain or loss. Do not edit the invoice down to the cash amount to make the difference vanish. That edit destroys the sales figure.

Match a supplier payment the same way. The bill stays at the rate you recorded when you approved it. The payment posts at the settlement rate. The gap is the exchange difference, not a change to the expense you originally booked.

Post fees as their own lines, in the currency in which they were charged. A net deposit that hides a fee will understate costs and make next month's comparison useless. If the provider's payout is a batch, open the batch report and post the pieces, or use a rule that splits them the same way every time.

A conversion between two wallets should be two legs. Pounds leave the pound account. Dollars arrive in the dollar account. The rate on that transfer is the rate you accepted. If the feed shows only one side, enter the other side from the confirmation before you close the period.

At month end, revalue open foreign bank balances and open foreign invoices with the rate your policy names. Save the print or the link with the date. Unrealized gains and losses will move if the rate moves next month. That movement is the open position. It is not a bank fee.

The forecast guide's warning still applies after the feed is live. A frozen rate in the cash plan will not match these posted rates. Update the plan from the settlement rates you just recorded.

What should a one-week test include?

Pick one currency that has both a receipt and a bill. Connect only that account. Import or feed five to ten real lines, including one fee and one conversion if you have them.

Check four things. The foreign amount on each line matches the statement. The invoice match happened in that currency. The fee is visible. The home-currency total of the account equals the foreign balance times the rate the file used, with the rate date stored.

Then try a duplicate. Export the same week again and confirm the ledger does not create a second copy. Try a user you have removed and confirm they cannot keep a feed token. Fix the mapping before you add the next currency.

If the provider cannot pass a foreign amount, stop and use a file you control. A pretty feed that drops the currency is slower than a plain CSV that keeps it.

Frequently asked questions

Do I need a direct integration to stop manual reconciliation?

No. A direct feed helps when volume is high and the feed keeps the foreign amount. A consistent CSV can do the same job for a smaller account. The requirement is the foreign amount, the rate, and the fee. The logo on the integration list is optional.

Should I post everything in home currency and keep a side spreadsheet?

That split is how differences get lost. Post the bank account in the currency it holds. Use the side sheet only as a staging file you import from, not as a second set of books.

What if the feed misses a fee or uses a rate I did not agree?

Post the missing fee from the provider's report before you close the month. Replace a wrong rate with the rate on the confirmation, and keep a note of the change. Then tell the provider. A silent plug will repeat next month.

Can I turn multi-currency off if the file gets messy?

Do not assume you can. Some products treat the setting as permanent once you have foreign transactions. Confirm the current help article, and test in a copy or a trial file if one is available, before you enable it on the live books.

Who should own the mapping rules?

The bookkeeper can maintain the feed. The accountant should approve the exchange-gain account, the revaluation rate, and the fee account. The owner should still recognize the foreign balances in the weekly treasury snapshot.

Does CurrencyCentral sync QuickBooks or Xero?

No. CurrencyCentral does not connect to accounting files, import statements, or calculate your exchange gain or loss.

Where to read next

Use treasury basics for multi-currency SMBs to decide which balances deserve an account and who reviews them each week. Use fixing multi-currency invoice reconciliation when the open invoices and the cash still disagree after the feed is in. CurrencyCentral does not close the books.

Paying many overseas contractors from one file is covered in Batch Payments: Paying Multiple Overseas Contractors Fast.

How an open foreign invoice becomes an unrealized gain, then a realized one when cash moves, is covered in FX Gains and Losses: Realized vs Unrealized for SMBs.