Financial Documents

Nationwide Bank Statement to Excel: CSV, midata or PDF

Nationwide's CSV covers a tax year, midata 12 months, PDFs 36 months. Where each route stops, and how to turn Nationwide PDF statements into Excel.

Published
Updated
Reading time
13 min
Topics:Financial DocumentsBank StatementsUKNationwidePDF conversionmidataLandlordsMTD ITSA

Nationwide's internet bank shows the last 15 months of current account transactions, and its Download transactions menu gives you two files: a CSV covering up to one tax year (6 April to 5 April) per download, available in the internet bank but not the app, and a midata file of 12 months that ends 31 days before the day you download it. PDF statements go back 36 months, in the internet bank and the app. Anything older is posted to you on request. So getting a Nationwide bank statement to Excel depends on the period you need: inside the CSV's reach, export it; outside it, convert the PDF statements into a spreadsheet, one row per transaction.

RouteHow far backWhereWhat you get
Transactions on screen15 monthsInternet bankA view, not a file
CSV (Download transactions)One tax year per downloadInternet bank onlyNationwide's own columns as a spreadsheet file
midata (Download transactions)12 months, ending 31 days before downloadDesktop browser or Android; iPhone and iPad view onlyA file of current account transactions
PDF statements36 monthsInternet bank and appMonthly statements
Posted copiesOlder than 36 monthsChat, phone or branchPaper statements
Closed accounts (closed on or after 2 February 2018)5 years before closureOnline, if registered within 6 monthsPDF statements

The CSV handles the current tax year, and the last one only until about July, when its first months pass the 15-month mark. A landlord's three-year file, a closed account, and the PDFs clients email over all come from the statements. The accounts are Nationwide's personal current accounts, the FlexAccount among them, which reach an accountant because the landlords, sole traders and partners who hold them report what passes through them on their Self Assessment returns.

Downloading a CSV or midata file from the internet bank

Both files come from the same menu, and both need the internet bank in a browser rather than the app.

The CSV.

  1. Log in to Nationwide's internet bank and open the current account.
  2. Go to Transactions and choose Download transactions.
  3. Choose Download CSV file and set the date range.

The range can span at most one tax year, 6 April to 5 April, so a file covering two tax years means two downloads. Nationwide's help pages don't set out the CSV or these limits; they come from accountants who use the export regularly, who also report that the app has no CSV option. The file holds date, description, transaction type, paid in, paid out and the running balance, which is close to what a bookkeeper wants already. Because the on-screen transactions view stops at 15 months, a period older than that has to come from the statements instead.

midata. Nationwide documents this one itself. Under Transactions, choose Download transactions, then Download midata. According to Nationwide's midata help page, the file holds all your current account transactions for a 12-month period, but excludes the 31 days before the date you download it. It works for current accounts only. On a desktop browser and on Android you can download it; on an iPhone or iPad you can only view it.

Downloaded on 15 November, it ends in mid-October, so it suits a quick look back over a year's income and outgoings. It cannot give you rows up to last week, and since its 12 months roll with the download date, it only matches a tax year if you download it around 6 May.

How to get Nationwide PDF statements, including those older than 36 months

In the internet bank, go to Documents, then Statements, and choose the account. You can download up to 36 months of past statements as PDF files, one per statement period. The Nationwide app holds the same 36 months, so a client without a laptop can still save them and send them on. Nationwide's statements help page gives both figures: 15 months of transactions to view, 36 months of statements to view and download.

For a statement older than 36 months, ask Nationwide for a posted copy, through the internet bank's chat, by phone on 03457 30 20 11, or in a branch. It takes about 10 working days to arrive. A posted copy is paper, so scan it before it goes anywhere near a spreadsheet.

The 36-month window is shorter than the period HMRC expects records to be kept. For a landlord's or sole trader's Self Assessment, records must be kept for at least 5 years after the 31 January submission deadline for the tax year they relate to, which for 2025/26 means until at least 31 January 2032. The internet bank will have dropped those statements long before then. Download the year's PDFs each spring and keep them in the client's file, rather than relying on Nationwide to have them when an enquiry arrives.

