United Kingdom · GBP

Convert NatWest Bank Statements to Excel

NatWest statements pair a “Date / Description / Withdrawn / Paid in / Balance” table with description prefixes for payment channels. Older statements hyphenate long references while newer digital PDFs keep them on one line — both variants are handled by the layout detector.

Drop your bank statement here

PDF, JPG or PNG · up to 25 MB

No signup required · Files deleted after processing · How files are handled

Works with statements from 1,000+ banks

How NatWest statements are structured

Withdrawn / Paid in amount columns
Channel prefixes in descriptions (e.g. OnLine Transaction, Card Purchase)
Layout differs between legacy paper-style and current digital PDFs
Balance brought forward line at each page start

Fields extracted

Date
Description with channel prefix retained
Withdrawn → debit, Paid in → credit
Balance excluding brought-forward marker rows

How to download a NatWest statement

1Log in to NatWest online banking.
2Select “Statements” for the relevant account.
3Choose a period and download the PDF statement.
4Upload the file here for Excel, CSV or JSON.

Common NatWest conversion problems

“Balance brought forward” rows get imported as fake transactions by naive tools.

Marker rows are recognized and excluded from the transaction list.

Legacy and current PDFs differ enough to break fixed templates.

The detector selects a parser variant per document rather than assuming one layout.

Example output

A converted NatWest statement lands in these columns:

Date	Description	Debit	Credit	Balance
25 Jan 2026	CARD PURCHASE ASDA SUPERSTORE	£72.14	—	£1,807.90
26 Jan 2026	ONLINE TRANSACTION FROM SAVINGS	—	£500.00	£2,307.90
27 Jan 2026	DD VODAFONE	£35.00	—	£2,272.90

NatWest conversion FAQ

Do Royal Bank of Scotland statements work as well?

Yes — RBS shares the NatWest Group layout family and is detected as its own variant.

Is the brought-forward balance included in exports?

It is used to validate the running balance but excluded from the transaction rows, so your totals stay clean.

StatementConvert is an independent service and is not affiliated with, endorsed by, or sponsored by NatWest Group plc. NatWest trademarks belong to their respective owners.