Convert Macquarie Bank Statement to Xero

Accurate Xero conversion from Macquarie statements depends on understanding their specific layout. BPAY payments are identified with the prefix "BPAY" followed by biller code and customer reference number — biller codes should map to vendor/payee fields in accounting imports. Our converter handles these Macquarie-specific details systematically, ensuring transaction dates, descriptions, amounts, and account information translate cleanly into Xero format. This attention to bank-specific formatting nuances prevents data loss and maintains statement accuracy throughout the Xero export process.

For Macquarie customers with multi-currency accounts, Xero exports preserve currency information alongside transaction amounts. Xero's multi-currency features can then correctly calculate exchange rate gains and losses when reconciling Macquarie foreign currency transactions. This capability is essential for Macquarie business customers with international operations or supplier payments.

Another consideration for Macquarie statements: statements from macquarie's investment and wealth platform include "platform reference" numbers linking transactions to managed fund activity — these are reference data and should not be treated as payee names. The Xero conversion process handles this automatically, applying bank-specific parsing rules that ensure accurate extraction even from complex multi-page statements with hundreds of transactions. This specialized approach delivers consistently clean output regardless of statement length or complexity.