Skip to main content
United Kingdom · Processed in your browser · financial data never uploaded

Convert a NatWest bank statement to Excel

Convert a NatWest statement PDF to Excel or CSV in your browser. StatementSift detects date, description, amount and balance columns, then checks row-by-row balance continuity before export. NatWest statements use this layout: Date, Type, Description, Paid out, Paid in and Balance — money out and money in sit in separate columns.

Debit / credit columnsstatement layout
DD MMM YYYYdate format
XLSX / CSVexport paths
NatWest statement reconciliation proof workspace
Drag & drop or click to select filesFiles are processed locally in your browser, never uploaded
Files are processed in your browser — never uploaded

Drop your bank statement PDFs (multiple allowed) and StatementSift detects the date/description/amount/balance columns locally and reconciles row by row. Financial data is never uploaded or sent to any external AI. Text-based PDFs (from online banking) work best.

Columns

Date, Type, Description, Paid out, Paid in and Balance — money out and money in sit in separate columns.

Best source

Sign in to NatWest online banking or the app and download the official PDF from Statements (Download statement). Pick the text-based PDF, not a screenshot or scan.

Review target

Flagged rows, opening and closing balances.

Watch-outs for NatWest statements

01

NatWest separates money out and money in into debit and credit columns. If a row is flagged, first check whether the sign was assigned correctly.

02

Wrapped merchant descriptions can push the next line out of alignment; check long descriptions when the balance proof fails.

03

Opening balance, closing balance and page-break continuation rows are not ordinary transactions, so review the first and last rows on multi-page statements.

How to convert a NatWest statement

  1. 1

    Download your NatWest statement as a text-based PDF from online banking.

  2. 2

    Drop the PDF into the local converter on this page.

  3. 3

    Review detected columns, opening and closing balances, and every flagged row.

  4. 4

    Export to Excel, CSV, or QuickBooks/OFX only after the reconciliation looks right.

Frequently asked questions

No. Reading the PDF, detecting rows, checking balances and building the export all run locally in your browser. Your NatWest statement is not uploaded or sent to an AI service.

Sign in to NatWest online banking or the app and download the official PDF from Statements (Download statement). Pick the text-based PDF, not a screenshot or scan.

Treat the export as a format conversion, not financial, accounting, tax or legal advice. Verify key figures and consult a qualified professional before relying on the output.

Updated · StatementSift team

Related guides