BankPDFtoXLS turns a NatWest statement PDF into a spreadsheet with the columns the statement prints, and it checks every balance on the way.
What a NatWest statement looks like
- A current NatWest statement has five columns: Date, Description, Paid In (£), Withdrawn (£) and Balance (£).
- An older layout adds a Type column and heads the amounts Paid in and Paid out. Its details run over several lines, and the converter joins them into one cell, separated by commas.
- Each description starts with the kind of transaction, such as CARD TRANSACTION, ONLINE TRANSACTION, AUTOMATED CREDIT, DIRECT DEBIT or STANDING ORDER.
- The date is printed only on the first transaction of each day. Current statements write it like 14 DEC, and most dates leave out the year.
- Every row has its own balance, including the BROUGHT FORWARD line.
What the spreadsheet looks like
| Date | Description | Paid In (£) | Withdrawn (£) | Balance (£) | Ledger |
|---|---|---|---|---|---|
| 02 JAN 2024 | BROUGHT FORWARD | 1,250.00 | ok | ||
| 03 JAN | CARD TRANSACTION COFFEE SHOP | 3.40 | 1,246.60 | ok | |
| AUTOMATED CREDIT EMPLOYER LTD | 2,100.00 | 3,346.60 | ok | ||
| 04 JAN | DIRECT DEBIT COUNCIL TAX | 142.00 | 3,204.60 | ok | |
| ONLINE TRANSACTION RENT VIA MOBILE | 950.00 | 2,254.60 | ok |
The rows above are an example, not a real statement.
A date that the statement leaves blank stays blank in the spreadsheet. Fill them in with three steps in Excel.
How we test it
The converter is tested against five NatWest statements, in both layouts: 404 transactions in all. 403 of them balance against the row before. The Ledger column flags the other one, so you know which row to check.
Convert a NatWest statement
- Upload the PDF on the home page.
- Check page one in the preview. It is free, with no email and no card.
- Create an account to convert every page. The pricing page lists the plans.
The PDF is deleted when its conversion finishes.
Other banks
- Convert HSBC Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert Santander Bank Statements to Excel
The converter reads other banks' statements too. See every supported bank.