PDF2TEXT
Try a statement free

Convert NatWest bank statements to Excel or CSV

NatWest's Online Banking can export transactions to Excel, CSV or OFX for Sage, Quicken and Microsoft Money. Statements are a separate thing: PDFs, available for up to seven years. This page is for bookkeepers and account holders who need those statement periods in a spreadsheet, complete with the balances a reconciliation depends on.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $3 up to 5 pages, $9 up to 25, priced by page count above that. No subscription.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your NatWest statement into Excel

  1. Download the PDF statement from NatWest online banking

    • Log in to NatWest Online Banking.
    • Select 'Statements & transactions' from the menu bar and select the account.
    • Change the year in the dropdown if needed and select the statement; it downloads as a PDF.
    • Save the statement for the period you need as a PDF.
    Go to NatWest Online Banking

  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your NatWest statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · GBP
Sample bank statement rows with made-up data, amounts in GBP
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about NatWest statements

What the export gives you

From 'View transactions', NatWest lists Microsoft Excel, Lotus 123, Text (CSV) and OFX files for Money, Quicken and Sage. Today's transactions aren't included. For statement periods, or when all you have is the PDF, conversion fills the gap.

Abbreviations in the description

NatWest publishes a list of its statement abbreviations: POS for a debit card transaction, D/D for Direct Debit, S/O for standing order, BAC for an automated credit, OTR for an online banking transaction and C/L for a cash machine withdrawal. They stay in the description after conversion, which makes it easy to separate card spending from bills.

DR has two meanings

On these statements, DR can mean the account was overdrawn or that an item is a debit. The converted file doesn't rely on those letters: each transaction has a signed amount. When you review it, check that any balance marked DR reads as a negative figure.

Seven years of statements

Statements download as PDFs for up to seven years, picked a year at a time from a dropdown. If you're pulling several years, upload them in one batch and the run is checked for missing, duplicate and overlapping months before export.

Output and review

From NatWest PDF to your books

Accounting tip

NatWest's own export includes OFX for Sage, and Sage Accounting also accepts CSV and XLS statement files. For statements converted here, the QuickBooks-ready CSV has the three columns Sage reads, Date, Description and Amount, in Sage's order, with dates already written dd/mm/yyyy.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

NatWest statement questions

Does NatWest let me export transactions to CSV?
Yes. Online Banking lists Microsoft Excel, Lotus 123, Text (CSV) and OFX files for Microsoft Money, Quicken and Sage, but today's transactions aren't included. Statements themselves are PDFs, which you can convert here when you need the statement periods.
What does POS mean on a NatWest statement?
The bank's list of abbreviations gives POS as a point of sale or debit card transaction. Other common ones are D/D for Direct Debit, S/O for standing order and TFR for transfer. All of them stay in the description column after conversion, so you can filter by them in Excel.
Can I import converted NatWest rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your NatWest statement to Excel

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $3 up to 5 pages, $9 up to 25, priced by page count above that. No subscription.

More Bank Statement Converters

View all 98 bank pages

United Kingdom

Next steps

pdf2text is independent and not affiliated with or endorsed by NatWest.