Nationwide Bank Statement to Excel: UK Guide

TL;DR To get a Nationwide statement into Excel, start from the PDF statement for each period, convert it so every transaction is one row with a single signed amount, and confirm that the opening balance plus all transactions equals the closing balance. Keep UK dates in day/month/year format so Excel doesn't swap days and months, combine any separate "paid in" and "paid out" columns into one amount, and treat transfers between your own Nationwide accounts as transfers rather than income or spending. Keep the original PDFs alongside the workbook. Once the balance check passes, your data is ready for a budget, Self Assessment, a mortgage application, or an import into Xero, QuickBooks or FreeAgent.

Nationwide is the UK's largest building society, and millions of people use its current accounts and savings accounts as their everyday banking. Getting the statements into a spreadsheet is a common job: you might be catching up on a year of sole trader records before the Self Assessment deadline, preparing for a mortgage application, helping a relative with their finances, or simply trying to see where the money goes each month.

This guide covers what a Nationwide statement usually contains, which file to start with, how to convert a PDF into clean rows, how to fix the UK-specific formatting issues that cause most errors, a worked example, and the problems people commonly hit. Nationwide updates its Internet Bank and app from time to time, so we describe the options in general terms rather than giving exact click paths.

What a Nationwide statement contains

Whatever the exact layout, a statement for a Nationwide current account or savings account generally shows:

• Account details: the account name, sort code and account number (often partly masked on downloads).
• The statement period: a start date and an end date.
• A balance brought forward and a balance carried forward, or equivalent opening and closing balance figures.
• The transactions: each with a date, a description, an amount in either a "paid in" or "paid out" style column, and usually a running balance.

UK statements tend to split money in and money out into two columns rather than using a single signed amount. That's easy for a person to read but awkward for formulas, so one of the first jobs in Excel is to combine them.

Descriptions on UK statements often include short transaction codes or labels that tell you how the payment was made, for example a card payment, a direct debit, a standing order, a Faster Payment or a bank transfer. The exact wording varies between banks and between statement formats. These labels are useful for categorising, so keep them rather than stripping them out.

PDF statement or downloaded transactions?

Depending on the account and the current version of Internet Bank, Nationwide may let you download PDF statements, and you may also be able to download recent transactions in a spreadsheet-friendly format. Check what your account offers. The two kinds of file are good for different things.

PDF statements are the formal record. They carry the period dates and the balances, and they're what lenders, letting agents, solicitors, the courts and UK Visas and Immigration generally mean when they ask for "bank statements".

Downloaded transaction lists open easily in Excel because each transaction is already on its own row. However, they may cover a date range rather than a statement period, may not include opening and closing balances in the same way, and may not go back as far as you need.

A sensible approach:

• For bookkeeping and analysis, use whichever is easiest to convert, but reconcile each month against the balance figures on the PDF.
• For anything you have to prove to someone else, send the PDF statements and keep your spreadsheet as your own working copy or a summary.

If all you have are PDFs, maybe paper statements you've scanned or older periods that are no longer available as downloads, you'll need to convert them. If you need statements from years ago, our guide to getting old bank statements explains the usual routes.

Converting a Nationwide PDF into rows

There are three practical options.

Copy and paste. Select the transaction table in a PDF viewer and paste it into Excel. On a single page this sometimes works. More often you'll get merged columns, descriptions split over two rows, and "paid in" and "paid out" amounts landing in the wrong columns. It's slow for anything more than a page or two.

Power Query. Excel for Windows with Microsoft 365 can import tables from a PDF through Get Data. Whether it works well depends on how the PDF is built. Our Power Query bank statement guide explains the process and the clean-up it usually needs.

A converter built for bank statements. SheetStatement reads the PDF, outputs one row per transaction with a single signed amount, and checks the opening and closing balances so you know nothing is missing. Export to Excel or CSV. The free plan includes 3 pages a month, enough to try it on a real statement; Starter ($9), Pro ($19) and Business ($39) monthly plans cover larger volumes. Scanned paper statements are harder for any tool; see our guide to converting scanned bank statements for what to expect.

Aim for a layout like this:

