Airwallex and Xero reconciliation

Use this skill to produce a traceable ledger and reconciled balances when Airwallex holds several currencies and Xero may support only its base currency. First identify the Xero organisation, base currency, subscription capabilities, Airwallex legal entity, wallet currencies, and the exact period. Do not assume that a card's billing currency identifies the wallet that funded it.

Decide how each wallet is represented

• An Airwallex wallet currency maps to a separate Xero bank account when Xero supports that currency. A base-currency-only Xero organisation cannot hold a true foreign-currency bank account. Keep the supported base-currency feed connected and use a clearly named base-currency tracking account for an unsynced foreign wallet when needed.
• A foreign-priced card payment funded by automatic conversion from the base-currency wallet belongs to the base-currency feed at its actual deducted amount. A payment funded from the foreign-currency wallet belongs to that wallet's tracking account. Check wallet balance activity before posting either case.
• Treat the Airwallex connection, Xero bank feed, and Expenses/Bills sync as distinct integrations. A failed expense sync does not prove that the related wallet movement is absent from Xero.
• If a feed is faulty, prefer Airwallex Reconnect over Disconnect; disconnecting can lose history and currency mappings. Do not enable an unsupported foreign-currency feed or retry manually booked expenses without a duplicate check.

Build the source-to-ledger mapping

Read references/reconciliation-playbook.md when preparing or posting entries. It covers settled-item selection, FX, deposits, fees, conversions, refunds, and the reconciliation checks.

For every source movement, preserve the Airwallex transaction or balance-history ID, wallet currency, signed wallet amount, posting date, counterpart, and evidence. Map it to one Xero entry or explain an exclusion. Check the same period and legal entity on both sides. Use source IDs and Xero references for idempotency; also inspect existing Xero transactions by date, amount, merchant, and wallet, since older entries may lack the source ID.

For a base-currency-only Xero organisation, value foreign-wallet movements in base currency using the actual Airwallex conversion when there was one. Otherwise apply a consistent, documented historical-rate policy. Never substitute today's rate for a past movement or invent a rate for a missing date. Revalue material foreign-currency monetary balances at the reporting date under the accounting standard applicable to the organisation.