Barclays statements follow the UK two-column convention with long wrapped references on business accounts. Convert once, and Xero takes the result through its statement import without a mapping screen.
Convert the statement first
- Upload the Barclays PDF to the converter — personal, Premier or business.
- Signs are inferred from the money-out/money-in columns and verified against the running balance; wrapped references are stitched into single rows so invoice matching still works.
- Download the OFX export.
Import into Xero
- Open the matching bank account in Xero: Manage account → Import a statement.
- Select the OFX file and import — dates, descriptions and signed amounts arrive ready to reconcile.
Barclays-specific notes
- Catch-up years: Barclays statements batch-convert cleanly — drop twelve months at once, each independently balance-checked, then import them oldest-first into Xero.
- References intact: Faster Payments and standing order references survive conversion in full, which is what Xero's bank rules match against.
Reconciling
Xero's statement balance after import equals the statement's printed closing balance — verified before export. Reconcile normally from there.