The Type column holds the payment method label if your statement shows one. The Source file column, such as nationwide-2026-04.pdf, lets you trace any row back to the original.

Step 1: combine paid in and paid out

If your converted data has two money columns, add a single Amount column with money in as positive and money out as negative. With paid out in column C and paid in in column D:

=N(D2)-N(C2)

N() treats blank cells as zero, so rows with only one value still calculate correctly. If your columns contain text such as "£" signs or commas, clean them first (Step 3). Our guide to separating debit and credit columns in Excel covers this and the reverse direction in more detail.

Step 2: check the balance

Now prove that the data is complete. For each statement:

=ROUND(Opening + SUM(Amount) - Closing, 2)

The answer should be exactly zero. If it isn't:

• The difference equals one transaction. A row is missing, usually at a page break or a "balance carried forward" line.
• The difference is double a transaction. A sign is wrong; an amount landed in the paid in column when it should have been paid out, or the reverse.
• The difference matches a "balance brought forward" figure. A balance line has been treated as a transaction. Delete it from the transaction rows.

That last one is particularly common with UK statements, because the brought-forward and carried-forward lines look a lot like transactions. They have a balance but are not money moving.

If you have a running balance column, check row by row. With balances in column E and amounts in column D, starting at row 3:

=ROUND(E2 + D3 - E3, 2)

The first non-zero result shows where things go wrong. For more methods, see our guide to finding bank reconciliation discrepancies.

Step 3: fix UK dates and amounts

This step solves the majority of "Excel is doing something strange" problems with UK statements.

Dates. Nationwide statements use UK day/month/year dates. If your Excel or Windows region is set to US, a date like 04/05/2026 (4 May) may be read as 5 April, and a date like 25/05/2026 may not be recognised at all and stay as text. You'll often notice because some dates sort correctly and others sit at the bottom of the list.

Test with =ISNUMBER(A2). If FALSE, the date is text. For text in the form DD/MM/YYYY:

=DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2))

Some statements show dates as 04 May 2026 or 04 May with the year only in the header. For the second case, you'll need to add the year from the statement period; take care with statements that run across a year end, where December and January rows sit together. Our guide to fixing bank statement dates in Excel covers these formats, plus the Text to Columns method with a DMY setting.

Amounts. Remove the pound sign and thousands separators if they came through as text:

=VALUE(SUBSTITUTE(SUBSTITUTE(C2,"£",""),",",""))

If an amount is shown with "CR" or "DR" after it, or in brackets, convert it to a signed number before checking balances. Our guide to converting parentheses to negative numbers covers several patterns.

Step 4: tag transfers and categorise

If you have more than one Nationwide account, perhaps a current account and a savings account, money moving between them is neither income nor spending. Add a Category column and tag those rows as Transfer. The same applies to paying off your own credit card from your current account if you also track the card separately.

Then categorise the rest. For a month or two, typing categories by hand is fine. For a year of sole trader transactions, set up a keyword table on a separate sheet and use a formula to match descriptions to categories. Our guide to Excel formulas for categorising transactions shows a robust pattern.

UK payment type labels help here. Direct debits are usually regular bills; standing orders are often rent or transfers to family; card payments are mostly day-to-day spending. Our guide to finding recurring payments in a bank statement shows how to pull out subscriptions and regular bills.

A worked example

You need April's transactions from a Nationwide current account for your budget. The statement shows:

• Balance brought forward: £1,320.40
• Balance carried forward: £1,104.12

After conversion and combining columns:

Check: the amounts sum to 2,150.00 − 950.00 − 142.00 − 64.38 − 96.00 − 500.00 − 18.00 − 71.90 − 24.00 − 500.00 = −216.28. £1,320.40 − £216.28 = £1,104.12, which matches the carried-forward balance. Complete.

Notice the date 12/04/2026. In a spreadsheet with US settings, that could be read as 4 December. If you sort by date and the savings transfer jumps to the end of the year, that's the cause. Fix the dates before you do anything that depends on them, such as monthly totals.

