The export lives in the Internet Bank, not the app
This is the first thing to get right. Nationwide's transaction download is a feature of the Internet Bank, and the Nationwide app does not have it. On a phone that is not a dead end — open the Internet Bank in your mobile browser rather than in the app, and the option is there.
Download your transactions
- Log in to the Internet Bank (in a browser, on any device).
- Select the current account you want.
- Under Transactions, choose Download transactions.
- From the dropdown, pick a plain CSV file for spreadsheet work, or midata for the standardised comparison file.
The CSV gives you a clean, readable set of columns: transaction date, description, type, amount paid in, amount paid out, and the running balance. That last column is worth having — plenty of bank exports drop it.
The 31-day gap, and other limits
The midata file covers twelve months, but it deliberately excludes the 31 days immediately before you download it, as a fraud-prevention measure. So the most recent month is simply absent. If you need right up to yesterday, take the CSV or the PDF statement for the recent weeks and midata for the rest.
Eligibility is narrow too: midata is offered on current accounts only. On savings accounts and some older product types you may find no spreadsheet option at all, just the PDF statement — and if the file range matters, note that the export is capped at a single tax year (6 April to 5 April).
Keep the midata file in its original format if you plan to upload it somewhere: editing it in a spreadsheet and re-saving can be enough to get it rejected.
The same standard turns up at Santander UK and Lloyds, each with slightly different limits.
Once the months are in one file, the running balance column makes the pattern easy to follow: the same amount leaving on the same day each month, for something that stopped being useful a while ago.