Convert NatWest statements to Excel & CSV

Turn National Westminster Bank Plc PDF statements into clean spreadsheets or accounting imports in seconds. The conversion runs on your device, so your NatWest statement is never uploaded.

Drop NatWest bank statement PDFs here

or choose files · multiple files OK · scanned PDFs & photos supported

Select PDF statements
  • 🔒 Never uploaded
  • ∞ Free & unlimited
  • ✓ Balance-checked
Online·Preparing offline mode…·
  • Your PDF never leaves your device
  • Unlimited pages, no signup
  • Works offline
  • Every row balance-checked

NatWest statement format at a glance

Date, Description, Paid In, Withdrawn and Balance columns, opening with a brought-forward balance line and showing the date once per day.

BankNational Westminster Bank Plc
Country United Kingdom
CurrencyGBP
Typical date formatDD MMM YYYY
Statements supportedCurrent account, Savings, Credit card, Business current account
Export toExcel, CSV, FreeAgent, Xero, QuickBooks, Sage, OFX, QIF, JSON

How to download your NatWest statement as a PDF

  1. Log in to NatWest Online Banking or the NatWest app.
  2. Select the account you want a statement for.
  3. Open the statements section; online banking usually lists recent statements and lets you reach older ones.
  4. Choose the period and save the PDF.

Menu names change from time to time. If you can’t find statements, search your online banking help for “e-statements”.

Tips for converting NatWest statements

  • Lines such as BROUGHT FORWARD are balances, not transactions. They belong in the opening balance check and should not be imported as a row of money in or out.
  • NatWest labels its columns Paid In and Withdrawn rather than Money in/Money out. In an import wizard, Withdrawn maps to debit (spent) and Paid In to credit (received).
  • NatWest, Royal Bank of Scotland and Ulster Bank are all NatWest Group brands with closely related statement designs, so the same cleanup routine works across them.
  • NatWest business customers can often use FreeAgent as part of their banking. Converting older PDF statements to CSV is a quick way to backfill months the bank feed doesn't cover — just check the boundary dates to avoid duplicates.

Helpful guides

How the conversion stays accurate

When your NatWest statement prints a running balance, pdf2statement replays every transaction against it and compares opening balance + money in − money out with the closing balance. Rows that don’t reconcile are highlighted before you export, which catches the classic problems of manual copy-paste: missed lines, merged descriptions and flipped signs.

FAQ

NatWest statement conversion FAQ

Should the BROUGHT FORWARD line appear as a transaction in my spreadsheet?

No. It is the closing balance from your previous statement carried into this one. It is the starting point for the running-balance check, but it isn't money moving in or out, so it shouldn't be imported as a transaction.

Do RBS and Ulster Bank statements convert the same way as NatWest?

Broadly, yes — they are part of the same group and use similar layouts. Each PDF is read on its own, so you can mix them in one batch, but keep one sheet per account so the balances don't get blended.

Is it safe to convert my NatWest statement here?

Yes. Your NatWest PDF is converted inside your own browser and never uploaded, so pdf2statement never receives your account number, balances or transactions. You can confirm this by converting with your internet connection switched off.

Can I convert NatWest credit card statements too?

Yes. Credit card statements are detected automatically. Purchases become money out and payments or refunds money in, and you can export a credit card OFX/QBO for accounting software.

Convert your NatWest statement now

Free, unlimited and private. No signup, no upload, no catch.

Choose PDF statements