How to export statements from NatWest (PDF, CSV, OFX and QIF)

NatWest splits the job the way most UK banks do: issued statements are PDFs in one place, and a separate transaction download produces spreadsheet files with different coverage. NatWest's particular twist is the date window on that download — long exports come out in chunks — and a statement-line code system all of its own.

The official PDF statement

1. Log in at onlinebanking.natwest.com.
2. Select Statements & transactions from the main menu.
3. Choose the account, then use the time-period dropdown to pick the year.
4. Select the statement cycle — it downloads as a PDF to save or print.

The transaction download (CSV, Excel, OFX, QIF)

The export lives with the transaction search rather than the statement archive, and accounting guides consistently report CSV, Excel, OFX and QIF options — a generous format list. The constraint is the search window: date-range searches run in short windows (around three months per search, per those same guides), so a twelve-month export means several passes stitched together. The PDF archive and the download are independent systems: the PDF is the official document, the export is raw data.

NatWest's statement codes

NatWest prints a type code on each line and publishes the official key: D/D (Direct Debit), S/O (Standing Order), POS (debit card point of sale), BAC (automated credit), BGC (bank giro credit), TFR (transfer), CHP (CHAPS), C/L (Cashline ATM), OTR (online banking transaction), DPC (direct banking by PC), INT (interest).

• The slash style (D/D, S/O) differs from the unslashed codes (DD, SO) that Lloyds-group and HSBC statements use — a real difference if a tool or template matches on codes. The cross-bank set is in our glossary.
• Codes have changed over the years (NatWest notes charges previously displayed as CHG), so older statements label things differently than current ones — worth knowing when assembling a multi-year history.

Getting a clean spreadsheet

For recent months, the export is exact — take the three-month windows and stitch them. For older periods, or when you'd rather not do four searches and a merge, download the PDFs and use the NatWest statement converter: it reads the PDF's own text, understands the slashed type codes, reconciles every line against the statement's printed balances, and outputs CSV, Excel, QIF or OFX in one pass with merchants named.