Convert NatWest bank statement to Excel
Upload the statement PDF and download an Excel file with one transaction per row: date, description and amount in separate columns (and the balance, when the statement shows it).
Secure
Your bank statements aren't shared with anyone and are encrypted in transit. Password-protected PDFs open in your browser. How we handle your files
Built for firms
For accountants and bookkeepers who reconcile accounts every month: one transaction per row and the same columns every time.
Accurate
We keep improving how each bank converts. If a file doesn't convert the way you expected, email us at support@extractpro.app and we'll fix it.
How do you convert your NatWest bank statement to Excel?
ExtractPro reads a NatWest bank statement downloaded from Online Banking and returns an .xlsx workbook whose rows are the transactions, with date, description and amount apart in separate columns and the balance included when the statement shows it. NatWest says “You can access your statements as a downloaded PDF file by selecting 'Statements & transactions' from the main menu, where you can download recent or historic statements going back up to 7 years for the account you choose.” NatWest is at natwest.com.
How to download your NatWest statement from Statements & transactions in Online Banking
- Log into Online Banking.
- Select Statements & transactions from the main menu.
- Choose the account.
- Download a recent or historic statement, going back up to 7 years.
“You can access your statements as a downloaded PDF file by selecting 'Statements & transactions' from the main menu, where you can download recent or historic statements going back up to 7 years for the account you choose.”
Step-by-step guide: How to download a NatWest bank statement
How it works
3 steps, in seconds
Download the statement
Get the statement for the period from NatWest; if it comes as a PDF, that is the file to upload.
Upload it to ExtractPro
If the PDF is password-protected, enter the password and the file unlocks in your browser. The password never reaches our servers.
Download the Excel file
One transaction per row, with date, description and amount in separate columns (and the balance, when the statement shows it).
FAQ
About NatWest statements
01Can a NatWest PDF statement be turned into an Excel file?
Can a NatWest PDF statement be turned into an Excel file?
Yes. Download the NatWest statement as a PDF file from Online Banking and upload it unchanged; ExtractPro returns a workbook with every transaction on its own row and amounts as numbers.
02How much statement history does the NatWest app show at a time?
How much statement history does the NatWest app show at a time?
NatWest says “You can search back up to 7 years on your bank statement using the Mobile app. However, you can only see 12 months of statement history for each search.” For a stretch longer than one search shows, the PDF statements in Online Banking are the documents to convert.
03What does NatWest say about midata and about exporting transactions?
What does NatWest say about midata and about exporting transactions?
NatWest says “We no longer offer customers the ability to download midata as it has been superseded by initiatives such as Open Banking, and the required transactional information can be found in the standard exportable Excel or PDF format when choosing to download your transactions.” Its search page adds “You can select the format to export your transactions to, including Excel and PDF.” Those are downloads of transactions; the downloaded bank statement is the document ExtractPro converts.
Your NatWest statement, in Excel
Free during launch. Upload the PDF and download the Excel file.
Convert my statementOther banks in the United Kingdom