Closed Nationwide accounts: five years of statements, if registered within six months

A former customer has 6 months from closure to register for online access to their statements. For a current account closed on or after 2 February 2018, Nationwide's historical statements page says that registering gives online statements going back 5 years from the date of closure. They become available within 10 working days of the account closing.

Miss the six months, or have an account closed before February 2018, and the route is paper. Nationwide posts copies within 7 days of the request, warns that five years of them can be a large bundle, and points to its Tariff of Charges for any cost. At TSB, a closed account usually means paper: statements sit in its Digital Inbox as PDFs while the account is open, and once it closes, a customer with no other open TSB account gets the history by post if they ask within five years, so getting TSB's Inbox PDFs and posted closed-account history into Excel starts with a scanner.

The five years and the 2018 date are not Nationwide's own choices. Part 5 of the CMA's Retail Banking Market Investigation Order 2017 requires banks and building societies to send a Payment Transaction History to any personal current account customer who closes their account. It has not always happened. According to the CMA's 2023 letter on Nationwide's closed-account transaction histories, Nationwide failed to provide an estimated 51,185 of them to former current account holders between 2 February 2018 and 17 May 2023. Nationwide fixed the issue and committed to tell recent leavers about their access to five years of history.

The history is the customer's by right, but it may not turn up without anyone asking for it. When a client switches away from Nationwide, have them register and download the five years of PDFs inside the six months, before the year-end work that needs them comes round. Not every bank works this way. A closed Monzo account gets one password-protected PDF of its whole history by email, with no registration window, and turning that single closed-account Monzo PDF into Excel starts with taking the password off.

Which route for which job

JobRoute
The current tax year, or the last one while it is still inside 15 monthsThe CSV, one download per tax year
A 12-month review that doesn't need the last few weeksmidata
Three tax years for a landlord's file, or any period past the CSV's reachThe PDF statements
An account the client has closedThe five years of PDFs, registered for within six months
PDFs a client has already emailedConvert them as they are; don't ask for a login

The jobs often overlap. A January file for the last tax year typically has its later months as a CSV and its earlier months from PDFs. That works in one sheet as long as both halves have the same shape, so settle these before joining them:

  • Column order. Pick one and map both sources to it.
  • Dates. One format, DD/MM/YYYY, stored as dates rather than text, so the sheet sorts and filters by period.
  • Amounts. Either paid in and paid out as two columns, as Nationwide's CSV gives them, or a single signed amount with money out negative. Choose one; mixing them breaks every total.
  • Origin. Add a column for the source (CSV, or the statement period of the PDF) so any row can be traced back.

Where the CSV and a PDF cover the same dates, keep one source for those dates and drop the other's rows. Duplicated rows at the seam will otherwise throw out every balance after it.

Next to some other UK banks, Nationwide's export is generous. The guide to Lloyds bank statement export and conversion describes a CSV limited to 12 months and 150 transactions per download, while a single Nationwide download covers a whole tax year. At the other end, converting Halifax bank statements to Excel is mostly a matter of working from the PDF statement.


Converting Nationwide PDF statements to Excel in one batch

