NatWest and Santander statements are generally cleaner than HSBC or Barclays — but each bank has its own formatting quirks that can still trip up standard PDF-to-Excel converters. If you are an accountant or bookkeeper processing client statements from either bank, knowing these quirks in advance will save you hours of manual cleanup.
This guide covers both banks in one place, with specific methods for each.
NatWest Bank Statements
What Makes NatWest Statements Tricky
NatWest's format is relatively straightforward compared to HSBC, but watch for these specific issues:
- Date format variations: Current account statements use DD/MM/YYYY, but some credit card statements use MM/DD/YYYY. If your converter does not normalise dates, half your transactions will have incorrect dates.
- Overdrawn balances: NatWest displays overdrawn balances with different formatting — sometimes with a minus sign, sometimes with "DR" notation. Standard converters often misinterpret these.
- Multi-account statements: When current and savings accounts appear on one PDF, the account name appears as a section header that converters may interpret as a transaction row.
How to Convert NatWest Statements
Manual approach: Copy-paste works reasonably well for NatWest. Use Paste Special → Unicode Text in Excel. Check that all dates use the same format. For multi-account statements, manually delete the account name headers.
Online banking: NatWest provides clean CSV exports through their online banking portal. If you have access, this is the simplest free method.
BankScan AI: Automatically detects NatWest format, normalises date formatting, and separates multi-account statements into individual sheets.
Santander Bank Statements
The Version Switcheroo
There are two common Santander statement layouts:
| Version A | Version B |
|---|---|
| Date | Description | Amount | Balance | Date | Description | Balance | Amount |
If your converter assumes column 4 is always the balance, it will be wrong for roughly half the Santander statements you process. The result: balance figures appear in the amount column and vice versa — making the entire spreadsheet unreliable for reconciliation.
How to Convert Santander Statements
Manual approach: Before copying any data, check the column headers on the first page. If "Balance" appears before "Amount", your columns are swapped. Note which version you have and adjust accordingly.
BankScan AI: Automatically detects which Santander statement version you have and adjusts column mapping accordingly. No manual checking required.
Quick Comparison: All Major UK Banks
| Bank | Main Challenge | Manual Time | BankScan AI |
|---|---|---|---|
| HSBC | Multi-line description wrap | 20-40 min | ~8 seconds |
| Barclays | Invisible formatting characters | 10-15 min | ~8 seconds |
| Monzo | 17-column CSV bloat | 5 min | ~8 seconds |
| NatWest | Date format variation | 5-10 min | ~8 seconds |
| Santander | Balance column position shifts | 10 min | ~8 seconds |
| Lloyds | Generally clean | 5 min | ~8 seconds |
| Halifax | Multi-page header repeats | 10 min | ~8 seconds |
Try All 16+ Banks Free
BankScan AI handles HSBC, Barclays, Lloyds, Monzo, NatWest, Santander, Halifax, Nationwide, Chase, Bank of America, Wells Fargo, Citi, and more. No signup, no card.
Try Free →