Free converter
Convert NatWest bank statements to CSV or Excel
Upload a NatWest PDF or CSV and download it as CSV, Excel, QIF, OFX or JSON, with every merchant identified.
Choose a statement file (PDF, OFX/QFX, CSV, XLSX, TXT — up to 5 MB)
CSV
spreadsheets & imports
Excel
XLSX workbook
QIF
Quicken, YNAB, GnuCash
OFX
accounting packages
JSON
developers & scripts
Getting your statement out of NatWest
NatWest keeps up to 7 years of PDF statements behind the 'Statements & transactions' menu in Online Banking, and publishes an official list of the type codes it prints on statement lines. The app shows recent statements, but the full archive lives in the browser version.
Download a PDF statement in NatWest Online Banking
- Log in at onlinebanking.natwest.com.
- Select 'Statements & transactions' from the main menu.
- Choose the account, then use the time period dropdown to pick the year.
- Select the statement cycle you want — it downloads as a PDF you can save or print.
NatWest notes the PDF statement can be used as proof of identity, address or income.
View statements in the NatWest app
- Open the NatWest app and select the account.
- Open the statements option for that account.
- Pick the statement you need and download the PDF.
The app surfaces recent statements; go to Online Banking in a browser for the full multi-year archive.
Download transactions for a spreadsheet
- In Online Banking, select the account and view its transactions.
- Use the search to set a date range (searches run in limited windows, so repeat for longer periods).
- Use the download option and choose your file format.
Menu wording shifts between app versions; the destinations above stay stable — confirm against NatWest's official help. Statements up to 5 MB / 5,000 rows are supported; card numbers are redacted before storage, the original file is deleted within 24 hours, and reports stay in your dashboard only as long as your plan keeps them.
What NatWest gives you natively
Issued statements are PDF. The separate transaction download supports spreadsheet and accounting formats — accounting guides consistently report CSV, Excel, OFX and QIF options. Date-range searches are limited to short windows (guides report around three months per search), so long exports are done in chunks. The PDF archive and the transaction download are independent: the PDF is the official document, the export is raw data.
How far back you can go
NatWest states you can download recent or historic statements going back up to 7 years in Online Banking. If you need a copy statement beyond what is online, NatWest has a dedicated 'Request a copy of your bank statement' support process. Transaction downloads cover a much shorter searchable window than the 7-year PDF archive.
NatWest statement quirks worth knowing
These are the details that trip people up when a NatWest export doesn't line up with the statement it came from — worth reading before you assume the conversion is wrong.
- NatWest prints a type code on each statement line and publishes the official key: D/D (Direct Debit), S/O (Standing Order), POS (debit card point of sale), BAC (automated credit), BGC (bank giro credit), TFR (transfer), CHP (CHAPS), C/L (Cashline ATM), OTR (online banking transaction), DPC (direct banking by PC), INT (interest).
- Some codes have changed over time — for example NatWest notes charges previously displayed as 'CHG' — so older statements use different labels than current ones.
- The slash style (D/D, S/O, C/R) differs from the unslashed codes (DD, SO) used by Lloyds-group and HSBC statements, which matters for descriptor matching.
- Transaction search for exports runs in limited date windows, so a 12-month CSV means several passes stitched together.
Sources
Written from NatWest's own documentation. Menu wording moves between app versions — these are the pages to check against:
- www.natwest.com/support-centre/view-or-change-your-details/view-statements/how-do-i-access-my-bank-statements-online.html
- www.natwest.com/support-centre/view-or-change-your-details/view-statements/do-you-have-a-list-of-statement-abbreviations.html
- www.natwest.com/support-centre/view-or-change-your-details/view-statements/how-can-i-get-a-copy-of-my-statement.html
- www.natwest.com/support-centre/view-or-change-your-details/view-statements/how-do-i-print-my-statement-in-online-banking.html
Free converter
Convert your statement — and understand it too
A free account converts a statement page every day to CSV, Excel, QIF or OFX — with every transaction matched to a real merchant name, not a cryptic descriptor. No card required; files deleted after 24 hours.
No bank logins · card numbers redacted before storage · everything deleted after 24 hours
Frequently asked questions
How do I download a NatWest statement as a PDF?
Log in at onlinebanking.natwest.com, select 'Statements & transactions', choose the account and year, then click the statement cycle you want — it downloads as a PDF.
Can I export NatWest transactions to Excel?
Yes — use the transaction download in Online Banking rather than the statements area. Set a date range and pick a format; CSV, Excel, OFX and QIF are reported by accounting guides. Long ranges need multiple searches.
How far back do NatWest statements go online?
Up to 7 years in Online Banking, per NatWest's support centre.
What do D/D, S/O and POS mean on a NatWest statement?
They are NatWest's official line-type codes: D/D is Direct Debit, S/O is Standing Order, and POS is a point-of-sale debit card transaction. NatWest publishes the full list in its support centre.
Go deeper on NatWest
We wrote a full walk-through of getting statements out of NatWest — where each format hides, how far the history reaches, and what to do when the export and the statement disagree: How to export bank statements from NatWest →