Convert a NatWest statement
Turn a digital NatWest statement into an import-ready spreadsheet in seconds, checked against its own balances before you rely on it. The file stays on your device from drop to download.
ukbankconv is independent software and is not affiliated with, endorsed by, or connected to National Westminster Bank Plc.
Certified for this layout
natwest-personal-classic · parser v1.0.0 · certified 16 July 2026
- Digital personal current-account statements from NatWest online banking
- Balances printed only on the last transaction of each day
- Year-less dates resolved against the printed statement period, including across a year boundary
- Overdrawn balances printed with a trailing D
- Brought forward and carried forward rows
Refused, with a reason
These cases produce an unsupported message, never guessed rows.
- Scanned or photographed statements
- Password-protected PDFs
- Business and RBS layouts (not yet certified)
Current certification results
- Exact row recall
- 100.00%
- Amount accuracy
- 100.00%
- Date accuracy
- 100.00%
- False verified
- 0 of 36
Measured through the full pipeline on a synthetic corpus replicating the NatWest digital layout, including corrupted fixtures that must never verify. Methodology and all numbers on the accuracy page.
What the export contains
The statement’s columns (Date, Description, Withdrawn, Paid In, Balance) become Date, Description, Money out, Money in, Amount, and Balance. CSV exports offer generic accounting, Xero, and FreeAgent presets with UK or ISO dates; Excel exports use real currency and date cells with a frozen header, filters, and an optional Conversion checks sheet recording exactly which checks passed.
Checks performed: every printed running balance transition, opening plus credits minus debits against the closing balance, declared statement totals where printed, and per-row direction consistency.
Known failure modes
- Day-end-only balances
- Because NatWest prints one balance per day, the reconciliation engine accumulates every intermediate amount and checks the day-end figure. A lost or wrong row inside the day still breaks the check.
- January dates on a December statement
- Dates without a year are resolved against the statement period, so a statement spanning December to January assigns each row to the correct year or flags it if it cannot.
NatWest questions
Verified on this page always means the deterministic checks passed on your statement, in your browser. It is never a marketing badge.