Convert NatWest PDF Statements to CSV

Built for the NatWest Group statement format

NatWest statements use a Paid Out / Paid In two-column layout with a Balance column on the far right. Each transaction is prefixed with a type code — D/D for Direct Debit, S/O for Standing Order, FPI/FPO for Faster Payments, BAC for BACS credits, ATM for cash withdrawals, POS for card purchases. The converter preserves these codes so you can filter by transaction type in Excel or use them to drive Xero bank rules.

RBS Royal Bank of Scotland and Ulster Bank statements use the same template with different branding in the header. Both are detected automatically and produce identical CSV output, which means a single Xero import map works across all three banks — useful if your client portfolio spans the group. NatWest Business and RBS Business statements add a sort-code-and-account-number page header that's stripped, so it doesn't appear as bogus rows in your CSV.

Where this tool earns its keep

NatWest's Bankline (business banking) does export CSV but only for the last few months and only one account at a time. Bookkeepers handling year-end for NatWest Business clients use this converter to backfill 12+ months of history in one upload. The output is identical in structure to a Bankline export, so import rules and bank reconciliation in Xero or Sage carry over without changes.

Mortgage applications regularly demand three to six months of NatWest current account statements as PDFs, but underwriters and brokers want them in spreadsheet form for affordability analysis. Convert the PDFs, drop into the broker's affordability template, and the analysis runs in seconds.

For solicitors, the NatWest converter is part of probate and divorce financial disclosure workflows: you receive a stack of PDF statements, convert them to CSV, and pivot by counterparty to surface unusual flows.

CSV columns and software import

Columns: Date (DD/MM/YYYY), Type, Description, Paid Out, Paid In, Balance. The schema matches NatWest's own Bankline CSV export, so any existing Xero, QuickBooks, or Sage import map keeps working. FreeAgent users can drop the file directly into the Banking → Upload Statement screen with no remapping.

How it works

1. Upload NatWest PDF — Also works for RBS and Ulster Bank
2. Parse Transactions — Dates, descriptions, amounts extracted
3. Download CSV — Import to Xero, QuickBooks, or Sage

Key benefits

• Handles NatWest personal current account format
• Works with NatWest Business Banking statements
• Compatible with RBS and Ulster Bank (same underlying format)
• UK date format preserved (DD/MM/YYYY)
• Multi-page statements consolidated automatically
• Bank-grade security — files purged in 1 hour

Common use cases

• Monthly NatWest business reconciliation
• Sole trader bookkeeping
• Migrating historic statements into Xero

Frequently asked questions

What's the maximum statement period I can convert?

NatWest Online Banking holds up to 7 years of statements. A single uploaded PDF can be up to 100 pages — typically 18+ months of personal current account activity or 4–8 months of a busy NatWest Business account. For older history, run multiple uploads and concatenate the CSVs.

How are credits and debits handled — single column or split?

NatWest's PDF uses a Paid Out / Paid In two-column layout and the CSV preserves both as unsigned positive columns. If you need a single signed Value column (debits negative), use Excel: =Paid_In-Paid_Out. The Type code (DD, FPI, BAC, POS, CPT, TFR) is kept in its own column for filtering.

How do I import the CSV into Xero, Bankline, or FreeAgent?

Xero: Bank Accounts → Import Statement → choose Generic CSV, map Paid Out → Spent and Paid In → Received. FreeAgent: Banking → Upload Statement → the headers auto-detect. The schema also matches NatWest Bankline's own CSV export, so existing Sage and QuickBooks import templates carry over without remapping.

Will this work for Ulster Bank Republic of Ireland statements?

Ulster Bank ROI uses a slightly different template since the divestment to AIB. Ulster Bank Northern Ireland statements (NatWest Group format) are fully supported, as are RBS Royal Bank of Scotland statements.

Can I convert NatWest Reward / Rewards statements with cashback annotations?

Yes. The cashback line items are kept as separate rows tagged 'REWARD' so they reconcile against the headline credit and can be filtered out for income-tax reporting if treated as a discount rather than income.

Related document tools

• Bank Statement to Excel — Extract transaction data from bank statement PDFs into editable Excel spreadsheets.
• Invoice to Excel — Extract invoice data from PDFs into organized Excel spreadsheets for easy tracking.
• Password Protect PDF — Add password protection to your PDF documents for secure sharing.
• Flatten PDF — Flatten PDF forms and annotations for secure, uneditable document submission.
• AI to PDF — Convert Adobe Illustrator (.ai) files to PDF for easy sharing and viewing.
• EPS to PDF — Convert EPS (Encapsulated PostScript) files to universally viewable PDFs.

Browse all DocumePro tools →