UK
Upload a NatWest statement PDF and you get every transaction back as clean rows — date, type, description, paid out, paid in and the running balance — with the closing figure checked before you download. Export to Excel, CSV, or an import file for Xero, QuickBooks or Zoho.
The catch with a NatWest statement is the extra Type column. It's genuinely useful once it's in a spreadsheet, but it's the first thing a plain copy-paste mangles.
What a NatWest statement looks like
NatWest prints a current-account statement across these columns:
Column | What's in it |
|---|---|
Date | The day the entry was applied (shown once per day) |
Type | A short code for how the money moved |
Description | The payee or reference |
Paid out | Debits |
Paid in | Credits |
Balance | Running balance after the transaction |
That Type column is the NatWest quirk. It sits between the date and the description, and it carries the codes NatWest uses for each kind of payment:
- BAC — a Bacs payment (often salary or a supplier)
- DD — Direct Debit
- SO — Standing Order
- C/L — an automated credit or debit
- POS — a card payment (point of sale)
- ATM — a cash withdrawal
- TFR — a transfer between accounts
Because the code lives in its own narrow column, a rough PDF export tends to shove it into the description or drop it entirely. The converter keeps the type beside the transaction it belongs to, so you can filter every Direct Debit or card payment in one click later.
Where to download your NatWest statement
- Online Banking: log in at natwest.com, select the account, open Statements, choose the period and download the PDF.
- NatWest app: tap the account, go to Statements, pick a month and save the PDF.
A statement downloaded this way is a digital PDF with sharp, selectable text, so the conversion is exact. If all you have is a scan or a photo of a paper statement, the converter reads it with OCR — that just takes a bit longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, with the type on its own column ready to filter.
- Xero or QuickBooks — an import-ready bank file so the lines arrive as statement entries to reconcile.
- Tally, Zoho and others — the same data in each one's format.
The maths is checked before you download: opening balance, plus paid in, minus paid out, has to equal the closing balance. On a NatWest statement where the date only prints once a day, that check catches any row that slipped to the wrong date or page.
Common snags with NatWest statements
- The Type column vanishes. The most common issue — the converter keeps BAC, DD, SO and the rest attached to the right line.
- Dates shown once per day. Every transaction still gets its correct date rather than a blank.
- Royal Bank of Scotland looks the same. NatWest and RBS are both part of NatWest Group and share this layout, so the same conversion works for RBS statements.
Frequently asked questions
Can I convert a NatWest statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
What do the type codes like BAC and DD mean on my NatWest statement?keyboard_arrow_down
They describe how the money moved: BAC is a Bacs payment, DD a Direct Debit, SO a Standing Order, POS a card payment, ATM a cash withdrawal and TFR a transfer. The converter keeps the type beside each transaction.
Does it work for Royal Bank of Scotland statements too?keyboard_arrow_down
Yes. NatWest and RBS are part of the same group and use the same statement layout, so the same conversion handles both.
Will it read a scanned NatWest statement?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from Online Banking will convert faster and cleaner than a scan.
My statement covers a savings and a current account — will they stay separate?keyboard_arrow_down
Yes. If a single PDF holds more than one NatWest account, each keeps its own opening and closing balance, so the two aren't merged into one running total by mistake.
