Nationwide · United Kingdom

Nationwide Statement to Excel, CSV & Xero

Nationwide lets customers view and download current-account, savings and credit card statements from the last 36 months, and offers a midata download for current-account transactions. This guide explains when to use those downloads and when to convert Nationwide PDF statements for bookkeeping.

Last updated 29 October 2026

At a glance

Official statement format
PDF statements in the app and internet bank
Statements available online
Current account, savings and credit card statements from the last 36 months
Closed current accounts
Historical statements for final 5 years can be accessed online if registered within 6 months of closure
Transaction export
midata download for current-account transactions over a 12-month period, excluding recent 31 days
Converts to
Excel (.xlsx), CSV, JSON, Xero CSV, QuickBooks 3- and 4-column CSV

Nationwide statements vs midata downloads

Nationwide offers more than one way to get account data:

PDF statementmidata download
What it isThe statement document for an accountA transaction data file for current-account comparison services
Publicly stated historyLast 36 months online for current, savings and credit card statements12-month current-account transaction period, excluding the most recent 31 days
Best forBookkeeping source records, statements, audits and mortgage requestsComparing current accounts or analysing recent transactions
Spreadsheet-ready?No, it is a PDFYes, but not a statement layout

For accountants and bookkeepers, the official PDF statement is usually the source record. The midata file can be useful, but it has limits.

How to download Nationwide statements

Nationwide says customers can view and download current-account, savings and credit card statements from the last 36 months in the app or internet bank.

In the internet bank, Nationwide says statements are under Documents. For current accounts, past statements can be found under Documents › Statements, then filtered by account.

If a client closed a current account, Nationwide says online access to historical statements can cover the final 5 years if the account was closed on or after 2 February 2018 and registration is completed within 6 months of closure.

How Nationwide midata works

Nationwide's midata page says the service downloads current-account transactions for a 12-month period. It does not include data from the 31 days before the download.

That matters for bookkeeping:

  • midata may not include the most recent month
  • it covers current accounts only
  • it is a transaction file, not an official statement
  • it may not align with monthly statement periods

If midata covers exactly what you need, use it. Otherwise, convert the PDF statements.

Converting a Nationwide PDF statement

Use PDF conversion when the client sends monthly statements or when midata does not cover the right period.

Workflow:

  1. Download the Nationwide PDF statements for the period.
  2. Upload the PDFs to AI Bank Statement.
  3. Choose Excel, CSV, JSON, Xero CSV or QuickBooks CSV.
  4. Use OCR mode for scanned statements.
  5. Compare totals and sample rows against the original PDF.

A good Nationwide conversion should preserve the transaction date, description, money in, money out and running balance where shown.

Nationwide to Xero, QuickBooks or FreeAgent

If the destination is accounting software, use the accounting-specific output rather than a generic spreadsheet:

  • Xero CSV for Xero manual bank statement import.
  • QuickBooks CSV for QuickBooks Online imports.
  • CSV for FreeAgent or other tools, after checking their expected layout.

This is useful when a bank feed is missing a period or when a client sends old PDF statements for catch-up bookkeeping.

Nationwide statement checklist

Before importing the converted file:

  • check the statement period
  • confirm no pages are missing
  • check UK date order
  • check debit and credit signs
  • keep the original PDFs with the client file
  • avoid overlapping imported data with a bank feed
  • use the PDF rather than midata when the official statement matters

Choose your output format

Frequently asked questions

How far back can I download Nationwide statements?

Nationwide says current-account, savings and credit card statements from the last 36 months can be viewed and downloaded in the app or internet bank. For closed current accounts, historical statements for the final 5 years may be available online if you register within 6 months of account closure.

Does Nationwide offer a CSV download?

Nationwide supports midata for current accounts. It downloads current-account transactions for a 12-month period, excluding the 31 days before the download. It is useful for comparison services, but it is not the same as an official statement PDF.

Can I convert a Nationwide PDF statement to Excel?

Yes. Upload the Nationwide PDF statement, choose Excel, and download a spreadsheet with one transaction per row.

Can I import Nationwide statements into Xero or QuickBooks?

Yes. Choose Xero CSV or QuickBooks 3- or 4-column CSV, then import the file into the matching Nationwide account.

Do scanned Nationwide statements work?

Yes. Use OCR mode for scanned or image-based PDF statements, then check the converted totals against the original statement.

Is the midata file enough for bookkeeping?

Sometimes. If it covers the exact period and imports cleanly, use it. If you need statement periods, balances, older months or source records, use the PDF statements and convert them.

More bank guides

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing