How to Convert a Mettle PDF Bank Statement to CSV or Excel

Mettle is NatWest Group's app-only business account built for sole traders and freelancers. Formal statements come as PDF files, which are difficult to work with if you need structured data for bookkeeping, tax returns, or accounting software imports. Here's how to convert them into clean CSV or Excel — for free, in a few seconds.

By Jack Whitehead 1 March 2026 5 min read

Watercolour illustration of a Mettle bank statement with molten data flowing into spreadsheet cells

The Problem With Mettle PDF Statements

Mettle is a mobile-first bank account. Everything runs through the app — there are no branches, no desktop banking portal with advanced export options. When you need a formal record of your transactions, Mettle provides PDF statements. For many sole traders, that PDF is the only comprehensive document covering a full statement period.

The trouble starts when you try to use that data. Copy-pasting from a Mettle PDF into a spreadsheet produces jumbled columns, broken descriptions, and amounts that end up in the wrong cells. If you're trying to import transactions into Xero, QuickBooks, Sage, or any other accounting platform that doesn't integrate directly with Mettle, you need a proper CSV — and the PDF won't give you one without help.

Quick answer: Use ReconcileIQ's free PDF converter. Select Mettle, upload your PDF, and download clean CSV or Excel output. Your first statement of up to 10 pages converts free on a new account.

How to Convert Your Mettle Statement (4 Steps)

Download the statement from Mettle
Sign in to Mettle online banking and download the PDF statement for each period you need. One PDF per statement period.
Create a free account
Register from the converter page, then open ReconcileIQ and open the PDF converter inside it. There is no bank to pick from a list — the extraction reads whatever layout is in front of it, which is why statements from banks we have never seen convert just as well.
Upload your PDF
Drag and drop or click to browse. The file is uploaded over an encrypted connection and read on our servers, which is what lets scans and photos work as well as native PDFs.
Download your CSV or Excel file
Review the extracted transactions on screen, then download as CSV (for accounting software import) or Excel (for spreadsheet analysis).

Privacy note: Your statement is uploaded over an encrypted connection and read on our servers rather than in the browser. That is a deliberate trade: it is what allows scanned and photographed statements to convert, not just native PDFs.

The ReconcileIQ PDF converter upload area accepting PDF and photo bank statements — **Step 1 in the tool.** The converter accepts native Mettle PDFs, scans and photos of paper statements, up to 12 files at once. The per-transaction cost is stated up front before anything runs.

A completed PDF conversion showing 35 extracted transactions with download and reconcile options — **The result.** A one-month statement converted to 35 clean rows. From here you can download the CSV for your accounting software, or push it straight into a reconciliation without re-uploading.

What the Converter Extracts

The Mettle parser extracts these fields from your PDF statement:

Date — transaction date in a clean, sortable format
Description — payee name, merchant details, or transfer reference
Amount — transaction value (positive for money in, negative for money out)
Balance — running balance after each transaction

Mettle statements typically use a single amount column with positive and negative values rather than separate "money in" and "money out" columns. The converter preserves this format in the CSV, or can split amounts into separate debit and credit columns if needed for your accounting software.

Can I Export Mettle Transactions Directly?

Mettle's app does allow you to view and share transaction data, but the export options are limited compared to traditional banks with full online banking portals. For a formal, complete record of a statement period, the PDF statement is the primary document Mettle provides.

If you're a sole trader filing a Self Assessment tax return or a freelancer preparing quarterly accounts, you likely need structured data covering specific periods. Converting the PDF statement gives you exactly that — clean rows with dates, descriptions, and amounts ready for import.

Mettle and FreeAgent Integration

Mettle has a built-in integration with FreeAgent, which can pull transactions directly via a bank feed. If you already use FreeAgent, this is the most convenient route and you may not need to convert PDFs at all.

However, if you use any other accounting platform — Xero, QuickBooks, Sage, Pandle, or others — there is no direct Mettle integration. In that case, converting your Mettle PDF statement to CSV is the fastest way to get your transactions into your software.

Understanding Mettle Statement Format

Mettle is a business-only account, so the statement format is straightforward compared to banks that have multiple personal and business layouts:

Single account type — Mettle offers one business current account, so the statement layout is consistent
Date and description — each transaction row includes the date and a description of the payment or receipt
Single amount column — credits shown as positive values, debits as negative (rather than separate columns)
Running balance — the balance after each transaction is listed alongside
Transaction references — faster payments, direct debits, and card payments each include relevant reference details

Because Mettle only has one account type, the parser is highly reliable. There are no layout variations between personal, business, or premium tiers to worry about.

What to Do With Your CSV Data

As a sole trader or freelancer, once you have clean CSV data from your Mettle statement, you can:

Import into accounting software — Xero, QuickBooks, Sage, and Pandle all accept CSV bank imports. This is the main route if you don't use FreeAgent
Reconcile in ReconcileIQ — upload alongside your accounting data to automatically match and reconcile transactions
Prepare your Self Assessment — structured transaction data makes it straightforward to categorise income and expenses for your tax return
Code in CodeIQ — if you're a bookkeeper managing clients who use Mettle, CodeIQ can automatically code transactions to the chart of accounts, classify VAT, and post back to your platform
Track cash flow in Excel — pivot tables, monthly summaries, and spending breakdowns for your business
Submit for MTD — Making Tax Digital for Income Tax (MTD ITSA) requires digital record-keeping. Clean CSV data is the first step

Convert Your Mettle Statement Now

Fast, accurate, and checked on screen before you download. Built for sole traders and freelancers. First statement free on a new account.

Convert your PDF now for free

Frequently Asked Questions

Can I export my Mettle transactions as CSV directly?

Mettle's app provides limited export options. For a complete, formal statement covering a full period, the PDF statement is the primary document. You can convert it to CSV for free using the converter at reconcileiq.com/bank-statement-converter — it takes seconds, and your first statement is free on a new account.

Does Mettle integrate with accounting software?

Mettle integrates directly with FreeAgent via a bank feed. If you use any other platform (Xero, QuickBooks, Sage, Pandle), there is no direct integration. Converting your Mettle PDF statement to CSV is the fastest way to import transactions into those tools.

Is the Mettle PDF converter free?

Your first statement of up to 10 pages converts free on a new account. After that it runs on credits, and the cost is shown before anything is processed.

What format are Mettle PDF statements in?

Mettle statements use a consistent business account layout with date, description, amount (positive for credits, negative for debits), and running balance. Since Mettle only offers one account type, the format is predictable and the converter parses it reliably every time.