UK
Upload a Nationwide statement PDF and every transaction comes back as clean rows — date, description, money in, money out and the running balance — with the closing figure checked before you download. Export to Excel, CSV, or an import file for Xero, QuickBooks or Zoho.
Nationwide is a building society rather than a bank, but its FlexAccount, FlexDirect and FlexPlus statements have the same problem as any PDF: you can't sum a column, and the transaction details wrap in a way that a straight copy-paste can't untangle.
What a Nationwide statement looks like
A Nationwide current-account statement uses these columns:
Column | What's in it |
|---|---|
Date | The day the transaction was applied |
Transaction details | The payee, plus how it was paid |
Money out | Debits |
Money in | Credits |
Balance | Running balance after the transaction |
The Transaction details column carries the type of payment — a Visa debit card purchase, a Direct Debit, a standing order, a Faster Payment or a transfer between your own Nationwide accounts. That detail often runs onto a second line for a long payee name, and a rough export reads the overflow as its own row, leaving you two halves to stitch back together. The converter joins them into one clean transaction.
Because Nationwide members often hold several products — a current account, a savings account and a credit card — a single PDF can cover more than one. Each keeps its own opening and closing balance so nothing is merged by mistake.
Where to download your Nationwide statement
- Internet Bank: log in at nationwide.co.uk, select the account, open Statements, choose the period and download the PDF.
- Nationwide app: tap the account, go to Statements, pick a month and save the PDF.
A statement downloaded this way is a digital PDF with selectable text, so the conversion is exact. If all you have is a scan or a photo of a posted statement, the converter reads it with OCR — that just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or QuickBooks — an import-ready bank file so the lines arrive as statement entries to reconcile.
- Tally, Zoho and others — the same data in each one's format.
Before you download, the maths is checked: opening balance, plus money in, minus money out, has to land on the closing balance. On a statement running to several pages, that check is what catches a single line dropped between them.
Common snags with Nationwide statements
- Wrapped transaction details. Long payee lines get rejoined to the right transaction.
- Several accounts in one PDF. Each keeps its own opening and closing balance.
- FlexPlus and packaged accounts. The monthly account fee shows as its own line, kept separate from your spending.
Frequently asked questions
Can I convert a Nationwide statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
Where do I download my Nationwide statement?keyboard_arrow_down
In the Internet Bank or the Nationwide app: choose the account, open Statements, pick the period and download the PDF. That digital PDF converts cleaner than a scan.
My PDF covers a current account and a savings account — will they stay separate?keyboard_arrow_down
Yes. Each account keeps its own opening and closing balance, so the two aren't merged into a single running total.
Does it keep the payment type, like Direct Debit or card payment?keyboard_arrow_down
Yes. Nationwide names how each payment was made inside the transaction details, and the converter keeps that description intact — so you can filter Direct Debits, card spending or transfers once it's in a spreadsheet.
Will it read a scanned Nationwide statement?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from the Internet Bank will convert faster and cleaner than a scan.
