Download your NatWest bank statement PDF and export all transactions to a clean Excel or CSV file — NatWest and Royal Bank of Scotland both supported, completely free.
Go to natwest.com and sign into Online Banking
Click your current, savings, or credit card account
Click "Statements" in the left-hand navigation
Select the period and click Download PDF — opens without password
NatWest Group: Royal Bank of Scotland (RBS) and Ulster Bank are also part of NatWest Group and use identical statement formats. This converter handles all three without any extra steps.
| Section | What It Contains |
|---|---|
| Account Header | Account name, sort code (XX-XX-XX), masked account number, IBAN (if applicable) |
| Statement Period | From / To dates for this statement |
| Opening Balance | Balance at start of period |
| Transaction Rows | Date | Type | Description | Paid out | Paid in | Balance |
| Transaction Types | FPS (Faster Payment), DD (Direct Debit), SO (Standing Order), BGC (Bank Giro Credit), ATM |
| Closing Balance | Balance at end of period with brought-forward notice |
Here is a real example of how raw PDF bank statement text is transformed into a clean Excel file:
| Raw PDF → Clean Excel | |
|---|---|
| Raw PDF text (messy) | Clean Excel output |
| 15/06/2026 FASTER PAYMENT RECEIVED JOHN SMITH REF JUNE RENT 1,500.00 3,248.50 CR | Date: 2026-06-15 Description: Faster Payment Received — John Smith / June Rent Credit: 1500.00 Balance: 3248.50 |
| 18/06/2026 DIRECT DEBIT VIRGIN MEDIA DR 49.99 3,198.51 | Date: 2026-06-18 Description: Direct Debit — Virgin Media Debit: 49.99 Balance: 3198.51 |
| 22/06/2026 VIS PURCHASE TESCO STORES 4291 DR 67.43 3,131.08 | Date: 2026-06-22 Description: Visa Purchase — Tesco Stores 4291 Debit: 67.43 Balance: 3131.08 |
Dates standardised to YYYY-MM-DD. Currency symbols removed. Debit and Credit in separate columns. Ready for Xero, QuickBooks, HMRC, or Tally import.
Every major UK bank statement format is auto-detected. DD/MM/YYYY dates converted, sort codes preserved in narrations, £ GBP amounts as plain numbers — ready for Xero, Sage, or HMRC submission.
All major high-street bank PDFs supported. Faster Payments and BACS references preserved. Statements going back 7 years all work without any reformatting.
Digital bank PDF and CSV exports both accepted. Monzo statement PDFs and Starling statements auto-detected without manual column mapping.
Building society and challenger bank formats all covered. Nationwide FlexAccount, Halifax Clarity, First Direct 1st Account — all extract cleanly.
🇬🇧 UK use cases: HMRC Self-Assessment expense tracking • Xero & FreeAgent import • Mortgage broker cash-flow submission • UKVI visa bank evidence • Companies House annual accounts
→ Dedicated UK Bank Statement Converter
Whether you are in India or an NRI abroad using an Indian bank account, upload your PDF and get a clean Excel file instantly — HDFC password prompts handled automatically.
Private sector bank PDFs auto-detected. Password-protected HDFC statements unlocked with your DOB (DDMMYYYY). UPI reference IDs and NEFT/IMPS narrations fully extracted.
Public sector formats supported including YONO e-passbook and branch-printed statements. Indian number system (1,23,456.00) converted to standard Excel format.
UPI app statements and Google Pay transaction PDFs fully supported. Debit/credit directions correctly identified from narration text.
🇮🇳 India use cases: ITR filing & income proof • Tally Prime bank reconciliation • GST return verification • CA bookkeeping • Home loan & personal loan applications • Student visa fund proof
→ Dedicated Indian Bank Statement Converter
All major US bank statement PDFs auto-detected. MM/DD/YYYY dates standardised, $ USD amounts as plain numbers, single signed-amount columns split into Debit/Credit automatically.
All major US bank formats including 2024–2025 redesigned layouts. ACH, Zelle, and wire references preserved. Credit card statements also supported.
US neobank PDF and statement exports both handled. No manual column mapping — Date, Description, Debit, Credit, Balance all extracted automatically.
🇺🇸 US use cases: QuickBooks Online bank feed import • Schedule C expense categorisation • Mortgage underwriting cash-flow review • SBA loan 12-month cash flow • CPA bookkeeping