NatWest statement from PDF to Excel
Drop your NatWest statement PDF and download the transactions in Excel, CSV, QBO (QuickBooks) or OFX. It is converted in your browser: the PDF is not uploaded anywhere.
Tested with real NatWest statements
Tested with three real NatWest statements published by public bodies. In all three, the opening balance plus the transactions gives the closing balance printed by the bank.
How to convert a NatWest statement to Excel
- Download the statement as a PDF from NatWest online banking. It has to be the PDF the bank generates, not a photo or a scan.
- Drop it on the converter. The transactions show on screen in a few seconds.
- Look at the balance check: if the opening balance plus the transactions gives the bank’s closing balance, the whole statement was read.
- Download the file in Excel, CSV, QBO or OFX.
What you get in Excel
One row per transaction with the date, the description, the signed amount and the balance. Dates and amounts are real dates and numbers, not text, so you can sum, filter and sort straight away. For bookkeeping software there is a QBO file for QuickBooks and an OFX file.
What to know about NatWest statements
- The “Paid In” and “Withdrawn” columns become one signed amount, next to the balance.
- The “BROUGHT FORWARD” row is used as the opening balance, not as a transaction.
Your statement stays on your computer
The PDF is read inside your browser. It is not uploaded, it is not stored and nobody else sees it. How that works.
What it costs
Viewing the transactions and checking the balances is free, and you can download 3 statements a month without paying. For more, there is a 7-day pass for £8 and a plan for £16 a month. See pricing.
Other banks
Chase Wells Fargo U.S. Bank TD Bank HSBC Lloyds Bank All tested banks
Private Statement Converter is not affiliated with NatWest. Names and trademarks belong to their owners.
Trying it with your NatWest statement costs nothing.
Convert a statement