With transfers excluded, April's income was £2,150.00 and spending was £1,866.28 (including the credit card payment). If you track your credit card separately, you'd tag the card payment as a transfer too, to avoid counting those purchases twice. Our guide to creating a budget from bank statements in Excel shows how to turn categorised months into a budget.

Self Assessment, mortgages and other uses

Self Assessment. If you're a sole trader or landlord using a Nationwide account, your statements are part of the records behind your tax return. The UK tax year runs from 6 April to 5 April, so add a Tax year column rather than relying on calendar months. One way, with the date in A2:

=IF(A2>=DATE(YEAR(A2),4,6), YEAR(A2)&"-"&RIGHT(YEAR(A2)+1,2), YEAR(A2)-1&"-"&RIGHT(YEAR(A2),2))

That returns labels like 2026-27. Filter on it to total income and expenses for the right year. What you can claim as an expense depends on your circumstances; this is general information, so check HMRC guidance or ask an accountant. Our guide to separating personal and business transactions helps if you use one account for both.

Mortgages. Lenders commonly ask for recent statements to check income, outgoings and the source of a deposit. Send the PDFs they request. Reviewing your spreadsheet first helps you notice anything they might ask about, such as large transfers in, so you can prepare an explanation. See our guide to bank statements for a mortgage application.

Visas. Some UK visa routes require evidence of funds held over a period. Requirements are specific and change, so follow the official guidance for your route. Our guide to bank statements for a visa application covers general preparation, and our guide to proof of funds bank statements explains how balances are usually read.

Bookkeeping software. To bring older months into Xero, QuickBooks or FreeAgent, export a checked CSV and import it, choosing a cut-over date if a bank feed is already connected. See the Xero CSV import format and importing bank statements into FreeAgent.

Common problems

Brought-forward lines counted as transactions. Remove any balance-only rows from the transaction list; they will throw the balance check off by exactly that balance.

Days and months swapped. Covered in Step 3. Fix dates with an explicit formula rather than reformatting cells, because formatting doesn't change how Excel stored the value.

Amounts in the wrong column. If a copy and paste shifts paid in values under paid out, the balance check will fail by double those amounts. A running balance check finds the first bad row quickly.

Wrapped descriptions. If a row has a description but no date or amount, it's usually the continuation of the line above. Merge it before categorising. Our guide to cleaning bank statement data in Excel shows how.

Overlapping months. If you combine statements and downloads, the same transaction may appear twice. Work in statement periods and see our guide to removing duplicate bank transactions.

A short checklist

• Each statement's brought-forward balance plus transactions equals its carried-forward balance.
• Each carried-forward balance equals the next statement's brought-forward balance.
• All dates are real dates in the right day/month order.
• Paid in and paid out are combined into one signed Amount column.
• Transfers between your own accounts are tagged and excluded from totals.
• Each row has a source file, and the original PDFs are kept.

Convert your Nationwide statements to Excel

Upload a Nationwide statement PDF to SheetStatement, confirm the opening and closing balances, and export to Excel or CSV. The free plan covers 3 pages a month so you can check the result on a real statement before choosing a plan.

FAQ

Can I download a Nationwide statement as Excel or CSV?

Depending on your account, Nationwide may let you download recent transactions in a spreadsheet-friendly format as well as PDF statements. If you only have the PDF, or need a full statement period with balances, convert the PDF so each transaction is a row.

Why are my Nationwide dates wrong in Excel?

UK statements use day/month/year. If Excel uses US settings, days and months swap or the date stays as text. Rebuild the date with the DATE function or import with a UK locale.

How do I combine paid in and paid out into one column?

Use a formula like =N(PaidIn)-N(PaidOut) so money in is positive and money out is negative. N() treats blanks as zero.

Why is my balance check off by a large round amount?

Often a "balance brought forward" or "carried forward" line has been counted as a transaction. Remove balance-only lines from the transaction rows.

Can I use converted statements for a mortgage or visa application?

Lenders and visa authorities generally want official statements, usually PDFs. Use the spreadsheet for your own review and send the documents they ask for.

Is it safe to upload bank statements to a converter?

Check the provider's security and privacy information first. SheetStatement's security page explains how files are handled.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Paid plans are Starter at $9 a month, Pro at $19 and Business at $39.