NatWest · personal and business
Convert your NatWest statement PDF to CSV or Excel
Download your NatWest statement as a PDF, choose it below, and get a CSV with every balance checked. Read in your browser, never uploaded.
Tested Checked on real NatWest statements.
or drop it here
Read in this browser. Your file is never uploaded.
Rows wrong or missing?
Send us the shape of this statement, not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Date | Description | Paid in | Paid out | Balance |
|---|
| Check | Result | What we found |
|---|
Statements
| Period | File | Opening | Closing | Rows | Used as |
|---|
| Date | Description | Paid in | Paid out | Balance | From |
|---|
Works with text PDFs that have Date, Description, Paid in / Paid out (or Amount) and Balance columns. Scanned or photographed statements are not supported yet. The samples are fictional test data.
NatWest statements have been tested with real statements, and convert with every balance checked. NatWest prints a running balance on each line, which makes its statements well suited to a row-by-row check: if a single transaction were misread, the converter would point to it immediately.
How to download your NatWest statement as a PDF
- Log in to NatWest online banking and choose the account.
- Open Statements (it may sit under an account options or documents menu).
- Pick the statement period and download the PDF. Repeat for each month you need.
- In the NatWest app, statements can usually be found from the account screen under Statements, where the PDF can be saved or shared.
If a statement isn’t available to download, NatWest can usually provide copies of older statements on request.
Menu names change from time to time and can differ between the app and the website. If you can’t find statements, search for “statements” in the app or online banking help.
What a NatWest statement looks like
NatWest statements usually list Date, Description, Paid In, Withdrawn and Balance, with “Brought forward” at the top of each page. The converter reads “Withdrawn” as money out and skips the brought-forward lines, which aren’t transactions.
Which export to choose
Personal customers usually want the CSV for Excel. If you keep a NatWest business account in Xero or QuickBooks, choose that layout so the money in and out become a single signed amount column.
Common issues with NatWest statements
- “Withdrawn” instead of “Paid out”. The converter recognises NatWest’s column heading and puts those amounts in the Paid out column of the CSV.
- Brought forward lines. Each page starts with a brought-forward balance. It is used to check the page joins correctly, then left out of the transactions.
- Long references. Faster Payments often carry a reference on a second line. It is joined onto the description so you can still search for it.
Support status: tested
We have converted real NatWest statements and checked every row against their printed balances. Banks change their statement designs from time to time, so each conversion is still checked: if a future NatWest layout doesn’t read correctly, the balance check will show it, and the “Help us support this layout” button lets you send us an anonymised report.
StatementToCSV is independent and not affiliated with or endorsed by NatWest. The name is used only to describe the statements the converter reads.
Questions people ask
Does StatementToCSV work with NatWest statements?
Yes. NatWest is one of the three layouts tested on real statements. Each conversion is still checked against the statement’s own balances.
Do RBS statements work the same way?
RBS is part of NatWest Group, and its statements are likely to look similar. We haven’t tested a real RBS statement yet, so RBS is listed as beta. See our RBS page.
Can I convert a NatWest credit card statement?
Credit card statements are laid out differently from current accounts and haven’t been tested. Try one; the check will show whether it read correctly.