Convert NatWest statements to Excel & CSV
Turn National Westminster Bank Plc PDF statements into clean spreadsheets or accounting imports in seconds. The conversion runs on your device, so your NatWest statement is never uploaded.
Drop NatWest bank statement PDFs here
or choose files · multiple files OK · scanned PDFs & photos supported
Select PDF statements- 🔒 Never uploaded
- ∞ Free & unlimited
- ✓ Balance-checked
- Your PDF never leaves your device
- Unlimited pages, no signup
- Works offline
- Every row balance-checked
NatWest statement format at a glance
Date, Description, Paid In, Withdrawn and Balance columns, opening with a brought-forward balance line and showing the date once per day.
| Bank | National Westminster Bank Plc |
|---|---|
| Country | United Kingdom |
| Currency | GBP |
| Typical date format | DD MMM YYYY |
| Statements supported | Current account, Savings, Credit card, Business current account |
| Export to | Excel, CSV, FreeAgent, Xero, QuickBooks, Sage, OFX, QIF, JSON |
How to download your NatWest statement as a PDF
- Log in to NatWest Online Banking or the NatWest app.
- Select the account you want a statement for.
- Open the statements section; online banking usually lists recent statements and lets you reach older ones.
- Choose the period and save the PDF.
Menu names change from time to time. If you can’t find statements, search your online banking help for “e-statements”.
Tips for converting NatWest statements
- Lines such as BROUGHT FORWARD are balances, not transactions. They belong in the opening balance check and should not be imported as a row of money in or out.
- NatWest labels its columns Paid In and Withdrawn rather than Money in/Money out. In an import wizard, Withdrawn maps to debit (spent) and Paid In to credit (received).
- NatWest, Royal Bank of Scotland and Ulster Bank are all NatWest Group brands with closely related statement designs, so the same cleanup routine works across them.
- NatWest business customers can often use FreeAgent as part of their banking. Converting older PDF statements to CSV is a quick way to backfill months the bank feed doesn't cover — just check the boundary dates to avoid duplicates.
Helpful guides
- PDF statement to Excel: every method compared
- Import NatWest transactions into QuickBooks
- Import NatWest statements into Xero
- Reconcile a bank statement in Excel
How the conversion stays accurate
When your NatWest statement prints a running balance, pdf2statement replays every transaction against it and compares opening balance + money in − money out with the closing balance. Rows that don’t reconcile are highlighted before you export, which catches the classic problems of manual copy-paste: missed lines, merged descriptions and flipped signs.
NatWest statement conversion FAQ
Should the BROUGHT FORWARD line appear as a transaction in my spreadsheet?
No. It is the closing balance from your previous statement carried into this one. It is the starting point for the running-balance check, but it isn't money moving in or out, so it shouldn't be imported as a transaction.
Do RBS and Ulster Bank statements convert the same way as NatWest?
Broadly, yes — they are part of the same group and use similar layouts. Each PDF is read on its own, so you can mix them in one batch, but keep one sheet per account so the balances don't get blended.
Is it safe to convert my NatWest statement here?
Yes. Your NatWest PDF is converted inside your own browser and never uploaded, so pdf2statement never receives your account number, balances or transactions. You can confirm this by converting with your internet connection switched off.
Can I convert NatWest credit card statements too?
Yes. Credit card statements are detected automatically. Purchases become money out and payments or refunds money in, and you can export a credit card OFX/QBO for accounting software.
Other banks in United Kingdom
Convert your NatWest statement now
Free, unlimited and private. No signup, no upload, no catch.
Choose PDF statements