How to import a PDF bank statement into Xero in the UK.

No. Xero’s Import a statement option takes structured files such as CSV, OFX, QFX and QBO, not PDFs. Xero’s own PDF statement conversion through Hubdoc has so far only launched in the US and Canada, which is why UK users keep asking for it on Xero’s product ideas forum.

Ask for a CSV or OFX export from online banking if the period is still downloadable, because that imports directly. If all you have is the PDF, convert it to a CSV first, check the converted rows add up to the statement’s balances, then import the CSV.

PDF statements downloaded from online banking for Barclays, Chase, Lloyds, Mettle, Monzo and Revolut. Scans and photos are refused rather than guessed at. CSV and Excel exports from any UK bank work too. It can output a file laid out for Xero’s bank statement import, and nothing you upload is stored.

Check it against the statement’s own numbers before importing. The converter does this for you: running balances, the closing balance and the statement totals all have to agree to the penny, or it tells you the statement doesn’t add up instead of producing a file.

It can if the dates overlap. If the account already has a bank feed, check which period the feed has brought in and only import the dates it doesn’t cover. Removing duplicates after the fact is slower than checking first.

Converting statement by statement works for one or two. For a year of statements across several accounts, Entrio imports them all at once, files each row on your firm’s rules, reconciles to the bank and produces a trial balance before anything goes near your accounting software.