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
- Drop the PDF in the box on this page, and we show you its first page converted.
- 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.
- 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.
Read next
- Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
- Why a Converted Bank Statement Does Not Balance
Other banks
- Convert ANZ Bank Statements to Excel
- Convert Commonwealth Bank (CommBank) Statements to Excel
- Convert ICICI Bank Statements to Excel
- Convert Metro Bank Statements to Excel
- Convert Monzo Bank Statements to Excel
- Convert HSBC Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
- Convert TSB Bank Statements to Excel
- Convert Virgin Money Bank Statements to Excel
We convert other banks' statements too. See every bank page.