How to Convert NatWest Statements to CSV or Excel

Why Convert NatWest Statements?

NatWest (National Westminster Bank) is one of the UK's leading retail banks, part of the NatWest Group alongside Royal Bank of Scotland and Ulster Bank. With millions of personal and business customers across England and Wales, NatWest statements are commonly needed for HMRC tax filings, mortgage applications, and business bookkeeping. NatWest PDF statements feature a consistent tabular layout, but extracting data manually is time-consuming, especially for business accounts with dozens of transactions per page. BankRead handles NatWest's statement format and delivers structured spreadsheet data automatically.

Understanding the NatWest Statement Format

NatWest current account statements use a portrait PDF with transactions in a table showing Date, Description, Type, Money In, Money Out, and Balance. The header displays the sort code, account number, IBAN, and statement period. NatWest credit card statements show an account summary followed by a transaction list with Date, Description, and Amount. Royal Bank of Scotland and Ulster Bank statements share the same layout with different branding. All amounts are in GBP (£).

How to Convert with BankRead

Follow these steps to convert your NatWest PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your NatWest online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your NatWest Statement PDF

1. Log in to NatWest Online Banking at nwolb.com using your customer number, PIN, and password.
2. Click on the account from your accounts overview.
3. Select 'Statements' from the account menu.
4. Choose the statement period from the available list — statements are stored for up to 7 years.
5. Click 'Download' or 'Save' to get the PDF statement.

What Data Gets Extracted

BankRead extracts the following fields from your NatWest statement:

• Transaction date (DD/MM/YYYY)
• Description / payee (e.g., 'CONTACTLESS PAYMENT TO SAINSBURY'S')
• Transaction type (e.g., D/D, S/O, BP, CHQ)
• Money in amount (credits, salary, refunds)
• Money out amount (debits, card payments, direct debits)
• AI-assigned category (e.g., Supermarkets, Utilities, Rent, Entertainment)

Export Options

Once your NatWest statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for NatWest Statements

• NatWest includes a 'Type' column with codes like D/D (direct debit), S/O (standing order), and BP (bill payment) — BankRead preserves these in the output.
• Royal Bank of Scotland and Ulster Bank statements are also supported as they share the same layout.
• NatWest business account statements may include additional reference numbers — these are captured in the description.
• Multi-page statements from active accounts are handled in a single upload.
• NatWest Reward or Select account statements use the same base format as standard current accounts.

Common Issues and Solutions

• NatWest transaction type codes (D/D, S/O, BP, CHQ, VIS) help identify the payment method. BankRead includes these codes in the description alongside the payee name.
• NatWest's 'Interest Charged/Paid' summary at the end of the statement is aggregate data and is not duplicated in the transaction extraction.
• Some NatWest statements include a 'Running Total' column that differs from the actual balance due to pending items. BankRead uses the Balance column for the running balance.

Frequently Asked Questions