How to reconcile multi-currency transactions in Xero
Businesses that pay suppliers, employees, and contractors in different currencies need more than a simple balance check. Exchange rates change between the transaction date, settlement date, and reporting date, creating differences that must be recorded correctly in Xero.
A reliable reconciliation process connects each foreign-currency payment to the right invoice, bill, card transaction, or bank-feed entry. It also separates genuine errors from legitimate foreign exchange movements so that financial reports remain accurate.
Xero’s multicurrency tools can handle much of this work, but the quality of the result depends on consistent account setup, complete transaction data, and a disciplined review process. The following workflow helps finance teams reconcile international spending with fewer adjustments.
Enable multicurrency and establish a clear structure
Start by confirming that multicurrency is enabled in the Xero organization. Add the currencies used by the business and review the base currency selected for financial reporting. The base currency cannot be changed casually, so it should reflect the company’s primary accounting jurisdiction.
Create or review bank, credit card, payment processor, and clearing accounts in their relevant currencies. A separate account for each foreign-currency wallet or card program makes it easier to match Xero entries with actual statements. Avoid combining transactions from several currencies in one manual account unless the provider reports them that way.
Set default tax rates, expense categories, contacts, and tracking options before processing a large batch. Consistent coding reduces the number of transactions that require correction during month-end close.
Capture the correct exchange rate
Xero generally uses its stored exchange rate when a foreign-currency transaction is entered. The accounting value in the organization’s base currency can therefore differ from the amount shown on the original bank or card statement.
For invoices and bills, record the currency and foreign amount as issued. When payment occurs later, Xero can recognize the difference between the original accounting value and the settlement value as a realized currency gain or loss. Do not overwrite this difference simply to force the two base-currency amounts to match.
For card purchases, retain the original receipt, transaction currency, settlement currency, and any conversion fee. A provider may convert a purchase days after the authorization date, while Xero records the expense when the transaction is imported. Supporting documentation helps explain the resulting variance.
Match feeds, bills, and card activity
Import bank and card feeds as close to the transaction date as possible. Match each line to an existing bill, invoice, spend-money transaction, or transfer instead of creating duplicate entries. When a payment has several components, split it into the expense, tax, and foreign exchange fee rather than posting the entire amount to one category.
Prepaid cards can add another layer because funds may be loaded before employees spend them. Record the load as a transfer or balance movement, then code individual purchases when they appear. A documented employee expense process can help finance teams collect receipts and assign costs to the correct person, project, or department.
When a feed does not connect directly to Xero, use a temporary clearing account. Post the provider’s settlement or funding entry to the clearing account, match the related transactions, and investigate any remaining balance before closing the period.
| Transaction type | Xero treatment | Reconciliation focus |
|---|---|---|
| Foreign-currency invoice | Enter in the invoice currency | Match the later payment and review realized gain or loss |
| Card purchase | Record the expense and applicable tax | Compare receipt currency with statement settlement |
| Currency conversion fee | Code separately as a bank or finance charge | Confirm it was not included in the expense twice |
| Transfer between currency accounts | Use a transfer between matching accounts | Check both sides and the conversion rate |
| Prepaid card load | Record as a transfer or funding movement | Ensure the load is not treated as an expense |
| Month-end balance | Revalue where required | Review unrealized exchange gains or losses |
Reconcile by currency and account
Open each foreign-currency account in Xero and compare its balance with the provider statement in that same currency. Reconcile the foreign amount first, then review the base-currency equivalent. This approach prevents an exchange-rate movement from being mistaken for a missing transaction.
Work through the period chronologically. Match opening balance, deposits, loads, purchases, refunds, fees, transfers, and closing balance. A small unexplained difference can indicate a duplicated feed line, a missing conversion fee, an incorrect transaction date, or a payment posted to the wrong currency account.
For accounts with high transaction volume, reconcile weekly rather than waiting for month-end. Frequent checks make it easier to retrieve receipts, identify unauthorized activity, and correct mapping rules while the source data is still available.
Handle gains, losses, and revaluation
Realized foreign exchange gains and losses arise when a transaction is settled at a different rate from the rate used when it was originally recorded. Xero may calculate this adjustment when matching the payment to an invoice or bill. Review the account used for the adjustment so it aligns with the organization’s chart of accounts and reporting policy.
Unrealized movements relate to balances that remain open at the reporting date, such as unpaid foreign-currency invoices or cash held in a foreign account. Depending on the company’s accounting requirements, these balances may need revaluation at period-end. The adjustment should be documented and reversed or updated in the next reporting period according to the chosen process.
Separate conversion spreads and service fees from exchange gains or losses. A provider’s fee is a real expense, while a rate movement reflects the changing value of the currency. Treating both as one amount can distort operating costs and financial analysis.
Use controls for international payments
Assign ownership for each stage of the workflow. The person approving an international payment should not be the only person checking the bank feed and closing the reconciliation. Approval limits, receipt requirements, and payment references create an audit trail for both internal and external review.
For accounts payable and receivable, use consistent payment references so Xero can identify the related invoice quickly. For employee spending, require a receipt, business purpose, currency, and cost center. Automated card controls, spending limits, and real-time transaction visibility can reduce the volume of manual follow-up.
Review connected apps and accounting integrations regularly. QuickBooks or Xero synchronization can streamline transaction imports, but incorrect account mappings or duplicated connections may create repeated entries. Test changes with a small batch before applying them across the organization.
Build a repeatable close checklist
A documented checklist makes foreign-currency reconciliation easier to delegate and audit. Keep exchange-rate sources, statement dates, adjustment entries, and unresolved items together with the period’s supporting records.
Use these controls during each reconciliation cycle:
- Confirm the opening and closing balance for every currency account.
- Match invoices, bills, card purchases, refunds, transfers, and fees.
- Review realized and unrealized exchange gains or losses.
- Investigate duplicate, missing, or manually edited feed transactions.
- Lock the period after approval and retain supporting statements.
After reconciliation, compare foreign-currency expenses with budgets and prior periods. Unexpected changes may reveal a pricing difference, supplier issue, unauthorized card use, or a recurring conversion fee that deserves attention.
A consistent Xero workflow turns international bookkeeping into a controlled monthly process. Set up currency accounts carefully, preserve the original transaction details, reconcile each account in its native currency, and document every adjustment. Businesses using YourRewardCard for card spending, payments, or employee expenses can apply the same controls across prepaid balances and international transactions, keeping financial data ready for reporting and decision-making.