Whatever the pile is (36 monthly statements, five years from a closed account, or a client's folder of PDFs with a few scanned posted copies mixed in), it goes in as one task. With Invoice Data Extraction you can upload the PDFs exactly as you downloaded or received them and convert a batch of Nationwide PDF statements to Excel: a task takes up to 6,000 files, several tasks can run at once, and scanned statements are read as well as the downloaded ones. FlexAccount statements and those for Nationwide's other current accounts go through the same way.

Then say what the spreadsheet should look like. The quickest start is the ready-made bank statement prompt, which asks for one row per transaction. For year-end work, it pays to write your own in plain words, along these lines:

One row per transaction: date as DD/MM/YYYY, description, paid in, paid out, balance. Add the statement period and the statement's closing balance to every row. Add a Category column.

If the sheet has to match a layout that another system imports, use a Structured Prompt instead: you name each column header in the order you need, with an instruction for each, and the spreadsheet comes back in that shape.

The download is Excel, CSV or JSON. In Excel, amounts come through as numbers and dates as dates, so totals and pivot tables work without reformatting. Every row carries the file and page it came from, and a value the panel of AI agents cannot agree on is flagged as Review Needed, with what to check, so you know which rows to compare against the statement first.

Nationwide's own CSV gives Nationwide's columns for one tax year per download. The extraction gives the columns your prompt asks for, across every period the PDFs cover, with the statement period on each row, so three years land in one sheet already marked by month.

Worked example: a landlord's three tax years of Nationwide PDFs

A landlord lets two flats. Rent comes into a Nationwide current account, and the mortgage payments, the letting agent's fees, insurance and repair bills go out of it, alongside some of the landlord's own spending. In April 2026 their accountant needs three tax years, 6 April 2023 to 5 April 2026: the latest for this year's return, the two before it to correct earlier ones. The CSV would cover the latest year but not the others, so for one consistent set the accountant downloads the monthly PDF statements covering those dates, requests posted copies of any that have passed the 36-month mark, and uploads them all as one task with this prompt:

One row per transaction. Date as DD/MM/YYYY, description, paid in, paid out, balance. Add the statement period to every row, and a Tax Year column (6 April to 5 April) based on the transaction date. Add a Category column: Rent received, Repairs, Letting agent fees, Insurance, Mortgage payment, Personal or Other.

Nationwide's monthly statements don't break on 5 April: the statement that straddles it holds rows from both years, and the Tax Year column puts each one in the right year without anyone splitting the statement by hand.

An invented example of the rows that come back:

DateDescriptionPaid inPaid outBalanceStatement periodTax yearCategory
02/04/2024HARBOUR LETTINGS RENT FLAT 1925.003,412.1818/03/2024 to 17/04/20242023/24Rent received
08/04/2024HARBOUR LETTINGS FEES111.003,301.1818/03/2024 to 17/04/20242024/25Letting agent fees
12/04/2024MORTGAGE PAYMENT FLAT 1486.222,814.9618/03/2024 to 17/04/20242024/25Mortgage payment
15/04/2024A J PLUMBING240.002,574.9618/03/2024 to 17/04/20242024/25Repairs

Two categories need care. Mortgage payments stay in a category of their own. Under Section 24, a residential landlord gets a 20% basic-rate tax credit on mortgage interest rather than deducting it from rental income, so it is reported apart from repairs, agent fees and insurance, which are deducted as allowable expenses. A monthly payment is usually capital and interest together, and the statement shows only the payment, so the interest figure comes from the lender's annual statement; the category keeps the payments together for that reconciliation. Personal spending is marked Personal, not deleted, so the account still balances.

Then check the balances before relying on the totals. For each statement, the opening balance plus paid in minus paid out should equal the closing balance, and each closing balance should equal the next statement's opening balance. A break in that chain is either a missing month or a row that needs checking, and the source file and page on each row take you to the place in the statement to look.

Where costs have to be split between the two flats, the same approach as allocating a landlord's supplier invoices per property for SA105 applies: a Property column, decided per row. And once the landlord is inside Making Tax Digital, which from 6 April 2026 covers landlords and sole traders with qualifying income over £50,000, these categorised rows are the material that Making Tax Digital for Income Tax digital records are built from.


Virgin Money accounts now belong to Nationwide, but keep their own statements

Virgin Money's business transferred to Nationwide on 2 April 2026, but none of the routes above apply to its accounts yet. Virgin Money's transfer questions page says its customers continue to use the Virgin Money apps and virginmoney.com, statements included, so their downloads follow Virgin Money's own menus and limits. That includes business current accounts: Nationwide's business banking today is Virgin Money's, and the Nationwide statements on this page are all personal current accounts. Once a Virgin Money statement is saved as a PDF, though, it converts the same way as a Nationwide one.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours