Convert NatWest Statement to CSV
Turn NatWest statement PDFs into normalized CSV rows so your bookkeeping and reconciliation work starts from structured data. Personal, business, and RBS statements supported.
Sample NatWest CSV output
What's unusual about NatWest statements
- NatWest uses
FPI/FPOfor Faster Payments In/Out,BGCfor bank giro credits, andPOSfor card purchases — preserved intransaction_type. - Two-column layout with the running balance on the right of the page extracts into a dedicated
balancecolumn. - Multi-page statements include "Your transactions continued" headers that are automatically excluded.
- Royal Bank of Scotland statements share the NatWest Group layout and convert using the same parser.
How to download your NatWest statement PDF
- Sign in to NatWest Online Banking or the NatWest app.
- Select the account you want a statement for.
- Open Statements and choose the period.
- Select Download PDF.
- Upload the PDF to StatementCSV and export as CSV or Excel.
Frequently asked questions
How do I download my NatWest statement as a PDF?
Sign in to NatWest Online Banking, select the account, open Statements, choose a period, and select Download PDF. The NatWest app supports this too.
Does StatementCSV handle NatWest transaction codes?
Yes. FPI/FPO for faster payments, BGC for bank giro credits, DD for direct debits, SO for standing orders, and POS for card payments are all preserved in the transaction_type field.
Are NatWest business and RBS statements supported?
Yes. NatWest personal and business statements both convert. RBS statements share the same underlying layout and use the same pipeline.
Do multi-page statements export correctly?
Yes. "Your transactions continued" page headers and repeated column headers across pages are detected and excluded from the output.
Convert statements from other UK banks
Dedicated converters for the most common UK bank statement formats.