Skip to content
stmtai

Convert NatWest statement PDFs to Excel, Xero and CSV.
Xero, QuickBooks Online, FreeAgent files from the PDF.

NatWest and RBS statement PDFs are not password-protected. From the transactions screen you can search by date and then 'Export', with OFX offered for Money, Quicken and Sage, and CSV for Excel.

Drop your NatWest statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in GBP.

Last updated

How to download a NatWest statement as a PDF

  1. Log in to NatWest (or Royal Bank of Scotland) Online Banking and select 'Statements' from the top menu. Business customers see it as 'Statements & transactions'.
  2. Choose the account, then the statement you want from the list. NatWest holds up to seven years online.
  3. Click 'View' to open it, then the download or save icon to keep the PDF.
  4. In the app: tap the account, then 'Statements', pick the month and tap the share icon to save the PDF.

Then drop the file above; several months of NatWest statements at once come back as one workbook.

Is the NatWest PDF password-protected?

NatWest and RBS statement PDFs are not password-protected. The same applies to Ulster Bank statements produced on the NatWest Group platform.

What NatWest statements look like

Date, Type, Description, Paid in, Withdrawn, Balance. Multi-line descriptions are common.

NatWest statements are set out as Date, Type, Description, Paid in, Withdrawn, Balance, in that order, which trips up people who expect money out to come first. The Type column carries abbreviations such as D/D, S/O, BAC, OTR, POS, C/L, CHG and INT, and descriptions frequently run over two or three lines with the reference on the second line. Dates print as day and month in capitals, 12 JUN, with the year taken from the statement heading. Personal statements arrive on A4 with roughly 30 to 40 transactions a page; RBS uses the same template with its own branding. The number of transactions is printed in the summary, which gives a useful row count to check against.

Why not use NatWest's own export?

From the transactions screen you can search by date and then 'Export', with OFX offered for Money, Quicken and Sage, and CSV for Excel. There is no PDF-to-CSV of the statement itself; the export is the transaction search result, so it lacks the printed opening and closing balances and the descriptions are often cut shorter than on the statement. Credit card transactions can only be viewed and exported for the last three months. When the numbers have to agree with a statement, or you need the full reference on a Faster Payment, converting the statement PDF is the better option.

Where NatWest statements trip up converters

  • Multi-line descriptions are merged into one row; the row count is checked against the printed number of transactions.

Which software NatWest customers import into

NatWest customers most often import into Xero, QuickBooks Online, FreeAgent, Excel.

NatWest questions

What do NatWest abbreviations like D/D, BAC, OTR and POS stand for?

D/D is a direct debit, S/O a standing order, BAC a BACS credit or debit, OTR an online or telephone transfer, POS a debit card purchase, C/L a cash withdrawal, CHG a bank charge and INT interest. stmtai keeps the code from the Type column at the front of the description so you can filter on it later.

Why are Paid in and Withdrawn the wrong way round compared with my other banks?

They are not wrong, just NatWest's order. Columns are read by their headings rather than their position, so credits land in Money in and debits in Money out regardless of which the bank prints first. The output has the same column order for every bank, which makes it easier to stack several accounts into one workbook.

My NatWest descriptions wrap onto several lines. Do I lose the second line?

No. Continuation lines are joined into a single description with a space between them, so a Faster Payment shows the payee and the reference together. The finished row count is checked against the transaction total printed on the statement so a wrapped line is never counted as an extra transaction.

How do I convert a NatWest statement PDF to Excel?

Download it from NatWest using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many NatWest statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in United Kingdom

All banks and formats · See a sample result