Banks

Convert Nationwide Bank Statements to Excel

Convert Nationwide statement PDFs to Excel and CSV. Nationwide prints a balance once a day, so we work out the rest and check every one we can. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

We turn your Nationwide statement PDF into a spreadsheet with the columns the statement prints. Nationwide leaves most rows without a balance, so we work out each missing balance and check every one we can.

What a Nationwide statement looks like

  • A Nationwide statement has five columns: Date, Description, £ Out, £ In and £ Balance.
  • The date is printed on the first transaction of each day, written like 16 Jun, without the year.
  • The statement opens with a Balance from statement line, dated with the year alone. It comes through as a row of its own, with that year as its date.
  • A description often runs over two lines, such as Contactless Payment above the shop's name. We put those lines in one row, with the amount.
  • Nationwide prints the balance once a day, against the day's last transaction.
  • A card payment in another currency has a line with the amount it was in and the rate, like 20.000000EUR at 1.16000, and a Non-Sterling transaction fee after it. We keep that line in the description, the pounds in £ Out, and the fee as a row of its own.

What your spreadsheet looks like

Where Nationwide printed no balance, we work it out from the rows around it, fill it in, and mark the row filled in the Ledger column.

Date Description £ Out £ In £ Balance Ledger
2023 Balance from statement 5 dated 01/06/2023 500.00 ok
02 Jun Contactless Payment CORNER SHOP LONDON 4.20 495.80 filled
Direct debit ENERGY CO 60.00 435.80 ok
03 Jun Contactless Payment CAFE PARIS 20.000000EUR at 1.16000 17.24 418.56 filled
Non-Sterling transaction fee 0.52 418.04 ok

The rows above are an example, not a real statement.

Where the statement leaves a date blank, your spreadsheet leaves it blank too. Fill in the blanks with three steps in Excel.

How we test it

We test against two Nationwide statements: 127 transactions in all, and the Ledger column flags none of them. Of the 127, 37 balance against a balance Nationwide printed. We fill in the other 90, the rows Nationwide prints no balance for.

Convert a Nationwide statement

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
  3. To convert every page, choose a plan on the pricing page.

To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.

Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.