How to Reconcile Foreign-Currency Bills in Xero

To reconcile foreign currency bills in Xero, keep each supplier bill in the currency and amount shown on the document, then match it to the payment that actually left the bank or card account. If the bill is missing from Find & Match, first expose items in other currencies. If the sterling amount differs, identify whether the difference comes from exchange-rate movement, a separate fee or a partial payment before you reconcile it.

Do not start by editing the bill to equal the GBP bank debit. The bill, the payment and the outstanding balance record different facts:

• The bill records what the supplier charged, in the supplier document's currency.
• The bank line records what left the account, in that account's currency. For a Xero bill paid from a GBP account, this is the sterling amount on the statement.
• The bill balance in Xero shows how much of the supplier liability has been settled and how much, if any, remains payable.

Before changing anything, check the source bill's currency and total, the payment date, the statement amount and currency, whether the bank or payment provider charged a separate fee, and whether the supplier received the full bill amount. Keep the bank statement and any remittance or provider confirmation beside the supplier bill. Those records usually reveal which problem you have.

What you can see	Most likely issue	What to check next
The bill is absent from Find & Match	A currency filter is hiding it	Show items in other currencies, then verify the supplier and bill reference
The bill appears, but the GBP figures differ	Exchange-rate movement or a separate fee	Compare the bill date, payment date, bank debit and fee evidence
The bill still has an amount due	The supplier received only part of the bill, or the wrong payment was matched	Confirm the amount actually sent and the intended remaining balance
The currency or supplier amount in Xero differs from the document	The bill was entered incorrectly	Correct the source-data error, not the payment evidence
The bill and payment use two different currencies, neither of them GBP	This is a cross-currency exception	Use an established clearing route or obtain accounting advice

A completed reconciliation should preserve the supplier document, clear the correct bank line and leave the bill showing the intended status. A balancing adjustment with no supporting event does not prove that any of those things happened.

If the bill is missing from Find & Match

A correctly entered foreign-currency bill can exist in Xero without appearing in the initial list of transactions available to match. In the reconciliation view, the Show [currency] items only selection restricts the list to the bank account's currency. For a GBP account, clear Show GBP items only to expose bills and other items in different currencies, then use Find & Match to search for the supplier bill.

Treat the filter as a visibility control, not a correction. Do not change the bill's currency or create another expense merely because the original bill was hidden. Once it appears, compare the supplier, bill reference, original-currency total and relevant payment date with the source records before selecting it.

Visibility is not the same as reconciliation. Once you have selected the bill in Find & Match, review the payment details against the statement before choosing Reconcile. A bill that appears may still represent a partial payment, include a separate charge in the bank debit or settle at a different sterling value because the exchange rate moved.

Separate exchange-rate movement from payment fees

A foreign-currency bill has a value in its transaction currency and an equivalent value in the organisation's base currency. If the exchange rate changes between the bill date and the payment date, the sterling amount needed to settle the same supplier liability changes. That is why a correct EUR or USD bill can appear beside a different GBP bank amount.

Suppose a EUR 1,000 bill was worth £860 on its bill date and the bank later paid £875 to settle the same EUR 1,000 liability. The supplier amount has not changed. The £15 movement belongs to the difference between the bill-date and settlement-date sterling values, so rewriting the bill as £875 would replace the original transaction with the later payment fact.

This treatment follows the underlying accounting distinction. HMRC's guidance on foreign-currency monetary liabilities describes foreign-currency trade debts as monetary items and recognises that exchange gains or losses arise when those items are settled. For a full payment already present in the GBP bank feed, open Find & Match from that statement line, expose the foreign-currency items, select the bill and reconcile it. Xero's foreign-currency reconciliation guidance covers this native route; settling the bill records the realised exchange gain or loss.

A bank or payment-provider fee is not exchange-rate movement. If the provider settled the EUR 1,000 bill for £875 and charged a separate £10 fee, the records need to preserve both events: £875 of supplier settlement and £10 of fees. Use the bank statement together with the provider's payment or fee confirmation to determine whether the debit contains both amounts or whether the fee appears as its own bank line.

When the provider combines the fee with the supplier payment in one bank statement line, use Xero's bank-statement adjustment route to add an identifiable bank-fee adjustment and code it to the appropriate fee expense account before reconciling. If the fee appears as a separate statement line, reconcile that line separately to the fee account. In either case, the full EUR 1,000 supplier liability is settled and the £10 charge remains visible rather than being folded into the exchange result.

Tell a partial payment from a wrongly entered bill

A remaining balance after reconciliation is correct when the supplier received only part of the amount due. In the Purchases menu, select Bills, open the bill, enter the actual payment date, account and amount under Payments, then record the payment. Xero's instructions for recording a bill payment cover full and partial payments. Match the recorded payment to the GBP statement line when it arrives in the bank feed. The bank line should show as reconciled, while the bill remains partly paid with the unpaid amount still payable in the bill currency.

That is not the same as an entry error. Compare the Xero bill with the supplier document when the currency, total, supplier, date or reference looks wrong. Correct a demonstrable mistake in the source entry, and check for a duplicate if two bills appear to represent the same document. Do not change a correct bill merely because its base-currency value differs from the later bank debit.

If the supplier was paid in full but the bill still shows an unexplained balance, recheck the matched payment, fee evidence and bill entry. Correct a source-data error only when the supplier document supports the change. A difference with no identified cause is not a basis for an adjustment.

Entering many purchase bills is a separate workflow. If the underlying issue is how the documents reached Xero rather than how this payment settles them, use the guide to bulk import bills and invoices into Xero instead of turning the reconciliation into an import repair.

Two non-base currencies need a separate route

The normal UK case has one foreign-currency bill and one GBP payment. Xero can use the organisation's base currency to account for the difference between the bill-date and settlement-date values.

A different problem arises when the bill is in one foreign currency and the payment account or transaction is in another, while GBP remains the organisation's base currency. A USD bill paid from a EUR account is not a direct same-currency match, and it should not be treated as though either side were a GBP bank payment.

This arrangement may need a clearing account or another documented route already established in the organisation's chart of accounts. The purpose is to preserve both original currency records while linking the economic settlement through traceable entries. It is not permission to post an unexplained difference between them.

Keep the supplier bill, the USD and EUR amounts, the dates and rates used, the payment evidence and any separate charges. If the clearing treatment is not already defined, obtain help from a Xero adviser or accountant rather than improvising journal lines. The branch is complete only when both sides of the clearing route resolve, the supplier bill shows the intended paid or remaining balance, and the audit trail explains every amount.

Confirm the bill is reconciled, not merely matched

Use the records, not a zero-looking difference, as the completion test:

• The correct bank or card line shows as reconciled.
• The intended supplier bill shows as paid, or it retains the genuine unpaid balance after a partial payment.
• The bill currency and amount still agree with the supplier document.
• Any separately charged bank or provider fee remains visible as its own expense.
• The difference between bill-date and payment-date base-currency values is recorded as currency movement, not buried in an unsupported adjustment.

This test closes one bill against one payment. If that bill is correct but the supplier's account still differs across several bills, credit notes or payments, the next job is to reconcile supplier statements in Xero. Do not reopen a correctly settled bill to compensate for an account-level discrepancy elsewhere.

Retain the supplier bill, bank or card statement and payment or remittance confirmation together. Where a separate charge applies, keep the provider's fee evidence as well. Those records support the bill amount, the cash movement and the treatment of every difference between them.