🚨 Foreign currency invoice not showing in the Match tab search?
If you are searching for your foreign currency settlement in Xero's Match tab and the invoice doesn't appear, it's usually caused by one of two things:
1. The "Show GBP items only" checkbox is ticked (or the equivalent for your home currency). Xero hides foreign currency invoices from the Match search by default. Fix: on the Match tab, un-tick "Show GBP items only", then search by the converted home-currency amount shown in the invoice reference (e.g. (converted to GBP 4.88)). The invoice should now appear and you can reconcile it.
2. A three-currency mismatch — if you've already un-ticked "Show GBP items only" and tried every amount and reference combination with nothing showing, the issue is likely that your settlement currency, bank payout currency, and Xero home currency are all different (e.g. MXN settlement, USD bank payout, GBP home). Xero can't surface the invoice in this scenario. See How to reconcile Amazon settlements when the bank payout is in a third currency for the fix.
Reconciling foreign currency settlements in Xero depends on whether you utilise Amazon's Currency Conversion Service (ACCS) or if you receive payouts directly in the foreign currency. This article will guide you through the reconciliation process for both scenarios.
Scenario 1: Using Amazon Currency Conversion Service (ACCS)
If your designated deposit account in Amazon is in your home currency (e.g., GBP) for all funds, including those originating in EUR, USD, or CAD, then Amazon's Currency Conversion Service (ACCS) will automatically convert these payments into your home currency before disbursing them to you.
How Link My Books Helps: When using ACCS, Link My Books helps simplify reconciliation by including the original currency amount and the converted home currency amount directly in the default Xero invoice/journal reference.
Example Reference: (€5.79) LMB-FR-1012345678-1 (converted to GBP 4.88)
This format makes it much easier to identify and match the foreign currency settlement to your home currency bank statement line in Xero.
Steps to Reconcile in Xero (Using ACCS):
Go to the 'Match' tab: In Xero, navigate to your bank reconciliation screen and click the 'Match' tab for the relevant bank account.
Adjust Filters: Un-tick the "Show GBP items only" checkbox. This ensures Xero searches across all currencies for potential matches. This is the most common reason a foreign currency invoice will not appear in the Match search — if you skip this step, the invoice will remain hidden even when it is present in Xero.
Search by Reference: Copy the exact amount you received in your home currency (e.g., GBP) from your bank statement, and paste it into the "Search by name or reference" box.
Initiate Search: Click "Go" or press Enter.
Select & Reconcile: Xero will display the invoices which have that specific figure in their reference. Tick the corresponding invoice/journal entry that matches your bank line, and then click "Reconcile".
Scenario 2: Receiving Payouts in Local Foreign Currency
If you have designated local bank accounts for each different currency that Amazon operates in (e.g., a EUR bank account for Amazon.de settlements, a USD account for Amazon.com), Amazon will pay you directly in those foreign currencies without prior conversion to your home currency (e.g., GBP).
Reconciliation in Xero (Local Foreign Currency): In this scenario, Link My Books will post the settlement to your Xero account in the original foreign currency. You will then reconcile the foreign currency payout in your dedicated foreign currency bank account within Xero, following standard multi-currency reconciliation procedures for that specific currency account.
Scenario 3: Three-currency mismatch (settlement, payout, and home all different)
If your Amazon marketplace settles in one currency (e.g. MXN from Amazon Mexico, CAD from Amazon Canada), Amazon then converts the payout into a different currency before it hits your bank (e.g. USD), and your Xero home currency is a third currency (e.g. GBP), the Match tab will not surface the invoice no matter what amount or filter combination you try.
This is because Xero can only directly match an invoice to a bank statement line when the two share a currency, or when one of them is the home currency. A three-currency setup falls outside of that.
There is a separate article covering the short-term workaround (a clearing account in the payout currency) and the long-term fix (changing Amazon's disbursement bank so payouts land in your home currency):
Troubleshooting: No Matching Settlements Found
If your search in Xero provides no matching settlements, here are a few things to check:
"Show GBP items only" is still ticked: this is by far the most common cause. On Xero's Match tab, make sure the "Show GBP items only" checkbox is un-ticked before you search. If this is left ticked, foreign currency invoices will not appear in the search results even though they exist in Xero.
Searching with the foreign currency amount instead of the converted amount: when using ACCS, the bank deposit is in your home currency (e.g. GBP). You need to search using the converted home-currency amount from the invoice reference (e.g. the value shown in brackets:
(converted to GBP 4.88)), not the original foreign-currency amount.Foreign currency invoice sitting in "Invoices Owed To You" but not appearing in the match search: if you can see the invoice in your foreign-currency invoices list but the Match search is not surfacing it, the filter on the Match tab is almost always the cause. Re-check the "Show GBP items only" checkbox first before investigating further.
Three-currency mismatch: if you have already un-ticked "Show GBP items only" and the invoice still isn't surfacing, check whether your settlement currency, bank payout currency, and home currency are all different (e.g. MXN settlement, USD payout, GBP home). If so, the Match tab will not be able to find the invoice. See How to reconcile Amazon settlements when the bank payout is in a third currency.
Settlements Not Sent: Verify that all relevant settlements have been successfully sent from Link My Books to Xero. Check your Link My Books dashboard for any pending or failed settlements.
Amazon Currency Exchange Rate Updates: Amazon initially provides an estimated exchange rate when a payout is generated. The final, confirmed exchange rate is provided later once the payout has been completed. If you don't find a match immediately, it's possible Link My Books received the estimated figure first. We automatically update the invoice/journal reference in Xero once Amazon provides the confirmed rate. If this is the case, waiting a few days for Amazon to finalise the exchange rate may result in a match appearing.
If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].