Convert NatWest PDF statements to Excel, CSV, Xero or QuickBooks

Getting PDF statements from NatWest

1. 1Log in to NatWest Online Banking and choose Statements & transactions in the main menu.
2. 2Pick the account and the statement, and download it as a PDF.

Older than 7 years

Statements older than 7 years aren’t in Online Banking; your client has to ask NatWest for them, and NatWest charges £3 for historic statements more than 10 years old. Paper copies can be scanned and converted, but check scanned rows against the page image.

Converting a NatWest statement

1. 1Upload the PDF statements, up to 10 at a time and up to 50 pages each. If a file is password-protected you’ll be asked for the password; it’s used once and never stored.
2. 2Review each statement next to its transactions. The opening balance, every transaction and the closing balance have to add up; if they don’t, the rows to check are flagged.
3. 3Choose Export, then the Xero statement CSV, a QuickBooks CSV layout, Excel or OFX for Sage and FreeAgent. For OFX, enter the sort code and account number printed on the statement.

Before you rely on it

There’s no NatWest template behind this: the converter reads each statement’s layout, so it isn’t limited to layouts someone has set up in advance. That also means a NatWest statement hasn’t necessarily been tested, and results vary by layout. Convert one statement with the free pages and check that it balances before you convert a client’s whole history.

Every row links to the line of the PDF it came from, and the opening balance plus the transactions has to reach the printed closing balance. When it doesn’t, the rows to check are flagged before you export.

Client data

Files and results are deleted 24 hours after upload, or straight away if you delete them. Before uploading client statements, read the privacy notice: it names every company that processes statement data and where.