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.

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.

BankPDFtoXLS is an independent service. We are not affiliated with, endorsed by, or sponsored by National Westminster Bank plc. The name "National Westminster Bank plc" is used only to describe compatibility with statements you have legally obtained from your own account. See our trademarks policy.

Drag bank statement PDFs here

or click to browse · PDF · up to 50 MB each · max 25 per batch

From NatWest PDF to verified spreadsheet

1. Drop your National Westminster Bank plc PDF — digital or scanned, monthly statement or a combined multi-month export, up to 50 MB (or batch up to 25 files). Password-protected PDFs and image-only scans both work: scans go through vision OCR automatically.
2. Parse & reconcile — every transaction is extracted and the sum is checked against ending balance minus beginning balance within $0.01.
3. Download XLSX, CSV, or QBO — one click each, or batch up to 10 statements and download them as a single ZIP.

NatWest statement structure and quirks

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

NatWest statement gotchas to watch for

Format-specific quirks that break naive PDF parsers — and how the reconciliation pipeline handles each one.

Reward account £5 monthly reward posts as a separate row

NatWest Reward and Reward Black accounts pay a £5 monthly reward when qualification criteria are met — direct debits, online logins. The reward posts as its own transaction row mid-statement with description 'Reward credit', earlier than the month-end interest. Parsers that aggregate all 'rewards' rows into a single year-end total can miss months where the qualification failed and no reward posted. The parser preserves each reward row distinctly, and the export adds a derived 'qualification met' flag per month based on whether the row exists.

Online vs paper statement format diverges on description column width

NatWest's online PDF statement uses a wider description column than the printed paper statement — the same transaction line wraps differently and may push the amount column off-grid in naive PDF text-extraction. The parser detects which template is in use from the masthead layout marker and applies the correct column-width hints, so multi-year batches that mix online-downloaded and paper-scanned statements all reconcile cleanly.

Bankline business statements use a different format entirely

NatWest Bankline (the corporate banking platform) generates statements in a different format than the consumer NatWest current-account statement — different section names, different date layout, embedded sub-account detail. Parsers tuned for the consumer template fail on Bankline PDFs. The parser detects Bankline by its product code and routes through a separate extraction path, so small-business clients on Bankline see the same Verified-badge experience as personal-account holders.

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.

Engineering notes

Why your bank statement balance doesn't match: 7 specific causes and how to track each one down

When the sum of transactions doesn't equal the printed ending balance, the cause is almost always one of seven specific patterns. A field guide to identifying which one you have, and what to do about each.

11 min read

Engineering notes

Password-protected bank statement PDFs: how to convert them safely without uploading the password to a stranger

Most banks ship encrypted statement PDFs by default. The conversion is easy when you have the password and impossible when you don't, but the part that matters most is what happens to the password during the conversion itself.

9 min read

Workflows that rely on Verified output

Most NatWest statements that come through us are part of one of these workflows. Each link below explains how the reconciliation guarantee maps to that practice.

Forensic accountants

Discovery packets, multi-year tracing

Divorce attorneys

Opposing-counsel financial disclosure

Bookkeepers

Catch-up & bank-feed gaps

Scanned PDFs

Vision OCR + reconciliation

PDF to QBO

QuickBooks-ready OFX export

For QuickBooks workflows

Verified imports, no duplicates