Nationwide Statement to Excel Converter

For older periods, or after the registration window has passed, Nationwide sends paper statements on request from a branch or by phone, posted within seven days. Its help page warns that a large request may arrive as a large bundle of paper, and points to the Tariff of Charges to check whether a cost applies.

Paper converts too. Scan each statement flat, one statement per file, and FlowParse reads it through OCR — then proves it against its printed balances, which is what catches a misread digit on a faint page.

The opening balance plus every signed transaction must equal the closing balance on the statement. FlowParse checks that, and checks each row against the running balance where it is printed. A payment in read as a payment out, or a line lost where a page breaks, fails at the row where it happened.

Statements that pass are marked reconciled. Anything else opens in the preview with the difference shown, so you see a problem before a lender or HMRC does.

Nationwide credit card statements work slightly differently. In the internet bank you see the latest account summary and previous summaries for up to 15 months, open a full statement from the statement archive, and use Download transactions to export in a format you choose — the app's My Documents covers credit card statements for 36 months.

A credit card statement converts as purchases, refunds and payments against the previous and new balance. Merged with the current account, the monthly card payment appears on both sides, which is the reconciliation an accountant wants to see.

For a Self Assessment return, a landlord's rental accounts or a sole trader's year end, the UK tax year runs from 6 April to 5 April — rarely matching statement dates. Smart Merge takes up to 100 Nationwide PDFs, puts every transaction in date order with the source file on every row, and lets you filter to the exact tax year after the merge.

Statements from HSBC, Lloyds, NatWest, Santander or Monzo can be merged into the same workbook, column by column, for someone who banks in more than one place.

UK sole traders, landlords and their accountants mostly use Xero, QuickBooks, FreeAgent or Sage. FlowParse exports a CSV with date, description and signed amount for a bank statement import, a QBO file for QuickBooks, and an Excel file for review first.

Because the description is kept whole — the payee name, the Direct Debit originator, the Faster Payments reference — each line can be matched to an invoice or a rent receipt after import.

Money out and money in are unsigned columns; pasted into one list, they all become positive and the total is meaningless. A UK date like 03/04/2025 is the 3rd of April, and an American-default spreadsheet turns it into March 4th. A long payment reference wraps over two lines and becomes two rows.

FlowParse signs each amount by its column, writes unambiguous dates and keeps one transaction per row. The balance proof is what confirms nothing was split, dropped or flipped on the way.

A landlord keeps rental income and costs in a Nationwide current account. The accountant asks for the full tax year so the property income can be reported. The landlord downloads thirteen monthly PDFs from the internet bank to cover 6 April to 5 April. The figures here are an illustration, not a real landlord's.

Uploaded together, the statements become one workbook in date order, each proved against its balances, with no month missing. Filtered to the tax year, the rent receipts sum to the income figure; the letting agent's fees, the repairs and the mortgage payments are listed with their payees. The accountant imports the CSV into their software instead of retyping thirteen statements.

Nationwide's help page names two situations where the usual online routes do not apply. For statements on a closed account needed under a Power of Attorney or a Court of Protection matter, you visit a branch or call; for statements on behalf of someone who has died, you contact Nationwide's Bereavement Specialist Support Team.

Statements obtained that way are often paper or arrive in batches covering several years. Converted and merged, they let an attorney or executor show the account's history in one place — every month proved against its balances, with the regular payments, the pension credits and the large withdrawals easy to filter.

Coverage: each closing balance equal to the next opening balance, so a missing month is visible. Dates: the tax year or the lender's period filtered after the merge, not before. Reconciled: every statement proved before its totals are used.

And keep the PDFs. A lender, a solicitor or HMRC may ask for the statement itself; the converted file is a working copy built from it.

Current account statements, card-based savings statements and credit card statements list transactions between two balances and convert the same way. Statements for closed accounts, downloaded through the historical-statements service, convert like any other.

Mortgage statements are summaries of payments and interest over a year; annual interest summaries and letters are single figures or notices. Keep them for their purpose; convert the statements.