Ledgerbox

NatWest statement converter

Turn a NatWest PDF statement into Excel, CSV or JSON, keeping the 6 columns they print, under their own headings. The file is read in this tab — it is never uploaded, which matters rather more for a GBP bank statement than for a holiday photo.

No statement to hand? Try one:

What a NatWest statement looks like

Their transaction table uses these columns, left to right — and these are the headings you get in your spreadsheet:

  1. 1Date
  2. 2Type
  3. 3Description
  4. 4Paid in
  5. 5Paid out
  6. 6Balance

The part that usually goes wrong

Paid in comes before paid out, the reverse of most UK banks — which is why column order is read off the page, never assumed.

Columns here are found from the gutters between them, not from recognising NatWest or its wording, so this comes through as 6 separate columns rather than as collapsed text. And because nothing is reinterpreted on the way out, a cell that looks wrong in the table is a cell you can see and fix before you download it.

Other United Kingdom banks

Questions

Is my bank statement uploaded anywhere?
No. The PDF is opened by JavaScript running in your own browser tab, and the table is extracted on your device. Nothing is sent to a server, so there is no copy of your statement for anyone — including us — to lose, sell or hand over.
Will the columns match my statement?
Yes, that is the whole point. The header row of your download is the header row of your PDF, word for word, and the columns come out in the order the statement printed them. Nothing is renamed to a house standard, merged, split or reordered.
Does it change the values in any way?
No. A cell arrives as the text that was in it — the same date format, the same thousands separators, the same Dr/Cr markers, the same currency symbols. The one optional exception is clearly labelled: for .xlsx you can have cells that are nothing but a figure typed as numbers rather than text, so Excel will add them up. The digits are unchanged, and you can switch it off.
What happens to a description that wraps onto two lines?
It stays as two rows, because that is what the PDF printed. Every line inside the table becomes one row, with the cells it actually had and the rest left empty. You can merge or delete rows yourself in the table before downloading.
Does it work with password-protected statements?
Yes. Enter the password when prompted; it is used to decrypt the file locally, in the same tab, and is never transmitted or stored.
What formats can I export to?
Excel (.xlsx), CSV, and JSON if you are feeding another tool. Accounting formats like OFX and QIF are not offered, because building one would mean deciding which of your columns is the date and which is a signed amount — exactly the guessing this tool does not do.
My bank is not in the list. Will it still work?
There is no list to be on. Columns are found from the gutters between them — the vertical stripes of the page that no row prints into — so the extractor never needs to recognise the bank, the language or the layout. The bank pages here describe layouts; they do not enable them.
Can it read a scanned statement?
Not yet. A scan is an image with no text layer, which needs OCR. Statements downloaded as PDF from online banking are text and work fine — if you scanned or photographed a printed statement, download the original from your bank instead.

A NatWest layout we read badly? Tell us what went wrong at hello@ledgerbox.example — a description of the columns is enough, please do not send us the statement.