Home › Countries › United Kingdom › NatWest › Statement to Excel
NatWest, based in Edinburgh, United Kingdom, delivers account statements as PDFs through its online banking portal. Upload the statement PDF below and download an Excel (.xlsx) workbook — extracted, normalized and reconciled first.
Excel is where most statement clean-up happens, and this export is built for it: the NatWest transactions land in a typed spreadsheet — real dates, real numbers, no text-formatted amounts — with a summary block showing that the figures tie back to the statement itself.
The main use is sharing clean figures with a client, partner or adviser who works in Excel. Statements from United Kingdom banks print dates as day/month/year — 03/04/2026 means 3 April 2026 and amounts with a comma for thousands and a point for decimals (1,234.56) — the converter's locale-aware reader handles that layout, and then the reconciliation check proves the result: the extracted transactions must add up to the balances printed on the statement itself, or the conversion is flagged.
Trust in the output comes from the statement's own arithmetic. NatWest prints balances that its transaction list must sum to; the converter repeats that sum independently on the extracted data. A dropped row, a duplicated row or a misread digit breaks the chain and is flagged at the row where it breaks, with the expected and printed balances shown side by side.
A NatWest statement's layout decides how differences behave. In a chronological layout with a running balance, a single dropped row shifts every later balance, which makes it easy to spot. In a sectioned layout — deposits, then withdrawals, then fees — compare section totals first. Knowing which layout you hold tells you where to look before the marked rows even load.
In United Kingdom, bookkeepers commonly work in Xero, Sage, QuickBooks and FreeAgent; the Excel and CSV exports from this converter are the files those tools import, and the Xero export is laid out for direct import where the tool accepts it.
Ask clients for the issued PDFs rather than portal screenshots or spreadsheet exports. The PDF is the only version that carries the balances the check needs, and a folder of monthly PDFs plus their conversion results is an audit trail that assembles itself.
When several months arrive as separate sheets, resist merging them into one long list until each month has passed its own check. Merged catch-up files hide which month owns a difference; per-statement sheets keep the chain visible, and the combined sheet is there when you need the whole period at once.
These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.
Tip: if the bank offers both a statement PDF and a transaction-list PDF, take the statement — it is the one carrying the balances the reconciliation check needs.
Download the statement PDF from NatWest online banking, upload it to the converter on this page, and download the an Excel (.xlsx) workbook. The transactions are extracted, put into the same standard columns used for every bank, and checked against the statement's balances first.
Expect day/month/year — 03/04/2026 means 3 April 2026 dates and amounts with a comma for thousands and a point for decimals (1,234.56) on a NatWest statement. The reader is locale-aware, so those conventions are handled rather than misread, and the output columns come out in the standard layout regardless.
Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.
No. The converter changes layout, not currency: figures stay in £ exactly as NatWest printed them.
Yes — convert each account's statements separately so each one reconciles against its own balances, then combine the exports in your software if you need a single view.
Scan the statement as flat and straight as you can and upload the scan. OCR reads it, and the reconciliation check verifies the read against the printed balances; rows it cannot verify are flagged for a manual look.
That depends on the bank's portal — most keep at least a year of PDFs online, and older periods can usually be requested. However far back you go, download each period as its own PDF.
The QuickBooks and Xero exports are laid out in the column order those tools import. The plain CSV and Excel exports suit everything else, including spreadsheet review before import.
No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.
Convert the same NatWest statement PDF to CSV instead.
Convert the same NatWest statement PDF to OFX instead.
Convert the same NatWest statement PDF to Xero instead.
Back to the NatWest statement converter hub or the United Kingdom bank directory. Other United Kingdom banks: Barclays statement to Excel · HSBC UK statement to Excel · Lloyds Bank statement to Excel · Santander UK statement to Excel
Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.