UK
About Nationwide statements
Nationwide is the UK's biggest building society, owned by its members rather than shareholders. The statement to convert is the full PDF from the Internet Bank or the Banking app, under Statements, rather than an on-screen balance summary.
Nationwide's transaction details often wrap onto a second line, laid out across its own money-out, money-in and balance columns. That's exactly the detail that gets scrambled when you paste a PDF into a spreadsheet, and exactly what the converter preserves, column by column.
Dates come through as DD/MM/YYYY and the figures stay in GBP (pounds), so the converted file matches what you'd expect locally. A scanned statement is no problem; it's read with OCR into the same layout, with the balance checked either way.
You end up with a file Xero accepts on the first try, with the PDF-wrangling taken care of before it gets there.
Why people convert Nationwide to Xero
Sometimes it's simplest to skip the Nationwide feed altogether — a one-off account, a client who won't share logins, a period the feed never covered. The converted file drops straight into Xero's Import a Statement screen and reconciles like any other month.
It's handy mid-year too, not just at catch-up. A one-off Nationwide account, a statement the feed skipped, or a closed account you still need on file — convert the PDF and it goes into Xero like any other import.
Import a Nationwide statement into Xero
Xero takes the CSV through its own Import a Statement screen.
- Convert the PDF above and download the Xero CSV.
- In Xero: Accounting → Bank accounts.
- Open the account, then Manage account → Import a statement.
- Upload the CSV — the date, description and amount columns line up.
- Reconcile the imported lines as usual.
The totals are checked first
Before the Xero-ready CSV downloads, the running balance is checked end to end. A missing or doubled line is caught at this step, not after it's already in Xero.
Frequently asked questions
Will it import into Xero?expand_more
Yes — the CSV goes in through Xero's Import a Statement screen and the date, description and amount columns line up, so you go straight to reconciling. If Xero asks you to confirm the column mapping the first time, save it and later imports remember the layout.
How is a Nationwide statement laid out?expand_more
Nationwide's transaction details often wrap onto a second line, laid out across its own money-out, money-in and balance columns. The converter reads each of those into its own column, so the Xero-ready CSV imports into Xero cleanly.
Where do I download the Nationwide statement?expand_more
From the Internet Bank or the Banking app, under Statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
Does it work on a scanned Nationwide statement?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
Is it free?expand_more
Converting is free to start. Excel, CSV and JSON download with no login; the Xero file needs a free sign-in.