Banks

Convert NatWest Bank Statements to Excel

Convert NatWest statement PDFs to Excel and CSV. We keep NatWest's own columns and check every balance. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

We turn your NatWest statement PDF into a spreadsheet with the columns the statement prints, and we check every balance on the way.

What a NatWest statement looks like

  • A current NatWest statement has five columns: Date, Description, Paid In (£), Withdrawn (£) and Balance (£).
  • An older layout adds a Type column and heads the amounts Paid in and Paid out. Its details run over several lines, and we join them into one cell, separated by commas.
  • Each description starts with the kind of transaction, such as CARD TRANSACTION, ONLINE TRANSACTION, AUTOMATED CREDIT, DIRECT DEBIT or STANDING ORDER.
  • The date is printed only on the first transaction of each day. Current statements write it like 14 DEC, and most dates leave out the year.
  • Every row has its own balance, including the BROUGHT FORWARD line.

What your spreadsheet looks like

Date Description Paid In (£) Withdrawn (£) Balance (£) Ledger
02 JAN 2024 BROUGHT FORWARD 1,250.00 ok
03 JAN CARD TRANSACTION COFFEE SHOP 3.40 1,246.60 ok
AUTOMATED CREDIT EMPLOYER LTD 2,100.00 3,346.60 ok
04 JAN DIRECT DEBIT COUNCIL TAX 142.00 3,204.60 ok
ONLINE TRANSACTION RENT VIA MOBILE 950.00 2,254.60 ok

The rows above are an example, not a real statement.

Where the statement leaves a date blank, your spreadsheet leaves it blank too. Fill in the blanks with three steps in Excel.

How we test it

We test against five NatWest statements, in both layouts: 392 transactions in all, and the Ledger column flags none of them. Of the 392, 391 balance against the row before. The other one has an amount we cannot read, so we fill it in from the balances around it.

Convert a NatWest statement

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
  3. To convert every page, choose a plan on the pricing page.

To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.

Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.