NatWest Statement to CSV: Export, Convert and Reconcile

You need NatWest transactions in a spreadsheet, and you need the numbers to be right — every direct debit, every card purchase, every credit landing on the correct side. Perhaps you are assembling a mortgage file, putting a Self Assessment return together, handing a year of trading to a bookkeeper, or reconstructing an account that has since been closed.

Sometimes NatWest will hand you a spreadsheet directly. Often what you actually have is a PDF someone emailed you, and no login that reaches the period in question. This guide covers both routes, the NatWest layout details that defeat generic converters, and how to prove your CSV matches the statement to the penny.

Quick answer

There are two ways to get NatWest transactions into CSV:

1. NatWest's own download. Online Banking lets you view an account's transactions and download them in a spreadsheet-friendly format — NatWest lists Microsoft Excel, Lotus 123 and Text (CSV file) among the options, alongside OFX for Quicken, Microsoft Money and Sage Line 50. This is the cleanest route when you can log in and the period you want is still available.
2. Convert the PDF statement. For statements already saved or emailed as PDFs, older periods, closed accounts, or a statement a client sent you, the transactions exist only inside a PDF. Upload it to a converter such as BankStatementKit, which reads the transactions out and balance-checks the result against the statement's own printed totals.

Rule of thumb: if you can log in and the date range is offered, take NatWest's export. Everything else goes through the PDF.

Turn a NatWest PDF into a verified CSV

Option 1: NatWest's built-in statement download

If you have Online Banking access, start here — the data comes straight from the bank.

1. Log in to Online Banking at onlinebanking.natwest.com.
2. Select Statements & transactions from the main menu.
3. Choose the account you want. NatWest shows recent and historic statements here, with up to seven years available.
4. For a spreadsheet rather than a PDF, open the transactions view for the account and use the download option, choosing Microsoft Excel or Text (CSV file) as the format.

Where the built-in download stops

The export is genuinely useful, and it runs out in predictable ways:

• The download is tied to a live login. For a closed account, an account you no longer operate, or a statement someone emailed you, there is no session to export from.
• History has an edge. Statements are offered for a defined window; anything older than what Online Banking still holds has to come from PDFs you already saved or from a request to the bank.
• The formats are legacy-shaped. Lotus 123 and Microsoft Money tell you how long these options have been in place. The CSV they produce is a raw dump that typically needs header cleanup and column retyping before accounting software will take it.
• Statements themselves are PDFs. The formal statement document — the one a lender or an accountant actually asks for, with the opening and closing balances printed on it — is a PDF, not a spreadsheet.
• Some accounts and card products behave differently. Credit card and business products do not always offer the same download choices as a personal current account.

Every one of those cases ends in the same place: a PDF.

Option 2: Convert the NatWest PDF statement to CSV

1. Find the statement PDF — a download from Online Banking, a saved e-statement, or one someone sent you.
2. Upload it. The file is processed in memory and never stored. If it happens to be password-protected, supply the password at upload.
3. The transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance. Paid In becomes Credit and Paid Out becomes Debit.
4. Check the verification label, then download the CSV.

Uploads are limited to 20MB or 50 pages, which comfortably covers a year of most personal statements. Scanned or photographed statements fall back to OCR automatically. More on the layout itself on the NatWest statement converter page.

Convert a NatWest statement

Why NatWest PDFs trip up generic converters

Two amount columns, no minus signs. NatWest carries direction in the layout: an amount appears under Paid In or under Paid Out, never both, and never as a negative number. A converter that flattens both columns into one field loses the sign on every debit in the file — an error that stays invisible until something downstream refuses to balance. The two columns sit close together on the page, so column detection that works off horizontal position alone can drift by a fraction and assign amounts to the wrong side.

Descriptions wrap, and the Type code sits beside them. Card purchases, faster payments and standing orders bring merchant names, locations, dates of purchase and reference strings, and one entry frequently needs two or three printed lines. A converter reading line-by-line turns a single transaction into several partial rows with no amounts on them. Rows have to be assembled around the date and amount columns, with continuation lines folded back into the transaction they belong to — and the short type code (D/D, S/O, CHQ, POS, ATM, TFR, as set out in NatWest's own statement jargon guide) has to travel with its row rather than being read as a stray fragment of description.

The page furniture looks like data. Statement headers, sort code and account number blocks, the address panel, page footers and any brought-forward and carried-forward lines all sit in the same visual band as transactions. Extraction that does not distinguish them adds rows that were never transactions, and those phantom rows are exactly what breaks a reconciliation later.

Prove the CSV matches the statement

This is the step most people skip, and it is the one that matters. A NatWest statement gives you two independent checks:

1. The running balance chain. Each row prints a Balance. For every row, the previous balance minus Paid Out plus Paid In must equal the printed figure. One dropped or duplicated transaction breaks the chain at exactly the row where it went wrong, which makes the error findable rather than merely detectable.
2. The opening and closing balances. The statement states where the period starts and where it ends. Opening balance plus total Paid In minus total Paid Out must equal the closing balance. If it does, no row went missing in bulk.

Doing both by hand takes 10–15 minutes per statement, more if the period is long. BankStatementKit runs both on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy pointing at the row where the numbers stop reconciling.

FAQ

The bottom line

If you can log in to Online Banking and the period you need is offered, take NatWest's own Excel or CSV download — it is free and native. For saved statements, older periods, closed accounts and PDFs a client sent you, convert the PDF, and insist on a conversion you can prove: the split Paid In / Paid Out columns and the wrapping descriptions are precisely where silent errors hide.