pdftoexcel

Convert your NatWest statement to Excel

Select Account, Reward, Premier Select, and NatWest credit-card statements. Drop a PDF and get back a verified XLSX, CSV, or QBO in seconds.

How the NatWest conversion works

  1. 1. Drop your National Westminster Bank plc PDF — monthly statement or a combined multi-month export, up to 25 MB. Password-protected PDFs work too.
  2. 2. Parse & reconcile — every transaction is extracted and the sum is checked against ending balance minus beginning balance within $0.01.
  3. 3. Download XLSX, CSV, or QBO — one click each, or batch up to 10 statements and download them as a single ZIP.

What a NatWest statement PDF looks like

Sections in the PDF
Account summary · Statement transactions · Interest details · Charges
Transaction date format
DD MMM YY
Products we've parsed
Select Account, Reward Account, Reward Black, Premier Select, Digital Regular Saver / Instant Saver, NatWest Reward / Platinum credit cards, NatWest Business Account

NatWest current-account statements use a single Statement transactions block with running balance after every row — same clean layout pattern as HSBC UK, which means first-pass LLM accuracy is high. UK-standard DD MMM YY dates; GBP preserved as the currency tag.

Reward and Reward Black accounts include monthly reward payments as transaction rows with 'Reward payment' in Description — summing those across a year gives a ready total for personal-tax self-assessment if applicable.

NatWest Reward and Platinum credit-card statements ship on a cycle schedule with the standard UK credit-card layout (Purchases, Payments received, Interest). These flow through the LLM path and reconcile against the printed new balance per cycle. Business Account statements share the personal layout plus a Fees section — one pipeline handles both.

Supported NatWest statement types

We handle checking, savings, credit-card, and business PDFs from National Westminster Bank plc.

  • checking
  • savings
  • credit-card
  • business

Frequently asked questions

Will Reward Account monthly reward payments show up?
Yes. Reward payments land as their own transaction rows with 'Reward payment' in Description. Filtering to see cumulative rewards is a single spreadsheet operation, and they're kept distinct from other interest credits.
Does it work for NatWest Premier Select?
Yes. Premier Select uses the same single-block Statement transactions layout as every NatWest current account tier — the same pipeline handles Select, Reward, Reward Black, and Premier Select without separate handling.
What about NatWest credit-card PDFs?
Yes. Reward and Platinum cycle-based credit-card statements use the standard UK layout — merchant and category preserved in Description, and reconciliation against the printed new balance gives a Verified / failed signal per cycle.
Can I convert NatWest Business Account statements?
Yes. The business layout adds a Fees section for service charges but otherwise matches personal current accounts, so the same pipeline parses them with equivalent accuracy.

Other banks we convert